consensus_index

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

13 rows where inchi_id = 43275

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28024 28024 8124 8124 43275 1 0.134949739253531
231488 231488 79205 79205 43275 1 0.173913043478261
279449 279449 94760 94760 43275 8 0.375903614457831
435955 435955 156436 156436 43275 1 0.173913043478261
520957 520957 207955 207955 43275 1 0.173913043478261
520960 520960 207956 207956 43275 1 0.173913043478261
520963 520963 207957 207957 43275 1 0.173913043478261
564064 564064 221617 221617 43275 1 0.173913043478261
662256 662256 237330 237330 43275 1 0.174496644295302
699437 699437 249259 249259 43275 1 0.175824175824176
793651 793651 277007 277007 43275 1 0.173913043478261
925454 925454 328965 328965 43275 1 0.168
929778 929778 330991 330991 43275 4 0.452830188679245 
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)
);