metadata: contig_metadata: 5 rows where bioproject = "PRJNA564013", tax_clade = "Metamonada" and tax

5 rows where bioproject = "PRJNA564013", tax_clade = "Metamonada" and tax_phylum = "Parabasalia"

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_order	tax_family	tax_genus	tax_species
3099542	3099542	PRJNA564013_P_NODE_193763_length_312_cov_3.254980_g190912_i0	PRJNA564013	193763	312	3.25498	10.1555376	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	54.7	0.008	NTclustered	gi\|2806472865\|ref\|XM_068508731.1\|	1144522	g190912	i0	94.444	0.115384615384615	36	1	11	1	41	75	865	900	Tritrichomonas foetus uncharacterized protein (TRFO_32860), partial mRNA	blastn	36	54.7	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
10754016	10754016	PRJNA564013_P_NODE_247689_length_263_cov_4.712871_g244837_i0	PRJNA564013	247689	263	4.712871	12.39485073	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	52.8	0.024	NTclustered	gi\|2319582776\|ref\|XM_001582426.2\|	412133	g244837	i0	100	0.106463878326996	28	0	11	0	37	64	2010	2037	Trichomonas vaginalis G3 EF-1 beta acid 2 family (TVAGG3_0999810), partial mRNA	blastn	28	52.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
27868780	27868780	PRJNA564013_P_NODE_282905_length_236_cov_9.960000_g280053_i0	PRJNA564013	282905	236	9.96	23.5056	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	43.1	0.0248	NR	XP_068366790.1	1144522	g280053	i0	42.9	0.622881355932203	49	27	62.3	1	198	52	495	542	XP_068366790.1 uncharacterized protein TRFO_16222 [Tritrichomonas foetus]	diamond	147	43.1	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
30016193	30016193	PRJNA564013_P_NODE_359271_length_192_cov_3.083969_g356419_i0	PRJNA564013	359271	192	3.083969	5.92122048	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	58.5	1.97e-8	NR	XP_001317232.1	412133	g356419	i0	70	0.625	40	12	62.5	0	17	136	116	155	XP_001317232.1 GTPase, Ras family, Rab subfamily [Trichomonas vaginalis G3]	diamond	120	58.5	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32387198	32387198	PRJNA564013_P_NODE_9079_length_1140_cov_22.165894_g7499_i0	PRJNA564013	9079	1140	22.165894	252.6911916	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	67.8	3.96e-8	NR	XP_067776970.1	135588	g7499	i0	49.3	0.363157894736842	69	28	18.2	2	800	594	119	180	XP_067776970.1 DEAD/DEAH box helicase family protein [Histomonas meleagridis]	diamond	414	67.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis

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