consensus_index

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

22 rows where inventory_id = 287958

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
829854 829854 287958 287958 53055 1 0.02494311276856
829855 829855 287958 287958 64736 5 0.139973904407419
829856 829856 287958 287958 153354 7 0.0718212311477852
829857 829857 287958 287958 178112 4 0.0231984201321561
829858 829858 287958 287958 186138 8 0.0793122944120015
829859 829859 287958 287958 188654 1 0.0415718546142667
829860 829860 287958 287958 194717 2 0.031425368242595
829861 829861 287958 287958 203070 3 0.0436184385491342
829862 829862 287958 287958 205250 1 0.01558944548035
829863 829863 287958 287958 216389 7 0.0321585360147556
829864 829864 287958 287958 232392 6 0.0324265347156541
829865 829865 287958 287958 235107 2 0.0244001504934001
829866 829866 287958 287958 236992 1 0.0166287418457067
829867 829867 287958 287958 239011 2 0.0843231115300867
829868 829868 287958 287958 241523 4 0.0319184384669226
829869 829869 287958 287958 253771 1 0.0191870098219692
829870 829870 287958 287958 258411 2 0.176374441825495
829871 829871 287958 287958 289343 4 0.0289064556922515
829872 829872 287958 287958 290049 1 0.0207859273071333
829873 829873 287958 287958 318619 1 0.0146724192756235
829874 829874 287958 287958 318695 2 0.018855220945557
829875 829875 287958 287958 323956 2 0.0205727326733647 
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)
);