Schema for knownIsoforms
  Database: hg17    Primary Table: knownIsoforms    Row Count: 38,086   Data last updated: 2005-06-04
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_018390varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

Connected Tables and Joining Fields
        hg17.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownIsoforms.clusterId)
      hg17.bioCycPathway.kgID (via knownIsoforms.transcript)
      hg17.ccdsKgMap.geneId (via knownIsoforms.transcript)
      hg17.ceBlastTab.query (via knownIsoforms.transcript)
      hg17.dmBlastTab.query (via knownIsoforms.transcript)
      hg17.drBlastTab.query (via knownIsoforms.transcript)
      hg17.dupSpMrna.mrnaID (via knownIsoforms.transcript)
      hg17.foldUtr3.name (via knownIsoforms.transcript)
      hg17.foldUtr5.name (via knownIsoforms.transcript)
      hg17.gladHumESDistance.query (via knownIsoforms.transcript)
      hg17.gladHumESDistance.target (via knownIsoforms.transcript)
      hg17.gnfAtlas2Distance.query (via knownIsoforms.transcript)
      hg17.gnfAtlas2Distance.target (via knownIsoforms.transcript)
      hg17.gnfU95Distance.query (via knownIsoforms.transcript)
      hg17.gnfU95Distance.target (via knownIsoforms.transcript)
      hg17.humanHprdP2P.query (via knownIsoforms.transcript)
      hg17.humanHprdP2P.target (via knownIsoforms.transcript)
      hg17.humanVidalP2P.query (via knownIsoforms.transcript)
      hg17.humanVidalP2P.target (via knownIsoforms.transcript)
      hg17.humanWankerP2P.query (via knownIsoforms.transcript)
      hg17.humanWankerP2P.target (via knownIsoforms.transcript)
      hg17.keggPathway.kgID (via knownIsoforms.transcript)
      hg17.kgAlias.kgID (via knownIsoforms.transcript)
      hg17.kgProtAlias.kgID (via knownIsoforms.transcript)
      hg17.kgSpAlias.kgID (via knownIsoforms.transcript)
      hg17.kgTargetAli.qName (via knownIsoforms.transcript)
      hg17.kgXref.kgID (via knownIsoforms.transcript)
      hg17.knownBlastTab.query (via knownIsoforms.transcript)
      hg17.knownBlastTab.target (via knownIsoforms.transcript)
      hg17.knownCanonical.transcript (via knownIsoforms.transcript)
      hg17.knownExpDistance.query (via knownIsoforms.transcript)
      hg17.knownExpDistance.target (via knownIsoforms.transcript)
      hg17.knownGene.name (via knownIsoforms.transcript)
      hg17.knownGeneLink.name (via knownIsoforms.transcript)
      hg17.knownGeneMrna.name (via knownIsoforms.transcript)
      hg17.knownGenePep.name (via knownIsoforms.transcript)
      hg17.knownToAllenBrain.name (via knownIsoforms.transcript)
      hg17.knownToEnsembl.name (via knownIsoforms.transcript)
      hg17.knownToGnf1h.name (via knownIsoforms.transcript)
      hg17.knownToGnfAtlas2.name (via knownIsoforms.transcript)
      hg17.knownToHInv.name (via knownIsoforms.transcript)
      hg17.knownToHprd.name (via knownIsoforms.transcript)
      hg17.knownToKeggEntrez.name (via knownIsoforms.transcript)
      hg17.knownToLocusLink.name (via knownIsoforms.transcript)
      hg17.knownToPfam.name (via knownIsoforms.transcript)
      hg17.knownToRefSeq.name (via knownIsoforms.transcript)
      hg17.knownToSuper.gene (via knownIsoforms.transcript)
      hg17.knownToU133.name (via knownIsoforms.transcript)
      hg17.knownToU133Plus2.name (via knownIsoforms.transcript)
      hg17.knownToU95.name (via knownIsoforms.transcript)
      hg17.knownToVisiGene.name (via knownIsoforms.transcript)
      hg17.mmBlastTab.query (via knownIsoforms.transcript)
      hg17.rankProp.query (via knownIsoforms.transcript)
      hg17.rankProp.target (via knownIsoforms.transcript)
      hg17.rnBlastTab.query (via knownIsoforms.transcript)
      hg17.scBlastTab.query (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
1NM_018390
2NM_000451
2NM_006883
3NM_002183
4AK123701
5AK023392
6BC001620
6NM_005088
6BC028151
6NM_004043

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