Data From: Microbial Volatile Organic Compounds Mediate Attraction By A Primary But Not Secondary Stored Product Insect Pest In Wheat
Department of Agriculture
@usgov.usda_gov_data_from_microbial_volatile_organic_compound_f435f0f7
Department of Agriculture
@usgov.usda_gov_data_from_microbial_volatile_organic_compound_f435f0f7
This dataset is associated with the forthcoming publication entitled, "Microbial volatile organic compounds mediate attraction by a primary but not secondary stored product insect pest in wheat", and includes data on grain damage from near infrared spectroscopy, behavioral data from wind tunnel and release-recapture experiments, as well as volatile characterization of headspace from moldy grain. For all files, incubation intervals 9, 18, and 27 d represent how long grain was incubated after being tempered to a grain moisture of 12, 15, or 19% or left untempered (ctrl; 10.8% grain moisture). TSO = Trece storgard oil; empty = negative control (no stimulus), LGB = lesser grain borer (Rhzyopertha dominica), and RFB = red flour beetle (Tribolium castaneum).
Note: The resource 'GC/MS Grain MVOC Headspace Data' was added 2021-08-04 with the deletion of some compounds as unlikely natural compounds and potential contaminants. This is the dataset that undergirds the non-metric multidimensional scaling analysis.
See the included file list for more information about methods and results of each file in this dataset.
Resources in this dataset:
File Name: tvw_final_gc_ms_data.csv
Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excel
File Name: tvw_nearinfrared_sorting_damaged_grain_fungal_exp.csv
Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excel
File Name: tvw_rr_lgb_rfb_microbial_cues.csv
Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excel
File Name: tvw_wt_lgb_rfb_data_microbial_cues.csv
Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excel
File Name: taylor_headspace_final_data_peer_reviewed_ag_commons.csv
Resource Software Recommended: Microsoft Excel,url: https://www.microsoft.com/en-us/microsoft-365/excel
File Name: file_list_MVOCwheat.txt
Organization: Department of Agriculture
Last updated: 2024-03-30T11:20:39.834750
Tags: agriculture, ars, behavior, chemical-ecology, data-gov, entomology, headspace, lesser-grain-borer, microbial-cues, mvocs, np304, red-flour-beetle, stored-product-pests, stored-products, trapping, wind-tunnel
CREATE TABLE taylor_headspace_final_data_peer_reviewed_ag_commons (
"rep" VARCHAR,
"incubation" BIGINT,
"moisture" BIGINT,
"incubationmoisture" BIGINT,
"n_1_butanol_3_methyl" DOUBLE -- 1-Butanol, 3-methyl-,
"n_1_butanol_2_methyl" DOUBLE -- 1-Butanol, 2-methyl-,
"n_2_3_butanediol_r" DOUBLE -- 2,3-Butanediol, (R?-),
"n_2_3_butanediol_s" DOUBLE -- 2,3-Butanediol, (S?-),
"n_2_octene_z" DOUBLE -- 2-Octene, (Z)-,
"heptane_2_4_dimethyl" DOUBLE -- Heptane, 2,4-dimethyl-,
"n_2_nonenal_e" DOUBLE -- 2-Nonenal, (E)-,
"butanoic_acid_2_methyl_ethyl_ester" DOUBLE -- Butanoic Acid, 2-methyl-, Ethyl Ester,
"octane_4_methyl" DOUBLE -- Octane, 4-methyl-,
"n_1_hexanol" DOUBLE -- 1-Hexanol,
"butyrolactone" DOUBLE,
"n_2_3h_furanone_dihydro_5_methyl" DOUBLE -- 2(3H)-Furanone, Dihydro-5-methyl-,
"nonane_4_methyl" DOUBLE -- Nonane, 4-methyl-,
"n_1_octen_3_ol" DOUBLE -- 1-Octen-3-ol,
"n_1_hexanol_2_ethyl" DOUBLE -- 1-Hexanol, 2-ethyl-,
"nonane_5_methyl_5_propyl" DOUBLE -- Nonane, 5-methyl-5-propyl-,
"phenol_2_methoxy" DOUBLE -- Phenol, 2-methoxy-,
"cyclopentane_1_2_dipropyl" DOUBLE -- Cyclopentane, 1,2-dipropyl-,
"nonanal" DOUBLE,
"n_2_phenylethanol" DOUBLE -- 2-Phenylethanol,
"cinnamaldehyde_e" DOUBLE -- Cinnamaldehyde, (E)-,
"n_1_ethanone_3_4_dimethylphenyl" DOUBLE -- 1-ethanone,(3,4-dimethylphenyl-),
"cis_jasmone" DOUBLE,
"benzenemethanol_4_methoxy" DOUBLE -- Benzenemethanol, 4-methoxy-,
"n_5_9_undecadien_2_one_6_10_dimethyl" DOUBLE -- 5,9-undecadien-2-one, (6,10-dimethyl-),
"pentanoic_acid_1_1_dimethylpropyl_ester" DOUBLE -- Pentanoic Acid, 1,1-dimethylpropyl Ester,
"sulfurous_acid_pentadecyl_2_propyl_ester" DOUBLE -- Sulfurous Acid, Pentadecyl 2-propyl Ester,
"sulfurous_acid_hexyl_octyl_ester" DOUBLE -- Sulfurous Acid, Hexyl Octyl Ester
);CREATE TABLE tvw_nearinfrared_sorting_damaged_grain_fungal_exp (
"date" TIMESTAMP,
"replicate" BIGINT,
"grain_moisture" VARCHAR,
"incubation_interval" BIGINT,
"total_weight" DOUBLE,
"weight_good_grain" DOUBLE,
"weight_damaged_grain" DOUBLE,
"n__weight_damaged_grain" DOUBLE -- % Weight Damaged Grain
);CREATE TABLE tvw_rr_lgb_rfb_microbial_cues (
"release_recapture_behavioral_experiments_2018_2019" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6
);CREATE TABLE tvw_wt_lgb_rfb_data_microbial_cues (
"wind_tunnel_behavioral_experiments_2018_2019" VARCHAR,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"each_trial_2_min_long" VARCHAR,
"unnamed_7" VARCHAR -- Unnamed: 7,
"unnamed_8" VARCHAR -- Unnamed: 8,
"unnamed_9" VARCHAR -- Unnamed: 9
);Anyone who has the link will be able to view this.