consensus_index

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

9 rows where inventory_id = 315550

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
897807 897807 315550 315550 3978 1 0.0623706237205563
897808 897808 315550 315550 71111 2 0.176410763918559
897809 897809 315550 315550 106084 1 0.249482494882225
897810 897810 315550 315550 140900 1 0.049896498976445
897811 897811 315550 315550 160792 1 0.0356403564117464
897812 897812 315550 315550 185928 2 0.249482494882225
897813 897813 315550 315550 186367 1 0.0415804158137042
897814 897814 315550 315550 204846 1 0.0831608316274084
897815 897815 315550 315550 223748 1 0.0311853118602781 
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)
);