api_results

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

12 rows where query_id = 106370

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
99486 99486 106370 106370 PubChem (compound) 1 83461 83461 1
436378 436378 106370 106370 PubChem (substance) 2 83461 83461 1
455523 455523 106370 106370 PubChem (substance) 2 12874 12874 9
644102 644102 106370 106370 PubChem (substance) 2 137125 137125 2
749743 749743 106370 106370 PubChem (substance) 2 166340 166340 3
749745 749745 106370 106370 PubChem (substance) 2 282876 282876 4
774036 774036 106370 106370 PubChem (substance) 2 200447 200447 5
774039 774039 106370 106370 PubChem (substance) 2 153804 153804 6
774040 774040 106370 106370 PubChem (substance) 2 195379 195379 7
774041 774041 106370 106370 PubChem (substance) 2 152352 152352 8
1011612 1011612 106370 106370 CAS Common Chemistry 3 83461 83461 1
1213704 1213704 106370 106370 Computational Toxicology and Exposure Data 4 83461 83461 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)
);