consensus_index

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

24 rows where inventory_id = 245557

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
688620 688620 245557 245557 17087 8 0.240227583462685
688621 688621 245557 245557 137238 2 0.0205993453380272
688622 688622 245557 245557 137239 3 0.120113791731342
688623 688623 245557 245557 139256 1 0.0600568958656712
688624 688624 245557 245557 170040 1 0.0400379305771141
688625 688625 245557 245557 195489 1 0.0240227583462685
688626 688626 245557 245557 195658 1 0.0160151722308457
688627 688627 245557 245557 200115 1 0.0218388712238804
688628 688628 245557 245557 206442 1 0.0200189652885571
688629 688629 245557 245557 210407 3 0.028022659908317
688630 688630 245557 245557 210408 3 0.0800758611542283
688631 688631 245557 245557 217831 1 0.0150142239664178
688632 688632 245557 245557 230296 2 0.0406058728533276
688633 688633 245557 245557 232254 1 0.0109194356119402
688634 688634 245557 245557 240726 3 0.055751883446309
688635 688635 245557 245557 241408 1 0.034318226208955
688636 688636 245557 245557 287842 2 0.0188740614771691
688637 688637 245557 245557 308195 1 0.0120113791731342
688638 688638 245557 245557 310231 1 0.0126435570243518
688639 688639 245557 245557 325976 1 0.0300284479328356
688640 688640 245557 245557 325977 1 0.0266919537180761
688641 688641 245557 245557 325978 1 0.018479044881745
688642 688642 245557 245557 325979 1 0.0171591131044775
688643 688643 245557 245557 326306 2 0.0310132476683543 
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)
);