Data Package Metadata View Summary

Estimates of nitrogen and phosphorus excretion rates in individual marine and estuarine animals

General Information

Data Package:

Local Identifier:

knb-lter-sbc.172.7

Title:

Estimates of nitrogen and phosphorus excretion rates in individual marine and estuarine animals

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

This dataset contains nitrogen and phosphorus excretion rate, as well as dry biomass, estimates for individual vertebrate and invertebrate animals in marine and estuarine environments. This dataset is a product of an LTER Synthesis Working Group aimed at evaluating the spatiotemporal variability in consumer nutrient dynamics in the wake of global change across eight long-term ecological research projects. These projects include seven long-term ecological research programs (LTER) funded by the National Science Foundation: (1) California Current Ecosystem, (2) Florida Coastal Everglades, (3) Moorea Coral Reef, (4) Northern Gulf of Alaska, (5) Plum Island Ecosystems, (6) Santa Barbara Coastal, and (7) Virginia Coast Reserve LTER projects. Additionally, the dataset includes data from (8) The Partnership for Interdisciplinary Science of Coastal Oceans (PISCO) research program. The temporal coverage of each time series data varies among projects, with the earliest record in 1999 and the most recent in 2023.

This data package also includes five R scripts used for data harmonization, identical to those in the Initial Release of the LTER Synthesis Working Group: Consumer-Mediated Nutrient Dynamics Project, v1.0.0. You can find the release in GitHub here: https://github.com/lter/lterwg-marine-cnd/releases/tag/v1.0.0.

Short Name:

Nitrogen and phosphorus excretion rates

Publication Date:

2024-06-10

Language:

English

For more information:
Visit:	https://mackwhite.github.io/cndwg_website/
Visit:	DOI PLACE HOLDER

Time Period

Begin:

1999-09-07

End:

2023-07-26

People and Organizations
Contact:	Santa Barbara Coastal LTER [ email ]
Creator:	White, Mack
Creator:	Kui, Li
Creator:	Chen, Angel
Creator:	Strickland, Bradley
Creator:	Peters, Joey
Creator:	Grier, Shalanda
Creator:	Capone, Dante
Creator:	Cawley, Grace
Creator:	Emery, Kyle A
Creator:	Enright, Lauren N
Creator:	Stajner, Anya
Creator:	Lyon, Nicholas
Organization:	Santa Barbara Coastal LTER

Data Entities
Data Table Name:	Consumer excretion rate
Description:	Nitrogen and phosphorus excretion rates and dry biomass estimates for individual vertebrate and invertebrate animals
Other Name:	R scripts
Description:	Five R scripts used for process the consumer excretion rate dataset

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/knb-lter-sbc/172/7/9fc5a5a28e42b885ae8b7af2e6eb5d51
Name:	Consumer excretion rate
Description:	Nitrogen and phosphorus excretion rates and dry biomass estimates for individual vertebrate and invertebrate animals
Number of Records:	1863096
Number of Columns:	31

Table Structure

Object Name:

harmonized_consumer_excretion_CLEAN.csv

Size:

651056769 byte

Authentication:

b68d63e3e7da4de45f8593a8055b6ef2 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Project

Habitat

raw filename

Row number

year

Calendar Month

Calendar Day

Date

Site code

Subsite level1

Subsite level2

Subsite level3

Species code

Scientific name

Common Name

Kingdom

Phylum

Class

Order

Family

Genus

Organism Group

Diet category

Density in num/m

Individual Dry Mass

Temperature in C

Density in num/m2

Density in num/m3

Nitrogen excretion rate

Phosphorus excretion rate

Column Name:

project

habitat

raw_filename

row_num

year

month

day

date

site

subsite_level1

subsite_level2

subsite_level3

sp_code

scientific_name

species

common_name

kingdom

phylum

class

order

family

genus

taxa_group

diet_cat

density_num/m

dmperind_g/ind

temp_c

density_num/m2

density_num/m3

nind_ug/hr

pind_ug/hr

Definition:

Projects includes the seven LTER sites and the coastalCA site from the PISCO project

Habitat that the data were collected

Raw data file names as we received/ downloaded them

The row number within each raw file

Year of measurement

month of sampling formatted as MM

day of sampling formatted as DD

Date of the sampling

Site code within each of the project

Subsite at level 1 within each of the project

Subsite at level 2 within each of the project

Subsite at level 3 within each of the project

Species code from individual project

Taxonomic scientific name that matches the ITIS database

Taxonomic scientific name originated from individual project

common name of the organism

Kingdom name of taxon in Linnean taxanomic system

Phylum name of taxon in Linnean taxanomic system

Class name of taxon in Linnean taxanomic system

Order name of taxon in Linnean taxanomic system

Family name of taxon in Linnean taxanomic system

Genus name of taxon in Linnean taxanomic system

Functional grouping term for observed taxon

Diet catagory for observed taxon

The density taxon per meter

Dry biomass per individual

Average temperature in degreeC

The density taxon per squared meter

The density taxon per cubic meter

Nitrogen excretion rate per individual

Phosphorus excretion rate per individual

External Measurement Definition, Link:

has unit Number per metre

has unit Degree Celsius

has unit Number per square metre

has unit Number per cubic metre

Storage Type:

string

integer

date

string

float

Measurement Type:

nominal

dateTime

nominal

ratio

Measurement Values Domain:

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Format	YYYY
Precision	1

Format	MM
Precision	1

Format	DD
Precision	1

Format	YYYY-MM-DD
Precision	1

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Definition

any text

Unit	numberPerMeter
Precision	1e-10
Type	real

Unit	gramsPerInd
Precision	1e-10
Type	real

Unit	celsius
Precision	1e-05
Type	real

Unit	numberPerMeterSquared
Precision	1e-10
Type	real

Unit	numberPerMeterCubed
Precision	1e-10
Type	real

Unit	microgramsPerHour
Precision	1e-10
Type	real

Unit	microgramsPerHour
Precision	1e-10
Type	real

Missing Value Code:

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Code	.
Expl	value not recorded or not available

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

R scripts

Entity Type:

otherEntity

Description:

Five R scripts used for process the consumer excretion rate dataset

Physical Structure Description:

Object Name:

data_wrangling_script.zip

Size:

28846 byte

Authentication:

7d1dd9ad955d6f93ff79ea79b9aa0154 Calculated By MD5

Externally Defined Format:

Format Name:

ZIP

Data:

https://pasta-s.lternet.edu/package/data/eml/knb-lter-sbc/172/7/195fe21811a0b870f006a90e6c65f6cb

Data Package Usage Rights

This data package is released under the Creative Commons License Attribution 4.0 International (CC BY 4.0, see https://creativecommons.org/licenses/by/4.0/). This license states that consumers ("Data Users" herein) may distribute, adapt, reuse, remix, and build upon this work, as long as they give appropriate credit, provide a link to the license, and indicate if changes were made. If redistributed, a Data User may not apply additional restrictions or technological measures that prevent access.

The Data User has an ethical obligation to cite the data source appropriately in any publication or product that results from its use, and notify the data contact or creator. Communication, collaboration, or co-authorship (as appropriate) with the creators of this data package is encouraged to prevent duplicate research or publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplication or inappropriate use. The Data User should realize that misinterpretation may occur if data are used outside of the context of the original study. The Data User should be aware that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data.

While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. This data package (with its components) is made available “as is” and with no warranty of accuracy or fitness for use. The creators of this data package and the repository where these data were obtained shall not be liable for any damages resulting from misinterpretation, use or misuse of the data package or its components.

Keywords

By Thesaurus:
LTER Controlled Vocabulary v1	Air Temperature, long term ecological research, marine, organism, phosphorus
SBC-LTER Controlled Vocabulary	Ecosystem Processes, Nearshore Ocean
Global Change Master Directory (GCMD) v6.0.0.0.0	Air Temperature, Nitrogen, Nutrients
Knowledge Network for Biocomplexity	Nutrients
NBII Biocomplexity	Aquatic organisms, Nutrients
none	consumer-derived nutrients, consumers, excretion, nutrient recycling, nutrient regeneration

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package

Description:

The dataset includes nitrogen and phosphorus excretion rate estimates from eight research programs and spans observations from 1999 to 2023. The appropriate datasets were identified during the 2022 LTER All-Scientists Meeting in Monterey, California. For information on dataset provenance, please see the Data Source section below. Datasets assessed for inclusion in working group efforts required size measurements (i.e., either mass or length) at the individual species level, alongside animal density estimates (# per unit area), in order to estimate nitrogen and phosphorus excretion rates using universal models published by Vanni & McIntyre (2016). These models required the following information to estimate excretion for individual animals: (1) individual dry biomass, (2) temperature, (3) vertebrate-invertebrate classification, and (4) coarse trophic guild categorization. For projects that recorded individual biomass but had missing values (i.e., due to field or data entry errors), we calculated the average mass for the given species within the program to estimate individual mass. For datasets that had length but no mass measurements, mass was calculated using length-weight coefficients published on FishBase or SeaLifeBase. Dry biomass was calculated for all individuals using project-level coefficients. In cases where wet-dry biomass coefficients were not available at the site, published coefficients were used to convert wet to dry mass. Temperature was held constant across each of the projects using mean water (for aquatic organisms) or air (for terrestrial organisms) temperature during the sampling period, using environmental data from the respective projects. Taxonomic classifications were determined using the taxize package in R, and the information was used to determine whether vertebrate or invertebrate coefficients were to be used in excretion rate calculations. Individual species were assigned to one of five trophic guilds (i.e., algivore/detritivore, invertivore, piscivore, piscivore/invertivore, and algivore/detritivore/insectivore/piscivore). The trophic guild of individual species was determined by project experts from each of the respective research programs. Once individual datasets contained the necessary information for excretion rate calculations, we performed zero-filled to permit calculation of areal excretion rate estimates for nitrogen and phosphorus in the unit of μg/m^2/hr. Next, standard column names were assigned to individual dataset in the data integration process.

Data Source:

Florida Coastal Everglades: https://pasta.lternet.edu/package/data/eml/knb-lter-fce/1164/12/de8a81c56378979f369fff30bbde9f01

Moorea Coral Reef: https://doi.org/10.6073/pasta/75644add7e7f90c568bf5045264d359a

Plum Island Ecosystems: https://doi.org/10.6073/pasta/de6b4cbb10fa240a63c95ffdd6152432

Santa Barbara Coastal (ocean): https://doi.org/10.6073/pasta/9ddf2268b69115670be27cdfd29ad104

Santa Barbara Coastal (beach): https://doi.org/10.6073/pasta/d84164f4099a98817e3f0afa49546b94

Virginia Coast Reserve: https://portal.edirepository.org/nis/mapbrowse?packageid=knb-lter-vcr.236.14

The Partnership for Interdisciplinary Science of Coastal Oceans (PISCO): https://doi.org/10.25494/P6/MLPA_kelpforest.5

The datasets from California Current Ecosystem and Northern Gulf of Alaska LTER sites are compiled through emails.

References:

Vanni, M. J., & McIntyre, P. B. (2016). Predicting nutrient excretion of aquatic animals with metabolic ecology and ecological stoichiometry: A global synthesis. Ecology, 97(12), 3460–3471. https://doi.org/10.1002/ecy.1582

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@edirepository.org

Web Address:

https://edirepository.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

Mack White

Address:

Department of Earth & Environment Florida International University,

Miami, FL 33181 US

Email Address:

mwhite@fiu.edu

Id:

https://orcid.org/0000-0002-6617-7023

Individual:

Li Kui

Address:

Marine Science Institute University of California,

Santa Barbara, CA 93106-6150 US

Email Address:

lkui@ucsb.edu

Id:

https://orcid.org/0000-0002-5894-4907

Individual:

Angel Chen

Address:

National Center for Ecological Analysis and Synthesis University of California Santa Barbara,

Santa Barbara, CA 93101 US

Email Address:

anchen@nceas.ucsb.edu

Id:

https://orcid.org/0000-0003-3515-6710

Individual:

Bradley Strickland

Address:

National Park Service South Florida Natural Resources Center,

Homestead, FL 33033 US

Email Address:

bradley_strickland@nps.gov

Id:

https://orcid.org/0000-0001-6443-7672

Individual:

Joey Peters

Address:

Great Ecology,

San Diego, CA 92103

Email Address:

jpeters.ecology@gmail.com

Id:

https://orcid.org/0000-0002-9625-1626

Individual:

Shalanda Grier

Address:

Department of Ecology, Evolution and Marine Biology University of California,

Santa Barbara, CA 93106 US

Email Address:

shalandagrier@ucsb.edu

Individual:

Dante Capone

Address:

Scripps Institution of Oceanography Univeristy of California San Diego,

San Diego, CA 92093

Email Address:

dcapone@ucsd.edu

Id:

https://orcid.org/0009-0005-1232-359X

Individual:

Grace Cawley

Address:

Scripps Institution of Oceanography Univeristy of California San Diego,

San Diego, CA 92093

Email Address:

gcawley@ucsd.edu

Id:

https://orcid.org/0000-0002-8813-1579

Individual:

Kyle A Emery

Address:

Marine Science Institute University of California,

Santa Barbara, CA 93106 USA

Email Address:

emery@ucsb.edu

Id:

https://orcid.org/0000-0003-0536-317X

Individual:

Lauren N Enright

Address:

Department of Ecology, Evolution and Marine Biology University of California,

Santa Barbara, CA 93106 US

Email Address:

laurenenright@ucsb.edu

Id:

https://orcid.org/0009-0007-2442-2805

Individual:

Anya Stajner

Address:

Scripps Institution of Oceanography Univeristy of California San Diego,

San Diego, CA 92093

Email Address:

Astajner@ucsd.edu

Id:

https://orcid.org/0000-0002-8755-5548

Individual:

Nicholas Lyon

Address:

National Center for Ecological Analysis and Synthesis University of California Santa Barbara,

Santa Barbara, CA 93101 US

Email Address:

lyon@nceas.ucsb.edu

Id:

https://orcid.org/0000-0003-3905-1078

Contacts:

Organization:

Santa Barbara Coastal LTER

Address:

Marine Science Institute,

University of California,

Santa Barbara, California 93106-6150 United States

Email Address:

sbclter@msi.ucsb.edu

Web Address:

https://sbclter.msi.ucsb.edu/

Id:

https://ror.org/05hnkta08

Associated Parties:

Organization:

Santa Barbara Coastal LTER

Address:

Marine Science Institute University of California,

Santa Barbara, CA 93106 USA

Email Address:

sbclter@msi.ucsb.edu

Role:

publisher, curator

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:

Time Period

Begin:

1999-09-07

End:

2023-07-26

Geographic Region:

Description:

Marine and estuarine environments: Marine and estuarine environments in the Pacific and Atlantic Ocean

Bounding Coordinates:

Northern:	59.05	Southern:	-17.49
Western:	-149.83	Eastern:	-70.89

Project

Parent Project Information:

Title:

Consumer-mediated nutrient dynamics of marine ecosystems under the wake of global change

Personnel:

Individual:

Mack White

Address:

Department of Earth & Environment Florida International University,

Miami, FL 33181 US

Email Address:

mwhite@fiu.edu

Role:

Principal Investigator

Funding:

Marine Consumer Nutrient Dynamics Synthesis Group supported through the Long Term Ecological Research Network Office (LNO) (NSF award numbers 1545288 and 1929393) and the National Center for Ecological Analysis and Synthesis, UCSB.

Additional Award Information:

Funder:

National Science Foundation

Funder ID:

https://dx.doi.org/10.13039/100000001

Number:

1929393

Title:

Consumer-mediated nutrient dynamics of marine ecosystems under the wake of global change

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'unitList'
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'abbreviation' = 'C'
        |     |     |     |  \___attribute 'constantToSI' = '273.18'
        |     |     |     |  \___attribute 'id' = 'celsius'
        |     |     |     |  \___attribute 'multiplierToSI' = '1'
        |     |     |     |  \___attribute 'name' = 'celsius'
        |     |     |     |  \___attribute 'parentSI' = 'kelvin'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'SI-derived unit of temperature'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'abbreviation' = 'g/ind'
        |     |     |     |  \___attribute 'id' = 'gramsPerInd'
        |     |     |     |  \___attribute 'multiplierToSI' = '0.001'
        |     |     |     |  \___attribute 'name' = 'gramsPerInd'
        |     |     |     |  \___attribute 'parentSI' = 'kilogramsPerInd'
        |     |     |     |  \___attribute 'unitType' = 'massSpecificCount'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'grams Per Individual'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'microgramsPerHour'
        |     |     |     |  \___attribute 'multiplierToSI' = '0.001'
        |     |     |     |  \___attribute 'name' = 'microgramsPerHour'
        |     |     |     |  \___attribute 'parentSI' = 'gramsPerHour'
        |     |     |     |  \___attribute 'unitType' = 'massFlux'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'micrograms per hour'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'numberPerMeter'
        |     |     |     |  \___attribute 'name' = 'numberPerMeter'
        |     |     |     |  \___attribute 'unitType' = 'arealDensity'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Number per meter'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'numberPerMeterCubed'
        |     |     |     |  \___attribute 'multiplierToSI' = '1'
        |     |     |     |  \___attribute 'name' = 'numberPerMeterCubed'
        |     |     |     |  \___attribute 'unitType' = 'volumetricDensity'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'number per meter cubed'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'numberPerMeterSquared'
        |     |     |     |  \___attribute 'multiplierToSI' = '1'
        |     |     |     |  \___attribute 'name' = 'numberPerMeterSquared'
        |     |     |     |  \___attribute 'unitType' = 'arealDensity'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'number per meter squared'
        |     |     |     |___text '\n            '
        |     |     |___text '\n         '
        |     |___text '\n      '
        |___text '\n   '

Copyright 2024 Environmental Data Initiative. This material is based upon work supported by the National Science Foundation under grants #2223103 and #2223104. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Please contact us with questions, comments, or for technical assistance regarding this web site or the Environmental Data Initiative. Please read our privacy policy to know what information we collect about you and to understand your privacy rights.

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

Data Package Metadata View Summary

Estimates of nitrogen and phosphorus excretion rates in individual marine and estuarine animals

Data Entities

Data Table

Non-Categorized Data Resource

Data Package Usage Rights

Keywords

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Data Source:

References:

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Parent Project Information:

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Estimates of nitrogen and phosphorus excretion rates in individual marine and estuarine animals

+/- Data Entities

Data Table

Non-Categorized Data Resource

+/- Data Package Usage Rights

+/- Keywords

+/- Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Data Source:

References:

+/- People and Organizations

+/- Temporal, Geographic and Taxonomic Coverage

+/- Project

Parent Project Information:

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Additional Metadata