consensus_index

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

12 rows where inventory_id = 57196

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
158900 158900 57196 57196 40954 3 0.0943641958280258
158901 158901 57196 57196 47694 1 0.0412173590229569
158902 158902 57196 57196 62810 1 0.0618260385344354
158903 158903 57196 57196 84937 1 0.0494608308275483
158904 158904 57196 57196 84938 3 0.136096720885374
158905 158905 57196 57196 120062 2 0.0713905599815689
158906 158906 57196 57196 122692 1 0.0494608308275483
158907 158907 57196 57196 135065 6 0.196285437217178
158908 158908 57196 57196 182723 3 0.196285437217178
158909 158909 57196 57196 199698 1 0.0353291648768202
158910 158910 57196 57196 229299 1 0.0309130192672177
158911 158911 57196 57196 231149 1 0.0274782393486379 
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)
);