Schema for sgdCanonical
  Database: sacCer2    Primary Table: sgdCanonical    Row Count: 6,550   Data last updated: 2009-02-17
Format description: Describes the canonical splice variant of a gene
On download server: MariaDB table dump directory
fieldexampleSQL type info description
chrom 2micronvarchar(255) values Chromosome
chromStart 251int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 1523int(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 R0010Wvarchar(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
        sacCer2.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)
      sacCer2.sgdGene.proteinID (via sgdCanonical.protein)
      sacCer2.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)
      sacCer2.ceBlastTab.query (via sgdCanonical.transcript)
      sacCer2.choExpDistance.query (via sgdCanonical.transcript)
      sacCer2.choExpDistance.target (via sgdCanonical.transcript)
      sacCer2.dmBlastTab.query (via sgdCanonical.transcript)
      sacCer2.drBlastTab.query (via sgdCanonical.transcript)
      sacCer2.esRegGeneToModule.gene (via sgdCanonical.transcript)
      sacCer2.esRegGeneToMotif.gene (via sgdCanonical.transcript)
      sacCer2.esRegUpstreamRegion.name (via sgdCanonical.transcript)
      sacCer2.hgBlastTab.query (via sgdCanonical.transcript)
      sacCer2.mmBlastTab.query (via sgdCanonical.transcript)
      sacCer2.rnBlastTab.query (via sgdCanonical.transcript)
      sacCer2.sgdAbundance.name (via sgdCanonical.transcript)
      sacCer2.sgdBlastTab.query (via sgdCanonical.transcript)
      sacCer2.sgdBlastTab.target (via sgdCanonical.transcript)
      sacCer2.sgdDescription.name (via sgdCanonical.transcript)
      sacCer2.sgdGene.name (via sgdCanonical.transcript)
      sacCer2.sgdIsoforms.transcript (via sgdCanonical.transcript)
      sacCer2.sgdLocalization.name (via sgdCanonical.transcript)
      sacCer2.sgdPep.name (via sgdCanonical.transcript)
      sacCer2.sgdToName.name (via sgdCanonical.transcript)
      sacCer2.sgdToPfam.name (via sgdCanonical.transcript)
      sacCer2.sgdToSwissProt.name (via sgdCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
2micron25115231R0010Wn/a
2micron327038162R0030Wn/a
2micron188630083R0020Cn/a
2micron530761984R0040Cn/a
chrM395143385Q0010n/a
chrM11666119576Q0032n/a
chrM13817188307Q0055P03876
chrM24155252558Q0075Q9ZZX0
chrM27665278129Q0080P00856
chrM284862926610Q0085P00854

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