consensus_index

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

11 rows where inventory_id = 532842

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1739708 1739708 532842 532842 60560 4 0.256584124221036
1739709 1739709 532842 532842 138974 3 0.161637869587462
1739710 1739710 532842 532842 152664 3 0.0750256530566121
1739711 1739711 532842 532842 158821 1 0.0427640207035059
1739712 1739712 532842 532842 176091 3 0.177905495348039
1739713 1739713 532842 532842 228366 2 0.0362864748363011
1739714 1739714 532842 532842 228556 2 0.0641460310552589
1739715 1739715 532842 532842 259791 3 0.0721371439219544
1739716 1739716 532842 532842 263311 1 0.0320730155276294
1739717 1739717 532842 532842 284322 1 0.0366548748887194
1739718 1739718 532842 532842 326627 2 0.0349166766911351 
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)
);