Schema for gbSeq

Schema for gbSeq

Database: bosTau4 Primary Table: gbSeq Row Count: 3,145,129

field	example	SQL type
`id`	1	`int unsigned`
`acc`	AB004856	`char(12)`
`version`	1	`smallint unsigned`
`size`	297	`int unsigned`
`gbExtFile`	1251	`int unsigned`
`file_offset`	8881	`bigint`
`file_size`	315	`int unsigned`
`type`	mRNA	`enum('EST','mRNA','PEP')`
`srcDb`	GenBank	`enum('GenBank','RefSeq','Other')`

Connected Tables and Joining Fields


	bosTau4.all_est.qName (via gbSeq.acc) bosTau4.all_mrna.qName (via gbSeq.acc) bosTau4.estOrientInfo.name (via gbSeq.acc) bosTau4.gbCdnaInfo.acc (via gbSeq.acc) bosTau4.gbStatus.acc (via gbSeq.acc) bosTau4.imageClone.acc (via gbSeq.acc) bosTau4.intronEst.qName (via gbSeq.acc) bosTau4.mgcFullMrna.qName (via gbSeq.acc) bosTau4.mgcGenes.name (via gbSeq.acc) bosTau4.mrnaOrientInfo.name (via gbSeq.acc) bosTau4.refFlat.name (via gbSeq.acc) bosTau4.refGene.name (via gbSeq.acc) bosTau4.refLink.mrnaAcc (via gbSeq.acc) bosTau4.refSeqAli.qName (via gbSeq.acc) bosTau4.refSeqStatus.mrnaAcc (via gbSeq.acc) bosTau4.refSeqSummary.mrnaAcc (via gbSeq.acc) bosTau4.xenoMrna.qName (via gbSeq.acc) bosTau4.gbExtFile.id (via gbSeq.gbExtFile)

Sample Rows

id	acc	version	size	gbExtFile	file_offset	file_size	type	srcDb
1	AB004856	1	297	1251	8881	315	mRNA	GenBank
2	AB005263	1	143	1251	9196	158	mRNA	GenBank
3	AB011407	1	431	1251	9650	452	mRNA	GenBank
4	AB012144	1	1131	1251	10102	1166	mRNA	GenBank
5	AB012145	1	1109	1251	11268	1144	mRNA	GenBank
6	AB017109	1	4347	1251	23502	4446	mRNA	GenBank
7	AB019621	1	652	1251	32496	678	mRNA	GenBank
8	AB026157	2	1621	1251	43544	1666	mRNA	GenBank
9	AB027742	1	430	1251	45210	451	mRNA	GenBank
10	AB027743	1	430	1251	45661	451	mRNA	GenBank

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