Schema for sgdIsoforms
  Database: sacCer1    Primary Table: sgdIsoforms    Row Count: 5,769   Data last updated: 2003-12-31
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 Q0060varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

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

Sample Rows
 
clusterIdtranscript
1Q0060
1Q0045
1Q0050
1Q0065
1Q0055
1Q0070
2Q0075
3Q0080
4Q0085
5Q0120

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