metadata: contig_metadata: 5 rows where bioproject = "PRJNA703759" and tax

5 rows where bioproject = "PRJNA703759" and tax_clade = "Discoba"

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
8337552	8337552	PRJNA703759_P_NODE_30007_length_267_cov_1.206186_g29531_i0	PRJNA703759	30007	267	1.206186	3.22051662	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	52.8	0.024	NTclustered	gi\|2031946382\|emb\|OD958505.1\|	5763	g29531	i0	100	0.104868913857678	28	0	10	0	8	35	14507	14534	Naegleria fowleri Karachi_NF001 strain	blastn	28	52.8	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
21587161	21587161	PRJNA703759_P_NODE_34397_length_253_cov_0.866667_g33921_i0	PRJNA703759	34397	253	0.866667	2.19266751	Euglena	3038	Euglenozoa	other_Eukaryota	52.8	0.023	NTclustered	gi\|30410708\|ref\|NC_001603.2\|	3039	g33921	i0	100	0.221343873517787	28	0	11	0	27	54	13903	13930	Euglena gracilis chloroplast, complete genome	blastn	56	52.8	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis
28409268	28409268	PRJNA703759_P_NODE_32446_length_258_cov_2.156757_g31970_i0	PRJNA703759	32446	258	2.156757	5.56443306	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	44.3	0.013	NR	XP_028878191.1	67003	g31970	i0	50	0.488372093023256	42	21	48.8	0	232	107	293	334	XP_028878191.1 uncharacterized protein TM35_000491310, partial [Trypanosoma theileri]	diamond	126	44.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
30220266	30220266	PRJNA703759_P_NODE_36632_length_252_cov_0.871508_g36156_i0	PRJNA703759	36632	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	46.6	0.00184	NR	KAJ9448719.1	91374	g36156	i0	41.4	2.45238095238095	70	24	83.3	1	38	247	856	908	KAJ9448719.1 hypothetical protein DIPPA_02679 [Diplonema papillatum]	diamond	618	46.6	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
31358023	31358023	PRJNA703759_P_NODE_50416_length_242_cov_0.923077_g49940_i0	PRJNA703759	50416	242	0.923077	2.23384634	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	57.8	1.85e-7	NR	CAG4710060.1	5763	g49940	i0	71.9	2.24380165289256	32	9	39.7	0	239	144	728	759	CAG4710060.1 unnamed protein product, partial [Naegleria fowleri]	diamond	543	57.8	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri

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