consensus_index

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

12 rows where inventory_id = 19106

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
60137 60137 19106 19106 37783 5 0.155485129220176
60138 60138 19106 19106 129218 2 0.235671386205031
60139 60139 19106 19106 192689 3 0.0785571287350104
60140 60140 19106 19106 193636 3 0.235671386205031
60141 60141 19106 19106 196765 2 0.0445377056451693
60142 60142 19106 19106 197573 3 0.0546944837305659
60143 60143 19106 19106 228315 2 0.0251226541817162
60144 60144 19106 19106 233993 3 0.0392785643675052
60145 60145 19106 19106 234314 1 0.0235671386205031
60146 60146 19106 19106 249637 3 0.0421334970499572
60147 60147 19106 19106 287900 1 0.0261857095783368
60148 60148 19106 19106 320196 2 0.0314929136801896 
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)
);