consensus_index

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

12 rows where inventory_id = 15198

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
49514 49514 15198 15198 6291 2 0.212595872341691
49515 49515 15198 15198 39758 1 0.106297936170845
49516 49516 15198 15198 111453 1 0.0265744840427113
49517 49517 15198 15198 140974 2 0.212595872341691
49518 49518 15198 15198 180163 2 0.0751639914925395
49519 49519 15198 15198 181706 1 0.0425191744683381
49520 49520 15198 15198 190118 1 0.0354326453902818
49521 49521 15198 15198 201286 4 0.0482149674893242
49522 49522 15198 15198 220268 2 0.0548920182034537
49523 49523 15198 15198 261465 1 0.0212595872341691
49524 49524 15198 15198 263369 1 0.0531489680854226
49525 49525 15198 15198 276716 1 0.0354326453902818 
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)
);