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

10 rows where bioproject = "PRJNA270367", 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
11848522	11848522	PRJNA270367_P_NODE_15850_length_318_cov_1.185874_g15645_i0	PRJNA270367	15850	318	1.185874	3.77107932	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	63.9	1.38e-5	NTclustered	gi\|2806466521\|ref\|XM_068506468.1\|	1144522	g15645	i0	95.122	0.128930817610063	41	1	13	1	174	214	2164	2203	Tritrichomonas foetus uncharacterized protein (TRFO_28932), partial mRNA	blastn	41	63.9	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
20771486	20771486	PRJNA270367_P_NODE_25797_length_225_cov_1.477273_g25592_i0	PRJNA270367	25797	225	1.477273	3.32386425	Trichomonas vaginalis	5722	Parabasalia	other_Eukaryota	62.1	3.32e-5	NTclustered	gi\|2319647530\|ref\|XM_001581711.2\|	412133	g25592	i0	94.872	0.173333333333333	39	2	17	0	175	213	1323	1361	Trichomonas vaginalis G3 uncharacterized protein (TVAGG3_0323080), partial mRNA	blastn	39	62.1	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
24596022	24596022	PRJNA270367_P_NODE_1360_length_1220_cov_3.115286_g1213_i0	PRJNA270367	1360	1220	3.1152860000000002	38.0064892	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	85.5	7.93e-14	NR	XP_067770880.1	135588	g1213	i0	38.4	0.607377049180328	125	70	30.7	2	257	631	306	423	XP_067770880.1 C2 domain containing protein [Histomonas meleagridis]	diamond	741	85.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
26915803	26915803	PRJNA270367_P_NODE_10722_length_405_cov_1.103933_g10520_i0	PRJNA270367	10722	405	1.103933	4.47092865	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	47.4	0.00509	NR	XP_001580550.1	412133	g10520	i0	37.3	0.496296296296296	67	30	40.7	4	201	37	543	609	XP_001580550.1 pectin lyase-like family [Trichomonas vaginalis G3]	diamond	201	47.4	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
27832106	27832106	PRJNA270367_P_NODE_44284_length_164_cov_0.939130_g44079_i0	PRJNA270367	44284	164	0.93913	1.5401732	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	45.4	0.00142	NR	XP_001580008.1	412133	g44079	i0	52.6	1.39024390243902	38	16	65.9	1	138	31	230	267	XP_001580008.1 serine-type endopeptidase protein [Trichomonas vaginalis G3]	diamond	228	45.4	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
28116211	28116211	PRJNA270367_P_NODE_27125_length_218_cov_1.094675_g26920_i0	PRJNA270367	27125	218	1.094675	2.3863915	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	50.8	3.42e-5	NR	XP_068357636.1	1144522	g26920	i0	41	1.91284403669725	61	32	78.4	1	41	211	99	159	XP_068357636.1 uncharacterized protein TRFO_28011 [Tritrichomonas foetus]	diamond	417	50.8	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
29049817	29049817	PRJNA270367_P_NODE_45308_length_163_cov_0.912281_g45103_i0	PRJNA270367	45308	163	0.912281	1.48701803	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	42	0.0229	NR	KAH0790010.1	135588	g45103	i0	51.7	3.58895705521472	29	14	53.4	0	75	161	1	29	KAH0790010.1 putative alpha-actinin [Histomonas meleagridis]	diamond	585	42	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
29144747	29144747	PRJNA270367_P_NODE_6409_length_536_cov_1.644764_g6214_i0	PRJNA270367	6409	536	1.644764	8.81593504	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	204	5.6500000000000006e-58	NR	BAA24068.1	43075	g6214	i0	56.7	13.9701492537313	178	72	99.6	1	3	536	327	499	BAA24068.1 elongation factor 2, partial [Trichomonas tenax]	diamond	7488	204	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas tenax
31622608	31622608	PRJNA270367_P_NODE_43996_length_164_cov_2.573913_g43791_i0	PRJNA270367	43996	164	2.573913	4.22121732	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	57.8	8.72e-9	NR	XP_001322826.1	412133	g43791	i0	62.2	1.64634146341463	45	17	82.3	0	3	137	84	128	XP_001322826.1 U4atac snRNA binding [Trichomonas vaginalis G3]	diamond	270	57.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
31907346	31907346	PRJNA270367_P_NODE_5657_length_574_cov_3.925714_g5465_i0	PRJNA270367	5657	574	3.925714	22.53359836	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	199	1.18e-61	NR	XP_068360038.1	1144522	g5465	i0	57.2	6.42334494773519	173	74	90.4	0	550	32	5	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	3687	199	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);;