[ensembl-dev] need SQL help

[Leo Gordon]

Dear Gang,

In addition to the textual description that Bert just sent you can also have a look at a graphical diagram of the Compara database schema.
You will find it under ensembl-compara/docs/schema_diagrams/compara_schema.png (in your API installation)
or in the public CVS:
	http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl-compara/docs/schema_diagrams/compara_schema.png?root=ensembl&view=markup

Hope this helps,

Leo.


On 28 Aug 2012, at 13:55, Bert Overduin wrote:

> Hello Gang,
> 
> Apologies for the delay in replying. Schema descriptions as well as extensive tutorials for the four main Ensembl APIs (core, compara, variation and regulation) you can find here:
> 
> http://www.ensembl.org/info/docs/api/index.html
> 
> Hope this helps.
> 
> Cheers,
> Bert
> 
> On Fri, Aug 3, 2012 at 10:19 AM, 陈岗 <danielchen06 at gmail.com> wrote:
> Hi All
> 
> For some reasons, I cannot use API to extract data of variation,orthologue,paralogue,regulation. I'm trying to apply SQL sentences, but the entity relationships are too sophisticated.
> 
> If you know how to dig out these data from gene id, please tell me. The most important part is their key/foreign key.
> 
> Thanks million
> -- 
> Gang Chen
> TILSI
> Taicang Institute For Life Science Information
> Address: A2/162, Renmin South Road, Taicang, 215400, Jiangsu Province, P.R.China
> Phone:（+86）512-82782588
> 
> 
> _______________________________________________
> 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/
> 
> 
> 
> 
> -- 
> Bert Overduin, Ph.D.
> Vertebrate Genomics Team
> 
> EMBL - European Bioinformatics Institute
> Wellcome Trust Genome Campus
> Hinxton, Cambridge CB10 1SD
> United Kingdom
> 
> http://www.ebi.ac.uk/~bert
> 
> 
> Ensembl browser: http://www.ensembl.org
> Mailing lists: http://www.ensembl.org/info/about/contact/mailing.html
> Blog: http://www.ensembl.info
> YouTube: http://www.youtube.com/user/EnsemblHelpdesk
> Facebook: http://www.facebook.com/Ensembl.org
> Twitter: http://twitter.com/Ensembl 
> 
> 
> 
> 
> _______________________________________________
> 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/