consensus_index

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

12 rows where inventory_id = 72175

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
203663 203663 72175 72175 2874 1 0.191869779281725
203664 203664 72175 72175 15625 1 0.0319782965469542
203665 203665 72175 72175 19881 2 0.055388034358829
203666 203666 72175 72175 54769 1 0.0959348896408625
203667 203667 72175 72175 56706 1 0.0274099684688179
203668 203668 72175 72175 79616 11 0.173632859056042
203669 203669 72175 72175 84319 3 0.0665175373360759
203670 203670 72175 72175 90475 2 0.038373955856345
203671 203671 72175 72175 140927 1 0.0239837224102156
203672 203672 72175 72175 148556 1 0.0959348896408625
203673 203673 72175 72175 152516 1 0.0959348896408625
203674 203674 72175 72175 215832 1 0.0959348896408625 
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)
);