metadata: contig_metadata: 13 rows where bioproject = "PRJNA1067443" and tax

13 rows where bioproject = "PRJNA1067443" 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
1013573	1013573	PRJNA1067443_P_NODE_701_length_630_cov_14.684022_g683_i0	PRJNA1067443	701	630	14.684022	92.5093386	Bodo	5712	Euglenozoa	other_Eukaryota	1147	0	NTclustered	gi\|45739068\|gb\|AY490226.1\|	75058	g683	i0	99.523	99.8333333333333	629	3	99	0	1	629	2107	1479	Bodo saltans 18S ribosomal RNA gene, partial sequence	blastn	62895	1147	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
1456167	1456167	PRJNA1067443_P_NODE_2062_length_466_cov_12.488550_g2044_i0	PRJNA1067443	2062	466	12.48855	58.196643	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	494	6.26e-135	NTclustered	gi\|2026667531\|dbj\|LC618031.1\|	67003	g2044	i0	85.804	119.568669527897	479	52	100	14	1	466	5634	5159	Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence	blastn	55719	494	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
3564059	3564059	PRJNA1067443_P_NODE_2543_length_437_cov_7.140110_g2525_i0	PRJNA1067443	2543	437	7.14011	31.2022807	Leishmania	5658	Euglenozoa	other_Eukaryota	381	4.739999999999999e-101	NTclustered	gi\|440222381\|gb\|JX030049.1\|	5659	g2525	i0	96.93	96.2173913043478	228	6	73	1	1	227	595	822	Leishmania amazonensis isolate LaPH8.rRNA.25 28S ribosomal RNA (LSU-beta), partial sequence	blastn	42047	381	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
7391202	7391202	PRJNA1067443_P_NODE_24406_length_199_cov_10.650794_g24388_i0	PRJNA1067443	24406	199	10.650794	21.19508006	Trypanosoma	5690	Euglenozoa	other_Eukaryota	357	3.2699999999999996e-94	NTclustered	gi\|162233\|gb\|M63699.1\|TRBRGS1	5693	g24388	i0	98.995	129.326633165829	199	2	100	0	1	199	261	63	T.cruzi S3 ribosomal RNA gene	blastn	25736	357	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
7834058	7834058	PRJNA1067443_P_NODE_2127_length_462_cov_8.496144_g2109_i0	PRJNA1067443	2127	462	8.496144	39.25218528	Crithidia fasciculata	5656	Euglenozoa	other_Eukaryota	459	2.26e-124	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g2109	i0	84.694	115.354978354978	490	42	100	20	1	462	7074	7558	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	53294	459	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
7834243	7834243	PRJNA1067443_P_NODE_767_length_616_cov_8.742173_g749_i0	PRJNA1067443	767	616	8.742173	53.85178568	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	856	0	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g749	i0	91.707	112.090909090909	627	36	100	14	1	616	6335	5714	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	69048	856	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
7834268	7834268	PRJNA1067443_P_NODE_8747_length_295_cov_14.657658_g8729_i0	PRJNA1067443	8747	295	14.657658	43.2400911	Bodo saltans	75058	Euglenozoa	other_Eukaryota	516	8.08e-142	NTclustered	gi\|225216789\|gb\|FJ176704.1\|	75058	g8729	i0	98.299	142.308474576271	294	5	99	0	1	294	581	874	Bodo saltans HFCC12 28S ribosomal RNA gene, partial sequence	blastn	41981	516	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
12935280	12935280	PRJNA1067443_P_NODE_23171_length_236_cov_7.680982_g23153_i0	PRJNA1067443	23171	236	7.680982	18.12711752	Bodo saltans	75058	Euglenozoa	other_Eukaryota	398	2.36e-106	NTclustered	gi\|68271530\|gb\|DQ086711.1\|	75058	g23153	i0	97.034	160.949152542373	236	7	100	0	1	236	387	622	Bodo saltans isolate BODOSALT large subunit ribosomal RNA gene, partial sequence	blastn	37984	398	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
15041190	15041190	PRJNA1067443_P_NODE_2592_length_435_cov_11.765193_g2574_i0	PRJNA1067443	2592	435	11.765193	51.17858955	Bodo	5712	Euglenozoa	other_Eukaryota	791	0	NTclustered	gi\|45739069\|gb\|AY490227.1\|	75058	g2574	i0	99.539	98.9632183908046	434	2	99	0	1	434	5	438	Bodo saltans JC02 18S ribosomal RNA gene, partial sequence	blastn	43049	795	0.994968553459119	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
17591215	17591215	PRJNA1067443_P_NODE_15674_length_254_cov_1.375691_g15656_i0	PRJNA1067443	15674	254	1.375691	3.49425514	Leishmania	5658	Euglenozoa	other_Eukaryota	243	1.28e-59	NTclustered	gi\|2593260741\|emb\|OY748518.1\|	5660	g15656	i0	83.984	7.07874015748031	256	37	100	4	1	254	1061328	1061075	Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 32	blastn	1798	243	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
18865049	18865049	PRJNA1067443_P_NODE_295_length_804_cov_16.564979_g281_i0	PRJNA1067443	295	804	16.564979	133.18243116	Bodo	5712	Euglenozoa	other_Eukaryota	1254	0	NTclustered	gi\|45739068\|gb\|AY490226.1\|	75058	g281	i0	94.945	93.6355721393035	811	23	100	16	1	804	1457	658	Bodo saltans 18S ribosomal RNA gene, partial sequence	blastn	75283	1254	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
20582799	20582799	PRJNA1067443_P_NODE_537_length_677_cov_6.728477_g520_i0	PRJNA1067443	537	677	6.728477	45.55178929	Bodo saltans	75058	Euglenozoa	other_Eukaryota	893	0	NTclustered	gi\|225216789\|gb\|FJ176704.1\|	75058	g520	i0	93.522	137.03988183161	602	35	89	3	76	677	1	598	Bodo saltans HFCC12 28S ribosomal RNA gene, partial sequence	blastn	92776	893	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
27248537	27248537	PRJNA1067443_P_NODE_19103_length_247_cov_0.885057_g19085_i0	PRJNA1067443	19103	247	0.885057	2.18609079	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	88.6	1.26e-18	NR	RNC45935.1	5693	g19085	i0	57.1	3.91093117408907	63	27	76.5	0	193	5	37	99	RNC45935.1 ATP-dependent RNA helicase [Trypanosoma cruzi]	diamond	966	89.4	0.991051454138702	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi

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