bcc15634-2ea1-4a71-aab9-7ed77ae8a69e Senckenberg Society For Nature Research Andrés Peredo Arce Postdoctoral researcher andres.peredo@senckenberg.de https://orcid.org/0000-0002-6353-9121 LifeWatch ERIC Lucia Vaira Service Centre ICT Coordinator lucia.vaira@lifewatch.eu https://orcid.org/0000-0002-5935-6074 2025-11-05 en <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> Excel taxonomy sampling Marco-Bolo None MIT License Excel template https://github.com/QCDIS/Biodiversity_time_series_analyses_from_European_marine_ecosystems/blob/main/data/Template_MBO_Example_raw_v3.xlsx Senckenberg Society For Nature Research Andrés Peredo Arce Postdoctoral researcher andres.peredo@senckenberg.de https://orcid.org/0000-0002-6353-9121 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. Metadata xslx taxagroup Taxonomic information The taxonimc classification using nine categories: Bacterioplankton, Phytoplankton, Macroalgae, Macrophytes, Zooplankton, Invertebrates, Fish, Birds and Mammals. siteid Site identifier The site-specific (e.g. alpha-numeric) identifier for each sampling location. sitename Site name The name of the sampling site. country Site country The country in which the data was collected (ISO 3166-1 alpha-2 codes). seaname Site sea name The name of the Sea/Ocean name (EEA https://www.eea.europa.eu/data-and-maps/figures/regional-ses-surrounding-europe-1). decimallatitude Site location latitude The decimal latitude (World Geodetic System 84 - WGS84 format). decimallongitude Site location longitude The decimal longitude (World Geodetic System 84 - WGS84 format). startyearcollected Start year The first sampling year. endyearcollected End year The last sampling year. samplingprotocol Sampling protocol The name of the sampling method. Birds xslx datecollected Sampling date The sampling date in ISO 8601 format (YYYY-MM-DD) siteid Site identifier The site-specific (e.g. alpha-numeric) identifier for each sampling location. sampleid Sample identifier 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. minimumdepthinmeters Minimum depth in meters The minimum depth in meters (if applicable/available) maximumdepthinmeters Maximum depth in meters The maximum depth in meters (if applicable/available) taxaname Taxon name The taxonomic level. It ideally includes the species name, ir alternatively the genus, family, or order. taxanameid Taxon identifier The Aphia ID number following WORMS (https://www.marinespecies.org/index.php) samplingeffort Sampling effort The value of the sampling effort. parameter Parameter It indicates if the measure refers to Abundance, Relative abundance, Concentration or Coverage data. parameter_value Parameter value The taxa abundance/coverage value. parameter_standardunit Parameter standard uniy The standard unit of the parameter. Method xslx taxagroup Taxonomic information The taxojnomic classification using nine categories: Bacterioplankton, Phytoplankton, Macroalgae, Macrophytes, Zooplankton, Invertebrates, Fish, Birds and Mammals. samplingprotocol Sampling protocol The name of the sampling method. instrument Instrument The name of the used instrument (categories defined here: https://vocab.nerc.ac.uk/search_nvs/L05/). references References The DOI of the study detailing the sampling method. description Description The short description of the sampling method.