consensus_index

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

10 rows where inventory_id = 246299

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
690494 690494 246299 246299 20157 5 0.131597216154296
690495 690495 246299 246299 97140 6 0.23688285046269
690496 690496 246299 246299 129189 1 0.0373067112071303
690497 690497 246299 246299 147506 1 0.0994845632190141
690498 690498 246299 246299 151363 6 0.21103862782664
690499 690499 246299 246299 182616 1 0.049742281609507
690500 690500 246299 246299 230973 2 0.0596907379314085
690501 690501 246299 246299 254051 2 0.0351731046377733
690502 690502 246299 246299 264292 2 0.0426362413795775
690503 690503 246299 246299 332617 2 0.0861561590320652 
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)
);