consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 60997
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 18625 | 18625 | 5459 5459 | 60997 | 7 | 0.45993031358885 |
| 21667 | 21667 | 6392 6392 | 60997 | 1 | 0.173228346456693 |
| 97071 | 97071 | 34412 34412 | 60997 | 1 | 0.173228346456693 |
| 194492 | 194492 | 69023 69023 | 60997 | 15 | 0.421052631578947 |
| 220473 | 220473 | 76339 76339 | 60997 | 1 | 0.173913043478261 |
| 240910 | 240910 | 81875 81875 | 60997 | 1 | 0.158568535700802 |
| 245273 | 245273 | 83454 83454 | 60997 | 8 | 0.416666666666667 |
| 547320 | 547320 | 216476 216476 | 60997 | 8 | 0.416666666666667 |
| 670748 | 670748 | 240152 240152 | 60997 | 1 | 0.172413793103448 |
| 714401 | 714401 | 252894 252894 | 60997 | 1 | 0.158988712489676 |
| 719762 | 719762 | 254438 254438 | 60997 | 7 | 0.412453626698023 |
| 740918 | 740918 | 261037 261037 | 60997 | 1 | 0.172413793103448 |
| 740921 | 740921 | 261038 261038 | 60997 | 1 | 0.173228346456693 |
| 824940 | 824940 | 286295 286295 | 60997 | 7 | 0.412453626698023 |
| 824944 | 824944 | 286296 286296 | 60997 | 8 | 0.461538461538462 |
| 935623 | 935623 | 334009 334009 | 60997 | 1 | 0.168674698795181 |
| 952361 | 952361 | 341690 341690 | 60997 | 4 | 0.452830188679245 |
| 1616028 | 1616028 | 487965 487965 | 60997 | 1 | 0.172413793103448 |
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)
);