Citations (cleaned) (view)

Data license: CC BY 4.0 · Data source: apt-scout automated curation pipeline (E. Dohi, NCNP) — values harvested from public databases; raw source stored per target

target_id

UniProt accession this citation supports. Links to uniprot.org.

citation_type

PDB / PMID / DOI.

citation_value

The identifier (PDB ID, PubMed ID, or DOI).

source_layer

Which layer's harvest produced this citation.

extracted_utc

When the value was harvested.

10,562 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: citation_type, source_layer, extracted_utc, extracted_utc (date)

Next page

CREATE VIEW v_citations AS
SELECT target_id, citation_type, citation_value, source_layer, extracted_utc
FROM citations
WHERE (citation_type='PDB'  AND length(citation_value)=4 AND substr(citation_value,1,1) GLOB '[0-9]')
   OR (citation_type='PMID' AND citation_value GLOB '[0-9]*' AND citation_value NOT GLOB '*[^0-9]*')
   OR (citation_type='DOI'  AND citation_value LIKE '10.%');