Column |
Data Type |
Null |
Description |
Values |
accepted_name_id |
text |
YES |
|
|
accepted_name_lsid |
text |
YES |
|
|
highertaxa_score_order |
text |
YES |
Ranking based on individual name match scores, from highest taxonomic component to lowest |
|
infraspecific_epithet_2_matched |
text |
YES |
|
|
infraspecific_epithet_2_score |
text |
YES |
|
|
infraspecific_epithet_matched |
text |
YES |
|
|
infraspecific_epithet_score |
text |
YES |
|
|
infraspecific_rank |
text |
YES |
|
|
infraspecific_rank_2 |
text |
YES |
|
|
name_matched_id |
text |
YES |
|
|
name_matched_lsid |
text |
YES |
|
|
overall_score_order |
text |
YES |
Best match ranking based on overall_score |
|
phonetic |
text |
YES |
|
|
specific_epithet_matched |
text |
YES |
|
|
name_id |
bigint |
YES |
Alternate integer identifier for the name submitted, assigned by TNRS |
|
name_submitted |
text |
YES |
Name submitted to TNRS; usually = verbatim_family + verbatim_scientific_name, with corrections for characters not handled by TNRS |
|
overall_score |
text |
YES |
Overall combined match score for taxon name and authority |
|
name_matched |
text |
YES |
Taxon name matched by the TNRS |
|
name_score |
text |
YES |
Match score for name without authority |
|
name_matched_rank |
text |
YES |
Taxonomic rank of name matched by the TNRS |
|
author_submitted |
text |
YES |
Authority submitted, if any, as detected by the TNRS name parser. |
|
author_matched |
text |
YES |
Authority matched |
|
author_score |
text |
YES |
Match score for authority, if submitted |
|
name_matched_author |
text |
YES |
Standard of of the taxon name matched by the TNRS |
|
name_matched_accepted_family |
text |
YES |
Family of accepted taxon, according to the classification used (usually, APG III) |
|
genus_submitted |
text |
YES |
Foreign key to taxon_id of genus in table taxon |
|
genus_matched |
text |
YES |
Match score for genus submitted to genus matched |
|
genus_score |
text |
YES |
Genus submitted, as detected by the TNRS name parser. |
|
specific_epithet_submitted |
text |
YES |
Specific epithet submitted, as detected by TNRS name parser |
|
specific_epithet_score |
text |
YES |
Match score for specific epithet |
|
family_submitted |
text |
YES |
Family submitted, as detected by the TNRS name parser. |
|
family_matched |
text |
YES |
Family matched by the TNRS (if family submitted) |
|
family_score |
text |
YES |
Match score for family matched to family submitted |
|
annotations |
text |
YES |
Standard annotations of uncertainty, etc., extracted from name: 'cf.', 'aff.', etc. |
|
unmatched_terms |
text |
YES |
Any trailing terms not matched by the TNRS, excluding authors and standard annotations such as 'cf.' |
|
name_matched_url |
text |
YES |
Url to original source of name matched |
|
taxonomic_status |
text |
YES |
Taxonomic status of the match name |
|
accepted_name |
text |
YES |
Accepted taxon name |
|
accepted_name_species |
text |
YES |
Accepted species name, omitting any subspecific taxa |
|
accepted_name_author |
text |
YES |
Author of accepted taxon name |
|
accepted_name_rank |
text |
YES |
Taxonomic rank of accepted taxon |
|
accepted_name_url |
text |
YES |
URL to source for accepted name |
|
accepted_name_family |
text |
YES |
Preferred family of accepted taxon, according to family classification chosen (usually APG III) |
|
source |
text |
YES |
Taxonomic sources consulted |
|
warnings |
text |
YES |
Warnings of problems or ambiguities detected by TRNS |
|
name_submitted_verbatim |
text |
YES |
Verbatim name submitted, without pre-processing corrections (in most cases will be same as name_submitted) |
|
name_submitted_rank |
text |
YES |
Taxonomic rank of name submitted, as detected by the TNRS name parser |
|
bien_taxonomy_id |
bigint |
YES |
Foreign key to table bien_taxonomy |
|
tnrs_scrubbed_id |
bigint |
NO |
Integer primary key. Uniquely identifies each record in this table. |
|
selected |
text |
YES |
Selected as best match |
|