metadata: contig_metadata: 12 rows where bioproject = "PRJNA1095825" and tax

12 rows where bioproject = "PRJNA1095825" and tax_clade = "Discoba"

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
4027789	4027789	PRJNA1095825_P_NODE_288144_length_242_cov_0.911243_g285081_i0	PRJNA1095825	288144	242	0.911243	2.20520806	Naegleria sp.	37103	Heterolobosea	other_Eukaryota	448	2.3799999999999995e-121	NTclustered	gi\|2651357798\|gb\|PP174311.1\|	37103	g285081	i0	100	11.9876033057851	242	0	100	0	1	242	3767	3526	Naegleria sp. isolate 33 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	2901	448	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria sp.
5302468	5302468	PRJNA1095825_P_NODE_114845_length_357_cov_1.514085_g111782_i0	PRJNA1095825	114845	357	1.514085	5.40528345	Petalomonas acorensis	2529306	Euglenozoa	other_Eukaryota	582	9.69e-162	NTclustered	gi\|1580982997\|gb\|MK564754.1\|	2529306	g111782	i0	96.089	73.1708683473389	358	13	100	1	1	357	397	40	Petalomonas acorensis strain HFCC220 small subunit ribosomal RNA gene, partial sequence	blastn	26122	582	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Petalomonadida	Scytomonadidae	Petalomonas	Petalomonas acorensis
20600585	20600585	PRJNA1095825_P_NODE_103757_length_374_cov_1.408638_g100694_i0	PRJNA1095825	103757	374	1.408638	5.26830612	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	52.8	0.036	NTclustered	gi\|2031946548\|emb\|OD958517.1\|	5763	g100694	i0	100	0.0748663101604278	28	0	7	0	347	374	28	1	Naegleria fowleri Karachi_NF001 strain	blastn	28	52.8	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
21877609	21877609	PRJNA1095825_P_NODE_254538_length_248_cov_0.880000_g251475_i0	PRJNA1095825	254538	248	0.88	2.1824	Leishmania major	5664	Euglenozoa	other_Eukaryota	459	1.13e-124	NTclustered	gi\|157873427\|ref\|XM_001685173.1\|	347515	g251475	i0	100	8	248	0	100	0	1	248	784	1031	Leishmania major strain Friedlin hypothetical protein partial mRNA	blastn	1984	459	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania major
23153458	23153458	PRJNA1095825_P_NODE_296719_length_241_cov_0.916667_g293656_i0	PRJNA1095825	296719	241	0.916667	2.20916747	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	54.7	0.006	NTclustered	gi\|2031937359\|emb\|OD957219.1\|	5763	g293656	i0	100	0.120331950207469	29	0	12	0	1	29	2	30	Naegleria fowleri Karachi_NF001 strain	blastn	29	54.7	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
27604891	27604891	PRJNA1095825_P_NODE_260864_length_247_cov_0.885057_g257801_i0	PRJNA1095825	260864	247	0.885057	2.18609079	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	89.7	6.78e-19	NR	KAJ9455577.1	91374	g257801	i0	46.3	0.995951417004049	82	44	99.6	0	2	247	33	114	KAJ9455577.1 Actin-related protein 2 [Diplonema papillatum]	diamond	246	89.7	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
29467231	29467231	PRJNA1095825_P_NODE_131530_length_336_cov_3.513308_g128467_i0	PRJNA1095825	131530	336	3.513308	11.80471488	Perkinsela sp. CCAP 156	1935466	Euglenozoa	other_Eukaryota	75.9	3.4e-14	NR	KNH04974.1	1314962	g128467	i0	43	0.955357142857143	107	52	95.5	2	6	326	23	120	KNH04974.1 60S ribosomal protein L9 [Perkinsela sp. CCAP 1560/4]	diamond	321	75.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea		Ichthyobodonidae	Perkinsela	Perkinsela sp. CCAP 1560/4
29751472	29751472	PRJNA1095825_P_NODE_121211_length_349_cov_1.090580_g118148_i0	PRJNA1095825	121211	349	1.09058	3.8061242	Bodo saltans	75058	Euglenozoa	other_Eukaryota	43.9	0.0432	NR	CUG93343.1	75058	g118148	i0	38.5	0.446991404011461	52	32	44.7	0	338	183	81	132	CUG93343.1 leucine-rich repeat protein, putative [Bodo saltans]	diamond	156	43.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30248791	30248791	PRJNA1095825_P_NODE_254352_length_248_cov_0.880000_g251289_i0	PRJNA1095825	254352	248	0.88	2.1824	Trypanosoma	5690	Euglenozoa	other_Eukaryota	89.4	1.58e-18	NR	XP_067081308.1	5694	g251289	i0	63.1	1.57258064516129	65	24	78.6	0	10	204	765	829	XP_067081308.1 major vault protein, putative [Trypanosoma equiperdum]	diamond	390	89.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma equiperdum
30289170	30289170	PRJNA1095825_P_NODE_197072_length_278_cov_4.882927_g194009_i0	PRJNA1095825	197072	278	4.882927	13.57453706	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	77.8	4.23e-16	NR	KAL0490923.1	1008807	g194009	i0	44.4	1.76978417266187	81	37	87.4	1	245	3	13	85	KAL0490923.1 ribosomal protein S20 [Acrasis kona]	diamond	492	77.8	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
30794216	30794216	PRJNA1095825_P_NODE_221534_length_261_cov_1.452128_g218471_i0	PRJNA1095825	221534	261	1.452128	3.79005408	Naegleria lovaniensis	51637	Heterolobosea	other_Eukaryota	81.3	1.26e-15	NR	XP_044548198.1	51637	g218471	i0	61.2	1.59770114942529	67	24	75.9	2	57	254	420	485	XP_044548198.1 uncharacterized protein C9374_005099 [Naegleria lovaniensis]	diamond	417	81.3	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria lovaniensis
32754324	32754324	PRJNA1095825_P_NODE_289200_length_242_cov_0.911243_g286137_i0	PRJNA1095825	289200	242	0.911243	2.20520806	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	91.3	1.6e-19	NR	KAL0488256.1	1008807	g286137	i0	53.8	0.991735537190083	80	36	99.2	1	1	240	106	184	KAL0488256.1 esterase [Acrasis kona]	diamond	240	91.3	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona

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