consensus_index

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

9 rows where inventory_id = 267320

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
762170 762170 267320 267320 3797 3 0.210520968514402
762171 762171 267320 267320 73629 2 0.0382840674356205
762172 762172 267320 267320 92940 2 0.0593094222412959
762173 762173 267320 267320 139003 1 0.0442066332792585
762174 762174 267320 267320 139145 4 0.265239799675551
762175 762175 267320 267320 151583 1 0.088413266558517
762176 762176 267320 267320 170738 3 0.0469765576689173
762177 762177 267320 267320 200180 2 0.057880069491816
762178 762178 267320 267320 261537 2 0.132619899837776 
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)
);