metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
404186	404186	PRJNA382357_P_NODE_65181_length_292_cov_1.688312_g64442_i0	PRJNA382357	65181	292	1.688312	4.92987104	Percolomonas cosmopolitus	63605	Heterolobosea	other_Eukaryota	254	6.91e-63	NTclustered	gi\|2043511950\|gb\|MZ264846.1\|	63605	g64442	i0	92.265	12.027397260274	181	10	92	4	110	288	1652	1474	Percolomonas cosmopolitus strain HFCC 1 small subunit ribosomal RNA gene, partial sequence	blastn	3512	254	1	Eukaryota	Discoba	Heterolobosea			Percolomonadidae	Percolomonas	Percolomonas cosmopolitus
1677336	1677336	PRJNA382357_P_NODE_118682_length_224_cov_1.993865_g117943_i0	PRJNA382357	118682	224	1.993865	4.4662576	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	159	1.14e-34	NTclustered	gi\|2031941177\|emb\|OD957840.1\|	5763	g117943	i0	89.764	32.1160714285714	127	9	55	3	96	218	261	387	Naegleria fowleri Karachi_NF001 strain	blastn	7194	159	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
10002838	10002838	PRJNA382357_P_NODE_151428_length_204_cov_0.909091_g150689_i0	PRJNA382357	151428	204	0.909091	1.85454564	Leishmania	5658	Euglenozoa	other_Eukaryota	54.7	0.005	NTclustered	gi\|1751371445\|tpg\|BK010876.1\|	5670	g150689	i0	100	1.26470588235294	29	0	14	0	39	67	5131	5159	TPA_asm: Leishmania guyanensis strain MCAN kinetoplast, complete sequence	blastn	258	54.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania guyanensis
11882528	11882528	PRJNA382357_P_NODE_44510_length_346_cov_1.291228_g43771_i0	PRJNA382357	44510	346	1.291228	4.46764888	Trypanosoma cruzi	5693	Euglenozoa	other_Eukaryota	54.7	0.009	NTclustered	gi\|1031970226\|gb\|CP015660.1\|	85057	g43771	i0	100	0.0838150289017341	29	0	8	0	185	213	966345	966373	Trypanosoma cruzi cruzi strain Sylvio X10/cl1 chromosome TcI10, partial sequence	blastn	29	54.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma cruzi
16979708	16979708	PRJNA382357_P_NODE_105254_length_236_cov_23.531429_g104515_i0	PRJNA382357	105254	236	23.531429	55.53417244	Procryptobia sorokini	351715	Euglenozoa	other_Eukaryota	246	9.05e-61	NTclustered	gi\|197723538\|gb\|EF681923.2\|	351715	g104515	i0	96.026	149.970338983051	151	6	100	0	86	236	424	274	Procryptobia sorokini strain HFCC98 28S ribosomal RNA gene, partial sequence	blastn	35393	246	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Parabodonida		Procryptobia	Procryptobia sorokini

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