Schema for ensemblToGeneName
  Database: hg19    Primary Table: ensemblToGeneName    Row Count: 204,940   Data last updated: 2014-02-28
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000400776varchar(255) values Ensembl transcript ID
value PNRC2varchar(255) values alternate gene name

Connected Tables and Joining Fields
        hg19.ensGene.name (via ensemblToGeneName.name)
      hg19.ensGtp.transcript (via ensemblToGeneName.name)
      hg19.ensPep.name (via ensemblToGeneName.name)
      hg19.ensemblSource.name (via ensemblToGeneName.name)
      hg19.knownToEnsembl.value (via ensemblToGeneName.name)
      knownGeneV39.knownToEnsembl.value (via ensemblToGeneName.name)

Sample Rows
 
namevalue
ENST00000400776PNRC2
ENST00000374457SRSF10
ENST00000433682SRSF10
ENST00000374449SRSF10
ENST00000459035U6atac
ENST00000516583SNORD112
ENST00000459564AL360154.2
ENST00000545452AL360154.1
ENST00000425945AC109135.1
ENST000004589015S_rRNA

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.