consensus_index

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

11 rows where inventory_id = 8117

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27988 27988 8117 8117 44373 8 0.264158066434462
27989 27989 8117 8117 185065 3 0.133576521061255
27990 27990 8117 8117 185632 1 0.0285515797569375
27991 27991 8117 8117 192592 4 0.148316510131295
27992 27992 8117 8117 234413 4 0.0567463330682094
27993 27993 8117 8117 241008 3 0.0565204335525544
27994 27994 8117 8117 259965 1 0.0507583640123333
27995 27995 8117 8117 289169 1 0.0652607537301428
27996 27996 8117 8117 310196 1 0.03806877300925
27997 27997 8117 8117 330200 1 0.0351404058546923
27998 27998 8117 8117 343947 2 0.107674750185168 
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)
);