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

9 rows where analysis = "blastn", bioproject = "PRJNA896758" 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
2148252	2148252	PRJNA896758_P_NODE_5562_length_482_cov_4.535452_g5173_i0	PRJNA896758	5562	482	4.535452	21.86087864	Leptomonas pyrrhocoris	157538	Euglenozoa	other_Eukaryota	60.2	2.81e-4	NTclustered	gi\|1002433044\|ref\|XM_015809586.1\|	157538	g5173	i0	94.737	4.87136929460581	38	2	8	0	272	309	3165	3202	Leptomonas pyrrhocoris putative paraflagellar rod protein mRNA	blastn	2348	60.2	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leptomonas	Leptomonas pyrrhocoris
4701473	4701473	PRJNA896758_P_NODE_6924_length_431_cov_1.198324_g6534_i0	PRJNA896758	6924	431	1.198324	5.16477644	Leishmania martiniquensis	1580590	Euglenozoa	other_Eukaryota	54.7	0.012	NTclustered	gi\|2787676407\|ref\|XM_067322978.1\|	1580590	g6534	i0	100	0.0672853828306264	29	0	7	0	1	29	962	990	Leishmania martiniquensis uncharacterized protein (LSCM1_05524), partial mRNA	blastn	29	54.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania martiniquensis
8896811	8896811	PRJNA896758_P_NODE_18627_length_269_cov_2.331633_g18237_i0	PRJNA896758	18627	269	2.331633	6.27209277	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	54.7	0.007	NTclustered	gi\|2593254642\|emb\|OY748489.1\|	5660	g18237	i0	96.875	6.32342007434944	32	1	12	0	152	183	325949	325918	Leishmania braziliensis isolate MHOM/BR/75/M2903 genome assembly, chromosome: 03	blastn	1701	54.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
9800669	9800669	PRJNA896758_P_NODE_21208_length_251_cov_0.865169_g20818_i0	PRJNA896758	21208	251	0.865169	2.17157419	Trypanosoma rangeli	5698	Euglenozoa	other_Eukaryota	248	2.7e-61	NTclustered	gi\|510034231\|gb\|KC544869.1\|	5698	g20818	i0	89.691	65.3346613545817	194	20	77	0	4	197	215	22	Trypanosoma rangeli clone TR05056 alpha tubulin gene, complete cds	blastn	16399	248	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma rangeli
9800760	9800760	PRJNA896758_P_NODE_8988_length_380_cov_1.439739_g8598_i0	PRJNA896758	8988	380	1.439739	5.4710082	Porcisia hertigi	2761500	Euglenozoa	other_Eukaryota	422	2.3999999999999995e-113	NTclustered	gi\|2794824028\|ref\|XM_067903207.1\|	2761500	g8598	i0	88.539	36.9921052631579	349	38	92	2	33	380	127	474	Porcisia hertigi uncharacterized protein (JKF63_07267), partial mRNA	blastn	14057	422	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Porcisia	Porcisia hertigi
16175558	16175558	PRJNA896758_P_NODE_18013_length_274_cov_1.149254_g17623_i0	PRJNA896758	18013	274	1.149254	3.14895596	Leishmania infantum	5671	Euglenozoa	other_Eukaryota	58.4	5.41e-4	NTclustered	gi\|146089991\|ref\|XM_001470489.1\|	435258	g17623	i0	100	1.87956204379562	31	0	11	0	119	149	850	820	Leishmania infantum JPCM5 conserved hypothetical protein partial mRNA	blastn	515	58.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania infantum
21274699	21274699	PRJNA896758_P_NODE_13077_length_318_cov_1.257143_g12687_i0	PRJNA896758	13077	318	1.257143	3.99771474	Trypanosoma melophagium	715481	Euglenozoa	other_Eukaryota	58.4	6.41e-4	NTclustered	gi\|2787710063\|ref\|XM_067331147.1\|	715481	g12687	i0	90.909	10.5566037735849	44	2	14	2	1	43	3014	3056	Trypanosoma melophagium uncharacterized protein (LSM04_004808), partial mRNA	blastn	3357	58.4	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma melophagium
23824917	23824917	PRJNA896758_P_NODE_10159_length_359_cov_0.968531_g9769_i0	PRJNA896758	10159	359	0.968531	3.47702629	Bodo edax	155204	Euglenozoa	other_Eukaryota	588	2.0999999999999994e-163	NTclustered	gi\|20331093\|gb\|AY028451.1\|	155204	g9769	i0	96.133	148.623955431755	362	10	99	2	1	358	3085	2724	Bodo edax 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	53356	588	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo edax
23825031	23825031	PRJNA896758_P_NODE_24319_length_245_cov_1.058140_g23929_i0	PRJNA896758	24319	245	1.05814	2.592443	Bodo saltans	75058	Euglenozoa	other_Eukaryota	113	1e-20	NTclustered	gi\|302026180\|gb\|GQ377699.1\|	75058	g23929	i0	85.455	27.4244897959184	110	14	44	2	1	109	1278	1386	Bodo saltans elongation factor 1 alpha mRNA, complete cds	blastn	6719	113	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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