consensus_index

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

9 rows where inventory_id = 1432

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4678 4678 1432 1432 8247 6 0.252798153579433
4679 4679 1432 1432 92901 13 0.204243988821043
4680 4680 1432 1432 146398 1 0.0631995383948582
4681 4681 1432 1432 160196 12 0.187534866007312
4682 4682 1432 1432 216104 1 0.0842660511931442
4683 4683 1432 1432 251310 1 0.0505596307158865
4684 4684 1432 1432 270491 1 0.0631995383948582
4685 4685 1432 1432 270547 1 0.0361140219399189
4686 4686 1432 1432 276739 2 0.0516022070156122 
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)
);