Schema for ensemblToGeneName
  Database: ce11    Primary Table: ensemblToGeneName    Row Count: 61,451   Data last updated: 2021-05-25
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name F07C3.7.1varchar(255) values Ensembl transcript ID
value aat-2varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
F07C3.7.1aat-2
T11F9.4a.1aat-6
T11F9.4b.1aat-6
F54B8.5.1abf-3
Y38H6C.22.1abf-4
Y39D8C.1.1abt-4
AC3.3.1abu-1
Y5H2A.3.1abu-4
C03A7.7.1abu-6
C03A7.8.1abu-7

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