Schema for ensemblToGeneName
  Database: ci2    Primary Table: ensemblToGeneName    Row Count: 20,206   Data last updated: 2011-10-25
Format description: Ensembl gene transcript to other gene name translation table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSCINT00000027313varchar(255) values Ensembl transcript ID
value F6XY46_CIOINvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCINT00000027313F6XY46_CIOIN
ENSCINT00000020405F6QFD6_CIOIN
ENSCINT00000020407F6QFD6_CIOIN
ENSCINT00000015514F7AMA3_CIOIN
ENSCINT00000015518F7AMA3_CIOIN
ENSCINT00000015517F7AMA3_CIOIN
ENSCINT00000000506F6ZZY9_CIOIN
ENSCINT00000015501F7AMI3_CIOIN
ENSCINT00000027244F7BER6_CIOIN
ENSCINT00000010826F6V9A1_CIOIN

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