Schema for sangerCanonical
  Database: ce6    Primary Table: sangerCanonical    Row Count: 20,051   Data last updated: 2008-06-03
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chrMvarchar(255) values Chromosome
chromStart 112int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 549int(11) range End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
clusterId 1int(10) unsigned range Which cluster of transcripts this belongs to in knownIsoforms
transcript MTCE.3varchar(255) values Corresponds to knownGene name field.
protein  varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        ce6.sangerIsoforms.clusterId (via sangerCanonical.clusterId)
      ce6.sangerGene.proteinID (via sangerCanonical.protein)
      ce6.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)
      ce6.dmBlastTab.query (via sangerCanonical.transcript)
      ce6.drBlastTab.query (via sangerCanonical.transcript)
      ce6.hgBlastTab.query (via sangerCanonical.transcript)
      ce6.kimExpDistance.query (via sangerCanonical.transcript)
      ce6.kimExpDistance.target (via sangerCanonical.transcript)
      ce6.mmBlastTab.query (via sangerCanonical.transcript)
      ce6.orfToGene.name (via sangerCanonical.transcript)
      ce6.rnBlastTab.query (via sangerCanonical.transcript)
      ce6.sangerBlastTab.query (via sangerCanonical.transcript)
      ce6.sangerBlastTab.target (via sangerCanonical.transcript)
      ce6.sangerGene.name (via sangerCanonical.transcript)
      ce6.sangerGeneToWBGeneID.sangerGene (via sangerCanonical.transcript)
      ce6.sangerIsoforms.transcript (via sangerCanonical.transcript)
      ce6.sangerLinks.orfName (via sangerCanonical.transcript)
      ce6.sangerPep.name (via sangerCanonical.transcript)
      ce6.sangerToRefSeq.name (via sangerCanonical.transcript)
      ce6.scBlastTab.query (via sangerCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrM1125491MTCE.3
chrM176226352MTCE.11
chrM338842693MTCE.16
chrM450356214MTCE.21
chrM567764495MTCE.23
chrM650578086MTCE.25
chrM782694287MTCE.26
chrM9648103488MTCE.31
chrM11690132729MTCE.35
chrIII88551194010H10E21.2H10E21.2

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