Schema for ensemblToGeneName
  Database: oryLat2    Primary Table: ensemblToGeneName    Row Count: 17,816   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 ENSORLT00000000006.1varchar(255) values Ensembl transcript ID
value si:ch211-113e8.3varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSORLT00000000006.1si:ch211-113e8.3
ENSORLT00000000013.1slc43a1b
ENSORLT00000000014.1slc43a1b
ENSORLT00000000025.1zgc:165555
ENSORLT00000000037.1GOT1 (1 of many)
ENSORLT00000000045.1CNNM1 (1 of many)
ENSORLT00000000046.1CNNM1 (1 of many)
ENSORLT00000000047.1hoga1
ENSORLT00000000050.1MORN4
ENSORLT00000000051.1lcor

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