Schema for humanWankerP2P
  Database: hg17    Primary Table: humanWankerP2P    Row Count: 121,786   Data last updated: 2006-05-15
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query NM_078469varchar(255) values Name of one gene
target NM_078469varchar(255) values Name of other gene
distance 0float range Distance in expression space, always >= 0

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

Sample Rows
 
querytargetdistance
NM_078469NM_0784690
NM_078469NM_0784680
NM_078469NM_0165670
NM_078468NM_0784690
NM_078468NM_0784680
NM_078468NM_0165670
NM_016567NM_0784690
NM_016567NM_0784680
NM_016567NM_0165670
NM_078469NM_0028251

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