1
|
COPY tnrs ("Time_submitted", "Name_number", "Name_submitted", "Overall_score", "Name_matched", "Name_matched_rank", "Name_score", "Name_matched_author", "Name_matched_url", "Author_matched", "Author_score", "Family_matched", "Family_score", "Name_matched_accepted_family", "Genus_matched", "Genus_score", "Specific_epithet_matched", "Specific_epithet_score", "Infraspecific_rank", "Infraspecific_epithet_matched", "Infraspecific_epithet_score", "Infraspecific_rank_2", "Infraspecific_epithet_2_matched", "Infraspecific_epithet_2_score", "Annotations", "Unmatched_terms", "Taxonomic_status", "Accepted_name", "Accepted_name_author", "Accepted_name_rank", "Accepted_name_url", "Accepted_name_species", "Accepted_name_family", "Selected", "Source", "Warnings", "Accepted_name_lsid", "Accepted_scientific_name", "Max_score") FROM stdin;
|
2
|
2013-06-06 14:31:26.280413-07 0 Fam_indet. Boyle#6501 0 No suitable matches found. \N 0 \N \N \N 0 \N 0 \N \N 0 \N 0 \N \N 0 \N \N 0 \N \N \N \N \N \N \N \N \N true \N \N \N 0
|
3
|
2013-06-06 14:31:26.280413-07 1 Poa annua var. eriolepis 1 Poa annua var. eriolepis variety 1 E. Desv. http://www.tropicos.org/Name/50119145 \N \N \N \N Poaceae Poa 1 annua 1 var. eriolepis 1 \N \N \N \N \N Synonym Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N Poaceae Poa annua L. 1
|
4
|
2013-06-06 14:31:26.280413-07 2 Poa annua 1 Poa annua species 1 L. http://www.tropicos.org/Name/25509881 \N \N \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Accepted Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N Poaceae Poa annua L. 1
|
5
|
2013-06-06 14:31:26.280413-07 3 Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire 0.77 Silene scouleri subsp. pringlei subspecies 0.77 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N var. grisea Accepted Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies http://www.tropicos.org/Name/6303627 Silene scouleri Caryophyllaceae true tropicos [Partial match] \N Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire 1
|
6
|
2013-06-06 14:31:26.280413-07 4 Fabaceae Boyle#6500 0.9 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N Boyle#6500 Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N Fabaceae Lindl. 1
|
7
|
2013-06-06 14:31:26.280413-07 5 Poa annua subsp. exilis 1 Poa annua subsp. exilis subspecies 1 (Tomm. ex Freyn) Asch. & Graebn. http://www.tropicos.org/Name/50063800 \N \N \N \N Poaceae Poa 1 annua 1 subsp. exilis 1 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae true tropicos \N Poaceae Poa infirma Kunth 1
|
8
|
2013-06-06 14:31:26.280413-07 6 Poa annua ssp. exilis 1 Poa annua subsp. exilis subspecies 1 (Tomm. ex Freyn) Asch. & Graebn. http://www.tropicos.org/Name/50063800 \N \N \N \N Poaceae Poa 1 annua 1 subsp. exilis 1 \N \N \N \N \N Synonym Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae true tropicos \N Poaceae Poa infirma Kunth 1
|
9
|
2013-06-06 14:31:26.280413-07 7 Poa annua subvar. minima 1 Poa annua subvar. minima subvariety 1 (Schur) Asch. & Graebn. http://www.tropicos.org/Name/50158097 \N \N \N \N Poaceae Poa 1 annua 1 subvar. minima 1 \N \N \N \N \N Accepted Poa annua subvar. minima (Schur) Asch. & Graebn. subvariety http://www.tropicos.org/Name/50158097 Poa annua Poaceae true tropicos \N Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn. 1
|
10
|
2013-06-06 14:31:26.280413-07 8 Poa annua L. 1 Poa annua species 1 L. http://www.tropicos.org/Name/25509881 L. 1 \N \N Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Accepted Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N Poaceae Poa annua L. 1
|
11
|
2013-06-06 14:31:26.280413-07 9 Compositae indet. sp.1 0.9 Compositae family 1 Giseke http://www.tropicos.org/Name/50255940 \N \N Compositae 1 Compositae \N \N \N \N \N \N \N \N \N \N \N indet. sp.1 Synonym Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos \N Asteraceae Bercht. & J. Presl 1
|
12
|
2013-06-06 14:31:26.280413-07 10 Poa annua fo. lanuginosa 1 Poa annua fo. lanuginosa forma 1 Sennen http://www.tropicos.org/Name/50267771 \N \N \N \N Poaceae Poa 1 annua 1 fo. lanuginosa 1 \N \N \N \N \N Synonym Poa annua var. annua \N variety http://www.tropicos.org/Name/25517736 Poa annua Poaceae true tropicos \N Poaceae Poa annua var. annua 1
|
13
|
2013-06-06 14:31:26.280413-07 11 Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire 0.77 Silene scouleri subsp. pringlei subspecies 0.77 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 \N \N \N \N Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N var. grisea Accepted Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies http://www.tropicos.org/Name/6303627 Silene scouleri Caryophyllaceae true tropicos [Partial match] \N Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire 1
|
14
|
2013-06-06 14:31:26.280413-07 12 Fabaceae Inga "fuzzy leaf" 0.9 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N "fuzzy leaf" Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N Fabaceae Inga Mill. 1
|
15
|
2013-06-06 14:31:26.280413-07 13 Fabaceae Inga sp.3 0.9 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 \N \N Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N sp.3 Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N Fabaceae Inga Mill. 1
|
16
|
2013-06-06 14:31:26.280413-07 14 Fabaceae unknown #2 0.9 Fabaceae family 1 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N unknown #2 Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos \N Fabaceae Lindl. 1
|
17
|
2013-06-06 14:31:29.731155-07 0 Poaceae Poa infirma Kunth 1 Poa infirma species 1 Kunth http://www.tropicos.org/Name/25514158 Kunth 1 Poaceae 1 Poaceae Poa 1 infirma 1 \N \N \N \N \N \N \N \N Accepted Poa infirma Kunth species http://www.tropicos.org/Name/25514158 Poa infirma Poaceae true tropicos \N Poaceae Poa infirma Kunth 1
|
18
|
2013-06-06 14:31:29.731155-07 1 Fabaceae Lindl. 0.5 Fabaceae family 0.5 Lindl. http://www.tropicos.org/Name/42000184 \N \N Fabaceae 1 Fabaceae \N \N \N \N \N \N \N \N \N \N \N Lindl. Accepted Fabaceae Lindl. family http://www.tropicos.org/Name/42000184 \N Fabaceae true tropicos [Partial match] \N Fabaceae Lindl. 1
|
19
|
2013-06-06 14:31:29.731155-07 2 Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn. 1 Poa annua subvar. minima subvariety 1 (Schur) Asch. & Graebn. http://www.tropicos.org/Name/50158097 (Schur) Asch. & Graebn. 1 Poaceae 1 Poaceae Poa 1 annua 1 subvar. minima 1 \N \N \N \N \N Accepted Poa annua subvar. minima (Schur) Asch. & Graebn. subvariety http://www.tropicos.org/Name/50158097 Poa annua Poaceae true tropicos \N Poaceae Poa annua subvar. minima (Schur) Asch. & Graebn. 1
|
20
|
2013-06-06 14:31:29.731155-07 3 Fabaceae Inga Mill. 1 Inga genus 1 Mill. http://www.tropicos.org/Name/40031040 Mill. 1 Fabaceae 1 Fabaceae Inga 1 \N \N \N \N \N \N \N \N \N \N Accepted Inga Mill. genus http://www.tropicos.org/Name/40031040 \N Fabaceae true tropicos \N Fabaceae Inga Mill. 1
|
21
|
2013-06-06 14:31:29.731155-07 4 Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire 1 Silene scouleri subsp. pringlei subspecies 1 (S. Watson) C.L. Hitchc. & Maguire http://www.tropicos.org/Name/6303627 (S. Watson) C.L. Hitchc. & Maguire 1 Caryophyllaceae 1 Caryophyllaceae Silene 1 scouleri 1 subsp. pringlei 1 \N \N \N \N \N Accepted Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire subspecies http://www.tropicos.org/Name/6303627 Silene scouleri Caryophyllaceae true tropicos \N Caryophyllaceae Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire 1
|
22
|
2013-06-06 14:31:29.731155-07 5 Poaceae Poa annua L. 1 Poa annua species 1 L. http://www.tropicos.org/Name/25509881 L. 1 Poaceae 1 Poaceae Poa 1 annua 1 \N \N \N \N \N \N \N \N Accepted Poa annua L. species http://www.tropicos.org/Name/25509881 Poa annua Poaceae true tropicos \N Poaceae Poa annua L. 1
|
23
|
2013-06-06 14:31:29.731155-07 6 Asteraceae Bercht. & J. Presl 0.4 Asteraceae family 0.5 Bercht. & J. Presl http://www.tropicos.org/Name/50307371 \N \N Asteraceae 1 Asteraceae \N \N \N \N \N \N \N \N \N \N \N Bercht. & J. Presl Accepted Asteraceae Bercht. & J. Presl family http://www.tropicos.org/Name/50307371 \N Asteraceae true tropicos [Partial match] \N Asteraceae Bercht. & J. Presl 1
|
24
|
2013-06-06 14:31:29.731155-07 7 Poaceae Poa annua var. annua 1 Poa annua var. annua variety 1 \N http://www.tropicos.org/Name/25517736 \N \N Poaceae 1 Poaceae Poa 1 annua 1 var. annua 1 \N \N \N \N \N Accepted Poa annua var. annua \N variety http://www.tropicos.org/Name/25517736 Poa annua Poaceae true tropicos \N Poaceae Poa annua var. annua 1
|
25
|
\.
|