consensus_index

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

13 rows where inchi_id = 33733

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1823 1823 461 461 33733 8 0.519685039370079
136228 136228 48297 48297 33733 1 0.241935483870968
185895 185895 66302 66302 33733 14 0.528497409326425
202204 202204 71703 71703 33733 8 0.519685039370079
257951 257951 87323 87323 33733 1 0.239130434782609
419116 419116 149762 149762 33733 4 0.506024096385542
419581 419581 150316 150316 33733 1 0.375
504591 504591 201830 201830 33733 1 0.239130434782609
504991 504991 202007 202007 33733 6 0.875
564503 564503 221760 221760 33733 8 0.519685039370079
577789 577789 226360 226360 33733 1 0.239130434782609
1641890 1641890 496843 496843 33733 7 0.888888888888889
1734328 1734328 531265 531265 33733 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)
);