consensus_index

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

8 rows where inchi_id = 30664

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19141 19141 5620 5620 30664 1 0.173228346456693
217103 217103 75341 75341 30664 1 0.137931034482759
230348 230348 78925 78925 30664 8 0.461538461538462
427099 427099 154013 154013 30664 1 0.172413793103448
733818 733818 258777 258777 30664 1 0.173228346456693
788989 788989 275564 275564 30664 8 0.461538461538462
957870 957870 344493 344493 30664 4 0.833333333333333
1621944 1621944 489752 489752 30664 8 0.461538461538462 
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)
);