consensus_index

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

12 rows where inventory_id = 295032

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
852767 852767 295032 295032 8730 1 0.128884564660297
852768 852768 295032 295032 12669 3 0.0848877249137121
852769 852769 295032 295032 47694 2 0.128884564660297
852770 852770 295032 295032 83483 8 0.236375333800332
852771 852771 295032 295032 121344 1 0.0429615215534322
852772 852772 295032 295032 141771 1 0.0286410143689548
852773 852773 295032 295032 147176 2 0.07441153810101
852774 852774 295032 295032 164517 1 0.0515538258641186
852775 852775 295032 295032 181657 1 0.0515538258641186
852776 852776 295032 295032 233899 1 0.0322211411650742
852777 852777 295032 295032 242998 1 0.0429615215534322
852778 852778 295032 295032 332416 1 0.0859230431068644 
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)
);