consensus_index

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

12 rows where inventory_id = 59622

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
166589 166589 59622 59622 5804 1 0.115393042451454
166590 166590 59622 59622 8184 2 0.133244408243913
166591 166591 59622 59622 115944 5 0.185261582227489
166592 166592 59622 59622 139097 1 0.0769286949676357
166593 166593 59622 59622 170571 2 0.103210674820788
166594 166594 59622 59622 181718 1 0.0576965212257268
166595 166595 59622 59622 205785 1 0.0329694407004153
166596 166596 59622 59622 216174 2 0.115393042451454
166597 166597 59622 59622 235042 1 0.0256428983225452
166598 166598 59622 59622 259310 1 0.0384643474838179
166599 166599 59622 59622 281886 2 0.0471090123122299
166600 166600 59622 59622 294889 1 0.0576965212257268 
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)
);