Schema for sgdCanonical
  Database: sacCer1    Primary Table: sgdCanonical    Row Count: 5,743   Data last updated: 2003-12-31
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 13817int(11) range Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
chromEnd 18830int(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 Q0055varchar(255) values Corresponds to knownGene name field.
protein Q9ZZX4varchar(255) values Accession of the associated protein, or UCSC ID in newer tables.

Connected Tables and Joining Fields
        sacCer1.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)
      sacCer1.sgdGene.proteinID (via sgdCanonical.protein)
      sacCer1.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)
      sacCer1.choExpDistance.query (via sgdCanonical.transcript)
      sacCer1.choExpDistance.target (via sgdCanonical.transcript)
      sacCer1.dmBlastTab.query (via sgdCanonical.transcript)
      sacCer1.esRegGeneToModule.gene (via sgdCanonical.transcript)
      sacCer1.esRegGeneToMotif.gene (via sgdCanonical.transcript)
      sacCer1.esRegUpstreamRegion.name (via sgdCanonical.transcript)
      sacCer1.hgBlastTab.query (via sgdCanonical.transcript)
      sacCer1.mmBlastTab.query (via sgdCanonical.transcript)
      sacCer1.rnBlastTab.query (via sgdCanonical.transcript)
      sacCer1.sgdAbundance.name (via sgdCanonical.transcript)
      sacCer1.sgdBlastTab.query (via sgdCanonical.transcript)
      sacCer1.sgdBlastTab.target (via sgdCanonical.transcript)
      sacCer1.sgdDescription.name (via sgdCanonical.transcript)
      sacCer1.sgdGene.name (via sgdCanonical.transcript)
      sacCer1.sgdIsoforms.transcript (via sgdCanonical.transcript)
      sacCer1.sgdLocalization.name (via sgdCanonical.transcript)
      sacCer1.sgdPep.name (via sgdCanonical.transcript)
      sacCer1.sgdToName.name (via sgdCanonical.transcript)
      sacCer1.sgdToPfam.name (via sgdCanonical.transcript)
      sacCer1.sgdToSwissProt.name (via sgdCanonical.transcript)

Sample Rows
 
chromchromStartchromEndclusterIdtranscriptprotein
chrM13817188301Q0055Q9ZZX4
chrM24155252552Q0075Q9ZZX0
chrM27665278123Q0080P00856
chrM28486292664Q0085Q95A27
chrM36539422515Q0120Q9ZZW6
chrM46722469536Q0130P00841
chrM48900500977Q0140Q9ZZW5
chrM61021617298Q0160P03882
chrM74494759849Q0255Q9ZZW0
chrM792128002210Q0275Q9ZZV9

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