Schema for humanVidalP2P
  Database: hg17    Primary Table: humanVidalP2P    Row Count: 259,184   Data last updated: 2006-05-04
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query NM_015530varchar(255) values Query gene. Indexed
target NM_015530varchar(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 humanVidalP2P.query)
      hg17.ccdsKgMap.geneId (via humanVidalP2P.query)
      hg17.ceBlastTab.query (via humanVidalP2P.query)
      hg17.dmBlastTab.query (via humanVidalP2P.query)
      hg17.drBlastTab.query (via humanVidalP2P.query)
      hg17.dupSpMrna.mrnaID (via humanVidalP2P.query)
      hg17.foldUtr3.name (via humanVidalP2P.query)
      hg17.foldUtr5.name (via humanVidalP2P.query)
      hg17.gladHumESDistance.query (via humanVidalP2P.query)
      hg17.gladHumESDistance.target (via humanVidalP2P.query)
      hg17.gnfAtlas2Distance.query (via humanVidalP2P.query)
      hg17.gnfAtlas2Distance.target (via humanVidalP2P.query)
      hg17.gnfU95Distance.query (via humanVidalP2P.query)
      hg17.gnfU95Distance.target (via humanVidalP2P.query)
      hg17.humanHprdP2P.query (via humanVidalP2P.query)
      hg17.humanHprdP2P.target (via humanVidalP2P.query)
      hg17.humanWankerP2P.query (via humanVidalP2P.query)
      hg17.humanWankerP2P.target (via humanVidalP2P.query)
      hg17.keggPathway.kgID (via humanVidalP2P.query)
      hg17.kgAlias.kgID (via humanVidalP2P.query)
      hg17.kgProtAlias.kgID (via humanVidalP2P.query)
      hg17.kgSpAlias.kgID (via humanVidalP2P.query)
      hg17.kgTargetAli.qName (via humanVidalP2P.query)
      hg17.kgXref.kgID (via humanVidalP2P.query)
      hg17.knownBlastTab.query (via humanVidalP2P.query)
      hg17.knownBlastTab.target (via humanVidalP2P.query)
      hg17.knownCanonical.transcript (via humanVidalP2P.query)
      hg17.knownExpDistance.query (via humanVidalP2P.query)
      hg17.knownExpDistance.target (via humanVidalP2P.query)
      hg17.knownGene.name (via humanVidalP2P.query)
      hg17.knownGeneLink.name (via humanVidalP2P.query)
      hg17.knownGeneMrna.name (via humanVidalP2P.query)
      hg17.knownGenePep.name (via humanVidalP2P.query)
      hg17.knownIsoforms.transcript (via humanVidalP2P.query)
      hg17.knownToAllenBrain.name (via humanVidalP2P.query)
      hg17.knownToEnsembl.name (via humanVidalP2P.query)
      hg17.knownToGnf1h.name (via humanVidalP2P.query)
      hg17.knownToGnfAtlas2.name (via humanVidalP2P.query)
      hg17.knownToHInv.name (via humanVidalP2P.query)
      hg17.knownToHprd.name (via humanVidalP2P.query)
      hg17.knownToKeggEntrez.name (via humanVidalP2P.query)
      hg17.knownToLocusLink.name (via humanVidalP2P.query)
      hg17.knownToPfam.name (via humanVidalP2P.query)
      hg17.knownToRefSeq.name (via humanVidalP2P.query)
      hg17.knownToSuper.gene (via humanVidalP2P.query)
      hg17.knownToU133.name (via humanVidalP2P.query)
      hg17.knownToU133Plus2.name (via humanVidalP2P.query)
      hg17.knownToU95.name (via humanVidalP2P.query)
      hg17.knownToVisiGene.name (via humanVidalP2P.query)
      hg17.mmBlastTab.query (via humanVidalP2P.query)
      hg17.rankProp.query (via humanVidalP2P.query)
      hg17.rankProp.target (via humanVidalP2P.query)
      hg17.rnBlastTab.query (via humanVidalP2P.query)
      hg17.scBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.bioCycPathway.kgID (via humanVidalP2P.query)
      knownGeneV39.ceBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.dmBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.drBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.foldUtr3.name (via humanVidalP2P.query)
      knownGeneV39.foldUtr5.name (via humanVidalP2P.query)
      knownGeneV39.gnfAtlas2Distance.query (via humanVidalP2P.query)
      knownGeneV39.gnfAtlas2Distance.target (via humanVidalP2P.query)
      knownGeneV39.kgAlias.kgID (via humanVidalP2P.query)
      knownGeneV39.kgColor.kgID (via humanVidalP2P.query)
      knownGeneV39.kgProtAlias.kgID (via humanVidalP2P.query)
      knownGeneV39.kgSpAlias.kgID (via humanVidalP2P.query)
      knownGeneV39.kgTargetAli.qName (via humanVidalP2P.query)
      knownGeneV39.kgXref.kgID (via humanVidalP2P.query)
      knownGeneV39.knownAttrs.kgID (via humanVidalP2P.query)
      knownGeneV39.knownBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.knownBlastTab.target (via humanVidalP2P.query)
      knownGeneV39.knownCanonical.protein (via humanVidalP2P.query)
      knownGeneV39.knownCanonical.transcript (via humanVidalP2P.query)
      knownGeneV39.knownCds.name (via humanVidalP2P.query)
      knownGeneV39.knownGene.name (via humanVidalP2P.query)
      knownGeneV39.knownGeneMrna.name (via humanVidalP2P.query)
      knownGeneV39.knownGenePep.name (via humanVidalP2P.query)
      knownGeneV39.knownIsoforms.transcript (via humanVidalP2P.query)
      knownGeneV39.knownToEnsembl.name (via humanVidalP2P.query)
      knownGeneV39.knownToGnfAtlas2.name (via humanVidalP2P.query)
      knownGeneV39.knownToHprd.name (via humanVidalP2P.query)
      knownGeneV39.knownToLocusLink.name (via humanVidalP2P.query)
      knownGeneV39.knownToMrna.name (via humanVidalP2P.query)
      knownGeneV39.knownToMrnaSingle.name (via humanVidalP2P.query)
      knownGeneV39.knownToMupit.name (via humanVidalP2P.query)
      knownGeneV39.knownToPfam.name (via humanVidalP2P.query)
      knownGeneV39.knownToRefSeq.name (via humanVidalP2P.query)
      knownGeneV39.knownToSuper.gene (via humanVidalP2P.query)
      knownGeneV39.knownToTag.name (via humanVidalP2P.query)
      knownGeneV39.knownToU133.name (via humanVidalP2P.query)
      knownGeneV39.knownToU95.name (via humanVidalP2P.query)
      knownGeneV39.knownToVisiGene.name (via humanVidalP2P.query)
      knownGeneV39.knownToWikipedia.name (via humanVidalP2P.query)
      knownGeneV39.mmBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.rnBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.scBlastTab.query (via humanVidalP2P.query)
      knownGeneV39.ucscScop.ucscId (via humanVidalP2P.query)

Sample Rows
 
querytargetdistance
NM_015530NM_0155300
NM_015530NM_0309351
NM_015530NM_0147022
NM_015530NM_0211381
NM_015530NM_0312992
NM_015530NM_0058312
NM_015530NM_0210612
NM_015530NM_0581932
NM_015530NM_0121012
NM_015530NM_0038582

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