consensus_index

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

20 rows where inventory_id = 249378

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
699841 699841 249378 249378 13320 1 0.0247050929109024
699842 699842 249378 249378 35296 6 0.164944229252832
699843 699843 249378 249378 110552 5 0.135267278311365
699844 699844 249378 249378 115474 1 0.0247050929109024
699845 699845 249378 249378 136398 2 0.0331453602835355
699846 699846 249378 249378 138621 4 0.105140854440584
699847 699847 249378 249378 147554 2 0.0265754104590374
699848 699848 249378 249378 147610 1 0.0202132578361929
699849 699849 249378 249378 167646 2 0.0237021457780634
699850 699850 249378 249378 168949 5 0.146693544895418
699851 699851 249378 249378 169496 1 0.0277932295247652
699852 699852 249378 249378 178248 2 0.0641857141910889
699853 699853 249378 249378 182528 1 0.0317636908854459
699854 699854 249378 249378 186646 1 0.0370576393663536
699855 699855 249378 249378 199883 1 0.0148230557465414
699856 699856 249378 249378 200176 1 0.0222345836198121
699857 699857 249378 249378 238882 2 0.0405946100176866
699858 699858 249378 249378 240047 2 0.017103525861394
699859 699859 249378 249378 297912 2 0.0185288196831768
699860 699860 249378 249378 309753 2 0.015881845442723 
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)
);