home / zeropm-v0-0-4

consensus_index

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

7 rows where inventory_id = 31401

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
87767 87767 31401 31401 47353 2 0.277595110397403
87768 87768 31401 31401 53081 2 0.277595110397403
87769 87769 31401 31401 75379 2 0.138797555198701
87770 87770 31401 31401 254406 2 0.0654297949954106
87771 87771 31401 31401 274958 1 0.0693987775993507
87772 87772 31401 31401 296280 1 0.0925317034658009
87773 87773 31401 31401 309906 1 0.0555190220794806
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 1176.217ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website