consensus_index

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

8 rows where inventory_id = 493301

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1632145 1632145 493301 493301 1783 3 0.258193115252546
1632146 1632146 493301 493301 6545 1 0.108434313614872
1632147 1632147 493301 493301 52218 1 0.0542171568074359
1632148 1632148 493301 493301 116599 6 0.325302940844616
1632149 1632149 493301 493301 159808 1 0.0813257352111539
1632150 1632150 493301 493301 167409 1 0.0650605881689231
1632151 1632151 493301 493301 220625 1 0.046471848692088
1632152 1632152 493301 493301 334362 1 0.040662867605577 
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)
);