consensus_index

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

9 rows where inventory_id = 86554

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
254886 254886 86554 86554 23 1 0.0389778738134056
254887 254887 86554 86554 7744 3 0.118982739463072
254888 254888 86554 86554 144681 4 0.0503591972466037
254889 254889 86554 86554 216009 2 0.311822990507245
254890 254890 86554 86554 231432 2 0.0805123499466102
254891 254891 86554 86554 241630 2 0.110246075558771
254892 254892 86554 86554 270952 2 0.110246075558771
254893 254893 86554 86554 295361 1 0.0346469989452494
254894 254894 86554 86554 343921 1 0.0311822990507245 
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)
);