Schema for ensemblToGeneName
  Database: fr2    Primary Table: ensemblToGeneName    Row Count: 37,102   Data last updated: 2018-05-08
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSTRUT00000008836.1varchar(255) values Ensembl transcript ID
value gtf2a2varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSTRUT00000008836.1gtf2a2
ENSTRUT00000010226.1gpn1
ENSTRUT00000010995.1large2
ENSTRUT00000010996.1large2
ENSTRUT00000010997.1large2
ENSTRUT00000010998.1large2
ENSTRUT00000012748.1si:ch211-71n6.4
ENSTRUT00000012749.1si:ch211-71n6.4
ENSTRUT00000012835.1BRSK2
ENSTRUT00000012836.1BRSK2

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