consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
23 rows where inchi_id = 42521
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 27693 | 27693 | 8039 8039 | 42521 | 8 | 0.625 |
| 39642 | 39642 | 11985 11985 | 42521 | 1 | 0.170984455958549 |
| 84797 | 84797 | 30516 30516 | 42521 | 8 | 0.625 |
| 84813 | 84813 | 30521 30521 | 42521 | 1 | 0.170984455958549 |
| 133736 | 133736 | 47442 47442 | 42521 | 1 | 0.170984455958549 |
| 133859 | 133859 | 47470 47470 | 42521 | 12 | 0.636363636363636 |
| 233310 | 233310 | 79780 79780 | 42521 | 8 | 0.9 |
| 436340 | 436340 | 156557 156557 | 42521 | 8 | 0.9 |
| 521096 | 521096 | 207992 207992 | 42521 | 8 | 0.9 |
| 521097 | 521097 | 207993 207993 | 42521 | 8 | 0.9 |
| 560146 | 560146 | 220327 220327 | 42521 | 12 | 0.636363636363636 |
| 662607 | 662607 | 237535 237535 | 42521 | 8 | 0.9 |
| 703614 | 703614 | 250558 250558 | 42521 | 8 | 0.625 |
| 704127 | 704127 | 250718 250718 | 42521 | 1 | 0.170984455958549 |
| 800486 | 800486 | 279239 279239 | 42521 | 8 | 0.625 |
| 800487 | 800487 | 279240 279240 | 42521 | 7 | 0.888888888888889 |
| 800488 | 800488 | 279241 279241 | 42521 | 8 | 0.9 |
| 800489 | 800489 | 279242 279242 | 42521 | 8 | 0.9 |
| 801291 | 801291 | 279529 279529 | 42521 | 1 | 0.170984455958549 |
| 884110 | 884110 | 307652 307652 | 42521 | 4 | 0.833333333333333 |
| 1615537 | 1615537 | 487781 487781 | 42521 | 8 | 0.625 |
| 1645257 | 1645257 | 498068 498068 | 42521 | 1 | 0.170984455958549 |
| 1724423 | 1724423 | 528056 528056 | 42521 | 4 | 0.833333333333333 |
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)
);