consensus_index

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

15 rows where inventory_id = 123543

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
363568 363568 123543 123543 50652 8 0.29192184252809
363569 363569 123543 123543 139799 1 0.0324357602808989
363570 363570 123543 123543 140506 2 0.0532973927270353
363571 363571 123543 123543 169331 1 0.0486536404213483
363572 363572 123543 123543 184416 3 0.0803253905325855
363573 363573 123543 123543 199629 1 0.029192184252809
363574 363574 123543 123543 200362 2 0.0260064647251402
363575 363575 123543 123543 216258 3 0.0884095319258822
363576 363576 123543 123543 224427 1 0.0243268202106742
363577 363577 123543 123543 228666 1 0.0194614561685393
363578 363578 123543 123543 233140 1 0.0265383493207355
363579 363579 123543 123543 243356 3 0.0521899934015526
363580 363580 123543 123543 259334 3 0.145960921264045
363581 363581 123543 123543 270291 2 0.0390096970877103
363582 363582 123543 123543 323958 3 0.0341616150827291 
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)
);