consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inventory_id = 321173
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 909424 | 909424 | 321173 321173 | 7801 | 3 | 0.103748055930059 |
| 909425 | 909425 | 321173 321173 | 130556 | 5 | 0.183601242144566 |
| 909426 | 909426 | 321173 321173 | 136391 | 1 | 0.103748055930059 |
| 909427 | 909427 | 321173 321173 | 197767 | 1 | 0.0311244167790178 |
| 909428 | 909428 | 321173 321173 | 197769 | 1 | 0.0282949243445616 |
| 909429 | 909429 | 321173 321173 | 197771 | 1 | 0.0259370139825148 |
| 909430 | 909430 | 321173 321173 | 227352 | 1 | 0.0194527604868861 |
| 909431 | 909431 | 321173 321173 | 229306 | 1 | 0.155622083895089 |
| 909432 | 909432 | 321173 321173 | 230121 | 2 | 0.0401814492818515 |
| 909433 | 909433 | 321173 321173 | 245401 | 1 | 0.0389055209737722 |
| 909434 | 909434 | 321173 321173 | 255538 | 1 | 0.0518740279650296 |
| 909435 | 909435 | 321173 321173 | 264660 | 1 | 0.0183084804582458 |
| 909436 | 909436 | 321173 321173 | 267987 | 1 | 0.0778110419475445 |
| 909437 | 909437 | 321173 321173 | 277630 | 1 | 0.0239418590607829 |
| 909438 | 909438 | 321173 321173 | 310149 | 1 | 0.022231726270727 |
| 909439 | 909439 | 321173 321173 | 332546 | 1 | 0.0622488335580356 |
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)
);