consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inventory_id = 218305
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 553013 | 553013 | 218305 218305 | 52214 | 2 | 0.142118350171905 |
| 553014 | 553014 | 218305 218305 | 84720 | 2 | 0.142118350171905 |
| 553015 | 553015 | 218305 218305 | 204174 | 1 | 0.0142118350171905 |
| 553016 | 553016 | 218305 218305 | 237129 | 1 | 0.028423670034381 |
| 553017 | 553017 | 218305 218305 | 238970 | 1 | 0.0355295875429762 |
| 553018 | 553018 | 218305 218305 | 248548 | 2 | 0.142118350171905 |
| 553019 | 553019 | 218305 218305 | 248550 | 3 | 0.0782107421667601 |
| 553020 | 553020 | 218305 218305 | 248564 | 1 | 0.0710591750859524 |
| 553021 | 553021 | 218305 218305 | 248567 | 1 | 0.028423670034381 |
| 553022 | 553022 | 218305 218305 | 248589 | 1 | 0.0710591750859524 |
| 553023 | 553023 | 218305 218305 | 248675 | 1 | 0.0236863916953175 |
| 553024 | 553024 | 218305 218305 | 248680 | 1 | 0.0473727833906349 |
| 553025 | 553025 | 218305 218305 | 248885 | 1 | 0.0355295875429762 |
| 553026 | 553026 | 218305 218305 | 249079 | 1 | 0.0473727833906349 |
| 553027 | 553027 | 218305 218305 | 258656 | 1 | 0.0177647937714881 |
| 553028 | 553028 | 218305 218305 | 292022 | 1 | 0.0157909277968783 |
| 553029 | 553029 | 218305 218305 | 292434 | 1 | 0.0203026214531292 |
| 553030 | 553030 | 218305 218305 | 326154 | 1 | 0.0203026214531292 |
| 553031 | 553031 | 218305 218305 | 331102 | 1 | 0.0129198500156277 |
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)
);