consensus_index

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

6 rows where inventory_id = 51287

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
143829 143829 51287 51287 4086 12 0.387096774193548
143830 143830 51287 51287 45728 2 0.129032258064516
143831 143831 51287 51287 137749 2 0.193548387096774
143832 143832 51287 51287 172538 1 0.0967741935483871
143833 143833 51287 51287 188344 1 0.0967741935483871
143834 143834 51287 51287 267084 1 0.0774193548387097 
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)
);