consensus_index

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

8 rows where inventory_id = 8729

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30078 30078 8729 8729 12854 1 0.0663980174132694
30079 30079 8729 8729 12855 1 0.049798513059952
30080 30080 8729 8729 41970 1 0.132796034826539
30081 30081 8729 8729 54380 9 0.341515805405392
30082 30082 8729 8729 62727 1 0.0995970261199041
30083 30083 8729 8729 73281 1 0.132796034826539
30084 30084 8729 8729 73566 2 0.0752882749813916
30085 30085 8729 8729 154055 1 0.0796776208959233 
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)
);