consensus_index

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

12 rows where inventory_id = 86526

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
254660 254660 86526 86526 7370 8 0.294525902461912
254661 254661 86526 86526 138329 2 0.0981753008206374
254662 254662 86526 86526 138373 2 0.147262951230956
254663 254663 86526 86526 168471 1 0.0589051804923824
254664 254664 86526 86526 192133 1 0.0420751289231303
254665 254665 86526 86526 194745 1 0.073631475615478
254666 254666 86526 86526 195510 1 0.0420751289231303
254667 254667 86526 86526 199481 2 0.0425111522674256
254668 254668 86526 86526 237674 2 0.060119848088701
254669 254669 86526 86526 260096 1 0.0589051804923824
254670 254670 86526 86526 270384 1 0.0327251002735458
254671 254671 86526 86526 334461 1 0.036815737807739 
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)
);