consensus_index

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

25 rows where inventory_id = 87054

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
256972 256972 87054 87054 11091 8 0.250953391140427
256973 256973 87054 87054 137053 2 0.0836511303801423
256974 256974 87054 87054 148284 2 0.0501906782280854
256975 256975 87054 87054 173801 1 0.0278837101267141
256976 256976 87054 87054 183932 1 0.0209127825950356
256977 256977 87054 87054 186649 1 0.0193041070108021
256978 256978 87054 87054 188270 1 0.0250953391140427
256979 256979 87054 87054 195651 1 0.0418255651900712
256980 256980 87054 87054 200126 2 0.0149973336350261
256981 256981 87054 87054 216557 2 0.125476695570214
256982 256982 87054 87054 217171 2 0.0130818498273205
256983 256983 87054 87054 219140 1 0.0114069723245649
256984 256984 87054 87054 238966 2 0.0627383477851068
256985 256985 87054 87054 239190 2 0.0313691738925534
256986 256986 87054 87054 239240 2 0.0244905432720625
256987 256987 87054 87054 240732 2 0.0209127825950356
256988 256988 87054 87054 240920 1 0.0139418550633571
256989 256989 87054 87054 243217 2 0.0248480883639358
256990 256990 87054 87054 267621 2 0.0299946672700523
256991 256991 87054 87054 274014 2 0.0228139446491297
256992 256992 87054 87054 294528 2 0.0159677818999754
256993 256993 87054 87054 310244 1 0.0119501614828775
256994 256994 87054 87054 320533 2 0.0193614744686575
256995 256995 87054 87054 320762 1 0.0167302260760285
256996 256996 87054 87054 329602 1 0.014761964184731 
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)
);