Schema for humanWankerP2P
  Database: hg17    Primary Table: humanWankerP2P    Row Count: 121,786   Data last updated: 2006-05-15
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query NM_078469varchar(255) values Query gene. Indexed
target NM_078469varchar(255) values Target gene. Not indexed
distance 0float range Distance between two, possibly in some expression space

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.