Schema for sangerCanonical
  Database: ce2    Primary Table: sangerCanonical    Row Count: 20,713   Data last updated: 2005-05-03
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom chrIvarchar(255) values Chromosome
chromStart 11640int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 16585int(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 Y74C9A.2varchar(255) values Corresponds to knownGene name field.
protein Q9N4D8varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

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

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrI11640165851Y74C9A.2Q9N4D8
chrI43732446772Y74C9A.1Q9N4D5
chrI49920543603Y48G1C.4Q9BL79
chrI72648803444Y48G1C.2Q9BL77
chrI82056849595Y48G1C.10Q8IU07
chrI86840896086Y48G1C.11Q8IU06
chrI91378926487Y48G1C.9Q9BL76
chrI93091947148Y48G1C.1Q9N3P1
chrI1110541122279F53G12.10O01802
chrI11236411369910F53G12.9O01801

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