consensus_index

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

7 rows where inventory_id = 103998

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
307756 307756 103998 103998 8268 6 0.314947273186018
307757 307757 103998 103998 16820 1 0.117838787123277
307758 307758 103998 103998 153852 1 0.0589193935616383
307759 307759 103998 103998 164147 2 0.249973816385001
307760 307760 103998 103998 176829 2 0.0771435945420289
307761 307761 103998 103998 208931 2 0.0883790903424574
307762 307762 103998 103998 217336 1 0.0707032722739659 
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)
);