consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inchi_id = 124019
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 25035 | 25035 | 7364 7364 | 124019 | 2 | 0.473684210526316 |
| 92273 | 92273 | 32899 32899 | 124019 | 2 | 0.473684210526316 |
| 174081 | 174081 | 62185 62185 | 124019 | 2 | 0.473684210526316 |
| 225273 | 225273 | 77686 77686 | 124019 | 2 | 0.470588235294118 |
| 432978 | 432978 | 155695 155695 | 124019 | 2 | 0.470588235294118 |
| 586580 | 586580 | 229028 229028 | 124019 | 2 | 0.470588235294118 |
| 754624 | 754624 | 265216 265216 | 124019 | 2 | 0.473684210526316 |
| 754626 | 754626 | 265217 265217 | 124019 | 1 | 0.461538461538462 |
| 1004072 | 1004072 | 359471 359471 | 124019 | 2 | 0.473684210526316 |
| 1004074 | 1004074 | 359472 359472 | 124019 | 2 | 0.473684210526316 |
| 1215230 | 1215230 | 403855 403855 | 124019 | 2 | 0.473684210526316 |
| 1215232 | 1215232 | 403856 403856 | 124019 | 2 | 0.473684210526316 |
| 1215234 | 1215234 | 403857 403857 | 124019 | 2 | 0.473684210526316 |
| 1457617 | 1457617 | 452663 452663 | 124019 | 2 | 0.473684210526316 |
| 1457619 | 1457619 | 452664 452664 | 124019 | 2 | 0.473684210526316 |
| 1592687 | 1592687 | 480764 480764 | 124019 | 2 | 0.473684210526316 |
| 1619261 | 1619261 | 488969 488969 | 124019 | 2 | 0.473684210526316 |
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)
);