consensus_index

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

10 rows where inventory_id = 8062

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27765 27765 8062 8062 146 1 0.0607875577933222
27766 27766 8062 8062 34921 1 0.0434196841380873
27767 27767 8062 8062 40664 2 0.0679625557060328
27768 27768 8062 8062 43676 7 0.174826547115992
27769 27769 8062 8062 47712 1 0.0506562981611019
27770 27770 8062 8062 62774 2 0.0305468971397718
27771 27771 8062 8062 129129 1 0.303937788966611
27772 27772 8062 8062 136255 3 0.146118048512426
27773 27773 8062 8062 231208 3 0.070537712369019
27774 27774 8062 8062 263573 1 0.0379922236208264 
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)
);