consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
6 rows where inventory_id = 52447
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 146619 | 146619 | 52447 52447 | 6863 | 6 | 0.394736842105263 |
| 146620 | 146620 | 52447 52447 | 136475 | 1 | 0.197368421052632 |
| 146621 | 146621 | 52447 52447 | 186520 | 1 | 0.0789473684210526 |
| 146622 | 146622 | 52447 52447 | 186912 | 1 | 0.0986842105263158 |
| 146623 | 146623 | 52447 52447 | 195530 | 1 | 0.0657894736842105 |
| 146624 | 146624 | 52447 52447 | 234752 | 1 | 0.131578947368421 |
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)
);