api_results

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

13 rows where query_id = 120466

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
140340 140340 120466 120466 PubChem (compound) 1 90299 90299 1
492559 492559 120466 120466 PubChem (substance) 2 90299 90299 1
664972 664972 120466 120466 PubChem (substance) 2 93124 93124 4
749609 749609 120466 120466 PubChem (substance) 2 227182 227182 6
749615 749615 120466 120466 PubChem (substance) 2 231108 231108 5
785084 785084 120466 120466 PubChem (substance) 2 136377 136377 2
785089 785089 120466 120466 PubChem (substance) 2 191994 191994 3
785091 785091 120466 120466 PubChem (substance) 2 170043 170043 8
785095 785095 120466 120466 PubChem (substance) 2 239275 239275 9
785100 785100 120466 120466 PubChem (substance) 2 247103 247103 11
785102 785102 120466 120466 PubChem (substance) 2 176411 176411 7
785103 785103 120466 120466 PubChem (substance) 2 178370 178370 10
1243401 1243401 120466 120466 Computational Toxicology and Exposure Data 4 90299 90299 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)
);