Schema for ensemblToGeneName
  Database: ci3    Primary Table: ensemblToGeneName    Row Count: 749   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 ENSCINT00000004156.3varchar(255) values Ensembl transcript ID
value laspvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCINT00000004156.3lasp
ENSCINT00000023552.2zf(c2h2)-116
ENSCINT00000009842.3mama
ENSCINT00000020132.3ephrinb
ENSCINT00000012097.3leprecan
ENSCINT00000031527.1not7
ENSCINT00000025376.2sfrp3/4-b
ENSCINT00000008085.3ck2b
ENSCINT00000021107.3yb1/2/3
ENSCINT00000010620.3yb1/2/3

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