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

5 rows where analysis = "blastn", bioproject = "PRJNA983838" 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
8924305	8924305	PRJNA983838_P_NODE_59607_length_373_cov_2.930000_g57240_i0	PRJNA983838	59607	373	2.93	10.9289	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	143	2.05e-29	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g57240	i0	90.654	38.7935656836461	107	10	29	0	24	130	8177	8071	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	14470	143	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
13719571	13719571	PRJNA983838_P_NODE_89891_length_278_cov_1.521951_g87524_i0	PRJNA983838	89891	278	1.521951	4.23102378	Bodo saltans	75058	Euglenozoa	other_Eukaryota	449	7.77e-122	NTclustered	gi\|77994632\|gb\|DQ207570.1\|	75058	g87524	i0	96.014	98.2446043165468	276	11	99	0	3	278	332	57	Bodo saltans strain HFCC13 18S ribosomal RNA gene, partial sequence	blastn	27312	449	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
14993941	14993941	PRJNA983838_P_NODE_93032_length_272_cov_1.567839_g90665_i0	PRJNA983838	93032	272	1.567839	4.26452208	Trypanosoma conorhini	83891	Euglenozoa	other_Eukaryota	137	6.7e-28	NTclustered	gi\|1673140149\|ref\|XM_029372850.1\|	83891	g90665	i0	77.826	5.57352941176471	230	45	83	6	46	272	25	251	Trypanosoma conorhini 40S ribosomal protein S10 (Tco025E_05960), partial mRNA	blastn	1516	137	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini
17543572	17543572	PRJNA983838_P_NODE_75234_length_314_cov_0.970954_g72867_i0	PRJNA983838	75234	314	0.970954	3.04879556	Porcisia hertigi	2761500	Euglenozoa	other_Eukaryota	296	1.23e-75	NTclustered	gi\|2794850138\|ref\|XM_067897636.1\|	2761500	g72867	i0	85.522	21.5573248407643	297	27	92	11	1	289	399	111	Porcisia hertigi uncharacterized protein (JKF63_01590), partial mRNA	blastn	6769	296	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Porcisia	Porcisia hertigi
17848993	17848993	PRJNA983838_P_NODE_118634_length_242_cov_0.923077_g116267_i0	PRJNA983838	118634	242	0.923077	2.23384634	Leishmania	5658	Euglenozoa	other_Eukaryota	200	7.359999999999999e-47	NTclustered	gi\|398021119\|ref\|XM_003863675.1\|	5661	g116267	i0	84.058	18.8801652892562	207	33	86	0	1	207	249	455	Leishmania donovani nucleoside diphosphate kinase b (LDBPK_323110), partial mRNA	blastn	4569	202	0.99009900990099	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani

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