Schema for sangerIsoforms
  Database: ce4    Primary Table: sangerIsoforms    Row Count: 30,497   Data last updated: 2007-07-30
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 cTel7X.1varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

Connected Tables and Joining Fields
        ce4.sangerCanonical.clusterId (via sangerIsoforms.clusterId)
      ce4.kimExpDistance.query (via sangerIsoforms.transcript)
      ce4.kimExpDistance.target (via sangerIsoforms.transcript)
      ce4.mmBlastTab.query (via sangerIsoforms.transcript)
      ce4.orfToGene.name (via sangerIsoforms.transcript)
      ce4.sangerBlastTab.query (via sangerIsoforms.transcript)
      ce4.sangerBlastTab.target (via sangerIsoforms.transcript)
      ce4.sangerCanonical.transcript (via sangerIsoforms.transcript)
      ce4.sangerGene.name (via sangerIsoforms.transcript)
      ce4.sangerGeneToWBGeneID.sangerGene (via sangerIsoforms.transcript)
      ce4.sangerLinks.orfName (via sangerIsoforms.transcript)
      ce4.sangerPep.name (via sangerIsoforms.transcript)
      ce4.sangerToRefSeq.name (via sangerIsoforms.transcript)

Sample Rows
 
clusterIdtranscript
1cTel7X.1
2CE7X_3.1
3Y35H6.1
4Y73B3A.21
5Y73B3A.20
6Y73B3A.18b
6Y73B3A.18a
7Y73B3A.17
8Y73B3A.16
9Y73B3A.15

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