consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
10 rows where inchi_id = 20740
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 54675 | 54675 | 17075 17075 | 20740 | 1 | 0.3125 |
| 171688 | 171688 | 61261 61261 | 20740 | 1 | 0.3125 |
| 327011 | 327011 | 110206 110206 | 20740 | 1 | 0.310344827586207 |
| 690827 | 690827 | 246445 246445 | 20740 | 1 | 0.3125 |
| 776868 | 776868 | 271693 271693 | 20740 | 1 | 0.3125 |
| 776870 | 776870 | 271694 271694 | 20740 | 1 | 0.3 |
| 897972 | 897972 | 315629 315629 | 20740 | 4 | 0.6 |
| 907603 | 907603 | 320401 320401 | 20740 | 1 | 0.3 |
| 1668536 | 1668536 | 506051 506051 | 20740 | 1 | 0.3125 |
| 1749084 | 1749084 | 535746 535746 | 20740 | 1 | 0.3125 |
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)
);