metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA743294" 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
722192	722192	PRJNA743294_P_NODE_57221_length_239_cov_3.192771_g56765_i0	PRJNA743294	57221	239	3.192771	7.63072269	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	333	6.849999999999999e-87	NTclustered	gi\|62766450\|gb\|AY924415.1\|	5778	g56765	i0	92.641	3.64853556485356	231	17	97	0	9	239	32	262	Hartmannella vermiformis glycosyl hydrolase mRNA, partial cds	blastn	872	333	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
3273617	3273617	PRJNA743294_P_NODE_9463_length_512_cov_4.715262_g9007_i0	PRJNA743294	9463	512	4.715262	24.14214144	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	708	0	NTclustered	gi\|62910949\|gb\|AY925001.1\|	5778	g9007	i0	96.495	1.90234375	428	15	84	0	85	512	1	428	Hartmannella vermiformis Rpl7A mRNA, partial cds	blastn	974	708	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
4550518	4550518	PRJNA743294_P_NODE_29564_length_306_cov_1.120172_g29108_i0	PRJNA743294	29564	306	1.120172	3.42772632	Copromyxa flindersi	3050410	Tubulinea	other_Eukaryota	555	1.7799999999999996e-153	NTclustered	gi\|2513086415\|gb\|OR081327.1\|	3050410	g29108	i0	99.346	54.875816993464	306	2	100	0	1	306	1525	1220	Copromyxa flindersi strain KI4.1.H5.3 small subunit ribosomal RNA gene, partial sequence	blastn	16792	555	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa flindersi
7100761	7100761	PRJNA743294_P_NODE_35366_length_283_cov_2.114286_g34910_i0	PRJNA743294	35366	283	2.114286	5.98342938	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	329	1.0799999999999998e-85	NTclustered	gi\|88601161\|gb\|DQ384328.1\|	5778	g34910	i0	87.633	4	283	35	100	0	1	283	253	535	Hartmannella vermiformis glycosyl hydrolase A mRNA, partial cds	blastn	1132	329	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
8375357	8375357	PRJNA743294_P_NODE_32727_length_292_cov_2.986301_g32271_i0	PRJNA743294	32727	292	2.986301	8.71999892	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	429	1.07e-115	NTclustered	gi\|146335208\|gb\|EF216680.1\|	5778	g32271	i0	93.993	0.969178082191781	283	17	97	0	10	292	276	558	Hartmannella vermiformis transketolase mRNA, complete cds	blastn	283	429	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
8375578	8375578	PRJNA743294_P_NODE_6527_length_609_cov_1.494403_g6076_i0	PRJNA743294	6527	609	1.494403	9.10091427	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	590	1.0299999999999997e-163	NTclustered	gi\|61968704\|gb\|AY803784.1\|	5778	g6076	i0	94.892	6.76518883415435	372	19	61	0	29	400	372	1	Hartmannella vermiformis vacuolar protein sorting protein 26 (vps26) gene, partial cds	blastn	4120	590	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
9650403	9650403	PRJNA743294_P_NODE_21488_length_352_cov_1.326165_g21032_i0	PRJNA743294	21488	352	1.326165	4.6681008	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	272	2.35e-68	NTclustered	gi\|327179545\|gb\|HM104303.1\|	5778	g21032	i0	88.158	0.786931818181818	228	27	65	0	107	334	1080	1307	Hartmannella vermiformis isolate CDC-19 glucosamine-6-phosphate isomerase (GPI) gene, partial cds	blastn	277	272	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
9650700	9650700	PRJNA743294_P_NODE_7088_length_587_cov_1.042802_g6636_i0	PRJNA743294	7088	587	1.042802	6.12124774	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	721	0	NTclustered	gi\|89148143\|gb\|DQ388525.1\|	5778	g6636	i0	88.889	0.996592844974446	585	65	99	0	3	587	2602	3186	Hartmannella vermiformis mitochondrial single-subunit RNA polymerase (mtRNAP) gene, complete cds; nuclear gene for mitochondrial product	blastn	585	721	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
10926112	10926112	PRJNA743294_P_NODE_49689_length_249_cov_0.886364_g49233_i0	PRJNA743294	49689	249	0.886364	2.20704636	Copromyxa protea	931554	Tubulinea	other_Eukaryota	209	1.26e-49	NTclustered	gi\|1042160949\|dbj\|LC102281.1\|	931554	g49233	i0	87.097	86.1606425702811	186	22	74	2	65	249	731	547	Copromyxa protea gene for elongation factor 2 alpha, partial cds, strain: LUM	blastn	21454	209	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
13475773	13475773	PRJNA743294_P_NODE_17811_length_382_cov_4.009709_g17355_i0	PRJNA743294	17811	382	4.009709	15.31708838	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	538	2.2899999999999998e-148	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g17355	i0	92.188	67.3743455497382	384	24	100	3	1	382	20545	20166	Hartmannella vermiformis mitochondrion, complete genome	blastn	25737	538	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
13476003	13476003	PRJNA743294_P_NODE_47491_length_251_cov_12.674157_g47035_i0	PRJNA743294	47491	251	12.674157	31.81213407	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	416	6.999999999999998e-112	NTclustered	gi\|62910949\|gb\|AY925001.1\|	5778	g47035	i0	96.787	4.49402390438247	249	8	99	0	1	249	746	498	Hartmannella vermiformis Rpl7A mRNA, partial cds	blastn	1128	416	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
16024450	16024450	PRJNA743294_P_NODE_12433_length_451_cov_58.997354_g11977_i0	PRJNA743294	12433	451	58.997354	266.07806654	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	784	0	NTclustered	gi\|300078496\|gb\|GU001158.1\|	5778	g11977	i0	98.004	24.0487804878049	451	9	100	0	1	451	1660	1210	Hartmannella vermiformis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	10846	784	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
16024624	16024624	PRJNA743294_P_NODE_33293_length_290_cov_2.465438_g32837_i0	PRJNA743294	33293	290	2.465438	7.1497702	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	381	3.0199999999999987e-101	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g32837	i0	90.378	1.00344827586207	291	26	99	2	2	290	938	648	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	291	381	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
17300211	17300211	PRJNA743294_P_NODE_36014_length_281_cov_1.644231_g35558_i0	PRJNA743294	36014	281	1.644231	4.62028911	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	176	1.47e-39	NTclustered	gi\|33304360\|gb\|AY293972.1\|	239731	g35558	i0	93.966	3.23131672597865	116	7	80	0	164	279	1797	1912	Hartmannella cantabrigiensis clone 15 dihydrofolate reductase (DHFR) gene, complete cds; and thymidylate synthase (TS) gene, partial cds	blastn	908	176	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
17300410	17300410	PRJNA743294_P_NODE_914_length_1358_cov_2.765759_g750_i0	PRJNA743294	914	1358	2.765759	37.55900722	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	1629	0	NTclustered	gi\|66270666\|gb\|AY950658.1\|	5778	g750	i0	92.806	1.18114874815906	1126	79	83	1	223	1346	1128	3	Hartmannella vermiformis Nop58p mRNA, partial cds	blastn	1604	1629	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
18573607	18573607	PRJNA743294_P_NODE_13215_length_439_cov_3.122951_g12759_i0	PRJNA743294	13215	439	3.122951	13.70975489	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	475	2.1199999999999998e-129	NTclustered	gi\|88601207\|gb\|DQ384272.1\|	5778	g12759	i0	92.705	0.876993166287016	329	24	75	0	111	439	357	29	Hartmannella vermiformis unknown mRNA	blastn	385	475	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
18573702	18573702	PRJNA743294_P_NODE_24275_length_333_cov_6.573077_g23819_i0	PRJNA743294	24275	333	6.573077	21.88834641	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	494	4.34e-135	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g23819	i0	93.413	109.966966966967	334	21	100	1	1	333	28267	27934	Hartmannella vermiformis mitochondrion, complete genome	blastn	36619	494	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
18573740	18573740	PRJNA743294_P_NODE_3035_length_857_cov_14.468112_g2677_i0	PRJNA743294	3035	857	14.468112	123.99171984	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	1245	0	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g2677	i0	92.816	10.730455075846	863	56	100	4	1	857	1063	201	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	9196	1245	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
18573813	18573813	PRJNA743294_P_NODE_40955_length_266_cov_1.616580_g40499_i0	PRJNA743294	40955	266	1.61658	4.3001028	Hartmannella cantabrigiensis	239731	Tubulinea	other_Eukaryota	233	8.089999999999999e-57	NTclustered	gi\|33304357\|gb\|AY293971.1\|	239731	g40499	i0	91.228	1.92857142857143	171	15	64	0	1	171	1900	2070	Hartmannella cantabrigiensis clone 5 dihydrofolate reductase (DHFR) gene, complete cds; and thymidylate synthase (TS) gene, partial cds	blastn	513	233	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Hartmannella	Hartmannella cantabrigiensis
18573917	18573917	PRJNA743294_P_NODE_555_length_1567_cov_7.174029_g434_i0	PRJNA743294	555	1567	7.174029	112.41703443	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	2163	0	NTclustered	gi\|146335208\|gb\|EF216680.1\|	5778	g434	i0	91.881	2.52265475430759	1552	120	99	6	19	1567	2088	540	Hartmannella vermiformis transketolase mRNA, complete cds	blastn	3953	2163	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
19848911	19848911	PRJNA743294_P_NODE_1476_length_1159_cov_3.985267_g1239_i0	PRJNA743294	1476	1159	3.985267	46.18924453	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	1439	0	NTclustered	gi\|423292048\|gb\|JQ519470.1\|	5778	g1239	i0	95.264	74.779119930975	908	43	78	0	247	1154	908	1	Vermamoeba vermiformis clone JG10.132_b5 alpha tubulin gene, partial cds	blastn	86669	1439	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
19848948	19848948	PRJNA743294_P_NODE_18656_length_374_cov_5.232558_g18200_i0	PRJNA743294	18656	374	5.232558	19.56976692	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	516	1.05e-141	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g18200	i0	95.639	51.7593582887701	321	14	86	0	1	321	27358	27038	Hartmannella vermiformis mitochondrion, complete genome	blastn	19358	516	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
21124438	21124438	PRJNA743294_P_NODE_117_length_2629_cov_8.457746_g84_i0	PRJNA743294	117	2629	8.457746	222.35414234	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	1240	0	NTclustered	gi\|421976355\|gb\|JQ519494.1\|	5778	g84	i0	94.836	64.7352605553442	794	41	30	0	464	1257	1	794	Vermamoeba vermiformis clone JG10.150_g4 elongation factor 2 alpha gene, partial cds	blastn	170189	1240	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
24948520	24948520	PRJNA743294_P_NODE_31240_length_298_cov_2.586667_g30784_i0	PRJNA743294	31240	298	2.586667	7.70826766	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	224	5.549999999999998e-54	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g30784	i0	81.034	2.60402684563758	290	48	96	7	12	298	25864	25579	Hartmannella vermiformis mitochondrion, complete genome	blastn	776	224	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis

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