Schema for ensemblToGeneName
  Database: saiBol1    Primary Table: ensemblToGeneName    Row Count: 38,881   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 ENSSBOT00000000072.1varchar(255) values Ensembl transcript ID
value SHROOM2varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSSBOT00000000072.1SHROOM2
ENSSBOT00000000103.1SHROOM2
ENSSBOT00000000042.1PRG3
ENSSBOT00000000066.1U6
ENSSBOT00000000112.1Y_RNA
ENSSBOT00000000201.1Metazoa_SRP
ENSSBOT00000000271.1GLYAT
ENSSBOT00000000278.1U4
ENSSBOT00000000417.1MPPED2
ENSSBOT00000000504.1MPPED2

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