consensus_index

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

9 rows where inventory_id = 79014

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
230790 230790 79014 79014 31915 8 0.329436195577638
230791 230791 79014 79014 44265 2 0.0951000380987776
230792 230792 79014 79014 48121 3 0.0997708825014003
230793 230793 79014 79014 137531 2 0.164718097788819
230794 230794 79014 79014 191998 2 0.0622575890258332
230795 230795 79014 79014 191999 1 0.0658872391155275
230796 230796 79014 79014 208868 1 0.0470623136539482
230797 230797 79014 79014 232091 1 0.0658872391155275
230798 230798 79014 79014 232118 1 0.0549060325962729 
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)
);