Related Experiment Video
Updated: Jun 23, 2026

10:56
A User-friendly and Powerful R Analysis of Large-scale Datasets
Published on: November 4, 2025
SDRF2GRAPH: a visualization tool of a spreadsheet-based description of experimental processes.
Hideya Kawaji1, Yoshihide Hayashizaki, Carsten O Daub
1RIKEN Omics Science Center, RIKEN Yokohama Institute, Yokohama, Kanagawa, Japan. kawaji@gsc.riken.jp
BMC Bioinformatics
|May 9, 2009
Summary
A new tool, SDRF2GRAPH, visualizes experimental steps from Sample and Data Relationship Format (SDRF) files as investigation design graphs. This aids in understanding complex experimental workflows and encourages SDRF file creation.
Area of Science:
- Genomics
- Bioinformatics
- Data Management
Background:
- Genome-scale experimental techniques generate large datasets requiring explicit metadata description.
- Sample and Data Relationship Format (SDRF) describes experimental processes but can become complex with numerous steps.
- Existing SDRF formats, while structured, can be challenging to interpret for intricate experiments.
Purpose of the Study:
- To introduce SDRF2GRAPH, a novel tool for visualizing experimental workflows.
- To simplify the understanding of complex experimental designs described in SDRF files.
- To facilitate the creation and validation of SDRF files through visual feedback.
Main Methods:
- Developed SDRF2GRAPH, a tool that generates directed acyclic graphs (DAGs) from SDRF files.
- Implemented a web-based interface accepting spreadsheet inputs (e.g., Microsoft Excel) directly.
- Enabled visualization of experimental steps as an Investigation Design Graph (IDG).
Main Results:
- SDRF2GRAPH successfully displays experimental steps from SDRF files as intuitive investigation design graphs.
- The tool accepts direct spreadsheet input, eliminating the need for text conversion.
- Visualization of the IDG structure simplifies comprehension of complex experimental processes.
Conclusions:
- SDRF2GRAPH is versatile, supporting various genome-scale technologies beyond microarrays, including next-generation sequencing.
- The visual representation of experimental workflows enhances understanding and promotes accurate SDRF file generation.
- This tool improves the usability and interpretability of metadata for large-scale biological data.
Related Concept Videos
The R Chart
In statistical process control, control charts, particularly R charts, are instrumental in monitoring process variations and identifying non-random patterns that run charts might miss. R charts track the variability within process subgroups, which is crucial when standard deviation use is impractical or unknown process variations exist.
R charts are pivotal for pinpointing shifts in process variability. Stability is indicated when all data points remain within the defined upper and lower...
R charts are pivotal for pinpointing shifts in process variability. Stability is indicated when all data points remain within the defined upper and lower...
Time-Series Graph
A time-series graph is a line graph with repeated measurements taken at successive intervals of time. It is also called a time series chart. To construct a time-series graph, one must look at both pieces of a paired data set. The horizontal axis is used to plot the time increments, and the vertical axis is used to plot the values of the variable that one is measuring. By using the axes in this way, each point on the graph will correspond to time and a measured quantity. The points on the graph...
Microsoft Excel: Plotting Mean, SD, and SE
In Microsoft Excel, plotting the mean along with standard deviation (SD) and standard error (SE) helps visualize data variability and reliability. To plot these values, follow these steps:
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...
Introduction to R
R is a powerful software environment for statistical computing and graphics. Originating as an implementation of the S language, developed at Bell Laboratories, R has evolved into a robust, open-source statistical software favored by statisticians and data scientists worldwide. Its comprehensive suite includes data manipulation, calculation, and graphical display capabilities, making it versatile for data analysis and visualization. Its programming language is at the core of R's functionality,...
Interpreting R Charts
R chart, or range chart, is a fundamental tool in statistical process control used to monitor the variability within a process. It complements the X-bar (x̄) chart by focusing on the range of the data, rather than individual values, providing a clear picture of the process dispersion over time.
An R chart plots the range of subsets of measurements collected from a process. Each point on the chart represents the range—defined as the difference between the maximum and minimum values—of a sample...
An R chart plots the range of subsets of measurements collected from a process. Each point on the chart represents the range—defined as the difference between the maximum and minimum values—of a sample...
Review and Preview
Data are individual items of information obtained from a population or sample. Data may be classified as qualitative (categorical), quantitative continuous, or quantitative discrete. Because it is not practical to measure the entire population in a study, researchers use samples to represent the population. A random sample is a representative group from the population chosen by using a method that gives each individual in the population an equal chance of being included in the sample. Random...

