consensus_index

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

10 rows where inchi_id = 48342

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
126795 126795 45304 45304 48342 1 0.0661000944287063
282812 282812 95910 95910 48342 6 0.329762318147457
556136 556136 219152 219152 48342 6 0.329762318147457
561114 561114 220665 220665 48342 1 0.0657894736842105
798573 798573 278572 278572 48342 1 0.0657894736842105
798579 798579 278573 278573 48342 1 0.065359477124183
798585 798585 278574 278574 48342 1 0.065359477124183
1646604 1646604 498569 498569 48342 4 0.322268255627982
1679793 1679793 510255 510255 48342 1 0.0659563673262303
1754711 1754711 537711 537711 48342 1 0.0657894736842105 
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)
);