Data From: Scale Insect (Hemiptera: Coccomorpha) Morphology Is Transformed Under Trophobiosis by US Government | Demographics and Population Studies

About this Dataset

Data From: Scale Insect (Hemiptera: Coccomorpha) Morphology Is Transformed Under Trophobiosis

Supplementary raw data, R scripts, and results underpinning analyses of geometric morphometric and linear data derived from scale insects; includes source code for all analyses, raw data for ostiole, leg, and body shape analyses, and alpha tables for body size analysis and ostioles analyses. Abbreviations are defined in the R script file. See README for list of resources.
Organization: Department of Agriculture
Last updated: 2024-03-30T11:24:15.629734
Tags: acropyga, ars, coccoidea, coccomorpha, data-gov, morphometrics, mutualism, np304, root-mealybug

Tables

Raw Data Linear Leg And Body Measurements

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.raw_data_linear_leg_and_body_measurements

27.02 KB
169 rows
18 columns


CREATE TABLE raw_data_linear_leg_and_body_measurements (
  "genus" VARCHAR,
  "species" VARCHAR,
  "association" VARCHAR,
  "trochanter_width_um" VARCHAR,
  "trochanter_length_um" VARCHAR,
  "femur_width_um" VARCHAR,
  "femur_length_um" VARCHAR,
  "tibia_width_um" VARCHAR,
  "tibia_length_um" VARCHAR,
  "tarsus_width_um" VARCHAR,
  "tarsus_length_um" VARCHAR,
  "tarsal_claw_width_um" VARCHAR,
  "tarsal_claw_length_um" VARCHAR,
  "overall_body_length_um" DOUBLE,
  "overall_body_width_um" DOUBLE,
  "body_ratio" DOUBLE,
  "shape_code" BIGINT,
  "color_code" VARCHAR
);

PosteriorOstiolesdata

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.posteriorostiolesdata

7.74 KB
76 rows
8 columns


CREATE TABLE posteriorostiolesdata (
  "genus" VARCHAR,
  "species" VARCHAR,
  "association" VARCHAR,
  "posterior_ostioles" VARCHAR,
  "post_ostiole_length" DOUBLE,
  "overall_body_length" DOUBLE,
  "color_code" VARCHAR,
  "shape_code" BIGINT
);

AnteriorOstiolesdata

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.anteriorostiolesdata

8.95 KB
76 rows
9 columns


CREATE TABLE anteriorostiolesdata (
  "genus" VARCHAR,
  "species" VARCHAR,
  "association" VARCHAR,
  "anterior_ostioles" VARCHAR,
  "ant_ostioles_length" DOUBLE,
  "overall_body_length" DOUBLE,
  "unnamed_6" DOUBLE,
  "color_code" VARCHAR,
  "shape_code" BIGINT
);

Shapelabels All

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.shapelabels_all

6.94 KB
167 rows
6 columns


CREATE TABLE shapelabels_all (
  "specid" BIGINT,
  "species" VARCHAR,
  "associated" VARCHAR,
  "color_code" VARCHAR,
  "genus" VARCHAR,
  "shape" BIGINT
);

Shapelabels2 Noxeno

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.shapelabels2_noxeno

6.42 KB
128 rows
6 columns


CREATE TABLE shapelabels2_noxeno (
  "specid" BIGINT,
  "species" VARCHAR,
  "associated" VARCHAR,
  "color_code" VARCHAR,
  "genus" VARCHAR,
  "shape" BIGINT
);

Shapelabels3 Rhizo

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.shapelabels3_rhizo

5.94 KB
103 rows
6 columns


CREATE TABLE shapelabels3_rhizo (
  "specid" BIGINT,
  "species" VARCHAR,
  "associated" VARCHAR,
  "color_code" VARCHAR,
  "genus" VARCHAR,
  "shape" BIGINT
);

Labels

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.labels

6.81 KB
167 rows
2 columns


CREATE TABLE labels (
  "unnamed_0" BIGINT,
  "c_c_users_jsodan1_documents_mealybug_images_capitesell_baf3a592" VARCHAR
);