AptBacterialDB REST API Explorer

Query AptBacterialDB data using structured filters, paramerters, and pagination. Build custom queries without writing code!

Base Endpoint

This is the main API endpoint used to retrieve data from AptBacterialDB. All queries are performed using HTTP GET requests and return results in JSON format.

https://webs.iiitd.edu.in/raghava/aptbacterialdb/api/query.php

The API is read-only and does not modify the database.

Request Parameters

Filters are passed as URL query parameters using the format: column:operator=value. Multiple filters can be combined using & and are applied using logical AND.

Supported Columns

  • AptBacDB_ID
  • PMID/DOI
  • Year
  • Title
  • Aptamer name
  • Length
  • Library
  • Type
  • Target Organism
  • Target
  • Activity Role
  • Modification
  • Potential Candidate
  • Patent

Operators

  • eq → equals/exact match
  • contains → contains/partial match
  • not equals → ne
  • gt → greater than (numeric)
  • lt → less than (numeric)
  • gte → greater than or equal (numeric)
  • lte → less than or equal (numeric)

Pagination

  • limit → number of results
  • offset → starting row

Example Queries

1. Default request
curl "https://webs.iiitd.edu.in/raghava/aptbacterialdb/api/query.php"
2. Search by Target
curl "https://webs.iiitd.edu.in/raghava/aptbacterialdb/api/query.php?Target:contains=bacteria"
3. Search by Aptamer name
curl "https://webs.iiitd.edu.in/raghava/aptbacterialdb/api/query.php?Aptamer%20name:contains=Aptamer"
4. Numeric filter
curl "https://webs.iiitd.edu.in/raghava/aptbacterialdb/api/query.php?Length:gt=50"
5. Multiple filters
curl "https://webs.iiitd.edu.in/raghava/aptbacterialdb/api/query.php?Target:contains=bacteria&Year:gte=2017"
6. Pagination
curl "https://webs.iiitd.edu.in/raghava/aptbacterialdb/api/query.php?limit=5&offset=10"

Build Query

Select a column, choose an operator, and enter a value. You can add multiple filters (AND logic).

Note: Numeric operators (gt, lt, gte, lte) are applicable only to numeric fields such as Year and Length.

API Request

Request URL

cURL

wget

Response Format

{
  "status": "success",
  "count": 10,
  "data": [
    {
      "AptBacDB_ID": "ABdb_0001",
      "Aptamer name": "...",
      "Target": "...",
      "Length": "..."
    }
  ]
}