home / zeropm-v0-0-4

consensus_index

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

8 rows where inventory_id = 275071

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
787596 787596 275071 275071 12811 4 0.222725738871927
787597 787597 275071 275071 17912 2 0.0787454401505617
787598 787598 275071 275071 29877 2 0.157490880301123
787599 787599 275071 275071 125003 1 0.0742419129573088
787600 787600 275071 275071 128843 3 0.222725738871927
787601 787601 275071 275071 227012 1 0.0742419129573088
787602 787602 275071 275071 253600 1 0.0445451477743853
787603 787603 275071 275071 314446 1 0.111362869435963
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 2351.247ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website