Schema for knownIsoforms
  Database: rn3    Primary Table: knownIsoforms    Row Count: 8,341   Data last updated: 2004-04-07
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 AY389467varchar(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)
      rn3.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)
      rn3.dmBlastTab.query (via knownIsoforms.transcript)
      rn3.drBlastTab.query (via knownIsoforms.transcript)
      rn3.dupSpMrna.mrnaID (via knownIsoforms.transcript)
      rn3.gnfAtlas2Distance.query (via knownIsoforms.transcript)
      rn3.gnfAtlas2Distance.target (via knownIsoforms.transcript)
      rn3.hgBlastTab.query (via knownIsoforms.transcript)
      rn3.keggPathway.kgID (via knownIsoforms.transcript)
      rn3.kgAlias.kgID (via knownIsoforms.transcript)
      rn3.kgProtAlias.kgID (via knownIsoforms.transcript)
      rn3.kgSpAlias.kgID (via knownIsoforms.transcript)
      rn3.kgXref.kgID (via knownIsoforms.transcript)
      rn3.knownBlastTab.query (via knownIsoforms.transcript)
      rn3.knownBlastTab.target (via knownIsoforms.transcript)
      rn3.knownCanonical.transcript (via knownIsoforms.transcript)
      rn3.knownGene.name (via knownIsoforms.transcript)
      rn3.knownGeneLink.name (via knownIsoforms.transcript)
      rn3.knownGeneMrna.name (via knownIsoforms.transcript)
      rn3.knownGenePep.name (via knownIsoforms.transcript)
      rn3.knownToEnsembl.name (via knownIsoforms.transcript)
      rn3.knownToGnfAtlas2.name (via knownIsoforms.transcript)
      rn3.knownToLocusLink.name (via knownIsoforms.transcript)
      rn3.knownToPfam.name (via knownIsoforms.transcript)
      rn3.knownToRefSeq.name (via knownIsoforms.transcript)
      rn3.knownToSuper.gene (via knownIsoforms.transcript)
      rn3.scBlastTab.query (via knownIsoforms.transcript)

Sample Rows
 
clusterIdtranscript
1AY389467
2AF347030
3U72620
4M65251
4D37951
5U37058
6AF361476
7U15425
8BC062039
8U68272

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