consensus_index

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

21 rows where inventory_id = 87116

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
257280 257280 87116 87116 11858 8 0.255252329149342
257281 257281 87116 87116 47316 4 0.044840700540085
257282 257282 87116 87116 108509 2 0.0380507706262053
257283 257283 87116 87116 137097 4 0.127626164574671
257284 257284 87116 87116 144687 2 0.0213452720786837
257285 257285 87116 87116 169284 4 0.0850841097164473
257286 257286 87116 87116 174079 2 0.0260515817530345
257287 257287 87116 87116 181335 2 0.0269059579391637
257288 257288 87116 87116 184244 1 0.0141806849527412
257289 257289 87116 87116 192358 2 0.036464618449906
257290 257290 87116 87116 196020 3 0.0557458620808262
257291 257291 87116 87116 196023 4 0.0360262931392911
257292 257292 87116 87116 208046 3 0.0420294500693776
257293 257293 87116 87116 217187 2 0.02433735466617
257294 257294 87116 87116 251382 1 0.0319065411436677
257295 257295 87116 87116 266547 2 0.0245616668242752
257296 257296 87116 87116 288013 2 0.015984520886938
257297 257297 87116 87116 288128 2 0.021887706651721
257298 257298 87116 87116 298060 2 0.0319065411436677
257299 257299 87116 87116 309732 2 0.0182789989537053
257300 257300 87116 87116 310008 2 0.017054763622373 
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)
);