gene names for ENSEMBL ID

470 views
Skip to first unread message

Bogdan Tanasa

unread,
Aug 20, 2018, 5:52:57 PM8/20/18
to gen...@soe.ucsc.edu
Dear all, please would you remind us how we can find the gene names for a set of ENSEMBL IDs ?

ENSG00000000003.14
ENSG00000000005.5
ENSG00000000419.12
ENSG00000000457.13
ENSG00000000460.16
........

thanks a lot, 

-- bogdan

Luis Nassar

unread,
Aug 21, 2018, 1:03:53 PM8/21/18
to tan...@gmail.com, gen...@soe.ucsc.edu
Hello Bogdan,

Thank you for using the UCSC Genome Browser and your question regarding converting Ensembl IDs to UCSC stable IDs. 

In case this explanation is not sufficient, I'd like to point you towards archived resources that may help further:

How to obtain the Ensembl transcript ID version number?

get genes informations having ensemblID with mysql query

You can accomplish this using the UCSC Table Browser. You can find it here:


For your selections:
- Clade: Mammal
- Genome: Human
- Assembly: GRCh38 (or whichever you wish to use)
- Group: Genes and Gene Predictions
- Track: All Gencode V28
- Make sure 'Genome' is selected
- Identifiers: Hit the 'paste list' or the 'upload list' button and enter your Ensembl IDs
- Skip the next few lines until you get to 'output format' and select 'selected fields from primary...'

At this point you can choose a name in the 'output file' field if you wish to export results, or alternatively, you can leave it black and hit the 'get output' button to see them on your web browser.

- In the next page, check the box under 'Linked Tables', which is wgEncodeGencodeAttrsV28
- Then select the 'allow selection from checked tables' button
- From this new table check the geneID and geneName boxes

Finally hit the 'Get output' button and your results should be as follows:

ENSG00000000460.16 C1orf112
ENSG00000000460.16 C1orf112
ENSG00000000457.13 SCYL3
ENSG00000000457.13 SCYL3
ENSG00000000457.13 SCYL3
ENSG00000000460.16 C1orf112
ENSG00000000460.16 C1orf112
ENSG00000000460.16 C1orf112
ENSG00000000003.14 TSPAN6
ENSG00000000005.5 TNMD
ENSG00000000003.14 TSPAN6
ENSG00000000003.14 TSPAN6
ENSG00000000419.12 DPM1
ENSG00000000419.12 DPM1

(You'll need to do some mild tailoring in this case, you can look into the 'uniq' command on unix if you'll be working on command line)

I hope this is helpful. If you have any further questions, please reply to gen...@soe.ucsc.edu. All messages sent to that address are archived on a publicly-accessible Google Groups forum. If your question includes sensitive data, you may send it instead to genom...@soe.ucsc.edu.

Lou Nassar
UCSC Genomics Institute

Training videos & resources: http://genome.ucsc.edu/training/index.html
Want to share the Browser with colleagues?
Host a workshop: http://bit.ly/ucscTraining

--

---
You received this message because you are subscribed to the Google Groups "UCSC Genome Browser Public Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to genome+un...@soe.ucsc.edu.
To post to this group, send email to gen...@soe.ucsc.edu.
Visit this group at https://groups.google.com/a/soe.ucsc.edu/group/genome/.
To view this discussion on the web visit https://groups.google.com/a/soe.ucsc.edu/d/msgid/genome/CA%2BJEM005wN1p9OYxCiZWNxrXPaFqmd3d%3DQZvqjfrf8sMUUwpqA%40mail.gmail.com.
For more options, visit https://groups.google.com/a/soe.ucsc.edu/d/optout.

Bogdan Tanasa

unread,
Aug 21, 2018, 1:57:12 PM8/21/18
to Luis Nassar, gen...@soe.ucsc.edu
that is very helpful, thanks a lot Luis !
Reply all
Reply to author
Forward
0 new messages