consensus_index

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

10 rows where inventory_id = 154880

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
430032 430032 154880 154880 2302 1 0.0359567989990503
430033 430033 154880 154880 2592 1 0.0809027977478632
430034 430034 154880 154880 2595 8 0.323611190991453
430035 430035 154880 154880 2596 2 0.0835560502237496
430036 430036 154880 154880 57816 2 0.161805595495726
430037 430037 154880 154880 65121 1 0.0404513988739316
430038 430038 154880 154880 138170 1 0.0647222381982906
430039 430039 154880 154880 139790 1 0.0462301701416361
430040 430040 154880 154880 170918 1 0.0539351984985755
430041 430041 154880 154880 266944 2 0.0934185041158453 
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)
);