consensus_index

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

11 rows where inchi_id = 50497

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
351841 351841 118957 118957 50497 1 0.0252587911611894
438242 438242 157075 157075 50497 7 0.290983395478421
474963 474963 172784 172784 50497 3 0.375
481588 481588 176735 176735 50497 1 0.31304347826087
482467 482467 177305 177305 50497 1 0.265968166812176
483031 483031 177699 177699 50497 1 0.599254417849115
489022 489022 182677 182677 50497 1 0.599254417849115
496236 496236 189445 189445 50497 1 0.599254417849115
711068 711068 252181 252181 50497 9 0.187963101351196
906507 906507 319942 319942 50497 4 0.296660149118645
1725973 1725973 528473 528473 50497 4 0.296660149118645 
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)
);