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

9 rows where analysis = "blastn", bioproject = "PRJNA575566" 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
1136802	1136802	PRJNA575566_P_NODE_29061_length_202_cov_0.907801_g28864_i0	PRJNA575566	29061	202	0.907801	1.83375802	Monomorphina	298266	Euglenozoa	other_Eukaryota	71.3	4.86e-8	NTclustered	gi\|54634948\|gb\|AY626054.1\|	158828	g28864	i0	81.522	12.6683168316832	92	12	45	4	1	90	722	634	Monomorphina striata strain CCAP 1261/9 16S small subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	2559	71.3	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Monomorphina	Monomorphina striata
4387575	4387575	PRJNA575566_P_NODE_26024_length_206_cov_1.765517_g25827_i0	PRJNA575566	26024	206	1.765517	3.63696502	Stachyamoeba lipophora	463046	Heterolobosea	other_Eukaryota	95.3	2.95e-15	NTclustered	gi\|756877602\|ref\|NC_026312.1\|	463046	g25827	i0	79.562	1.74271844660194	137	24	66	3	1	135	2451	2585	Stachyamoeba lipophora strain ATCC 50324 culture-collection ATCC:50324 mitochondrion, complete genome	blastn	359	95.3	1	Eukaryota	Discoba	Heterolobosea			Gruberellidae	Stachyamoeba	Stachyamoeba lipophora
6938348	6938348	PRJNA575566_P_NODE_5386_length_451_cov_8.615385_g5189_i0	PRJNA575566	5386	451	8.615385	38.85538635	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	630	4.409999999999999e-176	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g5189	i0	91.757	144.239467849224	461	27	100	9	1	451	4343	4802	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	65052	630	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
8213240	8213240	PRJNA575566_P_NODE_28047_length_203_cov_36.147887_g27850_i0	PRJNA575566	28047	203	36.147887	73.38021061	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	268	1.6099999999999998e-67	NTclustered	gi\|1002433687\|ref\|XR_001548746.1\|	157538	g27850	i0	91.327	117.556650246305	196	17	97	0	8	203	15	210	Leptomonas pyrrhocoris 28S ribosomal RNA (LSU-gamma) rRNA	blastn	23864	268	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
15862649	15862649	PRJNA575566_P_NODE_16753_length_258_cov_0.974619_g16556_i0	PRJNA575566	16753	258	0.974619	2.51451702	Seculamonas ecuadoriensis	221724	Root_unresolved	Root_unresolved	152	2.2499999999999995e-32	NTclustered	gi\|501673477\|ref\|NC_021128.1\|	221724	g16556	i0	78.723	0.910852713178295	235	44	90	6	12	243	10435	10666	Seculamonas ecuadoriensis strain ATCC 50688 mitochondrion, complete genome	blastn	235	152	1	Eukaryota	Discoba			Jakobida		Seculamonas	Seculamonas ecuadoriensis
19686648	19686648	PRJNA575566_P_NODE_2716_length_627_cov_7.224382_g2526_i0	PRJNA575566	2716	627	7.224382	45.29687514	Neobodo designis	312471	Euglenozoa	other_Eukaryota	1112	0	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g2526	i0	98.724	156.741626794258	627	7	100	1	1	627	1242	617	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	98277	1112	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
24088729	24088729	PRJNA575566_P_NODE_26499_length_206_cov_0.882759_g26302_i0	PRJNA575566	26499	206	0.882759	1.81848354	Leishmania	5658	Euglenozoa	other_Eukaryota	63.9	8.32e-6	NTclustered	gi\|2794750636\|ref\|XM_067838376.1\|	5663	g26302	i0	83.824	0.990291262135922	68	9	33	2	26	92	157	91	Leishmania enriettii uncharacterized protein (CUR178_06717), partial mRNA	blastn	204	63.9	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania enriettii
24786103	24786103	PRJNA575566_P_NODE_1320_length_891_cov_2.025301_g1162_i0	PRJNA575566	1320	891	2.025301	18.04543191	Stachyamoeba lipophora	463046	Heterolobosea	other_Eukaryota	180	3.95e-40	NTclustered	gi\|756877602\|ref\|NC_026312.1\|	463046	g1162	i0	72.384	37.334455667789	688	149	75	33	14	682	617	1282	Stachyamoeba lipophora strain ATCC 50324 culture-collection ATCC:50324 mitochondrion, complete genome	blastn	33265	180	1	Eukaryota	Discoba	Heterolobosea			Gruberellidae	Stachyamoeba	Stachyamoeba lipophora
24786454	24786454	PRJNA575566_P_NODE_7500_length_383_cov_1.732919_g7303_i0	PRJNA575566	7500	383	1.732919	6.63707977	Neobodo designis	312471	Euglenozoa	other_Eukaryota	599	1.0399999999999995e-166	NTclustered	gi\|77994645\|gb\|DQ207583.1\|	312471	g7303	i0	94.805	99.6292428198433	385	18	100	1	1	383	425	41	Neobodo designis strain HFCC306 18S ribosomal RNA gene, partial sequence	blastn	38158	599	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis

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