Schema for ensemblToGeneName
  Database: hg18    Primary Table: ensemblToGeneName    Row Count: 63,280   Data last updated: 2017-07-07
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000369958varchar(255) values Ensembl transcript ID
value AC011645.3-2varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENST00000369958AC011645.3-2
ENST00000400794AC011645.3-3
ENST00000400791AC011645.3-1
ENST00000338272AC011645.3-4
ENST00000400793AC011645.3-5
ENST00000391567AC026283.2-1
ENST00000407899AC026283.2-2
ENST00000400830AC026283.2-3
ENST00000404192AC026283.2-4
ENST00000400823AC026283.2-5

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