Menu
▾
▴
[Treebase-guts] SF.net SVN: treebase:[534] trunk/treebase-core/db
|
From: <vga...@us...> - 2010-03-09 22:27:34
|
Revision: 534
http://treebase.svn.sourceforge.net/treebase/?rev=534&view=rev
Author: vgapeyev
Date: 2010-03-09 22:27:21 +0000 (Tue, 09 Mar 2010)
Log Message:
-----------
A directory to keep track of data cleaning tasks
Modified Paths:
--------------
trunk/treebase-core/db/schema/TODO.txt
Added Paths:
-----------
trunk/treebase-core/db/cleaning/
trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/
trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/README.txt
trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/fixlabels_trans.pl
trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/output.txt
trunk/treebase-core/db/cleaning/README.txt
trunk/treebase-core/db/cleaning/TODO.txt
Added: trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/README.txt
===================================================================
--- trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/README.txt (rev 0)
+++ trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/README.txt 2010-03-09 22:27:21 UTC (rev 534)
@@ -0,0 +1,22 @@
+A perl script from Bill to remove duplicate taxon labels.
+
+Before running, adjust passwords in fixlabels_trans.pl
+
+Was run 2010-03-03, after Dec'2009 matrices and trees were loaded, but prior to loading Dec'2009 Taxon intelligence.
+
+output.txt contains the output from this script.
+
+The stdout was:
+The database starts with 101401 redundant records.
+The database ends with 0 redundant records.
+
+
+
+This query checks whether there are duplicate taxon labels.
+
+SELECT COUNT(*) FROM
+(SELECT study_id, taxonlabel, COUNT(taxonlabel_id)
+FROM taxonlabel WHERE study_id IS NOT NULL
+GROUP BY study_id, taxonlabel HAVING COUNT(taxonlabel_id) > 1
+ORDER BY COUNT(taxonlabel_id) DESC) AS countrecs;
+
Added: trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/fixlabels_trans.pl
===================================================================
--- trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/fixlabels_trans.pl (rev 0)
+++ trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/fixlabels_trans.pl 2010-03-09 22:27:21 UTC (rev 534)
@@ -0,0 +1,167 @@
+#!/usr/bin/perl
+
+use strict;
+use warnings;
+use DBI;
+
+# This script is intended to remove all taxonlabel records that are duplicates within the
+# same study. We start by getting a list of all studies. Then for each study_id, we get
+# a unique list of taxonlabels, picking from among the duplicates one taxonlabel_id that
+# will survive the culling; then we pick out a taxonvariant_id so that we can be sure that
+# the surviving taxonlabel has a mapping to taxonvariants. For each taxonlabel_id that
+# is destined to be deleted, we first update all tables that use it as a foreign key
+# and modify them to use the taxonlabel_id of the surviving record. Note that we cannot
+# just update the corresponding record in sub_taxonlabel because that would violate the
+# constraint that taxonlabel_id in sub_taxonlabel be unique. Instead, we delete any
+# sub_taxonlabel records that have a taxonlabel_id that is determined to be redundant.
+
+# For a local database:
+
+my $database = "tb2synops";
+my $username = "piel";
+my $password = "";
+
+# For the remote database, uncomment this (and also uncomment line 142):
+
+# my $database = "treebasedev";
+# my $username = "treebase_app";
+# my $password = "tim5tema";
+
+
+my $dbh = &ConnectToPg($database, $username, $password);
+
+# Let's start by counting the number of redundant taxonlabel_ids:
+
+my $count = q|SELECT COUNT(*) FROM |;
+$count .= q|(SELECT study_id, taxonlabel, COUNT(taxonlabel_id) |;
+$count .= q|FROM taxonlabel WHERE study_id IS NOT NULL |;
+$count .= q|GROUP BY study_id, taxonlabel HAVING COUNT(taxonlabel_id) > 1 |;
+$count .= q|ORDER BY COUNT(taxonlabel_id) DESC) AS countrecs |;
+
+my $totRec = $dbh->selectrow_array ($count);
+print "The database starts with $totRec redundant records.\n";
+
+# Assuming that the study_id column in taxonlabel is accurate,
+# lets get a distinct list of all study_ids
+
+my $query = q|SELECT DISTINCT study_id FROM taxonlabel WHERE study_id IS NOT NULL |;
+
+my $sth = $dbh->prepare($query)
+or die "Can't prepare $query: $dbh->errstr\n";
+my $rv = $sth->execute
+or die "can't execute the query: $sth->errstr\n";
+
+my @studyids; #unique list of all study_ids, as taken from the taxonlabel table
+
+while(my @row = $sth->fetchrow_array) {
+ push(@studyids, $row[0]);
+}
+my $rd = $sth->finish;
+
+$query = qq|SELECT taxonlabel, MIN(taxonlabel_id), MAX(taxonvariant_id) FROM taxonlabel |;
+$query .= qq|WHERE study_id = ? GROUP BY taxonlabel HAVING COUNT(taxonlabel_id) > 1 |;
+my $sth_getuniques = $dbh->prepare($query) or die "Can't prepare $query: $dbh->errstr\n";
+
+my $file ="output.txt";
+open(OUTPUT,">$file") || die "Content-type: text/html\n\nCannot open $file!";
+
+foreach my $stid ( @studyids ) {
+ my %taxonlabels;
+
+ # get a unique list of taxonlabel values and store the lowest taxonlabel_id,
+ # and the highest taxonvariant_id
+
+ my $rv = $sth_getuniques->execute( $stid );
+ while(my @row = $sth_getuniques->fetchrow_array) {
+ $taxonlabels{ $row[0] } = [ $row[1], $row[2] ];
+ }
+ my $rd = $sth_getuniques->finish;
+
+ # get a list of taxonlabel_ids that need to be deleted (ie they are redundant)
+ $query = qq|SELECT taxonlabel_id FROM taxonlabel WHERE taxonlabel = ? AND study_id = ? AND taxonlabel_id <> ? |;
+ my $sth_getdups = $dbh->prepare($query) or die "Can't prepare $query: $dbh->errstr\n";
+
+ foreach my $uniquetaxonlabel ( keys(%taxonlabels) ) {
+
+ eval {
+ my $dup_taxlabid;
+ my $rv = $sth_getdups->execute( $uniquetaxonlabel, $stid, $taxonlabels{$uniquetaxonlabel}[0] );
+ while(my @row = $sth_getdups->fetchrow_array) {
+ $dup_taxlabid = $row[0];
+
+ # first check that the sub_taxonlabel table has a record for the surviving taxonlabel_id
+
+ my $sub_taxonlabel_count = "SELECT COUNT(*) FROM sub_taxonlabel WHERE taxonlabel_id = " . $taxonlabels{$uniquetaxonlabel}[0] ;
+ my $sub_totRec = $dbh->selectrow_array ($sub_taxonlabel_count);
+
+ if ( $sub_totRec == 1) {
+
+ # now that we have a taxonlabel_id that can be deleted, let's update all records in
+ # other tables that use this id so that they use the taxonlabel_id of the surviving taxonlabel record
+
+ # we are ready to delete the sub_taxonlabel record that has our $dup_taxlabid
+ $dbh->do( "DELETE FROM sub_taxonlabel WHERE taxonlabel_id = ? ", undef, $dup_taxlabid );
+
+ # let's update the tables that have a FK with $dup_taxlabid so that they point to the surviving record
+ foreach my $tble ( 'phylotreenode', 'rowsegment', 'taxonlabelgroup_taxonlabel', 'taxonlabelset_taxonlabel', 'matrixrow' ) {
+ $dbh->do( "UPDATE $tble SET taxonlabel_id = ? WHERE taxonlabel_id = ? ", undef, $taxonlabels{$uniquetaxonlabel}[0], $dup_taxlabid );
+ }
+
+ # now we are ready to delete this redundant taxonlabel record
+ $dbh->do( "DELETE FROM taxonlabel WHERE taxonlabel_id = ? ", undef, $dup_taxlabid );
+
+ # optionally: print out a list of all deleted taxonlabel records
+ print OUTPUT "study $stid: taxonlabel $uniquetaxonlabel: $dup_taxlabid deleted in favor of $taxonlabels{$uniquetaxonlabel}[0]\n";
+ } elsif ($sub_totRec == 0) {
+ print "Whoops... sub_taxonlabel lacks a record for the surviving taxonlabel_id $taxonlabels{$uniquetaxonlabel}[0] \n";
+ } else {
+ print "Whoops... I didn't expect sub_taxonlabel to have $sub_totRec records with taxonlabel_id $taxonlabels{$uniquetaxonlabel}[0] \n";
+ print " > $sub_taxonlabel_count\n";
+ }
+
+ }
+ my $rd = $sth_getdups->finish;
+
+ # Make sure that the surviving taxonlabel has a taxonvariant_id
+ $dbh->do( "UPDATE taxonlabel SET taxonvariant_id = ? WHERE taxonlabel_id = ? ", undef, $taxonlabels{$uniquetaxonlabel}[1], $taxonlabels{$uniquetaxonlabel}[0] );
+
+ # If no errors so far, let's commit this set of changes
+ $dbh->commit();
+ };
+
+ if ($@) {
+ warn "Failed to fix $uniquetaxonlabel: $@\n";
+ $dbh->rollback();
+ }
+
+ }
+}
+
+close(OUTPUT);
+
+$totRec = $dbh->selectrow_array ($count);
+print "The database ends with $totRec redundant records.\n";
+
+
+my $rc = $dbh->disconnect;
+
+
+
+# Connect to Postgres using DBI
+#==============================================================
+sub ConnectToPg {
+
+ my ($cstr, $user, $pass) = @_;
+
+ $cstr = "DBI:Pg:dbname="."$cstr";
+ # uncomment this to run against the server at NESCent:
+ # $cstr .= ";host=treebasedb-dev.nescent.org";
+
+
+ my $dbh = DBI->connect($cstr, $user, $pass, {AutoCommit => 0, PrintError => 1, RaiseError => 1});
+ $dbh || &error("DBI connect failed : ",$dbh->errstr);
+
+ return($dbh);
+}
+
+
Property changes on: trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/fixlabels_trans.pl
___________________________________________________________________
Added: svn:executable
+ *
Added: trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/output.txt
===================================================================
--- trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/output.txt (rev 0)
+++ trunk/treebase-core/db/cleaning/2010-03-03_fixlabels/output.txt 2010-03-09 22:27:21 UTC (rev 534)
@@ -0,0 +1,101409 @@
+study 1074: taxonlabel Gaertneriomyces semiglobiferus: 141235 deleted in favor of 18109
+study 1074: taxonlabel Spizellomyces plurigibbosus: 141242 deleted in favor of 18114
+study 1074: taxonlabel Orpinomyces sp: 141218 deleted in favor of 18091
+study 1074: taxonlabel Anaeromyces K9: 141226 deleted in favor of 18100
+study 1074: taxonlabel Powellomyces sp: 141223 deleted in favor of 18111
+study 1074: taxonlabel Anaeromyces sp AUC2: 141224 deleted in favor of 18104
+study 1074: taxonlabel Spizellomyces kniepii: 141219 deleted in favor of 18113
+study 1074: taxonlabel Rhizophlyctis rosea: 141244 deleted in favor of 13180
+study 1074: taxonlabel Anaeromyces sp: 141222 deleted in favor of 18097
+study 1074: taxonlabel Anaeromyces JF1: 141234 deleted in favor of 18093
+study 1074: taxonlabel Orpinomyces sp 1: 141241 deleted in favor of 18101
+study 1074: taxonlabel Anaeromyces K5: 141220 deleted in favor of 18107
+study 1074: taxonlabel Piromyces PrI: 141236 deleted in favor of 18103
+study 1074: taxonlabel Neocallimastix patriciarum: 141230 deleted in favor of 18099
+study 1074: taxonlabel Piromyces polycephalus: 141237 deleted in favor of 18105
+study 1074: taxonlabel Kochiomyces dichotomus: 141233 deleted in favor of 18110
+study 1074: taxonlabel Spizellomyces pseudodichotomus: 141231 deleted in favor of 18108
+study 1074: taxonlabel Neocallimastix hurleyensis: 141232 deleted in favor of 18089
+study 1074: taxonlabel Anaeromyces sp AUC1: 141229 deleted in favor of 18094
+study 1074: taxonlabel Orpinomyces sp 2: 141217 deleted in favor of 18090
+study 1074: taxonlabel Anaeromyces BF1: 141225 deleted in favor of 18096
+study 1074: taxonlabel Orpinomyces KF1: 141238 deleted in favor of 18098
+study 1074: taxonlabel Orpinomyces KF2: 141239 deleted in favor of 18095
+study 1074: taxonlabel Orpinomyces KF3: 141221 deleted in favor of 18102
+study 1074: taxonlabel Caecomyces communis: 141228 deleted in favor of 18092
+study 1074: taxonlabel Neocallimastix frontalis SR4: 141240 deleted in favor of 18106
+study 1548: taxonlabel Gnetum urens: 172470 deleted in favor of 7378
+study 1548: taxonlabel Encephalartos altensteinii: 172456 deleted in favor of 31328
+study 1548: taxonlabel Gnetum sp Takeuchi7049: 172465 deleted in favor of 31302
+study 1548: taxonlabel Gnetum africanum: 172460 deleted in favor of 7345
+study 1548: taxonlabel Gnetum paniculatum: 172453 deleted in favor of 31299
+study 1548: taxonlabel Gnetum raya: 172449 deleted in favor of 31308
+study 1548: taxonlabel Gnetum hainanense Won600: 172448 deleted in favor of 31306
+study 1548: taxonlabel Taxus baccata: 172476 deleted in favor of 7398
+study 1548: taxonlabel Cycas taitungensis: 172463 deleted in favor of 31323
+study 1548: taxonlabel Gnetum schwackeanum: 172486 deleted in favor of 31300
+study 1548: taxonlabel Gnetum parvifolium: 172457 deleted in favor of 7350
+study 1548: taxonlabel Cupressus sempervirens: 172480 deleted in favor of 29195
+study 1548: taxonlabel Gnetum tenuifolium: 172478 deleted in favor of 31316
+study 1548: taxonlabel Gnetum cuspidatum: 172477 deleted in favor of 31307
+study 1548: taxonlabel Picea rubens: 172443 deleted in favor of 31327
+study 1548: taxonlabel Gnetum nodiflorum: 172435 deleted in favor of 7356
+study 1548: taxonlabel Gnetum acutum: 172459 deleted in favor of 31304
+study 1548: taxonlabel Gnetum latifolium Won575: 172432 deleted in favor of 31312
+study 1548: taxonlabel Gnetum hainanense Won580: 172433 deleted in favor of 31313
+study 1548: taxonlabel Cunninghamia lanceolata: 172472 deleted in favor of 31330
+study 1548: taxonlabel Gnetum montanum: 172430 deleted in favor of 7414
+study 1548: taxonlabel Gnetum neglectum: 172461 deleted in favor of 31309
+study 1548: taxonlabel Gnetum diminutum: 172488 deleted in favor of 31315
+study 1548: taxonlabel Gnetum gnemon Ashby: 172479 deleted in favor of 31321
+study 1548: taxonlabel Gnetum gnemonoides: 172440 deleted in favor of 31320
+study 1548: taxonlabel Gnetum woodsonianum: 172471 deleted in favor of 31319
+study 1548: taxonlabel Magnolia denudata: 172439 deleted in favor of 31331
+study 1548: taxonlabel Nageia nagi: 172489 deleted in favor of 8057
+study 1548: taxonlabel Gnetum sp Harder5621: 172454 deleted in favor of 31301
+study 1548: taxonlabel Ephedra sinica: 172464 deleted in favor of 7353
+study 1548: taxonlabel Cephalotaxus oliveri: 172469 deleted in favor of 31334
+study 1548: taxonlabel Gnetum latifolium Won524: 172487 deleted in favor of 31322
+study 1548: taxonlabel Nuphar variegata: 172466 deleted in favor of 31325
+study 1548: taxonlabel Gnetum gnemon Won514: 172473 deleted in favor of 31305
+study 1548: taxonlabel Welwitschia AF280996: 172455 deleted in favor of 31329
+study 1548: taxonlabel Gnetum aff. latifolium Won545: 172474 deleted in favor of 31298
+study 1548: taxonlabel Ephedra trifurca: 172434 deleted in favor of 31324
+study 1548: taxonlabel Calocedrus decurrens: 172429 deleted in favor of 29189
+study 1548: taxonlabel Gnetum ula: 172484 deleted in favor of 31310
+study 1548: taxonlabel Agathis borneensis: 172483 deleted in favor of 31336
+study 1548: taxonlabel Gnetum microstachyum: 172462 deleted in favor of 31314
+study 1548: taxonlabel Phyllocladus trichomanoides: 172428 deleted in favor of 8061
+study 1548: taxonlabel Zamia floridana: 172452 deleted in favor of 18271
+study 1548: taxonlabel Gnetum hainanense RBGE: 172441 deleted in favor of 31311
+study 1548: taxonlabel Gnetum costatum: 172468 deleted in favor of 7359
+study 1548: taxonlabel Bowenia serrulata: 172431 deleted in favor of 7416
+study 1548: taxonlabel Gnetum klossii: 172447 deleted in favor of 31317
+study 1548: taxonlabel Gnetum aff. latifolium SAN151116: 172475 deleted in favor of 31297
+study 1548: taxonlabel Abies firma: 172481 deleted in favor of 31335
+study 1548: taxonlabel Gnetum macrostachyum: 172450 deleted in favor of 31318
+study 1548: taxonlabel Gnetum gnemon clone: 172437 deleted in favor of 31332
+study 1548: taxonlabel Gnetum microcarpum: 172485 deleted in favor of 31303
+study 1548: taxonlabel Araucaria hunsteinii: 172467 deleted in favor of 31337
+study 1548: taxonlabel Gnetum hainanense: 172438 deleted in favor of 31333
+study 2026: taxonlabel Albugo candida ex. Biscutella laevig: 210693 deleted in favor of 78176
+study 2026: taxonlabel Albugo koreana CA2: 210686 deleted in favor of 78197
+study 2026: taxonlabel Albugo candida ex. Arabis turrita CA: 210655 deleted in favor of 78172
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA220: 210683 deleted in favor of 78209
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA10: 210658 deleted in favor of 78211
+study 2026: taxonlabel Albugo occidentalis AY286220: 210665 deleted in favor of 78191
+study 2026: taxonlabel Albugo candida ex. Descurainia sophi: 210678 deleted in favor of 78170
+study 2026: taxonlabel Albugo candida ex. Draba verna BP74: 210682 deleted in favor of 78210
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA220: 210674 deleted in favor of 78173
+study 2026: taxonlabel Pustula tragopogonis AY286221: 210694 deleted in favor of 78200
+study 2026: taxonlabel Albugo candida ex. Diplotaxis erucoi: 210689 deleted in favor of 78177
+study 2026: taxonlabel Wilsoniana portulacae CA17: 210663 deleted in favor of 78179
+study 2026: taxonlabel Albugo trianthemae CA50: 210673 deleted in favor of 78160
+study 2026: taxonlabel Albugo candida ex. Brassica juncea C: 210676 deleted in favor of 78169
+study 2026: taxonlabel Albugo lepidii ex. Lepidium apetalum: 210649 deleted in favor of 78167
+study 2026: taxonlabel Albugo candida ex. Iberis amara CA1: 210644 deleted in favor of 78193
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA319: 210660 deleted in favor of 78185
+study 2026: taxonlabel Albugo candida ex. Cardaminopsis hal: 210653 deleted in favor of 78182
+study 2026: taxonlabel Albugo candida ex. Lunaria sp. CU19: 210672 deleted in favor of 78207
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA319: 210675 deleted in favor of 78204
+study 2026: taxonlabel Albugo candida ex. Erysimum cuspidat: 210687 deleted in favor of 78174
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA10: 210652 deleted in favor of 78188
+study 2026: taxonlabel Albugo candida ex. Thlaspi arvense: 210647 deleted in favor of 78202
+study 2026: taxonlabel Albugo candida ex. Sisymbrium leteum: 210679 deleted in favor of 78175
+study 2026: taxonlabel Albugo candida ex. Aubrietia deltoid: 210661 deleted in favor of 78181
+study 2026: taxonlabel Albugo koreana CA3: 210643 deleted in favor of 78198
+study 2026: taxonlabel Albugo koreana ex. CA2: 210692 deleted in favor of 78180
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA219: 210681 deleted in favor of 78208
+study 2026: taxonlabel Albugo candida ex. Arabis turrita C: 210651 deleted in favor of 78194
+study 2026: taxonlabel Albugo candida ex. Draba lasiocarpa: 210666 deleted in favor of 78201
+study 2026: taxonlabel Albugo candida ex. Iberis amara CA18: 210664 deleted in favor of 78162
+study 2026: taxonlabel Albugo capparis ex. Capparis rupestr: 210667 deleted in favor of 78195
+study 2026: taxonlabel Albugo candida ex. Diptychocarpus st: 210645 deleted in favor of 78171
+study 2026: taxonlabel Albugo chardoni ex. Draba verna CA1: 210646 deleted in favor of 78199
+study 2026: taxonlabel Albugo candida ex. Eruca sativa CA2: 210680 deleted in favor of 78203
+study 2026: taxonlabel Albugo candida ex. C bursa pastoris: 210670 deleted in favor of 78189
+study 2026: taxonlabel Albugo candida ex. Berteroa incana C: 210650 deleted in favor of 78168
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA161: 210657 deleted in favor of 78192
+study 2026: taxonlabel Albugo candida ex. Berteroa incana: 210691 deleted in favor of 78206
+study 2026: taxonlabel Albugo sp. ex. Draba nemorosa CA219: 210684 deleted in favor of 78166
+study 2026: taxonlabel Albugo candida ex. Eruca sativa CA25: 210654 deleted in favor of 78184
+study 2026: taxonlabel Albugo chardoni ex. Cleome anomala C: 210685 deleted in favor of 78205
+study 2026: taxonlabel Albugo candida ex. Brassica juncea: 210677 deleted in favor of 78196
+study 2026: taxonlabel Albugo koreana ex. CA3: 210668 deleted in favor of 78161
+study 2026: taxonlabel Albugo candida ex. Raphanus sativus: 210648 deleted in favor of 78190
+study 2026: taxonlabel Albugo candida ex. Heliophila meyeri: 210669 deleted in favor of 78163
+study 2026: taxonlabel Albugo lepidii ex. Lepidium virginic: 210662 deleted in favor of 78186
+study 2026: taxonlabel Albugo ipomoeae panduratae CA25: 210659 deleted in favor of 78165
+study 2026: taxonlabel Albugo candida ex. Lunaria sp. CU19: 210656 deleted in favor of 78164
+study 2026: taxonlabel Albugo candida ex. Thlaspi arvense C: 210690 deleted in favor of 78183
+study 2026: taxonlabel Wilsoniana achyranthis CA19: 210671 deleted in favor of 78178
+study 2026: taxonlabel Wilsoniana bliti CA24: 210688 deleted in favor of 78187
+study 264: taxonlabel Richea B: 109718 deleted in favor of 19006
+study 264: taxonlabel Styphelia: 109697 deleted in favor of 19025
+study 264: taxonlabel Woollsia: 109713 deleted in favor of 19008
+study 264: taxonlabel Rupicola: 109698 deleted in favor of 19026
+study 264: taxonlabel Oligarrhena: 109721 deleted in favor of 19004
+study 264: taxonlabel Lebetanthus: 109710 deleted in favor of 19023
+study 264: taxonlabel Andersonia B: 109709 deleted in favor of 19019
+study 264: taxonlabel Gaultheria: 109715 deleted in favor of 19022
+study 264: taxonlabel Astroloma: 109719 deleted in favor of 19017
+study 264: taxonlabel Dracophyllum B: 109716 deleted in favor of 19014
+study 264: taxonlabel Melichrus: 109720 deleted in favor of 19009
+study 264: taxonlabel Dracophyllum A: 109712 deleted in favor of 19013
+study 264: taxonlabel Budawangia: 109704 deleted in favor of 19003
+study 264: taxonlabel Sprengelia: 109696 deleted in favor of 19020
+study 264: taxonlabel Cosmelia: 109708 deleted in favor of 19011
+study 264: taxonlabel Erica: 109706 deleted in favor of 19002
+study 264: taxonlabel Needhamiella: 109703 deleted in favor of 19024
+study 264: taxonlabel Lysinema: 109711 deleted in favor of 19015
+study 264: taxonlabel Sphenotoma: 109714 deleted in favor of 19010
+study 264: taxonlabel Prionotes: 109702 deleted in favor of 19001
+study 264: taxonlabel Richea A: 109707 deleted in favor of 19021
+study 264: taxonlabel Andersonia A: 109699 deleted in favor of 19012
+study 264: taxonlabel Dracophyllum C: 109701 deleted in favor of 19007
+study 264: taxonlabel Epacris: 109705 deleted in favor of 19018
+study 887: taxonlabel Diphysa humilis: 132218 deleted in favor of 819
+study 887: taxonlabel Ormocarpum rectangulare: 132184 deleted in favor of 9267
+study 887: taxonlabel Ormocarpum schliebenii: 132187 deleted in favor of 778
+study 887: taxonlabel Ormocarpum somalense: 132209 deleted in favor of 9273
+study 887: taxonlabel Pictetia sulcata: 132199 deleted in favor of 828
+study 887: taxonlabel Ormocarpum orientale: 132250 deleted in favor of 816
+study 887: taxonlabel Ormocarpum trichocarpum: 132201 deleted in favor of 786
+study 887: taxonlabel Diphysa racemosa: 132228 deleted in favor of 9263
+study 887: taxonlabel Pictetia mucronata: 132163 deleted in favor of 803
+study 887: taxonlabel Ormocarpum megalophyllum: 132191 deleted in favor of 821
+study 887: taxonlabel Chapmannia reghidensis: 132180 deleted in favor of 9269
+study 887: taxonlabel Chapmannia somalensis: 132216 deleted in favor of 9280
+study 887: taxonlabel Pictetia nipensis: 132151 deleted in favor of 785
+study 887: taxonlabel Pictetia marginata1: 132152 deleted in favor of 9258
+study 887: taxonlabel Diphysa spinosa: 132224 deleted in favor of 9257
+study 887: taxonlabel Ormocarpum flavum: 132202 deleted in favor of 798
+study 887: taxonlabel Ormocarpum muricatum: 132205 deleted in favor of 9235
+study 887: taxonlabel Diphysa spinosa1: 132149 deleted in favor of 9259
+study 887: taxonlabel Arachis magna: 132229 deleted in favor of 9279
+study 887: taxonlabel Ormocarpum dhofarense: 132211 deleted in favor of 9243
+study 887: taxonlabel Arachis batizocoi: 132185 deleted in favor of 9252
+study 887: taxonlabel Diphysa suberosa1: 132231 deleted in favor of 9245
+study 887: taxonlabel Ormocarpum drakei1: 132196 deleted in favor of 9271
+study 887: taxonlabel Diphysa thurberi: 132175 deleted in favor of 788
+study 887: taxonlabel Ormocarpum kirkii1: 132245 deleted in favor of 9241
+study 887: taxonlabel Stylosanthes guianensis: 132219 deleted in favor of 9253
+study 887: taxonlabel Arachis hermannii: 132241 deleted in favor of 9250
+study 887: taxonlabel Diphysa racemosa1: 132204 deleted in favor of 9265
+study 887: taxonlabel Diphysa americana2: 132203 deleted in favor of 9260
+study 887: taxonlabel Chapmannia tinireana: 132188 deleted in favor of 9248
+study 887: taxonlabel Ormocarpopsis tulearensis: 132162 deleted in favor of 801
+study 887: taxonlabel Arachis palustris: 132249 deleted in favor of 9270
+study 887: taxonlabel Pictetia aculeata1: 132181 deleted in favor of 9249
+study 887: taxonlabel Diphysa ormocarpoides1: 132253 deleted in favor of 9277
+study 887: taxonlabel Ormocarpum sennoides: 132254 deleted in favor of 824
+study 887: taxonlabel Ormocarpum verrucosum: 132234 deleted in favor of 799
+study 887: taxonlabel Diphysa americana1: 132244 deleted in favor of 9244
+study 887: taxonlabel Ormocarpum kirkii2: 132230 deleted in favor of 9242
+study 887: taxonlabel Dalbergia sissoo1: 132176 deleted in favor of 9275
+study 887: taxonlabel Arachis correntina: 132192 deleted in favor of 9264
+study 887: taxonlabel Pictetia obcordata: 132240 deleted in favor of 784
+study 887: taxonlabel Machaerium inundatum: 132171 deleted in favor of 9246
+study 887: taxonlabel Ormocarpum pubescens: 132154 deleted in favor of 825
+study 887: taxonlabel Diphysa suberosa: 132233 deleted in favor of 9240
+study 887: taxonlabel Ormocarpum bernierianum1: 132242 deleted in favor of 9262
+study 887: taxonlabel Ormocarpopsis mandrarensis: 132168 deleted in favor of 780
+study 887: taxonlabel Pictetia mucronata1: 132164 deleted in favor of 9239
+study 887: taxonlabel Ormocarpopsis aspera: 132212 deleted in favor of 820
+study 887: taxonlabel Ormocarpum drakei: 132167 deleted in favor of 9255
+study 887: taxonlabel Adesmia volckmannii1: 132232 deleted in favor of 9247
+study 887: taxonlabel Ormocarpum gillettii: 132195 deleted in favor of 9251
+study 887: taxonlabel Ormocarpum gillettii1: 132200 deleted in favor of 9274
+study 887: taxonlabel Pictetia spinosa: 132189 deleted in favor of 797
+study 887: taxonlabel Ormocarpopsis parvifolia1: 132193 deleted in favor of 9256
+study 887: taxonlabel Diphysa sennoides: 132220 deleted in favor of 818
+study 887: taxonlabel Ormocarpopsis parvifolia: 132252 deleted in favor of 9261
+study 887: taxonlabel Arachis villosa: 132165 deleted in favor of 9276
+study 887: taxonlabel Ormocarpum trachycarpum: 132182 deleted in favor of 795
+study 887: taxonlabel Arachis triseminata: 132227 deleted in favor of 9077
+study 887: taxonlabel Diphysa macrophylla: 132225 deleted in favor of 792
+study 2024: taxonlabel Neotyphodium sp 1081Bpu: 210432 deleted in favor of 77929
+study 2024: taxonlabel Epichloe typhina 200736Lp: 210462 deleted in favor of 77932
+study 2024: taxonlabel Neotyphodium sp 4078LaA: 210427 deleted in favor of 77939
+study 2024: taxonlabel Brachyelytrum erectum: 210437 deleted in favor of 77968
+study 2024: taxonlabel Epichloe amarillans 200743So: 210454 deleted in favor of 77947
+study 2024: taxonlabel Agrostis tenuis: 210416 deleted in favor of 77966
+study 2024: taxonlabel Epichloe bromicola 201558Br: 210426 deleted in favor of 77928
+study 2024: taxonlabel Hordelymus europaeus: 210428 deleted in favor of 77958
+study 2024: taxonlabel Lolium sp P4074: 210413 deleted in favor of 77955
+study 2024: taxonlabel Lolium perenne2: 210442 deleted in favor of 77964
+study 2024: taxonlabel Neotyphodium canariense 989Lc: 210460 deleted in favor of 77948
+study 2024: taxonlabel Glyceria striata: 210443 deleted in favor of 8396
+study 2024: taxonlabel Lolium multiflorum: 210419 deleted in favor of 8410
+study 2024: taxonlabel Epichloe elymi 201551Ec: 210420 deleted in favor of 77944
+study 2024: taxonlabel Calamagrostis villosa: 210418 deleted in favor of 77961
+study 2024: taxonlabel Epichloe festucae 1157Kc: 210423 deleted in favor of 77941
+study 2024: taxonlabel Epichloe festucae 90660Frc: 210436 deleted in favor of 77931
+study 2024: taxonlabel Lolium perenne: 210446 deleted in favor of 13032
+study 2024: taxonlabel Neotyphodium lolii: 210453 deleted in favor of 38665
+study 2024: taxonlabel Bromus purgans: 210431 deleted in favor of 77953
+study 2024: taxonlabel Echinopogon ovatus: 210457 deleted in favor of 77963
+study 2024: taxonlabel Epichloe baconii 200745Cv: 210412 deleted in favor of 77934
+study 2024: taxonlabel Agrostis hiemalis: 210458 deleted in favor of 77967
+study 2024: taxonlabel Bromus erectus: 210444 deleted in favor of 5777
+study 2024: taxonlabel Epichloe bromicola 200749Be: 210461 deleted in favor of 77951
+study 2024: taxonlabel Neotyphodium sp 3635Hbr: 210459 deleted in favor of 77936
+study 2024: taxonlabel Epichloe festucae 28Fl: 210439 deleted in favor of 77949
+study 2024: taxonlabel Neotyphodium gansuense 818Ai: 210415 deleted in favor of 77935
+study 2024: taxonlabel Epichloe glyceriae 200755Gs: 210414 deleted in favor of 77945
+study 2024: taxonlabel Sphenopholis obtusata: 210441 deleted in favor of 77965
+study 2024: taxonlabel Neotyphodium aotearoae 829: 210411 deleted in favor of 77950
+study 2024: taxonlabel Achnatherum inebrians: 210421 deleted in favor of 77957
+study 2024: taxonlabel Bromus ramosus: 210455 deleted in favor of 5795
+study 2024: taxonlabel Lolium sp P4078: 210447 deleted in favor of 77969
+study 2024: taxonlabel Brachypodum sylvaticum: 210430 deleted in favor of 77956
+study 2024: taxonlabel Hordeum brevisublulatum: 210429 deleted in favor of 77970
+study 2024: taxonlabel Neotyphodium occultans 999Lm: 210452 deleted in favor of 77943
+study 2024: taxonlabel Festuca rubra: 210451 deleted in favor of 13044
+study 2024: taxonlabel Koeleria cristata: 210433 deleted in favor of 77952
+study 2024: taxonlabel Lolium arundinaceum: 210425 deleted in favor of 77962
+study 2024: taxonlabel Epichloe baconii 200746At: 210434 deleted in favor of 77946
+study 2024: taxonlabel Epichloe sylvatica 200751Bs: 210445 deleted in favor of 77930
+study 2024: taxonlabel Neotyphodium sp 4074LaT: 210440 deleted in favor of 77942
+study 2024: taxonlabel Holcus mollis: 210417 deleted in favor of 77960
+study 2024: taxonlabel Epichloe amarillans 200744Ah: 210448 deleted in favor of 77937
+study 2024: taxonlabel Epichloe brachyelytri: 210422 deleted in favor of 67495
+study 2024: taxonlabel Elymus canadensis: 210438 deleted in favor of 59186
+study 2024: taxonlabel Neotyphodium sp 362Heur: 210424 deleted in favor of 77938
+study 2024: taxonlabel Neotyphodium coenopialum 19T: 210435 deleted in favor of 77933
+study 2024: taxonlabel Epichloe sp 9924Hm: 210456 deleted in favor of 77940
+study 2024: taxonlabel Lolium edwardii: 210449 deleted in favor of 77959
+study 2024: taxonlabel Festuca longifolia: 210450 deleted in favor of 77954
+study 802: taxonlabel Pirodrilus minutus: 126519 deleted in favor of 4503
+study 802: taxonlabel Tubifex smirnowi: 126513 deleted in favor of 4481
+study 802: taxonlabel Limnodriloides barnardi: 126543 deleted in favor of 4498
+study 802: taxonlabel Bathydrilus formosus: 126526 deleted in favor of 4460
+study 802: taxonlabel Bothrioneurum vejdovskyanum: 126555 deleted in favor of 4463
+study 802: taxonlabel Limnodriloides monothecus: 126552 deleted in favor of 4478
+study 802: taxonlabel Heterodrilus queenslandicus: 126545 deleted in favor of 4455
+study 802: taxonlabel Heterodrilus paucifascis: 126537 deleted in favor of 4458
+study 802: taxonlabel Limnodriloides lateroporus: 126540 deleted in favor of 4444
+study 802: taxonlabel Heterodrilus minisetosus: 126517 deleted in favor of 4487
+study 802: taxonlabel Enchytraeus sp: 126525 deleted in favor of 4497
+study 802: taxonlabel Monopylephorus rubroniveus: 126546 deleted in favor of 4470
+study 802: taxonlabel Slavina appendiculata: 126548 deleted in favor of 4447
+study 802: taxonlabel Limnodriloides baculatus: 126549 deleted in favor of 4492
+study 802: taxonlabel Limnodrilus hoffmeisteri: 126531 deleted in favor of 4507
+study 802: taxonlabel Limnodriloides vespertinus: 126518 deleted in favor of 4453
+study 802: taxonlabel Thalassodrilides bruneti: 126556 deleted in favor of 4484
+study 802: taxonlabel Limnodriloides anxius: 126534 deleted in favor of 4445
+study 802: taxonlabel Chaetogaster diastrophus: 126520 deleted in favor of 4474
+study 802: taxonlabel Ainudrilus lutulentus: 126533 deleted in favor of 4462
+study 802: taxonlabel Tectidrilus verrucosus: 126512 deleted in favor of 4466
+study 802: taxonlabel Pristina longiseta: 126561 deleted in favor of 4469
+study 802: taxonlabel Olavius tantulus: 126544 deleted in favor of 4473
+study 802: taxonlabel Inanidrilus leukodermatus: 126532 deleted in favor of 4479
+study 802: taxonlabel Ainudrilus geminus: 126521 deleted in favor of 4499
+study 802: taxonlabel Olavius albidus: 126539 deleted in favor of 4495
+study 802: taxonlabel Olavius vacuus: 126562 deleted in favor of 4450
+study 802: taxonlabel Stylodrilus heringianus: 126502 deleted in favor of 4456
+study 802: taxonlabel Inanidrilus triangulatus: 126504 deleted in favor of 4446
+study 802: taxonlabel Limnodriloides armatus: 126554 deleted in favor of 4493
+study 802: taxonlabel Heterodrilus jamiesoni: 126505 deleted in favor of 4459
+study 802: taxonlabel Pectinodrilus molestus: 126558 deleted in favor of 4476
+study 802: taxonlabel Tubificoides parviductus: 126563 deleted in favor of 4505
+study 802: taxonlabel Buchholzia fallax: 126564 deleted in favor of 4465
+study 802: taxonlabel Tubificoides pseudogaster: 126514 deleted in favor of 4452
+study 802: taxonlabel Vejdovskyella comata: 126516 deleted in favor of 4488
+study 802: taxonlabel Tectidrilus bori: 126530 deleted in favor of 4477
+study 802: taxonlabel Olavius algarvensis: 126559 deleted in favor of 4485
+study 802: taxonlabel Heronidrilus heronae: 126501 deleted in favor of 4506
+study 802: taxonlabel Clitellio arenarius: 126541 deleted in favor of 4467
+study 802: taxonlabel Tubifex ignotus: 126507 deleted in favor of 4494
+study 802: taxonlabel Bathydrilus litoreus: 126523 deleted in favor of 4500
+study 802: taxonlabel Nais communis: 126542 deleted in favor of 4472
+study 802: taxonlabel Tubificoides benedii: 126529 deleted in favor of 4483
+study 802: taxonlabel Aktedrilus arcticus: 126547 deleted in favor of 4454
+study 802: taxonlabel Heterodrilus decipiens: 126553 deleted in favor of 4504
+study 802: taxonlabel Smithsonidrilus westoni: 126560 deleted in favor of 4468
+study 802: taxonlabel Thalassodrilides ineri: 126515 deleted in favor of 4508
+study 802: taxonlabel Bathydrilus adriaticus: 126538 deleted in favor of 4486
+study 802: taxonlabel Paranais litoralis: 126527 deleted in favor of 4496
+study 802: taxonlabel Inanidrilus aduncosetis: 126509 deleted in favor of 4490
+study 802: taxonlabel Smithsonidrilus hummelincki: 126535 deleted in favor of 4475
+study 802: taxonlabel Lumbricus castaneus: 126503 deleted in favor of 4471
+study 802: taxonlabel Insulodrilus bifidus: 126551 deleted in favor of 4482
+study 802: taxonlabel Limnodriloides rubicundus: 126550 deleted in favor of 4443
+study 802: taxonlabel Heterodrilus flexuosus: 126506 deleted in favor of 4502
+study 802: taxonlabel Thalassodrilides gurwitschi: 126528 deleted in favor of 4442
+study 802: taxonlabel Limnodrilus udekemianus: 126500 deleted in favor of 4491
+study 802: taxonlabel Limnodriloides appendiculatus: 126508 deleted in favor of 4457
+study 802: taxonlabel Bathydrilus rohdei: 126524 deleted in favor of 4501
+study 802: taxonlabel Doliodrilus tener: 126511 deleted in favor of 4449
+study 1513: taxonlabel Begonia symsanguinea: 170247 deleted in favor of 29810
+study 1513: taxonlabel Begonia versicolor: 170241 deleted in favor of 29844
+study 1513: taxonlabel Begonia variabilis: 170269 deleted in favor of 29822
+study 1513: taxonlabel Begonia leprosa: 170272 deleted in favor of 29811
+study 1513: taxonlabel Begonia hernandioides: 170276 deleted in favor of 29830
+study 1513: taxonlabel Begonia hemsleyana: 170275 deleted in favor of 29812
+study 1513: taxonlabel Begonia rajah: 170268 deleted in favor of 29849
+study 1513: taxonlabel Begonia dregei: 170271 deleted in favor of 17872
+study 1513: taxonlabel Begonia acetosella acetosella: 170258 deleted in favor of 29804
+study 1513: taxonlabel Begonia longifolia China: 170256 deleted in favor of 29801
+study 1513: taxonlabel Begonia xanthiana: 170254 deleted in favor of 29814
+study 1513: taxonlabel Begonia halconensis: 170226 deleted in favor of 29840
+study 1513: taxonlabel Begonia silletensis: 170231 deleted in favor of 29829
+study 1513: taxonlabel Begonia sp nov Sulawesi 254: 170229 deleted in favor of 29816
+study 1513: taxonlabel Begonia handelii prostrata: 170242 deleted in favor of 29836
+study 1513: taxonlabel Begonia chloroneura: 170225 deleted in favor of 29821
+study 1513: taxonlabel Begonia masoniana: 170232 deleted in favor of 17865
+study 1513: taxonlabel Begonia longifolia AY044980: 170234 deleted in favor of 29825
+study 1513: taxonlabel Begonia ceratocarpa: 170267 deleted in favor of 29827
+study 1513: taxonlabel Begonia cathayana: 170228 deleted in favor of 29826
+study 1513: taxonlabel Begonia kingiana: 170243 deleted in favor of 29831
+study 1513: taxonlabel Begonia morsei: 170263 deleted in favor of 29819
+study 1513: taxonlabel Begonia hayatae: 170236 deleted in favor of 29808
+study 1513: taxonlabel Begonia circumlobata: 170257 deleted in favor of 29817
+study 1513: taxonlabel Begonia cristata: 170259 deleted in favor of 29845
+study 1513: taxonlabel Begonia goegoensis: 170253 deleted in favor of 29828
+study 1513: taxonlabel Begonia taiwaniana: 170262 deleted in favor of 29832
+study 1513: taxonlabel Begonia longifolia Java: 170261 deleted in favor of 29843
+study 1513: taxonlabel Begonia labordei: 170230 deleted in favor of 29837
+study 1513: taxonlabel Begonia brevirimosa: 170246 deleted in favor of 29807
+study 1513: taxonlabel Begonia rubella: 170260 deleted in favor of 29824
+study 1513: taxonlabel Begonia amphioxis: 170233 deleted in favor of 29848
+study 1513: taxonlabel Begonia diadema: 170265 deleted in favor of 29809
+study 1513: taxonlabel Begonia oxysperma: 170250 deleted in favor of 29835
+study 1513: taxonlabel Begonia balansana: 170240 deleted in favor of 29805
+study 1513: taxonlabel Begonia multangula: 170252 deleted in favor of 29820
+study 1513: taxonlabel Begonia longicarpa: 170237 deleted in favor of 29846
+study 1513: taxonlabel Begonia rex: 170245 deleted in favor of 29803
+study 1513: taxonlabel Begonia pavonina: 170266 deleted in favor of 29841
+study 1513: taxonlabel Begonia roxburghii Female: 170251 deleted in favor of 29842
+study 1513: taxonlabel Begonia alveolata: 170238 deleted in favor of 29839
+study 1513: taxonlabel Begonia robusta: 170270 deleted in favor of 29838
+study 1513: taxonlabel Begonia chlorosticta: 170239 deleted in favor of 29818
+study 1513: taxonlabel Begonia roxburghii Male: 170244 deleted in favor of 29834
+study 1513: taxonlabel Begonia palmata: 170227 deleted in favor of 17870
+study 1513: taxonlabel Begonia malachosticta: 170255 deleted in favor of 29802
+study 1513: taxonlabel Begonia alpina: 170249 deleted in favor of 29823
+study 1513: taxonlabel Begonia muricata: 170235 deleted in favor of 29806
+study 1513: taxonlabel Begonia wenshanensis: 170264 deleted in favor of 29833
+study 1513: taxonlabel Begonia geranioides: 170273 deleted in favor of 29813
+study 1513: taxonlabel Begonia handelii handelii: 170274 deleted in favor of 29815
+study 1513: taxonlabel Begonia boisiana: 170248 deleted in favor of 29847
+study 1070: taxonlabel Phanacis 1: 141045 deleted in favor of 2408
+study 1070: taxonlabel Liposthenes gle: 141031 deleted in favor of 2391
+study 1070: taxonlabel Parnips: 141046 deleted in favor of 2398
+study 1070: taxonlabel Liposthenes ker: 141039 deleted in favor of 2395
+study 1070: taxonlabel Phanacis 2: 141027 deleted in favor of 2404
+study 1070: taxonlabel Aulacidea: 141024 deleted in favor of 2387
+study 1350: taxonlabel Erysiphe pulchra var. japonica: 159102 deleted in favor of 37503
+study 1350: taxonlabel Oidium hevea MUMH2418 Brazil: 159088 deleted in favor of 37462
+study 1350: taxonlabel Erysiphe sinensis: 159099 deleted in favor of 37480
+study 1350: taxonlabel Erysiphe trifolii var. trifolii: 159069 deleted in favor of 8777
+study 1350: taxonlabel Oidium hevea MUMH2602 Thailand: 159100 deleted in favor of 37452
+study 1350: taxonlabel Erysiphe sparsa: 159084 deleted in favor of 37490
+study 1350: taxonlabel Erysiphe sp. MUMH124 Japan: 159072 deleted in favor of 37457
+study 1350: taxonlabel Oidium sp. AF154328: 159086 deleted in favor of 37491
+study 1350: taxonlabel Oidium hevea MUMH2545 Malaysia: 159066 deleted in favor of 37482
+study 1350: taxonlabel Erysiphe pulchra var. japonica AB0009: 159078 deleted in favor of 37476
+study 1350: taxonlabel Oidium hevea MUMH2544 Malaysia: 159053 deleted in favor of 37495
+study 1350: taxonlabel Oidium sp. AB078800: 159075 deleted in favor of 37455
+study 1350: taxonlabel Erysiphe pulchra var. japonica AB0159: 159077 deleted in favor of 37464
+study 1350: taxonlabel Erysiphe friesii var. dahurica: 159057 deleted in favor of 37469
+study 1350: taxonlabel Oidium hevea MUMH2419 Brazil: 159091 deleted in favor of 37461
+study 1080: taxonlabel Synechococcus WH8103: 141623 deleted in favor of 18357
+study 1080: taxonlabel Synechococcus KU43Fr from Chondrilla nucula: 141620 deleted in favor of 18359
+study 1080: taxonlabel Synechococcus NACL5: 141619 deleted in favor of 18358
+study 1080: taxonlabel Prochlorococcus NATL2: 141624 deleted in favor of 18355
+study 1080: taxonlabel Synechococcus from Petrosia ficiformis: 141622 deleted in favor of 18354
+study 1080: taxonlabel Oscillatoria rosea: 141621 deleted in favor of 18356
+study 1209: taxonlabel Capnodium dermatum: 149503 deleted in favor of 3543
+study 1209: taxonlabel Chaetasbolisia falcata: 149522 deleted in favor of 3544
+study 1209: taxonlabel Dothiora rhamni alpinae: 149543 deleted in favor of 18384
+study 1209: taxonlabel Hormonema prunorum: 149534 deleted in favor of 18388
+study 1209: taxonlabel Phaeosclera dematioides: 149526 deleted in favor of 3554
+study 1209: taxonlabel Sarcinomyces crustaceus: 149508 deleted in favor of 3556
+study 1209: taxonlabel Capnobotryella renispora AY220611: 149533 deleted in favor of 3557
+study 1209: taxonlabel Endoconidioma populi UAMH 10297: 149549 deleted in favor of 61632
+study 1209: taxonlabel Kabatiella lini: 149523 deleted in favor of 18387
+study 1209: taxonlabel Aureobasidium pullulans AF013229: 149491 deleted in favor of 18390
+study 1209: taxonlabel Phaeocryptopus gaeumanii: 149550 deleted in favor of 18379
+study 1209: taxonlabel Dothiora europaea: 149504 deleted in favor of 18396
+study 1209: taxonlabel Kabatina juniperi AF182376: 149495 deleted in favor of 18385
+study 1209: taxonlabel Aureobasidium pullulans AF121287: 149551 deleted in favor of 18378
+study 1209: taxonlabel Antennariella californica: 149513 deleted in favor of 3555
+study 1209: taxonlabel Endoconidioma populi: 149515 deleted in favor of 3550
+study 1209: taxonlabel Hormonema sp ATCC74360: 149545 deleted in favor of 61633
+study 1209: taxonlabel Capnobotryella renispora AY220614: 149542 deleted in favor of 3534
+study 1209: taxonlabel Rhizosphaera pini: 149521 deleted in favor of 18394
+study 1209: taxonlabel Endoconidioma populi UAMH 10298: 149509 deleted in favor of 61631
+study 1209: taxonlabel Capnobotryella sp. nov AJ301706: 149520 deleted in favor of 3553
+study 1209: taxonlabel Hyphospora agavaciensis: 149535 deleted in favor of 3539
+study 1209: taxonlabel Aureobasidium pullulans AJ276062: 149512 deleted in favor of 18383
+study 1209: taxonlabel Rhizosphaera macrospora: 149517 deleted in favor of 18395
+study 1209: taxonlabel Rhizosphaera oudemansii: 149546 deleted in favor of 18393
+study 2125: taxonlabel Diplodia mutila: 219214 deleted in favor of 91946
+study 2125: taxonlabel Diplodia medicaginis CBS500.72: 219254 deleted in favor of 91903
+study 2125: taxonlabel Pseudofusicoccum stromaticum CBS117448: 219211 deleted in favor of 91884
+study 2125: taxonlabel Dothiorella iberica CBS115041: 219238 deleted in favor of 91889
+study 2125: taxonlabel Diplodia mutila CBS112553: 219282 deleted in favor of 46070
+study 2125: taxonlabel Diplodia corticola CBS112549: 219279 deleted in favor of 46047
+study 2125: taxonlabel Diplodia mutila CBS230.30: 219304 deleted in favor of 46079
+study 2125: taxonlabel Botryosphaeria tsugae CBS418.64: 219221 deleted in favor of 91906
+study 2125: taxonlabel Lasiodiplodia theobromae: 219236 deleted in favor of 67078
+study 2125: taxonlabel Phaeobotryosphaeria citrigena ICMP16812: 219274 deleted in favor of 91885
+study 2125: taxonlabel Dothiorella JL599: 219290 deleted in favor of 91940
+study 2125: taxonlabel Neofusicoccum ribis: 219213 deleted in favor of 23095
+study 2125: taxonlabel Lasiodiplodia venezuelensis CBS118739: 219298 deleted in favor of 91913
+study 2125: taxonlabel Diplodia cupressi CBS261.85: 219227 deleted in favor of 46068
+study 2125: taxonlabel Phaeobotryon mamane CPC12445: 219301 deleted in favor of 91934
+study 2125: taxonlabel Botryosphaeria dothidea CBS110302: 219295 deleted in favor of 28971
+study 2125: taxonlabel Neodeightonia phoenicum CBS169.34: 219228 deleted in favor of 91893
+study 2125: taxonlabel Diplodia acerina CBS910.73: 219265 deleted in favor of 91938
+study 2125: taxonlabel Neofusicoccum luteum CBS110497: 219223 deleted in favor of 91924
+study 2125: taxonlabel Spencermartinsia viticola CBS117009: 219207 deleted in favor of 91888
+study 2125: taxonlabel Dothidotthia symphoricarpi CPC12929: 219216 deleted in favor of 91945
+study 2125: taxonlabel Diplodia pinea C CBS109943: 219315 deleted in favor of 46066
+study 2125: taxonlabel Neofusicoccum parvum CBS110301: 219232 deleted in favor of 91914
+study 2125: taxonlabel Phaeobotryosphaeria citrigena ICMP16818: 219261 deleted in favor of 91939
+study 2125: taxonlabel Pseudofusicoccum stromaticum CBS117449: 219291 deleted in favor of 91905
+study 2125: taxonlabel Lasiodiplodia theobromae CBS124.13: 219273 deleted in favor of 91918
+study 2125: taxonlabel Phaeobotryon mamane CPC12443: 219250 deleted in favor of 91932
+study 2125: taxonlabel Dothiorella sarmentorum: 219235 deleted in favor of 91941
+study 2125: taxonlabel Diplodia cupressi CBS168.87: 219243 deleted in favor of 46072
+study 2125: taxonlabel Barriopsis fusca CBS174.26: 219287 deleted in favor of 91907
+study 2125: taxonlabel Spencermartinsia ICMP16827: 219313 deleted in favor of 91917
+study 2125: taxonlabel Dothidotthia CPC12933: 219225 deleted in favor of 91943
+study 2125: taxonlabel Neofusicoccum mangiferum CBS118531: 219286 deleted in favor of 91897
+study 2125: taxonlabel Botryosphaeria corticis CBS119047: 219258 deleted in favor of 28975
+study 2125: taxonlabel Piedraia hortae: 219210 deleted in favor of 49808
+study 2125: taxonlabel Lasiodiplodia theobromae CBS164.96: 219310 deleted in favor of 91920
+study 2125: taxonlabel Diplodia rosulata CBS116472: 219257 deleted in favor of 91902
+study 2125: taxonlabel Dothiorella sarmentorum CBS115038: 219240 deleted in favor of 91925
+study 2125: taxonlabel Dothiorella iberica CBS113188: 219249 deleted in favor of 91936
+study 2125: taxonlabel Spencermartinsia ICMP16819: 219283 deleted in favor of 91896
+study 2125: taxonlabel Diplodia pinea C CBS109725: 219260 deleted in favor of 46069
+study 2125: taxonlabel Lasiodiplodia theobromae CAA006: 219288 deleted in favor of 91894
+study 2125: taxonlabel Diplodia scrobiculata CBS113423: 219266 deleted in favor of 90115
+study 2125: taxonlabel Botryosphaeria dothidea CBS115476: 219233 deleted in favor of 91908
+study 2125: taxonlabel Hysteropatella clavispora: 219318 deleted in favor of 13248
+study 2125: taxonlabel Dothidotthia CPC12928: 219259 deleted in favor of 91950
+study 2125: taxonlabel Dothiorella sarmentorum IMI63581b: 219319 deleted in favor of 91923
+study 2125: taxonlabel Diplodia coryli CBS242.51: 219305 deleted in favor of 91916
+study 2125: taxonlabel Dothidotthia CPC12932: 219217 deleted in favor of 91948
+study 2125: taxonlabel Lasiodiplodia rubropurpurea CBS118740: 219263 deleted in favor of 91900
+study 2125: taxonlabel Lasiodiplodia crassispora CBS118741: 219299 deleted in favor of 91887
+study 2125: taxonlabel Diplodia scrobiculata CBS109944: 219220 deleted in favor of 46056
+study 2125: taxonlabel Didymella cucurbitacearum: 219251 deleted in favor of 49774
+study 2125: taxonlabel Phaeobotryosphaeria visci CBS186.97: 219234 deleted in favor of 91892
+study 2125: taxonlabel Neofusicoccum luteum CBS110299: 219226 deleted in favor of 91927
+study 2125: taxonlabel Diplodia juglandis CBS188.87: 219268 deleted in favor of 91895
+study 2125: taxonlabel Neodeightonia subglobosa CBS448.91: 219272 deleted in favor of 91909
+study 2125: taxonlabel Neofusicoccum mangiferum CBS118532: 219222 deleted in favor of 91904
+study 2125: taxonlabel Phaeobotryon mamane CPC12264: 219280 deleted in favor of 91915
+study 2125: taxonlabel Dothidotthia CPC12930: 219292 deleted in favor of 91947
+study 2125: taxonlabel Spencermartinsia ICMP16828: 219244 deleted in favor of 91901
+study 2125: taxonlabel Neodeightonia phoenicum CBS122528: 219311 deleted in favor of 91937
+study 2125: taxonlabel Phaeobotryosphaeria porosum CBS110496: 219229 deleted in favor of 91910
+study 2125: taxonlabel Diplodia spegazziniana CBS302.75: 219317 deleted in favor of 91921
+study 2125: taxonlabel Phaeobotryosphaeria visci CBS100163: 219293 deleted in favor of 91886
+study 2125: taxonlabel Lasiodiplodia pseudotheobromae CBS116459: 219253 deleted in favor of 91935
+study 2125: taxonlabel Lasiodiplodia gonubiensis CBS115812: 219241 deleted in favor of 91926
+study 2125: taxonlabel Diplodia pinea A CBS109727: 219276 deleted in favor of 46054
+study 2125: taxonlabel Spencermartinsia ICMP16824: 219231 deleted in favor of 91919
+study 2125: taxonlabel Diplodia seriata CBS119049: 219303 deleted in favor of 46062
+study 2125: taxonlabel Lasiodiplodia crassispora CBS110492: 219277 deleted in favor of 91933
+study 2125: taxonlabel Spencermartinsia viticola CBS117006: 219289 deleted in favor of 91929
+study 2125: taxonlabel Massarina arundinacea: 219294 deleted in favor of 91949
+study 2125: taxonlabel Diplodia corticola CBS112546: 219215 deleted in favor of 91930
+study 2125: taxonlabel Phaeobotryon mamane CPC12444: 219264 deleted in favor of 91931
+study 2125: taxonlabel Dothiorella CAP187: 219206 deleted in favor of 91890
+study 2125: taxonlabel Neodeightonia phoenicum JL515: 219297 deleted in favor of 91898
+study 2125: taxonlabel Diplodia pinea A CBS393.84: 219284 deleted in favor of 46078
+study 2125: taxonlabel Diplodia rosulata CBS116470: 219208 deleted in favor of 91891
+study 2125: taxonlabel Phaeobotryon mamane CPC12442: 219271 deleted in favor of 91922
+study 2125: taxonlabel Lewia eureka: 219246 deleted in favor of 91944
+study 2125: taxonlabel Lasiodiplodia gonubiensis CBS116355: 219302 deleted in favor of 91928
+study 2125: taxonlabel Phaeobotryon mamane CPC12440: 219270 deleted in favor of 91912
+study 2125: taxonlabel Lasiodiplodia parva CBS356.59: 219307 deleted in favor of 91899
+study 2125: taxonlabel Diplodia seriata CBS112555: 219267 deleted in favor of 46088
+study 2125: taxonlabel Dothiorella CAA005: 219306 deleted in favor of 91911
+study 1420: taxonlabel Vaccinium uliginosum F WGre V53a: 163142 deleted in favor of 40229
+study 1420: taxonlabel Vaccinium uliginosum C NNor V17a: 163148 deleted in favor of 40234
+study 1420: taxonlabel Vaccinium uliginosum L Cali V47a: 163136 deleted in favor of 40227
+study 1420: taxonlabel Vaccinium uliginosum K Icel V11a: 163143 deleted in favor of 40222
+study 1420: taxonlabel Vaccinium uliginosum P USA V78: 163135 deleted in favor of 40226
+study 1420: taxonlabel Vaccinium uliginosum N Russ V115: 163137 deleted in favor of 40232
+study 1420: taxonlabel Vaccinium uliginosum M Alas V85: 163141 deleted in favor of 40238
+study 1420: taxonlabel Vaccinium uliginosum J Chuk V43a: 163152 deleted in favor of 40220
+study 1420: taxonlabel Vaccinium vitis-idaea: 163150 deleted in favor of 40224
+study 1420: taxonlabel Vaccinium uliginosum I Cana V48a: 163138 deleted in favor of 40223
+study 1420: taxonlabel Vaccinium uliginosum G Cana V52a: 163147 deleted in favor of 40221
+study 1420: taxonlabel Vaccinium uliginosum B Pyre V67a: 163149 deleted in favor of 40231
+study 1420: taxonlabel Vaccinium uliginosum A Alps V30a: 163145 deleted in favor of 40219
+study 1420: taxonlabel Vaccinium uliginosum O Alas V150: 163154 deleted in favor of 40235
+study 1420: taxonlabel Vaccinium uliginosum D Alps V31b: 163151 deleted in favor of 40233
+study 1420: taxonlabel Vaccinium uliginosum E Cana V50a: 163140 deleted in favor of 40230
+study 1420: taxonlabel Vaccinium myrtillus: 163144 deleted in favor of 40237
+study 1420: taxonlabel Vaccinium uliginosum R Alas V84: 163153 deleted in favor of 40228
+study 1420: taxonlabel Vaccinium uliginosum H Russ V39a: 163139 deleted in favor of 40236
+study 1420: taxonlabel Vaccinium uliginosum Q Alas V152c vulc: 163146 deleted in favor of 40225
+study 630: taxonlabel Saranga: 106628 deleted in favor of 64586
+study 1087: taxonlabel Botryosphaeria proteae AF452561: 142029 deleted in favor of 18576
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5032: 141945 deleted in favor of 18607
+study 1087: taxonlabel Botryosphaeria protearum AF452538: 142025 deleted in favor of 18667
+study 1087: taxonlabel Botryosphaeria rhodina AF243401: 142021 deleted in favor of 18562
+study 1087: taxonlabel Diplodia sp. STE-U 5148: 142053 deleted in favor of 18652
+study 1087: taxonlabel Botryosphaeria australis STE-U 5054: 142000 deleted in favor of 18592
+study 1087: taxonlabel Botryosphaeria rhodina STE-U 4422: 141924 deleted in favor of 18618
+study 1087: taxonlabel Botryosphaeria australis STE-U 4430: 142031 deleted in favor of 18615
+study 1087: taxonlabel Cercospora penzigii STE-U 4001: 141974 deleted in favor of 18679
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4436: 142015 deleted in favor of 18581
+study 1087: taxonlabel Botryosphaeria australis AY339260: 142010 deleted in favor of 18646
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4542: 141981 deleted in favor of 18664
+study 1087: taxonlabel Botryosphaeria australis STE-U 4528: 141957 deleted in favor of 18551
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4588: 142059 deleted in favor of 18601
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4527: 141973 deleted in favor of 18627
+study 1087: taxonlabel Botryosphaeria protearum AF452528: 141930 deleted in favor of 18583
+study 1087: taxonlabel Botryosphaeria australis STE-U 4428: 141999 deleted in favor of 18658
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4532: 141949 deleted in favor of 18589
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4441: 141970 deleted in favor of 18653
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4443: 142033 deleted in favor of 18603
+study 1087: taxonlabel Botryosphaeria parva STE-U 4534: 141975 deleted in favor of 18549
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5129: 142055 deleted in favor of 18617
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5163: 141927 deleted in favor of 18677
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4546: 142020 deleted in favor of 18609
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5143: 141987 deleted in favor of 18621
+study 1087: taxonlabel Botryosphaeria australis STE-U 4426: 141986 deleted in favor of 18624
+study 1087: taxonlabel Botryosphaeria australis STE-U 4434: 142067 deleted in favor of 18548
+study 1087: taxonlabel Botryosphaeria australis STE-U 4432: 142004 deleted in favor of 18639
+study 1087: taxonlabel Botryosphaeria parva STE-U 4540: 141979 deleted in favor of 18610
+study 1087: taxonlabel Botryosphaeria parva STE-U 4584: 142022 deleted in favor of 18635
+study 1087: taxonlabel Otthia spiraeae IMI63581: 141936 deleted in favor of 18685
+study 1087: taxonlabel Botryosphaeria lutea AF027745: 142047 deleted in favor of 10271
+study 1087: taxonlabel Botryosphaeria parva STE-U 4438: 142060 deleted in favor of 18554
+study 1087: taxonlabel Botryosphaeria dothidea STE-U 5045: 141998 deleted in favor of 18619
+study 1087: taxonlabel Diplodia porosum STE-U 5132: 142026 deleted in favor of 18591
+study 1087: taxonlabel Diplodia porosum STE-U 5046: 141996 deleted in favor of 18550
+study 1087: taxonlabel Botryosphaeria australis STE-U 5039: 142054 deleted in favor of 18558
+study 1087: taxonlabel Botryosphaeria australis STE-U 4596: 141941 deleted in favor of 18611
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4539: 142002 deleted in favor of 18573
+study 1087: taxonlabel Botryosphaeria australis STE-U 4415: 142052 deleted in favor of 18642
+study 1087: taxonlabel Botryosphaeria rhodina STE-U 4423: 142023 deleted in favor of 18649
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5140: 142001 deleted in favor of 18565
+study 1087: taxonlabel Botryosphaeria ribis CMW7773 AY236936 and AY236877: 141932 deleted in favor of 18680
+study 1087: taxonlabel Botryosphaeria australis AY339261: 141983 deleted in favor of 18638
+study 1087: taxonlabel Botryosphaeria australis STE-U 4427: 142017 deleted in favor of 18632
+study 1087: taxonlabel Botryosphaeria dothidea STE-U 4595: 141935 deleted in favor of 18662
+study 1087: taxonlabel Botryosphaeria parva STE-U 5035: 142065 deleted in favor of 18659
+study 1087: taxonlabel Botryosphaeria rhodina STE-U 4419: 142064 deleted in favor of 18560
+study 1087: taxonlabel Botryosphaeria parva STE-U 4424: 141988 deleted in favor of 18640
+study 1087: taxonlabel Botryosphaeria stevensii AF243407: 141946 deleted in favor of 18612
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5053: 141965 deleted in favor of 18556
+study 1087: taxonlabel Botryosphaeria australis STE-U 4598: 141948 deleted in favor of 18557
+study 1087: taxonlabel Botryosphaeria lutea AF293480: 141954 deleted in favor of 10266
+study 1087: taxonlabel Botryosphaeria ribis CMW7772 AY236935: 141985 deleted in favor of 18574
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5043: 141959 deleted in favor of 18678
+study 1087: taxonlabel Diplodia sp. STE-U 5131: 142009 deleted in favor of 18650
+study 1087: taxonlabel Botryosphaeria lutea STE-U 4592: 141925 deleted in favor of 18569
+study 1087: taxonlabel Botryosphaeria parva CMW9079 AY236941 and AY236888: 141972 deleted in favor of 18681
+study 1087: taxonlabel Botryosphaeria australis STE-U 4435: 142041 deleted in favor of 18570
+study 1087: taxonlabel Botryosphaeria stevensii STE-U 5038: 141934 deleted in favor of 18645
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5161: 141961 deleted in favor of 18608
+study 1087: taxonlabel Botryosphaeria ribis CMW7773 AY236936: 142051 deleted in favor of 18668
+study 1087: taxonlabel Botryosphaeria rhodina STE-U 4583: 142003 deleted in favor of 18580
+study 1087: taxonlabel Diplodia sp. STE-U 5048: 142008 deleted in favor of 18604
+study 1087: taxonlabel Botryosphaeria lutea STE-U 4594: 141991 deleted in favor of 18598
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4541: 141933 deleted in favor of 18666
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4537: 141966 deleted in favor of 18631
+study 1087: taxonlabel Botryosphaeria parva CMW9079 AY236941: 142058 deleted in favor of 18567
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5141: 141955 deleted in favor of 18578
+study 1087: taxonlabel Botryosphaeria parva STE-U 4530: 142040 deleted in favor of 18600
+study 1087: taxonlabel Diplodia sp. STE-U 5146: 141995 deleted in favor of 18571
+study 1087: taxonlabel Botryosphaeria parva STE-U 4437: 141992 deleted in favor of 18553
+study 1087: taxonlabel Botryosphaeria parva STE-U 4431: 141962 deleted in favor of 18593
+study 1087: taxonlabel Botryosphaeria proteae AF452560: 141958 deleted in favor of 18660
+study 1087: taxonlabel Botryosphaeria australis STE-U 4535: 141968 deleted in favor of 18671
+study 1087: taxonlabel Botryosphaeria ribis AF027741: 141940 deleted in favor of 10230
+study 1087: taxonlabel Botryosphaeria rhodina STE-U 4421: 141950 deleted in favor of 18661
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 5162: 141963 deleted in favor of 18655
+study 1087: taxonlabel Botryosphaeria dothidea AF241175: 142043 deleted in favor of 10223
+study 1087: taxonlabel Botryosphaeria australis STE-U 4418: 142005 deleted in favor of 18575
+study 1087: taxonlabel Botryosphaeria obtusa STE-U 4440: 141994 deleted in favor of 18673
+study 1087: taxonlabel Botryosphaeria parva STE-U 4417: 142013 deleted in favor of 18625
+st...
[truncated message content] |
