-- List of 889 taxa

-- REPLACE serves to eliminate new-line characters causing import errors
-- join to catalogue_number serves to eliminate leading unidentified whitespace from the raw data, enforcing use of processed version
-- set explicit ESCAPE for control characters; ENCLOSE fields in "


SET NAMES 'utf8';
SELECT
o.data_provider_id AS 'data_provider_id',
o.data_resource_id AS 'data_resource_id', 
dp.name AS 'Data_provider', 
dr.name AS 'Dataset', 
REPLACE(IFNULL(r.collector_name, ""),  "\n", ", ") AS 'Collector_name', 
 '' as 'Collector_number', 
 '' as 'Field_number', 
 '' as 'GUID', 
o.occurrence_date AS 'Date_collected', 
r.institution_code AS 'Institution_code',
r.collection_code AS 'Collection_code',
cat.code AS 'Catalogue_number', 
lub.br_value AS 'Basis_of_record', 
 ir.url as 'Image_url', 
 o.modified AS 'last_indexed',  
 REPLACE(IFNULL(r.identifier_name, ""),  "\n", " ")  AS 'Identifier',  
 r.identification_date AS 'Identification_date',  
r.scientific_name AS 'Scientific_name_original', 
 r.author AS 'Author',  
nn.canonical AS 'Scientific_name', 
 r.kingdom as 'Kingdom_original', 
 kn.canonical AS 'Kingdom',  
 r.phylum as 'Phylum_original', 
 pn.canonical AS 'Phylum',  
 r.class as 'Class_original', 
 cn.canonical AS 'Class',  
 r.order_rank as 'Order_rank_original',  
 orn.canonical AS 'Order_rank',  
 r.family as 'Family_original', 
 fn.canonical AS 'Family',  
 r.genus as 'Genus_original', 
 gn.canonical AS 'Genus',  
 r.country as 'Country_original',  
o.iso_country_code AS 'Country', 
REPLACE(IFNULL(r.locality, ""),  "\n", " ")  AS 'Locality', 
 REPLACE(IFNULL(r.county, ""),  "\n", " ")  AS 'County',  
 REPLACE(IFNULL(r.continent_ocean, ""),  "\n", " ")  AS 'Continent_or_Ocean',  
 REPLACE(IFNULL(r.state_province, ""),  "\n", " ")  AS 'State_or_Province',  
c.region AS 'Region', 
 dp.iso_country_code AS 'Provider_country',  
 r.latitude AS 'Latitude', 
o.latitude as 'Latitude_interpreted',
 r.longitude AS 'Longitude', 
o.longitude as 'Longitude_interpreted',
r.lat_long_precision AS 'Coordinate_precision', 
o.geospatial_issue AS 'geospatial_issue', 
 o.cell_id AS 'cell_id',  
 o.centi_cell_id AS 'centi_cell_id',  
 r.min_depth AS 'Min_depth',  
 r.max_depth AS 'Max_depth',  
 r.min_altitude AS 'Min_altitude',  
r.max_altitude AS 'Max_altitude',  
 r.altitude_precision AS 'Altitude_precision',  
CONCAT('http://data.gbif.org/occurrences/',o.id) AS 'gbif_portal_url',
 CONCAT('http://data.gbif.org/ws/rest/occurrence/get/',o.id) AS 'gbif_webservice_url',   
 o.id AS 'occurrence_id',
 o.nub_concept_id AS 'nub_concept_id'

INTO OUTFILE '/tmp/Invasives_20121121.txt'
FIELDS TERMINATED BY '\t' ESCAPED BY '\\' ENCLOSED BY '"'
LINES TERMINATED BY '\n'

FROM
occurrence_record o
JOIN data_resource dr ON dr.id = o.data_resource_id 
JOIN data_provider dp ON o.data_provider_id = dp.id 
LEFT JOIN country c ON o.iso_country_code = c.iso_country_code 
LEFT JOIN lookup_basis_of_record lub ON o.basis_of_record=lub.br_key
LEFT JOIN catalogue_number cat ON o.catalogue_number_id=cat.id
 left join image_record ir ON o.id = ir.occurrence_id  
INNER JOIN raw_occurrence_record r ON o.id=r.id 
INNER JOIN taxon_concept nc ON o.nub_concept_id=nc.id 
INNER JOIN taxon_name nn ON nc.taxon_name_id=nn.id 
LEFT JOIN taxon_concept kc ON nc.kingdom_concept_id=kc.id 
LEFT JOIN taxon_name kn ON kc.taxon_name_id=kn.id 
LEFT JOIN taxon_concept pc ON nc.phylum_concept_id=pc.id 
LEFT JOIN taxon_name pn ON pc.taxon_name_id=pn.id 
LEFT JOIN taxon_concept cc ON nc.class_concept_id=cc.id 
LEFT JOIN taxon_name cn ON cc.taxon_name_id=cn.id 
LEFT JOIN taxon_concept oc ON nc.order_concept_id=oc.id 
LEFT JOIN taxon_name orn ON oc.taxon_name_id=orn.id 
LEFT JOIN taxon_concept fc ON nc.family_concept_id=fc.id 
LEFT JOIN taxon_name fn ON fc.taxon_name_id=fn.id 
LEFT JOIN taxon_concept gc ON nc.genus_concept_id=gc.id 
LEFT JOIN taxon_name gn ON gc.taxon_name_id=gn.id  
WHERE

nn.canonical like 'Abelmoschus moschatus%'
or nn.canonical like 'Abrus precatorius%'
or nn.canonical like 'Acacia concinna%'
or nn.canonical like 'Acacia confusa%'
or nn.canonical like 'Acacia farnesiana%'
or nn.canonical like 'Acacia longifolia%'
or nn.canonical like 'Acacia mangium%'
or nn.canonical like 'Acacia mearnsii%'
or nn.canonical like 'Acacia melanoxylon%'
or nn.canonical like 'Acacia nilotica%'
or nn.canonical like 'Acacia retinodes%'
or nn.canonical like 'Acacia saligna%'
or nn.canonical like 'Acanthaster planci%'
or nn.canonical like 'Acanthocereus tetragonus%'
or nn.canonical like 'Acanthogobius flavimanus%'
or nn.canonical like 'Acanthophora spicifera%'
or nn.canonical like 'Acanthus mollis%'
or nn.canonical like 'Acer ginnala%'
or nn.canonical like 'Acer platanoides%'
or nn.canonical like 'Achatina fulica%'
or nn.canonical like 'Acnemia bifida%'
or nn.canonical like 'Acridotheres fuscus%'
or nn.canonical like 'Acridotheres tristis%'
or nn.canonical like 'Acromyrmex octospinosus%'
or nn.canonical like 'Acroptilon repens%'
or nn.canonical like 'Adelges piceae%'
or nn.canonical like 'Adelges tsugae%'
or nn.canonical like 'Adenanthera pavonina%'
or nn.canonical like 'Aedes aegypti%'
or nn.canonical like 'Aedes albopictus%'
or nn.canonical like 'Aegilops triuncialis%'
or nn.canonical like 'Agapanthus praecox%'
or nn.canonical like 'Agave americana%'
or nn.canonical like 'Agave sisalana%'
or nn.canonical like 'Ageratina adenophora%'
or nn.canonical like 'Ageratina riparia%'
or nn.canonical like 'Ageratum conyzoides%'
or nn.canonical like 'Agrilus planipennis%'
or nn.canonical like 'Agrostis capillaris%'
or nn.canonical like 'Agrostis gigantea%'
or nn.canonical like 'Ailanthus altissima%'
or nn.canonical like 'Akebia quinata%'
or nn.canonical like 'Albizia julibrissin%'
or nn.canonical like 'Albizia lebbeck%'
or nn.canonical like 'Alectoris chukar%'
or nn.canonical like 'Aleurites moluccana%'
or nn.canonical like 'Alexandrium minutum%'
or nn.canonical like 'Alitta succinea%'
or nn.canonical like 'Alliaria petiolata%'
or nn.canonical like 'Alnus glutinosa%'
or nn.canonical like 'Alosa pseudoharengus%'
or nn.canonical like 'Alpinia zerumbet%'
or nn.canonical like 'Alternanthera philoxeroides%'
or nn.canonical like 'Alternanthera sessilis%'
or nn.canonical like 'Ambrosia artemisiifolia%'
or nn.canonical like 'Ameiurus nebulosus%'
or nn.canonical like 'Ammophila arenaria%'
or nn.canonical like 'Ammotragus lervia%'
or nn.canonical like 'Ampelopsis brevipedunculata%'
or nn.canonical like 'Amynthas agrestis%'
or nn.canonical like 'Anas platyrhynchos%'
or nn.canonical like 'Andropogon gayanus%'
or nn.canonical like 'Andropogon virginicus%'
or nn.canonical like 'Angiopteris evecta%'
or nn.canonical like 'Annona glabra%'
or nn.canonical like 'Annona squamosa%'
or nn.canonical like 'Anolis aeneus%'
or nn.canonical like 'Anolis carolinensis%'
or nn.canonical like 'Anolis cristatellus%'
or nn.canonical like 'Anolis distichus%'
or nn.canonical like 'Anolis equestris%'
or nn.canonical like 'Anolis extremus%'
or nn.canonical like 'Anolis garmani%'
or nn.canonical like 'Anolis leachii%'
or nn.canonical like 'Anolis lineatus%'
or nn.canonical like 'Anolis maynardi%'
or nn.canonical like 'Anolis porcatus%'
or nn.canonical like 'Anolis richardii%'
or nn.canonical like 'Anolis trinitatis%'
or nn.canonical like 'Anolis wattsi%'
or nn.canonical like 'Anopheles quadrimaculatus%'
or nn.canonical like 'Anoplolepis gracilipes%'
or nn.canonical like 'Anoplophora chinensis%'
or nn.canonical like 'Anoplophora glabripennis%'
or nn.canonical like 'Anredera cordifolia%'
or nn.canonical like 'Anser anser%'
or nn.canonical like 'Anthonomus grandis%'
or nn.canonical like 'Antidesma bunias%'
or nn.canonical like 'Antigonon leptopus%'
or nn.canonical like 'Aphanomyces astaci%'
or nn.canonical like 'Apis mellifera%'
or nn.canonical like 'Archontophoenix cunninghamiana%'
or nn.canonical like 'Ardisia acuminata%'
or nn.canonical like 'Ardisia crenata%'
or nn.canonical like 'Ardisia elliptica%'
or nn.canonical like 'Arenga obtusifolia%'
or nn.canonical like 'Artemia franciscana%'
or nn.canonical like 'Arundo donax%'
or nn.canonical like 'Ascidiella aspersa%'
or nn.canonical like 'Asparagus densiflorus%'
or nn.canonical like 'Asparagus officinalis%'
or nn.canonical like 'Asterias amurensis%'
or nn.canonical like 'Asystasia gangetica%'
or nn.canonical like 'Aulacaspis yasumatsui%'
or nn.canonical like 'Austroeupatorium inulifolium%'
or nn.canonical like 'Avian Influenza Virus%'
or nn.canonical like 'Avipoxvirus %'
or nn.canonical like 'Axis axis%'
or nn.canonical like 'Azolla pinnata%'
or nn.canonical like 'Bacopa monnieri%'
or nn.canonical like 'Bactrocera tryoni%'
or nn.canonical like 'Bagaza Virus%'
or nn.canonical like 'BAGV%'
or nn.canonical like 'Bambusa vulgaris%'
or nn.canonical like 'Banana bunchy top virus%'
or nn.canonical like 'Batillaria attramentaria%'
or nn.canonical like 'Batrachochytrium dendrobatidis%'
or nn.canonical like 'BBTV%'
or nn.canonical like 'Beak and feather disease virus%'
or nn.canonical like 'Begonia cucullata%'
or nn.canonical like 'Bellamya chinensis%'
or nn.canonical like 'Bellis perennis%'
or nn.canonical like 'Bemisia tabaci%'
or nn.canonical like 'Berberis buxifolia%'
or nn.canonical like 'Berberis darwinii%'
or nn.canonical like 'Berberis thunbergii%'
or nn.canonical like 'BFDV%'
or nn.canonical like 'Bidens pilosa%'
or nn.canonical like 'Boa constrictor%'
or nn.canonical like 'Boehmeria penduliflora%'
or nn.canonical like 'Boiga irregularis%'
or nn.canonical like 'Boonea bisuturalis%'
or nn.canonical like 'Bos taurus%'
or nn.canonical like 'Bothriochloa pertusa%'
or nn.canonical like 'Branta canadensis%'
or nn.canonical like 'Brassica elongata%'
or nn.canonical like 'Brassica tournefortii%'
or nn.canonical like 'Bromus inermis%'
or nn.canonical like 'Bromus rubens%'
or nn.canonical like 'Bromus tectorum%'
or nn.canonical like 'Brontispa longissima%'
or nn.canonical like 'Bubalus bubalis%'
or nn.canonical like 'Bubo virginianus%'
or nn.canonical like 'Bubulcus ibis%'
or nn.canonical like 'Buddleja davidii%'
or nn.canonical like 'Buddleja madagascariensis%'
or nn.canonical like 'Bufo marinus%'
or nn.canonical like 'Bugula neritina%'
or nn.canonical like 'Bursaphelenchus xylophilus%'
or nn.canonical like 'Butomus umbellatus%'
or nn.canonical like 'Bythotrephes longimanus%'
or nn.canonical like 'Cabomba caroliniana%'
or nn.canonical like 'Cactoblastis cactorum%'
or nn.canonical like 'Caesalpinia decapetala%'
or nn.canonical like 'Caiman crocodilus%'
or nn.canonical like 'Calliphora vicina%'
or nn.canonical like 'Callithrix geoffroyi%'
or nn.canonical like 'Callithrix jacchus%'
or nn.canonical like 'Callithrix penicillata%'
or nn.canonical like 'Calluna vulgaris%'
or nn.canonical like 'Camelina sativa%'
or nn.canonical like 'Camelus dromedarius%'
or nn.canonical like 'Campuloclinium macrocephalum%'
or nn.canonical like 'Candidatus Liberibacter africanus%'
or nn.canonical like 'Candidatus Liberibacter americanus%'
or nn.canonical like 'Candidatus Liberibacter asiaticus%'
or nn.canonical like 'Canis latrans%'
or nn.canonical like 'Canis lupus%'
or nn.canonical like 'Canna indica%'
or nn.canonical like 'Capra hircus%'
or nn.canonical like 'Carassius auratus%'
or nn.canonical like 'Carcinus maenas%'
or nn.canonical like 'Cardamine flexuosa%'
or nn.canonical like 'Cardamine glacialis%'
or nn.canonical like 'Cardiospermum grandiflorum%'
or nn.canonical like 'Carduus nutans%'
or nn.canonical like 'Carijoa riisei%'
or nn.canonical like 'Carpobrotus edulis%'
or nn.canonical like 'Carpodacus mexicanus%'
or nn.canonical like 'Castilla elastica%'
or nn.canonical like 'Castor canadensis%'
or nn.canonical like 'Casuarina equisetifolia%'
or nn.canonical like 'Caulerpa taxifolia%'
or nn.canonical like 'Caulerpa webbiana%'
or nn.canonical like 'Cavia porcellus%'
or nn.canonical like 'Cecropia peltata%'
or nn.canonical like 'Cecropia schreberiana%'
or nn.canonical like 'Cedrela odorata%'
or nn.canonical like 'Celastrus orbiculatus%'
or nn.canonical like 'Celtodoryx ciocalyptoides%'
or nn.canonical like 'Cenchrus ciliaris%'
or nn.canonical like 'Cenchrus clandestinus%'
or nn.canonical like 'Cenchrus echinatus%'
or nn.canonical like 'Cenchrus macrourus%'
or nn.canonical like 'Cenchrus polystachios%'
or nn.canonical like 'Cenchrus setaceus%'
or nn.canonical like 'Centaurea biebersteinii%'
or nn.canonical like 'Centaurea diffusa%'
or nn.canonical like 'Centaurea melitensis%'
or nn.canonical like 'Centaurea solstitialis%'
or nn.canonical like 'Cerastium fontanum%'
or nn.canonical like 'Ceratitis capitata%'
or nn.canonical like 'Ceratocystis platani%'
or nn.canonical like 'Ceratophyllum demersum%'
or nn.canonical like 'Ceratostoma inornatum%'
or nn.canonical like 'Cercopagis pengoi%'
or nn.canonical like 'Cercopithecus mona%'
or nn.canonical like 'Cervus elaphus%'
or nn.canonical like 'Cervus nippon%'
or nn.canonical like 'Cervus timorensis%'
or nn.canonical like 'Cestrum nocturnum%'
or nn.canonical like 'Cestrum parqui%'
or nn.canonical like 'Chamaeleo jacksonii%'
or nn.canonical like 'Channa argus%'
or nn.canonical like 'Channa marulius%'
or nn.canonical like 'Charybdis hellerii%'
or nn.canonical like 'Charybdis japonica%'
or nn.canonical like 'Chromolaena odorata%'
or nn.canonical like 'Chronic Wasting Disease%'
or nn.canonical like 'Chrysanthemoides monilifera%'
or nn.canonical like 'Chrysobalanus icaco%'
or nn.canonical like 'Chthamalus proteus%'
or nn.canonical like 'Cichla ocellaris%'
or nn.canonical like 'Cichlasoma urophthalmus%'
or nn.canonical like 'Cinara cupressi%'
or nn.canonical like 'Cinchona pubescens%'
or nn.canonical like 'Cinnamomum camphora%'
or nn.canonical like 'Cinnamomum verum%'
or nn.canonical like 'Ciona intestinalis%'
or nn.canonical like 'Circus approximans%'
or nn.canonical like 'Cirsium arvense%'
or nn.canonical like 'Cirsium vulgare%'
or nn.canonical like 'Citharexylum spinosum%'
or nn.canonical like 'Civettictis civetta%'
or nn.canonical like 'Clarias batrachus%'
or nn.canonical like 'Clematis terniflora%'
or nn.canonical like 'Clematis vitalba%'
or nn.canonical like 'Clidemia hirta%'
or nn.canonical like 'Coccinia grandis%'
or nn.canonical like 'Codium fragile%'
or nn.canonical like 'Colubrina asiatica%'
or nn.canonical like 'Columba livia%'
or nn.canonical like 'Commelina benghalensis%'
or nn.canonical like 'Compsilura concinnata%'
or nn.canonical like 'Conyza floribunda%'
or nn.canonical like 'Coptotermes formosanus%'
or nn.canonical like 'Corbicula fluminea%'
or nn.canonical like 'Coronilla varia%'
or nn.canonical like 'Cortaderia jubata%'
or nn.canonical like 'Cortaderia selloana%'
or nn.canonical like 'Corvus splendens%'
or nn.canonical like 'Cotinus coggygria%'
or nn.canonical like 'Crassostrea gigas%'
or nn.canonical like 'Crassula helmsii%'
or nn.canonical like 'Crepidula fornicata%'
or nn.canonical like 'Cricetomys gambianus%'
or nn.canonical like 'Crocidura suaveolens%'
or nn.canonical like 'Cronartium ribicola%'
or nn.canonical like 'Cryphonectria parasitica%'
or nn.canonical like 'Cryptococcus fagisuga%'
or nn.canonical like 'Cryptostegia grandiflora%'
or nn.canonical like 'Cryptostegia madagascariensis%'
or nn.canonical like 'Ctenopharyngodon idella%'
or nn.canonical like 'Ctenosaura similis%'
or nn.canonical like 'Culex quinquefasciatus%'
or nn.canonical like 'Cupaniopsis anacardioides%'
or nn.canonical like 'Cuphea ignea%'
or nn.canonical like 'CWD%'
or nn.canonical like 'Cyathea cooperi%'
or nn.canonical like 'Cygnus olor%'
or nn.canonical like 'Cylindroiulus latestriatus%'
or nn.canonical like 'Cynanchum rossicum%'
or nn.canonical like 'Cynara cardunculus%'
or nn.canonical like 'Cynictis penicillata%'
or nn.canonical like 'Cynodon dactylon%'
or nn.canonical like 'Cynoglossum officinale%'
or nn.canonical like 'Cyperus rotundus%'
or nn.canonical like 'Cyprinella lutrensis%'
or nn.canonical like 'Cyprinus carpio%'
or nn.canonical like 'Cytisus scoparius%'
or nn.canonical like 'Cytisus striatus%'
or nn.canonical like 'Dalbergia sissoo%'
or nn.canonical like 'Daphnia lumholtzi%'
or nn.canonical like 'Delairea odorata%'
or nn.canonical like 'Dendrobaena octaedra%'
or nn.canonical like 'Dendroctonus valens%'
or nn.canonical like 'Dendrodrilus rubidus%'
or nn.canonical like 'Dendrolimus sibiricus%'
or nn.canonical like 'Diaphorina citri%'
or nn.canonical like 'Dichrostachys cinerea%'
or nn.canonical like 'Didymosphenia geminata%'
or nn.canonical like 'Dioscorea bulbifera%'
or nn.canonical like 'Dioscorea oppositifolia%'
or nn.canonical like 'Dipogon lignosus%'
or nn.canonical like 'Discula destructiva%'
or nn.canonical like 'Dreissena bugensis%'
or nn.canonical like 'Dreissena polymorpha%'
or nn.canonical like 'Duchesnea indica%'
or nn.canonical like 'Dysdera crocata%'
or nn.canonical like 'Egeria densa%'
or nn.canonical like 'Eichhornia crassipes%'
or nn.canonical like 'Elaeagnus angustifolia%'
or nn.canonical like 'Elaeagnus pungens%'
or nn.canonical like 'Elaeagnus umbellata%'
or nn.canonical like 'Elaeis guineensis%'
or nn.canonical like 'Elaphe guttata%'
or nn.canonical like 'Elephantopus mollis%'
or nn.canonical like 'Elettaria cardamomum%'
or nn.canonical like 'Eleutherodactylus coqui%'
or nn.canonical like 'Eleutherodactylus johnstonei%'
or nn.canonical like 'Eleutherodactylus planirostris%'
or nn.canonical like 'Elminius modestus%'
or nn.canonical like 'Elodea canadensis%'
or nn.canonical like 'Epipremnum pinnatum%'
or nn.canonical like 'Equus asinus%'
or nn.canonical like 'Equus caballus%'
or nn.canonical like 'Erigeron karvinskianus%'
or nn.canonical like 'Erinaceus europaeus%'
or nn.canonical like 'Eriobotrya japonica%'
or nn.canonical like 'Eriocheir sinensis%'
or nn.canonical like 'Erodium cicutarium%'
or nn.canonical like 'Erythrocebus patas%'
or nn.canonical like 'Esox lucius%'
or nn.canonical like 'Estrilda astrild%'
or nn.canonical like 'Eugenia uniflora%'
or nn.canonical like 'Euglandina rosea%'
or nn.canonical like 'Euonymus alata%'
or nn.canonical like 'Euonymus fortunei%'
or nn.canonical like 'Eupatorium cannabinum%'
or nn.canonical like 'Euphorbia esula%'
or nn.canonical like 'Euryops multifidus%'
or nn.canonical like 'Falcataria moluccana%'
or nn.canonical like 'Fallopia japonica%'
or nn.canonical like 'Felis catus%'
or nn.canonical like 'Ficopomatus enigmaticus%'
or nn.canonical like 'Ficus microcarpus%'
or nn.canonical like 'Ficus rubiginosa%'
or nn.canonical like 'Flacourtia indica%'
or nn.canonical like 'Flemingia strobilifera%'
or nn.canonical like 'FMDV%'
or nn.canonical like 'Foot-and-mouth disease virus%'
or nn.canonical like 'Fragaria vesca%'
or nn.canonical like 'Frangula alnus%'
or nn.canonical like 'Fraxinus floribunda%'
or nn.canonical like 'Fuchsia boliviana%'
or nn.canonical like 'Fuchsia magellanica%'
or nn.canonical like 'Funtumia elastica%'
or nn.canonical like 'Furcraea foetida%'
or nn.canonical like 'Gallus gallus%'
or nn.canonical like 'Gallus varius%'
or nn.canonical like 'Gambusia affinis%'
or nn.canonical like 'Gambusia holbrooki%'
or nn.canonical like 'Gastrophryne carolinensis%'
or nn.canonical like 'Gemma gemma%'
or nn.canonical like 'Genetta genetta%'
or nn.canonical like 'Genista monspessulana%'
or nn.canonical like 'Geomyces destructans%'
or nn.canonical like 'Geukensia demissa%'
or nn.canonical like 'Glyceria maxima%'
or nn.canonical like 'Glyptoperichthys gibbiceps%'
or nn.canonical like 'Gonipterus scutellatus%'
or nn.canonical like 'Gracilaria salicornia%'
or nn.canonical like 'Gracilaria vermiculophylla%'
or nn.canonical like 'Grevillea robusta%'
or nn.canonical like 'Gunnera manicata%'
or nn.canonical like 'Gunnera tinctoria%'
or nn.canonical like 'Gymnocephalus cernuus%'
or nn.canonical like 'Gymnocoronis spilanthoides%'
or nn.canonical like 'Gymnodinium catenatum%'
or nn.canonical like 'Gymnophthalmus underwoodi%'
or nn.canonical like 'Gymnorhina tibicen%'
or nn.canonical like 'Haematoxylum campechianum%'
or nn.canonical like 'Halophila stipulacea%'
or nn.canonical like 'Harmonia axyridis%'
or nn.canonical like 'Hedera helix%'
or nn.canonical like 'Hedychium coccineum%'
or nn.canonical like 'Hedychium coronarium%'
or nn.canonical like 'Hedychium flavescens%'
or nn.canonical like 'Hedychium gardnerianum%'
or nn.canonical like 'Heliotropium angiospermum%'
or nn.canonical like 'Heliotropium curassavicum%'
or nn.canonical like 'Helix aspersa%'
or nn.canonical like 'Hemiberlesia pitysophila%'
or nn.canonical like 'Hemidactylus frenatus%'
or nn.canonical like 'Hemidactylus mabouia%'
or nn.canonical like 'Hemigrapsus sanguineus%'
or nn.canonical like 'Hemitragus jemlahicus%'
or nn.canonical like 'Heracleum mantegazzianum%'
or nn.canonical like 'Herpestes auropunctatus%'
or nn.canonical like 'Herpestes pulverulentus%'
or nn.canonical like 'Heteropogon contortus%'
or nn.canonical like 'Hieracium aurantiacum%'
or nn.canonical like 'Hieracium floribundum%'
or nn.canonical like 'Hieracium pilosella%'
or nn.canonical like 'Hiptage benghalensis%'
or nn.canonical like 'Holcus lanatus%'
or nn.canonical like 'Homalodisca vitripennis%'
or nn.canonical like 'Hoplochelus marginalis%'
or nn.canonical like 'Houttuynia cordata%'
or nn.canonical like 'Hydrilla verticillata%'
or nn.canonical like 'Hydrocharis morsus-ranae%'
or nn.canonical like 'Hygrophila polysperma%'
or nn.canonical like 'Hylastes ater%'
or nn.canonical like 'Hypericum perforatum%'
or nn.canonical like 'Hyphantria cunea%'
or nn.canonical like 'Hypnea musciformis%'
or nn.canonical like 'Hypochaeris radicata%'
or nn.canonical like 'Hypogastura purpurescens%'
or nn.canonical like 'Hypogastura viatica%'
or nn.canonical like 'Hypophthalmichthys molitrix%'
or nn.canonical like 'Hypophthalmichthys nobilis%'
or nn.canonical like 'Icerya purchasi%'
or nn.canonical like 'Iguana iguana%'
or nn.canonical like 'Ilyanassa obsoleta%'
or nn.canonical like 'Impatiens glandulifera%'
or nn.canonical like 'Impatiens walleriana%'
or nn.canonical like 'Imperata cylindrica%'
or nn.canonical like 'Ipomoea aquatica%'
or nn.canonical like 'Ipomoea cairica%'
or nn.canonical like 'Ips typographus%'
or nn.canonical like 'Iris pseudacorus%'
or nn.canonical like 'Ischaemum polystachyum%'
or nn.canonical like 'Jatropha gossypiifolia%'
or nn.canonical like 'Juncus tenuis%'
or nn.canonical like 'Juniperus bermudiana%'
or nn.canonical like 'Kalanchoe pinnata%'
or nn.canonical like 'Kappaphycus %'
or nn.canonical like 'Lachnellula willkommii%'
or nn.canonical like 'Lagarosiphon major%'
or nn.canonical like 'Lama guanicoe%'
or nn.canonical like 'Landoltia punctata%'
or nn.canonical like 'Lantana camara%'
or nn.canonical like 'Lasius neglectus%'
or nn.canonical like 'Lates niloticus%'
or nn.canonical like 'Launaea intybacea%'
or nn.canonical like 'Leiothrix lutea%'
or nn.canonical like 'Lepidium latifolium%'
or nn.canonical like 'Lepidium virginicum%'
or nn.canonical like 'Lepus americanus%'
or nn.canonical like 'Lepus europaeus%'
or nn.canonical like 'Lespedeza cuneata%'
or nn.canonical like 'Leucaena leucocephala%'
or nn.canonical like 'Leuciscus idus%'
or nn.canonical like 'Ligustrum lucidum%'
or nn.canonical like 'Ligustrum robustum%'
or nn.canonical like 'Ligustrum sinense%'
or nn.canonical like 'Ligustrum vulgare%'
or nn.canonical like 'Limnocharis flava%'
or nn.canonical like 'Limnoperna fortunei%'
or nn.canonical like 'Limnophila sessiliflora%'
or nn.canonical like 'Linaria vulgaris%'
or nn.canonical like 'Linepithema humile%'
or nn.canonical like 'Linyphia triangularis%'
or nn.canonical like 'Lithobates catesbeianus%'
or nn.canonical like 'Litoria aurea%'
or nn.canonical like 'Litsea glutinosa%'
or nn.canonical like 'Littorina littorea%'
or nn.canonical like 'Livistona chinensis%'
or nn.canonical like 'Lonicera japonica%'
or nn.canonical like 'Lonicera maackii%'
or nn.canonical like 'Lotus corniculatus%'
or nn.canonical like 'Ludwigia peruviana%'
or nn.canonical like 'Lumbricus rubellus%'
or nn.canonical like 'Lumbricus terrestris%'
or nn.canonical like 'Lupinus polyphyllus%'
or nn.canonical like 'Lutjanus kasmira%'
or nn.canonical like 'Luzula campestris%'
or nn.canonical like 'Lycalopex griseus%'
or nn.canonical like 'Lygodium japonicum%'
or nn.canonical like 'Lygodium microphyllum%'
or nn.canonical like 'Lymantria dispar%'
or nn.canonical like 'Lymantria mathura%'
or nn.canonical like 'Lymantria monacha%'
or nn.canonical like 'Lythrum salicaria%'
or nn.canonical like 'Macaca fascicularis%'
or nn.canonical like 'Macaca mulatta%'
or nn.canonical like 'Macfadyena unguis-cati%'
or nn.canonical like 'Maconellicoccus hirsutus%'
or nn.canonical like 'Martes melampus%'
or nn.canonical like 'Melaleuca quinquenervia%'
or nn.canonical like 'Melastoma candidum%'
or nn.canonical like 'Melia azedarach%'
or nn.canonical like 'Melilotus alba%'
or nn.canonical like 'Melinis minutiflora%'
or nn.canonical like 'Merremia peltata%'
or nn.canonical like 'Merremia tuberosa%'
or nn.canonical like 'Miconia calvescens%'
or nn.canonical like 'Micropterus salmoides%'
or nn.canonical like 'Microstegium vimineum%'
or nn.canonical like 'Mikania micrantha%'
or nn.canonical like 'Mimosa diplotricha%'
or nn.canonical like 'Mimosa pigra%'
or nn.canonical like 'Mimosa pudica%'
or nn.canonical like 'Miscanthus sinensis%'
or nn.canonical like 'Misgurnus anguillicaudatus%'
or nn.canonical like 'Mnemiopsis leidyi%'
or nn.canonical like 'Molothrus ater%'
or nn.canonical like 'Molothrus bonariensis%'
or nn.canonical like 'Monomorium destructor%'
or nn.canonical like 'Monomorium floricola%'
or nn.canonical like 'Monomorium pharaonis%'
or nn.canonical like 'Monopterus albus%'
or nn.canonical like 'Montia fontana%'
or nn.canonical like 'Morella faya%'
or nn.canonical like 'Morone americana%'
or nn.canonical like 'Morus alba%'
or nn.canonical like 'Mus musculus%'
or nn.canonical like 'Musculista senhousia%'
or nn.canonical like 'Mustela erminea%'
or nn.canonical like 'Mustela furo%'
or nn.canonical like 'Mustela nivalis%'
or nn.canonical like 'Mustela vison%'
or nn.canonical like 'Mya arenaria%'
or nn.canonical like 'Mycale grandis%'
or nn.canonical like 'Myiopsitta monachus%'
or nn.canonical like 'Myocastor coypus%'
or nn.canonical like 'Myriophyllum aquaticum%'
or nn.canonical like 'Myriophyllum heterophyllum%'
or nn.canonical like 'Myriophyllum spicatum%'
or nn.canonical like 'Myrmica rubra%'
or nn.canonical like 'Mytilopsis leucophaeata%'
or nn.canonical like 'Mytilopsis sallei%'
or nn.canonical like 'Mytilus galloprovincialis%'
or nn.canonical like 'Myxobolus cerebralis%'
or nn.canonical like 'Najas minor%'
or nn.canonical like 'Nassella neesiana%'
or nn.canonical like 'Nassella tenuissima%'
or nn.canonical like 'Nasua nasua%'
or nn.canonical like 'Natrix maura%'
or nn.canonical like 'NDV%'
or nn.canonical like 'Neogobius melanostomus%'
or nn.canonical like 'Neonectria faginata%'
or nn.canonical like 'Neovison vison%'
or nn.canonical like 'Nephrolepis cordifolia%'
or nn.canonical like 'Newcastle disease virus%'
or nn.canonical like 'Neyraudia reynaudiana%'
or nn.canonical like 'Nicotiana glauca%'
or nn.canonical like 'Norops grahami%'
or nn.canonical like 'Norops sagrei%'
or nn.canonical like 'Nylanderia pubens%'
or nn.canonical like 'Nymphaea odorata%'
or nn.canonical like 'Nymphoides peltata%'
or nn.canonical like 'Nypa fruticans%'
or nn.canonical like 'Ochlerotatus japonicus%'
or nn.canonical like 'Ocimum gratissimum%'
or nn.canonical like 'Octolasion tyrtaeum%'
or nn.canonical like 'Odocoileus virginianus%'
or nn.canonical like 'Oeceoclades maculata%'
or nn.canonical like 'Olea europaea%'
or nn.canonical like 'Oncorhynchus mykiss%'
or nn.canonical like 'Onopordum acanthium%'
or nn.canonical like 'Oopterus soledadinus%'
or nn.canonical like 'Ophiostoma ulmi%'
or nn.canonical like 'Oplismenus hirtellus%'
or nn.canonical like 'Opuntia cochenillifera%'
or nn.canonical like 'Opuntia ficus-indica%'
or nn.canonical like 'Opuntia monacantha%'
or nn.canonical like 'Opuntia stricta%'
or nn.canonical like 'Oracella acuta%'
or nn.canonical like 'Orconectes rusticus%'
or nn.canonical like 'Orconectes virilis%'
or nn.canonical like 'Oreochromis %'
or nn.canonical like 'Oreochromis aureus%'
or nn.canonical like 'Oreochromis mossambicus%'
or nn.canonical like 'Oreochromis niloticus%'
or nn.canonical like 'Orthezia insignis%'
or nn.canonical like 'Orthotomicus erosus%'
or nn.canonical like 'Oryctes rhinoceros%'
or nn.canonical like 'Oryctolagus cuniculus%'
or nn.canonical like 'Osteopilus septentrionalis%'
or nn.canonical like 'Ostrea edulis%'
or nn.canonical like 'Ovis ammon%'
or nn.canonical like 'Ovis aries%'
or nn.canonical like 'Oxalis corniculata%'
or nn.canonical like 'Oxalis latifolia%'
or nn.canonical like 'Oxalis pes-caprae%'
or nn.canonical like 'Oxycaryum cubense%'
or nn.canonical like 'Oxyura jamaicensis%'
or nn.canonical like 'Pachycondyla chinensis%'
or nn.canonical like 'Pacifastacus leniusculus%'
or nn.canonical like 'Paederia foetida%'
or nn.canonical like 'Panicum repens%'
or nn.canonical like 'Paratachardina pseudolobata%'
or nn.canonical like 'Paratrechina longicornis%'
or nn.canonical like 'Paratrechina pubens%'
or nn.canonical like 'Parthenium hysterophorus%'
or nn.canonical like 'Paspalum scrobiculatum%'
or nn.canonical like 'Paspalum urvillei%'
or nn.canonical like 'Paspalum vaginatum%'
or nn.canonical like 'Passer domesticus%'
or nn.canonical like 'Passiflora edulis%'
or nn.canonical like 'Passiflora foetida%'
or nn.canonical like 'Passiflora maliformis%'
or nn.canonical like 'Passiflora suberosa%'
or nn.canonical like 'Passiflora tarminiana%'
or nn.canonical like 'Pasteurella multocida%'
or nn.canonical like 'Paulownia tomentosa%'
or nn.canonical like 'Perca fluviatilis%'
or nn.canonical like 'Perna perna%'
or nn.canonical like 'Perna viridis%'
or nn.canonical like 'Peromyscus fraterculus%'
or nn.canonical like 'Peromyscus maniculatus%'
or nn.canonical like 'Persicaria perfoliata%'
or nn.canonical like 'Petrogale inornata%'
or nn.canonical like 'Petromyzon marinus%'
or nn.canonical like 'Phalanger orientalis%'
or nn.canonical like 'Phalaris arundinacea%'
or nn.canonical like 'Phalloceros caudimaculatus%'
or nn.canonical like 'Pheidole megacephala%'
or nn.canonical like 'Phellinus noxius%'
or nn.canonical like 'Philornis downsi%'
or nn.canonical like 'Phoenix canariensis%'
or nn.canonical like 'Phormium tenax%'
or nn.canonical like 'Phoxinus phoxinus%'
or nn.canonical like 'Phragmites australis%'
or nn.canonical like 'Phyllorhiza punctata%'
or nn.canonical like 'Phyllostachys flexuosa%'
or nn.canonical like 'Phymatosorus scolopendria%'
or nn.canonical like 'Physalis peruviana%'
or nn.canonical like 'Phytophthora cinnamomi%'
or nn.canonical like 'Phytophthora lateralis%'
or nn.canonical like 'Phytophthora pinifolia%'
or nn.canonical like 'Phytophthora ramorum%'
or nn.canonical like 'Phytophthora taxon Agathis%'
or nn.canonical like 'Pimenta dioica%'
or nn.canonical like 'Pinus %'
or nn.canonical like 'Pinus caribaea%'
or nn.canonical like 'Pinus nigra%'
or nn.canonical like 'Pinus pinaster%'
or nn.canonical like 'Piper aduncum%'
or nn.canonical like 'Pistia stratiotes%'
or nn.canonical like 'Pitangus sulphuratus%'
or nn.canonical like 'Pittosporum tenuifolium%'
or nn.canonical like 'Pittosporum undulatum%'
or nn.canonical like 'Pittosporum viridiflorum%'
or nn.canonical like 'Plasmodium relictum%'
or nn.canonical like 'Platydemus manokwari%'
or nn.canonical like 'Pluchea carolinensis%'
or nn.canonical like 'Pluchea indica%'
or nn.canonical like 'Poa annua%'
or nn.canonical like 'Poa pratensis%'
or nn.canonical like 'Podarcis sicula%'
or nn.canonical like 'Poecilia reticulata%'
or nn.canonical like 'Polistes chinensis%'
or nn.canonical like 'Polygala paniculata%'
or nn.canonical like 'Polygonum cuspidatum%'
or nn.canonical like 'Polygonum perfoliatum L.%'
or nn.canonical like 'Polysiphonia brodiei%'
or nn.canonical like 'Pomacea canaliculata%'
or nn.canonical like 'Pomacea insularum%'
or nn.canonical like 'Populus alba%'
or nn.canonical like 'Porcellio scaber%'
or nn.canonical like 'Porphyrio porphyrio%'
or nn.canonical like 'Potamocorbula amurensis%'
or nn.canonical like 'Potamogeton crispus%'
or nn.canonical like 'Potamogeton perfoliatus%'
or nn.canonical like 'Potamopyrgus antipodarum%'
or nn.canonical like 'Procambarus clarkii%'
or nn.canonical like 'Procyon lotor%'
or nn.canonical like 'Prosopis %'
or nn.canonical like 'Prosopis glandulosa%'
or nn.canonical like 'Prosopis juliflora%'
or nn.canonical like 'Prunus campanulata%'
or nn.canonical like 'Pseudodiaptomus inopinus%'
or nn.canonical like 'Psidium cattleianum%'
or nn.canonical like 'Psidium guajava%'
or nn.canonical like 'Psittacula krameri%'
or nn.canonical like 'Psoralea pinnata%'
or nn.canonical like 'PTA%'
or nn.canonical like 'Pteris cretica%'
or nn.canonical like 'Pterois volitans%'
or nn.canonical like 'Pterygoplichthys %'
or nn.canonical like 'Pterygoplichthys anisitsi%'
or nn.canonical like 'Pterygoplichthys disjunctivus%'
or nn.canonical like 'Pterygoplichthys multiradiatus%'
or nn.canonical like 'Pterygoplichthys pardalis%'
or nn.canonical like 'Puccinia psidii%'
or nn.canonical like 'Pueraria montana%'
or nn.canonical like 'Pycnonotus cafer%'
or nn.canonical like 'Pycnonotus jocosus%'
or nn.canonical like 'Pylodictis olivaris%'
or nn.canonical like 'Pyrus calleryana%'
or nn.canonical like 'Python molurus%'
or nn.canonical like 'Quadrastichus erythrinae%'
or nn.canonical like 'Radumeris tasmaniensis%'
or nn.canonical like 'Raffaelea lauricola%'
or nn.canonical like 'Ramphotyphlops braminus%'
or nn.canonical like 'Rana catesbeiana%'
or nn.canonical like 'Rangia cuneata%'
or nn.canonical like 'Rangifer tarandus%'
or nn.canonical like 'Ranunculus ficaria%'
or nn.canonical like 'Raoiella indica%'
or nn.canonical like 'Rapana venosa%'
or nn.canonical like 'Rattus exulans%'
or nn.canonical like 'Rattus norvegicus%'
or nn.canonical like 'Rattus rattus%'
or nn.canonical like 'Rauvolfia vomitoria%'
or nn.canonical like 'Rhamnus alaternus%'
or nn.canonical like 'Rhamnus cathartica%'
or nn.canonical like 'Rhinella marina%'
or nn.canonical like 'Rhithropanopeus harrisii%'
or nn.canonical like 'Rhizophora mangle%'
or nn.canonical like 'Rhododendron ponticum%'
or nn.canonical like 'Rhodomyrtus tomentosa%'
or nn.canonical like 'Rhus longipes%'
or nn.canonical like 'Rhynchophorus ferrugineus%'
or nn.canonical like 'Ricinus communis%'
or nn.canonical like 'Rinderpest virus%'
or nn.canonical like 'Robinia pseudoacacia%'
or nn.canonical like 'Rosa bracteata%'
or nn.canonical like 'Rosa multiflora%'
or nn.canonical like 'Rottboellia cochinchinensis%'
or nn.canonical like 'Rubus alceifolius%'
or nn.canonical like 'Rubus discolor%'
or nn.canonical like 'Rubus ellipticus%'
or nn.canonical like 'Rubus moluccanus%'
or nn.canonical like 'Rubus niveus%'
or nn.canonical like 'Rubus phoenicolasius%'
or nn.canonical like 'Rubus pinnatus%'
or nn.canonical like 'Rubus rosifolius%'
or nn.canonical like 'Rubus ulmifolius%'
or nn.canonical like 'Ruellia brevifolia%'
or nn.canonical like 'Rumex acetosella%'
or nn.canonical like 'Rumex crispus%'
or nn.canonical like 'Rumex obtusifolius%'
or nn.canonical like 'Rupicapra rupicapra%'
or nn.canonical like 'Rusa unicolor%'
or nn.canonical like 'Rutilus rutilus%'
or nn.canonical like 'Sabella spallanzanii%'
or nn.canonical like 'Sacciolepis indica%'
or nn.canonical like 'Sagina procumbens%'
or nn.canonical like 'Sagittaria platyphylla%'
or nn.canonical like 'Sagittaria sagittifolia%'
or nn.canonical like 'Salix babylonica%'
or nn.canonical like 'Salix cinerea%'
or nn.canonical like 'Salix humboldtiana%'
or nn.canonical like 'Salmo salar%'
or nn.canonical like 'Salmo trutta%'
or nn.canonical like 'Salsola tragus%'
or nn.canonical like 'Salvelinus fontinalis%'
or nn.canonical like 'Salvelinus namaycush%'
or nn.canonical like 'Salvinia minima%'
or nn.canonical like 'Salvinia molesta%'
or nn.canonical like 'Samanea saman%'
or nn.canonical like 'Sansevieria hyacinthoides%'
or nn.canonical like 'Sansevieria trifasciata%'
or nn.canonical like 'Sargassum fluitans%'
or nn.canonical like 'Sargassum muticum%'
or nn.canonical like 'Sarotherodon occidentalis%'
or nn.canonical like 'Scaevola sericea%'
or nn.canonical like 'Scardinius erythrophthalmus%'
or nn.canonical like 'Schefflera actinophylla%'
or nn.canonical like 'Schinus terebinthifolius%'
or nn.canonical like 'Schismus arabicus%'
or nn.canonical like 'Schismus barbatus%'
or nn.canonical like 'Schizoporella errata%'
or nn.canonical like 'Schizoporella unicornis%'
or nn.canonical like 'Scinax ruber%'
or nn.canonical like 'Scinax x-signatus%'
or nn.canonical like 'Sciurus carolinensis%'
or nn.canonical like 'Scolopendra morsitans%'
or nn.canonical like 'Scolytus multistriatus%'
or nn.canonical like 'Scyphophorus acupunctatus%'
or nn.canonical like 'Sechium edule%'
or nn.canonical like 'Senecio angulatus%'
or nn.canonical like 'Senecio inaequidens%'
or nn.canonical like 'Senecio jacobaea%'
or nn.canonical like 'Senecio squalidus%'
or nn.canonical like 'Senecio viscosus%'
or nn.canonical like 'Senecio vulgaris%'
or nn.canonical like 'Senegalia catechu%'
or nn.canonical like 'Sesbania punicea%'
or nn.canonical like 'Setaria verticillata%'
or nn.canonical like 'Sirex noctilio%'
or nn.canonical like 'Sirococcus clavigignenti-juglandacearum%'
or nn.canonical like 'Solanum mauritianum%'
or nn.canonical like 'Solanum seaforthianum%'
or nn.canonical like 'Solanum sisymbriifolium%'
or nn.canonical like 'Solanum tampicense%'
or nn.canonical like 'Solanum torvum%'
or nn.canonical like 'Solanum viarum%'
or nn.canonical like 'Solenopsis geminata%'
or nn.canonical like 'Solenopsis invicta%'
or nn.canonical like 'Solenopsis papuana%'
or nn.canonical like 'Solenopsis richteri%'
or nn.canonical like 'Solidago canadensis%'
or nn.canonical like 'Sonchus asper%'
or nn.canonical like 'Sonchus oleraceus%'
or nn.canonical like 'Sorghum halepense%'
or nn.canonical like 'Spartina alterniflora%'
or nn.canonical like 'Spartina anglica%'
or nn.canonical like 'Spartina densiflora%'
or nn.canonical like 'Spartium junceum%'
or nn.canonical like 'Sparus aurata%'
or nn.canonical like 'Spathodea campanulata%'
or nn.canonical like 'Spermacoce verticillata%'
or nn.canonical like 'Sphaeroma quoianum%'
or nn.canonical like 'Sphaeroma quoyanum%'
or nn.canonical like 'Sphagneticola trilobata%'
or nn.canonical like 'Spiraea japonica%'
or nn.canonical like 'Sporobolus indicus%'
or nn.canonical like 'Stellaria alsine%'
or nn.canonical like 'Stellaria media%'
or nn.canonical like 'Streptopelia decaocto%'
or nn.canonical like 'Striga asiatica%'
or nn.canonical like 'Strobilanthes hamiltonianus%'
or nn.canonical like 'Sturnus vulgaris%'
or nn.canonical like 'Styela clava%'
or nn.canonical like 'Styela plicata%'
or nn.canonical like 'Suncus murinus%'
or nn.canonical like 'Sus scrofa%'
or nn.canonical like 'Syngonium podophyllum%'
or nn.canonical like 'Syzygium cumini%'
or nn.canonical like 'Syzygium jambos%'
or nn.canonical like 'Tabebuia heterophylla%'
or nn.canonical like 'Tamarix aphylla%'
or nn.canonical like 'Tamarix parviflora%'
or nn.canonical like 'Tamarix ramosissima%'
or nn.canonical like 'Tapinoma melanocephalum%'
or nn.canonical like 'Taraxacum officinale%'
or nn.canonical like 'Technomyrmex albipes%'
or nn.canonical like 'Tecoma capensis%'
or nn.canonical like 'Tecoma stans%'
or nn.canonical like 'Tenrec ecaudatus%'
or nn.canonical like 'Terminalia catappa%'
or nn.canonical like 'Tetropium fuscum%'
or nn.canonical like 'Thaumetopoea pityocampa%'
or nn.canonical like 'Thevetia peruviana%'
or nn.canonical like 'Thunbergia grandiflora%'
or nn.canonical like 'Thymophylla tenuiloba%'
or nn.canonical like 'Tibouchina urvilleana%'
or nn.canonical like 'Tilapia mariae%'
or nn.canonical like 'Tilapia zillii%'
or nn.canonical like 'Tinca tinca%'
or nn.canonical like 'Tithonia diversifolia%'
or nn.canonical like 'Tomicus piniperda%'
or nn.canonical like 'Toumeyella parvicornis%'
or nn.canonical like 'Trachemys scripta%'
or nn.canonical like 'Trachycarpus fortunei%'
or nn.canonical like 'Tradescantia fluminensis%'
or nn.canonical like 'Tradescantia spathacea%'
or nn.canonical like 'Trapa natans%'
or nn.canonical like 'Trechisibus antarcticus%'
or nn.canonical like 'Triadica sebifera%'
or nn.canonical like 'Trichosurus vulpecula%'
or nn.canonical like 'Tridentiger trigonocephalus%'
or nn.canonical like 'Trididemnum solidum%'
or nn.canonical like 'Trifolium dubium%'
or nn.canonical like 'Trifolium repens%'
or nn.canonical like 'Triphasia trifolia%'
or nn.canonical like 'Trogoderma granarium%'
or nn.canonical like 'Tubastraea coccinea%'
or nn.canonical like 'Tussilago farfara%'
or nn.canonical like 'Typha latifolia%'
or nn.canonical like 'Ulex europaeus%'
or nn.canonical like 'Undaria pinnatifida%'
or nn.canonical like 'Uredo rangelii%'
or nn.canonical like 'Urochloa maxima%'
or nn.canonical like 'Urochloa mutica%'
or nn.canonical like 'Urosalpinx cinerea%'
or nn.canonical like 'Utricularia gibba%'
or nn.canonical like 'Vachellia drepanolobium%'
or nn.canonical like 'Vallisneria nana%'
or nn.canonical like 'Vallisneria spiralis%'
or nn.canonical like 'Varanus indicus%'
or nn.canonical like 'Varanus niloticus%'
or nn.canonical like 'Varroa destructor%'
or nn.canonical like 'Verbascum thapsus%'
or nn.canonical like 'Verbena brasiliensis%'
or nn.canonical like 'Verbena rigida%'
or nn.canonical like 'Veronica serpyllifolia%'
or nn.canonical like 'Vespa velutina%'
or nn.canonical like 'Vespula germanica%'
or nn.canonical like 'Vespula pensylvanica%'
or nn.canonical like 'Vespula vulgaris%'
or nn.canonical like 'Vibrio cholerae%'
or nn.canonical like 'Vinca major%'
or nn.canonical like 'Vitex rotundifolia%'
or nn.canonical like 'Viverricula indica%'
or nn.canonical like 'Vulpes chama%'
or nn.canonical like 'Vulpes vulpes%'
or nn.canonical like 'Vulpia bromoides%'
or nn.canonical like 'Wasmannia auropunctata%'
or nn.canonical like 'Waterhousea floribunda%'
or nn.canonical like 'Watersipora subtorquata%'
or nn.canonical like 'West Nile virus%'
or nn.canonical like 'Wisteria floribunda%'
or nn.canonical like 'Wisteria sinensis%'
or nn.canonical like 'Xanthium spinosum%'
or nn.canonical like 'Xanthomonas axonopodis%'
or nn.canonical like 'Xenopus laevis%'
or nn.canonical like 'Xiphophorus hellerii%'
or nn.canonical like 'Xyleborus glabratus%'
or nn.canonical like 'Xylella fastidiosa%'
or nn.canonical like 'Xylosandrus compactus%'
or nn.canonical like 'Xylosandrus mutilatus%'
or nn.canonical like 'Yersinia pestis%'
or nn.canonical like 'Zantedeschia aethiopica%'
or nn.canonical like 'Zizania latifolia%'
or nn.canonical like 'Ziziphus mauritiana%'
or nn.canonical like 'Zoobotryon verticillatum%'
or nn.canonical like 'Zostera japonica%'
or nn.canonical like 'Zosterops japonicus%'
;