consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
7 rows where inventory_id = 7
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 27 | 27 | 7 7 | 3684 | 22 | 0.264483124241209 |
| 28 | 28 | 7 7 | 9034 | 2 | 0.193003929059259 |
| 29 | 29 | 7 7 | 36181 | 1 | 0.0909829246889664 |
| 30 | 30 | 7 7 | 154083 | 1 | 0.13647438703345 |
| 31 | 31 | 7 7 | 203677 | 1 | 0.13647438703345 |
| 32 | 32 | 7 7 | 243836 | 1 | 0.0909829246889664 |
| 33 | 33 | 7 7 | 284771 | 2 | 0.0787935240912513 |
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)
);