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 = 214799

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
542898 542898 214799 214799 25284 1 0.190440286976181
542899 542899 214799 214799 46792 1 0.126960191317454
542900 542900 214799 214799 56428 1 0.0423200637724846
542901 542901 214799 214799 70177 2 0.190440286976181
542902 542902 214799 214799 103014 4 0.226472944255234
542903 542903 214799 214799 170643 1 0.0634800956587269
542904 542904 214799 214799 189834 1 0.0544115105646231
542905 542905 214799 214799 248109 1 0.0761761147904723
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 501.64ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website