Schema for knownToTreefam
  Database: hg19    Primary Table: knownToTreefam    Row Count: 41,347   Data last updated: 2012-01-22
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 uc011mfh.2varchar(255) values primary ID
value TF353096varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToTreefam.name)
      hg19.ceBlastTab.query (via knownToTreefam.name)
      hg19.dmBlastTab.query (via knownToTreefam.name)
      hg19.drBlastTab.query (via knownToTreefam.name)
      hg19.foldUtr3.name (via knownToTreefam.name)
      hg19.foldUtr5.name (via knownToTreefam.name)
      hg19.gnfAtlas2Distance.query (via knownToTreefam.name)
      hg19.gnfAtlas2Distance.target (via knownToTreefam.name)
      hg19.gnfU95Distance.query (via knownToTreefam.name)
      hg19.gnfU95Distance.target (via knownToTreefam.name)
      hg19.humanHprdP2P.query (via knownToTreefam.name)
      hg19.humanHprdP2P.target (via knownToTreefam.name)
      hg19.humanVidalP2P.query (via knownToTreefam.name)
      hg19.humanVidalP2P.target (via knownToTreefam.name)
      hg19.humanWankerP2P.query (via knownToTreefam.name)
      hg19.humanWankerP2P.target (via knownToTreefam.name)
      hg19.keggPathway.kgID (via knownToTreefam.name)
      hg19.kgAlias.kgID (via knownToTreefam.name)
      hg19.kgColor.kgID (via knownToTreefam.name)
      hg19.kgProtAlias.kgID (via knownToTreefam.name)
      hg19.kgProtMap2.qName (via knownToTreefam.name)
      hg19.kgSpAlias.kgID (via knownToTreefam.name)
      hg19.kgTargetAli.qName (via knownToTreefam.name)
      hg19.kgTxInfo.name (via knownToTreefam.name)
      hg19.kgXref.kgID (via knownToTreefam.name)
      hg19.knownAttrs.kgID (via knownToTreefam.name)
      hg19.knownBlastTab.query (via knownToTreefam.name)
      hg19.knownBlastTab.target (via knownToTreefam.name)
      hg19.knownCanonToDecipher.name (via knownToTreefam.name)
      hg19.knownCanonical.transcript (via knownToTreefam.name)
      hg19.knownCds.name (via knownToTreefam.name)
      hg19.knownGene.name (via knownToTreefam.name)
      hg19.knownGeneMrna.name (via knownToTreefam.name)
      hg19.knownGenePep.name (via knownToTreefam.name)
      hg19.knownGeneTxMrna.name (via knownToTreefam.name)
      hg19.knownGeneTxPep.name (via knownToTreefam.name)
      hg19.knownIsoforms.transcript (via knownToTreefam.name)
      hg19.knownToAllenBrain.name (via knownToTreefam.name)
      hg19.knownToDecipher.name (via knownToTreefam.name)
      hg19.knownToEnsembl.name (via knownToTreefam.name)
      hg19.knownToGnfAtlas2.name (via knownToTreefam.name)
      hg19.knownToHInv.name (via knownToTreefam.name)
      hg19.knownToHprd.name (via knownToTreefam.name)
      hg19.knownToKeggEntrez.name (via knownToTreefam.name)
      hg19.knownToLocusLink.name (via knownToTreefam.name)
      hg19.knownToLynx.name (via knownToTreefam.name)
      hg19.knownToMrna.name (via knownToTreefam.name)
      hg19.knownToMrnaSingle.name (via knownToTreefam.name)
      hg19.knownToMupit.name (via knownToTreefam.name)
      hg19.knownToNextProt.name (via knownToTreefam.name)
      hg19.knownToPfam.name (via knownToTreefam.name)
      hg19.knownToRefSeq.name (via knownToTreefam.name)
      hg19.knownToSuper.gene (via knownToTreefam.name)
      hg19.knownToTag.name (via knownToTreefam.name)
      hg19.knownToU133.name (via knownToTreefam.name)
      hg19.knownToU133Plus2.name (via knownToTreefam.name)
      hg19.knownToU95.name (via knownToTreefam.name)
      hg19.knownToVisiGene.name (via knownToTreefam.name)
      hg19.knownToWikipedia.name (via knownToTreefam.name)
      hg19.mmBlastTab.query (via knownToTreefam.name)
      hg19.rnBlastTab.query (via knownToTreefam.name)
      hg19.scBlastTab.query (via knownToTreefam.name)
      hg19.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
uc011mfh.2TF353096
uc011mfi.2TF344269
uc022bqu.1TF343336
uc004cov.4TF343520
uc004cox.4TF342974
uc022bqw.1TF353091
uc011mfg.1TF316874
uc004con.1TF316874
uc002qvo.3TF333211
uc021vde.1TF351864

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