Schema for gnfAtlas2RgdGene2Distance

Database: rn4 Primary Table: gnfAtlas2RgdGene2Distance Row Count: 3,818,000 Data last updated: 2010-10-19
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

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

Connected Tables and Joining Fields


	rn4.affyExonTissuesGsMedianDistRgdGene2.query (via gnfAtlas2RgdGene2Distance.query) rn4.affyExonTissuesGsMedianDistRgdGene2.target (via gnfAtlas2RgdGene2Distance.query) rn4.affyExonTissuesGsMedianRgdGene2.name (via gnfAtlas2RgdGene2Distance.query) rn4.affyExonTissuesGsRgdGene2.name (via gnfAtlas2RgdGene2Distance.query) rn4.ceBlastTab.query (via gnfAtlas2RgdGene2Distance.query) rn4.dmBlastTab.query (via gnfAtlas2RgdGene2Distance.query) rn4.drBlastTab.query (via gnfAtlas2RgdGene2Distance.query) rn4.hgBlastTab.query (via gnfAtlas2RgdGene2Distance.query) rn4.mmBlastTab.query (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2BlastTab.query (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2BlastTab.target (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2Canonical.transcript (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2Isoforms.transcript (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2KeggPathway.rgdId (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2Pep.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToDescription.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToDisplayId.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToEnsembl.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToGenbank.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToGenbankAll.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToGnfAtlas2.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToKeggEntrez.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToLocusLink.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToPDB.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToPfam.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToRAE230.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToRefSeq.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToSymbol.rgdId (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToU34A.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2ToUniProt.name (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGene2Xref.rgdGeneId (via gnfAtlas2RgdGene2Distance.query) rn4.rgdGenePathway.geneId (via gnfAtlas2RgdGene2Distance.query) rn4.scBlastTab.query (via gnfAtlas2RgdGene2Distance.query)

Sample Rows

query	target	distance
RGD:631416	RGD:631416	0
RGD:631416	RGD:61946	0.432568
RGD:631416	RGD:1310002	0.442955
RGD:631416	RGD:67399	0.447182
RGD:631416	RGD:1307137	0.447205
RGD:631416	RGD:2290	0.449659
RGD:631416	RGD:61856	0.450159
RGD:631416	RGD:1310890	0.453023
RGD:631416	RGD:620615	0.457864
RGD:631416	RGD:708540	0.463886

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