consensus_index

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

12 rows where inventory_id = 48063

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
135657 135657 48063 48063 137366 1 0.0453046383972512
135658 135658 48063 48063 174223 1 0.0271827830383507
135659 135659 48063 48063 181644 1 0.0906092767945024
135660 135660 48063 48063 189149 2 0.271827830383507
135661 135661 48063 48063 239071 1 0.0679569575958768
135662 135662 48063 48063 241343 2 0.135913915191754
135663 135663 48063 48063 241344 1 0.0543655660767015
135664 135664 48063 48063 261961 1 0.0388325471976439
135665 135665 48063 48063 307821 2 0.0554866235272839
135666 135666 48063 48063 320718 2 0.0453046383972512
135667 135667 48063 48063 340495 2 0.0366532571716484
135668 135668 48063 48063 343793 2 0.0320352170299008 
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)
);