metadata: contig_metadata: 8 rows where bioproject = "PRJEB11748" and tax

8 rows where bioproject = "PRJEB11748" and tax_clade = "Metamonada"

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
11498528	11498528	PRJEB11748_P_NODE_94250_length_431_cov_2.408108_g92082_i0	PRJEB11748	94250	431	2.408108	10.37894548	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	58.4	8.94e-4	NTclustered	gi\|2794974794\|ref\|XM_067862723.1\|	2049356	g92082	i0	97.143	0.28538283062645	35	0	8	1	1	34	9093	9059	Monocercomonoides exilis Exocyst complex component Sec5 (MONOS_10283), partial mRNA	blastn	123	58.4	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
25209872	25209872	PRJEB11748_P_NODE_242380_length_252_cov_1.230366_g240197_i0	PRJEB11748	242380	252	1.230366	3.10052232	Paratrimastix	1709327	Preaxostyla	other_Eukaryota	141	4.74e-29	NTclustered	gi\|14348576\|gb\|AF244904.1\|AF244904	137421	g240197	i0	88.235	11.9126984126984	119	13	47	1	118	236	1540	1657	Trimastix pyriformis ATCC50598 small subunit ribosomal RNA gene, complete sequence	blastn	3002	141	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis ATCC50598
30254356	30254356	PRJEB11748_P_NODE_308492_length_215_cov_8.454545_g306309_i0	PRJEB11748	308492	215	8.454545	18.17727175	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	42	0.0495	NR	EFO65611.1	658858	g306309	i0	38.7	0.865116279069767	62	35	86.5	1	192	7	229	287	EFO65611.1 Hypothetical protein GLP15_1712 [Giardia lamblia P15]	diamond	186	42	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30443725	30443725	PRJEB11748_P_NODE_203113_length_281_cov_3.100000_g200930_i0	PRJEB11748	203113	281	3.1	8.711	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	43.9	0.0202	NR	XP_001321839.1	412133	g200930	i0	32.4	0.758007117437722	71	47	74.7	1	67	276	190	260	XP_001321839.1 spectrin binding [Trichomonas vaginalis G3]	diamond	213	43.9	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
30696231	30696231	PRJEB11748_P_NODE_185034_length_297_cov_3.279661_g182851_i0	PRJEB11748	185034	297	3.279661	9.74059317	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	53.5	1.15e-5	NR	KAJ3451011.1	1746091	g182851	i0	40.3	1.45454545454545	72	41	70.7	1	21	230	953	1024	KAJ3451011.1 putative phospholipid-transporting atpase [Anaeramoeba flamelloides]	diamond	432	53.5	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31290473	31290473	PRJEB11748_P_NODE_290855_length_224_cov_1.957055_g288672_i0	PRJEB11748	290855	224	1.957055	4.3838032	root	1	Root_unresolved	Root_unresolved	44.3	0.00808	NR	XP_001307830.1	412133	g288672	i0	39.7	6.06696428571429	58	33	77.7	1	189	16	292	347	XP_001307830.1 protein of unknown function (DUF3447) [Trichomonas vaginalis G3]	diamond	1359	44.3	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
31391905	31391905	PRJEB11748_P_NODE_333196_length_205_cov_2.256944_g331013_i0	PRJEB11748	333196	205	2.256944	4.6267352	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	42.4	0.0323	NR	KAJ4460314.1	342808	g331013	i0	57.1	0.51219512195122	35	13	51.2	1	202	98	1217	1249	KAJ4460314.1 Multidrug resistance-associated protein [Paratrimastix pyriformis]	diamond	105	42.4	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32372466	32372466	PRJEB11748_P_NODE_141919_length_345_cov_30.873239_g139740_i0	PRJEB11748	141919	345	30.873239	106.51267455	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	61.2	3.94e-8	NR	KAJ3442849.1	1746091	g139740	i0	37.3	1.91304347826087	110	56	90.4	5	29	340	713	815	KAJ3442849.1 hypothetical protein M0812_12601 [Anaeramoeba flamelloides]	diamond	660	61.2	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides

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