table_name	column_index	column_name	column_title	datatype	scale	precision	nullable	default_value	is_auto_inc	fk_table	fk_column_name	is_required	input_type	input_length	onChange	is_data_column	is_display_column	is_key_field	column_text	optionlist_query	url
BL_biosequence_set	1	biosequence_set_id	BioSequence Set ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_biosequence_set	2	project_id	Owner Project	int	4	0	N		N	project	project_id	Y	optionlist			Y	Y	N	Project under which this Biosequence Set is organized and for which user privileges is controlled	"SELECT DISTINCT P.project_id,UL.username||' - '||P.name FROM $TB_PROJECT P LEFT JOIN $TB_USER_LOGIN UL ON ( P.PI_contact_id=UL.contact_id ) WHERE P.record_status != 'D' AND P.project_id IN ( $accessible_project_ids ) ORDER BY UL.username||' - '||P.name,P.project_id"	
BL_biosequence_set	3	organism_id	Organism	int	4	0	N		N	organism	organism_id	Y	optionlist			Y	Y	N	Organism to which the BioSequences in this database belong	"SELECT organism_id, organism_name FROM $TB_ORGANISM ORDER BY sort_order,organism_name"	
BL_biosequence_set	4	set_name	Set Name	varchar	100	0	N		N			Y	text	50		Y	Y	N	Name of this BioSequence database		
BL_biosequence_set	5	set_tag	Set Tag	varchar	50	0	N		N			Y	text	20		Y	Y	Y	Short tag (name) of this BioSequence database		
BL_biosequence_set	6	set_description	Set Description	varchar	255	0	N		N			Y	text	50		Y	Y	N	Longer description of this BioSequence database		
BL_biosequence_set	7	set_version	Set Version	varchar	50	0	N		N			Y	text	40		Y	Y	N	Version of this BioSequence database		
BL_biosequence_set	8	polymer_type_id	Polymer Type	int	4	0	N		N	BL_polymer_type	polymer_type_id	Y	optionlist			Y	Y	N	"Polymer type (e.g. protein, DNA, RNA) for the BioSequences in this database"	"SELECT polymer_type_id, polymer_type_name FROM $TBBL_POLYMER_TYPE ORDER BY sort_order,polymer_type_name"	
BL_biosequence_set	9	upload_file	Upload file	varchar	255	0	Y		N			N	file	40		Y	Y	N	File path of this BioSequence database if to be uploaded via the web interface		
BL_biosequence_set	10	set_path	Set Path	varchar	255	0	N		N			Y	text	50		Y	Y	N	File path of this BioSequence database		
BL_biosequence_set	11	source_file_date	Source File Date	datetime	8	0	Y		N			N	text	40		N	N	N	Date of the FASTA file at last update		
BL_biosequence_set	12	uri	URI	varchar	255	0	Y		N			N	text	50		Y	Y	N	External web page or other URI		SELF
BL_biosequence_set	13	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_biosequence_set	14	sort_order	Sort Order	int	4	0	N	10	N			N	text	20		Y	Y	N	Allows the ordering or ranking of Biosequence Sets which is used to break ties for choosing canonical names.  Lower numbers indicate better rank.		
BL_biosequence_set	15	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_biosequence_set	16	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_biosequence_set	17	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_biosequence_set	18	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_biosequence_set	19	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_biosequence_set	20	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_dbxref	1	dbxref_id	dbxref ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_dbxref	2	dbxref_name	CrossRef Name	varchar	50	0	N		N			Y	text	40		Y	Y	N	Name of this Database Cross Reference		
BL_dbxref	3	dbxref_tag	CrossRef Tag	varchar	20	0	N		N			Y	text	20		Y	Y	Y	Short tag (name) of this Database Cross Reference		
BL_dbxref	4	dbxref_description	Description	varchar	255	0	N		N			Y	text	50		Y	Y	N	Longer description of this Database Cross Reference		
BL_dbxref	5	accessor	Accessor	varchar	255	0	N		N			Y	text	50		Y	Y	N	Part of a URL or URI to which an accession number can be appended to get more information about the entity using this cross reference		
BL_dbxref	6	accessor_suffix	Accessor Suffix	varchar	255	0	Y		N			N	text	50		Y	Y	N	Part of a URL or URI which comes after the accession number to build the full URL to get more information about the entity using this cross reference		
BL_dbxref	7	uri	URI	varchar	255	0	N		N			Y	text	50		Y	Y	N	External web page or other URI of the database		SELF
BL_dbxref	8	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_dbxref	9	sort_order	Sort Order	int	4	0	N	10	N							N	N	N			
BL_dbxref	10	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_dbxref	11	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_dbxref	12	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_dbxref	13	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_dbxref	14	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_dbxref	15	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_biosequence	1	biosequence_id	BioSequence ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_biosequence	2	biosequence_set_id	BioSequence Set	int	4	0	N		N	BL_biosequence_set	biosequence_set_id					N	N	Y	BioSequence Set to which this BioSequence belongs		pkDEFAULT
BL_biosequence	3	biosequence_name	BioSequence Name	varchar	255	0	N		N			Y	text	50		Y	Y	Y	Name of this BioSequence (generally everything before the first space in a FASTA file header line)		
BL_biosequence	4	biosequence_gene_name	BioSequence Gene Name	varchar	255	0	Y		N			Y	text	20		Y	Y	N	Gene name of this BioSequence if applicable.  Most common gene name if applicable		
BL_biosequence	5	dbxref_id	Database Cross Reference	int	4	0	Y		N	BL_dbxref	dbxref_id					Y	Y	N	Database cross reference for which the accession number applies		pkDEFAULT
BL_biosequence	6	biosequence_accession	BioSequence Accession	varchar	255	0	Y		N			Y	text	50		Y	Y	N	Accession number for this BioSequence in some external database designated above		
BL_biosequence	7	organism_id	Organism	int	4	0	Y		N	organism	organism_id	Y	optionlist			Y	Y	N	Organism to which this BioSequence belongs	"SELECT organism_id, organism_name FROM $TB_ORGANISM ORDER BY sort_order,organism_name"	
BL_biosequence	8	polymer_type_id	Polymer Type	int	4	0	Y		N	BL_polymer_type	polymer_type_id	Y	optionlist			Y	Y	N	"Polymer type (e.g. protein, DNA, RNA) of this BioSequence"	"SELECT polymer_type_id, polymer_type_name FROM $TBBL_POLYMER_TYPE ORDER BY sort_order,polymer_type_name"	
BL_biosequence	9	biosequence_desc	Biosequence Description	varchar	1024	0	N		N			Y	text	40		Y	Y	N	Description of this BioSequence (generally everything after the first space in a FASTA file header line)		
BL_biosequence	10	biosequence_seq	Sequence	text	16	0	Y		N			N	file	40		Y	Y	N	Actual sequence of the BioSequence if known		
BL_biosequence	11	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_biosequence	12	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_biosequence	13	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_biosequence	14	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_biosequence	15	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_biosequence	16	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_biosequence	17	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_biosequence_property_set	1	biosequence_property_set_id	BioSequence Property Set ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_biosequence_property_set	2	biosequence_id	BioSequence ID	int	4	0	N		N	BL_biosequence	biosequence_id					N	N	Y	Biosequence to which this Biosequence property set belongs		pkDEFAULT
BL_biosequence_property_set	3	n_transmembrane_regions	Number of Transmembrane Regions	int	4	0	Y		N							Y	Y	N	Number of transmembrane regions		pkDEFAULT
BL_biosequence_property_set	4	transmembrane_class	Transmembrane Region Class	varchar	10	0	Y		N			Y	text	50		Y	Y	N	"Class of the transmembrane region.  May be 0, TM, A, S, TM_xS based on output from TMHMM and signalP"		
BL_biosequence_property_set	5	transmembrane_topology	Transmembrane Region Topology	varchar	1024	0	Y		N			Y	text	20		Y	Y	N	Coding of which residues belong in the transmembrane regions		
BL_biosequence_property_set	6	has_signal_peptide	Has a Signal Peptide	char	1	0	Y		N			N	text	50		Y	Y	N	"Does this protein have a signal peptide on the end Y/N? (Note that Y means that there is some non-zero probability that it does, not that is necessarily does)"		
BL_biosequence_property_set	7	has_signal_peptide_probability	Probability that it has a Signal Peptide	real	4	0	Y		N			N	text	50		Y	Y	N	Probability that there is a signal peptide on the end as calculated by SignalP		
BL_biosequence_property_set	8	signal_peptide_length	Length of the Signal Peptide	int	4	0	Y		N			N	text	50		Y	Y	N	Length in residues of the signal peptide		
BL_biosequence_property_set	9	signal_peptide_is_cleaved	Signal Peptide gets Cleaved	char	1	0	Y		N			N	text	50		Y	Y	N	Does the signal peptide get cleaved off Y/N?		
BL_biosequence_property_set	10	genome_build	Genome Build	varchar	50	0	Y		N			N	text	50		Y	Y	N	Genome build name for which the following mapping parameters are valid		
BL_biosequence_property_set	11	chromosome	Chromosome	varchar	50	0	Y		N			N	text	50		Y	Y	N	Chromosome in which this mapping occurs		
BL_biosequence_property_set	12	start_in_chromosome	Start Position in Chromosome	int	4	0	Y		N			N	text	20		Y	Y	N	Start position of the biosequence in the chromosome		
BL_biosequence_property_set	13	end_in_chromosome	End Position in Chromosome	int	4	0	Y		N			N	text	20		Y	Y	N	End position of the biosequence in the chromosome		
BL_biosequence_property_set	14	strand	Strand	char	1	0	Y		N			N	text	10		Y	Y	N	"Strand (+,-) of the biosequence in the chromosome"		
BL_biosequence_property_set	15	isoelectric_point	Isoelectric Point	real	4	0	Y		N			N	text	10		Y	Y	N	Isoelectric Point (pI) of the protein		
BL_biosequence_property_set	16	fav_codon_frequency	Favorite Codon Frequency	real	4	0	Y		N			N	text	10		Y	Y	N	Favorite Codon Frequency		
BL_biosequence_property_set	17	duplicate_biosequences	Duplicate Biosequences	varchar	255	0	Y		N			N	text	50		Y	Y	N	Semicolon delimited list of duplicate sequences within the same set		
BL_biosequence_property_set	18	category	Category	varchar	255	0	Y		N			N	text	50		Y	Y	N	Biosequence category		
BL_biosequence_annotation	1	biosequence_annotation_id	Domain Match Type	int	4	0	N		Y							N	N				pkDEFAULT
BL_biosequence_annotation	2	biosequence_id	BioSequence	int	4	0	N		N	BL_biosequence	biosequence_id	Y	fixed			Y	Y	Y	BioSequence to which this annotation belongs		
BL_biosequence_annotation	3	gene_symbol	Gene Symbol	varchar	255	0	Y		N			N	text	50		Y	Y	N	Gene Symbol to describe this protein (e.g. TLR2)		
BL_biosequence_annotation	4	full_gene_name	Full Gene Name	varchar	255	0	Y		N			N	text	50		Y	Y	N	Full name of the gene (e.g. Toll-like Receptor 2)		
BL_biosequence_annotation	5	aliases	BioSequence Aliases	varchar	255	0	Y		N			N	text	50		Y	Y	N	Aliases of this BioSequence.  These are stored as a semi-colon delimited string		
BL_biosequence_annotation	6	former_names	Former BioSequence Names	varchar	255	0	Y		N			N	text	50		Y	Y	N	Former Aliases of this BioSequence.  These are stored as a colon-delimited string		
BL_biosequence_annotation	7	functional_description	Functional Description	text	16	0	Y		N			N	textarea	3		Y	Y	N	Functional description of the protein		
BL_biosequence_annotation	8	EC_numbers	EC Numbers	varchar	255	0	Y		N			N	text	50		Y	Y	N	EC Number(s) that corresponds to this domain.  Separate multiple numbers with a semicolon		
BL_biosequence_annotation	9	biosequence_type	Biosequence Type	varchar	255	0	Y		N			N	text	50		Y	Y	N	Further annotation of biosequence type		
BL_biosequence_annotation	10	category	Category	varchar	255	0	Y		N			N	text	50		Y	Y	N	Category		
BL_biosequence_annotation	11	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_biosequence_annotation	12	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_biosequence_annotation	13	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_biosequence_annotation	14	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_biosequence_annotation	15	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_biosequence_annotation	16	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_biosequence_annotation	17	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_query_option	1	query_option_id	Query Option ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_query_option	2	option_type	Option Type	varchar	255	0	N		N			Y	text	50		Y	Y	Y	Type or category of this option		
BL_query_option	3	option_key	Option Key	varchar	255	0	N		N			Y	text	50		Y	Y	Y	Key for this key/value pair option		
BL_query_option	4	option_value	Option Value	varchar	255	0	Y		N			Y	text	50		Y	Y	N	Value of this key/value pair option		
BL_query_option	5	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_query_option	6	sort_order	Sort Order	int	4	0	N	10	N			N	text	10		Y	Y	N	Numbers which override alphabetical sorting in a list box		
BL_query_option	7	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_query_option	8	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_query_option	9	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_query_option	10	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_query_option	11	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_query_option	12	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_polymer_type	1	polymer_type_id	Polymer Type ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_polymer_type	2	polymer_type_name	Polymer Type Name	varchar	100	0	N		N			Y	text	20		Y	Y	Y	Name of this polymer type		
BL_polymer_type	3	polymer_type_description	Polymer Type Description	varchar	255	0	N		N			Y	text	50		Y	Y	N	Description of this polymer type		
BL_polymer_type	4	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_polymer_type	5	sort_order	Sort Order	int	4	0	N	10	N			N	text	10		Y	Y	N	Numbers which override alphabetical sorting in a list box		
BL_polymer_type	6	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_polymer_type	7	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_polymer_type	8	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_polymer_type	9	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_polymer_type	10	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_polymer_type	11	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_relationship_type	1	relationship_type_id	Relationship Type ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_relationship_type	2	relationship_type_name	Relationship Type Name	varchar	100	0	N		N			Y	text	40		Y	Y	Y	Name of this relationship type		
BL_relationship_type	3	relationship_type_description	Relationship Type Description	varchar	255	0	N		N			Y	text	50		Y	Y	N	Description of what this relationship type really means		
BL_relationship_type	4	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_relationship_type	5	sort_order	Sort Order	int	4	0	N	10	N			N	text	10		Y	Y	N	Numbers which override alphabetical sorting in a list box		
BL_relationship_type	6	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_relationship_type	7	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_relationship_type	8	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_relationship_type	9	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_relationship_type	10	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_relationship_type	11	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_evidence_source	1	evidence_source_id	Evidence Source ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_evidence_source	2	evidence_source_name	Evidence Source Name	varchar	255	0	N		N			Y	text	40		Y	Y	N	Name of this evidence source (i.e. what process was used to enter this relationship. This should probably be both the name of the local program as well as the remote source)		
BL_evidence_source	3	evidence_source_tag	Evidence Source Tag	varchar	50	0	N		N			Y	text	40		Y	Y	Y	Short name (tag) of this evidence source as it might appear in a table column		
BL_evidence_source	4	evidence_source_description	Evidence Source Description	text	16	0	N		N			Y	textarea	4		Y	Y	N	Detailed description of how entries under this evidence source are entered in		
BL_evidence_source	5	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_evidence_source	6	sort_order	Sort Order	int	4	0	N	10	N			N	text	10		Y	Y	N	Numbers which override alphabetical sorting in a list box		
BL_evidence_source	7	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_evidence_source	8	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_evidence_source	9	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_evidence_source	10	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_evidence_source	11	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_evidence_source	12	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_relationship	1	relationship_id	Relationship ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_relationship	2	biosequence1_id	BioSequence 1 ID	int	4	0	N		N	BL_biosequence	biosequence_id	N	optionlist			N	N	Y	BioSequence identification	"SELECT 1,2"	
BL_relationship	3	biosequence2_id	BioSequence 2 ID	int	4	0	N		N	BL_biosequence	biosequence_id	N	optionlist			N	N	Y	BioSequence identification	"SELECT 1,2"	
BL_relationship	4	relationship_type_id	Relationship Type ID	int	4	0	N		N	BL_relationship_type	relationship_type_id	N	optionlist			N	N	Y	Relationship type for this relationship	"SELECT relationship_type_id, relationship_type_name FROM $TBBL_RELATIONSHIP_TYPE ORDER BY sort_order,relationship_type_name"	
BL_relationship	5	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_relationship	6	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_relationship	7	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_relationship	8	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_relationship	9	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_relationship	10	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_evidence	1	evidence_id	Evidence ID	int	4	0	N		Y							N	N				pkDEFAULT
BL_evidence	2	relationship_id	Relationship ID	int	4	0	N		N	BL_relationship	relationship_id	Y	optionlist			Y	Y	N	Relationship ID this line of evidence presents	"SELECT relationship_id, relationship_name FROM $TB_RELATIONSHIP ORDER BY sort_order,relationship_name"	
BL_evidence	3	evidence_source_id	Evidence Source ID	int	4	0	N		N	BL_evidence_source	evidence_source_id	Y	optionlist			Y	Y	N	Evidence Source that produced this line of evidence	"SELECT evidence_source_id, evidence_source_name FROM $TB_EVIDENCE_SOURCE ORDER BY sort_order,evidence_source_name"	
BL_evidence	4	comment	Comment	text	16	0	Y		N			N	textarea	4		Y	Y	N	Additional comments		
BL_evidence	5	date_created	query_option_id	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_evidence	6	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_evidence	7	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_evidence	8	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_evidence	9	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_evidence	10	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_BrowseBioSequence	1	biosequence_set_id	BioSequence Sets									N	multioptionlist	4		Y	Y	N	"Select desired BioSequence Sets to include in query.  Multiple items may be selected.  If no items are selected, ALL sets are searched."	"SELECT biosequence_set_id,set_name FROM $TBBL_BIOSEQUENCE_SET ORDER BY sort_order,set_name"	
BL_BrowseBioSequence	2	biosequence_name_constraint	Name Constraint									N	text	40		Y	Y	N	Constraint for the BioSequence Name. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	3	biosequence_gene_name_constraint	Gene Name Constraint									N	text	40		Y	Y	N	Constraint for the BioSequence Gene Name. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	4	molecular_function_constraint	Molecular Function Constraint									N	text	40		Y	Y	N	Constraint for the GO Molecular Function. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	5	biological_process_constraint	Biological Process Constraint									N	text	40		Y	Y	N	Constraint for the GO Biological Process. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	6	cellular_component_constraint	Cellular Component Constraint									N	text	40		Y	Y	N	Constraint for the GO Cellular Component. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	7	protein_domain_constraint	Protein Domain Constraint									N	text	40		Y	Y	N	Constraint for the InterPro Protein Domain. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	8	fav_codon_frequency_constraint	Favored Codon Frequency Constraint									N	text	40		Y	Y	N	"Constraint for the favored codon frequency (calculation by Patrick Pedrioli).  Allowed syntax: ""n.n"", ""> n.n"", ""< n.n"", ""between n.n and n.n"", ""n.n +- n.n"""		
BL_BrowseBioSequence	9	n_transmembrane_regions_constraint	Number of Transmembrane Regions Constraint									N	text	40		Y	Y	N	"Constraint for the number of transmembrane regions (based on a 19-residue wide sliding window of hydropathy indexes above 1.58).  Allowed syntax: ""n"", ""> n"", ""< n"", ""between n and n"", ""n +- n"""		
BL_BrowseBioSequence	10	biosequence_seq_constraint	Sequence Constraint									N	text	40		Y	Y	N	Constraint for the actual sequence. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	11	biosequence_desc_constraint	Description Constraint									N	text	40		Y	Y	N	Constraint for the BioSequence Description. '%' is wildcard character; '_' is single character wildcard; character range is like '[a-m]'; no other regexps supported.		
BL_BrowseBioSequence	12	sort_order	Sort Order									N	optionlist	 		Y	Y	N	Desired display sorting order (DESC means descending: highest to lowest)	"SELECT option_key,option_value FROM $TBBL_QUERY_OPTION WHERE option_type = 'BBS_sort_options' ORDER BY sort_order,option_value"	
BL_BrowseBioSequence	13	display_options	Display Options									N	multioptionlist	3		Y	Y	N	Various selectable table display options	"SELECT option_key,option_value FROM $TBBL_QUERY_OPTION WHERE option_type = 'BBS_display_options' ORDER BY sort_order,option_value"	
BL_BrowseBioSequence	14	row_limit	Maximum Rows									N	text	10		Y	Y	N	"Limit the numbers of rows displayed.  If not provided, default is 100 rows."		
BL_cbil_genome_coordinates	1	Coordinate_id	Primary key	int	4	0	N		Y			Y									
BL_cbil_genome_coordinates	2	Probe_Set_Name	Affymetrix probe set name	varchar	255	0	Y		N			N									
BL_cbil_genome_coordinates	3	Genome_Build	Genome build version number	varchar	255	0	Y		N			N									
BL_cbil_genome_coordinates	4	Chromosome	Chromosome defined by coordinates	varchar	255	0	Y		N			N									
BL_cbil_genome_coordinates	5	Gene_start	Transcription start coordinate	int	4	0	Y		N			N									
BL_cbil_genome_coordinates	6	gene_end	Transcription end coordinate	int	4	0	Y		N			N									
BL_cbil_genome_coordinates	7	Strand	Coding strand orientation	char	1	0	Y		N			N									
BL_cbil_genome_coordinates	8	DoTS	DoTS accession	varchar	255	0	Y		N			N									
BL_cbil_genome_coordinates	9	GenBank	GenBank accession	varchar	255	0	Y		N			N									
BL_cbil_genome_coordinates	10	Gene_Symbol	Official Gene Symbol	varchar	255	0	Y		N			N									
BL_cbil_genome_coordinates	11	Gene_Synonyms	Gene Synonyms	varchar	255	0	Y		N			N									
BL_cbil_genome_coordinates	12	organism_id	Organism identifier	int	4	0	N		N			N									
BL_MGEDOntologyRelationship	1	MGED_ontology_relationship_id	MGED ontology relationship ID	int	4	0	N		N			Y									
BL_MGEDOntologyRelationship	2	subject_term_id	Subject Term ID	int	4	0	N		N			Y									
BL_MGEDOntologyRelationship	3	predicate_term_id	Predicate Term ID	varchar	255	0	Y		N			N									
BL_MGEDOntologyRelationship	4	object_term_id	Object Term ID	int	4	0	N		N			Y									
BL_MGEDOntologyRelationship	5	ontology_relationship_type_id	Ontology Relationship ID	int	4	0	N		N			Y									
BL_MGEDOntologyTerm	1	MGED_ontology_term_id	MGED Ontology Term ID	int	4	0	N		N			Y									
BL_MGEDOntologyTerm	2	ontology_term_type_id	Ontology Term Type ID	int	4	0	N		N			Y									
BL_MGEDOntologyTerm	3	name	Ontology Name	varchar	255	0	N		N			Y									
BL_MGEDOntologyTerm	4	definition	Ontology Definition	text	16	0	N		N			Y									
BL_MGEDOntologyTerm	5	uri	Ontology uri	varchar	255	0	Y		N			N									
BL_MGEDOntologyTerm	6	external_database_release_id	external_database_release_id	varchar	255	0	Y		N			N									
BL_MGEDOntologyTerm	7	source_id	source_id	varchar	255	0	Y		N			N									
BL_OntologyRelationshipType	1	ontology_relationship_type_id	Ontology Relationship Type ID	int	4	0	Y		N			Y									
BL_OntologyRelationshipType	2	name	Ontology Relationship Name	varchar	255	0	Y		N			Y									
BL_OntologyTermType	1	ontology_term_type_id	Ontology Term Type ID	int	4	0	N		N			Y									
BL_OntologyTermType	2	name	Ontology Term Name	varchar	255	0	N		N			Y									
BL_OntologyTermType	3	description	Ontology Term Description	varchar	255	0	Y		N			N									
BL_data_object	1	data_object_id	Data Object ID	int	4	0	N		Y			Y				N	N		Primary Key		pkDEFAULT
BL_data_object	2	object_name	Object Name	varchar	255	0	N		N			Y	text	50		Y	Y	Y	Name for this data object		
BL_data_object	3	project_id	Owner Project	int	4	0	Y		N	project	project_id	Y	optionlist			Y	Y	N	Project under which this Biosequence Set is organized and for which user privileges is controlled	"SELECT DISTINCT P.project_id,UL.username||' - '||P.name FROM $TB_PROJECT P LEFT JOIN $TB_USER_LOGIN UL ON ( P.PI_contact_id=UL.contact_id ) WHERE P.record_status != 'D' AND P.project_id IN ( $writable_project_ids ) ORDER BY UL.username||' - '||P.name,P.project_id"	
BL_data_object	4	object_data	Object Data	varchar	255	0	Y		N			Y	file	40		Y	Y	N	Stored data object, generally serialized.		
BL_data_object	5	description	Description	varchar	2000	0	Y		N			N	textarea	5		Y	Y	N	Description of stored data object		
BL_data_object	6	data_object_type_id	Data Object Type ID	int	4	0	Y		N	data_object_type	data_object_type_id	Y	optionlist			Y	Y	N	Data type of this particular data object	SELECT DISTINCT data_object_type_id, data_object_type_name FROM $TBBL_DATA_OBJECT_TYPE	
BL_data_object	7	hypothesis_id	Hypothesis ID	int	4	0	Y		N	hypothesis	hypothesis_id	Y	optionlist			Y	Y	N	Data type of this particular data object	SELECT DISTINCT hypothesis_id, hypothesis_name FROM $TBBL_HYPOTHESIS WHERE project_id IN ( $writable_project_ids)	
BL_data_object	8	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_data_object	9	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_data_object	10	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_data_object	11	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_data_object	12	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_data_object	13	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_data_object_type	1	data_object_type_id	Data Object Type ID	int	4	0	N		Y			Y				N	N		Primary Key		pkDEFAULT
BL_data_object_type	2	data_object_type_name	Data Object Type Name	varchar	255	0	N		N			Y	text	50		Y	Y	Y	Name of this data object type		
BL_data_object_type	3	description	Description	varchar	2000	0	Y		N			N	textarea	5		Y	Y	N	Description of data object type		
BL_data_object_type	4	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_data_object_type	5	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_data_object_type	6	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_data_object_type	7	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_data_object_type	8	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_data_object_type	9	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_hypothesis	1	hypothesis_id	Hypothesis_id	int	4	0	N		Y			Y				N	N		Primary Key		pkDEFAULT
BL_hypothesis	2	hypothesis_name	Hypothesis Name	varchar	255	0	N		N			Y	text	50		Y	Y	Y	Name for this data object		
BL_hypothesis	3	project_id	Owner Project	int	4	0	Y		N	project	project_id	Y	optionlist			Y	Y	N	Project under which this hypothesis is stored	"SELECT DISTINCT P.project_id,UL.username||' - '||P.name FROM $TB_PROJECT P LEFT JOIN $TB_USER_LOGIN UL ON ( P.PI_contact_id=UL.contact_id ) WHERE P.record_status != 'D' AND P.project_id IN ( $writable_project_ids ) ORDER BY UL.username||' - '||P.name,P.project_id"	
BL_hypothesis	4	hypothesis	Hypothesis	text	16	0	Y		N			Y	textarea	6		Y	Y	N	Body of hypothesis		
BL_hypothesis	5	comment	comment	varchar	255	0	Y		N			N	text	50		Y	Y	N	Brief description of hypothesis		
BL_hypothesis	6	date_created	Date Record Created	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_hypothesis	7	created_by_id	Record Created By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_hypothesis	8	date_modified	Date Record Modified	datetime	8	0	N	CURRENT_TIMESTAMP	N							N	N				
BL_hypothesis	9	modified_by_id	Record Modified By	int	4	0	N	1	N	contact	contact_id					N	N				
BL_hypothesis	10	owner_group_id	Owner Group ID	int	4	0	N	1	N	work_group	work_group_id					N	N				
BL_hypothesis	11	record_status	Record Status	char	1	0	N	N	N							N	N				
BL_kegg_organism	1	kegg_organism_id	KEGG Organism ID	int	4	0	N		Y			Y				N	N		Primary Key		pkDEFAULT
BL_kegg_organism	2	kegg_organism_name	KEGG Organism name	varchar	255	0	N		N			Y	text	50		Y	Y	Y	KEGG name for this organism		
BL_kegg_organism	3	organism_id	Organism	int	4	0	Y		N	organism	organism_id	Y	optionlist			Y	Y	N	Organism_id which corresponds to this entry	"SELECT organism_id, organism_name FROM $TB_ORGANISM ORDER BY sort_order,organism_name"	
BL_kegg_pathway	1	kegg_pathway_id	KEGG Pathway ID	int	4	0	N		Y			Y				N	N		Primary Key		pkDEFAULT
BL_kegg_pathway	2	kegg_pathway_name	KEGG pathway name	varchar	255	0	N		N			Y	text	50		Y	Y	Y	KEGG name for this pathway		
BL_kegg_pathway	3	kegg_pathway_description	KEGG pathway description	varchar	255	0	N		N			Y	text	50		Y	Y	Y	KEGG description for this pathway		
BL_kegg_pathway	4	kegg_organism_id	Kegg Organism	int	4	0	Y		N	kegg_organism	kegg_organism_id	Y	optionlist			Y	Y	N	Foreign key to kegg_organism table	"SELECT kegg_organism_id, kegg_organism_name FROM $TBBL_KEGG_ORGANISM ORDER BY kegg_organism_name"	
BL_kegg_pathway	5	pathway_category	Pathway Category	varchar	255	0	Y		N			Y	text	50		Y	Y	N	Grouping for pathway		
BL_kegg_pathway	6	kgml	KGML	text	16	0	Y		N			Y	file	8		Y	Y	N	XML representation of this pathway		
BL_kegg_pathway	7	kgml_url	KGML URL	varchar	255	0	Y		N			Y	text	50		Y	Y	N	URL to KGML file		
BL_kegg_pathway	8	image	Image	text	16	0	Y		N			Y	file	50		Y	Y	N	Blank gif image of this pathway		
BL_kegg_pathway	9	image_url	Image URL	varchar	255	0	Y		N			Y	text	50		Y	Y	N	URL to pathway image		
BL_kegg_pathway	10	date_modified	Date Modified	datetime	8	0	Y	CURRENT_TIMESTAMP	N			Y	text	50		Y	Y	N	When record was updated		
BL_kegg_gene	1	kegg_gene_id	KEGG Gene ID	int	4	0	N		Y			Y				N	N		Primary Key		pkDEFAULT
BL_kegg_gene	2	kegg_organism_id	Kegg Organism	int	4	0	Y		N	kegg_organism	kegg_organism_id	Y	optionlist			Y	Y	N	Foreign key to kegg_organism table	"SELECT kegg_organism_id, kegg_organism_name FROM $TBBL_KEGG_ORGANISM ORDER BY kegg_organism_name"	
BL_kegg_gene	3	gene_id	Gene ID	varchar	255	0	Y		N			Y	text	50		Y	Y	N	Gene ID associated with this gene		
BL_kegg_gene	4	gene_symbol	Gene Symbol	varchar	255	0	Y		N			Y	text	50		Y	Y	N	Gene Symbol associated with this gene		
BL_kegg_gene	5	gene_description	Gene Description	varchar	255	0	Y		N			Y	text	50		Y	Y	N	Description information for gene		
BL_kegg_gene	6	annotation_line	Annotation Line	text	16	0	Y		N			Y	text	50		Y	Y	N	Entire definition line for this gene		
BL_kegg_pathway_genes	1	kegg_gene_id	KEGG Gene	int	4	0	Y		N	kegg_organism	kegg_organism_id	Y	optionlist			Y	Y	N	Foreign key to kegg_gene table	"SELECT kegg_organism_id, kegg_organism_name FROM $TBBL_KEGG_ORGANISM ORDER BY kegg_organism_name"	
BL_kegg_pathway_genes	2	kegg_pathway_id	KEGG Pathway	int	4	0	Y		N	kegg_pathway	kegg_pathway_id	Y	optionlist			Y	Y	N	Foreign key to kegg pathway table	"SELECT kegg_pathway_id, kegg_pathway_name FROM $TBBL_KEGG_PATHWAY ORDER BY kegg_pathway_name"