Database: hg19    Primary Table: humanHprdP2P    Row Count: 19,597,437
Format description: Distance between two genes in expression space.

field	example	SQL type	description
query	uc002nxp.2	varchar(255)	Name of one gene
target	uc002nxp.2	varchar(255)	Name of other gene
distance	0	float	Distance in expression space, always >= 0

      hg19.bioCycPathway.kgID (via humanHprdP2P.query)
      hg19.ccdsKgMap.geneId (via humanHprdP2P.query)
      hg19.ceBlastTab.query (via humanHprdP2P.query)
      hg19.dmBlastTab.query (via humanHprdP2P.query)
      hg19.drBlastTab.query (via humanHprdP2P.query)
      hg19.foldUtr3.name (via humanHprdP2P.query)
      hg19.foldUtr5.name (via humanHprdP2P.query)
      hg19.gnfAtlas2Distance.query (via humanHprdP2P.query)
      hg19.gnfAtlas2Distance.target (via humanHprdP2P.query)
      hg19.humanVidalP2P.query (via humanHprdP2P.query)
      hg19.humanVidalP2P.target (via humanHprdP2P.query)
      hg19.humanWankerP2P.query (via humanHprdP2P.query)
      hg19.humanWankerP2P.target (via humanHprdP2P.query)
      hg19.keggPathway.kgID (via humanHprdP2P.query)
      hg19.kg4ToKg5.newId (via humanHprdP2P.query)
      hg19.kgAlias.kgID (via humanHprdP2P.query)
      hg19.kgColor.kgID (via humanHprdP2P.query)
      hg19.kgProtAlias.kgID (via humanHprdP2P.query)
      hg19.kgProtMap2.qName (via humanHprdP2P.query)
      hg19.kgSpAlias.kgID (via humanHprdP2P.query)
      hg19.kgTargetAli.qName (via humanHprdP2P.query)
      hg19.kgTxInfo.name (via humanHprdP2P.query)
      hg19.kgXref.kgID (via humanHprdP2P.query)
      hg19.knownBlastTab.query (via humanHprdP2P.query)
      hg19.knownBlastTab.target (via humanHprdP2P.query)
      hg19.knownCanonical.protein (via humanHprdP2P.query)
      hg19.knownCanonical.transcript (via humanHprdP2P.query)
      hg19.knownGene.name (via humanHprdP2P.query)
      hg19.knownGeneMrna.name (via humanHprdP2P.query)
      hg19.knownGenePep.name (via humanHprdP2P.query)
      hg19.knownIsoforms.transcript (via humanHprdP2P.query)
      hg19.knownToAllenBrain.name (via humanHprdP2P.query)
      hg19.knownToEnsembl.name (via humanHprdP2P.query)
      hg19.knownToGnfAtlas2.name (via humanHprdP2P.query)
      hg19.knownToHprd.name (via humanHprdP2P.query)
      hg19.knownToLocusLink.name (via humanHprdP2P.query)
      hg19.knownToPfam.name (via humanHprdP2P.query)
      hg19.knownToRefSeq.name (via humanHprdP2P.query)
      hg19.knownToSuper.gene (via humanHprdP2P.query)
      hg19.knownToTreefam.name (via humanHprdP2P.query)
      hg19.knownToU133.name (via humanHprdP2P.query)
      hg19.knownToVisiGene.name (via humanHprdP2P.query)
      hg19.mmBlastTab.query (via humanHprdP2P.query)
      hg19.rnBlastTab.query (via humanHprdP2P.query)
      hg19.scBlastTab.query (via humanHprdP2P.query)
      hg19.knownToHprd.name (via humanHprdP2P.target)

query	target	distance
uc002nxp.2	uc002nxp.2	0
uc002nxp.2	uc002nxo.1	0
uc002nxo.1	uc002nxp.2	0
uc002nxo.1	uc002nxo.1	0
uc002nxp.2	uc001psf.2	1
uc002nxo.1	uc001psf.2	1
uc002nxp.2	uc011crb.1	2
uc002nxp.2	uc003jve.2	2
uc002nxp.2	uc003jvd.2	2
uc002nxp.2	uc003jvc.2	2

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