consensus_index

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

16 rows where inventory_id = 87005

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
256517 256517 87005 87005 7370 4 0.101293101653854
256518 256518 87005 87005 11257 1 0.0190858779627546
256519 256519 87005 87005 138329 2 0.0620291033789526
256520 256520 87005 87005 138373 4 0.24811641351581
256521 256521 87005 87005 199481 1 0.0275684903906456
256522 256522 87005 87005 232836 4 0.101293101653854
256523 256523 87005 87005 248977 1 0.0413527355859684
256524 256524 87005 87005 249120 1 0.049623282703162
256525 256525 87005 87005 264578 2 0.033155950407546
256526 256526 87005 87005 264580 2 0.0226498260949815
256527 256527 87005 87005 276594 1 0.049623282703162
256528 256528 87005 87005 282131 2 0.0506465508269272
256529 256529 87005 87005 292097 1 0.024811641351581
256530 256530 87005 87005 292602 1 0.0310145516894763
256531 256531 87005 87005 326246 2 0.0249366378169881
256532 256532 87005 87005 334659 1 0.03544520193083 
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)
);