Supplementary data

Supplementary data for the Pozzi et al. paper entitled "Ecological assessment of combined sewer overflow management practices through the analysis of benthic and hyporheic microbial assemblages and a tracking of exogenous bacterial taxa in a peri-urban intermittent stream". # Created by Dr Adrien C. MEYNIER POZZI on October 26th, 2021 # Part of DOmic research project funded by the Agence de l’Eau - Rhône Méditerranée Corse [AE-RMC, Project 2020 0702 DOmic, 2020-2023] # Part of the Chaudanne river long-term experiment site belonging to the Observatoire de Terrain en Hydrologie Urbaine (OTHU) # Part of the work conducted in the team on Opportinistic Bacterial Pathogen in the Environment (BPOE) led by Dr. Benoit Cournoyer # Samples were obtained in 2 campaigns, corresponding to periods before (2010-2011) or after (2018) the implementation of the 91/271/EEC European Directive that limited Combined-Sewer Overflow (CSO) discharges to the Chaudanne river # Samples consisted in surface water, benthic and hyporheic sediments taken in run, riffle and pool geomorphologic features, either upstream or downstream the CSO outlet, plus positive and negative controls Metadata. Name and description of data tables provided as supplementary information Data Name Description Data S1. List of samples with sampling design An array to describe sampling design. Top line is header and second line is metadata for each recorded variable. Data S2. River hydrology variables and hydraulic gradients at surveyed transects Array to describe the hydrologic variables and gradients at the studied transects. Top line is header, second line is metadata for each recorded variable, and third line is the unit of the variable, if any. Data S3. Hydrological indices and synthetic variables computed with ClustOfVar Hydrological indices computed for the river flow, precipitations and CSO overflows computed over a 3-week period preceding each sampling date. Data S4. CSO quantiles An array to describe CSO events included for the computation of the CSO dilution ratio (SI Data 6A) together with 6 tables and 3 figures (SI Data 6B to 6J) describing the CSO event ratio all year round over the studied period, as well as for events that occured before or after the CSO was modified and during low flow or high flow season. In SI Data 6A, top line is header and second line is metadata for each recorded variable. Data S5. Environmental variables (water physical-chemistry, nutrients, FIBs, MTEs, PAHs) with metadata An array to list environmental variables for all true samples (n=90) included in the study. Sample identifiers and dates are provided. First 8 rows list the CAS number, SANDRE number, unit, method, limit of quantification and norm for each variable, if any. Data S6. Raw environmental matrix for use in R An array to list experimental design and environmental variables for all true samples and controls. Several environmental variables were synthetized using the ClustOfVar method (Chavent et al (2012) 10.18637/jss.v050.i13). Format is directly usable in R software. Data S7. Scaled environmental matrix for use in R An array to list experimental design and environmental variables for all true samples and controls. Several environmental variables were synthetized using the ClustOfVar method (Chavent et al (2012) 10.18637/jss.v050.i13). All numeric variables were centered and scaled (means of 0 an standard deviations to 1; aka Z-scoring) Format is directly usable in R software.本数据集为Pozzi等人发表的论文补充数据，论文标题为《通过分析底栖与潜流微生物群落、追踪城郊间歇溪流中的外源细菌类群，评估合流制下水道溢流（Combined-Sewer Overflow, CSO）管理措施的生态效应》。 本数据集由Adrien C. MEYNIER POZZI博士于2021年10月26日创建。 本数据集属于DOmic研究项目的一部分，该项目由罗纳-地中海-科西嘉水资源局（Agence de l’Eau - Rhône Méditerranée Corse，简称AE-RMC）资助，项目编号为2020 0702 DOmic，执行周期为2020-2023年。 本数据集属于索丹河（Chaudanne river）长期试验站点的一部分，该站点隶属于城市水文野外观测站（Observatoire de Terrain en Hydrologie Urbaine，简称OTHU）。 本数据集属于Benoit Cournoyer博士领导的环境机会致病菌（Opportunistic Bacterial Pathogen in the Environment, BPOE）团队的研究工作（注：原文拼写为Opportinistic，应为Opportunistic）。 本数据集包含两次采样活动，分别对应欧盟91/271/EEC指令实施前（2010-2011年）与实施后（2018年）两个时期；该指令旨在限制合流制下水道溢流（CSO）向索丹河的排放。 采样样本涵盖：在合流制下水道溢流口上下游的急流段（run）、浅滩（riffle）与深潭（pool）三种河流地貌单元采集的地表水、底栖沉积物与潜流沉积物，以及阳性对照与阴性对照样本。 ### 元数据：补充材料中提供的各数据表名称及描述如下： 1. **数据S1：采样设计与样本清单** 本数组用于描述采样设计，首行为表头，第二行记录各变量的元数据。 2. **数据S2：调查断面的河流水文变量与水力梯度** 本数组用于描述研究断面的水文变量与水力梯度，首行为表头，第二行记录各变量的元数据，第三行（若有）标注各变量的单位。 3. **数据S3：基于ClustOfVar方法计算得到的水文指数与合成变量** 本数据集包含针对每次采样日期前3周内的河流流量、降水量与合流制下水道溢流事件计算得到的水文指数。 4. **数据S4：合流制下水道溢流事件分位数** 本数组用于描述用于计算CSO稀释比（补充数据6A）的合流制下水道溢流事件，同时包含6张数据表与3幅图表（补充数据6B至6J），用于描述研究期内全年的CSO事件占比，以及CSO管控措施实施前后、枯水季与丰水季发生的CSO事件占比。在补充数据6A中，首行为表头，第二行记录各变量的元数据。 5. **数据S5：带元数据的环境变量（水理化指标、营养盐、粪便指示菌（Fecal Indicator Bacteria, FIBs）、微量金属元素（Metals Trace Elements, MTEs）、多环芳烃（Polycyclic Aromatic Hydrocarbons, PAHs））** 本数组列出本研究纳入的全部有效样本（共90份）的环境变量，包含样本标识符与采样日期。前8行分别列出各变量的CAS编号、SANDRE编号、单位、检测方法、定量限与相关标准（若有）。 6. **数据S6：适用于R软件的原始环境矩阵** 本数组列出全部有效样本与对照样本的实验设计与环境变量。部分环境变量通过ClustOfVar方法合成（Chavent等, 2012, 10.18637/jss.v050.i13），格式可直接在R软件中使用。 7. **数据S7：适用于R软件的标准化环境矩阵** 本数组列出全部有效样本与对照样本的实验设计与环境变量。部分环境变量通过ClustOfVar方法合成（Chavent等, 2012, 10.18637/jss.v050.i13）。所有数值变量均经过中心化与标准化处理（均值为0，标准差为1，即Z分数转换），格式可直接在R软件中使用。