Schema for arbExpDistance

Database: dm1 Primary Table: arbExpDistance Row Count: 4,342,000 Data last updated: 2005-01-09
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

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

Connected Tables and Joining Fields


	dm1.bdgpBlastTab.query (via arbExpDistance.query) dm1.bdgpBlastTab.target (via arbExpDistance.query) dm1.bdgpCanonical.transcript (via arbExpDistance.query) dm1.bdgpGene.name (via arbExpDistance.query) dm1.bdgpGenePep.name (via arbExpDistance.query) dm1.bdgpIsoforms.transcript (via arbExpDistance.query) dm1.bdgpSwissProt.bdgpName (via arbExpDistance.query) dm1.bdgpToCanonical.name (via arbExpDistance.query) dm1.bdgpToLocusLink.name (via arbExpDistance.query) dm1.bdgpToPfam.name (via arbExpDistance.query) dm1.bdgpToRefSeq.name (via arbExpDistance.query) dm1.blastFBPep00.name (via arbExpDistance.query) dm1.drBlastTab.query (via arbExpDistance.query) dm1.fbTranscript.transcriptId (via arbExpDistance.query) dm1.hgBlastTab.query (via arbExpDistance.query) dm1.pscreen.geneIds (via arbExpDistance.query) dm1.scBlastTab.query (via arbExpDistance.query)

Sample Rows

query	target	distance
CG3152-RA	CG3152-RA	0
CG3152-RA	CG1554-RA	0.193933
CG3152-RA	CG3061-RA	0.35488
CG3152-RA	CG14789-RA	0.358711
CG3152-RA	CG7206-RB	0.370829
CG3152-RA	CG3051-RC	0.375105
CG3152-RA	CG4184-RA	0.379079
CG3152-RA	CG1231-RA	0.388465
CG3152-RA	CG9159-RA	0.388987
CG3152-RA	CG10808-RA	0.391237

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