Schema for ensemblToGeneName
  Database: papAnu4    Primary Table: ensemblToGeneName    Row Count: 41,105   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 ENSPANT00000023424.2varchar(255) values Ensembl transcript ID
value CDC42SE1varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSPANT00000023424.2CDC42SE1
ENSPANT00000026263.2SAMD13
ENSPANT00000048035.1SAMD13
ENSPANT00000016065.2U6
ENSPANT00000014756.2U6
ENSPANT00000007744.2SPRR4
ENSPANT00000044865.1U6
ENSPANT00000043050.1U6
ENSPANT00000038722.15S_rRNA
ENSPANT00000004248.2U6

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