Ë
    [4˜jU  ã                   ó.   — d dl mZmZmZmZ d„ Zd„ Zd„ Zy)é    )Ú
BATCH_SIZEÚBUCKET_LISTÚTAXONOMY_ORDERÚMAJOR_RANKSc           	      ó:  — i }| r|s|S 	 |j                  «       5 }|j                  dt        t        | «      «      f«       |j	                  «       D ]  }|d   ||d   <   Œ 	 d d d «       |S # 1 sw Y   |S xY w# t
        $ r}t        d|› �«       Y d }~|S d }~ww xY w)Nz–
                SELECT accession_version, tax_id
                FROM accession_taxid
                WHERE accession_version = ANY(%s);
            é   r   z[Error] Batch query failed: )ÚcursorÚexecuteÚlistÚsetÚfetchallÚ	ExceptionÚprint)Ú
accessionsÚconnÚaccession_mapÚcurÚrowÚes         úA/mounts/lovelace/temporary/charliep/p3/bam-report-main/util/db.pyÚget_taxids_for_accessionsr      s·   € Ø€MÙ™TØÐð
2Ø�[‰[‹]ð 	/˜cØ�K‰Kð ô ”s˜:“Ó'Ð)ô	+ð
 —|‘|“~ò /�Ø(+¨A©�˜c !™fÒ%ñ/÷	/ð Ð÷	/ð Ðûô ò 2ÜÐ,¨Q¨CÐ0×1Ð1ØÐûð2ús5   ŠA8 šAA+Á!A8 Á+A5Á0A8 Á5A8 Á8	BÂBÂBc                 ó¦  — i }d }|s|i fS | }	 |r|dk(  rnw	 |j                  «       5 }|j                  d|f«       |j                  «       }d d d «       sn7|\  }}	}
|
j	                  «       }
|
|vr|||
<   |
|j	                  «       k(  r|}|	}Œt
        D �
ci c]  }
|
|v sŒ|
||
   “Œ }}
|r||fS d|fS # 1 sw Y   ŒixY w# t        $ r Y Œ=w xY wc c}
w )Nr   zŽ
                    SELECT tax_id, parent_tax_id, rank
                    FROM nodes
                    WHERE tax_id = %s;
                ÚOther)r	   r
   Úfetchoner   Úlowerr   )ÚtaxidÚtarget_tax_levelr   Úfull_lineageÚtarget_taxidÚcurrent_taxidr   ÚinfoÚtax_idÚparent_tax_idÚrankÚfinal_lineages               r   Úget_lineage_from_taxidr&      s#  € Ø€LØ€LáØ˜RÐÐà€Mà
Ù °Ò 2Øð		Ø—‘“ð & #Ø—‘ð ð $Ð%ô	'ð
 —|‘|“~�÷&ñ ØØ&*Ñ#ˆ�˜tØ�z‰z‹|ˆØ�|Ñ#Ø!'ˆL˜ÑØÐ#×)Ñ)Ó+Ò+Ø!ˆLà%ˆð1 ô4 ;FÖ^°$ÈÐQ]ÒI]�T˜<¨Ñ-Ñ-Ð^€MÐ^á,8ˆL˜-Ð(ÐV¸wÈÐ>VÐV÷/&ð &ûô ò 	Ùð	üò _s4   —B? §$B3ÁB? Â	CÂCÂ3B<Â8B? Â?	CÃ
Cc                 óp  — i }| r|s|S | D �cg c]6  }t        |t        «      s"t        |t        «      sŒ$|j                  «       sŒ5|‘Œ8 }}|s|S 	 |j	                  «       5 }|j                  d|f«       |j                  «       D ]  }|d   ||d   <   Œ 	 d d d «       i }| D ]^  }||v r	||   ||<   Œt        |«      j                  «       rt        |«      |v r|t        |«         ||<   ŒH|dv r|||<   ŒR||v sŒWd|› �||<   Œ` |S c c}w # 1 sw Y   ŒuxY w# t        $ r}t        d|› �«       Y d }~Œ”d }~ww xY w)Nzƒ
                SELECT tax_id, name_txt
                FROM scientific_names
                WHERE tax_id = ANY(%s);
            r   r   z![Error] Batch name query failed: )ÚUnknownr   zTaxID:)	Ú
isinstanceÚintÚstrÚisdigitr	   r
   r   r   r   )	Útax_idsr   Úname_mapÚtidÚnumeric_tax_idsr   r   r   Úfinal_name_maps	            r   Úget_latin_names_batchr2   <   si  € Ø€HÙ™$Øˆà&-Ör˜s´¸CÄÔ1EÌ*ÐUXÔZ]ÕJ^Ðcf×cnÑcnÕcp’sÐr€OÐráØˆð
7Ø�[‰[‹]ð 	*˜cØ�K‰Kð ð "Ð#ô	%ð
 —|‘|“~ò *�Ø#& q¡6�˜˜Q™Ò ñ*÷	*ð €NØò 1ˆØ�(‰?Ø"*¨3¡-ˆN˜3ÒÜ�‹X×ÑÔ¤C¨£H°Ñ$8Ø"*¬3¨s«8Ñ"4ˆN˜3ÒØÐ(Ñ(Ø"%ˆN˜3ÒØ�OÒ#Ø$*¨3¨% .ˆN˜3Òð1ð Ðùò9 s÷	*ð 	*ûô ò 7ÜÐ1°!°Ð5×6Ñ6ûð7ús@   �%D³DÁDÁD Á4DÂD ÄDÄD Ä	D5ÄD0Ä0D5N)Úutil.varr   r   r   r   r   r&   r2   © ó    r   ú<module>r6      s   ðß IÓ Iòò$%WóN!r5   