consensus_index

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

13 rows where inventory_id = 249773

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
701161 701161 249773 249773 37649 4 0.137327489819414
701162 701162 249773 249773 49292 1 0.0202044751060905
701163 701163 249773 249773 114184 7 0.129752639068829
701164 701164 249773 249773 145363 3 0.165419082084169
701165 701165 249773 249773 165101 1 0.0707156628713168
701166 701166 249773 249773 212669 3 0.141431325742634
701167 701167 249773 249773 216908 1 0.0353578314356584
701168 701168 249773 249773 226605 1 0.0235718876237723
701169 701169 249773 249773 235012 1 0.031429183498363
701170 701170 249773 249773 258900 1 0.0282862651485267
701171 701171 249773 249773 277344 2 0.115478193904936
701172 701172 249773 249773 292410 2 0.0534560165013109
701173 701173 249773 249773 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)
);