consensus_index

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

8 rows where inventory_id = 239286

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
667727 667727 239286 239286 28058 2 0.141683655405858
667728 667728 239286 239286 28085 1 0.0416510796718302
667729 667729 239286 239286 129078 5 0.261962136007116
667730 667730 239286 239286 198937 1 0.187429858523236
667731 667731 239286 239286 227602 1 0.046857464630809
667732 667732 239286 239286 253155 1 0.093714929261618
667733 667733 239286 239286 317104 1 0.0749719434092944
667734 667734 239286 239286 332381 1 0.124953239015491 
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)
);