consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inventory_id = 271955
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 777562 | 777562 | 271955 271955 | 21765 | 4 | 0.256803831225567 |
| 777563 | 777563 | 271955 271955 | 248549 | 2 | 0.104839725082408 |
| 777564 | 777564 | 271955 271955 | 248621 | 8 | 0.0818303361174645 |
| 777565 | 777565 | 271955 271955 | 248649 | 1 | 0.0428006385375945 |
| 777566 | 777566 | 271955 271955 | 248662 | 2 | 0.0642009578063918 |
| 777567 | 777567 | 271955 271955 | 248694 | 1 | 0.0233458028386879 |
| 777568 | 777568 | 271955 271955 | 248722 | 2 | 0.104839725082408 |
| 777569 | 777569 | 271955 271955 | 248891 | 1 | 0.0366862616036524 |
| 777570 | 777570 | 271955 271955 | 249089 | 1 | 0.0321004789031959 |
| 777571 | 777571 | 271955 271955 | 249092 | 1 | 0.0321004789031959 |
| 777572 | 777572 | 271955 271955 | 249110 | 1 | 0.028533759025063 |
| 777573 | 777573 | 271955 271955 | 249113 | 1 | 0.0256803831225567 |
| 777574 | 777574 | 271955 271955 | 264295 | 2 | 0.0258097561485139 |
| 777575 | 777575 | 271955 271955 | 276055 | 2 | 0.0513607662451134 |
| 777576 | 777576 | 271955 271955 | 276766 | 1 | 0.0214003192687973 |
| 777577 | 777577 | 271955 271955 | 284926 | 2 | 0.0225231859565153 |
| 777578 | 777578 | 271955 271955 | 326149 | 2 | 0.0198128457206023 |
| 777579 | 777579 | 271955 271955 | 327215 | 2 | 0.0183901043250941 |
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)
);