consensus_index

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

20 rows where inventory_id = 153078

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
422088 422088 153078 153078 49226 8 0.265731269625475
422089 422089 153078 153078 137106 2 0.132865634812737
422090 422090 153078 153078 145414 1 0.0204408668942673
422091 422091 153078 153078 150909 1 0.0332164087031843
422092 422092 153078 153078 153093 1 0.0379616099464964
422093 422093 153078 153078 170699 2 0.0626334609084947
422094 422094 153078 153078 170703 2 0.0485156702027866
422095 422095 153078 153078 176509 1 0.0332164087031843
422096 422096 153078 153078 180069 1 0.0295256966250527
422097 422097 153078 153078 190092 1 0.0189808049732482
422098 422098 153078 153078 192055 2 0.0449167826276761
422099 422099 153078 153078 195363 1 0.0241573881477704
422100 422100 153078 153078 200073 1 0.0221442724687896
422101 422101 153078 153078 200687 1 0.0265731269625475
422102 422102 153078 153078 215544 2 0.0322246497851564
422103 422103 153078 153078 241143 1 0.0295256966250527
422104 422104 153078 153078 242127 2 0.0216968673094784
422105 422105 153078 153078 250904 1 0.0147628483125264
422106 422106 153078 153078 254605 2 0.0767100100251844
422107 422107 153078 153078 262638 1 0.0166082043515922 
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)
);