Schema for sgdIsoforms
  Database: sacCer3    Primary Table: sgdIsoforms    Row Count: 6,692   Data last updated: 2011-09-02
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 Q0010varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

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

Sample Rows
 
clusterIdtranscript
1Q0010
1Q0017
2Q0032
3Q0050
3Q0045
3Q0070
3Q0065
3Q0060
3Q0055
4Q0075

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