Schema for knownIsoforms
  Database: mm8    Primary Table: knownIsoforms    Row Count: 31,014   Data last updated: 2006-03-08
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_030175varchar(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)
      mm8.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)
      mm8.affyGnfU74ADistance.query (via knownIsoforms.transcript)
      mm8.affyGnfU74ADistance.target (via knownIsoforms.transcript)
      mm8.affyGnfU74BDistance.query (via knownIsoforms.transcript)
      mm8.affyGnfU74BDistance.target (via knownIsoforms.transcript)
      mm8.affyGnfU74CDistance.query (via knownIsoforms.transcript)
      mm8.affyGnfU74CDistance.target (via knownIsoforms.transcript)
      mm8.ccdsKgMap.geneId (via knownIsoforms.transcript)
      mm8.ceBlastTab.query (via knownIsoforms.transcript)
      mm8.dmBlastTab.query (via knownIsoforms.transcript)
      mm8.drBlastTab.query (via knownIsoforms.transcript)
      mm8.dupSpMrna.mrnaID (via knownIsoforms.transcript)
      mm8.foldUtr3.name (via knownIsoforms.transcript)
      mm8.foldUtr5.name (via knownIsoforms.transcript)
      mm8.gnfAtlas2Distance.query (via knownIsoforms.transcript)
      mm8.gnfAtlas2Distance.target (via knownIsoforms.transcript)
      mm8.hgBlastTab.query (via knownIsoforms.transcript)
      mm8.keggPathway.kgID (via knownIsoforms.transcript)
      mm8.kgAlias.kgID (via knownIsoforms.transcript)
      mm8.kgProtAlias.kgID (via knownIsoforms.transcript)
      mm8.kgSpAlias.kgID (via knownIsoforms.transcript)
      mm8.kgTargetAli.qName (via knownIsoforms.transcript)
      mm8.kgXref.kgID (via knownIsoforms.transcript)
      mm8.knownBlastTab.query (via knownIsoforms.transcript)
      mm8.knownBlastTab.target (via knownIsoforms.transcript)
      mm8.knownCanonical.transcript (via knownIsoforms.transcript)
      mm8.knownGene.name (via knownIsoforms.transcript)
      mm8.knownGeneMrna.name (via knownIsoforms.transcript)
      mm8.knownGenePep.name (via knownIsoforms.transcript)
      mm8.knownToAllenBrain.name (via knownIsoforms.transcript)
      mm8.knownToEnsembl.name (via knownIsoforms.transcript)
      mm8.knownToGnfAtlas2.name (via knownIsoforms.transcript)
      mm8.knownToKeggEntrez.name (via knownIsoforms.transcript)
      mm8.knownToLocusLink.name (via knownIsoforms.transcript)
      mm8.knownToPfam.name (via knownIsoforms.transcript)
      mm8.knownToRefSeq.name (via knownIsoforms.transcript)
      mm8.knownToSuper.gene (via knownIsoforms.transcript)
      mm8.knownToVisiGene.name (via knownIsoforms.transcript)
      mm8.rnBlastTab.query (via knownIsoforms.transcript)
      mm8.scBlastTab.query (via knownIsoforms.transcript)

Sample Rows
 
clusterIdtranscript
1NM_030175
2NM_001030293
3NM_153523
4NM_001037925
5NM_172505
5BC100378
6AK002489
6NM_027861
7AK015946
7NM_026136

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