api_results

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

14 rows where query_id = 33543

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
69462 69462 33543 33543 PubChem (compound) 1 121932 121932 1
69465 69465 33543 33543 PubChem (compound) 1 212272 212272 2
69467 69467 33543 33543 PubChem (compound) 1 121932 121932 3
69468 69468 33543 33543 PubChem (compound) 1 230845 230845 4
69469 69469 33543 33543 PubChem (compound) 1 1838 1838 5
394573 394573 33543 33543 PubChem (substance) 2 121932 121932 1
394580 394580 33543 33543 PubChem (substance) 2 212272 212272 3
394587 394587 33543 33543 PubChem (substance) 2 121932 121932 4
394593 394593 33543 33543 PubChem (substance) 2 230845 230845 5
394595 394595 33543 33543 PubChem (substance) 2 1838 1838 6
527263 527263 33543 33543 PubChem (substance) 2 211200 211200 2
733550 733550 33543 33543 PubChem (substance) 2 307934 307934 7
733551 733551 33543 33543 PubChem (substance) 2 204886 204886 8
989370 989370 33543 33543 CAS Common Chemistry 3 1838 1838 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)
);