consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
5 rows where inventory_id = 77002
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 222898 | 222898 | 77002 77002 | 3659 | 8 | 0.375903614457831 |
| 222899 | 222899 | 77002 77002 | 161319 | 1 | 0.125301204819277 |
| 222900 | 222900 | 77002 77002 | 225320 | 1 | 0.0939759036144578 |
| 222901 | 222901 | 77002 77002 | 231283 | 1 | 0.187951807228916 |
| 222902 | 222902 | 77002 77002 | 260905 | 1 | 0.187951807228916 |
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)
);