api_results

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

14 rows where query_id = 166105

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
112836 112836 166105 166105 PubChem (compound) 1 124673 124673 1
433498 433498 166105 166105 PubChem (substance) 2 32202 32202 6
447964 447964 166105 166105 PubChem (substance) 2 77102 77102 10
454873 454873 166105 166105 PubChem (substance) 2 124673 124673 1
761283 761283 166105 166105 PubChem (substance) 2 137340 137340 2
761287 761287 166105 166105 PubChem (substance) 2 188373 188373 3
761290 761290 166105 166105 PubChem (substance) 2 192071 192071 8
761297 761297 166105 166105 PubChem (substance) 2 261307 261307 9
761300 761300 166105 166105 PubChem (substance) 2 287957 287957 7
761304 761304 166105 166105 PubChem (substance) 2 188541 188541 4
761309 761309 166105 166105 PubChem (substance) 2 328602 328602 11
815573 815573 166105 166105 PubChem (substance) 2 170062 170062 5
1219452 1219452 166105 166105 Computational Toxicology and Exposure Data 4 77102 77102 2
1223105 1223105 166105 166105 Computational Toxicology and Exposure Data 4 124673 124673 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)
);