Table cxgn.sgn_bt.blast_db

This table holds metadata about the BLAST databases that we keep in stock.

 Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
blast_db_id serial 10  √  nextval('blast_db_blast_db_id_seq'::regclass)
file_base varchar 120 the basename of the blast db files, relative to the root of the databases repository.  A blast DB is usually composed of 3 files, all with a given basename, and with the extensions .[pn]in, .[pn]sq, and .[pn]hr.
title varchar 80
type varchar 80  √  null
source_url varchar 255  √  null
lookup_url varchar 255  √  null
cxgn_production_visible bool 1  √  false
update_freq varchar 80 'monthly'::character varying
info_url varchar 255  √  null
index_seqs bool 1 false corresponds to formatdb -o option.  Set true if formatdb should be given a '-o T'.  This is used only if you later want to fetch specific sequences out of this blast db.
blast_db_group_id int4 10  √  null
blast_db_group.blast_db_group_id blast_db_blast_db_group_id_fkey
blast_db_group this belongs to, for displaying on web
web_interface_visible bool 1  √  true whether this blast DB is available for BLASTing via web interfaces

Table contained 34 rows at Thu Jun 21 23:03 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name
blast_db_id Primary key Asc blast_db_pkey
file_base Must be unique Asc blast_db_file_base_key

Close relationships: