Data From: Hairy Vetch (Vicia Villosa Roth) Germplasm Contains A Cryptic Second Species (Vicia Varia Host)
Department of Agriculture
@usgov.usda_gov_data_from_hairy_vetch_vicia_villosa_roth_germ_c430a8fb
Department of Agriculture
@usgov.usda_gov_data_from_hairy_vetch_vicia_villosa_roth_germ_c430a8fb
CREATE TABLE viciassr_ldamodel (
"locationcode" VARCHAR,
"range" VARCHAR,
"row" VARCHAR,
"plant" VARCHAR,
"plant_sample_id" VARCHAR,
"dna_sample_code" VARCHAR,
"hv1_a05_1" VARCHAR,
"hv1_a05_2" VARCHAR,
"hv1_a05_3" VARCHAR,
"hv1_f03_1" VARCHAR,
"hv1_f03_2" VARCHAR,
"hv2_d07_1" VARCHAR,
"hv2_d07_2" VARCHAR,
"hv2_d07_3" VARCHAR,
"hv2_d07_4" VARCHAR,
"blue_red_special_1" VARCHAR,
"blue_red_special_2" VARCHAR,
"hv2_c03_1" VARCHAR,
"hv2_c03_2" VARCHAR,
"hv2_c03_3" VARCHAR,
"hv2_b10_1" VARCHAR,
"hv2_b10_2" VARCHAR,
"hv2_b10_3" VARCHAR,
"hv1_g02_1" VARCHAR,
"hv1_g02_2" VARCHAR,
"hv1_g02_3" VARCHAR,
"hv1_a11_1" VARCHAR,
"hv1_a11_2" VARCHAR,
"hv2_d01_1" VARCHAR,
"hv2_d01_2" VARCHAR,
"hv2_d03_1" VARCHAR,
"hv2_d03_2" VARCHAR,
"hv1_b04_1" VARCHAR,
"hv1_b04_2" VARCHAR,
"hv1_a03_1" VARCHAR,
"hv1_a03_2" VARCHAR,
"hv1_a03_3" VARCHAR,
"hv2_g01_1" VARCHAR,
"hv2_g01_2" VARCHAR,
"hv1_f01_1" VARCHAR,
"hv1_f01_2" VARCHAR,
"hv1_f01_3" VARCHAR,
"hv1_g05_1" VARCHAR,
"hv1_g05_2" VARCHAR,
"hv1_g05_3" VARCHAR,
"hv1_f05_1" VARCHAR,
"hv1_f05_2" VARCHAR,
"hv1_f05_3" VARCHAR,
"hv1_h03_1" VARCHAR,
"hv1_h03_2" VARCHAR,
"red_294_1" VARCHAR,
"red_294_2" VARCHAR,
"pc_1" VARCHAR,
"pc_2" VARCHAR,
"asl450_1_1" VARCHAR,
"asl450_1_2" VARCHAR,
"asl450_1_3" VARCHAR,
"bsr450_2_1" VARCHAR,
"bsr450_2_2" VARCHAR,
"bsr450_2_3" VARCHAR,
"csr450_0_1" VARCHAR,
"csr450_0_2" VARCHAR,
"csr450_0_3" VARCHAR,
"blue_462" VARCHAR,
"green_432" VARCHAR,
"plantid" VARCHAR,
"knowngroupidentity" VARCHAR,
"lda_assignedgroup" VARCHAR,
"lda_value" VARCHAR
);
Anyone who has the link will be able to view this.