Table Columns

If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings

  Sort columns ordinally
  Sort columns alphabetically

Columns in table "tnrs"




Column Data Type Null Description Values
unmatched_terms text YES Any trailing terms not matched by the TNRS, excluding authors and standard annotations such as 'cf.'
tnrs_warning text YES TNRS warnings, if any. 'No match', 'NULL', 'Partial match', 'TNRS resu… MORE
tnrs_name_matched_score numeric YES Overall TNRS name match score
tnrs_match_summary text YES Summary of match completeness for this name. 'Exact match', 'Fuzzy match', 'No match', 'NULL… MORE
tnrs_id bigint NO Integer primary key. Uniquely identifies each record in this table.
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
taxon_id text YES Foreign key to table taxon
specific_epithet_submitted text YES Specific epithet submitted, as detected by TNRS name parser
species_taxon_id text YES Foreign key to taxon_id of species in table taxon
species_submitted text YES Unstandardized species name submitted, as detected by TNRS name parser
sources text YES Taxonomic sources consulted
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_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_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_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_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'.
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_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_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_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'.
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 'family', 'forma', 'genus', 'NULL', 'species', … MORE
name_submitted text YES Name submitted to TNRS; usually = verbatim_family + verbatim_scientific_name, with corrections for characters not handled by TNRS
name_matched_rank text YES Taxonomic rank of name matched by the TNRS 'agsp', 'convar', 'cv', 'family', 'forma', 'gen… MORE
name_matched_author text YES Standard of of the taxon name matched by the TNRS
name_matched text YES Taxon name matched by the TNRS
name_id bigint YES Alternate integer identifier for the name submitted, assigned by TNRS
matched_taxonomic_status text YES Taxonomic status of name matched by TNRS 'Accepted', 'Illegitimate', 'Invalid', 'No opin… MORE
major_taxon text YES Major higher taxonomic group, not necessarily monophyletic (added by BIEN)
higher_plant_group_orig text YES
higher_plant_group text YES Major higher plant group, not necessarily monophyletic (added by BIEN)
genus_taxon_id text YES Foreign key to taxon_id of genus in table taxon
genus_submitted text YES Genus submitted, as detected by the TNRS name parser.
family_taxon_id text YES Foreign key to taxon_id of family in table taxon
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)
bien_taxonomy_id_txt text YES [internal use]
bien_taxonomy_id bigint YES Foreign key to table bien_taxonomy
author_submitted text YES Authority submitted, if any, as detected by the TNRS name parser.
annotations text YES Standard annotations of uncertainty, etc., extracted from name: 'cf.', 'aff.', etc.
animal_family_submitted text YES Non-plant family submitted, if any