consensus_index

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

20 rows where inventory_id = 73817

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
209229 209229 73817 73817 49226 8 0.265731269625475
209230 209230 73817 73817 137106 2 0.132865634812737
209231 209231 73817 73817 145414 1 0.0204408668942673
209232 209232 73817 73817 150909 1 0.0332164087031843
209233 209233 73817 73817 153093 1 0.0379616099464964
209234 209234 73817 73817 170699 2 0.0626334609084947
209235 209235 73817 73817 170703 2 0.0485156702027866
209236 209236 73817 73817 176509 1 0.0332164087031843
209237 209237 73817 73817 180069 1 0.0295256966250527
209238 209238 73817 73817 190092 1 0.0189808049732482
209239 209239 73817 73817 192055 2 0.0449167826276761
209240 209240 73817 73817 195363 1 0.0241573881477704
209241 209241 73817 73817 200073 1 0.0221442724687896
209242 209242 73817 73817 200687 1 0.0265731269625475
209243 209243 73817 73817 215544 2 0.0322246497851564
209244 209244 73817 73817 241143 1 0.0295256966250527
209245 209245 73817 73817 242127 2 0.0216968673094784
209246 209246 73817 73817 250904 1 0.0147628483125264
209247 209247 73817 73817 254605 2 0.0767100100251844
209248 209248 73817 73817 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)
);