[ensembl-dev] stable_id of mus_musculus_otherfeatures_64_37 mysql dataset

[倪鑫]

Hi Susan,

Thanks a lot! Your answer is very helpful.

Best Regards,

Xin


> -----原始邮件-----
> 发件人: "Susan Fairley" <sf7 at sanger.ac.uk>
> 发送时间: 2011年9月30日 星期五
> 收件人: nixin <nixin at fudan.edu.cn>
> 抄送: dev at ensembl.org
> 主题: Re: [ensembl-dev] stable_id of mus_musculus_otherfeatures_64_37 mysql dataset
> 
> 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/
> 
> 
> -- 
>  The Wellcome Trust Sanger Institute is operated by Genome Research 
>  Limited, a charity registered in England with number 1021457 and a 
>  company registered in England with number 2742969, whose registered 
>  office is 215 Euston Road, London, NW1 2BE.