consensus_index

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

21 rows where inventory_id = 87045

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
256873 256873 87045 87045 29918 3 0.174536455898024
256874 256874 87045 87045 127556 1 0.041954188086984
256875 256875 87045 87045 140297 3 0.109951077379985
256876 256876 87045 87045 167038 3 0.0692648384248313
256877 256877 87045 87045 189141 3 0.0503450257043808
256878 256878 87045 87045 192052 1 0.015732820532619
256879 256879 87045 87045 216240 1 0.0167816752347936
256880 256880 87045 87045 235047 1 0.031465641065238
256881 256881 87045 87045 238505 1 0.013984729362328
256882 256882 87045 87045 238965 1 0.0359607326459862
256883 256883 87045 87045 243363 1 0.0148073605012885
256884 256884 87045 87045 258865 3 0.0366503591266615
256885 256885 87045 87045 259603 1 0.020977094043492
256886 256886 87045 87045 261325 3 0.082897333440033
256887 256887 87045 87045 261925 1 0.013248690974837
256888 256888 87045 87045 284930 3 0.0279822593940516
256889 256889 87045 87045 289342 2 0.0237857888862403
256890 256890 87045 87045 290042 2 0.0252993273215498
256891 256891 87045 87045 297998 3 0.0927363302473993
256892 256892 87045 87045 309687 2 0.0177996545372893
256893 256893 87045 87045 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)
);