consensus_index

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

17 rows where inventory_id = 12970

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
42716 42716 12970 12970 50326 2 0.0359475245324785
42717 42717 12970 12970 56291 3 0.059906956992124
42718 42718 12970 12970 57871 2 0.025779305853581
42719 42719 12970 12970 140172 3 0.146640657931703
42720 42720 12970 12970 173831 3 0.0827964854475309
42721 42721 12970 12970 216127 5 0.0891838191526423
42722 42722 12970 12970 225333 3 0.076256215091356
42723 42723 12970 12970 228468 2 0.0470663577761042
42724 42724 12970 12970 234775 2 0.0306561519261412
42725 42725 12970 12970 256622 1 0.0305024860365424
42726 42726 12970 12970 256950 2 0.0470663577761042
42727 42727 12970 12970 264581 2 0.048228665086478
42728 42728 12970 12970 264648 2 0.0211496687372842
42729 42729 12970 12970 284268 2 0.152512430182712
42730 42730 12970 12970 320444 1 0.0203349906910283
42731 42731 12970 12970 330618 2 0.0197718250264847
42732 42732 12970 12970 334232 2 0.0185632218468896 
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)
);