consensus_index

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

12 rows where inventory_id = 2521

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8327 8327 2521 2521 3489 1 0.0849060397340258
8328 8328 2521 2521 3709 12 0.254718119202077
8329 8329 2521 2521 3730 1 0.0363883027431539
8330 8330 2521 2521 3731 1 0.0424530198670129
8331 8331 2521 2521 11441 1 0.127359059601039
8332 8332 2521 2521 29988 1 0.0509436238404155
8333 8333 2521 2521 46236 1 0.127359059601039
8334 8334 2521 2521 46508 1 0.0283020132446753
8335 8335 2521 2521 56916 1 0.0318397649002597
8336 8336 2521 2521 184032 2 0.056956702963674
8337 8337 2521 2521 187180 1 0.0849060397340258
8338 8338 2521 2521 224786 1 0.0636795298005193 
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)
);