consensus_index

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

11 rows where inventory_id = 52405

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
146579 146579 52405 52405 11086 2 0.0507722185077004
146580 146580 52405 52405 36039 1 0.189972246422238
146581 146581 52405 52405 54957 1 0.0633240821407459
146582 146582 52405 52405 55128 3 0.0829780216582686
146583 146583 52405 52405 67077 1 0.0474930616055595
146584 146584 52405 52405 120400 2 0.0775558448374583
146585 146585 52405 52405 121425 3 0.189972246422238
146586 146586 52405 52405 144789 1 0.0949861232111189
146587 146587 52405 52405 171468 1 0.0633240821407459
146588 146588 52405 52405 192211 1 0.0237465308027797
146589 146589 52405 52405 192381 4 0.106829244802469 
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)
);