Schema for sgdCanonical
  Database: sacCer3    Primary Table: sgdCanonical    Row Count: 6,534   Data last updated: 2011-09-02
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 3951int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 4338int(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 Q0010varchar(255) values Corresponds to knownGene name field.
protein n/avarchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        sacCer3.sgdIsoforms.clusterId (via sgdCanonical.clusterId)
      go.goaPart.dbObjectId (via sgdCanonical.protein)
      knownGeneV39.kgProtAlias.alias (via sgdCanonical.protein)
      knownGeneV39.kgSpAlias.spID (via sgdCanonical.protein)
      knownGeneV39.kgXref.spID (via sgdCanonical.protein)
      proteome.spOldNew.acc (via sgdCanonical.protein)
      proteome.spReactomeEvent.spID (via sgdCanonical.protein)
      proteome.spReactomeId.spID (via sgdCanonical.protein)
      sacCer3.sgdGene.proteinID (via sgdCanonical.protein)
      sacCer3.sgdToSwissProt.value (via sgdCanonical.protein)
      uniProt.accToKeyword.acc (via sgdCanonical.protein)
      uniProt.accToTaxon.acc (via sgdCanonical.protein)
      uniProt.citation.acc (via sgdCanonical.protein)
      uniProt.comment.acc (via sgdCanonical.protein)
      uniProt.description.acc (via sgdCanonical.protein)
      uniProt.displayId.acc (via sgdCanonical.protein)
      uniProt.extDbRef.acc (via sgdCanonical.protein)
      uniProt.feature.acc (via sgdCanonical.protein)
      uniProt.gene.acc (via sgdCanonical.protein)
      uniProt.geneLogic.acc (via sgdCanonical.protein)
      uniProt.info.acc (via sgdCanonical.protein)
      uniProt.otherAcc.acc (via sgdCanonical.protein)
      uniProt.protein.acc (via sgdCanonical.protein)
      visiGene.gene.uniProt (via sgdCanonical.protein)
      sacCer3.ceBlastTab.query (via sgdCanonical.transcript)
      sacCer3.choExpDistance.query (via sgdCanonical.transcript)
      sacCer3.choExpDistance.target (via sgdCanonical.transcript)
      sacCer3.dmBlastTab.query (via sgdCanonical.transcript)
      sacCer3.drBlastTab.query (via sgdCanonical.transcript)
      sacCer3.esRegGeneToModule.gene (via sgdCanonical.transcript)
      sacCer3.esRegGeneToMotif.gene (via sgdCanonical.transcript)
      sacCer3.esRegUpstreamRegion.name (via sgdCanonical.transcript)
      sacCer3.hgBlastTab.query (via sgdCanonical.transcript)
      sacCer3.mmBlastTab.query (via sgdCanonical.transcript)
      sacCer3.rnBlastTab.query (via sgdCanonical.transcript)
      sacCer3.sgdBlastTab.query (via sgdCanonical.transcript)
      sacCer3.sgdBlastTab.target (via sgdCanonical.transcript)
      sacCer3.sgdDescription.name (via sgdCanonical.transcript)
      sacCer3.sgdGene.name (via sgdCanonical.transcript)
      sacCer3.sgdIsoforms.transcript (via sgdCanonical.transcript)
      sacCer3.sgdPep.name (via sgdCanonical.transcript)
      sacCer3.sgdToName.name (via sgdCanonical.transcript)
      sacCer3.sgdToSwissProt.name (via sgdCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrM395143381Q0010n/a
chrM11666119572Q0032n/a
chrM13817188303Q0055P03876
chrM24155252554Q0075Q9ZZX0
chrM27665278125Q0080P00856
chrM28486292666Q0085P00854
chrM30873310147Q0092n/a
chrM36539422518Q0120P03879
chrM46722469539Q0130P61829
chrM489005009710Q0140P02381

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