Recipe-1: Making a Data Matrix FAIR

Recipe metadata

identifier: 10.5072/FK2862KX83

version: v0.1

Difficulty level

Reading Time

15 minutes

Recipe Type


Executable Code


Intended Audience

Data Managers

Data Scientists

<!-- ___

Table of Contents

  1. Summary
  2. Main Objectives
  3. Graphical Overview of the FAIRification Recipe Objectives
  4. Capability & Maturity Table
  5. FAIRification Objectives, Inputs and Outputs
  6. Table of Data Standards
  7. Table of Software and Tools
  8. Step by Step Process
  9. References
  10. Authors
  11. License -->


Our first data source: article by Raymond et al. Nat Genet. 50:772-777 (2018); this is targeted metabolite profiling study of strain-related chemical signatures of the rose fragrance; the biological materials was selected to allow a comparison between parts of the plant, and across cultivars in the same tissue type. Our starting point: their human-understandable data in the supplementary table, containing the mean concentrations of 61 metabolites measured in three different parts of the rose flower, in six distinct genotypes. Our second data source: article by Magnard et al. Science.Jul 3;349(6243):81-3 (2015); this is early work of the same group author of the first data source. Our approach: we performed a retrospective curation and re-annotation of the data matrices, disambiguating of the experimental design, using community, open interoperability standards from FAIRsharing (; we focused on the clarity of the statistical results to ensure reusability and reproducibility of the analytical workflow by humans and machines. The FAIRification steps for the first data source are documented in the sections below; the same steps were applied to the second data source to assess inter-experiment agreement, as both studies used the same varieties of rose and plant parts. Our results: semantically-anchored data matrices served as Linked Data, deposited in public archives (Zenodo and MetaboLights), and consumable by software agents for queries like “Retrieve study predictor variables and their levels” and “What is sample size used to compute the means?” to support study results review and assessment.

Main Objectives

The main purpose of this recipe is:

Making self describing tabular data using Frictionless tools instead of dumping Excel files.

  • ensure that results presented in MS Excel or PDF tables are made more open and unambiguous.
  • provide an RDF representation
  • enable reproduciblity of results
  • evaluate efficiency of the method via a data integrate challenge

Graphical Overview of the FAIRification Recipe Objectives

graph TD; A(Excel Document) -->B(Raw Data) B --> C{is wide table?} C -->|Yes| D(perform wide to long table conversion) C -->|No| E(proceed to semantic markup) A --> F{has PID?} F -->|Yes| G(perform a curl to test URI) F -->|No| H(upload to zenodo and obtain DOI)

Capability & Maturity Table

Capability Initial Maturity Level Final Maturity Level
Interoperability minimal repeatable

FAIRification Objectives, Inputs and Outputs

Actions.Objectives.Tasks Input Output
conversion Microsoft Excel file (.xlsx) Frictionless JSON Data Package
conversion Adobe PDF (.pdf) Frictionless JSON Data Package
format validation Frictionless JSON Data Package report
conversion Frictionless JSON Data Package RDF/linked data
text annotation Human Phenotype Ontology annotated text

Table of Data Standards

Data Formats Terminologies Models
Frictionless JSON Data Package CHEBI
Plant Ontology

Table of Software and Tools

Tool Name
zenodo API
cookie cutter for data science
jupyter notebook

Step by Step Process:

Step1: Address Data Findability and Accessibility:

We made the initial spreadsheet table discoverable and citable by:

Step2: Address Interoperability

We regularized the three dimensions of the matrix (data cube), which represent: i) the metabolites (molecular entities), ii) the treatments (experimental conditions and corresponding biomaterials and bioassays), and iii) the quantitation type (measurements).

Step 2A: semantic anchoring

Metabolites (free text) names were augmented with unambiguous InChI codes, assigned by accessing CHEBI ( programmatically via its LibChebi library (
We unpacked the information held in the column header, identifying the main types of tabulated entities and their relationships, and replacing free text with ontology term. For example, we disambiguated the taxonomic name of the cultivar from the anatomical part using terms and identifiers from the NCBI Taxonomy ( and Plant Ontology ( respectively.

Step 2B: disambiguation of the experimental design

We clarified the intent of the experimentalist, which is a comparison between two independent variables identified (the rose variety and the organism part), which are both categorical variables with six and three discrete factor levels, respectively. Since only eight factor combinations are reported, we concluded that this is a fractional factorial design (rather than a factorial design, where eighteen theoretical factor combinations are possible) We disambiguated among the attributes of the samples those that are study factors and their values, to explicitly enable queries on treatment groups and their sizes. We used the STATistics Ontology (STATO; to unambiguously express and semantically type these notions.

Step 2C: clarification of the measurement performed

We unpacked the type of measurement, and formally annotated them with the STATO classes; we also clarified the size of the sample over which the calculation was performed. Two measurements were identified for each of the experimental conditions, and for each treatment, a single biological material was prepared and assayed three times on the same analytical platform. We marked-up all entities with persistent resolvable identifiers to enhance dataset connectivity. Therefore, the computed sample mean can only be used to estimate the variability of the measurement technique, not the biological variability.

Step3: Preservation of the data matrices in an open syntax

We used the Frictionless Tabular Data Package ( to describe the table headers in JSON format. The transformation is documented in a jupyter notebook (

Step4: Address Reusability

We performed a conversion to Linked Data, using terms from OBO Foundry Ontologies ( As a result, the metabolite measurements can be plotted using popular visualization libraries (Python plotnine or R ggplot2) from either a SPARQL query over the RDF representation or from the data package directly.

Step5: address Findability and Accessibility

We made the FAIRified outputs discoverable and citable by uploading them to Zenodo, assigning an open license (CC-BY 4.0), and obtaining persistent unique identifiers:

To further demonstrate the value of such study design driven data representation, we applied a similar FAIRification process on the second data source. The results of this comparison, also released via Zenodo ( Lastly, we produced a study description file, in ISA-Tab format (, which references the Tabular Data Packages representing the results held in data matrices. The ISA file is suitable for deposition to MetaboLights, a public repository for metabolomics data recommended by several journals (


Rocca-Serra, P., Sansone, S. Experiment design driven FAIRification of omics data matrices, an exemplar. Sci Data 6, 271 (2019) doi:10.1038/s41597-019-0286-0


Name Affiliation orcid CrediT role
Philippe Rocca-Serra University of Oxford, Data Readiness Group 0000-0001-9853-5668 Writing - Original Draft
Susanna-Assunta Sansone University of Oxford, Data Readiness Group Writing - Review & Editing, Funding acquisition


This page is released under the Creative Commons 4.0 BY license.