Template input excel file for Biodiversity data from excel retriever

<div>This is a template input file for the Biodiversity data from excel retriever workflow component available <a href=" https://metadatacatalogue.lifewatch.eu/srv/eng/catalog.search#/metadata/d9fc8450-10d0-4774-92af-257a1fc4e488" target="_blank">here</a>. The Excel file includes four sheets to define and enable the metadata and data entry.</div>

IdentificationAbout this resource

Alternate Identifier: bcc15634-2ea1-4a71-aab9-7ed77ae8a69e

Publication Date: 2025-11-05

Title: Template input excel file for Biodiversity data from excel retriever

Short Name

Abstract: <div>This is a template input file for the Biodiversity data from excel retriever workflow component available <a href=" https://metadatacatalogue.lifewatch.eu/srv/eng/catalog.search#/metadata/d9fc8450-10d0-4774-92af-257a1fc4e488" target="_blank">here</a>. The Excel file includes four sheets to define and enable the metadata and data entry.</div>

Dataset Language: en

Dataset Creator: Senckenberg Society For Nature Research - Andrés Peredo Arce (Postdoctoral researcher)

Metadata Provider: LifeWatch ERIC - Lucia Vaira (Service Centre ICT Coordinator)

Dataset Contact: Senckenberg Society For Nature Research - Andrés Peredo Arce (Postdoctoral researcher)

Keywords (None)

Excel
taxonomy
sampling
Marco-Bolo

resourceLicensesLicense Information

Intellectual Rights: MIT License

Distribution

Online

A brief description of the the content of online URL.: Excel template

URL: https://github.com/QCDIS/Biodiversity_time_series_analyses_from_European_marine_ecosystems/blob/main/data/Template_MBO_Example_raw_v3.xlsx

• Project

Title: Marine Coastal Biodiversity Long-term Observations (MARCO-BOLO): Strengthening biodiversity observation in support of decision making

Abstract: MARCO-BOLO (MBO) aims to structure and strengthen European coastal and marine biodiversity observation capabilities, linking them to global efforts to understand and restore ocean health, hence ensuring that outputs respond to explicit stakeholder needs from policy, planning and industry. To this end MBO will establish and engage with a Community of Practice (CoP) to determine end-user needs with the aim of optimising marine data flows, knowledge uptake, and improving governance based on biodiversity observations. By exploiting synergies with concurrent projects MBO will develop and demonstrate new autonomous technology for biodiversity mapping and monitoring, and data streams from remote sensing, eDNA, robotics, optical and acoustic observations. Protocols for eDNA-based biodiversity observations are established and validated across applications, taxa and ecosystems. The sequence of the analytical and technical processes for the different use cases will be incorporated into operational Essential Ocean Variables (EOVs) and Essential Biodiversity Variables (EBVs) and included into online reusable workflows, contributing to the free and open access of EU and global biodiversity information facilities, and to support major EU biodiversity directives and global initiatives. The project partnership will leverage its international activities (MBON, GOOS, OBIS) and participation in UN Ocean Decade Programmes (Marine Life 2030, OBON, ODIS, Ocean Practices for the Decade) to align the MBO work programme to global CoP, ensuring European participation and leadership in global biodiversity monitoring and global science. MBO results will be designed to build upon existing capability and infrastructures, and to be relevant to existing frameworks so that outputs can be easily integrated into national, regional (EU and adjacent sea basins), and global observation systems, with no delay ensuring the reusability of the investments Europe is already making in data generation.

Personnel

Organization Name

Individual Name

Given Name

Surname

Position Name

• Data Table

Name: Metadata

Physical

Data Format

Externally Defined Format

Format Name: xslx

Attribute List

Attribute

Name: taxagroup

Label: Taxonomic information

Definition: The taxonimc classification using nine categories: Bacterioplankton, Phytoplankton, Macroalgae, Macrophytes, Zooplankton, Invertebrates, Fish, Birds and Mammals.

Standard Unit

Attribute

Name: siteid

Label: Site identifier

Definition: The site-specific (e.g. alpha-numeric) identifier for each sampling location.

Standard Unit

Attribute

Name: sitename

Label: Site name

Definition: The name of the sampling site.

Standard Unit

Attribute

Name: country

Label: Site country

Definition: The country in which the data was collected (ISO 3166-1 alpha-2 codes).

Standard Unit

Attribute

Name: seaname

Label: Site sea name

Definition: The name of the Sea/Ocean name (EEA https://www.eea.europa.eu/data-and-maps/figures/regional-ses-surrounding-europe-1).

Standard Unit

Attribute

Name: decimallatitude

Label: Site location latitude

Definition: The decimal latitude (World Geodetic System 84 - WGS84 format).

Standard Unit

Attribute

Name: decimallongitude

Label: Site location longitude

Definition: The decimal longitude (World Geodetic System 84 - WGS84 format).

Standard Unit

Attribute

Name: startyearcollected

Label: Start year

Definition: The first sampling year.

Standard Unit

Attribute

Name: endyearcollected

Label: End year

Definition: The last sampling year.

Standard Unit

Attribute

Name: samplingprotocol

Label: Sampling protocol

Definition: The name of the sampling method.

Standard Unit

• Data Table

Name: Birds

Physical

Data Format

Externally Defined Format

Format Name: xslx

Attribute List

Attribute

Name: datecollected

Label: Sampling date

Definition: The sampling date in ISO 8601 format (YYYY-MM-DD)

Standard Unit

Attribute

Name: siteid

Label: Site identifier

Definition: The site-specific (e.g. alpha-numeric) identifier for each sampling location.

Standard Unit

Attribute

Name: sampleid

Label: Sample identifier

Definition: The sample identifier built by combining site id and date. If desired, it can be added a third component to distinguish between samples taken at different depths or at different replicates. Format: SITE_ID_YYYYMMDD or SITE_ID_YYYYMMDD_MINDEPTHtoMAXDEPTH or SITE_ID_YYYYMMDD_REPLICATE.

Standard Unit

Attribute

Name: minimumdepthinmeters

Label: Minimum depth in meters

Definition: The minimum depth in meters (if applicable/available)

Standard Unit

Attribute

Name: maximumdepthinmeters

Label: Maximum depth in meters

Definition: The maximum depth in meters (if applicable/available)

Standard Unit

Attribute

Name: taxaname

Label: Taxon name

Definition: The taxonomic level. It ideally includes the species name, ir alternatively the genus, family, or order.

Standard Unit

Attribute

Name: taxanameid

Label: Taxon identifier

Definition: The Aphia ID number following WORMS ( https://www.marinespecies.org/index.php)

Standard Unit

Attribute

Name: samplingeffort

Label: Sampling effort

Definition: The value of the sampling effort.

Standard Unit

Attribute

Name: parameter

Label: Parameter

Definition: It indicates if the measure refers to Abundance, Relative abundance, Concentration or Coverage data.

Standard Unit

Attribute

Name: parameter_value

Label: Parameter value

Definition: The taxa abundance/coverage value.

Standard Unit

Attribute

Name: parameter_standardunit

Label: Parameter standard uniy

Definition: The standard unit of the parameter.

Standard Unit

• Data Table

Name: Method

Physical

Data Format

Externally Defined Format

Format Name: xslx

Attribute List

Attribute

Name: taxagroup

Label: Taxonomic information

Definition: The taxojnomic classification using nine categories: Bacterioplankton, Phytoplankton, Macroalgae, Macrophytes, Zooplankton, Invertebrates, Fish, Birds and Mammals.

Standard Unit

Attribute

Name: samplingprotocol

Label: Sampling protocol

Definition: The name of the sampling method.

Standard Unit

Attribute

Name: instrument

Label: Instrument

Definition: The name of the used instrument (categories defined here: https://vocab.nerc.ac.uk/search_nvs/L05/).

Standard Unit

Attribute

Name: references

Label: References

Definition: The DOI of the study detailing the sampling method.

Standard Unit

Attribute

Name: description

Label: Description

Definition: The short description of the sampling method.

Standard Unit

Default

IdentificationAbout this resource

resourceLicensesLicense Information

Distribution

Online

Project

• Project

Personnel

Individual Name

Data Tables

• Data Table

Physical

Data Format

Externally Defined Format

Attribute List

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

• Data Table

Physical

Data Format

Externally Defined Format

Attribute List

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

Attribute

• Data Table

Physical

Data Format

Externally Defined Format

Attribute List

Attribute

Attribute

Attribute

Attribute

Attribute