api_results

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

16 rows where query_id = 13944

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
28790 28790 13944 13944 PubChem (compound) 1 705 705 1
300875 300875 13944 13944 PubChem (substance) 2 46139 46139 12
336606 336606 13944 13944 PubChem (substance) 2 705 705 1
342015 342015 13944 13944 PubChem (substance) 2 5245 5245 8
365577 365577 13944 13944 PubChem (substance) 2 26713 26713 10
490172 490172 13944 13944 PubChem (substance) 2 75709 75709 3
497775 497775 13944 13944 PubChem (substance) 2 15280 15280 4
512880 512880 13944 13944 PubChem (substance) 2 43514 43514 2
516190 516190 13944 13944 PubChem (substance) 2 49851 49851 7
568887 568887 13944 13944 PubChem (substance) 2 47282 47282 9
692225 692225 13944 13944 PubChem (substance) 2 158359 158359 5
692227 692227 13944 13944 PubChem (substance) 2 158539 158539 6
692242 692242 13944 13944 PubChem (substance) 2 143835 143835 11
692254 692254 13944 13944 PubChem (substance) 2 144527 144527 13
959312 959312 13944 13944 CAS Common Chemistry 3 705 705 1
1159824 1159824 13944 13944 Computational Toxicology and Exposure Data 4 705 705 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)
);