consensus_index

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

11 rows where inventory_id = 207499

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
519036 519036 207499 207499 5257 8 0.281049474776087
519037 519037 207499 207499 8137 1 0.140524737388044
519038 519038 207499 207499 23993 1 0.0468415791293479
519039 519039 207499 207499 25593 1 0.0312277194195652
519040 519040 207499 207499 69679 2 0.0573689838065521
519041 519041 207499 207499 169921 1 0.0702623686940218
519042 519042 207499 207499 185233 1 0.0281049474776087
519043 519043 207499 207499 204058 1 0.0936831582586957
519044 519044 207499 207499 204595 1 0.0562098949552174
519045 519045 207499 207499 205545 1 0.0401499249680125
519046 519046 207499 207499 240086 1 0.140524737388044 
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)
);