home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 135924

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
53112 53112 135924 135924 PubChem (compound) 1 115772 115772 1
53115 53115 135924 135924 PubChem (compound) 1 137144 137144 3
53117 53117 135924 135924 PubChem (compound) 1 203840 203840 2
53119 53119 135924 135924 PubChem (compound) 1 216641 216641 4
53123 53123 135924 135924 PubChem (compound) 1 296223 296223 5
370894 370894 135924 135924 PubChem (substance) 2 115772 115772 1
370899 370899 135924 135924 PubChem (substance) 2 137144 137144 5
370900 370900 135924 135924 PubChem (substance) 2 203840 203840 3
370904 370904 135924 135924 PubChem (substance) 2 216641 216641 4
370909 370909 135924 135924 PubChem (substance) 2 296223 296223 14
370912 370912 135924 135924 PubChem (substance) 2 43709 43709 2
723344 723344 135924 135924 PubChem (substance) 2 250732 250732 13
723350 723350 135924 135924 PubChem (substance) 2 238210 238210 12
795831 795831 135924 135924 PubChem (substance) 2 256809 256809 6
795833 795833 135924 135924 PubChem (substance) 2 217827 217827 7
795834 795834 135924 135924 PubChem (substance) 2 231814 231814 8
795835 795835 135924 135924 PubChem (substance) 2 199603 199603 9
795836 795836 135924 135924 PubChem (substance) 2 206080 206080 10
795837 795837 135924 135924 PubChem (substance) 2 288410 288410 11
795838 795838 135924 135924 PubChem (substance) 2 158341 158341 15
976972 976972 135924 135924 CAS Common Chemistry 3 43709 43709 1
1179807 1179807 135924 135924 Computational Toxicology and Exposure Data 4 115772 115772 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)
);
Powered by Datasette · Queries took 730.404ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website