api_results

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

31 rows where query_id = 11506

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22105 22105 11506 11506 PubChem (compound) 1 58699 58699 1
327370 327370 11506 11506 PubChem (substance) 2 58699 58699 1
346380 346380 11506 11506 PubChem (substance) 2 13330 13330 2
488898 488898 11506 11506 PubChem (substance) 2 63226 63226 4
633984 633984 11506 11506 PubChem (substance) 2 140766 140766 28
708193 708193 11506 11506 PubChem (substance) 2 58699 58699 3
708196 708196 11506 11506 PubChem (substance) 2 165277 165277 5
708198 708198 11506 11506 PubChem (substance) 2 205304 205304 6
708200 708200 11506 11506 PubChem (substance) 2 201099 201099 7
708203 708203 11506 11506 PubChem (substance) 2 204054 204054 8
708204 708204 11506 11506 PubChem (substance) 2 201778 201778 9
708206 708206 11506 11506 PubChem (substance) 2 177783 177783 10
708208 708208 11506 11506 PubChem (substance) 2 201591 201591 11
708210 708210 11506 11506 PubChem (substance) 2 201592 201592 12
708212 708212 11506 11506 PubChem (substance) 2 201364 201364 13
708214 708214 11506 11506 PubChem (substance) 2 202515 202515 14
708216 708216 11506 11506 PubChem (substance) 2 200574 200574 15
708218 708218 11506 11506 PubChem (substance) 2 169867 169867 16
708220 708220 11506 11506 PubChem (substance) 2 169869 169869 17
708223 708223 11506 11506 PubChem (substance) 2 169873 169873 18
708225 708225 11506 11506 PubChem (substance) 2 200931 200931 19
708226 708226 11506 11506 PubChem (substance) 2 200647 200647 20
708228 708228 11506 11506 PubChem (substance) 2 200016 200016 21
708230 708230 11506 11506 PubChem (substance) 2 206550 206550 22
708232 708232 11506 11506 PubChem (substance) 2 210593 210593 23
708234 708234 11506 11506 PubChem (substance) 2 216522 216522 24
708238 708238 11506 11506 PubChem (substance) 2 143544 143544 25
708243 708243 11506 11506 PubChem (substance) 2 322699 322699 26
708245 708245 11506 11506 PubChem (substance) 2 254821 254821 27
954521 954521 11506 11506 CAS Common Chemistry 3 58699 58699 1
1154175 1154175 11506 11506 Computational Toxicology and Exposure Data 4 58699 58699 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)
);