Schema for ensemblToGeneName
  Database: fr3    Primary Table: ensemblToGeneName    Row Count: 21,866   Data last updated: 2019-01-14
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSTRUT00000025027.2varchar(255) values Ensembl transcript ID
value sdk2bvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSTRUT00000025027.2sdk2b
ENSTRUT00000025026.2sdk2b
ENSTRUT00000024991.2cdc42ep4b
ENSTRUT00000024619.2tekt3
ENSTRUT00000024512.2pmp22b
ENSTRUT00000024304.2hs3st3b1b
ENSTRUT00000023868.2cox10
ENSTRUT00000023655.2si:ch211-216b21.2
ENSTRUT00000022849.2sgca
ENSTRUT00000022848.2sgca

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