Schema for ensemblToGeneName
  Database: dipOrd1    Primary Table: ensemblToGeneName    Row Count: 16,072   Data last updated: 2015-08-05
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSDORT00000009617.1varchar(255) values Ensembl transcript ID
value Dock9varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSDORT00000009617.1Dock9
ENSDORT00000022843.1SNORA73
ENSDORT00000019926.1U1
ENSDORT00000022229.1U6
ENSDORT00000020165.1U1
ENSDORT00000021544.1U6
ENSDORT00000020360.1U6
ENSDORT00000020156.15_8S_rRNA
ENSDORT00000022965.15_8S_rRNA
ENSDORT00000021271.15_8S_rRNA

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