home / zeropm-v0-0-4

api_results

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

31 rows where query_id = 112233

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
131333 131333 112233 112233 PubChem (compound) 1 42695 42695 1
480565 480565 112233 112233 PubChem (substance) 2 42695 42695 1
736681 736681 112233 112233 PubChem (substance) 2 137964 137964 5
772912 772912 112233 112233 PubChem (substance) 2 140557 140557 25
778659 778659 112233 112233 PubChem (substance) 2 136984 136984 2
778662 778662 112233 112233 PubChem (substance) 2 178424 178424 3
778664 778664 112233 112233 PubChem (substance) 2 207784 207784 4
778666 778666 112233 112233 PubChem (substance) 2 198137 198137 6
778668 778668 112233 112233 PubChem (substance) 2 154426 154426 24
778669 778669 112233 112233 PubChem (substance) 2 206961 206961 7
778672 778672 112233 112233 PubChem (substance) 2 200041 200041 26
778675 778675 112233 112233 PubChem (substance) 2 239125 239125 28
778676 778676 112233 112233 PubChem (substance) 2 176634 176634 8
778677 778677 112233 112233 PubChem (substance) 2 176635 176635 9
778678 778678 112233 112233 PubChem (substance) 2 176636 176636 10
778679 778679 112233 112233 PubChem (substance) 2 176637 176637 11
778680 778680 112233 112233 PubChem (substance) 2 196758 196758 12
778681 778681 112233 112233 PubChem (substance) 2 197934 197934 13
778682 778682 112233 112233 PubChem (substance) 2 206825 206825 14
778683 778683 112233 112233 PubChem (substance) 2 206826 206826 15
778684 778684 112233 112233 PubChem (substance) 2 206827 206827 16
778685 778685 112233 112233 PubChem (substance) 2 206828 206828 17
778686 778686 112233 112233 PubChem (substance) 2 195394 195394 18
778687 778687 112233 112233 PubChem (substance) 2 173851 173851 19
778688 778688 112233 112233 PubChem (substance) 2 206960 206960 20
778689 778689 112233 112233 PubChem (substance) 2 206962 206962 21
778690 778690 112233 112233 PubChem (substance) 2 206990 206990 22
778691 778691 112233 112233 PubChem (substance) 2 206991 206991 23
778692 778692 112233 112233 PubChem (substance) 2 291610 291610 27
1033530 1033530 112233 112233 CAS Common Chemistry 3 42695 42695 1
1236469 1236469 112233 112233 Computational Toxicology and Exposure Data 4 42695 42695 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 476.67ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website