consensus_index

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

13 rows where inventory_id = 37960

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
108255 108255 37960 37960 37649 4 0.137327489819414
108256 108256 37960 37960 49292 1 0.0202044751060905
108257 108257 37960 37960 114184 7 0.129752639068829
108258 108258 37960 37960 145363 3 0.165419082084169
108259 108259 37960 37960 165101 1 0.0707156628713168
108260 108260 37960 37960 212669 3 0.141431325742634
108261 108261 37960 37960 216908 1 0.0353578314356584
108262 108262 37960 37960 226605 1 0.0235718876237723
108263 108263 37960 37960 235012 1 0.031429183498363
108264 108264 37960 37960 258900 1 0.0282862651485267
108265 108265 37960 37960 277344 2 0.115478193904936
108266 108266 37960 37960 292410 2 0.0534560165013109
108267 108267 37960 37960 292426 2 0.038141192145471 
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)
);