Data From: Host Specificity Of Aphelinus Species Collected From Soybean Aphid In Asia by US Government | Demographics and Population Studies

About this Dataset

Data From: Host Specificity Of Aphelinus Species Collected From Soybean Aphid In Asia

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:

Resource Title: Data dictionary for data from: Host specificity of Aphelinus species collected from soybean aphid in Asia.

File Name: data_dictionary_host_specificity_of_Aphelinus.csv

Resource Title: Collection information for Aphelinus species from soybean aphid for: Host specificity of Aphelinus species collected from soybean aphid in Asia.

File Name: Aphelinus_soybean_aphid_culture_data.csv

Resource Title: Parasitism of aphid species by Aphelinus species collected from soybean aphid.

File Name: Aphelinus_soybean_aphid_host_use.csv

Resource Title: Parasitism of Aphis species by Aphelinus coreae.

File Name: Aphelinus_coreae_with_Aphis_species.csv

Resource Title: Parasitism of Aphis species by Aphelinus glycinis.

File Name: Aphelinus_glycinis_with_Aphis_species.csv

Resource Title: Parasitism of Aphis species by Aphelinus rhamni.

File Name: Aphelinus_rhamni_with_Aphis_species.csv

Resource Title: Summary behavior of Aphelinus coreae exposed to various aphid species.

File Name: Aphelinus_coreae_behavior_summary.csv

Resource Title: Detailed behavior of female Aphelinus coreae and various aphid species.

File Name: Aphelinus_coreae_behavior_detailed.csv

Resource Title: Summary behavior of female Aphelinus glycinis exposed to various aphid species.

File Name: Aphelinus_glycinis_behavior_summary.csv

Resource Title: Detailed behavior of female Aphelinus glycinis and various aphid species.

File Name: Aphelinus_glycinis_behavior_detailed.csv

Resource Title: Summary behavior of female Aphelinus rhamni exposed to various aphid species.

File Name: Aphelinus_rhamni_behavior_summary.csv

Resource Title: Detailed behavior of female Aphelinus rhamni and aphid species.

File Name: Aphelinus_rhamni_behavior_detailed.csv

Resource Title: README file list for Data from: Host specificity of Aphelinus species collected from soybean aphid in Asia.

File Name: file_list_HostSpecificityAphelinusAsia.txt
Organization: Department of Agriculture
Last updated: 2024-03-30T11:18:41.196451
Tags: aphelinus-asychis-complex, aphelinus-coreae, aphelinus-glycinis, aphelinus-mali-complex, aphelinus-rhamni, aphelinus-varipes-complex, ars, biological-control, data-gov, np304, soybean-aphid

Tables

Data Dictionary Host Specificity Of Aphelinus 0

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.data_dictionary_host_specificity_of_aphelinus_0

9.67 KB
316 rows
8 columns


CREATE TABLE data_dictionary_host_specificity_of_aphelinus_0 (
  "csv_data_file" VARCHAR,
  "element_or_value_display_name" VARCHAR,
  "description_concentration_units" VARCHAR,
  "data_type" VARCHAR,
  "character_length" DOUBLE,
  "acceptable_values" VARCHAR,
  "required" VARCHAR,
  "accepts_null_value" VARCHAR
);

Aphelinus Soybean Aphid Culture Data

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_soybean_aphid_culture_data

9.02 KB
13 rows
12 columns


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
);

Aphelinus Soybean Aphid Host Use

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_soybean_aphid_host_use

33.81 KB
1866 rows
20 columns


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
);

Aphelinus Coreae With Aphis Species

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_coreae_with_aphis_species

15.71 KB
120 rows
21 columns


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
);

Aphelinus Glycinis With Aphis Species

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_glycinis_with_aphis_species

14.58 KB
120 rows
20 columns


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
);

Aphelinus Rhamni With Aphis Species

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_rhamni_with_aphis_species

15.94 KB
92 rows
22 columns


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
);

Aphelinus Coreae Behavior Summary

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_coreae_behavior_summary

26.96 KB
206 rows
34 columns


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
);

Aphelinus Coreae Behavior Detailed

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_coreae_behavior_detailed

45.77 KB
1306 rows
40 columns


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
);

Aphelinus Glycinis Behavior Summary

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_glycinis_behavior_summary

27.59 KB
234 rows
35 columns


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
);

Aphelinus Glycinis Behavior Detailed

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_glycinis_behavior_detailed

50.52 KB
1869 rows
40 columns


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
);

Aphelinus Rhamni Behavior Summary

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_rhamni_behavior_summary

27.03 KB
223 rows
34 columns


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
);

Aphelinus Rhamni Behavior Detailed

@usgov.usda_gov_data_from_host_specificity_of_aphelinus_speci_b4f6e1ce.aphelinus_rhamni_behavior_detailed

49.55 KB
1825 rows
38 columns


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
);