Schema for ensemblToGeneName
  Database: ornAna1    Primary Table: ensemblToGeneName    Row Count: 10,849   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 ENSOANT00000009681.2varchar(255) values Ensembl transcript ID
value RNF141varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSOANT00000009681.2RNF141
ENSOANT00000009675.2AMPD3
ENSOANT00000009324.3SWAP70
ENSOANT00000009323.2WEE1
ENSOANT00000009320.3ZNF143
ENSOANT00000026754.1RF00319
ENSOANT00000004946.3DENND5A
ENSOANT00000004940.2SCUBE2
ENSOANT00000004939.2NRIP3
ENSOANT00000004938.2TMEM9B

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