metadata: contig_metadata: 10 rows where bioproject = "PRJNA908278", tax_clade = "Metamonada" and tax

10 rows where bioproject = "PRJNA908278", 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
4718629	4718629	PRJNA908278_P_NODE_10244_length_379_cov_1.006536_g10141_i0	PRJNA908278	10244	379	1.006536	3.81477144	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	115	7.590000000000001e-27	NR	SOH55389.1	43075	g10141	i0	67.8	4.03693931398417	87	26	68.9	1	18	278	593	677	SOH55389.1 histidyl tRNA synthetase [Trichomonas tenax]	diamond	1530	116	0.991379310344828	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas tenax
4718736	4718736	PRJNA908278_P_NODE_18484_length_297_cov_1.468750_g18381_i0	PRJNA908278	18484	297	1.46875	4.3621875	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	54.7	0.008	NTclustered	gi\|2806450614\|ref\|XM_068500446.1\|	1144522	g18381	i0	100	0.0976430976430976	29	0	10	0	192	220	4340	4312	Tritrichomonas foetus uncharacterized protein (TRFO_18903), partial mRNA	blastn	29	54.7	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
4719018	4719018	PRJNA908278_P_NODE_984_length_1037_cov_11.229253_g923_i0	PRJNA908278	984	1037	11.229253	116.44735361	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	83.6	1.64e-13	NR	XP_067770880.1	135588	g923	i0	38.6	1.18611378977821	132	73	38.2	3	247	642	306	429	XP_067770880.1 C2 domain containing protein [Histomonas meleagridis]	diamond	1230	84.3	0.991696322657177	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
5993452	5993452	PRJNA908278_P_NODE_17745_length_303_cov_1.260870_g17642_i0	PRJNA908278	17745	303	1.26087	3.8204361	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	106	3.669999999999999e-24	NR	XP_001579821.1	412133	g17642	i0	48.4	9.38613861386139	95	48	93.1	1	5	286	182	276	XP_001579821.1 protein kinase protein [Trichomonas vaginalis G3]	diamond	2844	106	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
26905366	26905366	PRJNA908278_P_NODE_15361_length_322_cov_1.236948_g15258_i0	PRJNA908278	15361	322	1.236948	3.98297256	Tritrichomonadida	740972	Parabasalia	other_Eukaryota	80.9	3.91e-15	NR	XP_067776192.1	135588	g15258	i0	41.4	4.44409937888199	99	56	92.2	2	302	6	1222	1318	XP_067776192.1 Formin-like 2 Domain containing protein [Histomonas meleagridis]	diamond	1431	80.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
27656401	27656401	PRJNA908278_P_NODE_11184_length_366_cov_1.433447_g11081_i0	PRJNA908278	11184	366	1.433447	5.24641602	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	67.4	3.22e-10	NR	XP_068362269.1	1144522	g11081	i0	53.2	0.959016393442623	62	28	50.8	1	350	165	5	65	XP_068362269.1 ZPR1-related zinc finger protein [Tritrichomonas foetus]	diamond	351	67.4	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
30624568	30624568	PRJNA908278_P_NODE_12933_length_345_cov_1.308824_g12830_i0	PRJNA908278	12933	345	1.308824	4.5154428	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	88.6	1.71e-18	NR	EAY00485.1	412133	g12830	i0	48.9	1.68695652173913	94	39	78.3	2	287	18	82	170	EAY00485.1 CAMK family protein kinase [Trichomonas vaginalis G3]	diamond	582	88.6	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
30877467	30877467	PRJNA908278_P_NODE_33434_length_243_cov_0.905882_g33331_i0	PRJNA908278	33434	243	0.905882	2.20129326	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	71.2	3.52e-12	NR	XP_068366072.1	1144522	g33331	i0	43.8	0.987654320987654	80	43	97.5	2	7	243	676	754	XP_068366072.1 uncharacterized protein TRFO_16974 [Tritrichomonas foetus]	diamond	240	71.2	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
31351663	31351663	PRJNA908278_P_NODE_23496_length_267_cov_2.164948_g23393_i0	PRJNA908278	23496	267	2.164948	5.78041116	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	48.1	5.88e-4	NR	XP_068362102.1	1144522	g23393	i0	42.6	5.0561797752809	54	31	60.7	0	241	80	161	214	XP_068362102.1 Glycogen synthase kinase-3 [Tritrichomonas foetus]	diamond	1350	48.1	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
31573154	31573154	PRJNA908278_P_NODE_12216_length_353_cov_1.375000_g12113_i0	PRJNA908278	12216	353	1.375	4.85375	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	129	2.9699999999999997e-35	NR	XP_068348742.1	1144522	g12113	i0	56.7	11.3796033994334	104	45	88.4	0	351	40	74	177	XP_068348742.1 uncharacterized protein TRFO_38293 [Tritrichomonas foetus]	diamond	4017	129	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus

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