api_results

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

10 rows where query_id = 125985

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
146027 146027 125985 125985 PubChem (compound) 1 20530 20530 1
478712 478712 125985 125985 PubChem (substance) 2 31906 31906 2
500083 500083 125985 125985 PubChem (substance) 2 20530 20530 1
777491 777491 125985 125985 PubChem (substance) 2 195673 195673 6
777510 777510 125985 125985 PubChem (substance) 2 138446 138446 5
789460 789460 125985 125985 PubChem (substance) 2 228318 228318 3
789462 789462 125985 125985 PubChem (substance) 2 233665 233665 4
789463 789463 125985 125985 PubChem (substance) 2 239061 239061 7
1044663 1044663 125985 125985 CAS Common Chemistry 3 20530 20530 1
1247553 1247553 125985 125985 Computational Toxicology and Exposure Data 4 20530 20530 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)
);