It might sound strange, but we only store publicationYear for ot_genetics_portal evidence. It is due to the nature on how literature references are handled:
for the EPMC evidence to populate some of the columns, the publication metadata is retrieved from the ePMC API including publication year.
for all sources where pubmed identifiers are present, upon clicking on the reference, a drawer opens showing publication details. These pieces of data also fetched via an API calls.
the genetics portal evidence is slightly special, as some metadata eg. year of publication, first author have an impact on the interpretation of the evidence, so these values are stored in the evidence itself.
Please take a look:
query OpenTargetsGeneticsQuery(
$ensemblId: String!
$efoId: String!
$size: Int!
) {
disease(efoId: $efoId) {
id
evidences(
ensemblIds: [$ensemblId]
enableIndirect: true
size: $size
datasourceIds: ["ot_genetics_portal"]
) {
rows {
id
disease {
id
name
}
diseaseFromSource
studyId
studySampleSize
variantId
variantRsId
literature
publicationYear
publicationFirstAuthor
pValueExponent
pValueMantissa
oddsRatio
oddsRatioConfidenceIntervalLower
oddsRatioConfidenceIntervalUpper
beta
betaConfidenceIntervalLower
betaConfidenceIntervalUpper
variantFunctionalConsequence {
id
label
}
resourceScore
projectId
}
}
}
}