Schema for arbExpDistance

Database: dm3 Primary Table: arbExpDistance Row Count: 7,816,000 Data last updated: 2008-10-21
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

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

Connected Tables and Joining Fields


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

Sample Rows

query	target	distance
CG3625-RC	CG3625-RC	0
CG3625-RC	CG3625-RB	0
CG3625-RC	CG3625-RA	0
CG3625-RC	CG6746-RA	0.630829
CG3625-RC	CG16705-RA	0.650803
CG3625-RC	CG15319-RB	0.659184
CG3625-RC	CG1558-RA	0.722829
CG3625-RC	CG6446-RB	0.737013
CG3625-RC	CG6446-RA	0.737013
CG3625-RC	CG13917-RA	0.741263

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