Schema for ensemblToGeneName
  Database: canFam2    Primary Table: ensemblToGeneName    Row Count: 22,957   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 ENSCAFT00000039626varchar(255) values Ensembl transcript ID
value Q866Y1_CANFAvarchar(255) values alternate gene name

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

Sample Rows
 
namevalue
ENSCAFT00000039626Q866Y1_CANFA
ENSCAFT00000020538Q866Y1_CANFA
ENSCAFT00000020548C17orf101
ENSCAFT00000020565HEXDC
ENSCAFT00000020571C17orf62
ENSCAFT00000020594NARF
ENSCAFT00000020598NARF
ENSCAFT00000020603FOXK2
ENSCAFT00000020648WDR45L
ENSCAFT00000020679FN3KRP

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