Baselight

Data From: Life History Changes In Trogoderma Variabile And T. Inclusum Due To Mating Delay With Implications For Mating Disruption As A Management Tactic

Department of Agriculture

@usgov.usda_gov_data_from_life_history_changes_in_trogoderma__019edacd

Loading...
Loading...

About this Dataset

Data From: Life History Changes In Trogoderma Variabile And T. Inclusum Due To Mating Delay With Implications For Mating Disruption As A Management Tactic

Egg and progeny counts for Trogoderma variabile and Trogoderma inclusum adults with delays in mating. These data were generated to examine the effect of mating delay on life history and reproductive capacity as a cue to the use of mating disruption tactics such as pheromone lures. Survivorship was calculated as the last day egg counts were recorded for an individual. Blocks were adults that were all mated on the same day. Reps are an individual female. Control beetles are coded with either an "f" or an "m" for female and male and were never mated. Male control data was examined for similarity to female control data but was not used in further analysis and comparison. The experiment was all done at 30C, 65% relative humidity and a 16 light/8 dark photoperiod. Adults were transferred every 2 days to new vials and eggs were then counted and save for progeny counts. Trogoderma variabile populations were laboratory colonies for over 20 years. T. inclusum populations were collected in Kansas in August of 2012. We did not transform these data.

Resources in this dataset:

  • Resource Title: Progeny and egg counts for Trogoderma inclusum.

File Name: inclusum_mating_full_long.csv

Resource Description: Data for Trogoderma inclusum. Egg and progeny counts. Column headers: female age = day at which first mating occurred; species= T. inclusum; block=groups that were all mated on the same day; rep=an individual female; count=either eggs or progeny; Day = number of eggs of progeny counted on that given day. Adults were moved to new vials every two days, so egg and progeny counts are on a 2 day basis. Survivorship can be calculated as the last day that egg counts were taken. Day_ columns are the days post-mating.

  • Resource Title: Progeny and egg counts for Trogoderma variabile.

File Name: variabile_mating_full_long.csv

Resource Description: Data for Trogoderma variabile. Egg and progeny counts. Column headers: female age = day at which first mating occurred; species= T. inclusum; block=groups that were all mated on the same day; rep=an individual female; count=either eggs or progeny; Day = number of eggs of progeny counted on that given day. Adults were moved to new vials every two days, so egg and progeny counts are on a 2 day basis. Survivorship can be calculated as the last day that egg counts were taken. Day_ columns are the days post-mating.

  • Resource Title: Data Dictionary.

File Name: Data_Dictionary-Life_history_changes_Trogoderma.csv
Organization: Department of Agriculture
Last updated: 2024-03-30T11:19:58.883439
Tags: ars, data-gov, delayed-mating, demography, dermestid-beetle, larger-cabinet-beetle, life-history, mating-disruption, np304, pest-control, stored-product-pests, warehouse-beetle

Tables

Data Dictionary-Life History Changes Trogoderma

@usgov.usda_gov_data_from_life_history_changes_in_trogoderma__019edacd.data_dictionary_life_history_changes_trogoderma
  • 7.81 KB
  • 49 rows
  • 8 columns
Loading...

CREATE TABLE data_dictionary_life_history_changes_trogoderma (
  "spreadsheet_tab" VARCHAR,
  "element_or_value_display_name" VARCHAR,
  "description" VARCHAR,
  "data_type" VARCHAR,
  "character_length" BIGINT,
  "acceptable_values" VARCHAR,
  "required" VARCHAR,
  "accepts_null_value" VARCHAR
);

Inclusum Mating Full Long

@usgov.usda_gov_data_from_life_history_changes_in_trogoderma__019edacd.inclusum_mating_full_long
  • 22.03 KB
  • 364 rows
  • 28 columns
Loading...

CREATE TABLE inclusum_mating_full_long (
  "female_age" VARCHAR,
  "species" VARCHAR,
  "block" VARCHAR,
  "rep" VARCHAR,
  "count" VARCHAR,
  "day_0" VARCHAR,
  "day_2" DOUBLE,
  "day_4" DOUBLE,
  "day_6" DOUBLE,
  "day_8" DOUBLE,
  "day_10" DOUBLE,
  "day_12" DOUBLE,
  "day_14" DOUBLE,
  "day_16" DOUBLE,
  "day_18" DOUBLE,
  "day_20" DOUBLE,
  "day_22" DOUBLE,
  "day_24" DOUBLE,
  "day_26" DOUBLE,
  "day_28" DOUBLE,
  "day_30" DOUBLE,
  "day_32" DOUBLE,
  "day_34" DOUBLE,
  "day_36" DOUBLE,
  "day_38" DOUBLE,
  "day_40" DOUBLE,
  "day_42" DOUBLE,
  "day_44" DOUBLE
);

Variabile Mating Full Long

@usgov.usda_gov_data_from_life_history_changes_in_trogoderma__019edacd.variabile_mating_full_long
  • 16.15 KB
  • 356 rows
  • 21 columns
Loading...

CREATE TABLE variabile_mating_full_long (
  "female_age" VARCHAR,
  "species" VARCHAR,
  "block" VARCHAR,
  "rep" VARCHAR,
  "count" VARCHAR,
  "day_0" VARCHAR,
  "day_2" BIGINT,
  "day_4" DOUBLE,
  "day_6" DOUBLE,
  "day_8" DOUBLE,
  "day_10" DOUBLE,
  "day_12" DOUBLE,
  "day_14" DOUBLE,
  "day_16" DOUBLE,
  "day_18" DOUBLE,
  "day_20" DOUBLE,
  "day_22" DOUBLE,
  "day_24" DOUBLE,
  "day_26" DOUBLE,
  "day_28" VARCHAR,
  "day_30" VARCHAR
);

Share link

Anyone who has the link will be able to view this.