Update loadable refs to read_group refs

Yes, like that.

From: Melody Williams @.> Sent: Tuesday, March 7, 2023 1:50 PM To: stjude/XenoCP @.> Cc: Rusch, Michael @.>; Review requested @.> Subject: Re: [stjude/XenoCP] Update loadable refs to read_group refs (PR #35)

Caution: External Sender. Do not open unless you know the content is safe.

@mellypop commented on this pull request.

In src/main/scripts/add_bam_pair_xenocp.pyhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fstjude%2FXenoCP%2Fpull%2F35%23discussion_r1128481535&data=05%7C01%7Cmichael.rusch%40stjude.org%7C0f65d21cf19c4fc6205708db1f452f54%7C22340fa892264871b677d3b3e377af72%7C0%7C0%7C638138154234506092%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aWjy6CFx7MRw3Zh5HA7tHwLELEtZlF%2BlwMeFWBPdCNw%3D&reserved=0:

query = """select rg.read_group_id, rg.pu

from read_group rg inner join sample_target_project_view stpv
on rg.sample_target_id = stpv.sample_target_id and rg.project_id = stpv.project_id
where status = 'Normal' and formal_name = %s and target_name = %s
and project_name = %s and subproject = %s;"""

Something like this?

query = """select

        rg.read_group_id,

        rg.pu

    from

        read_group rg

        inner join sample_target_project_view stpv

            on rg.sample_target_id = stpv.sample_target_id and rg.project_id = stpv.project_id

    where

        status = 'Normal'

        and formal_name = %s

        and target_name = %s

        and project_name = %s

        and subproject = %s;"""

- Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fstjude%2FXenoCP%2Fpull%2F35%23discussion_r1128481535&data=05%7C01%7Cmichael.rusch%40stjude.org%7C0f65d21cf19c4fc6205708db1f452f54%7C22340fa892264871b677d3b3e377af72%7C0%7C0%7C638138154234506092%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aWjy6CFx7MRw3Zh5HA7tHwLELEtZlF%2BlwMeFWBPdCNw%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAH3RHETP6N4XSBM4RQBNRADW26GPXANCNFSM6AAAAAAUS5OUKM&data=05%7C01%7Cmichael.rusch%40stjude.org%7C0f65d21cf19c4fc6205708db1f452f54%7C22340fa892264871b677d3b3e377af72%7C0%7C0%7C638138154234506092%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=s8f1Cf2mW4zty7y0NyCqvN%2FMXoIgFbo3LJVu%2FIEda50%3D&reserved=0. You are receiving this because your review was requested.Message ID: @.***>

Email Disclaimer: www.stjude.org/emaildisclaimer Consultation Disclaimer: www.stjude.org/consultationdisclaimer

stjude / XenoCP

Update loadable refs to read_group refs #35