consensus_index

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

10 rows where inventory_id = 28433

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
78683 78683 28433 28433 5133 8 0.146622816793697
78684 78684 28433 28433 93173 2 0.0407679819901381
78685 78685 28433 28433 101575 2 0.0494182568923161
78686 78686 28433 28433 138316 3 0.27456307542054
78687 78687 28433 28433 181551 3 0.0915210251401802
78688 78688 28433 28433 199722 2 0.0364639916141744
78689 78689 28433 28433 216003 2 0.0301091501243081
78690 78690 28433 28433 226730 2 0.0773518072185364
78691 78691 28433 28433 264565 1 0.0432409747807766
78692 78692 28433 28433 285269 4 0.147810453341865 
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)
);