metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA812715" 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
2088217	2088217	PRJNA812715_P_NODE_18922_length_792_cov_11.212796_g17355_i0	PRJNA812715	18922	792	11.212796	88.80534432	Foaina nana	561876	Parabasalia	other_Eukaryota	1016	0	NTclustered	gi\|385861554\|dbj\|AB468086.1\|	561876	g17355	i0	90.141	72.8484848484848	781	77	99	0	1	781	86	866	Foaina nana mRNA for actin, partial cds, clone: CdFA6	blastn	57696	1016	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
2089143	2089143	PRJNA812715_P_NODE_46222_length_403_cov_1.866667_g44426_i0	PRJNA812715	46222	403	1.866667	7.52266801	Joenia annectens	450820	Parabasalia	other_Eukaryota	508	1.91e-139	NTclustered	gi\|385861538\|dbj\|AB468078.1\|	450820	g44426	i0	89.698	35.0198511166253	398	41	99	0	6	403	871	474	Joenia annectens mRNA for actin, partial cds, clone: KfJA1	blastn	14113	508	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Joenia	Joenia annectens
4640956	4640956	PRJNA812715_P_NODE_17344_length_853_cov_1.365385_g15822_i0	PRJNA812715	17344	853	1.365385	11.64673405	Foaina nana	561876	Parabasalia	other_Eukaryota	1018	0	NTclustered	gi\|385861554\|dbj\|AB468086.1\|	561876	g15822	i0	88.249	97.3118405627198	851	100	99	0	1	851	851	1	Foaina nana mRNA for actin, partial cds, clone: CdFA6	blastn	83007	1018	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
4642704	4642704	PRJNA812715_P_NODE_70904_length_304_cov_1.255411_g69104_i0	PRJNA812715	70904	304	1.255411	3.81644944	Joenia annectens	450820	Parabasalia	other_Eukaryota	357	5.36e-94	NTclustered	gi\|374428455\|dbj\|AB614008.1\|	450820	g69104	i0	87.829	15.2697368421053	304	37	100	0	1	304	512	815	Joenia annectens gene for actin, partial cds, clone: KfJA9	blastn	4642	357	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Joenia	Joenia annectens
5916062	5916062	PRJNA812715_P_NODE_24245_length_654_cov_4.027539_g22541_i0	PRJNA812715	24245	654	4.027539	26.34010506	Caduceia versatilis	402894	Parabasalia	other_Eukaryota	610	8.559999999999996e-170	NTclustered	gi\|385861550\|dbj\|AB468084.1\|	402894	g22541	i0	83.486	7.24923547400612	654	108	100	0	1	654	204	857	Caduceia versatilis mRNA for actin, partial cds, clone: CcCA4	blastn	4741	610	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Caduceia	Caduceia versatilis
5917227	5917227	PRJNA812715_P_NODE_60725_length_336_cov_1.460076_g58926_i0	PRJNA812715	60725	336	1.460076	4.90585536	Joenia annectens	450820	Parabasalia	other_Eukaryota	451	2.67e-122	NTclustered	gi\|385861538\|dbj\|AB468078.1\|	450820	g58926	i0	91.018	24.5208333333333	334	30	99	0	3	336	424	757	Joenia annectens mRNA for actin, partial cds, clone: KfJA1	blastn	8239	451	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Joenia	Joenia annectens
5917248	5917248	PRJNA812715_P_NODE_61525_length_333_cov_1.769231_g59726_i0	PRJNA812715	61525	333	1.769231	5.89153923	Joenoides intermedia	561868	Parabasalia	other_Eukaryota	327	4.659999999999999e-85	NTclustered	gi\|374428463\|dbj\|AB614012.1\|	561868	g59726	i0	84.384	11.1321321321321	333	52	100	0	1	333	510	178	Joenoides intermedia gene for actin, partial cds, clone: HmJA2	blastn	3707	327	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Joenoides	Joenoides intermedia
7603134	7603134	PRJNA812715_P_NODE_57006_length_350_cov_1.667870_g55207_i0	PRJNA812715	57006	350	1.66787	5.837545	Monocercomonoides	302781	Preaxostyla	other_Eukaryota	392	1.72e-104	NTclustered	gi\|156708131\|gb\|EF474123.1\|	302782	g55207	i0	88.379	92.9085714285714	327	36	93	2	25	350	1278	953	Monocercomonoides sp. PA clone 4/4 tubulin alpha subunit mRNA, complete cds	blastn	32518	392	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides sp. PA
8465026	8465026	PRJNA812715_P_NODE_11307_length_1173_cov_3.808182_g10153_i0	PRJNA812715	11307	1173	3.808182	44.66997486	Stephanonympha nelumbium	402892	Parabasalia	other_Eukaryota	1158	0	NTclustered	gi\|115293044\|gb\|DQ855403.1\|	402892	g10153	i0	93.606	66.2625745950554	782	40	66	8	399	1173	672	1450	Stephanonympha nelumbium clone 1 small subunit ribosomal RNA gene, partial sequence	blastn	77726	1158	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Stephanonympha	Stephanonympha nelumbium
8465881	8465881	PRJNA812715_P_NODE_29707_length_557_cov_7.332645_g27946_i0	PRJNA812715	29707	557	7.332645	40.84283265	Stephanonympha sp. NkStA1-6	983889	Parabasalia	other_Eukaryota	695	0	NTclustered	gi\|374428465\|dbj\|AB614013.1\|	983889	g27946	i0	89.35	11.7558348294434	554	57	99	2	1	553	323	875	Stephanonympha sp. NkStA1-6 gene for actin, partial cds, clone: NkStA1-6	blastn	6548	695	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Stephanonympha	Stephanonympha sp. NkStA1-6
8466433	8466433	PRJNA812715_P_NODE_47247_length_397_cov_2.675926_g45450_i0	PRJNA812715	47247	397	2.675926	10.62342622	Caduceia versatilis	402894	Parabasalia	other_Eukaryota	394	5.48e-105	NTclustered	gi\|385861550\|dbj\|AB468084.1\|	402894	g45450	i0	84.733	52.5113350125945	393	60	99	0	5	397	876	484	Caduceia versatilis mRNA for actin, partial cds, clone: CcCA4	blastn	20847	394	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Caduceia	Caduceia versatilis
9740623	9740623	PRJNA812715_P_NODE_19348_length_779_cov_5.798867_g17773_i0	PRJNA812715	19348	779	5.798867	45.17317393	Foaina nana	561876	Parabasalia	other_Eukaryota	1029	0	NTclustered	gi\|374428481\|dbj\|AB614021.1\|	561876	g17773	i0	90.605	95.5596919127086	777	72	99	1	3	778	101	877	Foaina nana gene for actin, partial cds, clone: CdFA11	blastn	74441	1029	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
9741657	9741657	PRJNA812715_P_NODE_50828_length_378_cov_1.918033_g49030_i0	PRJNA812715	50828	378	1.918033	7.25016474	Foaina nana	561876	Parabasalia	other_Eukaryota	322	2.49e-83	NTclustered	gi\|374428479\|dbj\|AB614020.1\|	561876	g49030	i0	83.776	0.896825396825397	339	55	90	0	37	375	421	759	Foaina nana gene for actin, partial cds, clone: CdFA3	blastn	339	322	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
11018678	11018678	PRJNA812715_P_NODE_94549_length_261_cov_2.047872_g92748_i0	PRJNA812715	94549	261	2.047872	5.34494592	Stephanonympha sp. NkStA1-3	570464	Parabasalia	other_Eukaryota	283	7.749999999999999e-72	NTclustered	gi\|385861546\|dbj\|AB468082.1\|	570464	g92748	i0	86.207	13.0153256704981	261	36	100	0	1	261	817	557	Stephanonympha sp. NkStA1-3 mRNA for actin, partial cds, clone: NkStA1-3	blastn	3397	283	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Stephanonympha	Stephanonympha sp. NkStA1-3
12291124	12291124	PRJNA812715_P_NODE_108490_length_248_cov_0.880000_g106689_i0	PRJNA812715	108490	248	0.88	2.1824	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	209	1.26e-49	NTclustered	gi\|2794954618\|ref\|XM_067872953.1\|	2049356	g106689	i0	82.258	64.0201612903226	248	38	99	6	4	248	423	179	Monocercomonoides exilis conventional actin (MONOS_2989), mRNA	blastn	15877	209	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
12291311	12291311	PRJNA812715_P_NODE_115690_length_244_cov_0.900585_g113889_i0	PRJNA812715	115690	244	0.900585	2.1974274	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	76.8	1.31e-9	NTclustered	gi\|2794977061\|ref\|XM_067879212.1\|	2049356	g113889	i0	100	0.422131147540984	41	0	17	0	6	46	14274	14314	Monocercomonoides exilis putative Dual specificity phosphatase, catalytic domain (MONOS_8775), partial mRNA	blastn	103	76.8	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis
13566298	13566298	PRJNA812715_P_NODE_23471_length_670_cov_6.912898_g21782_i0	PRJNA812715	23471	670	6.912898	46.3164166	Stephanonympha sp. NkStA1-6	983889	Parabasalia	other_Eukaryota	813	0	NTclustered	gi\|374428465\|dbj\|AB614013.1\|	983889	g21782	i0	88.657	19.1194029850746	670	73	99	3	2	669	206	874	Stephanonympha sp. NkStA1-6 gene for actin, partial cds, clone: NkStA1-6	blastn	12810	813	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Stephanonympha	Stephanonympha sp. NkStA1-6
14840861	14840861	PRJNA812715_P_NODE_25412_length_630_cov_4.587074_g23695_i0	PRJNA812715	25412	630	4.587074	28.8985662	Foaina nana	561876	Parabasalia	other_Eukaryota	765	0	NTclustered	gi\|385861554\|dbj\|AB468086.1\|	561876	g23695	i0	88.571	8.17936507936508	630	72	100	0	1	630	212	841	Foaina nana mRNA for actin, partial cds, clone: CdFA6	blastn	5153	765	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
16116420	16116420	PRJNA812715_P_NODE_60313_length_338_cov_0.871698_g58514_i0	PRJNA812715	60313	338	0.871698	2.94633924	Foaina nana	561876	Parabasalia	other_Eukaryota	298	3.71e-76	NTclustered	gi\|374428479\|dbj\|AB614020.1\|	561876	g58514	i0	82.544	2.0887573964497	338	59	100	0	1	338	847	510	Foaina nana gene for actin, partial cds, clone: CdFA3	blastn	706	298	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
17390998	17390998	PRJNA812715_P_NODE_22174_length_702_cov_3.321145_g20504_i0	PRJNA812715	22174	702	3.321145	23.3144379	Histomonas meleagridis	135588	Parabasalia	other_Eukaryota	56.5	0.005	NTclustered	gi\|2794867511\|ref\|XM_067917056.1\|	135588	g20504	i0	88	0.0712250712250712	50	3	7	2	520	566	574	623	Histomonas meleagridis C2 domain containing protein (GO595_003976), partial mRNA	blastn	50	56.5	1	Eukaryota	Metamonada	Parabasalia	Tritrichomonadida	Dientamoebidae	Histomonas	Histomonas meleagridis
17391733	17391733	PRJNA812715_P_NODE_43434_length_421_cov_3.287356_g41639_i0	PRJNA812715	43434	421	3.287356	13.83976876	Foaina nana	561876	Parabasalia	other_Eukaryota	586	8.989999999999997e-163	NTclustered	gi\|385861554\|dbj\|AB468086.1\|	561876	g41639	i0	92.067	15.6318289786223	416	33	99	0	1	416	44	459	Foaina nana mRNA for actin, partial cds, clone: CdFA6	blastn	6581	586	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
18664178	18664178	PRJNA812715_P_NODE_23615_length_667_cov_3.363636_g21919_i0	PRJNA812715	23615	667	3.363636	22.43545212	Daimonympha friedkini	3043608	Parabasalia	other_Eukaryota	501	5.49e-137	NTclustered	gi\|2497635472\|gb\|OQ883699.1\|	3043608	g21919	i0	95.82	57.3553223388306	311	12	56	1	296	606	633	324	Parabasalia sp. MTrznadel-2023e clone 2 small subunit ribosomal RNA gene, partial sequence	blastn	38256	501	1	Eukaryota	Metamonada	Parabasalia	Lophomonadida		Daimonympha	Daimonympha friedkini
21215581	21215581	PRJNA812715_P_NODE_45537_length_407_cov_2.479042_g43741_i0	PRJNA812715	45537	407	2.479042	10.08970094	Foaina nana	561876	Parabasalia	other_Eukaryota	536	8.849999999999999e-148	NTclustered	gi\|374428481\|dbj\|AB614021.1\|	561876	g43741	i0	90.594	96.2088452088452	404	38	99	0	2	405	840	437	Foaina nana gene for actin, partial cds, clone: CdFA11	blastn	39157	536	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Foaina	Foaina nana
21215975	21215975	PRJNA812715_P_NODE_58597_length_344_cov_1.206642_g56798_i0	PRJNA812715	58597	344	1.206642	4.15084848	Stephanonympha nelumbium	402892	Parabasalia	other_Eukaryota	303	8.14e-78	NTclustered	gi\|115293045\|gb\|DQ855404.1\|	402892	g56798	i0	98.824	46.8837209302326	170	2	49	0	1	170	179	10	Stephanonympha nelumbium clone 2 small subunit ribosomal RNA gene, partial sequence	blastn	16128	303	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Stephanonympha	Stephanonympha nelumbium
22490776	22490776	PRJNA812715_P_NODE_63178_length_327_cov_1.685039_g61379_i0	PRJNA812715	63178	327	1.685039	5.51007753	Stephanonympha sp. Nk3	336694	Parabasalia	other_Eukaryota	329	1.2699999999999998e-85	NTclustered	gi\|128168634\|dbj\|AB221059.1\|	336694	g61379	i0	85.139	2.1131498470948	323	46	98	2	1	322	540	861	Stephanonympha sp. Nk3 eno1 mRNA for enolase, partial cds	blastn	691	329	1	Eukaryota	Metamonada	Parabasalia	Cristamonadida		Stephanonympha	Stephanonympha sp. Nk3
23766058	23766058	PRJNA812715_P_NODE_50019_length_382_cov_2.268608_g48222_i0	PRJNA812715	50019	382	2.268608	8.66608256	Monocercomonoides exilis	2049356	Preaxostyla	other_Eukaryota	67.6	1.3e-6	NTclustered	gi\|2794958030\|ref\|XM_067876128.1\|	2049356	g48222	i0	97.436	1.83507853403141	39	1	10	0	19	57	1463	1425	Monocercomonoides exilis uncharacterized protein (MONOS_5936), partial mRNA	blastn	701	67.6	1	Eukaryota	Metamonada	Preaxostyla	Oxymonadida	Polymastigidae	Monocercomonoides	Monocercomonoides exilis

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