Schema for ensemblToGeneName
  Database: ailMel1    Primary Table: ensemblToGeneName    Row Count: 18,013   Data last updated: 2020-08-31
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSAMET00000017883.1varchar(255) values Ensembl transcript ID
value CHD9varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSAMET00000017883.1CHD9
ENSAMET00000017960.1RBL2
ENSAMET00000017981.1AKTIP
ENSAMET00000018009.1RPGRIP1L
ENSAMET00000018031.1FTO
ENSAMET00000018032.1IRX3
ENSAMET00000018037.1IRX5
ENSAMET00000018038.1IRX6
ENSAMET00000018040.1IRX6
ENSAMET00000018059.1MMP2

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