Hello Gang,<div><br></div><div>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:</div><div><br>
</div><div><a href="http://www.ensembl.org/info/docs/api/index.html">http://www.ensembl.org/info/docs/api/index.html</a></div><div><br></div><div>Hope this helps.</div><div><br></div><div>Cheers,</div><div>Bert<br><br><div class="gmail_quote">
On Fri, Aug 3, 2012 at 10:19 AM, 陈岗 <span dir="ltr"><<a href="mailto:danielchen06@gmail.com" target="_blank">danielchen06@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi All<div><br></div><div><div>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.</div>
<div><br></div><div>If you know how to dig out these data from gene id, please tell me. The most important part is their key/foreign key.</div><div><br></div><div>Thanks million</div><span class="HOEnZb"><font color="#888888">-- <br>
<div><font face="verdana, sans-serif" size="1">Gang Chen</font></div>
<div><font face="verdana, sans-serif" size="1">TILSI</font></div><div><font face="verdana, sans-serif" size="1"><span style>Taicang Institute For Life Science Information</span><br style>
<span style>Address: A2/162, Renmin South Road, Taicang, 215400, Jiangsu Province, P.R.China</span><br style><span style>Phone:<a href="tel:%EF%BC%88%2B86%EF%BC%89512-82782588" value="+8651282782588" target="_blank">（+86）512-82782588</a></span></font></div>
<br>
</font></span></div>
<br>_______________________________________________<br>
Dev mailing list <a href="mailto:Dev@ensembl.org">Dev@ensembl.org</a><br>
List admin (including subscribe/unsubscribe): <a href="http://lists.ensembl.org/mailman/listinfo/dev" target="_blank">http://lists.ensembl.org/mailman/listinfo/dev</a><br>
Ensembl Blog: <a href="http://www.ensembl.info/" target="_blank">http://www.ensembl.info/</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Bert Overduin, Ph.D.<br>Vertebrate Genomics Team<br><br>EMBL - European Bioinformatics Institute<br>Wellcome Trust Genome Campus<br>Hinxton, Cambridge CB10 1SD<br>
United Kingdom<br><br><a href="http://www.ebi.ac.uk/~bert" target="_blank">http://www.ebi.ac.uk/~bert</a><div><p style="margin-bottom:0in;margin-bottom:.0001pt"><font face="Arial"></font></p><p style="margin-bottom:0in;margin-bottom:.0001pt">
<font face="Arial">
</font></p><p style="margin-top:.1pt;margin-right:0in;margin-bottom:0in;margin-left:0in;margin-bottom:.0001pt"><font face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:black">Ensembl
browser: <a href="http://www.ensembl.org/" target="_blank"><span style="color:blue">http://www.ensembl.org</span></a></span><span style="font-size:10.0pt;font-family:Arial"></span></font></p><font face="Arial">
<p style="margin-top:.1pt;margin-right:0in;margin-bottom:0in;margin-left:0in;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:Arial;color:black">Mailing
lists: </span><span style="font-size:10.0pt;font-family:Arial;color:blue"><a href="http://www.ensembl.org/info/about/contact/mailing.html" target="_blank"><span style="color:blue">http://www.ensembl.org/info/about/contact/mailing.html</span></a></span><span style="font-size:10.0pt;font-family:Arial;color:black"></span></p>
<p style="margin-top:.1pt;margin-right:0in;margin-bottom:0in;margin-left:0in;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:Arial;color:black">Blog: </span><span style="font-size:10.0pt;font-family:Arial;color:blue"><a href="http://www.ensembl.info/" target="_blank"><span style="color:blue">http://www.ensembl.info</span></a></span><span style="font-size:10.0pt;font-family:Arial;color:black"></span></p>
<p style="margin-top:.1pt;margin-right:0in;margin-bottom:0in;margin-left:0in;margin-bottom:.0001pt"><span style="font-size:10.0pt;font-family:Arial;color:black">YouTube: </span><span style="font-size:10.0pt;font-family:Arial;color:#000099"><a href="http://www.youtube.com/user/EnsemblHelpdesk" target="_blank"><span style="color:blue">http://www.youtube.com/user/EnsemblHelpdesk</span></a></span><span style="font-size:10.0pt;font-family:Arial;color:black"><br>
Facebook: </span><span style="font-size:10.0pt;font-family:Arial;color:blue"><a href="http://www.facebook.com/Ensembl.org" target="_blank"><span style="color:blue">http://www.facebook.com/Ensembl.org</span></a></span><span style="font-size:10.0pt;font-family:Arial;color:black"><br>
Twitter: </span><span style="font-size:10.0pt;font-family:Arial;color:blue"><a href="http://twitter.com/Ensembl" target="_blank"><span style="color:blue">http://twitter.com/Ensembl</span></a> </span><span style="font-size:10.0pt;font-family:Arial;color:black"></span></p>
<p></p>
</font><p></p><font face="Arial">
</font><p></p>
</div><br>
</div>