consensus_index

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

13 rows where inchi_id = 123789

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17461 17461 5118 5118 123789 2 0.384615384615385
102625 102625 36155 36155 123789 2 0.384615384615385
187949 187949 66899 66899 123789 4 0.295566502463054
214663 214663 74627 74627 123789 2 0.292682926829268
425442 425442 153550 153550 123789 2 0.292682926829268
513848 513848 206266 206266 123789 2 0.292682926829268
513853 513853 206267 206267 123789 2 0.292682926829268
729711 729711 257462 257462 123789 2 0.384615384615385
845870 845870 292975 292975 123789 2 0.378378378378378
845873 845873 292976 292976 123789 2 0.384615384615385
845876 845876 292977 292977 123789 2 0.384615384615385
893281 893281 313412 313412 123789 1 0.375
1610953 1610953 486287 486287 123789 2 0.384615384615385 
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)
);