Table T15. MAD query with output raw data option.
Item name
Janus table
Janus column name
Leg SECTION Leg
Site SECTION Site
Hole SECTION Hole
Core SECTION Core
Coretype SECTION Core_type
Section SECTION Section_number
Top (cm) SAMPLE Top_interval x 100
Bottom (cm) SAMPLE Bottom_interval x100
Depth (mbsf) DEPTH_MAP, SAMPLE DEPTH_MAP.Map_interval_top + SAMPLE.Top_interval
Water content (bulk) (%) MAD_SAMPLE_DATA Calculated or Water_content_bulk
Water content (dry) (%) MAD_SAMPLE_DATA Calculated or Water_content_dry
Bulk density (g/cm3) MAD_SAMPLE_DATA Calculated or Bulk_density
Dry density (g/cm3) MAD_SAMPLE_DATA Calculated or Dry_density
Grain density (g/cm3) MAD_SAMPLE_DATA Calculated or Grain_density
Porosity (%) MAD_SAMPLE_DATA Calculated or Porosity
Void ratio MAD_SAMPLE_DATA Calculated or Void_ratio
Mass (bulk + beaker) (g) MAD_SAMPLE_DATA Mass_wet_and_beaker
Mass (dry + beaker) (g) MAD_SAMPLE_DATA Mass_dry_and_beaker
Volume (bulk + beaker) (cm3) MAD_SAMPLE_DATA Vol_wet_and_beaker
Stdev (Volume [bulk + beaker]) MAD_SAMPLE_DATA Vol_wet_and_beaker_stdev
Number of measurements(Volume [bulk + beaker]) MAD_SAMPLE_DATA Vol_wet_and_beaker_n
Cell (Volume [bulk + beaker]) MAD_SAMPLE_DATA Vol_wet_and_beaker_cell
Volume (dry + beaker) (cm3) MAD_SAMPLE_DATA Vol_dry_and_beaker
Stdev (Volume [dry + beaker]) MAD_SAMPLE_DATA Vol_dry_and_beaker_stdev
Number of measurements(Volume [dry + beaker]) MAD_SAMPLE_DATA Vol_dry_and_beaker_n
Cell (Volume [dry + beaker]) MAD_SAMPLE_DATA Vol_dry_and_beaker_cell
Date/Time MAD_SAMPLE_DATA Sample_date_time
Beaker MAD_SAMPLE_DATA Mad_beaker_id
Mass beaker (g) MAD_BEAKER_HISTORY Beaker_mass
Volume beaker (cm3) MAD_BEAKER_HISTORY Beaker_volume
Mass wet (g) MAD_SAMPLE_DATA MAD_SAMPLE_DATA.Mass_wet_and_beaker – MAD_BEAKER_HISTORY.Beaker_mass
Mass dry (g) MAD_SAMPLE_DATA MAD_SAMPLE_DATA.Mass_dry_and_beaker – MAD_BEAKER_HISTORY.Beaker_mass
Mass of pore water (g) MAD_SAMPLE_DATA Calculated
Mass of solids (salt corrected) (g) MAD_SAMPLE_DATA Calculated
Volume of pore water (cm3) MAD_SAMPLE_DATA Calculated
Mass of evaporated salt (g) MAD_SAMPLE_DATA Calculated
Volume of evaporated salt (cm3) MAD_SAMPLE_DATA Calculated
Volume bulk (cm3) MAD_SAMPLE_DATA MAD_SAMPLE_DATA.Vol_wet_and_beaker – MAD_BEAKER_HISTORY.Beaker_volume
Volume solids (cm3) MAD_SAMPLE_DATA Calculated
Volume dry (cm3) MAD_SAMPLE_DATA MAD_SAMPLE_DATA.Vol_dry_and_beaker – MAD_BEAKER_HISTORY.Beaker_volume
Method MAD_SAMPLE_DATA Method
Comments MAD_SAMPLE_DATA Comments