api_results

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

19 rows where query_id = 366225

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
7391 7391 366225 366225 PubChem (compound) 1 60355 60355 1
305561 305561 366225 366225 PubChem (substance) 2 2054 2054 16
305744 305744 366225 366225 PubChem (substance) 2 60355 60355 1
309872 309872 366225 366225 PubChem (substance) 2 63043 63043 10
341496 341496 366225 366225 PubChem (substance) 2 4065 4065 11
351413 351413 366225 366225 PubChem (substance) 2 51044 51044 3
646681 646681 366225 366225 PubChem (substance) 2 149874 149874 6
671615 671615 366225 366225 PubChem (substance) 2 120281 120281 12
697788 697788 366225 366225 PubChem (substance) 2 255399 255399 14
697841 697841 366225 366225 PubChem (substance) 2 296183 296183 2
697844 697844 366225 366225 PubChem (substance) 2 204914 204914 4
697847 697847 366225 366225 PubChem (substance) 2 147746 147746 5
697850 697850 366225 366225 PubChem (substance) 2 169840 169840 7
697853 697853 366225 366225 PubChem (substance) 2 192411 192411 8
697857 697857 366225 366225 PubChem (substance) 2 220244 220244 9
697860 697860 366225 366225 PubChem (substance) 2 208139 208139 13
697862 697862 366225 366225 PubChem (substance) 2 253780 253780 15
943587 943587 366225 366225 CAS Common Chemistry 3 60355 60355 1
1141256 1141256 366225 366225 Computational Toxicology and Exposure Data 4 60355 60355 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)
);