跳到正文

医学公开数据库查询与登记

使用有明确接口的公开数据库查询方法保存请求、筛选、分页与来源,可用于医学文献、临床试验及药物资料检索。

开源精选医疗业务86 个文件50,135 Stars浏览次数 0K-Dense-AI/scientific-agent-skills MIT版本 a1043ef
开始使用

下载前阅读 SKILL.md 中的使用条件,并确认所用工具支持对应能力。

输入资料
指定数据库和查询问题 实际接口、筛选条件及使用范围 阅读本节完整说明
交付内容
可复查的查询资料 请求、分页与来源记录 阅读本节完整说明
  1. 获取完整包,保留配套文件的目录结构。
  2. 按照原文准备所需工具、依赖与输入资料。
  3. 阅读对应使用步骤与输入输出说明,在自己的环境中验证结果。

使用提示摘自原文,配套文件保留来源版本;实际运行条件以各包说明为准。

正文

获取原文件

references/nasa-exoplanet-archive.md

Base URL

https://exoplanetarchive.ipac.caltech.edu

Authentication

No API key required. All endpoints are public.

Key Endpoints

GET /TAP/sync?query={ADQL}&format={format}
Parameter Type Description
query string Required. ADQL query.
format string json, csv, votable, tsv, ipac. Default: votable.

Example — confirmed planets with key parameters:

https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=SELECT pl_name,hostname,sy_dist,pl_orbper,pl_rade,pl_bmasse,disc_year,discoverymethod FROM ps WHERE default_flag=1 ORDER BY disc_year DESC&format=json

Example — planets in habitable zone (rough estimate):

https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=SELECT TOP 50 pl_name,hostname,pl_orbsmax,st_teff,pl_rade FROM ps WHERE default_flag=1 AND pl_orbsmax BETWEEN 0.8 AND 1.5 AND st_teff BETWEEN 4000 AND 7000&format=json

Example — planets discovered by TESS:

https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=SELECT pl_name,pl_rade,pl_orbper,disc_year FROM ps WHERE default_flag=1 AND disc_facility='Transiting Exoplanet Survey Satellite (TESS)'&format=json

Example — count planets by discovery method:

https://exoplanetarchive.ipac.caltech.edu/TAP/sync?query=SELECT discoverymethod, COUNT(*) as cnt FROM ps WHERE default_flag=1 GROUP BY discoverymethod ORDER BY cnt DESC&format=json

2. Legacy tables

Tables migrated to TAP (including ps) cannot be queried through the old nph-nstedAPI recipe. Use TAP for the tables below and inspect TAP_SCHEMA.tables and TAP_SCHEMA.columns for the current catalogue.

Key TAP Tables

Table Description
ps Planetary Systems — one row per reference per planet. Use default_flag=1 for the default/best parameter set.
pscomppars Planetary Systems Composite Parameters — one row per planet with best-fit values from multiple references.
stellarhosts Stellar properties of host stars.
TD Transiting Planets table; not a generic time-series table.
keplernames Kepler Object of Interest cross-references.
k2names K2 campaign cross-references.
toi TESS Objects of Interest.

Key Columns (ps table)

Column Description
pl_name Planet name (e.g., "Kepler-22 b").
hostname Host star name.
default_flag 1 = default parameter set for this planet.
disc_year Discovery year.
discoverymethod Transit, Radial Velocity, Imaging, Microlensing, etc.
pl_orbper Orbital period (days).
pl_orbsmax Semi-major axis (AU).
pl_rade Planet radius (Earth radii).
pl_bmasse Planet mass (Earth masses).
pl_eqt Equilibrium temperature (K).
sy_dist Distance to system (parsecs).
st_teff Stellar effective temperature (K).
st_rad Stellar radius (solar radii).
st_mass Stellar mass (solar masses).
disc_facility Discovery facility name.

Response Format (TAP JSON)

The archive returns an array of objects keyed by selected column names:

[{"pl_name": "Kepler-22 b", "pl_orbper": 289.8623}]

URL-encode the ADQL using a query-parameter encoder (for curl, --get --data-urlencode). default_flag=1 selects the archive's default parameter row; it is not a guarantee that every column is populated or that the chosen solution is best for your analysis. The orbital-distance/temperature filter above is illustrative, not a validated habitable-zone classification.

Rate Limits

No API key or authentication required. No formal rate limits documented, but the archive requests that users avoid excessive automated queries. Large result sets may cause timeouts; use bounded TOP N queries or partition on stable keys. MAXREC is a row cap, not an offset; inspect overflow status in VOTable results and never infer completeness from a capped JSON response.

For very large downloads, use the bulk download interface at:

https://exoplanetarchive.ipac.caltech.edu/cgi-bin/TblView/nph-tblView?app=ExoTbls&config=PS

CONTACT HAONAN

联系haonan

医疗 AI · 产品与独立开发

刘浩南

关注医疗 AI 从 demo 到真实落地,聚焦产品化、商业化与院内工作流效率提升。

12年医疗产研经验,大湾区头部医疗AI公司前产品总监,独立开发者

医疗 AI 产品化医疗 AI 商业化院内工作流效率
刘浩南的微信联系二维码
微信扫一扫,联系 haonan