metadata: contig_metadata: 14 rows where bioproject = "PRJNA758088", tax_clade = "Sar" and tax

14 rows where bioproject = "PRJNA758088", tax_clade = "Sar" 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
3285616	3285616	PRJNA758088_P_NODE_119783_length_383_cov_1.629032_g112813_i0	PRJNA758088	119783	383	1.629032	6.23919256	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	73.1	2.8e-8	NTclustered	gi\|1673122112\|ref\|XM_029366897.1\|	94643	g112813	i0	89.474	0.490861618798956	57	6	15	0	120	176	357	301	Besnoitia besnoiti ribosomal protein RPP1 (BESB_085470), partial mRNA	blastn	188	73.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
4566131	4566131	PRJNA758088_P_NODE_344984_length_243_cov_0.994118_g338013_i0	PRJNA758088	344984	243	0.994118	2.41570674	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	224	4.3899999999999996e-54	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g338013	i0	84.583	7.48559670781893	240	22	99	3	3	241	300581	300806	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	1819	224	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
7115206	7115206	PRJNA758088_P_NODE_260146_length_262_cov_2.174603_g253175_i0	PRJNA758088	260146	262	2.174603	5.69745986	Babesia bigemina	5866	SAR_Eukaryotes	SAR_Eukaryotes	145	3.83e-30	NTclustered	gi\|833486015\|ref\|XM_012912292.1\|	5866	g253175	i0	92.929	39.1717557251908	99	7	38	0	163	261	411	313	Babesia bigemina HISTONE fold protein,putative partial mRNA	blastn	10263	145	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bigemina
8857270	8857270	PRJNA758088_P_NODE_94767_length_432_cov_1.186630_g87797_i0	PRJNA758088	94767	432	1.18663	5.1262416	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	132	2.92e-33	NR	KAF8822145.1	476202	g87797	i0	58.1	9.10416666666667	105	44	72.9	0	3	317	251	355	KAF8822145.1 aldehyde dehydrogenase [Cardiosporidium cionae]	diamond	3933	132	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae
10131993	10131993	PRJNA758088_P_NODE_206808_length_296_cov_1.286996_g199837_i0	PRJNA758088	206808	296	1.286996	3.80950816	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	547	2.8799999999999986e-151	NTclustered	gi\|2792507\|gb\|AF042107.1\|	5802	g199837	i0	100	99.4324324324324	296	0	100	0	1	296	831	536	Eimeria tenella ribosomal protein S3a mRNA, complete cds	blastn	29432	547	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
10942825	10942825	PRJNA758088_P_NODE_66369_length_529_cov_1.368421_g59430_i0	PRJNA758088	66369	529	1.368421	7.23894709	Plasmodium knowlesi	5850	SAR_Eukaryotes	SAR_Eukaryotes	58.4	0.001	NTclustered	gi\|221061126\|ref\|XM_002262097.1\|	5851	g59430	i0	89.13	0.0869565217391304	46	5	9	0	222	267	502	457	Plasmodium knowlesi strain H drug/metabolite transporter DMT1, putative (PKNH_1424800), partial mRNA	blastn	46	58.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium knowlesi
12215843	12215843	PRJNA758088_P_NODE_246650_length_271_cov_0.969697_g239679_i0	PRJNA758088	246650	271	0.969697	2.62787887	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.025	NTclustered	gi\|2795618130\|ref\|XM_068063095.1\|	483139	g239679	i0	94.286	0.129151291512915	35	1	13	1	179	213	10180	10147	Cystoisospora suis uncharacterized protein (CSUI_002896), mRNA	blastn	35	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
19864973	19864973	PRJNA758088_P_NODE_365556_length_241_cov_0.916667_g358585_i0	PRJNA758088	365556	241	0.916667	2.20916747	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	255	1.54e-63	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g358585	i0	85.833	43.4273858921162	240	34	100	0	2	241	299538	299777	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	10466	255	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
19865410	19865410	PRJNA758088_P_NODE_52376_length_611_cov_4.912639_g45620_i0	PRJNA758088	52376	611	4.912639	30.01622429	Cyclospora cayetanensis	88456	SAR_Eukaryotes	SAR_Eukaryotes	200	3.17e-61	NR	OEH76901.1	88456	g45620	i0	61.4	5.90671031096563	176	68	86.4	0	546	19	32	207	OEH76901.1 ribosomal protein rpl19 [Cyclospora cayetanensis]	diamond	3609	200	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Cyclospora	Cyclospora cayetanensis
22413393	22413393	PRJNA758088_P_NODE_233978_length_278_cov_1.780488_g227007_i0	PRJNA758088	233978	278	1.780488	4.94975664	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	127	3.4599999999999995e-35	NR	XP_028869867.1	462227	g227007	i0	64.8	11.7841726618705	91	32	98.2	0	275	3	16	106	XP_028869867.1 Eukaryotic translation initiation factor 5A [Babesia sp. Xinjiang]	diamond	3276	127	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia sp. Xinjiang
27274266	27274266	PRJNA758088_P_NODE_212703_length_292_cov_1.178082_g205732_i0	PRJNA758088	212703	292	1.178082	3.43999944	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	79.3	8.78e-17	NR	XP_013229778.1	5802	g205732	i0	64.6	2.64041095890411	65	23	66.8	0	85	279	35	99	XP_013229778.1 ribosomal protein L41, putative [Eimeria tenella]	diamond	771	79.3	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
27315808	27315808	PRJNA758088_P_NODE_181363_length_315_cov_1.272727_g174392_i0	PRJNA758088	181363	315	1.272727	4.00909005	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	96.7	7.44e-22	NR	XP_003882293.1	572307	g174392	i0	56.4	3.52380952380952	78	34	74.3	0	315	82	123	200	XP_003882293.1 hypothetical protein NCLIV_020480 [Neospora caninum Liverpool]	diamond	1110	97.1	0.995880535530381	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
29042643	29042643	PRJNA758088_P_NODE_104688_length_410_cov_1.130564_g97718_i0	PRJNA758088	104688	410	1.130564	4.6353124	Sarcocystis calchasi	1344799	SAR_Eukaryotes	SAR_Eukaryotes	139	2.31e-37	NR	CAL7858373.1	1344799	g97718	i0	55.6	14.9853658536585	126	53	90	1	381	13	134	259	CAL7858373.1 unnamed protein product [Sarcocystis calchasi]	diamond	6144	139	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Sarcocystis	Sarcocystis calchasi
29074264	29074264	PRJNA758088_P_NODE_180308_length_316_cov_1.267490_g173337_i0	PRJNA758088	180308	316	1.26749	4.0052684	Cardiosporidium cionae	476202	SAR_Eukaryotes	SAR_Eukaryotes	104	1.07e-24	NR	KAF8821041.1	476202	g173337	i0	48.6	0.996835443037975	105	52	99.7	1	315	1	123	225	KAF8821041.1 putative Mitochondrial uncoupling protein 3 [Cardiosporidium cionae]	diamond	315	104	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Nephromycida		Cardiosporidium	Cardiosporidium cionae

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