metadata: contig_metadata: 29 rows where bioproject = "PRJNA737474" and tax

29 rows where bioproject = "PRJNA737474" and tax_phylum = "Tubulinea"

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_class	tax_order	tax_family	tax_genus	tax_species
25576911	25576911	PRJNA737474f_S_NODE_125897_length_277_cov_1.887255_g125219_i0	PRJNA737474	125897	277	1.887255	5.22769635	Copromyxa sp. PKD 2	3118317	Tubulinea	other_Eukaryota	507	4.53e-139	NTclustered	gi\|399764168\|gb\|JQ271679.1\|	1215977	g125219	i0	99.639	71.4223826714802	277	1	100	0	1	277	373	97	Copromyxa sp. PKD 2011 strain ZEB4 18S ribosomal RNA gene, partial sequence	blastn	19784	507	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa sp. PKD 2011
25579785	25579785	PRJNA737474f_S_NODE_32497_length_385_cov_3.362179_g31819_i0	PRJNA737474	32497	385	3.362179	12.94438915	Copromyxa sp. PKD 2	3118317	Tubulinea	other_Eukaryota	704	0	NTclustered	gi\|399764167\|gb\|JQ271678.1\|	1215977	g31819	i0	99.74	71.0285714285714	384	1	99	0	2	385	988	605	Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence	blastn	27346	704	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa sp. PKD 2011
25581980	25581980	PRJNA737474g_S_NODE_10129_length_1225_cov_11.802083_g9223_i0	PRJNA737474	10129	1225	11.802083	144.57551675	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1197	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g9223	i0	86.523	15.6424489795918	1113	120	89	21	1	1089	283	1389	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	19162	1197	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
25717476	25717476	PRJNA737474f_S_NODE_7786_length_739_cov_5.429429_g7195_i0	PRJNA737474	7786	739	5.429429	40.12348031	Amoeba proteus	5775	Tubulinea	other_Eukaryota	349	8.73e-117	NR	AAP88974.1	5775	g7195	i0	85.8	0.799729364005413	197	28	80	0	3	593	194	390	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	591	349	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
25723666	25723666	PRJNA737474g_S_NODE_401466_length_244_cov_0.888889_g400172_i0	PRJNA737474	401466	244	0.888889	2.16888916	Copromyxa protea	931554	Tubulinea	other_Eukaryota	285	1.99e-72	NTclustered	gi\|1042160949\|dbj\|LC102281.1\|	931554	g400172	i0	87.755	8.68852459016393	245	28	100	2	1	244	719	476	Copromyxa protea gene for elongation factor 2 alpha, partial cds, strain: LUM	blastn	2120	285	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
25726457	25726457	PRJNA737474g_S_NODE_95906_length_331_cov_4.643411_g94612_i0	PRJNA737474	95906	331	4.643411	15.36969041	Copromyxa protea	931554	Tubulinea	other_Eukaryota	383	9.73e-102	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g94612	i0	89.667	18.7945619335347	300	31	91	0	32	331	1	300	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	6221	383	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
25859702	25859702	PRJNA737474g_S_NODE_406379_length_243_cov_1.641176_g405085_i0	PRJNA737474	406379	243	1.641176	3.98805768	Copromyxa sp. PKD 2	3118317	Tubulinea	other_Eukaryota	398	2.4399999999999997e-106	NTclustered	gi\|399764167\|gb\|JQ271678.1\|	1215977	g405085	i0	100	68.8847736625514	215	0	88	0	29	243	321	107	Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence	blastn	16739	398	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa sp. PKD 2011
25985414	25985414	PRJNA737474f_S_NODE_13508_length_548_cov_9.816842_g12843_i0	PRJNA737474	13508	548	9.816842	53.79629416	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	662	0	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g12843	i0	95.012	72.8485401459854	421	21	77	0	128	548	1148	728	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	39921	662	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
26128137	26128137	PRJNA737474g_S_NODE_172837_length_287_cov_1.518692_g171543_i0	PRJNA737474	172837	287	1.518692	4.35864604	Copromyxa sp. PKD 2	3118317	Tubulinea	other_Eukaryota	171	7.02e-38	NTclustered	gi\|399764167\|gb\|JQ271678.1\|	1215977	g171543	i0	94.545	25.418118466899	110	6	38	0	178	287	1876	1767	Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence	blastn	7295	171	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa sp. PKD 2011
26128355	26128355	PRJNA737474g_S_NODE_183205_length_283_cov_3.066667_g181911_i0	PRJNA737474	183205	283	3.066667	8.67866761	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	202	2.4499999999999998e-47	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g181911	i0	91.724	51.886925795053	145	12	51	0	139	283	1148	1004	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	14684	202	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
26128357	26128357	PRJNA737474g_S_NODE_183277_length_283_cov_2.319048_g181983_i0	PRJNA737474	183277	283	2.319048	6.56290584	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	193	1.47e-44	NTclustered	gi\|909719647\|gb\|KT185627.1\|	5778	g181983	i0	82.805	77.3180212014134	221	32	76	5	10	225	28119	27900	Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome	blastn	21881	193	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
26131546	26131546	PRJNA737474g_S_NODE_368821_length_246_cov_1.971098_g367527_i0	PRJNA737474	368821	246	1.971098	4.84890108	Amoeba proteus	5775	Tubulinea	other_Eukaryota	131	1.08e-36	NR	AAW58116.1	5775	g367527	i0	78.7	0.914634146341463	75	16	91.5	0	246	22	99	173	AAW58116.1 peroxiredoxin, partial [Amoeba proteus]	diamond	225	131	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
26132700	26132700	PRJNA737474g_S_NODE_465565_length_235_cov_3.925926_g464271_i0	PRJNA737474	465565	235	3.925926	9.2259261	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	206	1.53e-48	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g464271	i0	96.032	49.7574468085106	126	5	54	0	110	235	1151	1026	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	11693	206	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
26133604	26133604	PRJNA737474g_S_NODE_59525_length_385_cov_2.185897_g58232_i0	PRJNA737474	59525	385	2.185897	8.41570345	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	614	3.7399999999999996e-171	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g58232	i0	95.561	94.2051948051948	383	17	99	0	1	383	722	1104	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	36269	614	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
26259850	26259850	PRJNA737474f_S_NODE_2742_length_1479_cov_38.813656_g2386_i0	PRJNA737474	2742	1479	38.813656	574.05397224	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1574	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g2386	i0	87.365	25.3015551048005	1393	150	93	16	40	1410	1	1389	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	37421	1574	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
26260882	26260882	PRJNA737474f_S_NODE_44942_length_350_cov_5.292419_g44264_i0	PRJNA737474	44942	350	5.292419	18.5234665	Amoeba proteus	5775	Tubulinea	other_Eukaryota	182	3.7699999999999995e-56	NR	AAW58116.1	5775	g44264	i0	78.5	0.917142857142857	107	23	91.7	0	2	322	67	173	AAW58116.1 peroxiredoxin, partial [Amoeba proteus]	diamond	321	182	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
26530763	26530763	PRJNA737474f_S_NODE_190384_length_253_cov_1.511111_g189706_i0	PRJNA737474	190384	253	1.511111	3.82311083	Copromyxa sp. PKD 2	3118317	Tubulinea	other_Eukaryota	344	3.3799999999999993e-90	NTclustered	gi\|399764167\|gb\|JQ271678.1\|	1215977	g189706	i0	100	21.3359683794466	186	0	74	0	1	186	1460	1645	Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence	blastn	5398	344	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa sp. PKD 2011
26541662	26541662	PRJNA737474g_S_NODE_60384_length_383_cov_2.287097_g59091_i0	PRJNA737474	60384	383	2.287097	8.75958151	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	152	3.65e-43	NR	AAY21191.1	5778	g59091	i0	56.8	1.95822454308094	125	54	97.9	0	383	9	118	242	AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis]	diamond	750	152	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
26541705	26541705	PRJNA737474g_S_NODE_61256_length_381_cov_3.928571_g59963_i0	PRJNA737474	61256	381	3.928571	14.96785551	Amoeba proteus	5775	Tubulinea	other_Eukaryota	140	2.03e-37	NR	AAP88974.1	5775	g59963	i0	80.2	0.637795275590551	81	16	63.8	0	377	135	310	390	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	243	140	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32919906	32919906	PRJNA737474f_S_NODE_64545_length_320_cov_1.975709_g63867_i0	PRJNA737474	64545	320	1.975709	6.3222688	Amoeba proteus	5775	Tubulinea	other_Eukaryota	185	1.0499999999999999e-54	NR	AAD37351.1	5775	g63867	i0	80.8	0.975	104	20	97.5	0	320	9	90	193	AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus]	diamond	312	185	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32938188	32938188	PRJNA737474g_S_NODE_84793_length_343_cov_1.737037_g83499_i0	PRJNA737474	84793	343	1.737037	5.95803691	Amoeba proteus	5775	Tubulinea	other_Eukaryota	105	5.72e-25	NR	BAF75060.1	5775	g83499	i0	73	0.551020408163265	63	17	55.1	0	4	192	225	287	BAF75060.1 aquaporin [Amoeba proteus]	diamond	189	105	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
32976100	32976100	PRJNA737474g_S_NODE_119394_length_313_cov_1.225000_g118100_i0	PRJNA737474	119394	313	1.225	3.83425	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.9	3.8e-6	NR	ABD72526.1	5778	g118100	i0	35.5	3.64217252396166	107	60	95.8	4	311	12	25	129	ABD72526.1 cudA-like protein D, partial [Vermamoeba vermiformis]	diamond	1140	53.9	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
32988342	32988342	PRJNA737474f_S_NODE_55267_length_332_cov_2.007722_g54589_i0	PRJNA737474	55267	332	2.007722	6.66563704	Copromyxa protea	931554	Tubulinea	other_Eukaryota	65.5	1.02e-9	NR	AOW71834.1	931554	g54589	i0	56.3	0.641566265060241	71	30	63.3	1	332	123	340	410	AOW71834.1 bacterial recombinase A, partial [Copromyxa protea]	diamond	213	65.5	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
33005575	33005575	PRJNA737474g_S_NODE_143803_length_299_cov_2.504425_g142509_i0	PRJNA737474	143803	299	2.504425	7.48823075	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	45.4	0.00669	NR	AAY21191.1	5778	g142509	i0	38.9	1.63545150501672	54	33	54.2	0	4	165	189	242	AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis]	diamond	489	45.4	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
33022092	33022092	PRJNA737474f_S_NODE_17140_length_489_cov_2.995192_g16467_i0	PRJNA737474	17140	489	2.995192	14.64648888	Amoeba proteus	5775	Tubulinea	other_Eukaryota	101	1.84e-22	NR	BAF75060.1	5775	g16467	i0	73.3	0.368098159509202	60	16	36.8	0	480	301	228	287	BAF75060.1 aquaporin [Amoeba proteus]	diamond	180	101	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
33022417	33022417	PRJNA737474f_S_NODE_43612_length_353_cov_2.775000_g42934_i0	PRJNA737474	43612	353	2.775	9.79575	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	77	2.86e-14	NR	AAY21191.1	5778	g42934	i0	48.7	1.2917847025495801	76	39	64.6	0	3	230	167	242	AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis]	diamond	456	77	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
33022473	33022473	PRJNA737474f_S_NODE_56036_length_331_cov_1.612403_g55358_i0	PRJNA737474	56036	331	1.612403	5.33705393	Amoeba proteus	5775	Tubulinea	other_Eukaryota	163	1.93e-47	NR	AKN09689.1	5775	g55358	i0	70.6	0.987915407854985	109	32	98.8	0	327	1	113	221	AKN09689.1 Tom20 [Amoeba proteus]	diamond	327	163	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
33124446	33124446	PRJNA737474f_S_NODE_20983_length_448_cov_5.576000_g20306_i0	PRJNA737474	20983	448	5.576	24.98048	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	123	1.5e-31	NR	AAY21191.1	5778	g20306	i0	55.9	1.36607142857143	102	45	68.3	0	446	141	141	242	AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis]	diamond	612	123	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
33176621	33176621	PRJNA737474g_S_NODE_233784_length_268_cov_1.041026_g232490_i0	PRJNA737474	233784	268	1.041026	2.78994968	Copromyxa protea	931554	Tubulinea	other_Eukaryota	57.8	2.5e-7	NR	AOW71834.1	931554	g232490	i0	56.1	0.738805970149254	66	28	72.8	1	219	25	345	410	AOW71834.1 bacterial recombinase A, partial [Copromyxa protea]	diamond	198	57.8	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea

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