Package | Description |
---|---|
ambit2.db.chart |
Modifier and Type | Class and Description |
---|---|
class |
BarChartGenerator<T extends ISourceDataset> |
class |
BarChartGeneratorDataset |
class |
FingerprintHistogramDataset |
class |
FuncGroupsChartGenerator
chart number of chemicals with functional groups
|
class |
HistogramChartGenerator |
class |
Nominal2SimilarityChartGenerator
Interval chart - range of similarity per nominal property (e.g.
|
class |
Numeric2SimilarityChartGenerator |
class |
PieChartGenerator<T extends ISourceDataset>
Generates pie chart with number of chemicals per group
|
class |
PropertiesChartGenerator |
class |
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.