consensus_index

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

16 rows where inventory_id = 456147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1472761 1472761 456147 456147 4082 1 0.0181600739178219
1472762 1472762 456147 456147 119555 6 0.254241034849507
1472763 1472763 456147 456147 167912 1 0.0508482069699013
1472764 1472764 456147 456147 188050 1 0.0211867529041255
1472765 1472765 456147 456147 192603 3 0.0769977699946653
1472766 1472766 456147 456147 193513 1 0.0254241034849507
1472767 1472767 456147 456147 199455 2 0.0293572259818823
1472768 1472768 456147 456147 201331 1 0.0847470116165022
1472769 1472769 456147 456147 212213 2 0.0480470393771072
1472770 1472770 456147 456147 212214 1 0.0317801293561883
1472771 1472771 456147 456147 218318 1 0.0158900646780942
1472772 1472772 456147 456147 230866 2 0.0312949080477542
1472773 1472773 456147 456147 247521 1 0.127120517424753
1472774 1472774 456147 456147 256712 1 0.0282490038721674
1472775 1472775 456147 456147 258451 2 0.0898877798989857
1472776 1472776 456147 456147 267222 1 0.0195570026807313 
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)
);