consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
14 rows where inventory_id = 18702
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 59100 | 59100 | 18702 18702 | 33810 | 4 | 0.196951691427178 |
| 59101 | 59101 | 18702 18702 | 120043 | 3 | 0.179721324402336 |
| 59102 | 59102 | 18702 18702 | 137050 | 2 | 0.069274916460973 |
| 59103 | 59103 | 18702 18702 | 157221 | 4 | 0.183284201050509 |
| 59104 | 59104 | 18702 18702 | 204371 | 1 | 0.0648007507235868 |
| 59105 | 59105 | 18702 18702 | 227568 | 1 | 0.0216002502411956 |
| 59106 | 59106 | 18702 18702 | 227621 | 1 | 0.0259203002894347 |
| 59107 | 59107 | 18702 18702 | 240519 | 1 | 0.0288003336549275 |
| 59108 | 59108 | 18702 18702 | 243352 | 1 | 0.0518406005788695 |
| 59109 | 59109 | 18702 18702 | 259329 | 2 | 0.0529095914073585 |
| 59110 | 59110 | 18702 18702 | 274450 | 2 | 0.0529095914073585 |
| 59111 | 59111 | 18702 18702 | 289540 | 1 | 0.0235639093540316 |
| 59112 | 59112 | 18702 18702 | 320632 | 1 | 0.0199386925303344 |
| 59113 | 59113 | 18702 18702 | 329511 | 1 | 0.0185145002067391 |
CREATE TABLE [consensus_index] (
[inventory_id] integer,
[inchi_id] text,
[consensus_score] text,
[consensus_count] integer,
FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);