metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1108009" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1108009" 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
212953	212953	PRJNA1108009_P_NODE_21441_length_276_cov_1.379310_g21123_i0	PRJNA1108009	21441	276	1.37931	3.8068956	Peranema trichophorum	56466	Euglenozoa	other_Eukaryota	470	5.91e-128	NTclustered	gi\|118738152\|gb\|EF114757.1\|	56466	g21123	i0	97.455	0.996376811594203	275	7	99	0	1	275	1156	882	Peranema trichophorum pyruvate:NADP+ oxidoreductase (pno) mRNA, partial cds	blastn	275	470	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemidae	Peranema	Peranema trichophorum
2763837	2763837	PRJNA1108009_P_NODE_28423_length_246_cov_0.890173_g28105_i0	PRJNA1108009	28423	246	0.890173	2.18982558	Bodo saltans	75058	Euglenozoa	other_Eukaryota	366	6.99e-97	NTclustered	gi\|226347424\|gb\|FJ807252.1\|	75058	g28105	i0	93.496	85.1585365853659	246	16	100	0	1	246	236	481	Bodo saltans strain CCAP 1907/2 elongation factor 1 alpha gene, partial cds	blastn	20949	366	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
6591040	6591040	PRJNA1108009_P_NODE_21006_length_280_cov_1.053140_g20688_i0	PRJNA1108009	21006	280	1.05314	2.948792	Leishmania martiniquensis	1580590	Euglenozoa	other_Eukaryota	143	1.49e-29	NTclustered	gi\|2787688236\|ref\|XM_067317772.1\|	1580590	g20688	i0	76.429	2	280	56	98	9	1	275	286	12	Leishmania martiniquensis uncharacterized protein (LSCM1_00113), partial mRNA	blastn	560	143	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania martiniquensis
11223884	11223884	PRJNA1108009_P_NODE_19949_length_288_cov_1.158140_g19631_i0	PRJNA1108009	19949	288	1.15814	3.3354432	Trypanosoma	5690	Euglenozoa	other_Eukaryota	449	8.090000000000001e-122	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g19631	i0	94.792	161.149305555556	288	15	100	0	1	288	4644	4357	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	46411	449	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
15515832	15515832	PRJNA1108009_P_NODE_3733_length_724_cov_0.947773_g3434_i0	PRJNA1108009	3733	724	0.947773	6.86187652	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	370	1.76e-97	NTclustered	gi\|686638956\|ref\|XM_009313649.1\|	71804	g3434	i0	77.551	0.879834254143646	637	128	87	15	52	681	44	672	Trypanosoma grayi 40S ribosomal protein S3a partial mRNA	blastn	637	370	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
16790049	16790049	PRJNA1108009_P_NODE_19954_length_288_cov_1.134884_g19636_i0	PRJNA1108009	19954	288	1.134884	3.26846592	Porcisia hertigi	2761500	Euglenozoa	other_Eukaryota	350	8.44e-92	NTclustered	gi\|2794841449\|ref\|XM_067899058.1\|	2761500	g19636	i0	89.286	116.180555555556	280	28	97	2	10	288	307	585	Porcisia hertigi uncharacterized protein (JKF63_03036), partial mRNA	blastn	33460	350	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Porcisia	Porcisia hertigi
18064567	18064567	PRJNA1108009_P_NODE_19755_length_289_cov_1.550926_g19437_i0	PRJNA1108009	19755	289	1.550926	4.48217614	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	189	1.95e-43	NTclustered	gi\|686640876\|ref\|XM_009314609.1\|	71804	g19437	i0	85.246	8.04498269896194	183	27	63	0	1	183	477	659	Trypanosoma grayi 40S ribosomal protein SA partial mRNA	blastn	2325	189	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
23165172	23165172	PRJNA1108009_P_NODE_18399_length_302_cov_1.637555_g18081_i0	PRJNA1108009	18399	302	1.637555	4.9454161	Bodo cf. uncinatus	202689	Euglenozoa	other_Eukaryota	359	1.48e-94	NTclustered	gi\|25986838\|gb\|AY122633.1\|	202689	g18081	i0	88.158	88.2847682119205	304	32	100	4	1	302	1437	1738	Bodo cf. uncinatus strain ATCC 30904 heat shock protein 90 (HSP-90) gene, partial cds	blastn	26662	359	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo cf. uncinatus
23165679	23165679	PRJNA1108009_P_NODE_8919_length_457_cov_1.994792_g8602_i0	PRJNA1108009	8919	457	1.994792	9.11619944	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	431	4.869999999999999e-116	NTclustered	gi\|1002447406\|ref\|XM_015802755.1\|	157538	g8602	i0	84.245	35.746170678337	457	56	98	15	2	450	1601	2049	Leptomonas pyrrhocoris putative mitochondrial elongation factor 2 (EF2-1) mRNA	blastn	16336	431	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris

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