consensus_index

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

11 rows where inchi_id = 74642

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
178892 178892 63779 63779 74642 6 0.875
421187 421187 152596 152596 74642 4 0.833333333333333
460085 460085 165407 165407 74642 8 0.9
525265 525265 209201 209201 74642 7 0.888888888888889
540051 540051 214009 214009 74642 7 0.888888888888889
668878 668878 239645 239645 74642 1 0.157894736842105
737064 737064 259905 259905 74642 4 0.833333333333333
737394 737394 260014 260014 74642 1 0.157894736842105
737399 737399 260015 260015 74642 1 0.157894736842105
926182 926182 329326 329326 74642 4 0.833333333333333
929028 929028 330548 330548 74642 1 0.155844155844156 
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)
);