| Class | Description |
|---|---|
| BarChartGenerator<T extends ISourceDataset> | |
| BarChartGeneratorDataset | |
| ChartGenerator<T> | |
| FingerprintHistogramDataset | |
| FuncGroupsChartGenerator |
chart number of chemicals with functional groups
|
| HistogramChartGenerator | |
| Nominal2SimilarityChartGenerator |
Interval chart - range of similarity per nominal property (e.g.
|
| Numeric2SimilarityChartGenerator | |
| PieChartGenerator<T extends ISourceDataset> |
Generates pie chart with number of chemicals per group
|
| PropertiesChartGenerator | |
| XTabChartGenerator |
select group_concat(distinct b),a-mod(a,10), count(*)
from (
select a,b from
(
select value_num as a,idchemical from query_results
join property_values using(idstructure) join properties using(idproperty)
where name = "LLNA EC3 %" and idquery=2
group by idchemical,value_num
) as X
join
(
select value as b,idchemical from query_results
join property_values using(idstructure) join property_string using(idvalue_string) join properties using(idproperty)
where name = "Michael Acceptors" and idquery=2
group by idchemical,value_num
) as Y
using(idchemical)
) as p
group by b,a-mod(a,10)
|
Copyright © 2004–2020 Ideaconsult Ltd.. All rights reserved.