api_results

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

16 rows where query_id = 67724

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
34888 34888 67724 67724 PubChem (compound) 1 11224 11224 1
345460 345460 67724 67724 PubChem (substance) 2 11224 11224 1
345520 345520 67724 67724 PubChem (substance) 2 129530 129530 8
360474 360474 67724 67724 PubChem (substance) 2 98444 98444 9
487169 487169 67724 67724 PubChem (substance) 2 57453 57453 12
490390 490390 67724 67724 PubChem (substance) 2 77644 77644 3
502442 502442 67724 67724 PubChem (substance) 2 24835 24835 4
537234 537234 67724 67724 PubChem (substance) 2 14168 14168 10
645429 645429 67724 67724 PubChem (substance) 2 14462 14462 2
714226 714226 67724 67724 PubChem (substance) 2 205137 205137 7
755440 755440 67724 67724 PubChem (substance) 2 203436 203436 5
755442 755442 67724 67724 PubChem (substance) 2 204617 204617 6
755444 755444 67724 67724 PubChem (substance) 2 201553 201553 11
755446 755446 67724 67724 PubChem (substance) 2 322717 322717 13
963537 963537 67724 67724 CAS Common Chemistry 3 11224 11224 1
1164965 1164965 67724 67724 Computational Toxicology and Exposure Data 4 11224 11224 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)
);