Time series plot with percentage of samples above threshold¶

A time series plot representing percentage of numerical data in y_value column of the SQLite table defined by table_name above the user defined threshold. SQLite table must have; Run, Sample, Date, y_value columns to generate the plot.

Example Plot¶

../_images/timeseries_percentage_samples_abv_threshold.png

Chart Properties¶

Option	Type	Use
Chart_title	String (Optional)	This is used to create the title of the chart. Default is “% Samples per run with {y_label} ≥ {threshold}”. E.g. “% Samples per run with Qualimap Median Coverage ≥ 100”.
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 “% Samples per run with {y_value} ≥ {threshold}”. E.g. “Qualimap Median Coverage ≥ 100”.
threshold	Integer (Required)	This is used to compute % of values above the threshold. E.g. 100.

Example JSON entry (minimum):

[
 {
  "chart_type": "time_series_with_percentage_of_samples_above_threshold",
  "chart_properties": {
       "y_value": "QualiMap_median_coverage",
       "threshold": 100
       }
 }
]

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

[
 {
  "table_name": "Production_Run_Stats_Summary",
  "include_samples": "all",
  "exclude_samples": "HCT15, NTC",
  "chart_type": "time_series_with_percentage_of_samples_above_threshold",
  "chart_properties": {
       "chart_title": "% Samples per run with Qualimap Median Coverage &ge; 100",
       "y_value": "Depth",
       "threshold": 100,
       "y_label": "Qualimap Median Coverage &ge; 100"
       }
 }
]