consensus_index

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

14 rows where inventory_id = 283027

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
814308 814308 283027 283027 51218 1 0.0267902005105187
814309 814309 283027 283027 52206 7 0.267902005105187
814310 814310 283027 283027 75159 1 0.0446503341841978
814311 814311 283027 283027 83488 1 0.0334877506381483
814312 814312 283027 283027 107005 1 0.0297668894561319
814313 814313 283027 283027 136474 2 0.0691720002791975
814314 814314 283027 283027 137028 2 0.0378870649006701
814315 814315 283027 283027 168930 2 0.07733664738196
814316 814316 283027 283027 169031 2 0.133951002552593
814317 814317 283027 283027 169090 2 0.0315725540838918
814318 814318 283027 283027 177695 2 0.133951002552593
814319 814319 283027 283027 188233 1 0.0243547277368352
814320 814320 283027 283027 238191 2 0.0413381768492918
814321 814321 283027 283027 271865 1 0.0382717150150267 
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)
);