[ensembl-dev] stable_id of mus_musculus_otherfeatures_64_37 mysql dataset

Susan Fairley sf7 at sanger.ac.uk
Fri Sep 30 09:35:09 BST 2011


Hi Xin,

The mouse otherfeatures database is used to store three sets of genes. 
The EST genes, the set of consensus coding sequence (CCDS) genes and an 
import of genes from refseq.

select distinct logic_name from analysis, gene where 
analysis.analysis_id =gene.analysis_id ;
+---------------------+
| logic_name          |
+---------------------+
| estgene             |
| ccds_import         |
| refseq_mouse_import |
+---------------------+
3 rows in set (0.00 sec)

The EST genes have IDs starting ENSMUSESTG.

For the CCDS and refseq imports, the imported IDs are stored in place of 
Ensembl stable IDs. The CCDS identifiers start CCDS, while the refseq 
IDs are numbers.

I hope this helps.

Regards,
Susan.

nixin wrote:
> Hi,
> 
> There are some stable_id that not begin with "ENSMUSESTG" in
> mus_musculus_otherfeatures_64_37 mysql dataset. For instance, gene_id
> "73205", it's stable_id is "100504551". Is there something wrong?
> 
> Thanks
> 
> Xin
> 
> 
> 
> 
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> List admin (including subscribe/unsubscribe): http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/




More information about the Dev mailing list