[ensembl-dev] core schema pdf

Andrea Edwards edwardsa at cs.man.ac.uk
Mon Mar 28 13:29:53 BST 2011


Thanks very much

On 28/03/11 09:47, Monika Komorowska wrote:
> Hi Andrea
>
> I attach pdfs of ensembl core schema.
> This page will contain links to the schema from release 62:
> http://www.ensembl.org/info/docs/api/core/core_schema.html
>
> Regards
>
>
>
> Monika
>
>
> On 25 Mar 2011, at 17:00, Andrea Edwards wrote:
>
>> Hi
>>
>> Is there a pdf of the ensembl core schema? I can only find one for the variation schema.
>>
>> If not, can you advise a quick way to find all of the tables linked to a specific table. I can do it in sql  but i was wondering if there was any other way quicker way from ensembl
>>
>> mysql>  select distinct TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME IN ('gene_id') and TABLE_SCHEMA = 'homo_sapiens_core_61_37f';
>> +---------------------------------------+
>> | TABLE_NAME                            |
>> +---------------------------------------+
>> | alt_allele                            |
>> | gene                                  |
>> | gene_attrib                           |
>> | gene_stable_id                        |
>> | splicing_event                        |
>> | transcript                            |
>> | unconventional_transcript_association |
>> +---------------------------------------+
>> 7 rows in set (0.05 sec)
>>
>> thanks
>>
>>
>> _______________________________________________
>> Dev mailing list
>> Dev at ensembl.org
>> http://lists.ensembl.org/mailman/listinfo/dev
> Monika Komorowska
> EnsEMBL Software Developer
>
> European Bioinformatics Institute (EMBL-EBI)
> tel: +44(0) 1233 494 409
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20110328/87f4d0a1/attachment.html>


More information about the Dev mailing list