consensus_index

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

10 rows where inventory_id = 27432

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
76549 76549 27432 27432 48177 6 0.236309077269317
76550 76550 27432 27432 100981 2 0.236309077269317
76551 76551 27432 27432 160120 2 0.118154538634659
76552 76552 27432 27432 160897 1 0.0787696924231058
76553 76553 27432 27432 199468 1 0.0590772693173293
76554 76554 27432 27432 201292 1 0.0787696924231058
76555 76555 27432 27432 204114 1 0.0472618154538635
76556 76556 27432 27432 205929 1 0.0337584396099025
76557 76557 27432 27432 205958 1 0.0393848462115529
76558 76558 27432 27432 320383 1 0.0590772693173293 
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)
);