Database: hg19    Primary Table: gnfAtlas2Distance    Row Count: 63,443,000
Format description: Distance between two genes in expression space.

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

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

query	target	distance
uc003nru.2	uc003nru.2	0
uc003nru.2	uc011faf.1	0
uc003nru.2	uc011guu.1	0
uc003nru.2	uc011ikt.1	0
uc003nru.2	uc011fyr.1	0
uc003nru.2	uc003nrv.2	0.203291
uc003nru.2	uc011fah.1	0.203291
uc003nru.2	uc011guw.1	0.203291
uc003nru.2	uc011ikv.1	0.203291
uc003nru.2	uc011fyt.1	0.203291

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