Reference
Data dictionary
Every field in the FoodProt AI export, listed in the order it is written.
What this page lists
The table lists every field of the export. It is produced from the same list the export itself uses, so the two always match.
There are 52 measurement fields and 31 provenance fields, 83 in total, written in this order.
How to read a row
The field key is the short internal name of the field. The export header is the exact column heading written into the workbook; its spacing and punctuation are kept as they are, because existing sheets elsewhere depend on them.
The target unit is what standardisation converts into for that field. A field with no target unit is a name, an identifier, a count, or a quantity without a unit such as cohesiveness.
The group says whether the field describes the experiment (measurement) or lets a reader check the value (provenance).
The fields
Measurement fields come first, then provenance fields.
FoodProt AI export fields, in the order they are written
protein
- Export header
- Protein
- Type
- text
- Target unit
- —
- Group
- Measurement
protein_concentration_pct
- Export header
- Protein Concentration (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
treatment_1
- Export header
- Treatment (1)
- Type
- text
- Target unit
- —
- Group
- Measurement
treatment_1_unit
- Export header
- Treatment unit (1)
- Type
- text
- Target unit
- —
- Group
- Measurement
treatment_1_value
- Export header
- Treatment value (1)
- Type
- number
- Target unit
- —
- Group
- Measurement
treatment_1_temp_c
- Export header
- Treatment (1) tem. ( °C)
- Type
- number
- Target unit
- °C
- Group
- Measurement
treatment_1_time_min
- Export header
- Treatment (1) time (min)
- Type
- number
- Target unit
- min
- Group
- Measurement
treatment_2
- Export header
- Treatment (2)
- Type
- text
- Target unit
- —
- Group
- Measurement
treatment_2_unit
- Export header
- Treatment unit (2)
- Type
- text
- Target unit
- —
- Group
- Measurement
treatment_2_value
- Export header
- Treatment value (2)
- Type
- number
- Target unit
- —
- Group
- Measurement
treatment_2_temp_c
- Export header
- Treatment (2) tem. ( °C)
- Type
- number
- Target unit
- °C
- Group
- Measurement
treatment_2_time_min
- Export header
- Treatment (2) time (min)
- Type
- number
- Target unit
- min
- Group
- Measurement
additive_1
- Export header
- Additives (1)
- Type
- text
- Target unit
- —
- Group
- Measurement
additive_1_conc_pct
- Export header
- Additives (1) Concentration (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
additive_2
- Export header
- Additives (2)
- Type
- text
- Target unit
- —
- Group
- Measurement
additive_2_conc_pct
- Export header
- Additives (2) Con. (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
additive_3
- Export header
- Additives (3)
- Type
- text
- Target unit
- —
- Group
- Measurement
additive_3_conc_pct
- Export header
- Additives (3) Con. (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
additive_4
- Export header
- Additives (4)
- Type
- text
- Target unit
- —
- Group
- Measurement
additive_4_conc_pct
- Export header
- Additives (4) Con. (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
ph
- Export header
- pH
- Type
- number
- Target unit
- —
- Group
- Measurement
salt_type
- Export header
- Type of salt
- Type
- text
- Target unit
- —
- Group
- Measurement
ionic_strength_m
- Export header
- ionic strength (M)
- Type
- number
- Target unit
- M
- Group
- Measurement
heating_temp_c_gel_prep
- Export header
- Heating tem. (°C) for gel preparation
- Type
- number
- Target unit
- °C
- Group
- Measurement
heating_hold_time_min
- Export header
- Heating/hold time (min)
- Type
- number
- Target unit
- min
- Group
- Measurement
samples_stored_c
- Export header
- Samples stored (°C)
- Type
- number
- Target unit
- °C
- Group
- Measurement
storage_time_h
- Export header
- Storage time (h)
- Type
- number
- Target unit
- h
- Group
- Measurement
hardness_g
- Export header
- Hardness/firmness/ Gel strength/ (g)
- Type
- number
- Target unit
- g
- Group
- Measurement
cohesiveness
- Export header
- Cohesiveness
- Type
- number
- Target unit
- —
- Group
- Measurement
springiness_mm
- Export header
- Springiness (mm)
- Type
- number
- Target unit
- mm
- Group
- Measurement
gumminess_g
- Export header
- Gumminess (g)
- Type
- number
- Target unit
- g
- Group
- Measurement
chewiness_g
- Export header
- Chewiness (g)
- Type
- number
- Target unit
- g
- Group
- Measurement
adhesiveness_g_s
- Export header
- Adhesiveness (g.s)
- Type
- number
- Target unit
- g.s
- Group
- Measurement
resilience_pct
- Export header
- Resilience (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
fracturability_g
- Export header
- Fracturability (g)
- Type
- number
- Target unit
- g
- Group
- Measurement
water_holding_capacity_pct
- Export header
- Water holding capacity (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
oil_holding_capacity_pct
- Export header
- Oil holding capacity (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
solubility_pct
- Export header
- Solubility (%)
- Type
- number
- Target unit
- %
- Group
- Measurement
least_gelation_conc_pct_wv
- Export header
- Least gelation concentration (% w/v)
- Type
- number
- Target unit
- % w/v
- Group
- Measurement
denaturation_temperature
- Export header
- Denaturation temperature
- Type
- number
- Target unit
- °C
- Group
- Measurement
viscosity_mpa_s
- Export header
- Viscosity (mPa.s)
- Type
- number
- Target unit
- mPa.s
- Group
- Measurement
storage_modulus_g_prime_pa
- Export header
- Storage modulus, G′ (Pa)
- Type
- number
- Target unit
- Pa
- Group
- Measurement
freq_hz_g_prime
- Export header
- Frequency (Hz)_Storage modulus, G′ (Pa)
- Type
- number
- Target unit
- Hz
- Group
- Measurement
temp_c_g_prime
- Export header
- Tem. (°C)_Storage modulus, G′ (Pa)
- Type
- number
- Target unit
- °C
- Group
- Measurement
time_min_g_prime
- Export header
- Time(°min)_Storage modulus, G′ (Pa)
- Type
- number
- Target unit
- min
- Group
- Measurement
loss_modulus_g_double_prime_pa
- Export header
- Loss modulus, G″(Pa)
- Type
- number
- Target unit
- Pa
- Group
- Measurement
freq_hz_g_double_prime
- Export header
- Frequency (Hz)_Loss modulus, G″(Pa)
- Type
- number
- Target unit
- Hz
- Group
- Measurement
temp_c_g_double_prime
- Export header
- Tem. (°C)_Loss modulus, G′' (Pa)
- Type
- number
- Target unit
- °C
- Group
- Measurement
time_min_g_double_prime
- Export header
- Time (min)_Loss modulus, G′' (Pa)
- Type
- number
- Target unit
- min
- Group
- Measurement
loss_tangent_tan_delta
- Export header
- Loss tangent (tan δ)
- Type
- number
- Target unit
- —
- Group
- Measurement
time_min_tan_delta
- Export header
- Time(min)_Loss tangent (tan δ)
- Type
- number
- Target unit
- min
- Group
- Measurement
citation_link
- Export header
- Citation Link
- Type
- text
- Target unit
- —
- Group
- Measurement
study_config_id
- Export header
- Study configuration ID
- Type
- text
- Target unit
- —
- Group
- Provenance
project_id
- Export header
- Project ID
- Type
- text
- Target unit
- —
- Group
- Provenance
article_title
- Export header
- Article title
- Type
- text
- Target unit
- —
- Group
- Provenance
authors
- Export header
- Authors
- Type
- text
- Target unit
- —
- Group
- Provenance
year
- Export header
- Year
- Type
- number
- Target unit
- —
- Group
- Provenance
journal
- Export header
- Journal
- Type
- text
- Target unit
- —
- Group
- Provenance
doi
- Export header
- DOI
- Type
- text
- Target unit
- —
- Group
- Provenance
pmid
- Export header
- PMID
- Type
- text
- Target unit
- —
- Group
- Provenance
pmcid
- Export header
- PMCID
- Type
- text
- Target unit
- —
- Group
- Provenance
database_source
- Export header
- Database source
- Type
- text
- Target unit
- —
- Group
- Provenance
search_query_used
- Export header
- Search query used
- Type
- text
- Target unit
- —
- Group
- Provenance
screening_decision_text
- Export header
- Screening decision
- Type
- text
- Target unit
- —
- Group
- Provenance
extraction_readiness_score
- Export header
- Extraction-readiness score
- Type
- number
- Target unit
- —
- Group
- Provenance
fulltext_status_text
- Export header
- Full-text status
- Type
- text
- Target unit
- —
- Group
- Provenance
inclusion_exclusion_reason
- Export header
- Inclusion/exclusion reason
- Type
- text
- Target unit
- —
- Group
- Provenance
data_source_type
- Export header
- Data source type
- Type
- text
- Target unit
- —
- Group
- Provenance
page_number
- Export header
- Page number
- Type
- number
- Target unit
- —
- Group
- Provenance
table_number
- Export header
- Table number
- Type
- text
- Target unit
- —
- Group
- Provenance
figure_number
- Export header
- Figure number
- Type
- text
- Target unit
- —
- Group
- Provenance
figure_panel
- Export header
- Figure panel
- Type
- text
- Target unit
- —
- Group
- Provenance
original_value
- Export header
- Original value
- Type
- text
- Target unit
- —
- Group
- Provenance
original_unit
- Export header
- Original unit
- Type
- text
- Target unit
- —
- Group
- Provenance
standardized_value
- Export header
- Standardized value
- Type
- number
- Target unit
- —
- Group
- Provenance
standardized_unit
- Export header
- Standardized unit
- Type
- text
- Target unit
- —
- Group
- Provenance
conversion_formula
- Export header
- Conversion formula
- Type
- text
- Target unit
- —
- Group
- Provenance
source_evidence
- Export header
- Source evidence
- Type
- text
- Target unit
- —
- Group
- Provenance
extraction_confidence
- Export header
- Extraction confidence
- Type
- number
- Target unit
- —
- Group
- Provenance
human_verification_status
- Export header
- Human verification status
- Type
- text
- Target unit
- —
- Group
- Provenance
reviewer
- Export header
- Reviewer
- Type
- text
- Target unit
- —
- Group
- Provenance
review_date
- Export header
- Review date
- Type
- date
- Target unit
- —
- Group
- Provenance
notes
- Export header
- Notes
- Type
- text
- Target unit
- —
- Group
- Provenance
What the dictionary does not tell you
It does not say which fields your project collects. That is set in the study configuration, and a project that never measured viscosity has the column with no values in it.
It does not say which fields must be checked by a person before approval. That is also set for each project, except for values read from figures, which always are.
Related
Exports and the audit trail
What the FoodProt AI export contains, who can export, and what the provenance columns let a reader check.
Units and standardisation
How units are standardised: the reported value is kept beside the converted one, and unsafe conversions are refused.
The verified dataset
What a verified value is, how the dataset is organised, and how to filter it.
Importing spreadsheets and existing data
Bringing in legacy FoodProt sheets and hand-collected data, with every column confirmed by you.