Schema for ensemblToGeneName
  Database: ochPri2    Primary Table: ensemblToGeneName    Row Count: 14,973   Data last updated: 2019-01-11
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSOPRT00000020757.1varchar(255) values Ensembl transcript ID
value RF00001varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSOPRT00000020757.1RF00001
ENSOPRT00000013481.1ACTL7B
ENSOPRT00000013558.1ELP1
ENSOPRT00000020089.1RF00026
ENSOPRT00000013573.1FAM206A
ENSOPRT00000013612.1CTNNAL1
ENSOPRT00000013659.1TMEM245
ENSOPRT00000017595.1MIR32
ENSOPRT00000013676.1FRRS1L
ENSOPRT00000013717.1EPB41L4B

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