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

5 rows where analysis = "blastn", bioproject = "PRJNA414225" 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
4911149	4911149	PRJNA414225_P_NODE_3844_length_257_cov_1.706731_g3757_i0	PRJNA414225	3844	257	1.706731	4.38629867	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	147	1.04e-30	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g3757	i0	97.647	48.1089494163424	85	2	33	0	170	254	8063	8147	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	12364	147	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
10622782	10622782	PRJNA414225_P_NODE_28909_length_180_cov_1.358779_g28822_i0	PRJNA414225	28909	180	1.358779	2.4458022	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	261	2.33e-65	NTclustered	gi\|2031940963\|emb\|OD957789.1\|	5763	g28822	i0	92.778	2.62777777777778	180	13	100	0	1	180	148	327	Naegleria fowleri Karachi_NF001 strain	blastn	473	261	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
10622846	10622846	PRJNA414225_P_NODE_61229_length_165_cov_2.103448_g61142_i0	PRJNA414225	61229	165	2.103448	3.4706892	Trypanosoma grayi	71804	Euglenozoa	other_Eukaryota	222	9.939999999999999e-54	NTclustered	gi\|686646785\|ref\|XM_009317563.1\|	71804	g61142	i0	90.909	104.963636363636	165	15	100	0	1	165	324	160	Trypanosoma grayi calmodulin partial mRNA	blastn	17319	222	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma grayi
16996307	16996307	PRJNA414225_P_NODE_10994_length_206_cov_1.949045_g10907_i0	PRJNA414225	10994	206	1.949045	4.0150327	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	370	4.38e-98	NTclustered	gi\|2031941502\|emb\|OD957913.1\|	5763	g10907	i0	99.029	1	206	2	100	0	1	206	155	360	Naegleria fowleri Karachi_NF001 strain	blastn	206	370	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
18270483	18270483	PRJNA414225_P_NODE_13815_length_195_cov_1.397260_g13728_i0	PRJNA414225	13815	195	1.39726	2.724657	Andalucia godoyi	505711	Root_unresolved	Root_unresolved	226	9.379999999999996e-55	NTclustered	gi\|484759855\|ref\|NC_021124.1\|	505711	g13728	i0	89.56	183.492307692308	182	14	92	4	4	183	695	873	Andalucia godoyi strain ATCC PRA-185 mitochondrion, complete genome	blastn	35781	226	1	Eukaryota	Discoba			Jakobida	Andaluciidae	Andalucia	Andalucia godoyi

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