consensus_index

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

21 rows where inventory_id = 77191

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
223683 223683 77191 77191 4483 4 0.184278560691738
223684 223684 77191 77191 46096 1 0.0921392803458688
223685 223685 77191 77191 137447 2 0.0284347992409278
223686 223686 77191 77191 137756 1 0.0368557121383475
223687 223687 77191 77191 170823 3 0.0558093945750706
223688 223688 77191 77191 173452 1 0.0153565467243115
223689 223689 77191 77191 179884 1 0.0263255086702482
223690 223690 77191 77191 180017 3 0.0326375319392855
223691 223691 77191 77191 186700 1 0.0141752738993644
223692 223692 77191 77191 195269 4 0.184278560691738
223693 223693 77191 77191 207190 3 0.0507062000779276
223694 223694 77191 77191 208503 1 0.0141752738993644
223695 223695 77191 77191 220948 3 0.0481665420981493
223696 223696 77191 77191 227547 3 0.0558093945750706
223697 223697 77191 77191 228710 1 0.0167525964265216
223698 223698 77191 77191 232231 3 0.0218486392895169
223699 223699 77191 77191 241911 3 0.0232955559061704
223700 223700 77191 77191 242702 1 0.0307130934486229
223701 223701 77191 77191 265272 1 0.0230348200864672
223702 223702 77191 77191 277410 1 0.0230348200864672
223703 223703 77191 77191 309463 2 0.0179837460821917 
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)
);