Hello Manuel, You can get the information you are looking for from our table browser (http://www.genome.ucsc.edu/cgi-bin/hgTables).
After selecting Human select: group: Genes and Gene Prediction Tracks track: Ensembl Genes table: ensGene output format: selected fields from primary and related tables then click on "get output". This will take you to another menu. Here you can select the Ensembl identifier and the genomic coordinates: hg18.ensGene fields: select name, chrom, and the transcription or coding region start and end depending on what you want. Select hg18.kgXref and click "allow selection from checked tables". This should bring up a much longer list of tables that are connected to kgXref that you can also choose fields from. Now select proteome.hgnc from the Linked Tables section and click "allow selection from checked tables". You should now have all the tables you need available to select fields from. These fields should be selected: hg18.ensGene: name, chrom, txStart, txEnd kgXref: kgID proteome.hgnc: hgncId Finally hit "get output" (this should be at the bottom of the first section). Hopefully this information was helpful and answers your question. If you have further questions or require clarification feel free to contact the mailing list at [email protected]. Regards, Pauline Fujita UCSC Genome Bioinformatics Group http://genome.ucsc.edu Manuel Rodrigues wrote: > Hi > > I'm trying to extract a list of UCSC gene coordinates but I want to obtain in > the same table the UCSC, HGNC and Ensembl IDs. > How can I? > > > > > > _______________________________________________ > Genome maillist - [email protected] > http://www.soe.ucsc.edu/mailman/listinfo/genome > _______________________________________________ Genome maillist - [email protected] http://www.soe.ucsc.edu/mailman/listinfo/genome
