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

5 rows where bioproject = "PRJNA222400", 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
28179155	28179155	PRJNA222400_P_NODE_7946_length_166_cov_1.777778_g7913_i0	PRJNA222400	7946	166	1.777778	2.95111148	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	63.9	1.82e-10	NR	KAJ4461374.1	342808	g7913	i0	53.7	1.95180722891566	54	25	97.6	0	5	166	105	158	KAJ4461374.1 putative tyrosine phosphatase [Paratrimastix pyriformis]	diamond	324	63.9	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29032135	29032135	PRJNA222400_P_NODE_3848_length_228_cov_1.089385_g3815_i0	PRJNA222400	3848	228	1.089385	2.4837978	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	90.9	3.2e-19	NR	KAJ4461998.1	342808	g3815	i0	54.1	0.973684210526316	74	34	97.4	0	225	4	270	343	KAJ4461998.1 putative Glycoside hydrolase [Paratrimastix pyriformis]	diamond	222	90.9	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30042352	30042352	PRJNA222400_P_NODE_411_length_783_cov_2.935967_g386_i0	PRJNA222400	411	783	2.935967	22.98862161	Paratrimastix eleionoma	1709329	Preaxostyla	other_Eukaryota	151	2.8e-42	NR	WCZ58434.1	1709329	g386	i0	61.1	4.05747126436782	126	48	48.3	1	24	401	1	125	WCZ58434.1 translation initiation factor 1A [Paratrimastix eleionoma]	diamond	3177	151	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix eleionoma
30516293	30516293	PRJNA222400_P_NODE_2693_length_292_cov_3.304527_g2660_i0	PRJNA222400	2693	292	3.304527	9.64921884	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	42.7	0.0145	NR	XP_067729760.1	2049356	g2660	i0	40	1.4486301369863	75	44	77.1	1	250	26	20	93	XP_067729760.1 uncharacterized protein MONOS_12776 [Monocercomonoides exilis]	diamond	423	42.7	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
31337850	31337850	PRJNA222400_P_NODE_5736_length_187_cov_1.666667_g5703_i0	PRJNA222400	5736	187	1.666667	3.11666729	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	42	0.0298	NR	KAA6386700.1	222440	g5703	i0	39.6	0.850267379679144	53	32	85	0	179	21	162	214	KAA6386700.1 MAG: putative Vesicle-associated membrane protein 7B [Streblomastix strix]	diamond	159	42	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix

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