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.629736
Tags: acropyga, ars, coccoidea, coccomorpha, data-gov, morphometrics, mutualism, np304, root-mealybug

Tables

AnteriorOstiolesdata

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.anteriorostiolesdata

9.17 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  -- Unnamed: 6,
  "color_code" VARCHAR,
  "shape_code" BIGINT
);

Labels

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.labels

6.98 kB
167 rows
2 columns

CREATE TABLE labels (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "c_c_users_jsodan1_documents_mealybug_images_capitesell_baf3a592" VARCHAR  -- C..C...Users..Jsodan1..Documents..Mealybug.Images..Capitesella.migrans..Capitisella.migrans 1...
);

PosteriorOstiolesdata

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.posteriorostiolesdata

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

Shapelabels2 Noxeno

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.shapelabels2_noxeno

6.57 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

6.08 kB
103 rows
6 columns

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

Shapelabels All

@usgov.usda_gov_data_from_scale_insect_hemiptera_coccomorpha__64aac181.shapelabels_all

7.11 kB
167 rows
6 columns

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