api_results

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

11 rows where query_id = 101337

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
66827 66827 101337 101337 PubChem (compound) 1 119133 119133 1
390997 390997 101337 101337 PubChem (substance) 2 119133 119133 1
705890 705890 101337 101337 PubChem (substance) 2 119133 119133 2
732288 732288 101337 101337 PubChem (substance) 2 238345 238345 3
732290 732290 101337 101337 PubChem (substance) 2 224874 224874 5
732292 732292 101337 101337 PubChem (substance) 2 296446 296446 8
763201 763201 101337 101337 PubChem (substance) 2 232141 232141 6
763203 763203 101337 101337 PubChem (substance) 2 232178 232178 7
769539 769539 101337 101337 PubChem (substance) 2 138636 138636 4
987363 987363 101337 101337 CAS Common Chemistry 3 16372 16372 1
1190297 1190297 101337 101337 Computational Toxicology and Exposure Data 4 119133 119133 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)
);