api_results

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

10 rows where query_id = 30094

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
645848 645848 30094 30094 PubChem (substance) 2 315685 315685 4
730188 730188 30094 30094 PubChem (substance) 2 317421 317421 1
730191 730191 30094 30094 PubChem (substance) 2 315492 315492 2
730198 730198 30094 30094 PubChem (substance) 2 332636 332636 3
730199 730199 30094 30094 PubChem (substance) 2 317145 317145 5
730203 730203 30094 30094 PubChem (substance) 2 317911 317911 6
730209 730209 30094 30094 PubChem (substance) 2 321437 321437 7
730212 730212 30094 30094 PubChem (substance) 2 278137 278137 8
984666 984666 30094 30094 CAS Common Chemistry 3 7535 7535 1
1187609 1187609 30094 30094 Computational Toxicology and Exposure Data 4 135238 135238 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)
);