Schema for sgdIsoforms
  Database: sacCer2    Primary Table: sgdIsoforms    Row Count: 6,717   Data last updated: 2009-02-17
Format description: Links together various transcripts of a gene into a cluster
On download server: MariaDB table dump directory
fieldexampleSQL type info description
clusterId 1int(10) unsigned range Unique id for transcript cluster (aka gene)
transcript R0010Wvarchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

Connected Tables and Joining Fields
        sacCer2.sgdCanonical.clusterId (via sgdIsoforms.clusterId)
      sacCer2.ceBlastTab.query (via sgdIsoforms.transcript)
      sacCer2.choExpDistance.query (via sgdIsoforms.transcript)
      sacCer2.choExpDistance.target (via sgdIsoforms.transcript)
      sacCer2.dmBlastTab.query (via sgdIsoforms.transcript)
      sacCer2.drBlastTab.query (via sgdIsoforms.transcript)
      sacCer2.esRegGeneToModule.gene (via sgdIsoforms.transcript)
      sacCer2.esRegGeneToMotif.gene (via sgdIsoforms.transcript)
      sacCer2.esRegUpstreamRegion.name (via sgdIsoforms.transcript)
      sacCer2.hgBlastTab.query (via sgdIsoforms.transcript)
      sacCer2.mmBlastTab.query (via sgdIsoforms.transcript)
      sacCer2.rnBlastTab.query (via sgdIsoforms.transcript)
      sacCer2.sgdAbundance.name (via sgdIsoforms.transcript)
      sacCer2.sgdBlastTab.query (via sgdIsoforms.transcript)
      sacCer2.sgdBlastTab.target (via sgdIsoforms.transcript)
      sacCer2.sgdCanonical.transcript (via sgdIsoforms.transcript)
      sacCer2.sgdDescription.name (via sgdIsoforms.transcript)
      sacCer2.sgdGene.name (via sgdIsoforms.transcript)
      sacCer2.sgdLocalization.name (via sgdIsoforms.transcript)
      sacCer2.sgdPep.name (via sgdIsoforms.transcript)
      sacCer2.sgdToName.name (via sgdIsoforms.transcript)
      sacCer2.sgdToPfam.name (via sgdIsoforms.transcript)
      sacCer2.sgdToSwissProt.name (via sgdIsoforms.transcript)

Sample Rows
 
clusterIdtranscript
1R0010W
2R0030W
3R0020C
4R0040C
5Q0010
5Q0017
6Q0032
7Q0050
7Q0045
7Q0070

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