metadata: contig_metadata: 18 rows where bioproject = "PRJNA432257", tax_clade = "Sar" and tax

18 rows where bioproject = "PRJNA432257", 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
1704050	1704050	PRJNA432257_S_NODE_125082_length_152_cov_3.626087_g124701_i0	PRJNA432257	125082	152	3.626087	5.51165224	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	60.2	7.43e-5	NTclustered	gi\|820688590\|tpe\|LN714475.1\|	572307	g124701	i0	94.872	0.625	39	1	25	1	115	152	708333	708295	TPA_asm: Neospora caninum Liverpool, chromosome chrIb, complete genome	blastn	95	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
4255943	4255943	PRJNA432257_S_NODE_106624_length_170_cov_1.864662_g106243_i0	PRJNA432257	106624	170	1.864662	3.1699254	Toxoplasma gondii	5811	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.014	NTclustered	gi\|820698309\|tpe\|LN714497.1\|	432359	g106243	i0	100	0.164705882352941	28	0	16	0	65	92	1102439	1102466	TPA_asm: Toxoplasma gondii VEG, chromosome chrVIIb, complete genome	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Toxoplasma	Toxoplasma gondii
4256487	4256487	PRJNA432257_S_NODE_34544_length_265_cov_40.614035_g34163_i0	PRJNA432257	34544	265	40.614035	107.62719275	Cryptosporidium sp. chipmunk genotype I	1280935	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.024	NTclustered	gi\|2787708287\|ref\|XM_067344869.1\|	1280935	g34163	i0	100	0.105660377358491	28	0	11	0	61	88	986	959	Cryptosporidium sp. chipmunk genotype I membrane associated HD superfamily cyclic nucleotide phosphodiesterase domain containing (ELE39_002019), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp. chipmunk genotype I
4256748	4256748	PRJNA432257_S_NODE_51104_length_229_cov_4.473958_g50723_i0	PRJNA432257	51104	229	4.473958	10.24536382	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	333	6.519999999999999e-87	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g50723	i0	93.392	26.2576419213974	227	12	100	3	1	227	278	501	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	6013	333	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
5533869	5533869	PRJNA432257_S_NODE_79405_length_193_cov_90.269231_g79024_i0	PRJNA432257	79405	193	90.269231	174.21961583	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	219	1.55e-52	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g79024	i0	91.25	18.4870466321244	160	14	84	0	1	160	300436	300595	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3568	219	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
6191711	6191711	PRJNA432257_S_NODE_26965_length_290_cov_3.462451_g26584_i0	PRJNA432257	26965	290	3.462451	10.0411079	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.027	NTclustered	gi\|1145262039\|ref\|XM_012909119.2\|	5854	g26584	i0	100	0.289655172413793	28	0	10	0	230	257	1523	1496	Plasmodium reichenowi N2,N2-dimethylguanosine tRNA methyltransferase, putative partial mRNA	blastn	84	52.8	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium reichenowi
6807467	6807467	PRJNA432257_S_NODE_49746_length_231_cov_140.025773_g49365_i0	PRJNA432257	49746	231	140.025773	323.45953563	Eimeria maxima	5804	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.021	NTclustered	gi\|915132192\|ref\|XM_013480240.1\|	5804	g49365	i0	100	0.121212121212121	28	0	12	0	169	196	2629	2602	Eimeria maxima hypothetical protein, conserved partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria maxima
8082420	8082420	PRJNA432257_S_NODE_11867_length_385_cov_1.589080_g11495_i0	PRJNA432257	11867	385	1.58908	6.117958	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	300	1.19e-76	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g11495	i0	89.54	8.66233766233766	239	22	98	3	1	237	299614	299851	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	3335	300	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
10632895	10632895	PRJNA432257_S_NODE_106269_length_170_cov_3.909774_g105888_i0	PRJNA432257	106269	170	3.909774	6.6466158	Plasmodium sp. gorilla clade G2	880535	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.004	NTclustered	gi\|1620158959\|ref\|XM_028681669.1\|	880535	g105888	i0	100	0.170588235294118	29	0	17	0	29	57	2145	2117	Plasmodium sp. gorilla clade G2 ubiquitin carboxyl-terminal hydrolase 1, putative (PADL01_0101900), partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium sp. gorilla clade G2
14458677	14458677	PRJNA432257_S_NODE_53392_length_225_cov_74.558511_g53011_i0	PRJNA432257	53392	225	74.558511	167.75664975	Eimeria tenella	5802	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.02	NTclustered	gi\|916425495\|ref\|XM_013378525.1\|	5802	g53011	i0	96.774	0.137777777777778	31	1	14	0	153	183	1400	1370	Eimeria tenella intracellular protease, putative (ETH_00008560), partial mRNA	blastn	31	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella
15731913	15731913	PRJNA432257_S_NODE_17433_length_337_cov_8.180000_g17052_i0	PRJNA432257	17433	337	8.18	27.5666	Cryptosporidium sp. chipmunk genotype I	1280935	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.032	NTclustered	gi\|2787708287\|ref\|XM_067344869.1\|	1280935	g17052	i0	100	0.0830860534124629	28	0	8	0	61	88	986	959	Cryptosporidium sp. chipmunk genotype I membrane associated HD superfamily cyclic nucleotide phosphodiesterase domain containing (ELE39_002019), partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Cryptosporidiidae	Cryptosporidium	Cryptosporidium sp. chipmunk genotype I
17006831	17006831	PRJNA432257_S_NODE_33514_length_268_cov_35.991342_g33133_i0	PRJNA432257	33514	268	35.991342	96.45679656	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	337	6.05e-88	NTclustered	gi\|1624698156\|ref\|XM_029013946.1\|	189622	g33133	i0	93.45	22.9328358208955	229	11	86	3	39	267	322	98	Babesia ovata CTP synthase, putative (BOVATA_050290), partial mRNA	blastn	6146	337	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
17007297	17007297	PRJNA432257_S_NODE_69854_length_203_cov_220.692771_g69473_i0	PRJNA432257	69854	203	220.692771	448.00632513	Eimeria mitis	44415	SAR_Eukaryotes	SAR_Eukaryotes	60.2	1.06e-4	NTclustered	gi\|916511703\|ref\|XM_013500566.1\|	44415	g69473	i0	100	0.58128078817734	32	0	16	0	129	160	434	465	Eimeria mitis uncharacterized protein (EMH_0082690), partial mRNA	blastn	118	60.2	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria mitis
18281401	18281401	PRJNA432257_S_NODE_51435_length_228_cov_138.031414_g51054_i0	PRJNA432257	51435	228	138.031414	314.71162392	Gregarina sp. Phaedon/Daegwallyeong/2010	1049247	SAR_Eukaryotes	SAR_Eukaryotes	180	8.94e-41	NTclustered	gi\|339715944\|gb\|JF412715.1\|	1049247	g51054	i0	85.549	0.758771929824561	173	24	75	1	20	191	4841	4669	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	173	180	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eugregarinorida	Gregarinidae	Gregarina	Gregarina sp. Phaedon/Daegwallyeong/2010
24655772	24655772	PRJNA432257_S_NODE_26360_length_292_cov_17.305882_g25979_i0	PRJNA432257	26360	292	17.305882	50.53317544	Neospora caninum	29176	SAR_Eukaryotes	SAR_Eukaryotes	265	3.19e-66	NTclustered	gi\|820695469\|tpe\|LN714488.1\|	572307	g25979	i0	86.722	16.1678082191781	241	29	89	3	20	259	96676	96438	TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome	blastn	4721	265	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Sarcocystidae	Neospora	Neospora caninum
27012456	27012456	PRJNA432257_S_NODE_21202_length_316_cov_2.197133_g20821_i0	PRJNA432257	21202	316	2.197133	6.94294028	Babesia bovis T2Bo	484906	SAR_Eukaryotes	SAR_Eukaryotes	73.2	2.91e-14	NR	XP_001610942.1	484906	g20821	i0	57.4	0.579113924050633	61	25	57	1	311	132	42	102	XP_001610942.1 putative ribosomal protein S25 [Babesia bovis T2Bo]	diamond	183	73.2	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia bovis
28339139	28339139	PRJNA432257_S_NODE_30346_length_278_cov_4.514523_g29965_i0	PRJNA432257	30346	278	4.514523	12.55037394	Plasmodium yoelii 17X	1323249	SAR_Eukaryotes	SAR_Eukaryotes	43.9	0.0231	NR	ETB61003.1	1323249	g29965	i0	30.3	0.712230215827338	66	45	70.1	1	248	54	851	916	ETB61003.1 hypothetical protein YYC_01952 [Plasmodium yoelii 17X]	diamond	198	43.9	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii
29002613	29002613	PRJNA432257_S_NODE_61088_length_214_cov_48.909605_g60707_i0	PRJNA432257	61088	214	48.909605	104.6665547	Plasmodium falciparum 7G8	57266	SAR_Eukaryotes	SAR_Eukaryotes	40.4	0.0357	NR	EUR71841.1	57266	g60707	i0	36.8	0.799065420560748	57	36	79.9	0	36	206	23	79	EUR71841.1 hypothetical protein PFBG_02867 [Plasmodium falciparum 7G8]	diamond	171	40.4	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum

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