Schema for ensemblToGeneName
  Database: choHof1    Primary Table: ensemblToGeneName    Row Count: 9,228   Data last updated: 2019-01-11
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSCHOT00000003814.1varchar(255) values Ensembl transcript ID
value LRP1Bvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCHOT00000003814.1LRP1B
ENSCHOT00000006208.1KCTD3
ENSCHOT00000006282.1USH2A
ENSCHOT00000011951.1LAMA2
ENSCHOT00000002335.1CSMD3
ENSCHOT00000005461.1RYR2
ENSCHOT00000010908.1HDAC9
ENSCHOT00000011044.1NBEA
ENSCHOT00000004926.1NCKAP5
ENSCHOT00000013810.1IQCH

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