api_results

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

11 rows where query_id = 15851

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
33931 33931 15851 15851 PubChem (compound) 1 120399 120399 1
344104 344104 15851 15851 PubChem (substance) 2 7794 7794 8
344110 344110 15851 15851 PubChem (substance) 2 120399 120399 1
655173 655173 15851 15851 PubChem (substance) 2 230778 230778 3
655175 655175 15851 15851 PubChem (substance) 2 230995 230995 4
655178 655178 15851 15851 PubChem (substance) 2 7795 7795 2
655180 655180 15851 15851 PubChem (substance) 2 120399 120399 6
713741 713741 15851 15851 PubChem (substance) 2 183409 183409 5
713742 713742 15851 15851 PubChem (substance) 2 292588 292588 7
962902 962902 15851 15851 CAS Common Chemistry 3 7795 7795 1
1164209 1164209 15851 15851 Computational Toxicology and Exposure Data 4 120399 120399 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)
);