home / zeropm-v0-0-4

consensus_index

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

15 rows where inventory_id = 77785

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
225629 225629 77785 77785 7044 8 0.265330943181628
225630 225630 77785 77785 74757 2 0.132665471590814
225631 225631 77785 77785 169198 2 0.0419525057087334
225632 225632 77785 77785 188529 1 0.0884436477272094
225633 225633 77785 77785 188530 1 0.0241209948346935
225634 225634 77785 77785 190419 1 0.066332735795407
225635 225635 77785 77785 224628 2 0.026017839554675
225636 225636 77785 77785 230850 1 0.0379044204545183
225637 225637 77785 77785 232013 1 0.0530661886363256
225638 225638 77785 77785 232038 1 0.0442218238636047
225639 225639 77785 77785 232136 1 0.0331663678977035
225640 225640 77785 77785 256433 1 0.0530661886363256
225641 225641 77785 77785 277407 2 0.0510629638234168
225642 225642 77785 77785 292073 2 0.0289499793177104
225643 225643 77785 77785 307903 1 0.0442218238636047
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)
);
Powered by Datasette · Queries took 2470.699ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website