consensus_index

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

16 rows where inventory_id = 243909

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
682992 682992 243909 243909 7370 4 0.101293101653854
682993 682993 243909 243909 11257 1 0.0190858779627546
682994 682994 243909 243909 138329 2 0.0620291033789526
682995 682995 243909 243909 138373 4 0.24811641351581
682996 682996 243909 243909 199481 1 0.0275684903906456
682997 682997 243909 243909 232836 4 0.101293101653854
682998 682998 243909 243909 248977 1 0.0413527355859684
682999 682999 243909 243909 249120 1 0.049623282703162
683000 683000 243909 243909 264578 2 0.033155950407546
683001 683001 243909 243909 264580 2 0.0226498260949815
683002 683002 243909 243909 276594 1 0.049623282703162
683003 683003 243909 243909 282131 2 0.0506465508269272
683004 683004 243909 243909 292097 1 0.024811641351581
683005 683005 243909 243909 292602 1 0.0310145516894763
683006 683006 243909 243909 326246 2 0.0249366378169881
683007 683007 243909 243909 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)
);