consensus_index

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

12 rows where inventory_id = 103319

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
305718 305718 103319 103319 6291 2 0.212595872341691
305719 305719 103319 103319 39758 1 0.106297936170845
305720 305720 103319 103319 111453 1 0.0265744840427113
305721 305721 103319 103319 140974 2 0.212595872341691
305722 305722 103319 103319 180163 2 0.0751639914925395
305723 305723 103319 103319 181706 1 0.0425191744683381
305724 305724 103319 103319 190118 1 0.0354326453902818
305725 305725 103319 103319 201286 4 0.0482149674893242
305726 305726 103319 103319 220268 2 0.0548920182034537
305727 305727 103319 103319 261465 1 0.0212595872341691
305728 305728 103319 103319 263369 1 0.0531489680854226
305729 305729 103319 103319 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)
);