This is a test version of Biostars. For the public version, visit https://www.biostars.org.
ENSEMBL Gene ID to Gene Symbol

I came across this site which offers some tools for converting ENSEMBL gene id to gene symbol. I wanted to inquire about what are the conversion set of rules?

gene

What do you mean by set of rules? We've gone off into giving lists of tools but maybe this is not what you're asking.

Is there a one to one conversion between ENSEMBL gene id to gene symbol? Is it just a huge table or there are some rules that given an ENSEMBL I can convert it to gene symbol?

So assuming I have this ENSEMBL : ENSMUSG00000022485 can I deduce from the numbers what is the gene symbol? without using a database? The bottom line is that I want to write a script that handels such conversion (two sided)

Your best bet is to use the API posted by @Jean-Karim below. Other solutions will need you to install/use R code or query MySQL.

Could you elaborate on how can I query from MySQL? where can I find the relevant databases?

You have to understand that Ensembl IDs and gene symbols represent different notions of what a gene is. In Ensembl, a gene is a portion of a chromosome. A gene symbol on the other hand is an attempt at summarizing and standardizing many names given to a "gene" by biologists. The definition of gene used by biologists is fuzzy and usually refers to a set of related molecules (e.g. proteins or RNAs) that may be produced by more than one locus in the genome.

3 answers

Please take a look at the first two answers here for the 2 most common programmatic approaches:

Another approach via mysql and UCSC:

Kevin

Either you can use the biomaRt R package or just use Ensembl BioMart to convert Ensembl-id to gene name in BioMart and choose a specific database and fetch your query.

There's also the perl API to Ensembl. No need to do raw SQL queries against the database and it's much more convenient when one needs to access and process different types of entities/information.

Log in to answer this question.