consensus_index

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

10 rows where inventory_id = 47434

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
133707 133707 47434 47434 15807 1 0.0461854192441054
133708 133708 47434 47434 19914 1 0.032989585174361
133709 133709 47434 47434 25786 2 0.115463548110264
133710 133710 47434 47434 42871 1 0.0288658870275659
133711 133711 47434 47434 46444 9 0.230927096220527
133712 133712 47434 47434 74731 1 0.0769756987401757
133713 133713 47434 47434 74750 1 0.0577317740551318
133714 133714 47434 47434 105470 2 0.0544300385657511
133715 133715 47434 47434 128948 3 0.230927096220527
133716 133716 47434 47434 163891 1 0.115463548110264 
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)
);