consensus_index

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

11 rows where inventory_id = 311146

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
889940 889940 311146 311146 60560 2 0.245603715638627
889941 889941 311146 311146 138974 2 0.122801857819313
889942 889942 311146 311146 152664 2 0.0549186603694498
889943 889943 311146 311146 158821 1 0.0409339526064378
889944 889944 311146 311146 176091 2 0.245603715638627
889945 889945 311146 311146 228366 2 0.0347336105625371
889946 889946 311146 311146 228556 1 0.0614009289096567
889947 889947 311146 311146 259791 2 0.0818679052128756
889948 889948 311146 311146 263311 1 0.0307004644548283
889949 889949 311146 311146 284322 1 0.0350862450912324
889950 889950 311146 311146 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)
);