petermr / CEVOpen

Contentmining of Open phytochemical literature for medicinal activities
26 stars 19 forks source link

Create TYPES for activity tables #48

Open petermr opened 4 years ago

petermr commented 4 years ago

Activity tables have variable numbers of columns and may have parameters (e.g. concentrations). Ideally we should transform to denormalised (e.g tidytables) but that comes later.

Here we try to abstract the different types of tables.

Start by collecting into different activity types, one issue per type. We denote the types here in a single comment and the ne create an issue;

petermr commented 4 years ago

Antioxidant DPPH

Concentration μg/ml % inhibition by T. bovei essential oil ± SD % of inhibition by Trolox ± SD
1 38.65 ± 1.08 40.6 ± 0.91
2 47.55 ± 1.34 48.7 ± 1.32
3 52.09 ± 1.05 56.09 ± 0.83
5 64.19 ± 1.32 60.12 ± 1.98
7 64.19 ± 1.83 80.12 ± 1.06
10 69.38 ± 1.33 87.95 ± 1.66
20 76.29 ± 2.12 88.71 ± 1.47
30 81.23 ± 1.43 91.55 ± 2.71
40 92.1 ± 1.65 91.56 ± 1.93
50 95.95 ± 1.40 99.45 ± 2.79
80 97.82 ± 1.87 99.55 ± 1.87
100 98.12 ± 1.58 99.55 ± 2.64
petermr commented 4 years ago

antimicrobial (MIC)

Microorganism MIC value (mg/ml) for T. bovei essential oil
Escherichia coli (ATCC 25922) 0.5
Pseudomonas aeruginosa (ATCC 27853) 0.25
Staphylococcus aureus (ATCC 25923) 0.25
Staphylococcus aureus (MRSA Positive) 0.5
Candida albicans (Clinical isolate) 0.25