consensus_index

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

16 rows where inchi_id = 190420

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
38152 38152 11475 11475 190420 1 0.0342096514236818
108611 108611 38078 38078 190420 1 0.0342096514236818
147999 147999 53274 53274 190420 1 0.0333698226669585
273276 273276 92694 92694 190420 1 0.0342096514236818
300112 300112 101633 101633 190420 2 0.130718954248366
505032 505032 202018 202018 190420 1 0.0342096514236818
563455 563455 221425 221425 190420 1 0.0342096514236818
669084 669084 239698 239698 190420 2 0.123373336489087
700095 700095 249447 249447 190420 1 0.0342096514236818
794539 794539 277291 277291 190420 1 0.0342096514236818
794551 794551 277292 277292 190420 1 0.0436888383843956
915326 915326 324260 324260 190420 1 0.0435795669875587
916557 916557 324877 324877 190420 1 0.139211136890951
1642600 1642600 497099 497099 190420 1 0.0342096514236818
1654564 1654564 501324 501324 190420 2 0.123373336489087
1734723 1734723 531377 531377 190420 1 0.0342096514236818 
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)
);