| Summary | Package variables | Synopsis | Description | General documentation | Methods |
use Bio::DB::SeqFeature::Store;
# Open the sequence database my $db = Bio::DB::SeqFeature::Store->new( -adaptor => 'DBI::mysql', -dsn => 'dbi:mysql:test', -write => 1 ); my $loader = Bio::DB::SeqFeature::Store::GFF3Loader->new(-store => $db, -verbose => 1, -fast => 1); $loader->load('./my_genome.gff3');
# #index-subfeatures [0|1]Note that you can place a space between the two #'s in order to
ctg123 . TF_binding_site 1000 1012 . + . ID=tfbs00001;index=1You can use this to turn indexing on and off, overriding the default
| new | Description | Code |
| load | Description | Code |
| store | No description | Code |
| tmp_store | No description | Code |
| sfclass | No description | Code |
| fast | No description | Code |
| seq_chunk_size | No description | Code |
| verbose | No description | Code |
| default_seqfeature_class | No description | Code |
| subfeatures_normalized | No description | Code |
| subfeatures_in_table | No description | Code |
| load_fh | No description | Code |
| start_load | No description | Code |
| finish_load | No description | Code |
| do_load | No description | Code |
| handle_meta | No description | Code |
| handle_feature | No description | Code |
| store_current_feature | No description | Code |
| build_object_tree | No description | Code |
| build_object_tree_in_tables | No description | Code |
| build_object_tree_in_features | No description | Code |
| attach_children | No description | Code |
| add_segment | No description | Code |
| parse_attributes | No description | Code |
| start_or_finish_sequence | No description | Code |
| load_sequence | No description | Code |
| msg | No description | Code |
| new | code | next | Top |
Title : newThis method creates a new GFF3 loader and establishes its connection with a Bio::DB::SeqFeature::Store database. Arguments are -name=>$value pairs as described in this table: Name ValueWhen you call new(), a connection to a Bio::DB::SeqFeature::Store database should already have been established and the database initialized (if appropriate). Some combinations of Bio::SeqFeatures and Bio::DB::SeqFeature::Store databases support a fast loading mode. Currently the only reliable implementation of fast loading is the combination of DBI::mysql with Bio::DB::SeqFeature. The other important restriction on fast loading is the requirement that a feature that contains subfeatures must occur in the GFF3 file before any of its subfeatures. Otherwise the subfeatures that occurred before the parent feature will not be attached to the parent correctly. This restriction does not apply to normal (slow) loading. If you use an unnormalized feature class, such as Bio::SeqFeature::Generic, then the loader needs to create a temporary database in which to cache features until all their parts and subparts have been seen. This temporary databases uses the "bdb" adaptor. The -tmp option specifies the directory in which that database will be created. If not present, it defaults to the system default tmp directory specified by File::Spec->tmpdir(). The -chunk_size option allows you to tune the representation of DNA/Protein sequence in the Store database. By default, sequences are split into 2000 base/residue chunks and then reassembled as needed. This avoids the problem of pulling a whole chromosome into memory in order to fetch a short subsequence from somewhere in the middle. Depending on your usage patterns, you may wish to tune this parameter using a chunk size that is larger or smaller than the default. |
| load | code | prev | next | Top |
Title : loadOnce the loader is created, invoke its load() method with a list of GFF3 or FASTA file paths or previously-opened filehandles in order to load them into the database. Compressed files ending with .gz, .Z and .bz2 are automatically recognized and uncompressed on the fly. Paths beginning with http: or ftp: are treated as URLs and opened using the LWP GET program (which must be on your path). FASTA files are recognized by their initial ">" character. Do not feed the loader a file that is neither GFF3 nor FASTA; I don't know what will happen, but it will probably not be what you expect. |
| new | description | prev | next | Top |
my $self = shift; my ($store,$seqfeature_class,$tmpdir,$verbose,$fast,$seq_chunk_size) = rearrange(['STORE', ['SF_CLASS','SEQFEATURE_CLASS'], ['TMP','TMPDIR'], 'VERBOSE', 'FAST', 'CHUNK_SIZE', ],@_); $seqfeature_class ||= $self->default_seqfeature_class; eval "require $seqfeature_class" unless $seqfeature_class->can('new'); $self->throw($@) if $@; my $normalized = $seqfeature_class->can('subfeatures_are_normalized') && $seqfeature_class->subfeatures_are_normalized; my $in_table = $seqfeature_class->can('subfeatures_are_stored_in_a_table') && $seqfeature_class->subfeatures_are_stored_in_a_table; if ($fast) { my $canfast = $normalized && $in_table; warn <<END unless $canfast; Only features that support the Bio::DB::SeqFeature::NormalizedTableFeature interface can be loaded using the -fast method. Reverting to slower feature-by-feature method. END $fast &&= $canfast; } # try to bring in highres time() function}
eval "require Time::HiRes"; $tmpdir ||= File::Spec->tmpdir(); my $tmp_store = Bio::DB::SeqFeature::Store->new(-adaptor => 'berkeleydb', -temporary=> 1, -dsn => $tmpdir, -cache => 1, -write => 1) unless $normalized; return bless { store => $store, tmp_store => $tmp_store, seqfeature_class => $seqfeature_class, fast => $fast, seq_chunk_size => $seq_chunk_size || DEFAULT_SEQ_CHUNK_SIZE, verbose => $verbose, load_data => {}, subfeatures_normalized => $normalized, subfeatures_in_table => $in_table, },ref($self) || $self;
| load | description | prev | next | Top |
my $self = shift; my $start = $self->time(); my $count = 0; for my $file_or_fh (@_) { $self->msg("loading $file_or_fh...\n"); my $fh = $self->open_fh($file_or_fh) or $self->throw("Couldn't open $file_or_fh: $!"); $count += $self->load_fh($fh); $self->msg(sprintf "load time: %5.2fs\n",$self->time()-$start); } $count;}
| store | description | prev | next | Top |
shift->{store}}
| tmp_store | description | prev | next | Top |
shift->{tmp_store}}
| sfclass | description | prev | next | Top |
shift->{seqfeature_class}}
| fast | description | prev | next | Top |
shift->{fast}}
| seq_chunk_size | description | prev | next | Top |
shift->{seq_chunk_size}}
| verbose | description | prev | next | Top |
shift->{verbose}}
| default_seqfeature_class | description | prev | next | Top |
my $self = shift; return 'Bio::DB::SeqFeature';}
| subfeatures_normalized | description | prev | next | Top |
my $self = shift; my $d = $self->{subfeatures_normalized}; $self->{subfeatures_normalized} = shift if @_; $d;}
| subfeatures_in_table | description | prev | next | Top |
my $self = shift; my $d = $self->{subfeatures_in_table}; $self->{subfeatures_in_table} = shift if @_; $d;}
| load_fh | description | prev | next | Top |
my $self = shift; my $fh = shift; $self->start_load(); my $count = $self->do_load($fh); $self->finish_load(); $count;}
| start_load | description | prev | next | Top |
my $self = shift; $self->{load_data}{Parent2Child} = {}; $self->{load_data}{Local2GlobalID} = {}; $self->{load_data}{TemporaryID} = "GFFLoad0000000"; $self->{load_data}{IndexSubfeatures} = 1; $self->{load_data}{CurrentFeature} = undef; $self->{load_data}{CurrentID} = undef; $self->store->start_bulk_update() if $self->fast;}
| finish_load | description | prev | next | Top |
my $self = shift; $self->msg("Building object tree..."); my $start = $self->time(); $self->build_object_tree; $self->msg(sprintf "%5.2fs\n",$self->time()-$start); if ($self->fast) { $self->msg("Loading bulk data into database..."); $start = $self->time(); $self->store->finish_bulk_update; $self->msg(sprintf "%5.2fs\n",$self->time()-$start); } eval {$self->store->commit}; delete $self->{load_data};}
| do_load | description | prev | next | Top |
my $self = shift; my $fh = shift; my $start = $self->time(); my $count = 0; my $mode = 'gff'; # or 'fasta'}
while (<$fh>) { chomp; next unless /^\S/; # blank line
$mode = 'gff' if /\t/; # if it has a tab in it, switch to gff mode
if (/^\#\s?\#\s*(.+)/) { ## meta instruction
$mode = 'gff'; $self->handle_meta($1); } elsif (/^\#/) { $mode = 'gff'; # just to be safe
next; # comment
} elsif (/^>\s*(\S+)/) { # FASTA lines are coming
$mode = 'fasta'; $self->start_or_finish_sequence($1); } elsif ($mode eq 'fasta') { $self->load_sequence($_); } elsif ($mode eq 'gff') { $self->handle_feature($_); if (++$count % 1000 == 0) { my $now = $self->time(); my $nl = -t STDOUT && !$ENV{EMACS} ? "\r" : "\n"; $self->msg(sprintf("%d features loaded in %5.2fs...$nl",$count,$now - $start)); $start = $now; } } else { $self->throw("I don't know what to do with this line:\n$_"); } } $self->store_current_feature(); # during fast loading, we will have a feature left at the very end
$self->start_or_finish_sequence(); # finish any half-loaded sequences
$self->msg(' 'x80,"\n"); #clear screen
$count;
| handle_meta | description | prev | next | Top |
my $self = shift; my $instruction = shift; if ($instruction =~ /sequence-region\s+(.+)\s+(-?\d+)\s+(-?\d+)/i) { my $feature = $self->sfclass->new(-name => $1, -seq_id => $1, -start => $2, -end => $3, -primary_tag => 'region'); $self->store->store($feature); return; } if ($instruction =~/index-subfeatures\s+(\S+)/i) { $self->{load_data}{IndexSubfeatures} = $1; $self->store->index_subfeatures($1); return; }}
| handle_feature | description | prev | next | Top |
my $self = shift; my $gff_line = shift; my $ld = $self->{load_data}; my @columns = map {$_ eq '.' ? undef : $_ } split /\t/,$gff_line; return unless @columns >= 8; my ($refname,$source,$method,$start,$end, $score,$strand,$phase,$attributes) = @columns; $strand = $Strandedness{$strand||0}; my ($reserved,$unreserved) = $self->parse_attributes($attributes); my $name = ($reserved->{Name} && $reserved->{Name}[0]); my $has_loadid = defined $reserved->{ID}[0]; my $feature_id = $reserved->{ID}[0] || $ld->{TemporaryID}++; my @parent_ids = @{$reserved->{Parent}} if $reserved->{Parent}; my $index_it = $ld->{IndexSubfeatures}; if (exists $reserved->{Index} || exists $reserved->{index}) { $index_it = $reserved->{Index}[0] || $reserved->{index}[0]; } # Everything in the unreserved hash becomes an attribute, so we copy}
# some attributes over
$unreserved->{Note} = $reserved->{Note} if exists $reserved->{Note}; $unreserved->{Alias} = $reserved->{Alias} if exists $reserved->{Alias}; $unreserved->{Target} = $reserved->{Target} if exists $reserved->{Target}; $unreserved->{Gap} = $reserved->{Gap} if exists $reserved->{Gap}; $unreserved->{load_id}= $reserved->{ID} if exists $reserved->{ID}; # TEMPORARY HACKS TO SIMPLIFY DEBUGGING
push @{$unreserved->{Alias}},$feature_id if $has_loadid; $unreserved->{parent_id} =\@ parent_ids if @parent_ids; # POSSIBLY A PERMANENT HACK -- TARGETS BECOME ALIASES
# THIS IS TO ALLOW FOR TARGET-BASED LOOKUPS
if (exists $reserved->{Target}) { my %aliases = map {$_=>1} @{$unreserved->{Alias}}; for my $t (@{$reserved->{Target}}) { (my $tc = $t) =~ s/\s+.*$//; # get rid of coordinates
$name ||= $tc; push @{$unreserved->{Alias}},$tc unless $name eq $tc || $aliases{$tc}; } } my @args = (-display_name => $name, -seq_id => $refname, -start => $start, -end => $end, -strand => $strand || 0, -score => $score, -phase => $phase, -primary_tag => $method || 'feature', -source => $source, -tag => $unreserved, -attributes => $unreserved, ); # Here's where we handle feature lines that have the same ID (multiple locations, not
# parent/child relationships)
my $old_feat; # Current feature is the same as the previous feature, which hasn't yet been loaded
if (defined $ld->{CurrentID} && $ld->{CurrentID} eq $feature_id) { $old_feat = $ld->{CurrentFeature}; } # Current feature is the same as a feature that was loaded earlier
elsif (my $id = $self->{load_data}{Local2GlobalID}{$feature_id}) { $old_feat = $self->fetch($feature_id) or $self->warn(<<END); ID=$feature_id has been used more than once, but it cannot be found in the database. This can happen if you have specified fast loading, but features sharing the same ID are not contiguous in the GFF file. This will be loaded as a separate feature. Line $.: "$_" END } # contiguous feature, so add a segment
if (defined $old_feat) { $self->add_segment($old_feat,$self->sfclass->new(@args)); return; } # we get here if this is a new feature
# first of all, store the current feature if it is there
$self->store_current_feature() if defined $ld->{CurrentID}; # now create the new feature
# (index top-level features only if policy asks us to)
my $feature = $self->sfclass->new(@args); $feature->object_store($self->store) if $feature->can('object_store'); # for lazy table features
$ld->{CurrentFeature} = $feature; $ld->{CurrentID} = $feature_id; my $top_level = !@parent_ids; my $has_id = defined $reserved->{ID}[0]; $index_it ||= $top_level; $ld->{IndexIt}{$feature_id}++ if $index_it; $ld->{TopLevel}{$feature_id}++ if !$self->{fast} && $top_level; # need to track top level features
# remember parentage
for my $parent (@parent_ids) { push @{$ld->{Parent2Child}{$parent}},$feature_id; }
| store_current_feature | description | prev | next | Top |
my $self = shift; my $ld = $self->{load_data}; defined $ld->{CurrentFeature} or return; my $f = $ld->{CurrentFeature}; my $normalized = $self->subfeatures_normalized; my $indexed = $ld->{IndexIt}{$ld->{CurrentID}}; # logic is as follows:}
# 1. If the feature is an indexed feature, then we store it into the main database
# so that it can be searched. It doesn't matter whether it is a top-level feature
# or a subfeature.
# 2. If the feature class is normalized, but not indexed, then we store it into the
# main database using the "no_index" method. This will make it accessible to
# queries on the top level parent, but it won't come up by itself in range or
# attribute searches.
# 3. Otherwise, this is an unindexed subfeature; we store it in the temporary database
# until the object build step, at which point it gets integrated into its object tree
# and copied into the main database.
if ($indexed) { $self->store->store($f); } elsif ($normalized) { $self->store->store_noindex($f) } else { $self->tmp_store->store_noindex($f) } my $id = $f->primary_id; # assigned by store()
$ld->{Local2GlobalID}{$ld->{CurrentID}} = $id; undef $ld->{IndexIt}{$ld->{CurrentID}} if $normalized; # no need to remember this
undef $ld->{CurrentID}; undef $ld->{CurrentFeature};
| build_object_tree | description | prev | next | Top |
my $self = shift; $self->subfeatures_in_table ? $self->build_object_tree_in_tables : $self->build_object_tree_in_features;}
| build_object_tree_in_tables | description | prev | next | Top |
my $self = shift; my $store = $self->store; my $ld = $self->{load_data}; while (my ($load_id,$children) = each %{$ld->{Parent2Child}}) { my $parent_id = $ld->{Local2GlobalID}{$load_id} or $self->throw("$load_id doesn't have a primary id"); my @children = map {$ld->{Local2GlobalID}{$_}} @$children; # this updates the table that keeps track of parent/child relationships,}
# but does not update the parent object -- so (start,end) had better be right!!!
$store->add_SeqFeature($parent_id,@children); }
| build_object_tree_in_features | description | prev | next | Top |
my $self = shift; my $store = $self->store; my $tmp = $self->tmp_store; my $ld = $self->{load_data}; my $normalized = $self->subfeatures_normalized; while (my ($load_id) = each %{$ld->{TopLevel}}) { my $feature = $self->fetch($load_id) or $self->throw("$load_id (id=$ld->{Local2GlobalID}{$load_id}) should have a database entry, but doesn't"); $self->attach_children($store,$ld,$load_id,$feature); $feature->primary_id(undef) unless $ld->{IndexIt}{$load_id}; # Indexed objects are updated, not created anew}
$store->store($feature); }
| attach_children | description | prev | next | Top |
my $self = shift; my ($store,$ld,$load_id,$feature) = @_; my $children = $ld->{Parent2Child}{$load_id} or return; for my $child_id (@$children) { my $child = $self->fetch($child_id) or $self->throw("$child_id should have a database entry, but doesn't"); $self->attach_children($store,$ld,$child_id,$child); # recursive call}
$feature->add_SeqFeature($child); }
| add_segment | description | prev | next | Top |
my $self = shift; my ($parent,$child) = @_; if ($parent->can('add_segment')) { # probably a lazy table feature}
my $segment_count = $parent->can('denormalized_segment_count') ? $parent->denormalized_segment_count : $parent->can('denormalized_segments ') ? $parent->denormalized_segments : $parent->can('segments') ? $parent->segments : 0; unless ($segment_count) { # convert into a segmented object
my $segment; if ($parent->can('clone')) { $segment = $parent->clone; } else { my %clone = %$parent; $segment = bless\% clone,ref $parent; } delete $segment->{segments}; eval {$segment->object_store(undef) }; $segment->primary_id(undef); # this updates the object and expands its start and end positions without writing
# the segments into the database as individual objects
$parent->add_segment($segment); } $parent->add_segment($child); 1; # for debugging
} # a conventional Bio::SeqFeature::Generic object - create a split location
else { my $current_location = $parent->location; if ($current_location->can('add_sub_Location')) { $current_location->add_sub_Location($child->location); } else { eval "require Bio::Location::Split" unless Bio::Location::Split->can('add_sub_Location'); my $new_location = Bio::Location::Split->new(); $new_location->add_sub_Location($current_location); $new_location->add_sub_Location($child->location); $parent->location($new_location); } }
| parse_attributes | description | prev | next | Top |
my $self = shift; my $att = shift; my @pairs = map {my ($name,$value) = split /=/; [unescape($name) => unescape($value)] } split /;/,$att; my (%reserved,%unreserved); foreach (@pairs) { my $tag = $_->[0]; my @values = split /,/,$_->[1]; if ($Special_attributes{$tag}) { # reserved attribute}
push @{$reserved{$tag}},@values; } else { push @{$unreserved{$tag}},@values } } return (\%reserved,\%unreserved);
| start_or_finish_sequence | description | prev | next | Top |
my $self = shift; my $seqid = shift; if (my $sl = $self->{fasta_load}) { if (defined $sl->{seqid}) { $self->store->insert_sequence($sl->{seqid},$sl->{sequence},$sl->{offset}); delete $self->{fasta_load}; } } if (defined $seqid) { $self->{fasta_load} = {seqid => $seqid, offset => 0, sequence => ''}; }}
| load_sequence | description | prev | next | Top |
my $self = shift; my $seq = shift; my $sl = $self->{fasta_load} or return; my $cs = $self->seq_chunk_size; $sl->{sequence} .= $seq; while (length $sl->{sequence} >= $cs) { my $chunk = substr($sl->{sequence},0,$cs); $self->store->insert_sequence($sl->{seqid},$chunk,$sl->{offset}); $sl->{offset} += length $chunk; substr($sl->{sequence},0,$cs) = ''; }}
| msg | description | prev | next | Top |
my $self = shift; my @msg = @_; return unless $self->verbose; print STDERR @msg;}
| accessors | Top |
store() the long-term Bio::DB::SeqFeature::Store object
tmp_store() the temporary Bio::DB::SeqFeature::Store object used during loading sfclass() the Bio::SeqFeatureI class fast() whether fast loading is active seq_chunk_size() the sequence chunk size verbose() verbose progress messages
| Internal Methods | Top |
| BUGS | Top |
| SEE ALSO | Top |
| AUTHOR | Top |