consensus_index

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

11 rows where inventory_id = 386262

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1137302 1137302 386262 386262 60560 4 0.24779182388196
1137303 1137303 386262 386262 138974 3 0.12389591194098
1137304 1137304 386262 386262 152664 3 0.0632950706369159
1137305 1137305 386262 386262 158821 1 0.0412986373136599
1137306 1137306 386262 386262 176091 4 0.24779182388196
1137307 1137307 386262 386262 228366 2 0.0350430557979033
1137308 1137308 386262 386262 228556 2 0.0619479559704899
1137309 1137309 386262 386262 259791 3 0.069665239485581
1137310 1137310 386262 386262 263311 1 0.030973977985245
1137311 1137311 386262 386262 284322 1 0.0353988319831371
1137312 1137312 386262 386262 326627 2 0.0337201961635776 
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)
);