consensus_index

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

19 rows where inventory_id = 393722

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1172512 1172512 393722 393722 139026 2 0.0569132642536669
1172513 1172513 393722 393722 170075 1 0.0301828163199224
1172514 1172514 393722 393722 170076 2 0.0328588884373149
1172515 1172515 393722 393722 181710 2 0.0697042285088328
1172516 1172516 393722 393722 181711 1 0.0482925061118758
1172517 1172517 393722 393722 195833 1 0.0219511391417617
1172518 1172518 393722 393722 199497 2 0.0162425275076797
1172519 1172519 393722 393722 229165 2 0.170739792761001
1172520 1172520 393722 393722 231498 2 0.170739792761001
1172521 1172521 393722 393722 231998 1 0.0603656326398447
1172522 1172522 393722 393722 240978 2 0.028860292460685
1172523 1172523 393722 393722 243721 2 0.0187978325095046
1172524 1172524 393722 393722 246033 1 0.0185740408122599
1172525 1172525 393722 393722 270490 1 0.0268291700621532
1172526 1172526 393722 393722 284740 1 0.0201218775466149
1172527 1172527 393722 393722 308111 2 0.0204073085059773
1172528 1172528 393722 393722 320288 2 0.0408146170119547
1172529 1172529 393722 393722 333098 1 0.0301828163199224
1172530 1172530 393722 393722 334341 2 0.0174260571272082 
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)
);