metadata: contig_metadata: 9 rows where bioproject = "PRJNA404067" and tax

9 rows where bioproject = "PRJNA404067" 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
1689723	1689723	PRJNA404067_P_NODE_5562_length_565_cov_5.317460_g5201_i0	PRJNA404067	5562	565	5.31746	30.043649	uncultured Gregarina	2480866	SAR_Eukaryotes	SAR_Eukaryotes	830	0	NTclustered	gi\|1496531432\|gb\|MG766260.1\|	2480866	g5201	i0	93.11	77.3592920353982	566	36	100	2	1	565	1066	503	Uncultured Gregarina small subunit ribosomal RNA gene, partial sequence	blastn	43708	830	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida			uncultured Gregarina
6792157	6792157	PRJNA404067_P_NODE_15726_length_261_cov_6.660000_g15339_i0	PRJNA404067	15726	261	6.66	17.3826	Gregarinasina sp. PA8	2565589	SAR_Eukaryotes	SAR_Eukaryotes	431	2.62e-116	NTclustered	gi\|1664596165\|dbj\|LC474291.1\|	2565589	g15339	i0	96.552	89.551724137931	261	8	100	1	1	261	296	37	Gregarinasina sp. PA8 gene for 18S ribosomal RNA, partial sequence	blastn	23373	431	1	Eukaryota	Sar	Apicomplexa	Conoidasida				Gregarinasina sp. PA8
13168365	13168365	PRJNA404067_P_NODE_26991_length_218_cov_1.171975_g26604_i0	PRJNA404067	26991	218	1.171975	2.5549055	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	388	1.29e-103	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g26604	i0	99.074	33.5183486238532	216	2	100	0	1	216	301529	301744	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	7307	388	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13168460	13168460	PRJNA404067_P_NODE_32591_length_207_cov_1.650685_g32204_i0	PRJNA404067	32591	207	1.650685	3.41691795	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	255	1.29e-63	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g32204	i0	88.942	40.2995169082126	208	22	100	1	1	207	299919	299712	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	8342	255	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
13834969	13834969	PRJNA404067_P_NODE_42591_length_185_cov_4.532258_g42204_i0	PRJNA404067	42591	185	4.532258	8.3846773	Stenophora	650298	SAR_Eukaryotes	SAR_Eukaryotes	106	1.2e-18	NTclustered	gi\|2295827471\|gb\|OP390086.1\|	2976838	g42204	i0	91.026	35.4	78	7	42	0	104	181	5221	5144	Stenophora sp. TMiroliubova-2022a isolate Sr1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	6549	106	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Stenophoridae	Stenophora	Stenophora nickeli
14443846	14443846	PRJNA404067_P_NODE_8372_length_389_cov_2.448171_g7990_i0	PRJNA404067	8372	389	2.448171	9.52338519	Gregarina sp. Phaedon/Daegwallyeong/2010	1049247	SAR_Eukaryotes	SAR_Eukaryotes	303	9.29e-78	NTclustered	gi\|339715944\|gb\|JF412715.1\|	1049247	g7990	i0	81.122	59.2236503856041	392	63	100	9	1	389	4114	4497	Gregarina sp. Phaedon/Daegwallyeong/2010 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence	blastn	23038	303	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina sp. Phaedon/Daegwallyeong/2010
23367003	23367003	PRJNA404067_P_NODE_9319_length_365_cov_1.286184_g8934_i0	PRJNA404067	9319	365	1.286184	4.6945716	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	564	3.6e-156	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g8934	i0	94.521	52.4821917808219	365	20	100	0	1	365	116279	116643	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	19156	564	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
24641299	24641299	PRJNA404067_P_NODE_43620_length_176_cov_4.860870_g43233_i0	PRJNA404067	43620	176	4.86087	8.5551312	Theileria luwenshuni	540482	SAR_Eukaryotes	SAR_Eukaryotes	87.9	4.07e-13	NTclustered	gi\|2868556105\|gb\|PQ720765.2\|	540482	g43233	i0	94.643	29.3238636363636	56	3	32	0	119	174	919	974	Theileria luwenshuni isolate TC-H4-160 small subunit ribosomal RNA gene, partial sequence	blastn	5161	87.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria luwenshuni
28496722	28496722	PRJNA404067_P_NODE_15047_length_267_cov_3.033981_g14660_i0	PRJNA404067	15047	267	3.033981	8.10072927	Babesia gibsoni	33632	SAR_Eukaryotes	SAR_Eukaryotes	119	1.8099999999999999e-31	NR	KAK1441808.1	33632	g14660	i0	67.1	7.65168539325843	85	28	95.5	0	261	7	38	122	KAK1441808.1 ribosomal protein L22/L17 like protein [Babesia gibsoni]	diamond	2043	119	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);;