Add study node to represent telomere length pilot

[pbilling]

• [x] Create WgsTelomereLengthPilot Study w/ properties studyLead, participantCount, name
• [x] Connect the Study to 1000 participants with AAA phenotype information and CRAMs
• [x] Create a CSV with columns: sample, ageAtEnrollment, vaReportedGender, hareEthnicity, aaaDiagnosis, cram, crai

[pbilling]

Cypher query to create Study node:

CREATE (s:Study {name:"WgsTelomereLengthPilot", studyLead:"Prathima Vembu", participantCount:1000})
RETURN s

[pbilling]

Query elements

• Check that person has a CRAM
• Check that person has been checked for AAA

Cypher query to add participants to study:

MATCH (s:Study), (p:Person)-[:HAS_BIOLOGICAL_OME]->(g:Genome)-[:HAS_SEQUENCING_READS]->(cram:Cram)-[:HAS_INDEX]->(crai:Crai)
WHERE s.name = "WgsTelomereLengthPilot"
AND EXISTS(p.aaaDiagnosis)
WITH DISTINCT p, s
LIMIT 1000
MERGE (s)-[:HAS_PARTICIPANT {study:"WgsTelomereLengthPilot"}]->(:Participant)-[:IS]->(p)
RETURN COUNT(p)

[pbilling]

Validation query:

MATCH (s:Study)-[:HAS_PARTICIPANT]->(:Participant)-[:IS]->(p:Person)
WHERE s.name = "WgsTelomereLengthPilot"
RETURN COUNT(p)

COUNT(p)
1000

[pbilling]

Get phenotype information:

MATCH (s:Study)-[:HAS_PARTICIPANT]->(:Participant)-[:IS]->(p:Person)-[:HAS_BIOLOGICAL_OME]->(:Genome)-[:HAS_SEQUENCING_READS]->(cram:Cram)-[:HAS_INDEX]->(crai:Crai)
WHERE s.name = "WgsTelomereLengthPilot"
RETURN cram.sample, p.ageAtEnrollment, p.vaReportedGender, p.hareEthnicity, p.aaaDiagnosis, cram.uri, crai.uri