[ensembl-dev] ID ensembl

[William Spooner]

Hi Kattina,

One way is to use MySQL against the public ensembl database;

$ mysql -hensembldb.ensembl.org -uanonymous homo_sapiens_core_79_38 -e 'select
g.stable_id, count(*) from gene g join transcript t using(gene_id) join
exon_transcript te using(transcript_id) where g.biotype="protein_coding"
group by g.stable_id having count(*) = 1'

Best,

Will


On Mon, Apr 13, 2015 at 4:56 PM, Kattina Zavala <kattinazavala at gmail.com>
wrote:

> Hi Ensembl team,
>
> I want know if is possible to obtain a list with ID ensembl from all genes
> with a one exon (for coding protein gene)...
> Thank you very much in advance,
>
>
> --
> Kattina Zavala
> Bioquímico
> Instituto de Cs. Ambientales y Evolutivas
> Universidad Austral de Chile
> Teléfono: +56 9 82794985
>
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info:
> http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/
>
>


-- 
William Spooner
Chief Science Officer
<http://www.eaglegenomics.com>
M: +44 (0)7779663045 | T: @wspoonr <http://twitter.com/wspoonr> | L:
linkedin <http://uk.linkedin.com/in/williamspooner>

*Eagle Genomics Ltd <http://www.eaglegenomics.com>*Disclaimer
<http://www.eaglegenomics.com/about/privacy-statement/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20150414/a9fd4ec3/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: E_Email_Sig.jpg
Type: image/jpeg
Size: 36746 bytes
Desc: not available
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20150414/a9fd4ec3/attachment.jpg>