Column |
Data Type |
Null |
Description |
Values |
higher_plant_group_orig |
text |
YES |
|
|
tnrs_id |
bigint |
NO |
Integer primary key. Uniquely identifies each record in this table. |
|
name_id |
bigint |
YES |
Alternate integer identifier for the name submitted, assigned by TNRS |
|
name_submitted_verbatim |
text |
YES |
Verbatim name submitted, without pre-processing corrections (in most cases will be same as name_submitted) |
|
name_submitted |
text |
YES |
Name submitted to TNRS; usually = verbatim_family + verbatim_scientific_name, with corrections for characters not handled by TNRS |
|
name_submitted_rank |
text |
YES |
Taxonomic rank of name submitted, as detected by the TNRS name parser |
'family', 'forma', 'genus', 'NULL', 'species', … MORE |
family_submitted |
text |
YES |
Family submitted, as detected by the TNRS name parser. |
|
genus_submitted |
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 |
|
author_submitted |
text |
YES |
Authority submitted, if any, as detected by the TNRS name parser. |
|
bien_taxonomy_id |
bigint |
YES |
Foreign key to table bien_taxonomy |
|
taxon_id |
text |
YES |
Foreign key to table taxon |
|
family_taxon_id |
text |
YES |
Foreign key to taxon_id of family in table taxon |
|
genus_taxon_id |
text |
YES |
Foreign key to taxon_id of genus in table taxon |
|
species_taxon_id |
text |
YES |
Foreign key to taxon_id of species in table taxon |
|
family_matched |
text |
YES |
Family matched by the TNRS (if family submitted) |
|
name_matched |
text |
YES |
Taxon name matched by the TNRS |
|
name_matched_author |
text |
YES |
Standard of of the taxon name matched by the TNRS |
|
name_matched_rank |
text |
YES |
Taxonomic rank of name matched by the TNRS |
'agsp', 'convar', 'cv', 'family', 'forma', 'gen… MORE |
tnrs_name_matched_score |
numeric |
YES |
Overall TNRS name match score |
|
matched_taxonomic_status |
text |
YES |
Taxonomic status of name matched by TNRS |
'Accepted', 'Illegitimate', 'Invalid', 'No opin… MORE |
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.' |
|
scrubbed_taxonomic_status |
text |
YES |
Taxonomic status of final taxon name resolved by TNRS. In most cases will be accepted; if not accepted name will use matched name if matched_taxonomic_status='No opinion' |
'Accepted', 'No opinion', 'NULL' MORE |
scrubbed_family |
text |
YES |
Family of accepted taxon name resolved by TNRS. If no accepted name, family of matched name is used, but only if matched_taxonomic_status='No opinion'. |
|
scrubbed_genus |
text |
YES |
Genus of accepted name resolved by TNRS. If no accepted name, matched name is used if matched_taxonomic_status='No opinion'.. |
|
scrubbed_specific_epithet |
text |
YES |
Epithet of final accepted species resolved by TNRS. If no accepted name, epithet of matched species is used, but only if matched_taxonomic_status='No opinion'.. |
|
scrubbed_species_binomial |
text |
YES |
Accepted species resolved by TNRS. If no accepted name, matched species is used, but only if matched_taxonomic_status='No opinion'. |
|
scrubbed_taxon_name_no_author |
text |
YES |
Final accepted taxon name resolved by TNRS. If no accepted name, matched name is used, but only if matched_taxonomic_status='No opinion'. |
|
scrubbed_taxon_canonical |
text |
YES |
Final taxon name resolved by TNRS, omitting infraspecific indicators such as var., subsp., etc. |
|
scrubbed_author |
text |
YES |
Author of final taxon resolved by TNRS. If no accepted name, author of matched name is used if matched_taxonomic_status='No opinion'. |
|
scrubbed_taxon_name_with_author |
text |
YES |
Final accepted taxon name + author resolved by TNRS. If no accepted name, matched name is used if matched_taxonomic_status='No opinion'. |
|
scrubbed_species_binomial_with_morphospecies |
text |
YES |
Final species binomial resolved by TNRS, with unmatched terms, if any, appended to end. If no accepted name, matched name is used if matched_taxonomic_status='No opinion'. |
|
sources |
text |
YES |
Taxonomic sources consulted |
|
tnrs_warning |
text |
YES |
TNRS warnings, if any. |
'No match', 'NULL', 'Partial match', 'TNRS resu… MORE |
tnrs_match_summary |
text |
YES |
Summary of match completeness for this name. |
'Exact match', 'Fuzzy match', 'No match', 'NULL… MORE |
tnrs_author_matched_score |
numeric |
YES |
Match score of author (if author submitted with name) |
|
taxon_submitted |
text |
YES |
Name submitted to TNRS; usually = verbatim_family + verbatim_scientific_name, with corrections for characters not handled by TNRS |
|
bien_taxonomy_id_txt |
text |
YES |
[internal use] |
|
major_taxon |
text |
YES |
Major higher taxonomic group, not necessarily monophyletic (added by BIEN) |
|
animal_family_submitted |
text |
YES |
Non-plant family submitted, if any |
|
species_submitted |
text |
YES |
Unstandardized species name submitted, as detected by TNRS name parser |
|
higher_plant_group |
text |
YES |
Higher plant group of final resolved name (scrubbed_species_binomial) |
|