metadata: contig_metadata: 5 rows where bioproject = "PRJNA591127" and tax

5 rows where bioproject = "PRJNA591127" 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
3690188	3690188	PRJNA591127_P_NODE_20723_length_196_cov_2.352201_g20554_i0	PRJNA591127	20723	196	2.352201	4.61031396	Babesia	5864	SAR_Eukaryotes	SAR_Eukaryotes	86.1	1.67e-12	NTclustered	gi\|833484291\|ref\|XM_012911757.1\|	5866	g20554	i0	96.154	11.7142857142857	52	2	27	0	107	158	279	228	Babesia bigemina 60S ribosomal L22e protein, putative partial mRNA	blastn	2296	86.1	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
5668898	5668898	PRJNA591127_P_NODE_4065_length_359_cov_1.745342_g3897_i0	PRJNA591127	4065	359	1.745342	6.26577778	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	108	7.16e-19	NTclustered	gi\|160358922\|gb\|EU252544.1\|	88456	g3897	i0	79.141	9.53203342618384	163	29	45	5	191	353	1674	1517	Cyclospora cayetanensis 28S large subunit ribosomal RNA gene, partial sequence	blastn	3422	108	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
8218295	8218295	PRJNA591127_P_NODE_28327_length_152_cov_3.756522_g28158_i0	PRJNA591127	28327	152	3.756522	5.70991344	Plasmodium sp. gorilla clade G2	880535	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.001	NTclustered	gi\|1620167712\|ref\|XM_028681606.1\|	880535	g28158	i0	94.595	0.243421052631579	37	1	24	1	17	52	15000	14964	Plasmodium sp. gorilla clade G2 E3 ubiquitin-protein ligase, putative (PADL01_0825300), partial mRNA	blastn	37	56.5	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium sp. gorilla clade G2
24791140	24791140	PRJNA591127_P_NODE_11140_length_220_cov_5.136612_g10971_i0	PRJNA591127	11140	220	5.136612	11.3005464	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	283	6.35e-72	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g10971	i0	92.424	41.0136363636364	198	15	100	0	1	198	299715	299912	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	9023	283	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
28279631	28279631	PRJNA591127_P_NODE_25646_length_165_cov_1.601562_g25477_i0	PRJNA591127	25646	165	1.601562	2.6425773	Babesia gibsoni	33632	SAR_Eukaryotes	SAR_Eukaryotes	76.6	1.11e-15	NR	KAK1443061.1	33632	g25477	i0	75.5	4.8	53	13	96.4	0	6	164	2	54	KAK1443061.1 60S ribosomal protein L19 like protein [Babesia gibsoni]	diamond	792	76.6	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni

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);;