Schema for ensemblToGeneName
  Database: canFam5    Primary Table: ensemblToGeneName    Row Count: 16,832   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 ENSCAFT00040000002.1varchar(255) values Ensembl transcript ID
value ENPP1varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCAFT00040000002.1ENPP1
ENSCAFT00040000009.1TXNL4A
ENSCAFT00040000010.1TXNL4A
ENSCAFT00040000011.1TXNL4A
ENSCAFT00040000027.1ATP9B
ENSCAFT00040000028.1ATP9B
ENSCAFT00040000029.1ATP9B
ENSCAFT00040000030.1ATP9B
ENSCAFT00040000031.1ATP9B
ENSCAFT00040000032.1ATP9B

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