metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA285816" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA285816" 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
4887076	4887076	PRJNA285816_S_NODE_13484_length_207_cov_4.550633_g13382_i0	PRJNA285816	13484	207	4.550633	9.41981031	Leishmania	5658	Euglenozoa	other_Eukaryota	196	7.91e-46	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g13382	i0	96.639	70.1062801932367	119	3	57	1	1	119	991000	990883	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	14512	196	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
6749695	6749695	PRJNA285816_S_NODE_21466_length_176_cov_1.078740_g21364_i0	PRJNA285816	21466	176	1.07874	1.8985824	Monomorphina pyrum	96784	Euglenozoa	other_Eukaryota	150	5.12e-32	NTclustered	gi\|526131140\|gb\|KF383286.1\|	96784	g21364	i0	87.121	1.57954545454545	132	17	75	0	6	137	313	444	Monomorphina pyrum methionine adenosyltransferase (MAT) mRNA, partial cds	blastn	278	150	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Monomorphina	Monomorphina pyrum
9300064	9300064	PRJNA285816_S_NODE_21008_length_177_cov_1.453125_g20906_i0	PRJNA285816	21008	177	1.453125	2.57203125	Leishmania martiniquensis	1580590	Euglenozoa	other_Eukaryota	115	1.88e-21	NTclustered	gi\|2787688158\|ref\|XM_067317733.1\|	1580590	g20906	i0	78.947	2.06214689265537	171	34	96	2	1	170	425	256	Leishmania martiniquensis uncharacterized protein (LSCM1_00074), partial mRNA	blastn	365	115	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania martiniquensis
9987250	9987250	PRJNA285816_S_NODE_16268_length_194_cov_1.434483_g16166_i0	PRJNA285816	16268	194	1.434483	2.78289702	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	52.8	0.017	NTclustered	gi\|1673149906\|ref\|XM_029378342.1\|	5698	g16166	i0	96.774	1.32989690721649	31	1	16	0	146	176	211	241	Trypanosoma rangeli uncharacterized protein (TraAM80_01290), partial mRNA	blastn	258	52.8	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
14400895	14400895	PRJNA285816_S_NODE_14872_length_200_cov_7.205298_g14770_i0	PRJNA285816	14872	200	7.205298	14.410596	Trypanosoma conorhini	83891	Euglenozoa	other_Eukaryota	326	9.27e-85	NTclustered	gi\|1673141461\|ref\|XR_003828664.1\|	83891	g14770	i0	96	135.435	200	8	100	0	1	200	5022	5221	Trypanosoma conorhini 28S ribosomal RNA (Tco025E_06705), rRNA	blastn	27087	326	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini
14401050	14401050	PRJNA285816_S_NODE_2672_length_409_cov_7.997222_g2570_i0	PRJNA285816	2672	409	7.997222	32.70863798	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	551	3.1799999999999985e-152	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g2570	i0	90.887	142.58924205379	417	29	100	7	1	409	4387	4802	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	58319	551	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
14401112	14401112	PRJNA285816_S_NODE_4852_length_311_cov_5.362595_g4750_i0	PRJNA285816	4852	311	5.362595	16.67767045	Neobodo designis	312471	Euglenozoa	other_Eukaryota	512	1.11e-140	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g4750	i0	96.463	159.106109324759	311	10	100	1	1	311	912	1221	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	49482	512	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
15674676	15674676	PRJNA285816_S_NODE_18253_length_186_cov_1.897810_g18151_i0	PRJNA285816	18253	186	1.89781	3.5299266	Trypanosoma conorhini	83891	Euglenozoa	other_Eukaryota	58.4	3.42e-4	NTclustered	gi\|1673142343\|ref\|XM_029373932.1\|	83891	g18151	i0	100	0.166666666666667	31	0	17	0	149	179	363	333	Trypanosoma conorhini uncharacterized protein (Tco025E_07065), partial mRNA	blastn	31	58.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini
15674678	15674678	PRJNA285816_S_NODE_18333_length_186_cov_1.291971_g18231_i0	PRJNA285816	18333	186	1.291971	2.40306606	Entosiphon sulcatum	101493	Euglenozoa	other_Eukaryota	163	7.04e-36	NTclustered	gi\|5733381\|gb\|AF095840.1\|AF095840	101493	g18231	i0	83.243	96.8118279569892	185	23	97	7	1	181	974	1154	Entosiphon sulcatum b-tubulin (tub-b) gene, complete cds	blastn	18007	163	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemataceae	Entosiphon	Entosiphon sulcatum
17636773	17636773	PRJNA285816_S_NODE_22574_length_172_cov_3.975610_g22472_i0	PRJNA285816	22574	172	3.97561	6.8380492	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	195	2.27e-45	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g22472	i0	88.75	112.912790697674	160	17	93	1	1	160	6865	7023	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	19421	196	0.994897959183674	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
18223805	18223805	PRJNA285816_S_NODE_6955_length_266_cov_4.857143_g6853_i0	PRJNA285816	6955	266	4.857143	12.92000038	Neobodo designis	312471	Euglenozoa	other_Eukaryota	462	9.48e-126	NTclustered	gi\|33317834\|gb\|AF464896.1\|	312471	g6853	i0	98.12	99.4624060150376	266	4	100	1	1	266	1813	2077	Bodo designis strain DH 18S small subunit ribosomal RNA gene, partial sequence	blastn	26457	462	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
20185174	20185174	PRJNA285816_S_NODE_19656_length_181_cov_3.757576_g19554_i0	PRJNA285816	19656	181	3.757576	6.80121256	root	1	Root_unresolved	Root_unresolved	56.5	0.001	NTclustered	gi\|2593260053\|emb\|OY748516.1\|	5660	g19554	i0	96.97	11.5138121546961	33	1	18	0	47	79	1175174	1175142	Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 30	blastn	2084	56.5	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
20185212	20185212	PRJNA285816_S_NODE_3876_length_343_cov_5.523810_g3774_i0	PRJNA285816	3876	343	5.52381	18.9466683	Leishmania	5658	Euglenozoa	other_Eukaryota	246	1.39e-60	NTclustered	gi\|440222381\|gb\|JX030049.1\|	5659	g3774	i0	95.484	84.7638483965015	155	6	66	1	190	343	822	668	Leishmania amazonensis isolate LaPH8.rRNA.25 28S ribosomal RNA (LSU-beta), partial sequence	blastn	29074	246	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
20773353	20773353	PRJNA285816_S_NODE_10697_length_225_cov_1.647727_g10595_i0	PRJNA285816	10697	225	1.647727	3.70738575	Bodo saltans	75058	Euglenozoa	other_Eukaryota	156	1.48e-33	NTclustered	gi\|301014698\|gb\|GQ377700.1\|	75058	g10595	i0	82.955	48.0355555555556	176	26	77	4	2	175	243	70	Bodo saltans ribosomal protein S23a (rps23a) mRNA, complete cds	blastn	10808	156	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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