api_results

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

12 rows where query_id = 384116

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
274186 274186 384116 384116 PubChem (compound) 1 31392 31392 1
664919 664919 384116 384116 PubChem (substance) 2 31392 31392 1
783497 783497 384116 384116 PubChem (substance) 2 212041 212041 2
787859 787859 384116 384116 PubChem (substance) 2 167604 167604 4
923645 923645 384116 384116 PubChem (substance) 2 178309 178309 3
923646 923646 384116 384116 PubChem (substance) 2 258896 258896 5
923647 923647 384116 384116 PubChem (substance) 2 257416 257416 6
923648 923648 384116 384116 PubChem (substance) 2 169473 169473 7
923649 923649 384116 384116 PubChem (substance) 2 294881 294881 8
923650 923650 384116 384116 PubChem (substance) 2 242225 242225 9
1120628 1120628 384116 384116 CAS Common Chemistry 3 31392 31392 1
1332802 1332802 384116 384116 Computational Toxicology and Exposure Data 4 31392 31392 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)
);