BIP-Align Step 2 - Table Loading

In Step 2 of Bip-Align, the data from separate data sources is loaded into the database. The clone table and cds table are partially populated in this step. The following fields are populated in this step:

Clone Table:	CDS Table:
clone_id	clone_id
organism	clone_beg
data_source	clone_end
clone_length
sequence
library
annotation
synonyms
last_updated

Each entry in a transcript record, whether it is from UniGene, GenBank, dbEST or another source, provides one entry in the clone table. For the set of fields listed above, it is a one to one mapping from data to database.
These are the same fields as mapped to various data sources:

BIP-Align	GenBank	UniGene	dbEST
Clone Table
clone_id	Accession	UniGene ID	dbEST Id:GenBank Acc:GenBank gi:Clone Id
organism	organism	organism	organism
data_source	GenBank	UniGene	dbEST
clone_length	clone_length	clone_length	clone_length
sequence	ORIGIN	sequence	SEQUENCE
library	tissue_type	Library	Lib name
annotation	DEFINITION	Description	Annotation
synonyms	N/A	N/A	N/A
last_updated	This is a field created by BIP-Align
CDS Table
clone_id	Same as clone_id in clone table
clone_beg	CDS	N/A	N/A
clone_end	CDS	N/A	N/A

BIP-Align Database Schema

For any comments or suggestions, send an e-mail at: BIP_FEEDBACK@asu.edu