<div dir="ltr">Is there any chance you could give an example of an annotation attribute keyed on the ensembl_id? I looked around the schema docs before I wrote this e-mail, specifically for the gene product name, and couldn't find it.<div>
<br></div><div>JO</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, May 26, 2014 at 1:19 AM, Manuel Alfonso López Rourich <span dir="ltr"><<a href="mailto:alfonso.lopez@cenits.es" target="_blank">alfonso.lopez@cenits.es</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi, <div><br></div><div>Getting annotations for Ensembl IDs it's easy with a Perl script by using the Ensembl Perl API. Have a look at the database schema to see what information you can get for your different types of data through this link <a href="http://www.ensembl.org/info/docs/api/index.html" target="_blank">http://www.ensembl.org/info/docs/api/index.html</a>.</div>
<div><br></div><div>Regards, </div><div><br></div><div><table border="0" cellpadding="0" width="425" style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse;margin-left:auto;margin-right:auto"><tbody><tr>
<td colspan="2" valign="top"><div style="text-align:center"><span style="font-size:xx-small"><strong> Manuel Alfonso López Rourich</strong></span></div><div style="text-align:center"><span style="font-size:xx-small"> Técnico de Apoyo</span></div>
<div style="text-align:center"><span style="font-size:xx-small"> <a href="mailto:alfonso.lopez@cenits.es" target="_blank">alfonso.lopez@cenits.es</a></span></div></td></tr><tr><td width="500" valign="top"><div>
<span style="font-family:Tahoma"> <img src="http://www.cenits.es/sites/cenits.es/files/galerias/CenitS.thumbnail.jpg" border="0" alt="" width="120" height="80"></span></div><div><p style="margin-top:6px;text-align:center">
<span style="font-size:xx-small"><span style="font-family:Tahoma">C\ Sola, 1 (Conventual San Francisco)<br>10200 Trujillo. Extremadura. Spain<br>Tel. <a href="tel:%2B34%20927%20659%20317" value="+34927659317" target="_blank">+34 927 659 317</a> <br>
Fax: <a href="tel:%2B34%20927%20323%20237" value="+34927323237" target="_blank">+34 927 323 237</a><br>Web: </span><a href="http://www.cenits.es/" target="_blank"><span style="font-family:Tahoma">www.cenits.es</span></a></span></p>
</div></td><td width="250" valign="top"><div><span style="font-family:Tahoma"> <img src="http://www.cenits.es/sites/cenits.es/files/galerias/COMPUTAEX.thumbnail.jpg" border="0" alt="" width="170" height="80"></span></div>
<div><p style="margin-top:6px;text-align:center"><span style="font-size:xx-small"><span style="font-family:Tahoma">Carretera Nacional 521, km 41.8<br>10071 Cáceres. Extremadura. Spain<br>Tel. <a href="tel:%2B34%20927%20659%20317" value="+34927659317" target="_blank">+34 927 659 317</a> <br>
Fax: <a href="tel:%2B34%20927%20323%20237" value="+34927323237" target="_blank">+34 927 323 237</a><br>Web: </span><a href="http://www.computaex.es/" target="_blank"><span style="font-family:Tahoma">www.computaex.es</span></a></span></p>
</div></td></tr></tbody></table><div style="font-family:arial,sans-serif;font-size:13px"><p style="text-align:justify"><font face="Tahoma" size="1" color="#000000">En cumplimiento de la Ley Orgánica 15/1999, de 13 de diciembre, de Protección de Datos de Carácter Personal, conforme art. 5 relativo al derecho de la información en la recogida de datos, se le informa de que los datos de carácter personal de los que disponemos, son incorporados en un fichero automatizado propiedad de la Fundación COMPUTAEX, responsable del tratamiento y destinatario de los datos, con domicilio en Carretera Nacional 521, km 41.8, 10071 Cáceres. Podrá ejercitar los derechos de acceso, rectificación, cancelación y oposición dirigiéndose al responsable del fichero a la dirección indicada. </font></p>
</div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-05-26 4:15 GMT+02:00 Joshua Orvis <span dir="ltr"><<a href="mailto:jorvis@gmail.com" target="_blank">jorvis@gmail.com</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">I have a list of several thousand ENSEMBL IDs, such as ENSMUSG00000039372, and I want to automate a way to get whatever associated annotation attributes from them that I can, such as gene product name, gene symbol, GO terms, etc. From pages like this I see that I can get at least the product name, labeled as "Description":<div>
<br></div><div><a href="http://uswest.ensembl.org/Mus_musculus/Gene/Summary?db=core;g=ENSMUSG00000039372" target="_blank">http://uswest.ensembl.org/Mus_musculus/Gene/Summary?db=core;g=ENSMUSG00000039372</a><br></div><div>
<br></div><div>For this one, it would be "membrane-associated ring finger (C3HC4) 4". </div>
<div><br></div><div>I tried connecting to the MySQL database but couldn't find where this is stored. What is the best way to get this sort of information for a lot of IDs? MySQL, Perl, Python, whatever solution is fine.</div>
<div><br></div><div>Thanks!</div><span><font color="#888888"><div><br>Joshua</div></font></span></div>
<br></div></div>_______________________________________________<br>
Dev mailing list <a href="mailto:Dev@ensembl.org" target="_blank">Dev@ensembl.org</a><br>
Posting guidelines and subscribe/unsubscribe info: <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></div>
<br>_______________________________________________<br>
Dev mailing list <a href="mailto:Dev@ensembl.org">Dev@ensembl.org</a><br>
Posting guidelines and subscribe/unsubscribe info: <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></div>