consensus_index

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

13 rows where inchi_id = 30458

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
74098 74098 25581 25581 30458 1 0.214285714285714
173209 173209 61871 61871 30458 12 0.549515642478265
197544 197544 70172 70172 30458 2 0.216068290949324
269147 269147 91247 91247 30458 8 0.534690026059609
405619 405619 141990 141990 30458 2 0.216068290949324
450281 450281 161519 161519 30458 7 0.888888888888889
535046 535046 212300 212300 30458 2 0.216068290949324
732792 732792 258426 258426 30458 1 0.214285714285714
851857 851857 294744 294744 30458 1 0.214285714285714
851860 851860 294745 294745 30458 2 0.216068290949324
1640518 1640518 496312 496312 30458 8 0.9
1733708 1733708 531046 531046 30458 8 0.9
1762768 1762768 541505 541505 30458 1 0.214285714285714 
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)
);