consensus_index

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

10 rows where inventory_id = 78753

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
229789 229789 78753 78753 14033 8 0.274680183997793
229790 229790 78753 78753 44866 1 0.0549360367995585
229791 229791 78753 78753 99662 1 0.137340091998896
229792 229792 78753 78753 157357 2 0.137340091998896
229793 229793 78753 78753 159990 1 0.0686700459994481
229794 229794 78753 78753 169471 1 0.0549360367995585
229795 229795 78753 78753 169626 2 0.0423840725590632
229796 229796 78753 78753 178057 1 0.0457800306662988
229797 229797 78753 78753 232383 1 0.0915600613325975
229798 229798 78753 78753 240516 2 0.0792933390860907 
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)
);