[ensembl-dev] RefSeq ID and Ensembl gene ID

[Thomas Juettemann]

Dear all,

I need to create a list that is similar to part of the  UCSC RefLink table:

+-----------------+--------------------------+
| Field           | Type                  |
+-----------------+--------------------------+
| name          | varchar(255)       |
| product       | varchar(255)       |
| mrnaAcc     | varchar(255)       |
| protAcc       | varchar(255)       |
| geneName   | int(10) unsigned  |
| prodName    | int(10) unsigned  |
| locusLinkId  | int(10) unsigned  |
| omimId        | int(10) unsigned  |
+------------------+-------------------------+

I only need the refseq IDs, mrnaAcc (e.g. NM_001086914) and protAcc (e.g.
NP_001080383). Ideally I'd like to do it by using the Ensembl Perl API.
So far I am able to get all transcripts, but got stuck in figuring out a way
to map RefSeq onto ENST IDs.

Any suggestions welcome!

Many thanks,
Thomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20110201/393ba72f/attachment.html>