Schema for knownIsoforms
  Database: hg16    Primary Table: knownIsoforms    Row Count: 43,164   Data last updated: 2004-03-29
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 AK128780varchar(255) values Corresponds to name in knownGene table, transcript in knownCanonical

Connected Tables and Joining Fields
        hg16.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.knownCanonical.clusterId (via knownIsoforms.clusterId)
      knownGeneV39.knownIsoforms.clusterId (via knownIsoforms.clusterId)
      hg16.bioCycPathway.kgID (via knownIsoforms.transcript)
      hg16.dmBlastTab.query (via knownIsoforms.transcript)
      hg16.drBlastTab.query (via knownIsoforms.transcript)
      hg16.dupSpMrna.mrnaID (via knownIsoforms.transcript)
      hg16.foldUtr3.name (via knownIsoforms.transcript)
      hg16.foldUtr5.name (via knownIsoforms.transcript)
      hg16.gnfAtlas2Distance.query (via knownIsoforms.transcript)
      hg16.gnfAtlas2Distance.target (via knownIsoforms.transcript)
      hg16.gnfU95Distance.query (via knownIsoforms.transcript)
      hg16.gnfU95Distance.target (via knownIsoforms.transcript)
      hg16.hg17Kg.name (via knownIsoforms.transcript)
      hg16.keggPathway.kgID (via knownIsoforms.transcript)
      hg16.kgAlias.kgID (via knownIsoforms.transcript)
      hg16.kgProtAlias.kgID (via knownIsoforms.transcript)
      hg16.kgXref.kgID (via knownIsoforms.transcript)
      hg16.knownBlastTab.query (via knownIsoforms.transcript)
      hg16.knownBlastTab.target (via knownIsoforms.transcript)
      hg16.knownCanonical.transcript (via knownIsoforms.transcript)
      hg16.knownGene.name (via knownIsoforms.transcript)
      hg16.knownGeneLink.name (via knownIsoforms.transcript)
      hg16.knownGeneMrna.name (via knownIsoforms.transcript)
      hg16.knownGenePep.name (via knownIsoforms.transcript)
      hg16.knownToEnsembl.name (via knownIsoforms.transcript)
      hg16.knownToGnfAtlas2.name (via knownIsoforms.transcript)
      hg16.knownToHInv.name (via knownIsoforms.transcript)
      hg16.knownToLocusLink.name (via knownIsoforms.transcript)
      hg16.knownToPfam.name (via knownIsoforms.transcript)
      hg16.knownToRefSeq.name (via knownIsoforms.transcript)
      hg16.knownToSuper.gene (via knownIsoforms.transcript)
      hg16.knownToU133.name (via knownIsoforms.transcript)
      hg16.knownToU95.name (via knownIsoforms.transcript)
      hg16.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
1AK128780
2BC031359
3AK097327
4BC015393
5AK093438
5AK124125
6AY050570
7BC015549
8AF116687
9AK093239

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