consensus_index

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

18 rows where inventory_id = 42022

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
120763 120763 42022 42022 31915 8 0.27571711719394
120764 120764 42022 42022 44265 2 0.0919057057313134
120765 120765 42022 42022 48121 2 0.0562805208730254
120766 120766 42022 42022 137531 2 0.13785855859697
120767 120767 42022 42022 169644 1 0.0393881595991343
120768 120768 42022 42022 184128 1 0.0344646396492425
120769 120769 42022 42022 185691 1 0.0172323198246213
120770 120770 42022 42022 186527 1 0.0459528528656567
120771 120771 42022 42022 189026 1 0.0229764264328284
120772 120772 42022 42022 191998 2 0.0435947040114212
120773 120773 42022 42022 191999 2 0.0551434234387881
120774 120774 42022 42022 198626 1 0.0306352352437711
120775 120775 42022 42022 201616 1 0.0250651924721764
120776 120776 42022 42022 208868 1 0.0393881595991343
120777 120777 42022 42022 218991 1 0.0183811411462627
120778 120778 42022 42022 234490 1 0.0212090090149185
120779 120779 42022 42022 249713 1 0.0196940797995672
120780 120780 42022 42022 297919 1 0.0162186539525847 
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)
);