broadinstitute / cpg

Cell painting gallery
BSD 3-Clause "New" or "Revised" License
2 stars 3 forks source link

Parse well id for image objects #40

Open johnarevalo opened 4 months ago

johnarevalo commented 4 months ago

Well id for images is encoded in the filename. There are multiple patterns, depending on the source. Source 1

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_S
source_1,Batch1_20221004,UL000109,A02,1,r01c02f01p01-ch5sk1fk1fl1.tiff

Source 2

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,FileName_O
source_2,20210607_Batch_2,1053601756,A01,1,1053601756_A01_T0001F001L01A04Z01C04.tif,

Source 3

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site
source_3,CP_25_all_Phenix1,C13443aW,A01,1,r01c01f01p01-ch2sk1fk1fl1.tiff,

Source 4

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,F
source_4,2021_04_26_Batch1,BR00117035,A01,1,r01c01f01p01-ch2sk1fk1fl1.tiff,

Source 5

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,FileName_OrigAGP,FileName_OrigDNA,
source_5,JUMPCPE-20210623-Run01_20210624_003152,ADMJUM001,A01,1,P01_ADMJUM001_A01_T0001F001L01A04Z01C04.tif,

Source 6

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,FileName_OrigAGP,FileName_Or
source_6,p210824CPU2OS48hw384exp022JUMP,110000293081,A01,1,110000293081_A01_T0001F001L01A03Z01C04.tif,

Source 7

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,FileNam
source_7,20210719_Run1,CP1-SC1-01,A01,0,CP1-SC1-01_A01_T0001F001L01A04Z01C05.tif,

Source_8

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,FileNa
source_8,J1,A1170383,A01,1,HTS_A01_s1_w20B4AE6FD-1ADC-4BA5-AB69-A459DD5C1532.tif

Source_9

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Si
source_9,20210824-Run5,GR00003381,A01,1,r01c01f01p01-ch3sk1fk1fl1.tiff,

Source 10

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,FileName_OrigAGP,FileName_OrigDNA,F
source_10,2021_05_31_U2OS_48_hr_run1,Dest210531-152149,A01,1,Dest210531-152149_A01_T0001F001L01A03Z01C04.tif,

Source_11

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Met
source_11,Batch1,EC000001,A01,1,r01c01f01p01-ch3sk1fk1fl1.tiff,

Source_13

Metadata_Source,Metadata_Batch,Metadata_Plate,Metadata_Well,Metadata_Site,FileName_Ori
source_13,20220914_Run1,CP-CC9-R1-01,A01,0,CP-CC9-R1-01_A01_T0001F001L01A04Z01C05.tif,