consensus_index

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

18 rows where inventory_id = 280171

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
803603 803603 280171 280171 1614 3 0.0781499727075099
803604 803604 280171 280171 28063 7 0.144076270802919
803605 803605 280171 280171 28901 3 0.0809433785120605
803606 803606 280171 280171 97658 1 0.0163178202041289
803607 803607 280171 280171 120402 1 0.053032915663419
803608 803608 280171 280171 123863 2 0.212131662653676
803609 803609 280171 280171 142925 1 0.017677638554473
803610 803610 280171 280171 150434 1 0.0151522616181197
803611 803611 280171 280171 169894 1 0.0235701847392973
803612 803612 280171 280171 169899 1 0.0212131662653676
803613 803613 280171 280171 188249 1 0.053032915663419
803614 803614 280171 280171 199519 1 0.0424263325307352
803615 803615 280171 280171 201077 1 0.035355277108946
803616 803616 280171 280171 201205 1 0.0265164578317095
803617 803617 280171 280171 204874 1 0.0192846966048796
803618 803618 280171 280171 206121 1 0.0303045232362394
803619 803619 280171 280171 232061 1 0.053032915663419
803620 803620 280171 280171 263430 1 0.070710554217892 
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)
);