Schema for ensemblToGeneName
  Database: vicPac1    Primary Table: ensemblToGeneName    Row Count: 10,115   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 ENSVPAT00000000583.1varchar(255) values Ensembl transcript ID
value NRXN3varchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSVPAT00000000583.1NRXN3
ENSVPAT00000016146.1RF00001
ENSVPAT00000017985.1RF00322
ENSVPAT00000000585.1DIO2
ENSVPAT00000000586.1CEP128
ENSVPAT00000016445.1RF00026
ENSVPAT00000017994.1RF00004
ENSVPAT00000000587.1TSHR
ENSVPAT00000000588.1GTF2A1
ENSVPAT00000000590.1STON2

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