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

8 rows where bioproject = "PRJEB3181" 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
1330258	1330258	PRJEB3181_P_NODE_21742_length_175_cov_1.777778_g21477_i0	PRJEB3181	21742	175	1.777778	3.1111115	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	52.8	0.015	NTclustered	gi\|2794973889\|ref\|XM_067874884.1\|	2049356	g21477	i0	100	0.32	28	0	16	0	102	129	8055	8082	Monocercomonoides exilis uncharacterized protein (MONOS_4785), partial mRNA	blastn	56	52.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
27949344	27949344	PRJEB3181_P_NODE_28345_length_150_cov_0.983193_g28080_i0	PRJEB3181	28345	150	0.983193	1.4747895	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	45.4	0.00108	NR	KAJ3432301.1	1746091	g28080	i0	64.5	1.24	31	11	62	0	146	54	89	119	KAJ3432301.1 muscle-specific protein [Anaeramoeba flamelloides]	diamond	186	45.4	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
29938632	29938632	PRJEB3181_P_NODE_7351_length_309_cov_15.406475_g7090_i0	PRJEB3181	7351	309	15.406475	47.60600775	Spironucleus salmonicida	348837	Fornicata	other_Eukaryota	100	9.58e-25	NR	XP_067764835.1	348837	g7090	i0	62.3	0.747572815533981	77	29	74.8	0	309	79	64	140	XP_067764835.1 Ribosomal protein L23 [Spironucleus salmonicida]	diamond	231	100	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Spironucleus	Spironucleus salmonicida
30412747	30412747	PRJEB3181_P_NODE_1333_length_544_cov_27.278752_g1178_i0	PRJEB3181	1333	544	27.278752	148.39641088	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	51.2	5.08e-4	NR	KAA6397625.1	222440	g1178	i0	61.9	0.231617647058824	42	15	23.2	1	111	236	41	81	KAA6397625.1 MAG: hypothetical protein EZS28_006852 [Streblomastix strix]	diamond	126	51.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
30854736	30854736	PRJEB3181_P_NODE_1714_length_508_cov_6.318658_g1547_i0	PRJEB3181	1714	508	6.318658	32.09878264	Anaeramoeba flamelloides	1746091	Root_unresolved	Root_unresolved	139	2.579999999999999e-38	NR	KAJ3424417.1	1746091	g1547	i0	49.3	8.36811023622047	140	70	82.7	1	2	421	32	170	KAJ3424417.1 60S ribosomal protein L18A [Anaeramoeba flamelloides]	diamond	4251	139	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba flamelloides
31392313	31392313	PRJEB3181_P_NODE_18916_length_190_cov_1.704403_g18652_i0	PRJEB3181	18916	190	1.704403	3.2383657	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	52.8	1.06e-6	NR	XP_001322826.1	412133	g18652	i0	61	1.31052631578947	41	16	64.7	0	6	128	88	128	XP_001322826.1 U4atac snRNA binding [Trichomonas vaginalis G3]	diamond	249	52.8	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
32404537	32404537	PRJEB3181_P_NODE_8419_length_291_cov_6.838462_g8156_i0	PRJEB3181	8419	291	6.838462	19.89992442	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	53.5	8.85e-6	NR	XP_067719024.1	2049356	g8156	i0	39.7	0.649484536082474	63	37	64.9	1	289	101	5	66	XP_067719024.1 uncharacterized protein MONOS_12211 [Monocercomonoides exilis]	diamond	189	53.5	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
32656792	32656792	PRJEB3181_P_NODE_24780_length_162_cov_1.564885_g24515_i0	PRJEB3181	24780	162	1.564885	2.5351137	Anaeramoeba ignava	1746090	Root_unresolved	Root_unresolved	45.8	0.00104	NR	KAJ5072680.1	1746090	g24515	i0	57.1	0.648148148148148	35	15	64.8	0	4	108	415	449	KAJ5072680.1 aminotransferase [Anaeramoeba ignava]	diamond	105	45.8	1	Eukaryota	Metamonada			Anaeramoebidae	Anaeramoeba	Anaeramoeba ignava

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