Database: hg19    Primary Table: humanVidalP2P    Row Count: 586,182
Format description: Distance between two genes in expression space.

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

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

query	target	distance
uc004cwy.3	uc004cwy.3	0
uc004cwy.3	uc004cwx.3	0
uc004cwx.3	uc004cwy.3	0
uc004cwx.3	uc004cwx.3	0
uc004cwy.3	uc003mkc.1	1
uc004cwy.3	uc003mkb.1	1
uc004cwy.3	uc003mka.1	1
uc004cwx.3	uc003mkc.1	1
uc004cwx.3	uc003mkb.1	1
uc004cwx.3	uc003mka.1	1

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