Table cxgn.sgn.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)
unigene_build.blast_db_id unigene_build_blast_db_id_fkey
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
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  √  false whether this blast DB is available for BLASTing via web interfaces
description text 2147483647  √  null

Table contained 55 rows at Wed May 20 01:50 EDT 2009

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  within one two degrees of separation :