api_results

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

16 rows where query_id = 376202

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
269584 269584 376202 376202 PubChem (compound) 1 90545 90545 1
647056 647056 376202 376202 PubChem (substance) 2 240275 240275 9
659260 659260 376202 376202 PubChem (substance) 2 90545 90545 1
659274 659274 376202 376202 PubChem (substance) 2 257737 257737 8
919259 919259 376202 376202 PubChem (substance) 2 140428 140428 2
919261 919261 376202 376202 PubChem (substance) 2 183422 183422 3
919263 919263 376202 376202 PubChem (substance) 2 233655 233655 4
919265 919265 376202 376202 PubChem (substance) 2 211591 211591 5
919266 919266 376202 376202 PubChem (substance) 2 199447 199447 6
919267 919267 376202 376202 PubChem (substance) 2 254316 254316 7
919268 919268 376202 376202 PubChem (substance) 2 237876 237876 10
919269 919269 376202 376202 PubChem (substance) 2 309725 309725 11
919270 919270 376202 376202 PubChem (substance) 2 286494 286494 12
919271 919271 376202 376202 PubChem (substance) 2 289608 289608 13
1117989 1117989 376202 376202 CAS Common Chemistry 3 90545 90545 1
1329635 1329635 376202 376202 Computational Toxicology and Exposure Data 4 90545 90545 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)
);