Schema for dmBlastTab

Database: mm10 Primary Table: dmBlastTab Row Count: 6,028 Data last updated: 2019-09-20
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`query`	ENSMUST00000190686.6	`varchar(255)`	values	Name of sequence in this assembly (query)
`target`	FBtr0072807	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	49.1	`float`	range	Percent identity
`aliLength`	167	`int(10) unsigned`	range	Length of alignment
`mismatch`	78	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	4	`int(10) unsigned`	range	Number of gap openings
`qStart`	0	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	164	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	0	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	163	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	5e-27	`double`	range	Expectation value
`bitScore`	122	`double`	range	Bit score