consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
11 rows where inchi_id = 31006
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 8978 | 8978 | 2722 2722 | 31006 | 7 | 0.888888888888889 |
| 199196 | 199196 | 70851 70851 | 31006 | 7 | 0.888888888888889 |
| 341600 | 341600 | 115271 115271 | 31006 | 7 | 0.620689655172414 |
| 529114 | 529114 | 210116 210116 | 31006 | 7 | 0.888888888888889 |
| 529115 | 529115 | 210117 210117 | 31006 | 4 | 0.833333333333333 |
| 566132 | 566132 | 222290 222290 | 31006 | 8 | 0.625 |
| 697083 | 697083 | 248502 248502 | 31006 | 12 | 0.928571428571429 |
| 789208 | 789208 | 275631 275631 | 31006 | 4 | 0.222965088976923 |
| 789225 | 789225 | 275632 275632 | 31006 | 7 | 0.620689655172414 |
| 939874 | 939874 | 336020 336020 | 31006 | 4 | 0.833333333333333 |
| 1752533 | 1752533 | 536895 536895 | 31006 | 6 | 0.875 |
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)
);