[ensembl-dev] Core-Funcgen schema/keys?

William Michels wjm1 at caa.columbia.edu
Thu Feb 19 16:29:38 GMT 2015


Hello,

I've been searching for a schema that delineates key relationships between
the top-level databases at Ensembl such as Core, FuncGen, etc.
Unfortunately, I have been unable to find a schema graphic, png or
otherwise.

(I understand some Core tables are reflected in FuncGen. I furthermore
understand I can do these queries using Biomart, but I was hoping to
have/use standard MySQL queries as well).

For example, I can't find documentation on the Foreign key relationships
between:

rattus_norvegicus_funcgen_78_5.xref.dbprimary_acc   <-->
 rattus_norvegicus_core_78_5


My guess for a key relationship in 'core'  is:
 rattus_norvegicus_core_78_5.transcript.stable_id


Thus to connect the two top-level databases this leads to a rather
odd-looking WHERE clause:

"WHERE rattus_norvegicus_funcgen_78_5.xref.dbprimary_acc
= rattus_norvegicus_core_78_5.transcript.stable_id"


Maybe this is incredibly obvious, but sometimes *incredibly* obvious things
sometimes turn out to be *incredibly* wrong.  So I thought I'd check with
Ensembl.

Any help appreciated,

Thanks,

Bill

William Michels, Ph.D.
Assistant Research Biochemist, UCSF (former)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20150219/09efd440/attachment.html>


More information about the Dev mailing list