Schema for ensemblToGeneName
  Database: cavPor3    Primary Table: ensemblToGeneName    Row Count: 24,398   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 ENSCPOT00000012397.3varchar(255) values Ensembl transcript ID
value FZD6varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCPOT00000012397.3FZD6
ENSCPOT00000010798.3NDUFAF6
ENSCPOT00000003103.3MATN2
ENSCPOT00000007891.3TMEM67
ENSCPOT00000038039.1TMEM74
ENSCPOT00000045279.1BAALC
ENSCPOT00000011377.3TNFRSF11B
ENSCPOT00000048262.1RBIS
ENSCPOT00000046378.1ZFPM2
ENSCPOT00000014367.3ZFPM2

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