consensus_index

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

10 rows where inventory_id = 73894

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
209812 209812 73894 73894 24229 1 0.0558971287418964
209813 209813 73894 73894 39957 1 0.0670765544902757
209814 209814 73894 73894 51342 9 0.270172392258864
209815 209815 73894 73894 56959 1 0.0558971287418964
209816 209816 73894 73894 56960 1 0.0670765544902757
209817 209817 73894 73894 68374 1 0.0419228465564223
209818 209818 73894 73894 68382 2 0.167691386225689
209819 209819 73894 73894 84981 1 0.0838456931128447
209820 209820 73894 73894 173564 2 0.111794257483793
209821 209821 73894 73894 178059 2 0.0633813864229794 
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)
);