consensus_index

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

20 rows where inchi_id = 77735

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6038 6038 1848 1848 77735 1 0.0939759036144578
116519 116519 40630 40630 77735 8 0.396600566572238
130759 130759 46507 46507 77735 1 0.1875
156216 156216 56168 56168 77735 1 0.0810007504173897
221777 221777 76718 76718 77735 1 0.0939759036144578
247773 247773 84317 84317 77735 8 0.396600566572238
405677 405677 142018 142018 77735 1 0.191489361702128
441942 441942 158427 158427 77735 8 0.357462190372524
495996 495996 189086 189086 77735 1 0.1875
517380 517380 207112 207112 77735 1 0.0939759036144578
536464 536464 212910 212910 77735 8 0.396600566572238
593015 593015 231162 231162 77735 1 0.0939759036144578
597871 597871 235514 235514 77735 1 0.0939759036144578
672964 672964 240716 240716 77735 1 0.0946196660482375
731126 731126 257858 257858 77735 8 0.396600566572238
745327 745327 262239 262239 77735 1 0.0939759036144578
849201 849201 293779 293779 77735 8 0.396600566572238
849207 849207 293780 293780 77735 6 0.394736842105263
951530 951530 341372 341372 77735 1 0.1875
1630591 1630591 492769 492769 77735 8 0.396600566572238 
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)
);