api_results

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

11 rows where query_id = 31288

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
65478 65478 31288 31288 PubChem (compound) 1 222785 222785 1
65479 65479 31288 31288 PubChem (compound) 1 142199 142199 2
65481 65481 31288 31288 PubChem (compound) 1 228097 228097 3
65482 65482 31288 31288 PubChem (compound) 1 110087 110087 4
389040 389040 31288 31288 PubChem (substance) 2 222785 222785 1
389042 389042 31288 31288 PubChem (substance) 2 142199 142199 2
389047 389047 31288 31288 PubChem (substance) 2 228097 228097 3
389052 389052 31288 31288 PubChem (substance) 2 110087 110087 5
670060 670060 31288 31288 PubChem (substance) 2 12286 12286 4
986387 986387 31288 31288 CAS Common Chemistry 3 12746 12746 1
1189330 1189330 31288 31288 Computational Toxicology and Exposure Data 4 110087 110087 1 
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);