consensus_index

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

12 rows where inventory_id = 60016

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
168188 168188 60016 60016 37308 3 0.148289334587618
168189 168189 60016 60016 109432 1 0.0356450381816939
168190 168190 60016 60016 117380 5 0.324166649315335
168191 168191 60016 60016 138645 1 0.0427740458180327
168192 168192 60016 60016 185126 2 0.0823186895579019
168193 168193 60016 60016 199617 1 0.0329031121677175
168194 168194 60016 60016 200546 1 0.0305528898700234
168195 168195 60016 60016 216269 4 0.102777965520292
168196 168196 60016 60016 258934 1 0.0388854961982115
168197 168197 60016 60016 261460 1 0.0611057797400467
168198 168198 60016 60016 309964 1 0.0285160305453551
168199 168199 60016 60016 332996 1 0.0534675572725409 
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)
);