consensus_index

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

11 rows where inventory_id = 37963

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
108298 108298 37963 37963 17168 6 0.145967605123607
108299 108299 37963 37963 83486 1 0.03244334713442
108300 108300 37963 37963 130559 9 0.279092400461782
108301 108301 37963 37963 145660 3 0.0795997332209787
108302 108302 37963 37963 216106 3 0.107125571948489
108303 108303 37963 37963 248146 2 0.112387051208819
108304 108304 37963 37963 253117 2 0.0529797640182106
108305 108305 37963 37963 270968 2 0.0556171665161486
108306 108306 37963 37963 276591 2 0.04866502070163
108307 108307 37963 37963 290028 1 0.038932016561304
108308 108308 37963 37963 296452 1 0.0353927423284582 
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)
);