Schema for knownToTreefam
  Database: hg18    Primary Table: knownToTreefam    Row Count: 53,949   Data last updated: 2009-04-27
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc004fqe.1varchar(255) values primary ID
value TF300612varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc004fqe.1TF300612
uc004fqf.1TF300612
uc004fqi.1TF300612
uc010nwd.1TF335557
uc004fqj.1TF335557
uc010nwe.1TF335557
uc004fqk.1TF318093
uc010nwf.1TF318093
uc010nwg.1TF320624
uc004fql.1TF320624

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