Schema for knownIsoforms
  Database: mm7    Primary Table: knownIsoforms    Row Count: 30,632   Data last updated: 2005-11-14
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 NM_008483varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

Connected Tables and Joining Fields
        knownGeneV39.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownIsoforms.clusterId)
      mm7.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.bioCycPathway.kgID (via knownIsoforms.transcript)
      knownGeneV39.ceBlastTab.query (via knownIsoforms.transcript)
      knownGeneV39.dmBlastTab.query (via knownIsoforms.transcript)
      knownGeneV39.drBlastTab.query (via knownIsoforms.transcript)
      knownGeneV39.foldUtr3.name (via knownIsoforms.transcript)
      knownGeneV39.foldUtr5.name (via knownIsoforms.transcript)
      knownGeneV39.gnfAtlas2Distance.query (via knownIsoforms.transcript)
      knownGeneV39.gnfAtlas2Distance.target (via knownIsoforms.transcript)
      knownGeneV39.kgAlias.kgID (via knownIsoforms.transcript)
      knownGeneV39.kgColor.kgID (via knownIsoforms.transcript)
      knownGeneV39.kgProtAlias.kgID (via knownIsoforms.transcript)
      knownGeneV39.kgSpAlias.kgID (via knownIsoforms.transcript)
      knownGeneV39.kgTargetAli.qName (via knownIsoforms.transcript)
      knownGeneV39.kgXref.kgID (via knownIsoforms.transcript)
      knownGeneV39.knownAttrs.kgID (via knownIsoforms.transcript)
      knownGeneV39.knownBlastTab.query (via knownIsoforms.transcript)
      knownGeneV39.knownBlastTab.target (via knownIsoforms.transcript)
      knownGeneV39.knownCanonical.protein (via knownIsoforms.transcript)
      knownGeneV39.knownCanonical.transcript (via knownIsoforms.transcript)
      knownGeneV39.knownCds.name (via knownIsoforms.transcript)
      knownGeneV39.knownGene.name (via knownIsoforms.transcript)
      knownGeneV39.knownGeneMrna.name (via knownIsoforms.transcript)
      knownGeneV39.knownGenePep.name (via knownIsoforms.transcript)
      knownGeneV39.knownIsoforms.transcript (via knownIsoforms.transcript)
      knownGeneV39.knownToEnsembl.name (via knownIsoforms.transcript)
      knownGeneV39.knownToGnfAtlas2.name (via knownIsoforms.transcript)
      knownGeneV39.knownToHprd.name (via knownIsoforms.transcript)
      knownGeneV39.knownToLocusLink.name (via knownIsoforms.transcript)
      knownGeneV39.knownToMrna.name (via knownIsoforms.transcript)
      knownGeneV39.knownToMrnaSingle.name (via knownIsoforms.transcript)
      knownGeneV39.knownToMupit.name (via knownIsoforms.transcript)
      knownGeneV39.knownToPfam.name (via knownIsoforms.transcript)
      knownGeneV39.knownToRefSeq.name (via knownIsoforms.transcript)
      knownGeneV39.knownToSuper.gene (via knownIsoforms.transcript)
      knownGeneV39.knownToTag.name (via knownIsoforms.transcript)
      knownGeneV39.knownToU133.name (via knownIsoforms.transcript)
      knownGeneV39.knownToU95.name (via knownIsoforms.transcript)
      knownGeneV39.knownToVisiGene.name (via knownIsoforms.transcript)
      knownGeneV39.knownToWikipedia.name (via knownIsoforms.transcript)
      knownGeneV39.mmBlastTab.query (via knownIsoforms.transcript)
      knownGeneV39.rnBlastTab.query (via knownIsoforms.transcript)
      knownGeneV39.scBlastTab.query (via knownIsoforms.transcript)
      knownGeneV39.ucscScop.ucscId (via knownIsoforms.transcript)
      mm7.affyGnfU74ADistance.query (via knownIsoforms.transcript)
      mm7.affyGnfU74ADistance.target (via knownIsoforms.transcript)
      mm7.affyGnfU74BDistance.query (via knownIsoforms.transcript)
      mm7.affyGnfU74BDistance.target (via knownIsoforms.transcript)
      mm7.affyGnfU74CDistance.query (via knownIsoforms.transcript)
      mm7.affyGnfU74CDistance.target (via knownIsoforms.transcript)
      mm7.dmBlastTab.query (via knownIsoforms.transcript)
      mm7.drBlastTab.query (via knownIsoforms.transcript)
      mm7.dupSpMrna.mrnaID (via knownIsoforms.transcript)
      mm7.foldUtr3.name (via knownIsoforms.transcript)
      mm7.foldUtr5.name (via knownIsoforms.transcript)
      mm7.gnfAtlas2Distance.query (via knownIsoforms.transcript)
      mm7.gnfAtlas2Distance.target (via knownIsoforms.transcript)
      mm7.hgBlastTab.query (via knownIsoforms.transcript)
      mm7.keggPathway.kgID (via knownIsoforms.transcript)
      mm7.kgAlias.kgID (via knownIsoforms.transcript)
      mm7.kgProtAlias.kgID (via knownIsoforms.transcript)
      mm7.kgSpAlias.kgID (via knownIsoforms.transcript)
      mm7.kgXref.kgID (via knownIsoforms.transcript)
      mm7.knownBlastTab.query (via knownIsoforms.transcript)
      mm7.knownBlastTab.target (via knownIsoforms.transcript)
      mm7.knownCanonical.transcript (via knownIsoforms.transcript)
      mm7.knownGene.name (via knownIsoforms.transcript)
      mm7.knownGeneLink.name (via knownIsoforms.transcript)
      mm7.knownGeneMrna.name (via knownIsoforms.transcript)
      mm7.knownGenePep.name (via knownIsoforms.transcript)
      mm7.knownToAllenBrain.name (via knownIsoforms.transcript)
      mm7.knownToEnsembl.name (via knownIsoforms.transcript)
      mm7.knownToGnfAtlas2.name (via knownIsoforms.transcript)
      mm7.knownToKeggEntrez.name (via knownIsoforms.transcript)
      mm7.knownToLocusLink.name (via knownIsoforms.transcript)
      mm7.knownToPfam.name (via knownIsoforms.transcript)
      mm7.knownToRefSeq.name (via knownIsoforms.transcript)
      mm7.knownToVisiGene.name (via knownIsoforms.transcript)
      mm7.rnBlastTab.query (via knownIsoforms.transcript)
      mm7.scBlastTab.query (via knownIsoforms.transcript)

Sample Rows
 
clusterIdtranscript
1NM_008483
2AK141751
3AK079850
4NM_001004153
4BC086454
5AJ245453
6NM_030740
7BC089532
8AK030037
9BC089532

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