metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA896554" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA896554" and tax_phylum = "Apicomplexa"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
870590	870590	PRJNA896554_P_NODE_153681_length_250_cov_0.870056_g146141_i0	PRJNA896554	153681	250	0.870056	2.17514	Plasmodium sp. gorilla clade G2	880535	SAR_Eukaryotes	SAR_Eukaryotes	193	1.28e-44	NTclustered	gi\|1620172179\|ref\|XM_028682123.1\|	880535	g146141	i0	80.876	2.952	251	42	99	6	2	249	889	1136	Plasmodium sp. gorilla clade G2 tubulin beta chain (PADL01_1007100), partial mRNA	blastn	738	193	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium sp. gorilla clade G2
872153	872153	PRJNA896554_P_NODE_73881_length_431_cov_2.234637_g66341_i0	PRJNA896554	73881	431	2.234637	9.63128547	Cryptosporidium bovis	310047	SAR_Eukaryotes	SAR_Eukaryotes	58.4	8.94e-4	NTclustered	gi\|2787668277\|ref\|XM_067325946.1\|	310047	g66341	i0	97.143	0.0812064965197216	35	0	8	1	51	84	588	622	Cryptosporidium bovis uncharacterized protein (FG379_000535), partial mRNA	blastn	35	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium bovis
5972927	5972927	PRJNA896554_P_NODE_113425_length_303_cov_0.939130_g105885_i0	PRJNA896554	113425	303	0.93913	2.8455639	Plasmodium sp. gorilla clade G2	880535	SAR_Eukaryotes	SAR_Eukaryotes	63.9	1.3e-5	NTclustered	gi\|1620175784\|ref\|XM_028683396.1\|	880535	g105885	i0	100	6.52805280528053	34	0	11	0	270	303	1203	1170	Plasmodium sp. gorilla clade G2 tetratricopeptide repeat protein, putative (PADL01_1242100), partial mRNA	blastn	1978	63.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium sp. gorilla clade G2
6347720	6347720	PRJNA896554_P_NODE_115185_length_299_cov_1.977876_g107645_i0	PRJNA896554	115185	299	1.977876	5.91384924	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|1620123137\|ref\|XM_028672339.1\|	5849	g107645	i0	96.97	2.24414715719064	33	1	11	0	21	53	7125	7157	Plasmodium gallinaceum CCR4-NOT transcription complex subunit 1, putative (PGAL8A_00331100), partial mRNA	blastn	671	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium gallinaceum
10172288	10172288	PRJNA896554_P_NODE_128208_length_279_cov_1.121359_g120668_i0	PRJNA896554	128208	279	1.121359	3.12859161	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|1145263057\|ref\|XM_012909749.2\|	5854	g120668	i0	100	0.541218637992832	29	0	10	0	237	265	243	271	Plasmodium reichenowi DnaJ protein, putative partial mRNA	blastn	151	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
12350679	12350679	PRJNA896554_P_NODE_54570_length_603_cov_1.307547_g47099_i0	PRJNA896554	54570	603	1.307547	7.88450841	Plasmodium cynomolgi	5827	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.017	NTclustered	gi\|457869355\|ref\|XM_004221551.1\|	1120755	g47099	i0	90.698	0.0713101160862355	43	1	7	2	190	232	655	616	Plasmodium cynomolgi strain B hypothetical protein (PCYB_071540) mRNA, complete cds	blastn	43	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium cynomolgi
13997745	13997745	PRJNA896554_P_NODE_71451_length_446_cov_2.233244_g63911_i0	PRJNA896554	71451	446	2.233244	9.96026824	Cryptosporidium	5806	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.043	NTclustered	gi\|67613816\|ref\|XM_662234.1\|	353151	g63911	i0	96.875	0.143497757847534	32	0	7	1	355	385	591	622	Cryptosporidium hominis TU502 hypothetical protein (Chro.80481) partial mRNA	blastn	64	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium hominis
19095252	19095252	PRJNA896554_P_NODE_155795_length_249_cov_0.875000_g148255_i0	PRJNA896554	155795	249	0.875	2.17875	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|1145257570\|ref\|XM_012906471.2\|	5854	g148255	i0	100	0.449799196787149	28	0	11	0	55	82	569	542	Plasmodium reichenowi transcription elongation factor SPT5, putative partial mRNA	blastn	112	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
22547155	22547155	PRJNA896554_P_NODE_141198_length_261_cov_1.627660_g133658_i0	PRJNA896554	141198	261	1.62766	4.2481926	Cryptosporidium ubiquitum	857276	SAR_Eukaryotes	SAR_Eukaryotes	211	3.71e-50	NTclustered	gi\|1624738154\|ref\|XM_029018599.1\|	857276	g133658	i0	81.818	6.38314176245211	253	45	97	1	5	256	508	760	Cryptosporidium ubiquitum 26s proteasome regulatory subunit S4 like AAA ATPase (cubi_01587), partial mRNA	blastn	1666	211	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium ubiquitum
23821692	23821692	PRJNA896554_P_NODE_109639_length_310_cov_1.299578_g102099_i0	PRJNA896554	109639	310	1.299578	4.0286918	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.73e-4	NTclustered	gi\|83286319\|ref\|XM_725017.1\|	5861	g102099	i0	100	0.283870967741935	32	0	10	0	25	56	743	712	Plasmodium yoelii actin I, putative (PY17X_1461900), partial mRNA	blastn	88	60.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
23822803	23822803	PRJNA896554_P_NODE_156639_length_248_cov_1.674286_g149099_i0	PRJNA896554	156639	248	1.674286	4.15222928	Cryptosporidium bovis	310047	SAR_Eukaryotes	SAR_Eukaryotes	152	2.15e-32	NTclustered	gi\|2787668985\|ref\|XM_067326618.1\|	310047	g149099	i0	78	1.18145161290323	250	49	99	6	1	247	652	406	Cryptosporidium bovis 26S proteasome regulatory subunit 7 (RPT1)-AAA atpase (FG379_000075), partial mRNA	blastn	293	152	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium bovis
25098000	25098000	PRJNA896554_P_NODE_67540_length_473_cov_1.395000_g60000_i0	PRJNA896554	67540	473	1.395	6.59835	Cryptosporidium muris	5808	SAR_Eukaryotes	SAR_Eukaryotes	291	8.96e-74	NTclustered	gi\|209877255\|ref\|XM_002140034.1\|	441375	g60000	i0	80.519	11.2938689217759	385	69	81	6	8	389	771	1152	Cryptosporidium muris RN66 26S protease regulatory subunit 8, putative (CMU_027300), partial mRNA	blastn	5342	291	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium muris
25470488	25470488	PRJNA896554_P_NODE_160520_length_247_cov_0.885057_g152980_i0	PRJNA896554	160520	247	0.885057	2.18609079	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.006	NTclustered	gi\|1843567218\|ref\|XM_034567774.1\|	5823	g152980	i0	100	1.21052631578947	29	0	12	0	57	85	863	891	Plasmodium berghei ANKA BIR protein (PBANKA_0317181), partial mRNA	blastn	299	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium berghei

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;