consensus_index

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

10 rows where inchi_id = 197222

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
30328 30328 8815 8815 197222 1 0.157894736842105
165916 165916 59466 59466 197222 1 0.157894736842105
242231 242231 82348 82348 197222 2 0.130968719527853
439609 439609 157572 157572 197222 1 0.107290233837689
716228 716228 253385 253385 197222 2 0.131561079585355
819030 819030 284316 284316 197222 1 0.155844155844156
819035 819035 284317 284317 197222 1 0.157894736842105
892794 892794 313217 313217 197222 1 0.155844155844156
1627124 1627124 491426 491426 197222 1 0.157894736842105
1726850 1726850 528767 528767 197222 1 0.157894736842105 
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)
);