consensus_index

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

20 rows where inchi_id = 185927

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27830 27830 8078 8078 185927 3 0.104290179080625
27834 27834 8079 8079 185927 1 0.0787626557092586
101720 101720 35881 35881 185927 1 0.0787626557092586
174237 174237 62233 62233 185927 1 0.0787626557092586
197180 197180 70003 70003 185927 1 0.0274652648821591
513668 513668 206222 206222 185927 1 0.0273759643877625
539996 539996 213990 213990 185927 1 0.0269817767493211
559428 559428 220087 220087 185927 2 0.123447740100069
704467 704467 250799 250799 185927 3 0.106110327131871
704471 704471 250800 250800 185927 1 0.0817726847383117
801796 801796 279675 279675 185927 3 0.10644973619588
801803 801803 279676 279676 185927 2 0.125532391840395
801807 801807 279677 279677 185927 1 0.0854755548393561
840865 840865 291564 291564 185927 1 0.0273759643877625
860657 860657 297631 297631 185927 2 0.125532391840395
916853 916853 324979 324979 185927 1 0.0835266821345708
1623484 1623484 490252 490252 185927 3 0.10644973619588
1623488 1623488 490253 490253 185927 1 0.0854755548393561
1724602 1724602 528111 528111 185927 2 0.125532391840395
1724606 1724606 528112 528112 185927 1 0.0835266821345708 
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)
);