consensus_index

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

10 rows where inventory_id = 13111

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
43156 43156 13111 13111 27434 1 0.0258711154285754
43157 43157 13111 13111 68516 2 0.258711154285754
43158 43158 13111 13111 122824 7 0.123206428145795
43159 43159 13111 13111 147223 1 0.0431185257142923
43160 43160 13111 13111 232669 1 0.0646777885714385
43161 43161 13111 13111 275977 2 0.258711154285754
43162 43162 13111 13111 287962 1 0.0369587363265363
43163 43163 13111 13111 291462 2 0.0862370514285847
43164 43164 13111 13111 296286 1 0.0323388942857193
43165 43165 13111 13111 332915 2 0.0578495727520382 
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)
);