<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Ryan,<br>
<br>
Ontology terms are linked to ensembl translations as external
references.<br>
For a given GO xref, the display_label column in the xref table (in
the core database) will correspond to the accession column in the
term table in the ontology database.<br>
<br>
You can also retrieve this information using the perl API:<br>
<br>
my $go_xrefs = $gene->get_all_DBLinks('GO');<br>
my $ontology_term_adaptor = $registry->get_adaptor( 'Multi',
'Ontology', 'OntologyTerm' );<br>
while (my $go_xref = shift @{$go_xrefs} ) {<br>
my $go_term = $ontology_term_adaptor->fetch_by_accession(
$go_xref->display_id );<br>
print $go_term->accession, " ", $go_term->name, "\n";<br>
}<br>
<br>
<br>
Hope that helps,<br>
Magali<br>
<br>
<div class="moz-cite-prefix">On 17/03/2014 16:17, Ryan Brown wrote:<br>
</div>
<blockquote
cite="mid:CALaxeR1VniXBMZ_STewier_CeuNzfbtfE73GQvZUaPaO_DAcEg@mail.gmail.com"
type="cite">
<div dir="ltr">Ensembl:<br>
<br>
I am interested in getting information related to the Term
table in the ensembl_ontology_75 database. Can you describe how
rows in this table relate to tables and columns in the
ensembl_core_75 database? My goal is to have a query where I can
specify the name field in the ontology term table, perform a set
of inner joins, and then get data from other tables / databases.<br>
<br>
Thanks<br>
Ryan<br clear="all">
<div><br>
-- <br>
<div dir="ltr">
<div><span style="font-family:arial,helvetica,sans-serif"><b><font><span
style="color:rgb(7,55,99)">Ryan M. Brown<br>
XenoGen Biosystems</span></font></b></span><br>
<font size="1">The information contained in this message
(including any files transmitted with this message) may
contain proprietary, trade secret, or other confidential
and/or legally privileged information. Any information
contained in this message (or in any files transmitted
with this message) is confidential and cannot be shared
with any third party without prior written approval.
This message is intended to be read only by the
individual or entity to whom it is addressed or by their
designee. If the reader of this message is not the
intended recipient, you are on notice that any use,
disclosure, copying or distribution of this message, in
any form, is strictly prohibited. If you have received
this message in error, please immediately notify the
sender and destroy all copies of this message in your
possession, custody or control.</font><br>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Dev mailing list <a class="moz-txt-link-abbreviated" href="mailto:Dev@ensembl.org">Dev@ensembl.org</a>
Posting guidelines and subscribe/unsubscribe info: <a class="moz-txt-link-freetext" href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a>
Ensembl Blog: <a class="moz-txt-link-freetext" href="http://www.ensembl.info/">http://www.ensembl.info/</a>
</pre>
</blockquote>
<br>
</body>
</html>