blast_db

1 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
blast_db_id serial 10 √ nextval('sgn.blast_db_blast_db_id_seq'::regclass)
blast_query.blast_db_id blast_query_blast_db_id_fkey R
blast_db_blast_db_group.blast_db_id blast_db_blast_db_group_blast_db_id_fkey R
blast_db_organism.blast_db_id blast_db_organism_blast_db_id_fkey R
unigene_build.blast_db_id unigene_build_blast_db_id_fkey R
file_base varchar 120 null

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 .pnin, .pnsq, and .pnhr.
title varchar 80 null
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 true

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 R

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
jbrowse_src varchar 80 √ null

Indexes

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

Check Constraints

Constraint Name Constraint
blast_db_update_freq_check ((((update_freq)::text = 'daily'::text) OR ((update_freq)::text = 'weekly'::text) OR ((update_freq)::text = 'monthly'::text) OR ((update_freq)::text = 'manual'::text)))
blast_db_info_url_check (((info_url IS NULL) OR ((info_url)::text ~ similar_escape('(ftp|http|https)://%'::text, NULL::text))))
blast_db_source_url_check (((source_url IS NULL) OR ((source_url)::text ~ similar_escape('(ftp|http|https|cxgn-resource|file)://%'::text, NULL::text))))
blast_db_file_base_check (((file_base)::text !~~ '/%'::text))
blast_db_lookup_url_check (((lookup_url IS NULL) OR ((lookup_url)::text ~ similar_escape('(ftp|http|https)://%%s%'::text, NULL::text))))
blast_db_type_check ((((type)::text = 'protein'::text) OR ((type)::text = 'nucleotide'::text)))

Relationships

Close relationships within degrees of separation