consensus_index

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

14 rows where inventory_id = 154827

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
429858 429858 154827 154827 2270 8 0.2579274155636
429859 429859 154827 154827 21577 1 0.0859758051878666
429860 429860 154827 154827 26325 1 0.0644818538908999
429861 429861 154827 154827 38576 1 0.0515854831127199
429862 429862 154827 154827 54971 1 0.0515854831127199
429863 429863 154827 154827 78272 1 0.02579274155636
429864 429864 154827 154827 83446 2 0.0317486701461694
429865 429865 154827 154827 88072 1 0.0286586017292889
429866 429866 154827 154827 158467 1 0.0859758051878666
429867 429867 154827 154827 161026 1 0.03224092694545
429868 429868 154827 154827 179661 1 0.0368467736519428
429869 429869 154827 154827 182926 1 0.0644818538908999
429870 429870 154827 154827 183102 1 0.0429879025939333
429871 429871 154827 154827 196667 2 0.1289637077818 
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)
);