consensus_index

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

21 rows where inventory_id = 40068

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
114785 114785 40068 40068 29918 3 0.174536455898024
114786 114786 40068 40068 127556 1 0.041954188086984
114787 114787 40068 40068 140297 3 0.109951077379985
114788 114788 40068 40068 167038 3 0.0692648384248313
114789 114789 40068 40068 189141 3 0.0503450257043808
114790 114790 40068 40068 192052 1 0.015732820532619
114791 114791 40068 40068 216240 1 0.0167816752347936
114792 114792 40068 40068 235047 1 0.031465641065238
114793 114793 40068 40068 238505 1 0.013984729362328
114794 114794 40068 40068 238965 1 0.0359607326459862
114795 114795 40068 40068 243363 1 0.0148073605012885
114796 114796 40068 40068 258865 3 0.0366503591266615
114797 114797 40068 40068 259603 1 0.020977094043492
114798 114798 40068 40068 261325 3 0.082897333440033
114799 114799 40068 40068 261925 1 0.013248690974837
114800 114800 40068 40068 284930 3 0.0279822593940516
114801 114801 40068 40068 289342 2 0.0237857888862403
114802 114802 40068 40068 290042 2 0.0252993273215498
114803 114803 40068 40068 297998 3 0.0927363302473993
114804 114804 40068 40068 309687 2 0.0177996545372893
114805 114805 40068 40068 326253 1 0.0119869108819954 
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)
);