consensus_index

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

10 rows where inventory_id = 295971

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
855651 855651 295971 295971 84774 4 0.229686814007275
855652 855652 295971 295971 169990 1 0.114843407003638
855653 855653 295971 295971 177715 1 0.0574217035018188
855654 855654 295971 295971 177721 4 0.229686814007275
855655 855655 295971 295971 184339 1 0.0328124020010393
855656 855656 295971 295971 203071 1 0.045937362801455
855657 855657 295971 295971 204274 1 0.0765622713357584
855658 855658 295971 295971 204345 1 0.0574217035018188
855659 855659 295971 295971 253845 2 0.0663048719482039
855660 855660 295971 295971 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)
);