api_results

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

14 rows where query_id = 110326

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
129329 129329 110326 110326 PubChem (compound) 1 94639 94639 1
329659 329659 110326 110326 PubChem (substance) 2 77510 77510 4
477923 477923 110326 110326 PubChem (substance) 2 94639 94639 1
709323 709323 110326 110326 PubChem (substance) 2 230248 230248 2
709340 709340 110326 110326 PubChem (substance) 2 321315 321315 11
776793 776793 110326 110326 PubChem (substance) 2 12217 12217 10
776797 776797 110326 110326 PubChem (substance) 2 229954 229954 3
776801 776801 110326 110326 PubChem (substance) 2 291284 291284 8
776803 776803 110326 110326 PubChem (substance) 2 206730 206730 5
776805 776805 110326 110326 PubChem (substance) 2 288083 288083 7
776809 776809 110326 110326 PubChem (substance) 2 309530 309530 9
776810 776810 110326 110326 PubChem (substance) 2 232275 232275 6
1031895 1031895 110326 110326 CAS Common Chemistry 3 12217 12217 1
1234794 1234794 110326 110326 Computational Toxicology and Exposure Data 4 94639 94639 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)
);