Schema for humanVidalP2P

Database: hg17 Primary Table: humanVidalP2P Row Count: 259,184 Data last updated: 2006-05-04
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

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

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

query	target	distance
NM_015530	NM_015530	0
NM_015530	NM_030935	1
NM_015530	NM_014702	2
NM_015530	NM_021138	1
NM_015530	NM_031299	2
NM_015530	NM_005831	2
NM_015530	NM_021061	2
NM_015530	NM_058193	2
NM_015530	NM_012101	2
NM_015530	NM_003858	2

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