[Bio] / FigMetagenomeTools / phage_data.pl Repository:
ViewVC logotype

View of /FigMetagenomeTools/phage_data.pl

Parent Directory Parent Directory | Revision Log Revision Log

Revision - (download) (as text) (annotate) (vendor branch)
Mon Feb 19 17:15:26 2007 UTC (13 years ago) by olson
Branch: x, MAIN
CVS Tags: mgrast_dev_08112011, mgrast_dev_08022011, mgrast_dev_05262011, mgrast_dev_04082011, mgrast_version_3_2, mgrast_dev_12152011, mgrast_dev_06072011, mgrast_rel_2008_0806, mgrast_dev_10262011, mgrast_dev_02212011, mgrast_rel_2008_0923, mgrast_release_3_0, mgrast_dev_03252011, mgrast_rel_2008_0924, mgrast_rel_2008_1110_v2, mgrast_rel_2008_0625, mgrast_release_3_0_4, mgrast_release_3_0_2, mgrast_release_3_0_3, mgrast_release_3_0_1, mgrast_dev_03312011, mgrast_release_3_1_2, mgrast_release_3_1_1, mgrast_release_3_1_0, mgrast_dev_04132011, mgrast_dev_04012011, mgrast_rel_2008_0919, mgrast_rel_2008_1110, myrast_33, mgrast_rel_2008_0917, mgrast_dev_04052011, mgrast_dev_02222011, y, HEAD
Changes since 1.1: +0 -0 lines
Initial import

#!/usr/bin/perl -w

use strict;
use DBI;

my $dbh=DBI->connect("DBI:mysql:phage", "rob", "forestry") or die "Can't connect to database\n";

foreach my $type (qw[Streptococcus Staphylococcus vibrio campylobacter listeria]) {
 print "*** $type ***\n";
 my $exc=$dbh->prepare("select count, organism, host from phage where (organism like '\%$type\%' or host like '\%$type\%')") || die $dbh->errstr;
 $exc->execute || die $dbh->errstr;
 while (my @res=$exc->fetchrow_array) {
  print join "\t", @res, "\n";

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3