consensus_index

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

10 rows where inventory_id = 158642

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
442593 442593 158642 158642 84774 4 0.229686814007275
442594 442594 158642 158642 169990 1 0.114843407003638
442595 442595 158642 158642 177715 1 0.0574217035018188
442596 442596 158642 158642 177721 4 0.229686814007275
442597 442597 158642 158642 184339 1 0.0328124020010393
442598 442598 158642 158642 203071 1 0.045937362801455
442599 442599 158642 158642 204274 1 0.0765622713357584
442600 442600 158642 158642 204345 1 0.0574217035018188
442601 442601 158642 158642 253845 2 0.0663048719482039
442602 442602 158642 158642 294901 1 0.0765622713357584 
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)
);