consensus_index

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

20 rows where inventory_id = 59999

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
168064 168064 59999 59999 37598 7 0.259217357535169
168065 168065 59999 59999 47895 3 0.129608678767585
168066 168066 59999 59999 75665 1 0.0185155255382264
168067 168067 59999 59999 120043 1 0.0144009643075094
168068 168068 59999 59999 136365 2 0.0289813816198253
168069 168069 59999 59999 146241 1 0.0324021696918962
168070 168070 59999 59999 149807 2 0.0748296055757767
168071 168071 59999 59999 169215 2 0.105825043072293
168072 168072 59999 59999 169433 2 0.0386418421597671
168073 168073 59999 59999 169454 1 0.0432028929225282
168074 168074 59999 59999 169542 1 0.023565214321379
168075 168075 59999 59999 169543 1 0.0259217357535169
168076 168076 59999 59999 184623 1 0.0199397967334746
168077 168077 59999 59999 185082 1 0.0172811571690113
168078 168078 59999 59999 188244 2 0.0352750143574309
168079 168079 59999 59999 198596 1 0.0216014464612641
168080 168080 59999 59999 217708 1 0.0370310510764528
168081 168081 59999 59999 236990 1 0.0162010848459481
168082 168082 59999 59999 271778 2 0.0265951397315801
168083 168083 59999 59999 271837 2 0.0237624162056114 
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)
);