metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1120586" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1120586" 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
3578928	3578928	PRJNA1120586_P_NODE_16283_length_320_cov_19.653386_g16092_i0	PRJNA1120586	16283	320	19.653386	62.8908352	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	525	1.4699999999999994e-144	NTclustered	gi\|11037201\|gb\|AF208879.1\|AF208879	140242	g16092	i0	96.25	159.0375	320	12	100	0	1	320	967	648	Cruzella marina large subunit ribosomal RNA gene, partial sequence	blastn	50892	529	0.992438563327032	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Cruzella	Cruzella marina
6131184	6131184	PRJNA1120586_P_NODE_16425_length_319_cov_182.720000_g16234_i0	PRJNA1120586	16425	319	182.72	582.8768	Leishmania	5658	Euglenozoa	other_Eukaryota	211	4.66e-50	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g16234	i0	79.31	99.8181818181818	348	37	100	21	1	319	990657	990998	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	31842	211	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
9204414	9204414	PRJNA1120586_P_NODE_55368_length_186_cov_13.735043_g55177_i0	PRJNA1120586	55368	186	13.735043	25.54717998	Neobodo designis	312471	Euglenozoa	other_Eukaryota	289	1.11e-73	NTclustered	gi\|59891951\|gb\|AY753611.1\|	312471	g55177	i0	94.624	86.6774193548387	186	10	100	0	1	186	1192	1377	Neobodo designis isolate Dev2 18S ribosomal RNA gene, partial sequence	blastn	16122	289	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
16330816	16330816	PRJNA1120586_P_NODE_2453_length_670_cov_14.906822_g2270_i0	PRJNA1120586	2453	670	14.906822	99.8757074	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	267	2.19e-66	NTclustered	gi\|440222388\|gb\|JX030056.1\|	5659	g2270	i0	93.333	29.4791044776119	180	12	27	0	362	541	182	3	Leishmania amazonensis isolate LaPH8.rRNA.32 28S ribosomal RNA (LSU-delta M2), partial sequence	blastn	19751	268	0.996268656716418	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
21430273	21430273	PRJNA1120586_P_NODE_14357_length_335_cov_1.353383_g14166_i0	PRJNA1120586	14357	335	1.353383	4.53383305	Leishmania	5658	Euglenozoa	other_Eukaryota	219	2.9399999999999992e-52	NTclustered	gi\|398023953\|ref\|XM_003865090.1\|	5661	g14166	i0	79.43	10.3850746268657	316	59	93	3	8	317	1120	805	Leishmania donovani elongation factor 2 (LDBPK_360210), partial mRNA	blastn	3479	219	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania donovani
22705194	22705194	PRJNA1120586_P_NODE_14378_length_334_cov_148.430189_g14187_i0	PRJNA1120586	14378	334	148.430189	495.75683126	Leishmania	5658	Euglenozoa	other_Eukaryota	272	2.22e-68	NTclustered	gi\|440222381\|gb\|JX030049.1\|	5659	g14187	i0	95.858	82.6287425149701	169	6	65	1	1	168	654	822	Leishmania amazonensis isolate LaPH8.rRNA.25 28S ribosomal RNA (LSU-beta), partial sequence	blastn	27598	272	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania amazonensis
23228026	23228026	PRJNA1120586_P_NODE_1299_length_876_cov_107.382900_g1151_i0	PRJNA1120586	1299	876	107.3829	940.674204	Trypanosoma otospermophili	269061	Euglenozoa	other_Eukaryota	928	0	NTclustered	gi\|51988027\|dbj\|AB190228.1\|	269061	g1151	i0	86.277	112.5399543379	889	81	99	29	1	864	4693	5565	Trypanosoma otospermophili genes for IGS, 18S rRNA, 5.8S rRNA, 28S rRNA and ITS1-6	blastn	98585	928	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma otospermophili
23228729	23228729	PRJNA1120586_P_NODE_54199_length_216_cov_19.564626_g54008_i0	PRJNA1120586	54199	216	19.564626	42.25959216	Neobodo designis	312471	Euglenozoa	other_Eukaryota	339	1.3099999999999998e-88	NTclustered	gi\|62871456\|gb\|AY998643.1\|	312471	g54008	i0	95.327	95.6898148148148	214	9	99	1	1	213	642	855	Neobodo designis strain SCCAP BD50 18S ribosomal RNA gene, partial sequence	blastn	20669	339	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);;