consensus_index

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

10 rows where inchi_id = 147754

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3867 3867 1114 1114 147754 1 0.159513862514242
141158 141158 50326 50326 147754 1 0.159677136339709
200808 200808 71341 71341 147754 1 0.159090909090909
213721 213721 74361 74361 147754 2 0.15993907083016
424821 424821 153369 153369 147754 1 0.188003581020591
513313 513313 206110 206110 147754 1 0.189000994742078
513320 513320 206111 206111 147754 1 0.188003581020591
540501 540501 214156 214156 147754 1 0.188003581020591
665261 665261 238295 238295 147754 2 0.189907759088443
665268 665268 238296 238296 147754 1 0.188003581020591 
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)
);