consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
5 rows where inventory_id = 398667
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1195420 | 1195420 | 398667 398667 | 2901 | 6 | 0.315789473684211 |
| 1195421 | 1195421 | 398667 398667 | 128446 | 2 | 0.315789473684211 |
| 1195422 | 1195422 | 398667 398667 | 129009 | 1 | 0.157894736842105 |
| 1195423 | 1195423 | 398667 398667 | 155174 | 1 | 0.105263157894737 |
| 1195424 | 1195424 | 398667 398667 | 195800 | 1 | 0.0789473684210526 |
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)
);