metadata: contig_metadata: 10 rows where bioproject = "PRJNA575566" and tax

10 rows where bioproject = "PRJNA575566" 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
560028	560028	PRJNA575566_P_NODE_17541_length_251_cov_1.794737_g17344_i0	PRJNA575566	17541	251	1.794737	4.50478987	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	118	6.86e-32	NR	KAJ5067634.1	1746090	g17344	i0	74	10.1235059760956	77	20	92	0	18	248	1	77	KAJ5067634.1 40S ribosomal protein S23 [Anaeramoeba ignava]	diamond	2541	118	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
560338	560338	PRJNA575566_P_NODE_8761_length_354_cov_1.180887_g8564_i0	PRJNA575566	8761	354	1.180887	4.18033998	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	82.4	3.83e-16	NR	KAJ4459881.1	342808	g8564	i0	54.8	0.61864406779661	73	33	61.9	0	349	131	167	239	KAJ4459881.1 putative Single-stranded TG1-3 DNA-binding protein [Paratrimastix pyriformis]	diamond	219	82.4	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
14588814	14588814	PRJNA575566_P_NODE_17932_length_249_cov_1.021277_g17735_i0	PRJNA575566	17932	249	1.021277	2.54297973	uncultured Oxymonadida sp.	413579	Preaxostyla	other_Eukaryota	193	1.27e-44	NTclustered	gi\|119117134\|gb\|DQ925208.1\|	413579	g17735	i0	80.876	6.18072289156626	251	42	99	6	1	248	134	381	Unidentified Oxymonadida clone R21 alpha-tubulin (Atub) mRNA, partial cds	blastn	1539	193	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida			uncultured Oxymonadida sp.
19686564	19686564	PRJNA575566_P_NODE_22276_length_220_cov_1.540881_g22079_i0	PRJNA575566	22276	220	1.540881	3.3899382	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	54.7	0.005	NTclustered	gi\|2794940695\|ref\|XM_067877144.1\|	2049356	g22079	i0	94.444	0.327272727272727	36	1	16	1	7	42	5984	6018	Monocercomonoides exilis uncharacterized protein (MONOS_6873), partial mRNA	blastn	72	54.7	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
28311362	28311362	PRJNA575566_P_NODE_27526_length_204_cov_0.895105_g27329_i0	PRJNA575566	27526	204	0.895105	1.8260142	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	44.7	0.00483	NR	EFO64161.1	658858	g27329	i0	35.4	1.76470588235294	65	39	95.6	2	4	198	353	414	EFO64161.1 VSP with INR [Giardia lamblia P15]	diamond	360	44.7	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
28406034	28406034	PRJNA575566_P_NODE_3006_length_596_cov_1.196262_g2811_i0	PRJNA575566	3006	596	1.196262	7.12972152	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	98.2	4.85e-20	NR	KAJ5076240.1	1746090	g2811	i0	33.7	2.66778523489933	175	67	88.1	2	558	34	209	334	KAJ5076240.1 RNA recognition motif rrm domain containing protein [Anaeramoeba ignava]	diamond	1590	98.2	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
29006302	29006302	PRJNA575566_P_NODE_20508_length_231_cov_1.505882_g20311_i0	PRJNA575566	20508	231	1.505882	3.47858742	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	47.4	7.52e-4	NR	KAJ3442778.1	1746091	g20311	i0	33.8	2.87012987012987	74	49	96.1	0	226	5	454	527	KAJ3442778.1 alpha-actinin sarcomeric-like protein [Anaeramoeba flamelloides]	diamond	663	47.4	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29574004	29574004	PRJNA575566_P_NODE_23110_length_215_cov_1.240260_g22913_i0	PRJNA575566	23110	215	1.24026	2.666559	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	57	2.47e-7	NR	KAJ5073100.1	1746090	g22913	i0	45.6	0.948837209302326	68	37	94.9	0	205	2	440	507	KAJ5073100.1 spectrin/filamin related cytoskeletal protein [Anaeramoeba ignava]	diamond	204	57	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava
30869344	30869344	PRJNA575566_P_NODE_17894_length_249_cov_1.361702_g17697_i0	PRJNA575566	17894	249	1.361702	3.39063798	Giardia lamblia P15	658858	Fornicata	other_Eukaryota	51.2	4.06e-5	NR	EFO63958.1	658858	g17697	i0	54.5	0.397590361445783	33	15	39.8	0	152	54	436	468	EFO63958.1 VSP [Giardia lamblia P15]	diamond	99	51.2	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia duodenalis
32369619	32369619	PRJNA575566_P_NODE_26419_length_206_cov_0.882759_g26222_i0	PRJNA575566	26419	206	0.882759	1.81848354	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	46.6	0.001	NR	ESU42996.1	5741	g26222	i0	39.3	5.16990291262136	56	25	71.4	2	206	60	313	366	ESU42996.1 Variant-specific surface protein [Giardia intestinalis]	diamond	1065	47	0.991489361702128	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);;