The BlueBio Project’s database

The BlueBio database is a comprehensive and robust compilation of international and national research projects active in the years 2003-2022 in Fisheries, Aquaculture, Seafood Processing and Marine Biotechnology. Based on the COFASP projects’ database, it was implemented within the ERA-NET Cofund BlueBio project through a 3-years data collection including 3 surveys (.xlsx file) and a wide data retrieval. After being integrated, data were harmonised, shared as open and disseminated through a WebGIS (https://bluebioeconomy.eu/the-bluebio-projects-online-database/). The WebGIS was key for data update and validation as users were enabled to add new projects and edit existing ones.The database consists of 3,761 “georeferenced” projects, described by 22 parameters that are clustered into textual and spatial, some directly collected while others deduced. The database is a living archive to inform actors of the Blue Bioeconomy sector in a period of rapid transformations and research needs. The selection of projects to be included in the database was based on a combination of keywords previously identified by database administrators within the title, abstract, and, when available, keywords.The complete BlueBio database information backup (.sql file) should be restored in Postgre SQL. Collected research projects are also presented in a more user friendly .csv file, along with the R code used for its extraction.As compared to the previous version, the database has been further enhanced by adding projects related to the years 2020-2022, as well as finalizing the harmonization of the data to achieve a more detailed and accurate allocation of projects.The related report MS37 refers on the results of a series of exploratory analyses aimed to describe the information contained in the BlueBio research projects’ database.* corresponding author: Anna Nora Tassetti, [e-mail]

BlueBio数据库是一套全面且严谨的科研项目汇编库，收录了2003至2022年间活跃于渔业、水产养殖、海产品加工及海洋生物技术领域的国际与国家级科研项目。该数据库以COFASP项目数据库为基础，依托欧盟研究与创新战略议程联合资助（ERA-NET Cofund）BlueBio项目框架完成搭建，历经三年的数据收集工作，涵盖3份.xlsx格式调研文件及大规模数据检索环节。数据经整合与统一协调后，以开放共享的形式通过WebGIS平台（https://bluebioeconomy.eu/the-bluebio-projects-online-database/）进行发布与传播。该WebGIS平台是数据更新与校验的核心载体，支持用户新增科研项目并编辑已收录的项目信息。本数据库共收录3761个带地理参考标识的科研项目，每项项目由22项参数进行描述，这些参数可划分为文本类与空间类两类，其中部分参数为直接采集所得，其余则通过推导得出。本数据库作为动态更新的活档案库，可为快速变革期内的蓝色生物经济（Blue Bioeconomy）领域从业者提供精准信息支撑，契合当前行业的科研需求。数据库的项目收录筛选规则由管理人员预先设定关键词组合，从项目标题、摘要（若提供）及项目关键词中进行匹配筛选。完整的BlueBio数据库信息备份文件（.sql）需在PostgreSQL环境中完成恢复部署。收录的科研项目同时提供更易用的.csv格式文件，以及用于提取该数据集的R语言代码脚本。相较于此前版本，本数据库新增了2020至2022年相关的科研项目，并完成了全量数据的统一协调规范工作，从而实现对项目更为细致精准的归类分配。相关报告MS37阐述了一系列探索性分析的成果，这些分析旨在全面描述BlueBio科研项目数据库所收录的信息内容。* 通讯作者：Anna Nora Tassetti，电子邮箱：[e-mail]