consensus_index

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

17 rows where inchi_id = 78272

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17951 17951 5261 5261 78272 8 0.9
22087 22087 6505 6505 78272 1 0.0131720310355599
119366 119366 41553 41553 78272 1 0.0131720310355599
131583 131583 46698 46698 78272 2 0.0122198063506605
215612 215612 74902 74902 78272 7 0.517241379310345
221097 221097 76522 76522 78272 1 0.02579274155636
426143 426143 153737 153737 78272 7 0.517241379310345
429863 429863 154827 154827 78272 1 0.02579274155636
516772 516772 206974 206974 78272 1 0.02579274155636
597511 597511 235432 235432 78272 1 0.02579274155636
671904 671904 240444 240444 78272 2 0.0122198063506605
731590 731590 258022 258022 78272 8 0.9
743230 743230 261666 261666 78272 1 0.0131720310355599
850036 850036 294101 294101 78272 4 0.833333333333333
850037 850037 294102 294102 78272 8 0.9
850038 850038 294103 294103 78272 4 0.833333333333333
1611613 1611613 486505 486505 78272 7 0.888888888888889 
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)
);