metadata: contig_metadata: 6 rows where bioproject = "PRJNA1063685", tax_clade = "Metamonada" and tax

6 rows where bioproject = "PRJNA1063685", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"

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
4005863	4005863	PRJNA1063685_S_NODE_20484_length_505_cov_5.296296_g19946_i0	PRJNA1063685	20484	505	5.296296	26.7462948	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	310	2.41e-94	NR	KAJ4460522.1	342808	g19946	i0	93.4	74.649504950495	167	11	99.2	0	3	503	2143	2309	KAJ4460522.1 putative 26S proteasome regulatory subunit 6B [Paratrimastix pyriformis]	diamond	37698	310	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
10382990	10382990	PRJNA1063685_S_NODE_51129_length_314_cov_2.821577_g50586_i0	PRJNA1063685	51129	314	2.821577	8.85975178	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	63.9	1.36e-5	NTclustered	gi\|2794969629\|ref\|XM_067864423.1\|	2049356	g50586	i0	100	7.08917197452229	34	0	11	0	198	231	1487	1520	Monocercomonoides exilis uncharacterized protein (MONOS_11852), mRNA	blastn	2226	63.9	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
27248495	27248495	PRJNA1063685_S_NODE_32903_length_409_cov_3.291667_g32361_i0	PRJNA1063685	32903	409	3.291667	13.46291803	root	1	Root_unresolved	Root_unresolved	65.1	3.9e-9	NR	KAJ4457966.1	342808	g32361	i0	31.3	16.6210268948655	144	77	97.6	5	11	409	2109	2241	KAJ4457966.1 putative Serine/threonine-protein kinase EDR1 [Paratrimastix pyriformis]	diamond	6798	65.1	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29972328	29972328	PRJNA1063685_S_NODE_56991_length_291_cov_1.059633_g56448_i0	PRJNA1063685	56991	291	1.059633	3.08353203	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	68.6	5.47e-11	NR	KAA6400217.1	222440	g56448	i0	40.5	1.7319587628866	84	49	85.6	1	41	289	608	691	KAA6400217.1 MAG: putative Serine/threonine protein kinase OSK3 [Streblomastix strix]	diamond	504	68.6	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
32153585	32153585	PRJNA1063685_S_NODE_60378_length_279_cov_1.072816_g59835_i0	PRJNA1063685	60378	279	1.072816	2.99315664	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	53.5	9.44e-6	NR	XP_067733439.1	2049356	g59835	i0	41.4	0.752688172043011	70	38	74.2	2	225	19	628	695	XP_067733439.1 putative collagen beta-1,O-galactosyltransferase [Monocercomonoides exilis]	diamond	210	53.5	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
32470176	32470176	PRJNA1063685_S_NODE_48919_length_324_cov_1.884462_g48376_i0	PRJNA1063685	48919	324	1.884462	6.10565688	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	67	1.87e-10	NR	KAJ4455179.1	342808	g48376	i0	35.5	1.96296296296296	107	62	99.1	3	323	3	24	123	KAJ4455179.1 hypothetical protein PAPYR_9911 [Paratrimastix pyriformis]	diamond	636	67	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis

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