home / zeropm-v0-0-4

api_results

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

29 rows where query_id = 96802

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
120596 120596 96802 96802 PubChem (compound) 1 111382 111382 1
120599 120599 96802 96802 PubChem (compound) 1 229523 229523 2
120601 120601 96802 96802 PubChem (compound) 1 234962 234962 3
120603 120603 96802 96802 PubChem (compound) 1 230470 230470 4
120605 120605 96802 96802 PubChem (compound) 1 229669 229669 5
120607 120607 96802 96802 PubChem (compound) 1 230543 230543 6
120609 120609 96802 96802 PubChem (compound) 1 329551 329551 7
431353 431353 96802 96802 PubChem (substance) 2 59611 59611 7
431356 431356 96802 96802 PubChem (substance) 2 188661 188661 8
431362 431362 96802 96802 PubChem (substance) 2 136778 136778 18
465749 465749 96802 96802 PubChem (substance) 2 111382 111382 1
465755 465755 96802 96802 PubChem (substance) 2 229523 229523 2
465757 465757 96802 96802 PubChem (substance) 2 234962 234962 3
465762 465762 96802 96802 PubChem (substance) 2 230470 230470 5
465765 465765 96802 96802 PubChem (substance) 2 229669 229669 6
465768 465768 96802 96802 PubChem (substance) 2 230543 230543 16
465770 465770 96802 96802 PubChem (substance) 2 329551 329551 19
767588 767588 96802 96802 PubChem (substance) 2 60973 60973 4
767590 767590 96802 96802 PubChem (substance) 2 315601 315601 9
767592 767592 96802 96802 PubChem (substance) 2 215554 215554 10
767593 767593 96802 96802 PubChem (substance) 2 229523 229523 11
767595 767595 96802 96802 PubChem (substance) 2 284929 284929 12
767598 767598 96802 96802 PubChem (substance) 2 229249 229249 13
767601 767601 96802 96802 PubChem (substance) 2 230094 230094 14
767603 767603 96802 96802 PubChem (substance) 2 289218 289218 15
767604 767604 96802 96802 PubChem (substance) 2 298040 298040 17
767607 767607 96802 96802 PubChem (substance) 2 328730 328730 20
1025965 1025965 96802 96802 CAS Common Chemistry 3 60973 60973 1
1228538 1228538 96802 96802 Computational Toxicology and Exposure Data 4 111382 111382 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)
);
Powered by Datasette · Queries took 1225.954ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website