api_results

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

17 rows where query_id = 110361

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
129370 129370 110361 110361 PubChem (compound) 1 12457 12457 1
477982 477982 110361 110361 PubChem (substance) 2 12457 12457 1
710021 710021 110361 110361 PubChem (substance) 2 238468 238468 14
776986 776986 110361 110361 PubChem (substance) 2 136495 136495 2
776988 776988 110361 110361 PubChem (substance) 2 266776 266776 4
776992 776992 110361 110361 PubChem (substance) 2 226902 226902 11
776998 776998 110361 110361 PubChem (substance) 2 176822 176822 3
776999 776999 110361 110361 PubChem (substance) 2 343994 343994 5
777000 777000 110361 110361 PubChem (substance) 2 195194 195194 6
777001 777001 110361 110361 PubChem (substance) 2 197877 197877 7
777002 777002 110361 110361 PubChem (substance) 2 197878 197878 8
777003 777003 110361 110361 PubChem (substance) 2 197941 197941 9
777004 777004 110361 110361 PubChem (substance) 2 177304 177304 10
777005 777005 110361 110361 PubChem (substance) 2 238742 238742 12
777006 777006 110361 110361 PubChem (substance) 2 136496 136496 13
1031919 1031919 110361 110361 CAS Common Chemistry 3 12457 12457 1
1234817 1234817 110361 110361 Computational Toxicology and Exposure Data 4 12457 12457 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)
);