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

5 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
3413879	3413879	PRJNA888821_P_NODE_47323_length_213_cov_15.600000_g47240_i0	PRJNA888821	47323	213	15.6	33.228	Phacus smulkowskianus	135591	Euglenozoa	other_Eukaryota	195	2.94e-45	NTclustered	gi\|21239038\|gb\|AF188117.1\|	135591	g47240	i0	84.343	0.929577464788732	198	31	93	0	16	213	680	483	Phacus smulkowskianus culture SAG:58.81 strain SAG 58.81 paraxonemal rod protein PAR 1 mRNA, partial cds	blastn	198	195	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Phacaceae	Phacus	Phacus smulkowskianus
7241032	7241032	PRJNA888821_P_NODE_36886_length_246_cov_5.497110_g36803_i0	PRJNA888821	36886	246	5.49711	13.5228906	Entosiphon sp.	1921133	Euglenozoa	other_Eukaryota	228	3.4399999999999986e-55	NTclustered	gi\|1547024950\|gb\|MK213406.1\|	1921133	g36803	i0	84.81	26.8333333333333	237	24	96	6	1	237	1550	1326	Entosiphon sp. strain ESC small subunit ribosomal RNA, partial sequence	blastn	6601	228	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemataceae	Entosiphon	Entosiphon sp.
8515429	8515429	PRJNA888821_P_NODE_127_length_1222_cov_5.048738_g100_i0	PRJNA888821	127	1222	5.048738	61.69557836	Neobodo designis	312471	Euglenozoa	other_Eukaryota	1799	0	NTclustered	gi\|197723537\|gb\|EF681922.2\|	312471	g100	i0	94.276	132.874795417349	1188	49	97	13	43	1222	1	1177	Neobodo designis strain HFCC97 28S ribosomal RNA gene, partial sequence	blastn	162373	1799	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo designis
11066154	11066154	PRJNA888821_P_NODE_1889_length_449_cov_3.973404_g1814_i0	PRJNA888821	1889	449	3.973404	17.84058396	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	630	4.3899999999999986e-176	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g1814	i0	91.904	149.846325167038	457	28	100	7	1	449	4803	4348	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	67281	630	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
13995673	13995673	PRJNA888821_P_NODE_2691_length_405_cov_3.108434_g2612_i0	PRJNA888821	2691	405	3.108434	12.5891577	Leishmania	5658	Euglenozoa	other_Eukaryota	348	4.42e-91	NTclustered	gi\|2593250474\|emb\|OY748421.1\|	5660	g2612	i0	82.448	106.493827160494	433	43	100	22	1	405	990563	990990	Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 27	blastn	43130	348	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);;