Division

Stores the GenBank Division and the NCBI three letter code for records originating from GenBank. NCBI uses Divisions to organize GenBank records according to two definitions: some divisions are based on taxonomy (e.g., the "BCT" division), whereas other divisions exist purely for data organization reasons (e.g., the "CON" division, whose records store instructions for the construction of large contigs). Sequences from different GenBank divisions vary substantially in quality based upon the way they were generated, e.g., single-pass genomic sequencing, ESTs (low quality, single-pass sequencing), cDNAs (high coverage sequencing) and genomic sequencing (moderate coverage sequencing). All BioWarehouse records associated with a GenBank dataset also have a record in the Division table.

Columns

Column	MySQL Type	Oracle Type	Nullable	Description
WID	BIGINT	NUMBER	No	Warehouse ID for this Division.
Code	VARCHAR	VARCHAR2(10)	Yes	Genbank Division code (3 characters) which is an abbreviation for the GenBank Name.
Name	VARCHAR	VARCHAR2(100)	Yes	Division name.
DataSetWID	BIGINT	NUMBER	No	Reference to the data set from which the entity came from.

Referenced By

Table	Column
Taxon	DivisionWID
Entry	OtherWID
RelatedTerm	OtherWID
CitationWIDOtherWID	OtherWID
CommentTable	OtherWID
CrossReference	OtherWID
CrossReference	CrossWID
Description	OtherWID
DBID	OtherWID
SynonymTable	OtherWID
ToolAdvice	OtherWID

Other Constraints

None.

Indexes

Name	Columns
DIVISION_NAME	NAME
DIVISION_DIVCODE	CODE
DIVISION_DATASETWID	DATASETWID