Time series plot with absolute threshold

A time series plot of numerical data with user defined lower and upper thresholds. Numerical data in y_value column of the SQLite table defined by table_name is used to plot this graph. SQLite table must have; Run, Sample, Date, y_value columns to generate the plot. In case of per_sample graph Run column is not required. For per_sample graph if only Run column is present in the table, Run column is used to generate plots.

Example Plot

../_images/timeseries_absolute_threshold.png

Chart Properties

Option Type Use
Chart_title String (Optional) This is used to create the title of the chart. Default is “{y_label} (Mean per run)”. E.g. “Qualimap Median Coverage (Mean per run)”.
y_value String (Required) Column header in SQLite table. The column should contain numeric data. This data is plotted on the y-axis. E.g. “Depth”.
y_label String (Optional) This is used to create the y-axis label in the chart. Default is “{y_value} (Mean per run)”. E.g. “Qualimap Median Coverage (Mean per run)”.
lower_threshold Integer (Optional) This is used to create lower threshold line on the chart. E.g. 100.
upper_threshold Integer (Optional) This is used to create upper threshold line on the chart. E.g. 300.
per_sample Boolean (Optional) Plot per sample graph. Default is “False”. If set to “True” per sample graph will be plotted.

Example JSON entry (minimum):

[
 {
  "chart_type": "time_series_with_absolute_threshold",
  "chart_properties": {
      "y_value": "Depth",
      "lower_threshold": 100,
      }
 }
]

Example JSON entry (full) to plot all samples excluding HCT15 and NTC:

[
 {
  "table_name": "Production_Run_Stats_Summary",
  "include_samples": "all",
  "exclude_samples": "HCT15, NTC",
  "chart_type": "time_series_with_absolute_threshold",
  "chart_properties": {
      "chart_title": "Qualimap Median Coverage (Mean per run)",
      "y_value": "Depth",
      "lower_threshold": 100,
      "y_label": "Qualimap Median Coverage (Mean per run)",
      "per_sample": "True"
      }
 }
]