consensus_index

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

15 rows where inchi_id = 58586

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31016 31016 9080 9080 58586 8 0.371272832959494
198173 198173 70472 70472 58586 1 0.0251133599469611
209924 209924 73910 73910 58586 1 0.0315356855948081
244373 244373 83170 83170 58586 8 0.371272832959494
350013 350013 118255 118255 58586 1 0.20625
422489 422489 153119 153119 58586 1 0.0315356855948081
433172 433172 155758 155758 58586 1 0.258620689655172
440664 440664 157988 157988 58586 8 0.519685039370079
478830 478830 174912 174912 58586 1 0.1875
712695 712695 252547 252547 58586 1 0.0251133599469611
796165 796165 277823 277823 58586 1 0.20625
813773 813773 282914 282914 58586 1 0.0315356855948081
822289 822289 285515 285515 58586 5 0.340909090909091
822293 822293 285516 285516 58586 8 0.371272832959494
1628381 1628381 491945 491945 58586 8 0.371272832959494 
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)
);