metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA565584" 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
3107842	3107842	PRJNA565584_P_NODE_43683_length_452_cov_2.153034_g42532_i0	PRJNA565584	43683	452	2.153034	9.73171368	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	556	7.61e-154	NTclustered	gi\|423291976\|gb\|JQ519433.1\|	5778	g42532	i0	88.914	99.9800884955752	451	50	99	0	2	452	592	142	Vermamoeba vermiformis clone JG10.93_b2 actin gene, partial cds	blastn	45191	556	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
6934713	6934713	PRJNA565584_P_NODE_27646_length_587_cov_0.838521_g26505_i0	PRJNA565584	27646	587	0.838521	4.92211827	Polychaos sp. OK-2023a	3107887	Tubulinea	other_Eukaryota	697	0	NTclustered	gi\|2634048133\|gb\|OR947210.1\|	3107887	g26505	i0	88.127	51.2350936967632	598	56	100	11	1	587	1401	1994	Polychaos sp. OK-2023a small subunit ribosomal RNA gene, partial sequence	blastn	30075	697	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Polychaos	Polychaos sp. OK-2023a
6935376	6935376	PRJNA565584_P_NODE_5906_length_1409_cov_2.776946_g5286_i0	PRJNA565584	5906	1409	2.776946	39.12716914	Copromyxa protea	931554	Tubulinea	other_Eukaryota	1133	0	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g5286	i0	81.792	6.31156848828957	1384	222	97	22	1	1360	8	1385	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	8893	1133	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
7512879	7512879	PRJNA565584_P_NODE_43346_length_454_cov_1.763780_g42195_i0	PRJNA565584	43346	454	1.76378	8.0075612	Saccamoeba	136463	Tubulinea	other_Eukaryota	833	0	NTclustered	gi\|399764206\|gb\|JQ271717.1\|	1215623	g42195	i0	99.78	95.0022026431718	454	1	100	0	1	454	1647	1194	Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence	blastn	43131	833	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba sp. DP7
9485024	9485024	PRJNA565584_P_NODE_30368_length_555_cov_1.242739_g29220_i0	PRJNA565584	30368	555	1.242739	6.89720145	Copromyxa protea	931554	Tubulinea	other_Eukaryota	348	6.22e-91	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g29220	i0	78.333	3.02882882882883	540	115	97	2	17	555	1	539	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	1681	348	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
10761591	10761591	PRJNA565584_P_NODE_58429_length_389_cov_1.167722_g57278_i0	PRJNA565584	58429	389	1.167722	4.54243858	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	318	3.32e-82	NTclustered	gi\|421976355\|gb\|JQ519494.1\|	5778	g57278	i0	92.727	81.3598971722365	220	16	57	0	170	389	794	575	Vermamoeba vermiformis clone JG10.150_g4 elongation factor 2 alpha gene, partial cds	blastn	31649	318	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
13309912	13309912	PRJNA565584_P_NODE_189591_length_246_cov_1.780347_g188439_i0	PRJNA565584	189591	246	1.780347	4.37965362	Netzelia tuberculata	1260112	Tubulinea	other_Eukaryota	143	1.28e-29	NTclustered	gi\|421976361\|gb\|JQ519497.1\|	1260112	g188439	i0	77.922	1.9390243902439	231	47	93	4	18	246	1	229	Netzelia tuberculata clone JG11.58_a3 elongation factor 2 alpha gene, partial cds	blastn	477	143	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Netzeliidae	Netzelia	Netzelia tuberculata
13311035	13311035	PRJNA565584_P_NODE_47431_length_433_cov_1.261111_g46280_i0	PRJNA565584	47431	433	1.261111	5.46061063	Copromyxa laresi	1789826	Tubulinea	other_Eukaryota	551	3.379999999999999e-152	NTclustered	gi\|1042160931\|dbj\|LC102272.1\|	1789826	g46280	i0	89.607	96.7090069284065	433	45	100	0	1	433	20	452	Copromyxa sp. MK-2016 gene for actin, partial cds, strain: ZEB1_cl1	blastn	41875	551	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa laresi
13311807	13311807	PRJNA565584_P_NODE_87851_length_317_cov_1.315574_g86699_i0	PRJNA565584	87851	317	1.315574	4.17036958	Copromyxa protea	931554	Tubulinea	other_Eukaryota	364	3.3599999999999985e-96	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g86699	i0	87.382	33.9526813880126	317	40	100	0	1	317	362	46	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	10763	364	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
14585200	14585200	PRJNA565584_P_NODE_219292_length_233_cov_3.362500_g218140_i0	PRJNA565584	219292	233	3.3625	7.834625	Saccamoeba limax	136464	Tubulinea	other_Eukaryota	154	5.56e-33	NTclustered	gi\|213950421\|gb\|EU869301.1\|	136464	g218140	i0	82.759	9.66094420600858	174	29	74	1	61	233	1613	1786	Saccamoeba limax strain NTSHR small subunit ribosomal RNA gene, partial sequence	blastn	2251	154	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba limax
14585696	14585696	PRJNA565584_P_NODE_40472_length_471_cov_2.919598_g39321_i0	PRJNA565584	40472	471	2.919598	13.75130658	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	560	6.15e-155	NTclustered	gi\|423291978\|gb\|JQ519434.1\|	5778	g39321	i0	88.553	98.1464968152866	463	51	98	2	9	470	32	493	Vermamoeba vermiformis clone JG10.93_e2 actin gene, partial cds	blastn	46227	560	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
14586478	14586478	PRJNA565584_P_NODE_80792_length_331_cov_1.108527_g79641_i0	PRJNA565584	80792	331	1.108527	3.66922437	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	405	2.08e-108	NTclustered	gi\|62910949\|gb\|AY925001.1\|	5778	g79641	i0	95.294	0.897280966767372	255	12	77	0	1	255	255	1	Hartmannella vermiformis Rpl7A mRNA, partial cds	blastn	297	405	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
17133145	17133145	PRJNA565584_P_NODE_162854_length_254_cov_1.071823_g161702_i0	PRJNA565584	162854	254	1.071823	2.72243042	Glaeseria mira	242547	Tubulinea	other_Eukaryota	375	1.2e-99	NTclustered	gi\|33946352\|gb\|AY294155.1\|	242547	g161702	i0	93.307	98.3937007874016	254	17	100	0	1	254	502	755	Glaeseria mira actin mRNA, partial cds	blastn	24992	375	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Glaeseria	Glaeseria mira
17134579	17134579	PRJNA565584_P_NODE_43674_length_452_cov_2.279683_g42523_i0	PRJNA565584	43674	452	2.279683	10.30416716	Copromyxa protea	931554	Tubulinea	other_Eukaryota	407	8.109999999999999e-109	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g42523	i0	83.962	20.5132743362832	424	68	94	0	2	425	424	1	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	9272	407	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
17711729	17711729	PRJNA565584_P_NODE_119734_length_282_cov_1.301435_g118582_i0	PRJNA565584	119734	282	1.301435	3.6700467	Elardia	2681632	Tubulinea	other_Eukaryota	244	4e-60	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g118582	i0	82.456	67.4503546099291	285	44	100	6	1	282	852	571	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	19021	244	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
18409629	18409629	PRJNA565584_P_NODE_83755_length_325_cov_1.154762_g82603_i0	PRJNA565584	83755	325	1.154762	3.7529765	uncultured Lobosea	282480	Tubulinea	other_Eukaryota	270	7.74e-68	NTclustered	gi\|49356809\|gb\|AY605213.1\|	282480	g82603	i0	87.137	45.0738461538462	241	27	74	3	1	240	668	905	Uncultured Lobosea clone Sey078 small subunit ribosomal RNA gene, partial sequence	blastn	14649	270	1	Eukaryota	Amoebozoa	Tubulinea					uncultured Lobosea
18985658	18985658	PRJNA565584_P_NODE_175075_length_249_cov_3.125000_g173923_i0	PRJNA565584	175075	249	3.125	7.78125	Vermamoeba	1260114	Tubulinea	other_Eukaryota	460	3.16e-125	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g173923	i0	100	47.7791164658635	249	0	100	0	1	249	5484	5236	Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	11897	460	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
20960015	20960015	PRJNA565584_P_NODE_9117_length_1125_cov_28.421103_g8242_i0	PRJNA565584	9117	1125	28.421103	319.73740875	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	944	0	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g8242	i0	81.89	91.6231111111111	1132	193	100	11	1	1125	1137	11	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	103076	944	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
22232975	22232975	PRJNA565584_P_NODE_188178_length_247_cov_0.885057_g187026_i0	PRJNA565584	188178	247	0.885057	2.18609079	Cryptodifflugia operculata	1078836	Tubulinea	other_Eukaryota	99	2.83e-16	NTclustered	gi\|345452568\|gb\|JF694302.1\|	1078836	g187026	i0	89.744	1.69230769230769	78	7	31	1	153	229	44	121	Cryptodifflugia operculata clone 6 actin gene, partial cds	blastn	418	99	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Arcellinida	Cryptodifflugiidae	Cryptodifflugia	Cryptodifflugia operculata
22234923	22234923	PRJNA565584_P_NODE_9118_length_1125_cov_15.470532_g8242_i1	PRJNA565584	9118	1125	15.470532	174.043485	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	928	0	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g8242	i1	81.625	94.1626666666667	1132	196	100	11	1	1125	11	1137	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	105933	928	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
22234971	22234971	PRJNA565584_P_NODE_9278_length_1115_cov_22.386756_g8242_i2	PRJNA565584	9278	1115	22.386756	249.6123294	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	933	0	NTclustered	gi\|33946358\|gb\|AY294158.1\|	239731	g8242	i2	81.859	93.952466367713	1119	193	99	10	1	1114	1137	24	Hartmannella cantabrigiensis actin mRNA, complete cds	blastn	104757	933	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
24783212	24783212	PRJNA565584_P_NODE_47220_length_434_cov_1.121884_g46069_i0	PRJNA565584	47220	434	1.121884	4.86897656	Copromyxa protea	931554	Tubulinea	other_Eukaryota	375	2.19e-99	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g46069	i0	82.979	8.57834101382488	423	64	97	6	9	427	419	1	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	3723	375	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);;