consensus_index

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

19 rows where inchi_id = 87540

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5207 5207 1553 1553 87540 12 0.483870967741935
5214 5214 1554 1554 87540 1 0.0963350785340314
19748 19748 5789 5789 87540 8 0.625
160267 160267 57626 57626 87540 14 0.64
186973 186973 66592 66592 87540 1 0.109826589595376
205353 205353 72794 72794 87540 12 0.483870967741935
205802 205802 72939 72939 87540 1 0.0960809102402023
218324 218324 75696 75696 87540 8 0.478260869565217
255700 255700 86769 86769 87540 1 0.215868235126046
427855 427855 154241 154241 87540 8 0.625
686906 686906 244978 244978 87540 1 0.188976377952756
735727 735727 259511 259511 87540 12 0.636363636363636
759374 759374 266527 266527 87540 4 0.656703184093677
759376 759376 266528 266528 87540 3 0.369635151137236
857698 857698 296681 296681 87540 4 0.6
857700 857700 296682 296682 87540 8 0.625
957058 957058 344099 344099 87540 4 0.6
1613481 1613481 487108 487108 87540 8 0.625
1718307 1718307 526254 526254 87540 4 0.6 
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)
);