Schema for flyP2P

Database: dm2 Primary Table: flyP2P Row Count: 2,001,243 Data last updated: 2006-02-07
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

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

Connected Tables and Joining Fields


	dm2.arbExpDistance.query (via flyP2P.query) dm2.arbExpDistance.target (via flyP2P.query) dm2.ceBlastTab.query (via flyP2P.query) dm2.drBlastTab.query (via flyP2P.query) dm2.flyBase2004Xref.name (via flyP2P.query) dm2.flyBaseBlastTab.query (via flyP2P.query) dm2.flyBaseBlastTab.target (via flyP2P.query) dm2.flyBaseCanonical.transcript (via flyP2P.query) dm2.flyBaseGene.name (via flyP2P.query) dm2.flyBaseIsoforms.transcript (via flyP2P.query) dm2.flyBaseNoncoding.name (via flyP2P.query) dm2.flyBasePep.name (via flyP2P.query) dm2.flyBaseToCG.name (via flyP2P.query) dm2.flyBaseToDescription.name (via flyP2P.query) dm2.flyBaseToPfam.name (via flyP2P.query) dm2.flyBaseToRefSeq.name (via flyP2P.query) dm2.flyBaseToUniProt.name (via flyP2P.query) dm2.hgBlastTab.query (via flyP2P.query) dm2.mmBlastTab.query (via flyP2P.query) dm2.rnBlastTab.query (via flyP2P.query) dm2.scBlastTab.query (via flyP2P.query)

Sample Rows

query	target	distance
CG2759-RA	CG2759-RA	0
CG2759-RA	CG7803-RA	1
CG2759-RA	CG8573-RB	1
CG2759-RA	CG8573-RA	1
CG2759-RA	CG3757-RA	1
CG2759-RA	CG3936-RA	2
CG2759-RA	CG6502-RA	1
CG2759-RA	CG4654-RB	2
CG2759-RA	CG4654-RA	2
CG2759-RA	CG6376-RC	2

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