api_results

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

17 rows where query_id = 313294

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
305574 305574 313294 313294 PubChem (substance) 2 2054 2054 1
309324 309324 313294 313294 PubChem (substance) 2 3690 3690 8
309990 309990 313294 313294 PubChem (substance) 2 63043 63043 12
310156 310156 313294 313294 PubChem (substance) 2 2666 2666 14
326735 326735 313294 313294 PubChem (substance) 2 52211 52211 9
340155 340155 313294 313294 PubChem (substance) 2 4032 4032 2
341489 341489 313294 313294 PubChem (substance) 2 4065 4065 4
366062 366062 313294 313294 PubChem (substance) 2 28116 28116 5
371329 371329 313294 313294 PubChem (substance) 2 44389 44389 15
438624 438624 313294 313294 PubChem (substance) 2 84588 84588 13
463669 463669 313294 313294 PubChem (substance) 2 64298 64298 7
522138 522138 313294 313294 PubChem (substance) 2 65120 65120 6
674204 674204 313294 313294 PubChem (substance) 2 187268 187268 11
847633 847633 313294 313294 PubChem (substance) 2 309974 309974 3
847634 847634 313294 313294 PubChem (substance) 2 147749 147749 10
1090247 1090247 313294 313294 CAS Common Chemistry 3 2054 2054 1
1291984 1291984 313294 313294 Computational Toxicology and Exposure Data 4 2054 2054 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)
);