metadata: contig_metadata: 14 rows where bioproject = "PRJNA577580", tax_clade = "Metamonada" and tax

14 rows where bioproject = "PRJNA577580", 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
6942247	6942247	PRJNA577580_P_NODE_5626_length_377_cov_3.269737_g5548_i0	PRJNA577580	5626	377	3.269737	12.32690849	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	175	1e-50	NR	KAJ4456818.1	342808	g5548	i0	67.8	1.88594164456233	118	38	93.9	0	376	23	256	373	KAJ4456818.1 putative Cell division control protein 2 [Paratrimastix pyriformis]	diamond	711	175	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
9492382	9492382	PRJNA577580_P_NODE_11128_length_276_cov_1.152709_g11050_i0	PRJNA577580	11128	276	1.152709	3.18147684	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	62.1	4.22e-5	NTclustered	gi\|2794954191\|ref\|XM_067864300.1\|	2049356	g11050	i0	93.023	11.4094202898551	43	2	15	1	48	89	1917	1959	Monocercomonoides exilis putative CRE-CLP-2 protein (MONOS_11737), mRNA	blastn	3149	62.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
12043148	12043148	PRJNA577580_P_NODE_5130_length_396_cov_1.287926_g5052_i0	PRJNA577580	5130	396	1.287926	5.10018696	uncultured Oxymonadida sp.	413579	Preaxostyla	other_Eukaryota	313	1.57e-80	NTclustered	gi\|119117128\|gb\|DQ925205.1\|	413579	g5052	i0	81.203	96.0833333333333	399	66	100	8	1	396	444	836	Unidentified Oxymonadida clone R9 alpha-tubulin (Atub) mRNA, partial cds	blastn	38049	313	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida			uncultured Oxymonadida sp.
23516414	23516414	PRJNA577580_P_NODE_12239_length_265_cov_1.036458_g12161_i0	PRJNA577580	12239	265	1.036458	2.7466137	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	60.2	1.45e-4	NTclustered	gi\|2794948749\|ref\|XM_067868623.1\|	2049356	g12161	i0	100	7.76603773584906	32	0	24	0	201	232	6927	6896	Monocercomonoides exilis uncharacterized protein (MONOS_15731), partial mRNA	blastn	2058	60.2	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
27521948	27521948	PRJNA577580_P_NODE_7963_length_320_cov_1.263158_g7885_i0	PRJNA577580	7963	320	1.263158	4.0421056	Blattamonas nauphoetae	2049346	Preaxostyla	other_Eukaryota	75.1	3.99e-13	NR	KAK2964370.1	2049346	g7885	i0	45.3	0.890625	95	52	89.1	0	1	285	171	265	KAK2964370.1 putative Arginine--tRNA ligase [Blattamonas nauphoetae]	diamond	285	75.1	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida		Blattamonas	Blattamonas nauphoetae
28090299	28090299	PRJNA577580_P_NODE_9845_length_291_cov_3.816514_g9767_i0	PRJNA577580	9845	291	3.816514	11.10605574	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	72.8	8.79e-14	NR	KAJ4459457.1	342808	g9767	i0	38.8	1.01030927835052	98	55	97.9	2	3	287	37	132	KAJ4459457.1 hypothetical protein PAPYR_4504 [Paratrimastix pyriformis]	diamond	294	72.8	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28167086	28167086	PRJNA577580_P_NODE_3025_length_517_cov_3.024775_g2947_i0	PRJNA577580	3025	517	3.024775	15.63808675	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	152	4.63e-40	NR	KAJ4461998.1	342808	g2947	i0	43.9	1.99032882011605	171	95	99.2	1	514	2	280	449	KAJ4461998.1 putative Glycoside hydrolase [Paratrimastix pyriformis]	diamond	1029	152	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
28500912	28500912	PRJNA577580_P_NODE_13567_length_253_cov_0.866667_g13489_i0	PRJNA577580	13567	253	0.866667	2.19266751	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	94	1.89e-21	NR	KAA6379712.1	222440	g13489	i0	56.1	1.92094861660079	82	36	97.2	0	7	252	97	178	KAA6379712.1 MAG: putative elav G [Streblomastix strix]	diamond	486	94	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
29195598	29195598	PRJNA577580_P_NODE_9089_length_302_cov_1.126638_g9011_i0	PRJNA577580	9089	302	1.126638	3.40244676	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	83.2	5.64e-17	NR	KAJ4459187.1	342808	g9011	i0	41.1	0.943708609271523	95	55	93.4	1	3	284	136	230	KAJ4459187.1 hypothetical protein PAPYR_4993 [Paratrimastix pyriformis]	diamond	285	83.2	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
29637119	29637119	PRJNA577580_P_NODE_6050_length_365_cov_1.671233_g5972_i0	PRJNA577580	6050	365	1.671233	6.10000045	Paratrimastix pyriformis	342808	Preaxostyla	other_Eukaryota	130	2.8199999999999996e-32	NR	KAJ4459039.1	342808	g5972	i0	57	0.994520547945206	121	49	98.6	3	360	1	214	332	KAJ4459039.1 putative 3'-5' exonuclease [Paratrimastix pyriformis]	diamond	363	130	1	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
30711542	30711542	PRJNA577580_P_NODE_13874_length_252_cov_0.871508_g13796_i0	PRJNA577580	13874	252	0.871508	2.19620016	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	62.8	3.8e-9	NR	XP_067728979.1	2049356	g13796	i0	35.2	1.04761904761905	88	49	95.2	2	249	10	339	426	XP_067728979.1 uncharacterized protein MONOS_1500 [Monocercomonoides exilis]	diamond	264	62.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
31926390	31926390	PRJNA577580_P_NODE_13477_length_253_cov_1.700000_g13399_i0	PRJNA577580	13477	253	1.7	4.301	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	157	3.01e-42	NR	KAJ4460522.1	342808	g13399	i0	91.7	70.7075098814229	84	7	99.6	0	252	1	2218	2301	KAJ4460522.1 putative 26S proteasome regulatory subunit 6B [Paratrimastix pyriformis]	diamond	17889	158	0.993670886075949	Eukaryota	Metamonada	Preaxostyla		Paratrimastigidae	Paratrimastix	Paratrimastix pyriformis
32071178	32071178	PRJNA577580_P_NODE_7378_length_331_cov_2.534884_g7300_i0	PRJNA577580	7378	331	2.534884	8.39046604	Streblomastix strix	222440	Preaxostyla	other_Eukaryota	119	1.04e-28	NR	KAA6381424.1	222440	g7300	i0	53.7	11.3111782477341	108	50	97.9	0	5	328	426	533	KAA6381424.1 MAG: putative ELAV protein [Streblomastix strix]	diamond	3744	119	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Streblomastigidae	Streblomastix	Streblomastix strix
32179751	32179751	PRJNA577580_P_NODE_15518_length_245_cov_1.191860_g15440_i0	PRJNA577580	15518	245	1.19186	2.920057	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.5	2.22e-8	NR	KAJ4457181.1	342808	g15440	i0	38.7	4.76326530612245	75	45	91.8	1	238	14	11	84	KAJ4457181.1 putative Protein SHOOT GRAVITROPISM 6 [Paratrimastix pyriformis]	diamond	1167	60.8	0.995065789473684	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);;