nmdp-bioinformatics / gfe-db

Graph database representing IPD-IMGT/HLA sequence data as GFE
https://gfe-db.readthedocs.io
GNU General Public License v3.0
9 stars 15 forks source link

submit_date should be the date the allele was "first" submitted #93

Open mmaiers-nmdp opened 1 year ago

mmaiers-nmdp commented 1 year ago

this query

match (s:Submitter)-[d:SUBMITTED]-(g:GFE)
return d.submit_date, count(*)

returns the same value for every allele

╒═══════════════╤══════════╕
│"d.submit_date"│"count(*)"│
╞═══════════════╪══════════╡
│"2023-08-24"   │21243     │
└───────────────┴──────────┘

This works for user submissions but for the IPD_alleles it should be probably be the date the allele was first submitted there (or the date of the quarterly release when it was first published.

mmaiers-nmdp commented 7 months ago

This is still an issue in the current database on dockerhub "chrisammon3000/gfe-db:latest" accessed 2024-02-12

image