consensus_index

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

11 rows where inventory_id = 291254

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
839951 839951 291254 291254 60560 2 0.245603715638627
839952 839952 291254 291254 138974 2 0.122801857819313
839953 839953 291254 291254 152664 2 0.0549186603694498
839954 839954 291254 291254 158821 1 0.0409339526064378
839955 839955 291254 291254 176091 2 0.245603715638627
839956 839956 291254 291254 228366 2 0.0347336105625371
839957 839957 291254 291254 228556 1 0.0614009289096567
839958 839958 291254 291254 259791 2 0.0818679052128756
839959 839959 291254 291254 263311 1 0.0307004644548283
839960 839960 291254 291254 284322 1 0.0350862450912324
839961 839961 291254 291254 326627 2 0.033422432347014 
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)
);