consensus_index

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

13 rows where inventory_id = 201501

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
503522 503522 201501 201501 4755 8 0.258979497487312
503523 503523 201501 201501 44093 1 0.0431632495812186
503524 503524 201501 201501 46537 1 0.0369970710696159
503525 503525 201501 201501 136467 2 0.0915630794307812
503526 503526 201501 201501 151125 1 0.0647448743718279
503527 503527 201501 201501 185616 1 0.129489748743656
503528 503528 201501 201501 186907 1 0.0863264991624372
503529 503529 201501 201501 188009 1 0.0517958994974623
503530 503530 201501 201501 202869 1 0.032372437185914
503531 503531 201501 201501 205491 1 0.0287754997208124
503532 503532 201501 201501 205597 1 0.0258979497487312
503533 503533 201501 201501 208261 1 0.0517958994974623
503534 503534 201501 201501 261971 1 0.0863264991624372 
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)
);