Schema for D. mel. cDNAs - cDNAs from D. melanogaster

Database: dm3gene Primary Table: dmel_cdna Row Count: 7

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`matches`	2194	`int(10) unsigned`	range
`misMatches`	12	`int(10) unsigned`	range
`repMatches`	0	`int(10) unsigned`	range
`nCount`	0	`int(10) unsigned`	range
`qNumInsert`	0	`int(10) unsigned`	range
`qBaseInsert`	0	`int(10) unsigned`	range
`tNumInsert`	4	`int(10) unsigned`	range
`tBaseInsert`	789	`int(10) unsigned`	range
`strand`	-	`char(2)`	values
`qName`	AY069466	`varchar(255)`	values
`qSize`	2233	`int(10) unsigned`	range
`qStart`	0	`int(10) unsigned`	range
`qEnd`	2206	`int(10) unsigned`	range
`tName`	contig1	`varchar(255)`	values
`tSize`	11000	`int(10) unsigned`	range
`tStart`	439	`int(10) unsigned`	range
`tEnd`	3434	`int(10) unsigned`	range
`blockCount`	5	`int(10) unsigned`	range
`blockSizes`	721,218,1123,110,34,	`longblob`
`qStarts`	27,748,966,2089,2199,	`longblob`
`tStarts`	439,1239,1582,2764,3400,	`longblob`

Sample Rows

bin	matches	misMatches	tNumInsert	tBaseInsert	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
585	2194	12	4	789	-	AY069466	2233	0	2206	contig1	11000	439	3434	5	721,218,1123,110,34,	27,748,966,2089,2199,	439,1239,1582,2764,3400,
585	3599	43	7	1394	-	AY095530	3680	17	3659	contig1	11000	439	5475	8	721,218,1123,110,407,716,173,174,	21,742,960,2083,2193,2600,3316,3489,	439,1239,1582,2764,3400,3866,4641,5301,
585	3600	42	7	1394	-	BT044140	3680	17	3659	contig1	11000	439	5475	8	721,218,1123,110,407,716,173,174,	21,742,960,2083,2193,2600,3316,3489,	439,1239,1582,2764,3400,3866,4641,5301,
585	2330	0	4	789	-	BT150059	2347	0	2330	contig1	11000	444	3563	5	716,218,1123,110,163,	17,733,951,2074,2184,	444,1239,1582,2764,3400,
585	3641	0	2	122	+	AF145687	3663	0	3641	contig1	11000	5932	9695	3	87,757,2797,	0,87,844,	5932,6080,6898,
585	3438	0	2	122	+	FJ630149	3472	16	3454	contig1	11000	5934	9494	3	85,757,2596,	16,101,858,	5934,6080,6898,
585	848	4	2	130	+	BT028774	885	0	852	contig1	11000	9864	10846	3	33,579,240,	0,33,612,	9864,9970,10606,

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

Description