api_results

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

12 rows where query_id = 104932

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124936 124936 104932 104932 PubChem (compound) 1 53046 53046 1
471998 471998 104932 104932 PubChem (substance) 2 53046 53046 1
540713 540713 104932 104932 PubChem (substance) 2 17533 17533 5
772135 772135 104932 104932 PubChem (substance) 2 137220 137220 2
772139 772139 104932 104932 PubChem (substance) 2 239118 239118 3
772142 772142 104932 104932 PubChem (substance) 2 179838 179838 4
772144 772144 104932 104932 PubChem (substance) 2 220985 220985 6
772146 772146 104932 104932 PubChem (substance) 2 291046 291046 7
772147 772147 104932 104932 PubChem (substance) 2 197946 197946 8
772149 772149 104932 104932 PubChem (substance) 2 138475 138475 9
1028663 1028663 104932 104932 CAS Common Chemistry 3 53046 53046 1
1231486 1231486 104932 104932 Computational Toxicology and Exposure Data 4 53046 53046 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)
);