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

9 rows where bioproject = "PRJEB81463" 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
4825463	4825463	PRJEB81463_P_NODE_8324_length_348_cov_4.287273_g8052_i0	PRJEB81463	8324	348	4.287273	14.91971004	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	166	1.46e-49	NR	XP_013233901.1	5802	g8052	i0	74.3	4.82758620689655	113	28	96.6	1	345	10	76	188	XP_013233901.1 40S ribosomal protein S9, putative [Eimeria tenella]	diamond	1680	166	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
16300023	16300023	PRJEB81463_P_NODE_13293_length_286_cov_1.450704_g13021_i0	PRJEB81463	13293	286	1.450704	4.14901344	Apicomplexa	5794	SAR_Eukaryotes	SAR_Eukaryotes	123	2.3699999999999996e-31	NR	XP_029219060.1	94643	g13021	i0	64.2	4.98251748251748	95	32	98.6	2	4	285	95	188	XP_029219060.1 ribosomal protein RPL3 [Besnoitia besnoiti]	diamond	1425	123	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti
17991910	17991910	PRJEB81463_P_NODE_15675_length_274_cov_1.164179_g15403_i0	PRJEB81463	15675	274	1.164179	3.18985046	Theileria equi strain WA	1537102	SAR_Eukaryotes	SAR_Eukaryotes	115	2.6199999999999997e-30	NR	XP_004829363.1	1537102	g15403	i0	62.2	0.985401459854015	90	33	98.5	1	4	273	4	92	XP_004829363.1 60S ribosomal protein L17, putative [Theileria equi strain WA]	diamond	270	115	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Theileriidae	Theileria	Theileria equi
20541618	20541618	PRJEB81463_P_NODE_4897_length_452_cov_2.936675_g4625_i0	PRJEB81463	4897	452	2.936675	13.273771	Plasmodium reichenowi	5854	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.012	NTclustered	gi\|1145257752\|ref\|XM_020114622.1\|	5854	g4625	i0	100	0.0641592920353982	29	0	6	0	207	235	1487	1515	Plasmodium reichenowi hypothetical protein partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
23092268	23092268	PRJEB81463_P_NODE_14559_length_279_cov_1.922330_g14287_i0	PRJEB81463	14559	279	1.92233	5.3633007	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	353	6.289999999999999e-93	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g14287	i0	90.217	2.01075268817204	276	20	98	7	8	279	80280	80552	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	561	353	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
28424047	28424047	PRJEB81463_P_NODE_15386_length_275_cov_1.693069_g15114_i0	PRJEB81463	15386	275	1.693069	4.65593975	Cystoisospora suis	483139	SAR_Eukaryotes	SAR_Eukaryotes	63.2	3.54e-9	NR	XP_067919922.1	483139	g15114	i0	42.2	0.981818181818182	90	47	98.2	4	1	270	10	94	XP_067919922.1 alpha beta hydrolase [Cystoisospora suis]	diamond	270	63.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Cystoisospora	Cystoisospora suis
29048225	29048225	PRJEB81463_P_NODE_27188_length_243_cov_1.323529_g26916_i0	PRJEB81463	27188	243	1.323529	3.21617547	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	105	2.45e-26	NR	XP_012336428.1	5857	g26916	i0	67.1	34.2098765432099	79	26	97.5	0	238	2	29	107	XP_012336428.1 uncharacterized protein AK88_03388 [Plasmodium fragile]	diamond	8313	106	0.990566037735849	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium fragile
30280161	30280161	PRJEB81463_P_NODE_16932_length_267_cov_1.572165_g16660_i0	PRJEB81463	16932	267	1.572165	4.19768055	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	107	7.99e-27	NR	KAK1444384.1	33632	g16660	i0	67.5	5.59550561797753	83	24	91	2	1	243	53	134	KAK1444384.1 hypothetical protein BgAZ_102900 [Babesia gibsoni]	diamond	1494	108	0.990740740740741	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia gibsoni
31045682	31045682	PRJEB81463_P_NODE_11795_length_296_cov_1.726457_g11523_i0	PRJEB81463	11795	296	1.726457	5.11031272	Besnoitia besnoiti	94643	SAR_Eukaryotes	SAR_Eukaryotes	111	1.3800000000000002e-27	NR	XP_029215743.1	94643	g11523	i0	71.8	1.43918918918919	71	20	72	0	295	83	183	253	XP_029215743.1 ribosomal protein RPS4 [Besnoitia besnoiti]	diamond	426	111	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Besnoitia	Besnoitia besnoiti

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