consensus_index

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

15 rows where inventory_id = 418100

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1270245 1270245 418100 418100 30575 8 0.270162403645047
1270246 1270246 418100 418100 46499 2 0.110293339435698
1270247 1270247 418100 418100 63043 1 0.135081201822523
1270248 1270248 418100 418100 120237 1 0.0192973145460748
1270249 1270249 418100 418100 139934 1 0.0900541345483488
1270250 1270250 418100 418100 216509 1 0.0540324807290093
1270251 1270251 418100 418100 256376 1 0.0385946290921495
1270252 1270252 418100 418100 256829 1 0.0675406009112616
1270253 1270253 418100 418100 274146 1 0.0270162403645047
1270254 1270254 418100 418100 274224 1 0.0450270672741744
1270255 1270255 418100 418100 274347 1 0.0300180448494496
1270256 1270256 418100 418100 288980 1 0.0245602185131861
1270257 1270257 418100 418100 289755 1 0.0225135336370872
1270258 1270258 418100 418100 322818 1 0.0337703004556308
1270259 1270259 418100 418100 322830 1 0.0207817233573113 
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)
);