consensus_index

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

8 rows where inventory_id = 201615

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
503937 503937 201615 201615 4414 4 0.237242798118408
503938 503938 201615 201615 21711 1 0.0419389978342994
503939 503939 201615 201615 27347 1 0.0838779956685988
503940 503940 201615 201615 48912 6 0.335511982674395
503941 503941 201615 201615 176819 2 0.111837327558132
503942 503942 201615 201615 201435 1 0.0559186637790659
503943 503943 201615 201615 205082 1 0.0479302832391993
503944 503944 201615 201615 248777 1 0.0671023965348791 
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)
);