consensus_index

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

8 rows where inventory_id = 69942

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
196988 196988 69942 69942 59375 2 0.195952267355821
196989 196989 69942 69942 76723 2 0.0979761336779106
196990 196990 69942 69942 76724 1 0.092372784690787
196991 196991 69942 69942 187744 2 0.277118354072361
196992 196992 69942 69942 187872 1 0.0395883362960516
196993 196993 69942 69942 192308 2 0.0692795885180903
196994 196994 69942 69942 201306 1 0.0461863923453935
196995 196995 69942 69942 231951 2 0.0715516513500443 
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)
);