consensus_index

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

11 rows where inventory_id = 486021

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1609901 1609901 486021 486021 8748 3 0.273537405029922
1609902 1609902 486021 486021 59839 1 0.0273537405029922
1609903 1609903 486021 486021 67519 5 0.191155356633315
1609904 1609904 486021 486021 101554 3 0.0526793867579757
1609905 1609905 486021 486021 136302 3 0.0698714311956283
1609906 1609906 486021 486021 167483 3 0.0948301218670562
1609907 1609907 486021 486021 168939 3 0.0828417419316228
1609908 1609908 486021 486021 208534 2 0.0407765488023866
1609909 1609909 486021 486021 231215 2 0.0394817236068643
1609910 1609910 486021 486021 274980 2 0.0789634472137286
1609911 1609911 486021 486021 294505 1 0.0390767721471317 
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)
);