This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Database to map gene ID to the chromosome where it is located?

I am looking for a database, preferentially with a .csv or .txt dump that would be able to convert gene accession handles (Name, Gene Id, UNIPROT IDs, EMBL accession numbers, ...) to the chromosomes they are assigned in their specific organism.

This data is usually shown in web rendering of the Uniprot proteins, but is absent from the original .txt data dump as far as I know.

gene

3 answers

One way to do it is to grab the archive of the gene annotations from your source of choice with wget or curl, filter the result for genes with awk, and then convert to BED and awk to get the fourth and first columns (ID and chromosome values), e.g.,:

​$ wget -qO- ftp://ftp.sanger.ac.uk/pub/gencode/Gencode_human/release_21/gencode.v21.annotation.gff3.gz \
    | gunzip --stdout - \
    | awk '$3=="gene"' - \
    | convert2bed -i gff - \
    | awk '{print "$4\t$1";}' - \
    > gene_id_and_chromosome.txt

Thank you for your answer! I see there is a way to do the same thing for the mouse thanks to the same resource. Is there a way to retrieve the mapping for Saccharomyces Cerevisiae?

Andrei! Hello from Seattle! I'm looking for a way to find the chromosome location for the uniprot.dat file. Any chance you know where I can find that?

Hello Summer, hope you are doing well there! Cf my answer, hope it helps.

bioDBnet does what you want

It seems that Uniprot has "Proteomes" object some of which actually map to the chromosomes.

In Uniprot, this is available under the DR; EMBL; BKXXXXX; ... ;. .. ;... field (for yeast, CMXXXX for humans).

A mapping from BKXXX (CMXXX) references seems to be obtainable manually from the Uniprot proteome links.

It seems that the mapping is also readily available in BioConductor among the gene location mapping tools too.

Log in to answer this question.