consensus_index

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

19 rows where inventory_id = 117076

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
346689 346689 117076 117076 34976 2 0.110197596747564
346690 346690 117076 117076 111443 4 0.269927882912514
346691 346691 117076 117076 170805 3 0.134963941456257
346692 346692 117076 117076 183190 1 0.0269927882912514
346693 346693 117076 117076 216196 3 0.0899759609708381
346694 346694 117076 117076 239194 2 0.0426793456995395
346695 346695 117076 117076 240423 3 0.0674819707281286
346696 346696 117076 117076 265198 1 0.014206730679606
346697 346697 117076 117076 275728 1 0.0224939902427095
346698 346698 117076 117076 276388 1 0.0385611261303592
346699 346699 117076 117076 280846 1 0.0245388984465922
346700 346700 117076 117076 292548 1 0.0299919869902794
346701 346701 117076 117076 292680 1 0.0207636833009626
346702 346702 117076 117076 294492 1 0.0192805630651796
346703 346703 117076 117076 294829 1 0.0134963941456257
346704 346704 117076 117076 297605 1 0.0179951921941676
346705 346705 117076 117076 307911 1 0.0168704926820321
346706 346706 117076 117076 309860 1 0.0158781107595597
346707 346707 117076 117076 321403 1 0.0149959934951397 
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)
);