home / zeropm-v0-0-4

consensus_index

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

7 rows where inchi_id = 41427

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
277383 277383 94051 94051 41427 6 0.514285714285714
317512 317512 107008 107008 41427 1 0.307692307692308
453146 453146 162703 162703 41427 6 0.514285714285714
502425 502425 200740 200740 41427 4 0.833333333333333
748093 748093 263038 263038 41427 2 0.0915141816842597
822612 822612 285648 285648 41427 2 0.063382887601742
1644319 1644319 497708 497708 41427 6 0.430750225721352
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)
);
Powered by Datasette · Queries took 962.829ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website