consensus_index

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

20 rows where inchi_id = 56981

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
13985 13985 4294 4294 56981 1 0.173228346456693
13987 13987 4295 4295 56981 7 0.419570239965807
30451 30451 8872 8872 56981 1 0.173228346456693
42923 42923 13020 13020 56981 7 0.419570239965807
80674 80674 29096 29096 56981 1 0.173228346456693
80676 80676 29097 29097 56981 7 0.419570239965807
163449 163449 58513 58513 56981 1 0.175438596491228
163453 163453 58514 58514 56981 11 0.525
164267 164267 58855 58855 56981 1 0.148148148148148
242813 242813 82577 82577 56981 1 0.137931034482759
288545 288545 97715 97715 56981 7 0.395665457907095
370631 370631 126171 126171 56981 7 0.517241379310345
439838 439838 157676 157676 56981 1 0.172413793103448
716840 716840 253546 253546 56981 1 0.173228346456693
717454 717454 253765 253765 56981 7 0.419570239965807
820944 820944 285027 285027 56981 7 0.419570239965807
820947 820947 285028 285028 56981 4 0.373341713832489
893316 893316 313430 313430 56981 4 0.373341713832489
893548 893548 313546 313546 56981 1 0.168674698795181
1627452 1627452 491569 491569 56981 1 0.173228346456693 
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)
);