Data From: Detection Of Viral, Bacterial, And Protozoan Pathogens And Microbial Source Tracking Markers In Paired Large- And Small-volume Water Samples by US Government | Healthcare

About this Dataset

Data From: Detection Of Viral, Bacterial, And Protozoan Pathogens And Microbial Source Tracking Markers In Paired Large- And Small-volume Water Samples

This repository contains data supporting the publication, "Detection of viral, bacterial, and protozoan pathogens and microbial source tracking markers in paired large- and small-volume water samples." The dataset comprises qPCR concentrations of microbial targets in paired large volume and small volume samples from field studies and laboratory recovery experiments, as described in the main publication.

"Field studies.csv" contains sample data and target concentrations for three field studies, two in groundwater and one in surface water. In the "Groundwater - Private wells (n = 138)" study, large volume samples taken by dead-end ultrafiltration were compared to small volume grab samples. In the remaining two studies, large volume dead-end ultrafiltration and small volume samples were collected synchronously to remove the effect of spatial/temporal heterogeneity during collection. Only the 15 qPCR assays with detections and common to all studies are included. Geographic information is not included to protect the privacy of study participants.

"Recovery data.csv" contains laboratory data for large volume and small volume method recovery of three microbial targets (a bacterium, a virus, and a protozoan) at varying initial concentrations.

"Storage data.csv" contains laboratory data for microbial target decay during storage prior to processing. Liquid small volume samples and large volume ultrafilters were stored at 4 C to simulate normal sample storage and transport conditions. Concentrations of three microbial targets (a bacterium, a virus, and a protozoan) were determined for storage times from 0 to 96 hours.

Descriptive data for all microbial targets is provided in "Target data.csv". An explanation of variables (with units) for all data files can found in "Key to variables.csv".
Organization: Department of Agriculture
Last updated: 2025-06-05T09:39:47.013678
Tags: bacteria, dead-end-ultrafiltration, groundwater, pathogen, protozoa, sample-volume, surface-water, virus, water-sample-detection

Tables

Storage Data

@usgov.usda_gov_data_from_detection_of_viral_bacterial_and_pr_d5d1dbd1.storage_data

8.97 KB
60 rows
8 columns


CREATE TABLE storage_data (
  "sample_id" VARCHAR,
  "sample_volume" VARCHAR,
  "time" BIGINT,
  "adenovirus_groups_a_f" DOUBLE,
  "campylobacter_jejuni" DOUBLE,
  "cryptosporidium_spp" DOUBLE,
  "salmonella_inva_gene" DOUBLE,
  "salmonella_ttr_gene" DOUBLE
);

Target Data

@usgov.usda_gov_data_from_detection_of_viral_bacterial_and_pr_d5d1dbd1.target_data

4.78 KB
15 rows
5 columns


CREATE TABLE target_data (
  "target" VARCHAR,
  "full_target_name" VARCHAR,
  "category" VARCHAR,
  "organism_type" VARCHAR,
  "lod" DOUBLE
);

Field Studies

@usgov.usda_gov_data_from_detection_of_viral_bacterial_and_pr_d5d1dbd1.field_studies

35.64 KB
670 rows
23 columns


CREATE TABLE field_studies (
  "study_name" VARCHAR,
  "sample_volume" VARCHAR,
  "sample_pair_id" VARCHAR,
  "lims_id" BIGINT,
  "sampling_date" TIMESTAMP,
  "collected_volume" DOUBLE,
  "equivalent_volume_dna" DOUBLE,
  "equivalent_volume_rna" DOUBLE,
  "humm2" DOUBLE,
  "c_jejuni" DOUBLE,
  "pan_crypto" DOUBLE,
  "g_duodenalis" DOUBLE,
  "hadvaf" DOUBLE,
  "hf183" DOUBLE,
  "hev" DOUBLE,
  "nov2" DOUBLE,
  "pmmov" DOUBLE,
  "rota_nsp3" DOUBLE,
  "rota_vp1" DOUBLE,
  "rotc" DOUBLE,
  "sal_inva" DOUBLE,
  "sal_ttr" DOUBLE,
  "shiga_1" DOUBLE
);

Recovery Data

@usgov.usda_gov_data_from_detection_of_viral_bacterial_and_pr_d5d1dbd1.recovery_data

6.64 KB
234 rows
6 columns


CREATE TABLE recovery_data (
  "sample_id" VARCHAR,
  "sample_volume" VARCHAR,
  "initial_concentration" DOUBLE,
  "target" VARCHAR,
  "recovered_concentration" DOUBLE,
  "unnamed_5" VARCHAR
);

Key To Variables

@usgov.usda_gov_data_from_detection_of_viral_bacterial_and_pr_d5d1dbd1.key_to_variables

4.18 KB
23 rows
3 columns


CREATE TABLE key_to_variables (
  "file" VARCHAR,
  "variable" VARCHAR,
  "explanation" VARCHAR
);