consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

12 rows where inchi_id = 8333

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
50119 50119 15542 15542 8333 6 0.473684210526316
62203 62203 20007 20007 8333 3 0.323798069779396
107236 107236 37749 37749 8333 3 0.323798069779396
280462 280462 95099 95099 8333 1 0.3125
307815 307815 104015 104015 8333 5 0.466666666666667
360582 360582 122437 122437 8333 2 0.385628546646544
505266 505266 202110 202110 8333 1 0.3125
559234 559234 220034 220034 8333 1 0.3125
704695 704695 250853 250853 8333 1 0.318181818181818
1645635 1645635 498200 498200 8333 1 0.3125
1658124 1658124 502443 502443 8333 6 0.473684210526316
1682585 1682585 511450 511450 8333 3 0.323798069779396 
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)
);