consensus_index

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

11 rows where inventory_id = 241542

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
675708 675708 241542 241542 4601 11 0.310531385693689
675709 675709 241542 241542 38490 1 0.0388164232117112
675710 675710 241542 241542 136415 2 0.155265692846845
675711 675711 241542 241542 149870 1 0.0443616265276699
675712 675712 241542 241542 150095 1 0.0517552309489482
675713 675713 241542 241542 190777 3 0.0999382521580445
675714 675714 241542 241542 237476 1 0.0345034872992988
675715 675715 241542 241542 310480 2 0.0776328464234223
675716 675716 241542 241542 310671 1 0.0443616265276699
675717 675717 241542 241542 317175 3 0.0873041047651579
675718 675718 241542 241542 318359 2 0.0448213447805198 
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)
);