Data From: Host Specificity Of Aphelinus Species Collected From Soybean Aphid In Asia
Department of Agriculture
@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce
Department of Agriculture
@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce
The soybean aphid, Aphis glycines Matsumura (Hemiptera: Aphididae), is native to Asia where it is an occasional pest of soybean, Glycine max (L.). Aphis glycines was found during 2000 in North America and since then has spread throughout much of the area where soybean is grown. In Asia, A. glycines seldom reaches damaging levels; however in North America, it has become the most important insect pest of soybean, decreasing yields and incurring large control costs. Field surveys and exclosure experiments in China showed that natural enemies can limit soybean aphid abundance. A project to find, evaluate, and introduce Asian natural enemies into North America was initiated in 2001, with an emphasis on parasitoids. To ensure that introductions of exotic parasitoids would have minimum impact on non-target species, we tested host specificity of all candidates for introduction. These data sets provide results of no-choice laboratory experiments on host specificity of 13 populations in seven species from three species complexes in the genus Aphelinus (Hymenoptera: Aphelinidae). They also provide results of experiments on the mechanisms of host specificity in three parasitoid species with narrow host ranges.
See the included README file list for more details on methods and citations for these data files.
Resources in this dataset:
File Name: data_dictionary_host_specificity_of_Aphelinus.csv
File Name: Aphelinus_soybean_aphid_culture_data.csv
File Name: Aphelinus_soybean_aphid_host_use.csv
File Name: Aphelinus_coreae_with_Aphis_species.csv
File Name: Aphelinus_glycinis_with_Aphis_species.csv
File Name: Aphelinus_rhamni_with_Aphis_species.csv
File Name: Aphelinus_coreae_behavior_summary.csv
File Name: Aphelinus_coreae_behavior_detailed.csv
File Name: Aphelinus_glycinis_behavior_summary.csv
File Name: Aphelinus_glycinis_behavior_detailed.csv
File Name: Aphelinus_rhamni_behavior_summary.csv
File Name: Aphelinus_rhamni_behavior_detailed.csv
File Name: file_list_HostSpecificityAphelinusAsia.txt
Organization: Department of Agriculture
Last updated: 2024-03-30T11:18:41.196454
Tags: aphelinus-asychis-complex, aphelinus-coreae, aphelinus-glycinis, aphelinus-mali-complex, aphelinus-rhamni, aphelinus-varipes-complex, ars, biological-control, data-gov, np304, soybean-aphid
CREATE TABLE aphelinus_coreae_behavior_detailed (
"species" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"order" BIGINT,
"exphost" VARCHAR,
"datexp" TIMESTAMP,
"aphidid" BIGINT,
"location" VARCHAR,
"approaches" BIGINT,
"stings" BIGINT,
"misses" BIGINT,
"leg" BIGINT,
"longstingord" VARCHAR,
"sapprmin" VARCHAR,
"spprsec" VARCHAR,
"eapprmin" VARCHAR,
"eapprsec" VARCHAR,
"sstingmin" VARCHAR,
"sstingsec" VARCHAR,
"estingmin" VARCHAR,
"estingsec" VARCHAR,
"shfmin" VARCHAR,
"shfsec" VARCHAR,
"ehfmin" VARCHAR,
"ehfsec" VARCHAR,
"hf" BIGINT,
"jump" BIGINT,
"visits" BIGINT,
"disturb" BIGINT,
"up" BIGINT,
"wave" BIGINT,
"buck" BIGINT,
"kick" BIGINT,
"rotate" BIGINT,
"walk" BIGINT,
"corn" DOUBLE,
"drop" BIGINT,
"twitch" BIGINT,
"notwalk" BIGINT,
"fall" BIGINT
);CREATE TABLE aphelinus_coreae_behavior_summary (
"species" VARCHAR,
"country" VARCHAR,
"city" VARCHAR,
"year" BIGINT,
"orghost" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"location" BIGINT,
"exphost" VARCHAR,
"aphid_treat" VARCHAR,
"age" BIGINT,
"time_preexp" VARCHAR,
"nhf_preexp" VARCHAR,
"date" TIMESTAMP,
"time_aphid" VARCHAR,
"timein" VARCHAR,
"timeout" VARCHAR,
"naphids" BIGINT,
"nappr" BIGINT,
"nstung" BIGINT,
"nhf" BIGINT,
"flit" VARCHAR,
"obs_time" VARCHAR,
"leave_time" VARCHAR,
"naphids_diss" VARCHAR,
"neggs_aphids" VARCHAR,
"neggs_wasp" VARCHAR,
"novarioles" VARCHAR,
"naphids_rear" VARCHAR,
"nmum" VARCHAR,
"nemer" VARCHAR,
"nadults" VARCHAR,
"nmales" VARCHAR,
"nfemales" VARCHAR
);CREATE TABLE aphelinus_coreae_with_aphis_species (
"species" VARCHAR,
"country" VARCHAR,
"city" VARCHAR,
"year" BIGINT,
"orighost" VARCHAR,
"sourceid" VARCHAR,
"subculture" BIGINT,
"block" BIGINT,
"location" BIGINT,
"exphost" VARCHAR,
"datein" TIMESTAMP,
"timein" VARCHAR,
"dateout" TIMESTAMP,
"timeout" VARCHAR,
"waspfate" VARCHAR,
"plantfate" VARCHAR,
"nmum" BIGINT,
"nemer" BIGINT,
"nadults" BIGINT,
"nmales" VARCHAR,
"nfemales" VARCHAR
);CREATE TABLE aphelinus_glycinis_behavior_detailed (
"species" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"order" BIGINT,
"exphost" VARCHAR,
"datexp" TIMESTAMP,
"aphidid" BIGINT,
"location" VARCHAR,
"approaches" VARCHAR,
"stings" VARCHAR,
"misses" VARCHAR,
"leg" VARCHAR,
"longstingord" VARCHAR,
"sapprmin" VARCHAR,
"spprsec" VARCHAR,
"eapprmin" VARCHAR,
"eapprsec" VARCHAR,
"sstingmin" VARCHAR,
"sstingsec" VARCHAR,
"estingmin" VARCHAR,
"estingsec" VARCHAR,
"shfmin" VARCHAR,
"shfsec" VARCHAR,
"ehfmin" VARCHAR,
"ehfsec" VARCHAR,
"hf" VARCHAR,
"jump" VARCHAR,
"visits" VARCHAR,
"disturb" VARCHAR,
"up" VARCHAR,
"wave" VARCHAR,
"buck" VARCHAR,
"kick" VARCHAR,
"rotate" VARCHAR,
"walk" VARCHAR,
"corn" VARCHAR,
"drop" VARCHAR,
"twitch" VARCHAR,
"notwalk" VARCHAR,
"fall" VARCHAR
);CREATE TABLE aphelinus_glycinis_behavior_summary (
"species" VARCHAR,
"country" VARCHAR,
"city" VARCHAR,
"year" BIGINT,
"orghost" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"location" BIGINT,
"exphost" VARCHAR,
"aphid_treat" VARCHAR,
"age" VARCHAR,
"time_preexp" VARCHAR,
"nhf_preexp" VARCHAR,
"date" TIMESTAMP,
"time_aphid" VARCHAR,
"timein" VARCHAR,
"timeout" VARCHAR,
"naphids" BIGINT,
"nappr" BIGINT,
"nstung" BIGINT,
"nhf" BIGINT,
"flit" VARCHAR,
"obs_time" BIGINT,
"leave_time" BIGINT,
"naphids_diss" VARCHAR,
"neggs_aphids" VARCHAR,
"neggs_wasp" VARCHAR,
"novarioles" VARCHAR,
"naphids_rear" VARCHAR,
"nmum" VARCHAR,
"naphids_surv" VARCHAR,
"nemer" VARCHAR,
"nadults" VARCHAR,
"nmales" VARCHAR,
"nfemales" VARCHAR
);CREATE TABLE aphelinus_glycinis_with_aphis_species (
"species" VARCHAR,
"country" VARCHAR,
"city" VARCHAR,
"year" BIGINT,
"orighost" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"location" BIGINT,
"exphost" VARCHAR,
"datein" TIMESTAMP,
"timein" VARCHAR,
"dateout" TIMESTAMP,
"timeout" VARCHAR,
"waspfate" VARCHAR,
"plantfate" VARCHAR,
"nmum" VARCHAR,
"nemer" VARCHAR,
"nadults" VARCHAR,
"nmales" VARCHAR,
"nfemales" VARCHAR
);CREATE TABLE aphelinus_rhamni_behavior_detailed (
"species" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"order" BIGINT,
"exphost" VARCHAR,
"datexp" TIMESTAMP,
"aphidid" BIGINT,
"location" VARCHAR,
"approaches" BIGINT,
"stings" BIGINT,
"misses" BIGINT,
"leg" BIGINT,
"longstingord" VARCHAR,
"sapprmin" VARCHAR,
"spprsec" VARCHAR,
"eapprmin" VARCHAR,
"eapprsec" VARCHAR,
"sstingmin" VARCHAR,
"sstingsec" VARCHAR,
"estingmin" VARCHAR,
"estingsec" VARCHAR,
"shfmin" VARCHAR,
"shfsec" VARCHAR,
"ehfmin" VARCHAR,
"ehfsec" VARCHAR,
"hf" BIGINT,
"jump" BIGINT,
"visits" BIGINT,
"disturb" VARCHAR,
"up" VARCHAR,
"wave" VARCHAR,
"buck" VARCHAR,
"kick" VARCHAR,
"rotate" VARCHAR,
"walk" VARCHAR,
"corn" VARCHAR,
"drop" VARCHAR,
"twitch" VARCHAR
);CREATE TABLE aphelinus_rhamni_behavior_summary (
"species" VARCHAR,
"country" VARCHAR,
"city" VARCHAR,
"year" BIGINT,
"orghost" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"location" BIGINT,
"exphost" VARCHAR,
"aphid_treat" VARCHAR,
"age" VARCHAR,
"time_preexp" VARCHAR,
"nhf_preexp" VARCHAR,
"date" TIMESTAMP,
"time_aphid" VARCHAR,
"timein" VARCHAR,
"timeout" VARCHAR,
"naphids" BIGINT,
"nappr" BIGINT,
"nstung" BIGINT,
"nhf" BIGINT,
"flit" VARCHAR,
"obs_time" VARCHAR,
"leave_time" VARCHAR,
"naphids_diss" VARCHAR,
"neggs_aphids" VARCHAR,
"neggs_wasp" VARCHAR,
"naphids_rear" VARCHAR,
"nmum" VARCHAR,
"naphids_surv" VARCHAR,
"nemer" VARCHAR,
"nadults" VARCHAR,
"nmales" VARCHAR,
"nfemales" VARCHAR
);CREATE TABLE aphelinus_rhamni_with_aphis_species (
"species" VARCHAR,
"country" VARCHAR,
"city" VARCHAR,
"year" BIGINT,
"orghost" VARCHAR,
"sourceid" VARCHAR,
"block" BIGINT,
"location" BIGINT,
"exphost" VARCHAR,
"datein" TIMESTAMP,
"timein" VARCHAR,
"dateout" TIMESTAMP,
"timeout" VARCHAR,
"waspfate" VARCHAR,
"plantfate" VARCHAR,
"nmum" BIGINT,
"nemer" BIGINT,
"nadults" BIGINT,
"nmales" BIGINT,
"malewt" VARCHAR,
"nfemales" BIGINT,
"femalewt" VARCHAR
);CREATE TABLE aphelinus_soybean_aphid_culture_data (
"genus" VARCHAR,
"complex" VARCHAR,
"species" VARCHAR,
"year" BIGINT,
"country" VARCHAR,
"region" VARCHAR,
"locations" VARCHAR,
"host_plant_species" VARCHAR,
"founding_number" BIGINT,
"collector" VARCHAR,
"permit_number" VARCHAR,
"voucher_id" VARCHAR
);CREATE TABLE aphelinus_soybean_aphid_host_use (
"species" VARCHAR,
"country" VARCHAR,
"population" VARCHAR,
"year" BIGINT,
"sourceid" VARCHAR,
"orghost" VARCHAR,
"exphost" VARCHAR,
"block" BIGINT,
"location" BIGINT,
"datein" TIMESTAMP,
"timein" VARCHAR,
"dateout" VARCHAR,
"timeout" VARCHAR,
"waspfate" VARCHAR,
"plantfate" VARCHAR,
"nmum" BIGINT,
"nemer" BIGINT,
"nadults" BIGINT,
"nmales" VARCHAR,
"nfemales" VARCHAR
);Anyone who has the link will be able to view this.