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

5 rows where bioproject = "PRJNA407087", tax_clade = "Metamonada" and tax_phylum = "Parabasalia"

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
26980454	26980454	PRJNA407087_S_NODE_3622_length_301_cov_3.566176_g3159_i0	PRJNA407087	3622	301	3.566176	10.73418976	Trichomonas vaginalis G3	412133	Parabasalia	other_Eukaryota	84	2.23e-16	NR	XP_001307808.1	412133	g3159	i0	44.9	1.90365448504983	98	54	97.7	0	294	1	339	436	XP_001307808.1 Clan MH, family M20, peptidase T-like metallopeptidase dapE [Trichomonas vaginalis G3]	diamond	573	84	1	Eukaryota	Metamonada	Parabasalia	Trichomonadida	Trichomonadidae	Trichomonas	Trichomonas vaginalis
28212193	28212193	PRJNA407087_S_NODE_2266_length_429_cov_27.940000_g1805_i0	PRJNA407087	2266	429	27.94	119.8626	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	132	6.480000000000001e-36	NR	XP_068360038.1	1144522	g1805	i0	55	4.53146853146853	131	59	91.6	0	1	393	48	178	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	1944	132	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
28591427	28591427	PRJNA407087_S_NODE_6747_length_191_cov_2.061728_g6284_i0	PRJNA407087	6747	191	2.061728	3.93790048	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	41.6	0.0488	NR	XP_068357511.1	1144522	g6284	i0	31.8	1.03664921465969	66	42	99	1	191	3	66	131	XP_068357511.1 WD repeat protein [Tritrichomonas foetus]	diamond	198	41.6	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
29349184	29349184	PRJNA407087_S_NODE_2289_length_426_cov_67.397985_g1828_i0	PRJNA407087	2289	426	67.397985	287.1154161	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	141	2.08e-39	NR	XP_068360038.1	1144522	g1828	i0	56.9	0.915492957746479	130	56	91.5	0	1	390	48	177	XP_068360038.1 40S ribosomal protein S9-1 [Tritrichomonas foetus]	diamond	390	141	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus
32383385	32383385	PRJNA407087_S_NODE_9979_length_151_cov_1.459016_g9516_i0	PRJNA407087	9979	151	1.459016	2.20311416	Tritrichomonas foetus	1144522	Parabasalia	other_Eukaryota	53.5	8.11e-7	NR	XP_068362296.1	1144522	g9516	i0	48.9	2.86092715231788	45	23	89.4	0	146	12	93	137	XP_068362296.1 small GTP-binding protein [Tritrichomonas foetus]	diamond	432	53.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Tritrichomonadidae	Tritrichomonas	Tritrichomonas foetus

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