Schema for knownIsoforms
  Database: hg18    Primary Table: knownIsoforms    Row Count: 66,803   Data last updated: 2009-03-03
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(11) range Unique id for transcript cluster (aka gene)
transcript uc009vip.1varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

Connected Tables and Joining Fields
        hg18.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownIsoforms.clusterId)
      hg18.bioCycPathway.kgID (via knownIsoforms.transcript)
      hg18.ccdsKgMap.geneId (via knownIsoforms.transcript)
      hg18.ceBlastTab.query (via knownIsoforms.transcript)
      hg18.dmBlastTab.query (via knownIsoforms.transcript)
      hg18.drBlastTab.query (via knownIsoforms.transcript)
      hg18.foldUtr3.name (via knownIsoforms.transcript)
      hg18.foldUtr5.name (via knownIsoforms.transcript)
      hg18.gnfAtlas2Distance.query (via knownIsoforms.transcript)
      hg18.gnfAtlas2Distance.target (via knownIsoforms.transcript)
      hg18.gnfU95Distance.query (via knownIsoforms.transcript)
      hg18.gnfU95Distance.target (via knownIsoforms.transcript)
      hg18.humanHprdP2P.query (via knownIsoforms.transcript)
      hg18.humanHprdP2P.target (via knownIsoforms.transcript)
      hg18.humanVidalP2P.query (via knownIsoforms.transcript)
      hg18.humanVidalP2P.target (via knownIsoforms.transcript)
      hg18.humanWankerP2P.query (via knownIsoforms.transcript)
      hg18.humanWankerP2P.target (via knownIsoforms.transcript)
      hg18.keggPathway.kgID (via knownIsoforms.transcript)
      hg18.kgAlias.kgID (via knownIsoforms.transcript)
      hg18.kgColor.kgID (via knownIsoforms.transcript)
      hg18.kgProtAlias.kgID (via knownIsoforms.transcript)
      hg18.kgProtMap2.qName (via knownIsoforms.transcript)
      hg18.kgSpAlias.kgID (via knownIsoforms.transcript)
      hg18.kgTargetAli.qName (via knownIsoforms.transcript)
      hg18.kgTxInfo.name (via knownIsoforms.transcript)
      hg18.kgXref.kgID (via knownIsoforms.transcript)
      hg18.knownBlastTab.query (via knownIsoforms.transcript)
      hg18.knownBlastTab.target (via knownIsoforms.transcript)
      hg18.knownCanonToDecipher.name (via knownIsoforms.transcript)
      hg18.knownCanonical.protein (via knownIsoforms.transcript)
      hg18.knownCanonical.transcript (via knownIsoforms.transcript)
      hg18.knownGene.name (via knownIsoforms.transcript)
      hg18.knownGeneMrna.name (via knownIsoforms.transcript)
      hg18.knownGenePep.name (via knownIsoforms.transcript)
      hg18.knownToAllenBrain.name (via knownIsoforms.transcript)
      hg18.knownToDecipher.name (via knownIsoforms.transcript)
      hg18.knownToEnsembl.name (via knownIsoforms.transcript)
      hg18.knownToGnf1h.name (via knownIsoforms.transcript)
      hg18.knownToGnfAtlas2.name (via knownIsoforms.transcript)
      hg18.knownToHInv.name (via knownIsoforms.transcript)
      hg18.knownToHprd.name (via knownIsoforms.transcript)
      hg18.knownToKeggEntrez.name (via knownIsoforms.transcript)
      hg18.knownToLocusLink.name (via knownIsoforms.transcript)
      hg18.knownToMupit.name (via knownIsoforms.transcript)
      hg18.knownToPfam.name (via knownIsoforms.transcript)
      hg18.knownToRefSeq.name (via knownIsoforms.transcript)
      hg18.knownToSuper.gene (via knownIsoforms.transcript)
      hg18.knownToTreefam.name (via knownIsoforms.transcript)
      hg18.knownToU133.name (via knownIsoforms.transcript)
      hg18.knownToU133Plus2.name (via knownIsoforms.transcript)
      hg18.knownToU95.name (via knownIsoforms.transcript)
      hg18.knownToVisiGene.name (via knownIsoforms.transcript)
      hg18.mmBlastTab.query (via knownIsoforms.transcript)
      hg18.rnBlastTab.query (via knownIsoforms.transcript)
      hg18.scBlastTab.query (via knownIsoforms.transcript)
      hg18.ucscScop.ucscId (via knownIsoforms.transcript)
      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)

Sample Rows
 
clusterIdtranscript
1uc009vip.1
1uc001aaa.2
2uc009vis.1
2uc001aae.2
2uc009viu.1
2uc009vit.1
2uc001aab.2
2uc001aac.2
2uc009vir.1
2uc009viq.1

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