consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
7 rows where inventory_id = 39
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 188 | 188 | 39 39 | 49668 | 12 | 0.229677925528528 |
| 189 | 189 | 39 39 | 97062 | 18 | 0.335976209720625 |
| 190 | 190 | 39 39 | 101991 | 1 | 0.0839940524301563 |
| 191 | 191 | 39 39 | 112844 | 1 | 0.111992069906875 |
| 192 | 192 | 39 39 | 136740 | 4 | 0.0876385308508699 |
| 193 | 193 | 39 39 | 151963 | 2 | 0.0751265643758044 |
| 194 | 194 | 39 39 | 161588 | 1 | 0.0671952419441251 |
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)
);