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

10 rows where bioproject = "PRJNA489308", 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
10026390	10026390	PRJNA489308_P_NODE_13048_length_327_cov_2.232283_g12972_i0	PRJNA489308	13048	327	2.232283	7.29956541	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	148	1.2599999999999999e-42	NR	GIQ84029.1	797122	g12972	i0	74.7	4.1743119266055	91	23	83.5	0	273	1	3	93	GIQ84029.1 Ran GTPase [Kipferlia bialata]	diamond	1365	149	0.993288590604027	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
26934174	26934174	PRJNA489308_P_NODE_34182_length_247_cov_0.873563_g34106_i0	PRJNA489308	34182	247	0.873563	2.15770061	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.9	4.42e-6	NR	KAG9391744.1	201153	g34106	i0	34.1	1.97975708502024	82	28	99.6	1	1	246	80	135	KAG9391744.1 Peptide chain release factor eRF1/aRF1 [Carpediemonas membranifera]	diamond	489	54.3	0.992633517495396	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
27044768	27044768	PRJNA489308_P_NODE_3642_length_530_cov_1.919037_g3566_i0	PRJNA489308	3642	530	1.919037	10.1708961	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	83.6	4.95e-15	NR	GKT36386.1	2918883	g3566	i0	45.8	1.53396226415094	96	32	43.6	3	21	251	1368	1462	GKT36386.1 Deoxyribonuclease II like protein [Aduncisulcus paluster]	diamond	813	83.6	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
27107789	27107789	PRJNA489308_P_NODE_9502_length_363_cov_1.396552_g9426_i0	PRJNA489308	9502	363	1.396552	5.06948376	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	102	9.86e-23	NR	GKT23767.1	2918883	g9426	i0	48.9	3.53719008264463	88	45	72.7	0	99	362	258	345	GKT23767.1 Zinc finger protein ZPR1 [Aduncisulcus paluster]	diamond	1284	102	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster
27170980	27170980	PRJNA489308_P_NODE_13802_length_322_cov_1.088353_g13726_i0	PRJNA489308	13802	322	1.088353	3.50449666	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	145	4.849999999999999e-38	NR	KAG9390257.1	201153	g13726	i0	63	1.00621118012422	108	37	97.8	1	321	7	43	150	KAG9390257.1 C2 domain of PTEN tumor-suppressor protein [Carpediemonas membranifera]	diamond	324	145	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
27740095	27740095	PRJNA489308_P_NODE_4384_length_493_cov_1.754762_g4308_i0	PRJNA489308	4384	493	1.754762	8.65097666	Kipferlia bialata	797122	Fornicata	other_Eukaryota	47.8	0.0074	NR	GIQ82786.1	797122	g4308	i0	36.4	0.602434077079107	99	52	57.2	4	12	293	483	575	GIQ82786.1 hypothetical protein KIPB_003984 [Kipferlia bialata]	diamond	297	47.8	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
28624012	28624012	PRJNA489308_P_NODE_21727_length_280_cov_1.400966_g21651_i0	PRJNA489308	21727	280	1.400966	3.9227048	Kipferlia bialata	797122	Fornicata	other_Eukaryota	43.1	0.0389	NR	GIQ84516.1	797122	g21651	i0	26.2	1.10357142857143	103	54	96.4	3	6	275	27	120	GIQ84516.1 hypothetical protein KIPB_006019, partial [Kipferlia bialata]	diamond	309	43.1	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
28939678	28939678	PRJNA489308_P_NODE_14008_length_320_cov_1.635628_g13932_i0	PRJNA489308	14008	320	1.635628	5.2340096	Hexamita inflata	28002	Fornicata	other_Eukaryota	56.6	4.96e-7	NR	CAK8774055.1	28002	g13932	i0	28.9	2.83125	114	63	98.4	2	319	5	96	200	CAK8774055.1 HINF_058378 [Hexamita inflata]	diamond	906	56.6	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29539365	29539365	PRJNA489308_P_NODE_670_length_1030_cov_3.582027_g619_i0	PRJNA489308	670	1030	3.582027	36.8948781	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	48.5	0.0316	NR	KAG9389591.1	201153	g619	i0	43.9	0.166019417475728	57	31	16.6	1	814	984	349	404	KAG9389591.1 Ubiquitin family [Carpediemonas membranifera]	diamond	171	48.5	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
32479393	32479393	PRJNA489308_P_NODE_11599_length_339_cov_2.812030_g11523_i0	PRJNA489308	11599	339	2.81203	9.5327817	Giardia intestinalis assemblage B	1394984	Fornicata	other_Eukaryota	47	0.00376	NR	KWX13038.1	1394984	g11523	i0	39.4	0.584070796460177	66	36	54.9	2	228	43	103	168	KWX13038.1 Variant-specific surface protein [Giardia intestinalis assemblage B]	diamond	198	47	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);;