Table 1 Description of the core OctocoralTraits v2.2 table containing observations binding measurements.
From: The Octocoral Trait Database: a global database of trait information for octocoral species
Variable | Value |
|---|---|
observation_id | A unique ID assigned to each trait observation to link trait measurements. This ID was manually assigned during the data compilation process. |
user_id | An ID for the user who integrated the data into the data descriptor. This ID can be cross-referenced with the user_id.csv interrelated table. |
access | A boolean value (0; private, 1; public) indicating that all entries in the OctocoralTraits v2.2 data descriptor are public. |
specie_id / specie_name | An ID / name for each octocoral species in the data descriptor, cross-referenced with the species_id.csv table. The species name follows the octocoral classification available in WoRMS as of May 2024. |
family_molecule | The valid family name for each octocoral species, based on the latest octocoral classification derived from molecular techniques. |
location_id / location_name | A unique ID / name for each location where trait data was collected, allowing for cross-referencing with the comprehensive list of locations in the related table location_id.csv. |
latitude / longitude | Two columns with the coordinates of each location expressed in decimal degrees. |
resource_id | An ID for the primary scientific source from which trait data was compiled. It can be cross-referenced with the table resource_id.csv. |
resource_secondary_id | An ID for the secondary scientific source from which trait data was compiled, if any. |
measurement_id | An ID for each trait measurement. |
trait_id / trait_name | An ID / name for each trait for which data was compiled. It can be cross-referenced with the table trait_id.csv, which contains the complete list of traits and their definitions. |
trait_category | Whether a trait is Biomechanical, Morphological, Geographical, Ecological, Reproductive, Physiological, about the conservation status of the species, or Contextual. |
standard_id / standard_unit | An ID / name for each measurement unit used. It can be cross-referenced with the table standard_id.csv, which contains the complete list of units and their definitions. |
methodology_id / methodology_name | An ID / name for each methodology reported to have been used to measure a trait. It can be cross-referenced with the interrelated table methodology_id.csv, which contains the complete list of methods and their description. |
value | The actual value measured for a given trait. |
value type_id / value_type | An ID / name for each categorical type of value used. It can be cross-referenced with the interrelated table value_type_id.csv, which contains the complete list of value types. |
precision | The level of uncertainty associated with the value if it is made up from more than one measurement. For range, the lower value is given in this column. |
precision_type_id / precision_type_name | An ID / name for each kind of uncertainty that the precision estimate (above) corresponds with (e.g., standard error, range…etc). |
precision_upper | It captures the maximum (upper) value if range is used as precision_type |
replicates | The number of measurements (replicates) that were used to calculate the value. The field is left blank when equal to one (e.g., a raw_value). |
notes | Any relevant comment regarding a particular measurement has been included as notes. |
Original Aphia ID in publication | The Aphia_ID code of the original species as it appeared in the publication from which the trait data was obtained. This ensures traceability of taxonomy changes, even when the combination is no longer valid, and the species has been reclassified. |
