api_results

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

24 rows where query_id = 74000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
297816 297816 74000 74000 PubChem (substance) 2 50570 50570 1
317061 317061 74000 74000 PubChem (substance) 2 74088 74088 2
318540 318540 74000 74000 PubChem (substance) 2 74093 74093 15
328265 328265 74000 74000 PubChem (substance) 2 74069 74069 5
334501 334501 74000 74000 PubChem (substance) 2 47899 47899 3
351102 351102 74000 74000 PubChem (substance) 2 50761 50761 9
358445 358445 74000 74000 PubChem (substance) 2 5198 5198 17
471237 471237 74000 74000 PubChem (substance) 2 45302 45302 6
690357 690357 74000 74000 PubChem (substance) 2 46135 46135 4
703085 703085 74000 74000 PubChem (substance) 2 183261 183261 10
758266 758266 74000 74000 PubChem (substance) 2 154459 154459 7
758267 758267 74000 74000 PubChem (substance) 2 154587 154587 8
758268 758268 74000 74000 PubChem (substance) 2 145410 145410 11
758269 758269 74000 74000 PubChem (substance) 2 61810 61810 12
758271 758271 74000 74000 PubChem (substance) 2 139357 139357 13
758272 758272 74000 74000 PubChem (substance) 2 249895 249895 14
758273 758273 74000 74000 PubChem (substance) 2 148237 148237 16
939298 939298 74000 74000 CAS Common Chemistry 3 50570 50570 2
1017973 1017973 74000 74000 CAS Common Chemistry 3 46135 46135 1
1017977 1017977 74000 74000 CAS Common Chemistry 3 61810 61810 3
1136163 1136163 74000 74000 Computational Toxicology and Exposure Data 4 50570 50570 4
1148282 1148282 74000 74000 Computational Toxicology and Exposure Data 4 74088 74088 2
1158471 1158471 74000 74000 Computational Toxicology and Exposure Data 4 47899 47899 3
1220311 1220311 74000 74000 Computational Toxicology and Exposure Data 4 94366 94366 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)
);