Time series Box-and-Whisker plot of the numerical data¶
A time series Box-and-Whisker plot of numerical data. Numerical data in y_value
column of the SQLite table defined by table_name
is used to plot this graph.
SQLite table must have; Sample, Date, y_value
columns to generate the plot.
If Run
column is present instead of Sample
column in the table, Run
column is used to generate plots.
Example Plot¶
Chart Properties¶
Option | Type | Use |
---|---|---|
Chart_title | String (Optional) | This is used to create the title of the chart. Default is “{y_label} Monthly Box-and-Whisker Plot”. E.g. “Bcftools Stats Number Of Snps Monthly Box-and-Whisker Plot”. |
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. “Number”. |
y_label | String (Optional) | This is used to create the y-axis label in the chart. Default is “{y_label}”. E.g. “Bcftools Stats Number Of Snps”. |
Type | String (Optional) | This is used to select subset of rows from the SQLite table’s “Type” columns. E.g. “SNPs”. |
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. |
Example JSON entry (minimum):
[
{
"chart_type": "time_series_with_box_whisker_plot",
"chart_properties": {
"y_value": "Bcftools_Stats_number_of_SNPs"
}
}
]
Example JSON entry (full) to plot all samples excluding HCT15 and NTC
[
{
"table_name": "SNPs_Indels_Stats_Summary",
"include_samples": "all",
"exclude_samples": "HCT15, NTC",
"chart_type": "time_series_with_box_whisker_plot",
"chart_properties": {
"chart_title": "Bcftools Stats Number Of Snps Monthly Box-and-Whisker Plot",
"y_value": "Number",
"Type": "SNPs",
"y_label": "Bcftools Stats Number Of Snps",
"lower_threshold": 10000,
"upper_threshold": 15000
}
}
]