Database: hg19    Primary Table: humanWankerP2P    Row Count: 263,064
Format description: Distance between two genes in expression space.

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

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

query	target	distance
uc002gqi.2	uc002gqi.2	0
uc002gqi.2	uc001zqr.2	1
uc002gqi.2	uc003kuz.2	2
uc002gqi.2	uc003kuy.2	2
uc002gqi.2	uc001qsa.1	2
uc002gqi.2	uc001qsb.2	2
uc002gqi.2	uc009zfl.1	2
uc002gqi.2	uc004bpn.2	2
uc002gqi.2	uc001ten.1	2
uc002gqi.2	uc003cxf.2	2

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