metadata: contig_metadata: 8 rows where bioproject = "PRJNA407087", tax_clade = "Metamonada" and tax

8 rows where bioproject = "PRJNA407087", 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
28545108	28545108	PRJNA407087_S_NODE_4687_length_246_cov_5.354839_g4224_i0	PRJNA407087	4687	246	5.354839	13.17290394	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	85.5	1.84e-17	NR	CAK8773861.1	28002	g4224	i0	50	3.91463414634146	82	40	98.8	1	244	2	195	276	CAK8773861.1 HINF_055388 [Hexamita inflata]	diamond	963	85.5	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
28591429	28591429	PRJNA407087_S_NODE_9567_length_154_cov_2.272000_g9104_i0	PRJNA407087	9567	154	2.272	3.49888	Giardia intestinalis	5741	Fornicata	other_Eukaryota	46.2	6.73e-4	NR	XP_001707734.2	5741	g9104	i0	40	1.75324675324675	45	27	87.7	0	7	141	900	944	XP_001707734.2 VSP [Giardia intestinalis]	diamond	270	46.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
29443586	29443586	PRJNA407087_S_NODE_1850_length_489_cov_16.256522_g1407_i0	PRJNA407087	1850	489	16.256522	79.49439258	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	97.4	3.19e-22	NR	KAG9392754.1	201153	g1407	i0	39	0.94478527607362	154	84	92	6	467	18	1	148	KAG9392754.1 Translationally controlled tumor protein [Carpediemonas membranifera]	diamond	462	97.4	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
31261269	31261269	PRJNA407087_S_NODE_6615_length_193_cov_3.304878_g6152_i0	PRJNA407087	6615	193	3.304878	6.37841454	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	72.4	5.53e-13	NR	ESU43233.1	5741	g6152	i0	64.3	5.17616580310881	56	20	87	0	182	15	82	137	ESU43233.1 Cytosolic heat shock protein 90 [Giardia intestinalis]	diamond	999	72.8	0.994505494505495	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
31529334	31529334	PRJNA407087_S_NODE_6916_length_187_cov_3.354430_g6453_i0	PRJNA407087	6916	187	3.35443	6.2727841	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	103	7.89e-25	NR	KAG9393831.1	201153	g6453	i0	72.6	1.98930481283422	62	17	99.5	0	2	187	108	169	KAG9393831.1 cyclin-dependent kinase-like [Carpediemonas membranifera]	diamond	372	103	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
31672335	31672335	PRJNA407087_S_NODE_7457_length_178_cov_4.268456_g6994_i0	PRJNA407087	7457	178	4.268456	7.59785168	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	51.2	1.62e-5	NR	TNJ29928.1	5742	g6994	i0	37.3	4.36516853932584	59	37	99.4	0	2	178	75	133	TNJ29928.1 Kinase, NEK [Giardia muris]	diamond	777	51.6	0.992248062015504	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
32510208	32510208	PRJNA407087_S_NODE_6679_length_192_cov_2.975460_g6216_i0	PRJNA407087	6679	192	2.97546	5.7128832	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	42.4	0.0264	NR	GKT34970.1	2918883	g6216	i0	39	0.921875	59	36	92.2	0	11	187	1521	1579	GKT34970.1 Dynein beta chain, ciliary, partial [Aduncisulcus paluster]	diamond	177	42.4	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
32510211	32510211	PRJNA407087_S_NODE_8679_length_162_cov_4.233083_g8216_i0	PRJNA407087	8679	162	4.233083	6.85759446	Giardia muris	5742	Fornicata	other_Eukaryota	48.1	1.59e-4	NR	TNJ26588.1	5742	g8216	i0	46.2	0.722222222222222	39	21	72.2	0	1	117	148	186	TNJ26588.1 pVSP [Giardia muris]	diamond	117	48.1	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris

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