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

10 rows where bioproject = "PRJNA421571", tax_clade = "Metamonada" and tax_phylum = "Fornicata"

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
9352058	9352058	PRJNA421571_P_NODE_7728_length_1360_cov_2.463869_g6590_i0	PRJNA421571	7728	1360	2.463869	33.5086184	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	179	8.719999999999999e-45	NR	KAG9392656.1	201153	g6590	i0	34.2	1.73161764705882	389	223	84.7	9	64	1215	852	1212	KAG9392656.1 ABC transporter transmembrane region 2 [Carpediemonas membranifera]	diamond	2355	179	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
26839307	26839307	PRJNA421571_P_NODE_37101_length_496_cov_1.456265_g34558_i0	PRJNA421571	37101	496	1.456265	7.2230744	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	112	1.22e-25	NR	KAG9394580.1	201153	g34558	i0	38.1	2.02016129032258	168	91	99.8	3	1	495	280	437	KAG9394580.1 Repeat of unknown function (DUF1126) [Carpediemonas membranifera]	diamond	1002	113	0.991150442477876	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
27044056	27044056	PRJNA421571_P_NODE_67342_length_312_cov_2.054393_g64793_i0	PRJNA421571	67342	312	2.054393	6.40970616	Giardia intestinalis	5741	Fornicata	other_Eukaryota	44.3	0.0228	NR	ESU45245.1	5741	g64793	i0	56.5	1.32692307692308	46	19	44.2	1	29	166	312	356	ESU45245.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	414	44.3	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
27833638	27833638	PRJNA421571_P_NODE_101504_length_244_cov_1.789474_g98955_i0	PRJNA421571	101504	244	1.789474	4.36631656	Giardia intestinalis	5741	Fornicata	other_Eukaryota	54.3	3.3e-6	NR	ESU44688.1	5741	g98955	i0	39.4	0.811475409836066	66	34	81.1	2	235	38	1750	1809	ESU44688.1 M26 IgA1-specific metallo-endopeptidase, N-terminal region [Giardia intestinalis]	diamond	198	54.3	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28686499	28686499	PRJNA421571_P_NODE_29947_length_591_cov_1.069498_g27427_i0	PRJNA421571	29947	591	1.069498	6.32073318	Giardia intestinalis	5741	Fornicata	other_Eukaryota	50.4	9.85e-4	NR	ESU44822.1	5741	g27427	i0	30.8	3.61421319796954	146	77	62.9	4	6	377	2	145	ESU44822.1 High cysteine membrane protein Group 2 [Giardia intestinalis]	diamond	2136	50.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
30265510	30265510	PRJNA421571_P_NODE_103472_length_243_cov_0.905882_g100923_i0	PRJNA421571	103472	243	0.905882	2.20129326	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	77.4	2.09e-15	NR	GKT31461.1	2918883	g100923	i0	47.4	5.76543209876543	78	41	96.3	0	9	242	99	176	GKT31461.1 Retrovirus-related Pol polyprotein from transposon 17.6, partial [Aduncisulcus paluster]	diamond	1401	77.4	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
31086716	31086716	PRJNA421571_P_NODE_25395_length_672_cov_4.000000_g22923_i0	PRJNA421571	25395	672	4	26.88	Giardia intestinalis assemblage B	1394984	Fornicata	other_Eukaryota	48.5	0.00578	NR	KWX14910.1	1394984	g22923	i0	47	0.625	66	30	29.5	3	189	386	105	165	KWX14910.1 Variant-specific surface protein [Giardia intestinalis assemblage B]	diamond	420	48.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31118017	31118017	PRJNA421571_P_NODE_101995_length_244_cov_0.900585_g99446_i0	PRJNA421571	101995	244	0.900585	2.1974274	Giardia intestinalis	5741	Fornicata	other_Eukaryota	50.4	7.36e-5	NR	XP_001705150.2	5741	g99446	i0	49.1	1.27868852459016	55	25	63.9	2	166	11	501	555	XP_001705150.2 High cysteine membrane protein Group 2 [Giardia intestinalis]	diamond	312	50.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31592849	31592849	PRJNA421571_P_NODE_89976_length_254_cov_1.701657_g87427_i0	PRJNA421571	89976	254	1.701657	4.32220878	Giardia intestinalis	5741	Fornicata	other_Eukaryota	56.6	5.56e-7	NR	ESU42287.1	5741	g87427	i0	47.7	2.58661417322835	65	29	72	2	1	183	701	764	ESU42287.1 Variant-specific surface protein [Giardia intestinalis]	diamond	657	56.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31814070	31814070	PRJNA421571_P_NODE_80297_length_276_cov_1.517241_g77748_i0	PRJNA421571	80297	276	1.517241	4.18758516	Giardia intestinalis	5741	Fornicata	other_Eukaryota	56.2	9.55e-7	NR	ESU40389.1	5741	g77748	i0	41.4	0.945652173913043	87	45	92.4	4	271	17	295	377	ESU40389.1 Variant-specific surface protein, partial [Giardia intestinalis]	diamond	261	56.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis

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