consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inchi_id = 118642
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 52606 | 52606 | 16347 16347 | 118642 | 4 | 0.461538461538462 |
| 68430 | 68430 | 22866 22866 | 118642 | 1 | 0.191091397461567 |
| 98269 | 98269 | 34837 34837 | 118642 | 1 | 0.180070216802505 |
| 98272 | 98272 | 34838 34838 | 118642 | 4 | 0.466666666666667 |
| 193229 | 193229 | 68731 68731 | 118642 | 1 | 0.186504277457136 |
| 193232 | 193232 | 68732 68732 | 118642 | 3 | 0.454545454545455 |
| 318378 | 318378 | 107269 107269 | 118642 | 4 | 0.461538461538462 |
| 384912 | 384912 | 131998 131998 | 118642 | 1 | 0.191091397461567 |
| 469383 | 469383 | 169778 169778 | 118642 | 4 | 0.461538461538462 |
| 492482 | 492482 | 185408 185408 | 118642 | 1 | 0.191091397461567 |
| 687154 | 687154 | 245063 245063 | 118642 | 4 | 0.466666666666667 |
| 722932 | 722932 | 255538 255538 | 118642 | 1 | 0.185842209749562 |
| 832181 | 832181 | 288847 288847 | 118642 | 1 | 0.186504277457136 |
| 832185 | 832185 | 288848 288848 | 118642 | 1 | 0.186504277457136 |
| 1664714 | 1664714 | 504653 504653 | 118642 | 4 | 0.466666666666667 |
| 1747277 | 1747277 | 535164 535164 | 118642 | 4 | 0.466666666666667 |
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)
);