metadata: contig_metadata: 20 rows where bioproject = "PRJNA700095" and tax

20 rows where bioproject = "PRJNA700095" and tax_phylum = "Euglenozoa"

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
2459479	2459479	PRJNA700095_P_NODE_70822_length_202_cov_13.348837_g69557_i0	PRJNA700095	70822	202	13.348837	26.96465074	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	259	9.65e-65	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g69557	i0	91.146	115.826732673267	192	16	95	1	9	200	6835	7025	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	23397	261	0.992337164750958	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
3735982	3735982	PRJNA700095_P_NODE_29383_length_313_cov_5.341667_g28119_i0	PRJNA700095	29383	313	5.341667	16.71941771	Leishmania	5658	Euglenozoa	other_Eukaryota	265	3.45e-66	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g28119	i0	95.238	73.7987220447284	168	6	53	2	147	313	990876	991042	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	23099	265	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
5012552	5012552	PRJNA700095_P_NODE_7684_length_715_cov_21.219626_g6534_i0	PRJNA700095	7684	715	21.219626	151.7203259	Leishmania	5658	Euglenozoa	other_Eukaryota	791	0	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g6534	i0	86.767	119.013986013986	733	70	99	20	1	713	989661	990386	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	85095	791	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
8837181	8837181	PRJNA700095_P_NODE_9547_length_632_cov_13.846154_g8328_i0	PRJNA700095	9547	632	13.846154	87.50769328	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	1044	0	NTclustered	gi\|45739063\|gb\|AY490221.1\|	266813	g8328	i0	96.524	99.8544303797468	633	19	100	3	1	632	2082	1452	Bodo celer 18S ribosomal RNA gene, partial sequence	blastn	63108	1044	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo celer
13437117	13437117	PRJNA700095_P_NODE_68751_length_228_cov_22.464516_g67486_i0	PRJNA700095	68751	228	22.464516	51.21909648	Neobodo designis	312471	Euglenozoa	other_Eukaryota	366	6.39e-97	NTclustered	gi\|77994645\|gb\|DQ207583.1\|	312471	g67486	i0	96.018	97.9342105263158	226	7	99	2	4	228	982	758	Neobodo designis strain HFCC306 18S ribosomal RNA gene, partial sequence	blastn	22329	366	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
15985841	15985841	PRJNA700095_P_NODE_44613_length_264_cov_14.785340_g43349_i0	PRJNA700095	44613	264	14.78534	39.0332976	Neobodo designis	312471	Euglenozoa	other_Eukaryota	475	1.2099999999999996e-129	NTclustered	gi\|59891959\|gb\|AY753619.1\|	312471	g43349	i0	99.615	99.3295454545455	260	1	98	0	1	260	428	687	Neobodo designis isolate TeToto4 18S ribosomal RNA gene, partial sequence	blastn	26223	475	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
17260995	17260995	PRJNA700095_P_NODE_16794_length_442_cov_10.509485_g15531_i0	PRJNA700095	16794	442	10.509485	46.4519237	Neobodo designis	312471	Euglenozoa	other_Eukaryota	529	1.62e-145	NTclustered	gi\|77994645\|gb\|DQ207583.1\|	312471	g15531	i0	94.017	112.647058823529	351	18	79	2	1	348	351	1	Neobodo designis strain HFCC306 18S ribosomal RNA gene, partial sequence	blastn	49790	529	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
18534972	18534972	PRJNA700095_P_NODE_27315_length_326_cov_17.501976_g26051_i0	PRJNA700095	27315	326	17.501976	57.05644176	Neobodo designis	312471	Euglenozoa	other_Eukaryota	575	1.4699999999999996e-159	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g26051	i0	98.476	160.092024539877	328	2	100	2	1	326	896	1222	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	52190	575	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
21085628	21085628	PRJNA700095_P_NODE_45077_length_263_cov_12.784211_g43813_i0	PRJNA700095	45077	263	12.784211	33.62247493	Trypanosoma conorhini	83891	Euglenozoa	other_Eukaryota	438	1.5799999999999996e-118	NTclustered	gi\|1673141461\|ref\|XR_003828664.1\|	83891	g43813	i0	96.935	139.342205323194	261	8	99	0	3	263	4971	5231	Trypanosoma conorhini 28S ribosomal RNA (Tco025E_06705), rRNA	blastn	36647	438	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini
21586522	21586522	PRJNA700095_P_NODE_67157_length_235_cov_11.419753_g65893_i0	PRJNA700095	67157	235	11.419753	26.83641955	Leishmania	5658	Euglenozoa	other_Eukaryota	267	6.91e-67	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g65893	i0	89.352	83.8170212765957	216	18	91	5	4	217	990749	990537	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	19697	267	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
26670927	26670927	PRJNA700095_P_NODE_2961_length_1128_cov_2.759242_g2231_i0	PRJNA700095	2961	1128	2.759242	31.12424976	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	360	5.999999999999999e-114	NR	KAJ9455383.1	91374	g2231	i0	56.3	2.84042553191489	334	128	88.6	7	1001	3	464	780	KAJ9455383.1 2-oxoisovalerate dehydrogenase subunit beta [Diplonema papillatum]	diamond	3204	360	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
26924625	26924625	PRJNA700095_P_NODE_5402_length_849_cov_2.503866_g4387_i0	PRJNA700095	5402	849	2.503866	21.25782234	Bodo saltans	75058	Euglenozoa	other_Eukaryota	123	8.22e-28	NR	CUG88796.1	75058	g4387	i0	36.7	0.597173144876325	169	100	57.6	4	30	518	419	586	CUG88796.1 cation ATPase alpha subunit, putative, partial [Bodo saltans]	diamond	507	123	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
26956041	26956041	PRJNA700095_P_NODE_22182_length_370_cov_1.898990_g20918_i0	PRJNA700095	22182	370	1.89899	7.026263	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	58.5	4.07e-7	NR	KAJ9468047.1	91374	g20918	i0	33.3	2.69189189189189	117	56	87.6	4	368	45	256	359	KAJ9468047.1 hypothetical protein DIPPA_34511 [Diplonema papillatum]	diamond	996	58.5	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27998901	27998901	PRJNA700095_P_NODE_17405_length_432_cov_3.208914_g16142_i0	PRJNA700095	17405	432	3.208914	13.86250848	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	106	2.46e-24	NR	KAJ9442796.1	91374	g16142	i0	45.5	3.33333333333333	121	66	84	0	3	365	214	334	KAJ9442796.1 hypothetical protein DIPPA_16099 [Diplonema papillatum]	diamond	1440	106	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
28914129	28914129	PRJNA700095_P_NODE_36488_length_285_cov_1.330189_g35224_i0	PRJNA700095	36488	285	1.330189	3.79103865	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	92.8	1.58e-19	NR	KAJ9443059.1	91374	g35224	i0	52.2	0.947368421052632	90	43	94.7	0	284	15	1171	1260	KAJ9443059.1 Upf0753 protein [Diplonema papillatum]	diamond	270	92.8	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29482462	29482462	PRJNA700095_P_NODE_3030_length_1118_cov_2.516746_g2287_i0	PRJNA700095	3030	1118	2.516746	28.13722028	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	290	7.48e-92	NR	KAJ9460099.1	91374	g2287	i0	43.5	0.998211091234347	372	180	99.6	8	1114	2	39	381	KAJ9460099.1 Pectin acetylesterase 3 [Diplonema papillatum]	diamond	1116	290	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
30841094	30841094	PRJNA700095_P_NODE_28874_length_316_cov_2.489712_g27610_i0	PRJNA700095	28874	316	2.489712	7.86748992	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	68.2	9.37e-11	NR	KAJ9468047.1	91374	g27610	i0	36.6	1.06329113924051	112	62	99.7	2	2	316	151	260	KAJ9468047.1 hypothetical protein DIPPA_34511 [Diplonema papillatum]	diamond	336	68.2	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31757855	31757855	PRJNA700095_P_NODE_26977_length_329_cov_1.503906_g25713_i0	PRJNA700095	26977	329	1.503906	4.94785074	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	101	3.9699999999999997e-23	NR	KAJ9442796.1	91374	g25713	i0	50.5	1.67781155015198	97	47	87.5	1	3	290	189	285	KAJ9442796.1 hypothetical protein DIPPA_16099 [Diplonema papillatum]	diamond	552	101	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
32496960	32496960	PRJNA700095_P_NODE_31199_length_306_cov_2.163090_g29935_i0	PRJNA700095	31199	306	2.16309	6.6190554	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	101	5.59e-23	NR	CUI15460.1	75058	g29935	i0	53	6.90196078431373	100	47	98	0	305	6	127	226	CUI15460.1 sodium potassium-transporting ATPase subunit alpha, putative [Bodo saltans]	diamond	2112	101	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
32549119	32549119	PRJNA700095_P_NODE_34279_length_291_cov_5.270642_g33015_i0	PRJNA700095	34279	291	5.270642	15.33756822	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	65.5	6.38e-10	NR	XP_009307861.1	71804	g33015	i0	46	2.25773195876289	63	34	64.9	0	98	286	4	66	XP_009307861.1 putative phosphomevalonate kinase protein [Trypanosoma grayi]	diamond	657	65.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi

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