consensus_index

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

10 rows where inventory_id = 74993

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
215956 215956 74993 74993 52393 2 0.0569563056850989
215957 215957 74993 74993 77807 1 0.107397839950046
215958 215958 74993 74993 79622 8 0.322193519850139
215959 215959 74993 74993 185614 2 0.161096759925069
215960 215960 74993 74993 199797 1 0.0644387039700278
215961 215961 74993 74993 239024 1 0.0805483799625347
215962 215962 74993 74993 250944 2 0.0703083901494057
215963 215963 74993 74993 253112 1 0.0536989199750232
215964 215964 74993 74993 259756 1 0.0322193519850139
215965 215965 74993 74993 308360 1 0.0357992799833488 
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)
);