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

10 rows where bioproject = "PRJNA1166865", 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
10517624	10517624	PRJNA1166865_P_NODE_87069_length_245_cov_0.895349_g86828_i0	PRJNA1166865	87069	245	0.895349	2.19360505	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	63.9	1.02e-5	NTclustered	gi\|123426569\|ref\|XM_001307065.1\|	412133	g86828	i0	93.023	0.175510204081633	43	3	18	0	32	74	746	788	Trichomonas vaginalis G3 myotrophin family (TVAGG3_0260130), partial mRNA	blastn	43	63.9	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
26692179	26692179	PRJNA1166865_P_NODE_45901_length_324_cov_1.533865_g45660_i0	PRJNA1166865	45901	324	1.533865	4.9697226	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	80.9	3.87e-15	NR	XP_067770880.1	135588	g45660	i0	44.7	0.87037037037037	94	49	87	1	39	320	306	396	XP_067770880.1 C2 domain containing protein [Histomonas meleagridis]	diamond	282	80.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
27324989	27324989	PRJNA1166865_P_NODE_10803_length_647_cov_1.534843_g10571_i0	PRJNA1166865	10803	647	1.534843	9.93043421	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	47.4	0.0255	NR	KAH0795122.1	135588	g10571	i0	32.6	1.30757341576507	141	73	62.6	7	56	460	14	138	KAH0795122.1 H-SHIPPO 1 [Histomonas meleagridis]	diamond	846	47.4	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
27893245	27893245	PRJNA1166865_P_NODE_82805_length_247_cov_0.885057_g82564_i0	PRJNA1166865	82805	247	0.885057	2.18609079	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	70.5	8.49e-13	NR	XP_068360783.1	1144522	g82564	i0	49.1	1.2995951417004	55	28	66.8	0	245	81	72	126	XP_068360783.1 phosphodiesterase, MJ0936 family protein [Tritrichomonas foetus]	diamond	321	70.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28259705	28259705	PRJNA1166865_P_NODE_89026_length_244_cov_0.900585_g88785_i0	PRJNA1166865	89026	244	0.900585	2.1974274	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	63.2	2.35e-9	NR	XP_067771422.1	135588	g88785	i0	46.3	8.07786885245902	80	41	97.1	2	1	237	118	196	XP_067771422.1 AGC family protein kinase [Histomonas meleagridis]	diamond	1971	63.2	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
28638971	28638971	PRJNA1166865_P_NODE_39747_length_345_cov_3.393382_g39506_i0	PRJNA1166865	39747	345	3.393382	11.7071679	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	44.3	0.00682	NR	XP_001314726.1	412133	g39506	i0	42.2	1.09565217391304	45	22	39.1	1	146	12	51	91	XP_001314726.1 positive regulation of ATP-dependent microtubule motor activity, plus-end-directed [Trichomonas vaginalis G3]	diamond	378	44.3	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
28670476	28670476	PRJNA1166865_P_NODE_94127_length_241_cov_0.916667_g93886_i0	PRJNA1166865	94127	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	98.2	1.1e-21	NR	XP_068361557.1	1144522	g93886	i0	62	3.0746887966805	79	27	98.3	1	5	241	213	288	XP_068361557.1 asparaginyl-tRNA synthetase family protein [Tritrichomonas foetus]	diamond	741	98.2	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
31892973	31892973	PRJNA1166865_P_NODE_80517_length_248_cov_1.760000_g80276_i0	PRJNA1166865	80517	248	1.76	4.3648	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.8	5.51e-5	NR	XP_001327808.1	412133	g80276	i0	50	2.41935483870968	50	22	60.5	1	152	3	134	180	XP_001327808.1 phosphatidylinositol catabolic process [Trichomonas vaginalis G3]	diamond	600	50.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32538430	32538430	PRJNA1166865_P_NODE_87239_length_245_cov_0.895349_g86998_i0	PRJNA1166865	87239	245	0.895349	2.19360505	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	53.5	5.15e-6	NR	XP_001308953.1	412133	g86998	i0	42.4	1.46938775510204	59	32	72.2	1	23	199	93	149	XP_001308953.1 nuclear envelope reassembly [Trichomonas vaginalis G3]	diamond	360	53.5	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32840767	32840767	PRJNA1166865_P_NODE_71780_length_258_cov_1.664865_g71539_i0	PRJNA1166865	71780	258	1.664865	4.2953517	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	75.1	1.59e-13	NR	XP_068347957.1	1144522	g71539	i0	43.5	6.90697674418605	85	47	98.8	1	258	4	9	92	XP_068347957.1 AGC family protein kinase [Tritrichomonas foetus]	diamond	1782	75.5	0.994701986754967	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);;