home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 29336

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22369 22369 29336 29336 PubChem (compound) 1 64739 64739 1
327775 327775 29336 29336 PubChem (substance) 2 64739 64739 1
329323 329323 29336 29336 PubChem (substance) 2 76731 76731 5
440977 440977 29336 29336 PubChem (substance) 2 4755 4755 3
471234 471234 29336 29336 PubChem (substance) 2 45302 45302 4
677437 677437 29336 29336 PubChem (substance) 2 136467 136467 22
695864 695864 29336 29336 PubChem (substance) 2 315679 315679 6
708577 708577 29336 29336 PubChem (substance) 2 136468 136468 2
708598 708598 29336 29336 PubChem (substance) 2 200179 200179 20
709547 709547 29336 29336 PubChem (substance) 2 315681 315681 7
729436 729436 29336 29336 PubChem (substance) 2 186927 186927 8
729437 729437 29336 29336 PubChem (substance) 2 202223 202223 9
729439 729439 29336 29336 PubChem (substance) 2 202224 202224 10
729441 729441 29336 29336 PubChem (substance) 2 202387 202387 11
729443 729443 29336 29336 PubChem (substance) 2 197765 197765 12
729445 729445 29336 29336 PubChem (substance) 2 193959 193959 13
729447 729447 29336 29336 PubChem (substance) 2 200411 200411 14
729449 729449 29336 29336 PubChem (substance) 2 202870 202870 15
729451 729451 29336 29336 PubChem (substance) 2 185607 185607 16
729453 729453 29336 29336 PubChem (substance) 2 202582 202582 17
729455 729455 29336 29336 PubChem (substance) 2 204613 204613 18
729457 729457 29336 29336 PubChem (substance) 2 195516 195516 19
729459 729459 29336 29336 PubChem (substance) 2 231613 231613 21
954666 954666 29336 29336 CAS Common Chemistry 3 64739 64739 2
1154361 1154361 29336 29336 Computational Toxicology and Exposure Data 4 64739 64739 2
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)
);
Powered by Datasette · Queries took 1129.459ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website