Data From: Groundwater Surveillance Of Endemic Swine Pathogens On Forty Iowa Swine Farms Via Dead-end Ultrafiltration by US Government | Healthcare

About this Dataset

Data From: Groundwater Surveillance Of Endemic Swine Pathogens On Forty Iowa Swine Farms Via Dead-end Ultrafiltration

Groundwater samples were collected in an observational study design by dead-end ultrafiltration from private wells on 40 Iowa swine farms and analyzed by quantitative polymerase chain reaction (qPCR) to assess contamination by endemic swine pathogens and swine manure markers. These data facilitate investigation of groundwater as a biosecurity risk on swine farms. Each farm was sampled one time. Twenty farms were sampled in spring of 2024 (4/15/2024 – 5/29/2024) and twenty farms were sampled in fall of 2024 (9/16/2024 – 10/29/2024). Sample volumes were 639–853 L (mean = 759). Control samples were collected in the field for each field sample, and control samples were tested for all organisms if the corresponding field sample tested positive for any organism. Samples were shipped on ice to the laboratory where they were backflushed, underwent secondary concentration, and archived at -80 degrees Celsius. Secondary concentrates were subsampled for nucleic acid extraction using the QIAGEN QIAcube Connect system, and each nucleic acid extract was analyzed in duplicate by qPCR using a Roche LightCycler 480 II for the following microorganisms: Cryptosporidium spp., enteropathogenic Escherichia coli , porcine circovirus type 2, porcine epidemic diarrhea virus, porcine reproductive and respiratory syndrome virus, rotavirus group C, Salmonella spp., swine Bacteroidales (2 qPCR assays), and swine influenza virus. Negative and positive controls were included at lab steps for concentration, nucleic acid extraction, reverse transcription, and qPCR. PCR inhibition was assessed in each nucleic acid extract and mitigated by dilution if necessary. Data are expressed as genomic copies per liter of groundwater sampled unless otherwise indicated. Dataset consists of 1 spreadsheet file: Dataset 01102025_V4.csv. Variables in this file are described in the included data dictionary.
Organization: Department of Agriculture
Last updated: 2025-06-05T09:41:33.545940
Tags: biosecurity, groundwater, porcine-circovirus-2, porcine-influenza-a-virus, porcine-reproductive-and-respiratory-swine-virus, swine-pathogens

Tables

Data Dictionary

@usgov.usda_gov_data_from_groundwater_surveillance_of_endemic_4358f7c9.data_dictionary

12.37 KB
13 rows
10 columns


CREATE TABLE data_dictionary (
  "tablecolumn" VARCHAR,
  "columnheading" VARCHAR,
  "columndescription" VARCHAR,
  "extendeddescription" VARCHAR,
  "unitabbreviation" VARCHAR,
  "unitdefinition" VARCHAR,
  "additionalcolumnnote" VARCHAR,
  "analyticallaboratoryname" VARCHAR,
  "analyticallaboratorylocation" VARCHAR,
  "methodreference" VARCHAR
);

Dataset 01102025 V4

@usgov.usda_gov_data_from_groundwater_surveillance_of_endemic_4358f7c9.dataset_01102025_v4

13.14 KB
65 rows
16 columns


CREATE TABLE dataset_01102025_v4 (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "microorganism_marker_name_and_or_genetic_target" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR
);