Schema for sangerCanonical
  Database: ce4    Primary Table: sangerCanonical    Row Count: 19,965   Data last updated: 2007-08-02
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chrIIvarchar(255) values Chromosome
chromStart 9788812int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 9793199int(11) range End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
clusterId 16606int(10) unsigned range Which cluster of transcripts this belongs to in knownIsoforms
transcript T10B9.5varchar(255) values Corresponds to knownGene name field.
protein Q27517varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        ce4.sangerIsoforms.clusterId (via sangerCanonical.clusterId)
      ce4.sangerGene.proteinID (via sangerCanonical.protein)
      ce4.sangerLinks.protName (via sangerCanonical.protein)
      go.goaPart.dbObjectId (via sangerCanonical.protein)
      knownGeneV39.kgProtAlias.alias (via sangerCanonical.protein)
      knownGeneV39.kgSpAlias.spID (via sangerCanonical.protein)
      knownGeneV39.kgXref.spID (via sangerCanonical.protein)
      proteome.spOldNew.acc (via sangerCanonical.protein)
      proteome.spReactomeEvent.spID (via sangerCanonical.protein)
      proteome.spReactomeId.spID (via sangerCanonical.protein)
      uniProt.accToKeyword.acc (via sangerCanonical.protein)
      uniProt.accToTaxon.acc (via sangerCanonical.protein)
      uniProt.citation.acc (via sangerCanonical.protein)
      uniProt.comment.acc (via sangerCanonical.protein)
      uniProt.description.acc (via sangerCanonical.protein)
      uniProt.displayId.acc (via sangerCanonical.protein)
      uniProt.extDbRef.acc (via sangerCanonical.protein)
      uniProt.feature.acc (via sangerCanonical.protein)
      uniProt.gene.acc (via sangerCanonical.protein)
      uniProt.geneLogic.acc (via sangerCanonical.protein)
      uniProt.info.acc (via sangerCanonical.protein)
      uniProt.otherAcc.acc (via sangerCanonical.protein)
      uniProt.protein.acc (via sangerCanonical.protein)
      visiGene.gene.uniProt (via sangerCanonical.protein)
      ce4.kimExpDistance.query (via sangerCanonical.transcript)
      ce4.kimExpDistance.target (via sangerCanonical.transcript)
      ce4.mmBlastTab.query (via sangerCanonical.transcript)
      ce4.orfToGene.name (via sangerCanonical.transcript)
      ce4.sangerBlastTab.query (via sangerCanonical.transcript)
      ce4.sangerBlastTab.target (via sangerCanonical.transcript)
      ce4.sangerGene.name (via sangerCanonical.transcript)
      ce4.sangerGeneToWBGeneID.sangerGene (via sangerCanonical.transcript)
      ce4.sangerIsoforms.transcript (via sangerCanonical.transcript)
      ce4.sangerLinks.orfName (via sangerCanonical.transcript)
      ce4.sangerPep.name (via sangerCanonical.transcript)
      ce4.sangerToRefSeq.name (via sangerCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrII9788812979319916606T10B9.5Q27517
chrII9783732978731316605T10B9.7Q27518
chrII9779259978186516604T10B9.8Q27520
chrII9774904977579816603T10B9.9Q09352
chrII9770683977379916602ZK1321.4Q9XTP9
chrII9768506976976216601ZK1321.3Q09369
chrII9750425975221916600Y53C12B.7Q7YWN6
chrII9743045974598216599Y53C12B.1O18215
chrII9738896974279916598Y53C12B.2O18216
chrII9721742972444116597Y53C12B.6O18213

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