metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA700095" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA700095" 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
2459479	2459479	PRJNA700095_P_NODE_70822_length_202_cov_13.348837_g69557_i0	PRJNA700095	70822	202	13.348837	26.96465074	Trypanosomatidae	5654	Euglenozoa	other_Eukaryota	259	9.65e-65	NTclustered	gi\|2414483\|emb\|Y00055.1\|	5656	g69557	i0	91.146	115.826732673267	192	16	95	1	9	200	6835	7025	Crithidia fasciculata ribosomal DNA repeat (complete)	blastn	23397	261	0.992337164750958	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Crithidia	Crithidia fasciculata
3735982	3735982	PRJNA700095_P_NODE_29383_length_313_cov_5.341667_g28119_i0	PRJNA700095	29383	313	5.341667	16.71941771	Leishmania	5658	Euglenozoa	other_Eukaryota	265	3.45e-66	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g28119	i0	95.238	73.7987220447284	168	6	53	2	147	313	990876	991042	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	23099	265	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
5012552	5012552	PRJNA700095_P_NODE_7684_length_715_cov_21.219626_g6534_i0	PRJNA700095	7684	715	21.219626	151.7203259	Leishmania	5658	Euglenozoa	other_Eukaryota	791	0	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g6534	i0	86.767	119.013986013986	733	70	99	20	1	713	989661	990386	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	85095	791	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis
8837181	8837181	PRJNA700095_P_NODE_9547_length_632_cov_13.846154_g8328_i0	PRJNA700095	9547	632	13.846154	87.50769328	Kinetoplastea	5653	Euglenozoa	other_Eukaryota	1044	0	NTclustered	gi\|45739063\|gb\|AY490221.1\|	266813	g8328	i0	96.524	99.8544303797468	633	19	100	3	1	632	2082	1452	Bodo celer 18S ribosomal RNA gene, partial sequence	blastn	63108	1044	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo celer
13437117	13437117	PRJNA700095_P_NODE_68751_length_228_cov_22.464516_g67486_i0	PRJNA700095	68751	228	22.464516	51.21909648	Neobodo designis	312471	Euglenozoa	other_Eukaryota	366	6.39e-97	NTclustered	gi\|77994645\|gb\|DQ207583.1\|	312471	g67486	i0	96.018	97.9342105263158	226	7	99	2	4	228	982	758	Neobodo designis strain HFCC306 18S ribosomal RNA gene, partial sequence	blastn	22329	366	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
15985841	15985841	PRJNA700095_P_NODE_44613_length_264_cov_14.785340_g43349_i0	PRJNA700095	44613	264	14.78534	39.0332976	Neobodo designis	312471	Euglenozoa	other_Eukaryota	475	1.2099999999999996e-129	NTclustered	gi\|59891959\|gb\|AY753619.1\|	312471	g43349	i0	99.615	99.3295454545455	260	1	98	0	1	260	428	687	Neobodo designis isolate TeToto4 18S ribosomal RNA gene, partial sequence	blastn	26223	475	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
17260995	17260995	PRJNA700095_P_NODE_16794_length_442_cov_10.509485_g15531_i0	PRJNA700095	16794	442	10.509485	46.4519237	Neobodo designis	312471	Euglenozoa	other_Eukaryota	529	1.62e-145	NTclustered	gi\|77994645\|gb\|DQ207583.1\|	312471	g15531	i0	94.017	112.647058823529	351	18	79	2	1	348	351	1	Neobodo designis strain HFCC306 18S ribosomal RNA gene, partial sequence	blastn	49790	529	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
18534972	18534972	PRJNA700095_P_NODE_27315_length_326_cov_17.501976_g26051_i0	PRJNA700095	27315	326	17.501976	57.05644176	Neobodo designis	312471	Euglenozoa	other_Eukaryota	575	1.4699999999999996e-159	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g26051	i0	98.476	160.092024539877	328	2	100	2	1	326	896	1222	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	52190	575	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
21085628	21085628	PRJNA700095_P_NODE_45077_length_263_cov_12.784211_g43813_i0	PRJNA700095	45077	263	12.784211	33.62247493	Trypanosoma conorhini	83891	Euglenozoa	other_Eukaryota	438	1.5799999999999996e-118	NTclustered	gi\|1673141461\|ref\|XR_003828664.1\|	83891	g43813	i0	96.935	139.342205323194	261	8	99	0	3	263	4971	5231	Trypanosoma conorhini 28S ribosomal RNA (Tco025E_06705), rRNA	blastn	36647	438	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma conorhini
21586522	21586522	PRJNA700095_P_NODE_67157_length_235_cov_11.419753_g65893_i0	PRJNA700095	67157	235	11.419753	26.83641955	Leishmania	5658	Euglenozoa	other_Eukaryota	267	6.91e-67	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g65893	i0	89.352	83.8170212765957	216	18	91	5	4	217	990749	990537	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	19697	267	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Leishmania	Leishmania braziliensis

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