home / zeropm-v0-0-4

consensus_index

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

9 rows where inchi_id = 41627

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2910 2910 828 828 41627 7 0.888888888888889
157424 157424 56609 56609 41627 1 0.209558823529412
201132 201132 71433 71433 41627 7 0.888888888888889
267822 267822 90784 90784 41627 1 0.3125
420400 420400 151505 151505 41627 3 0.690983005625053
446333 446333 159879 159879 41627 1 0.20625
898331 898331 315813 315813 41627 1 0.253012048192771
1731324 1731324 530159 530159 41627 1 0.259842519685039
1755024 1755024 537827 537827 41627 4 0.833333333333333
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 499.314ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website