consensus_index

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

13 rows where inventory_id = 87071

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
257131 257131 87071 87071 105953 3 0.105175124408901
257132 257132 87071 87071 109796 2 0.0551273604358953
257133 257133 87071 87071 137608 1 0.0689092005448691
257134 257134 87071 87071 181578 2 0.194904651965683
257135 257135 87071 87071 181647 2 0.194904651965683
257136 257136 87071 87071 184608 2 0.0329448991750355
257137 257137 87071 87071 199505 1 0.0344546002724346
257138 257138 87071 87071 214350 1 0.0459394670299127
257139 257139 87071 87071 217295 1 0.0229697335149564
257140 257140 87071 87071 263249 1 0.0344546002724346
257141 257141 87071 87071 287924 2 0.0520904593388572
257142 257142 87071 87071 308140 2 0.0375094177595657
257143 257143 87071 87071 329381 1 0.0250578911072251 
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)
);