metadata: contig_metadata: 18 rows where bioproject = "PRJNA546018" and tax

18 rows where bioproject = "PRJNA546018" and tax_clade = "Amoebozoa"

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
1119263	1119263	PRJNA546018_S_NODE_7821_length_633_cov_12.405594_g7515_i0	PRJNA546018	7821	633	12.405594	78.52741002	Vermamoeba	1260114	Tubulinea	other_Eukaryota	1066	0	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g7515	i0	98.2	62.4170616113744	611	9	96	2	24	633	5177	5786	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	39510	1072	0.994402985074627	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
1786777	1786777	PRJNA546018_S_NODE_55102_length_205_cov_2.840278_g54777_i0	PRJNA546018	55102	205	2.840278	5.8225699	Angulamoeba microcystivorans	1654978	Evosea	other_Eukaryota	239	1.28e-58	NTclustered	gi\|961557578\|gb\|KP719182.2\|	1654978	g54777	i0	90.27	15.6780487804878	185	15	89	3	1	183	1089	906	Angulamoeba microcystivorans strain A4WVB clone 2 small subunit ribosomal RNA gene, partial sequence	blastn	3214	239	1	Eukaryota	Amoebozoa	Evosea	Variosea			Angulamoeba	Angulamoeba microcystivorans
4338413	4338413	PRJNA546018_S_NODE_7604_length_643_cov_5.896907_g7301_i0	PRJNA546018	7604	643	5.896907	37.91711201	Squamamoeba japonica	1167875	Evosea	other_Eukaryota	265	7.539999999999999e-66	NTclustered	gi\|381423467\|gb\|JN638032.1\|	1167875	g7301	i0	83.746	36.4043545878694	283	42	44	4	140	419	1179	1460	Squamamoeba japonica strain CCAP 1593/1 clone 2224 18S ribosomal RNA gene, partial sequence	blastn	23408	265	1	Eukaryota	Amoebozoa	Evosea				Squamamoeba	Squamamoeba japonica
9438974	9438974	PRJNA546018_S_NODE_14328_length_440_cov_10.311346_g14003_i0	PRJNA546018	14328	440	10.311346	45.3699224	Cochliopodium kieliense	1512276	Discosea	other_Eukaryota	579	1.5799999999999993e-160	NTclustered	gi\|659103923\|gb\|KJ569725.1\|	1512276	g14003	i0	90.38	44.2363636363636	447	34	100	9	1	440	604	1048	Cochliopodium kieliense clone 9601 18S ribosomal RNA gene, partial sequence	blastn	19464	579	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium kieliense
13264966	13264966	PRJNA546018_S_NODE_41571_length_238_cov_4.225989_g41246_i0	PRJNA546018	41571	238	4.225989	10.05785382	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	429	8.45e-116	NTclustered	gi\|300078496\|gb\|GU001158.1\|	5778	g41246	i0	99.16	33.4033613445378	238	2	100	0	1	238	3677	3440	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	7950	429	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
15814248	15814248	PRJNA546018_S_NODE_7653_length_641_cov_8.181034_g7349_i0	PRJNA546018	7653	641	8.181034	52.44042794	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	254	1.63e-62	NTclustered	gi\|470424971\|ref\|XM_004337710.1\|	1257118	g7349	i0	79.275	53.4477379095164	386	63	58	12	20	392	2644	2263	Acanthamoeba castellanii str. Neff coatmer subunit, putative (ACA1_379260), partial mRNA	blastn	34260	254	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
19637461	19637461	PRJNA546018_S_NODE_51976_length_210_cov_1.617450_g51651_i0	PRJNA546018	51976	210	1.61745	3.396645	uncultured Amoebozoa	590481	Root_unresolved	Root_unresolved	335	1.6299999999999994e-87	NTclustered	gi\|221185864\|gb\|FJ577811.1\|	590481	g51651	i0	98.438	0.914285714285714	192	0	90	1	2	190	743	552	Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence	blastn	192	335	1	Eukaryota	Amoebozoa						uncultured Amoebozoa
19637651	19637651	PRJNA546018_S_NODE_8516_length_602_cov_8.238447_g8204_i0	PRJNA546018	8516	602	8.238447	49.59545094	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	207	1.1999999999999998e-48	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g8204	i0	83.945	68.6395348837209	218	34	36	1	69	285	28057	27840	Hartmannella vermiformis mitochondrion, complete genome	blastn	41321	207	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
23463409	23463409	PRJNA546018_S_NODE_44379_length_230_cov_1.153846_g44054_i0	PRJNA546018	44379	230	1.153846	2.6538458	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	211	3.2e-50	NTclustered	gi\|85062628\|gb\|DQ340386.1\|	5786	g44054	i0	88.571	48.1608695652174	175	18	76	2	1	174	8297	8124	Dictyostelium purpureum 17S ribosomal RNA, 5.8S ribosomal RNA, 26S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	11077	211	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
24736794	24736794	PRJNA546018_S_NODE_23620_length_329_cov_2.414179_g23295_i0	PRJNA546018	23620	329	2.414179	7.94264891	Cochliopodium minus	313997	Discosea	other_Eukaryota	501	2.56e-137	NTclustered	gi\|330902862\|gb\|JF298257.1\|	313997	g23295	i0	94.242	59.3768996960486	330	14	99	4	1	327	619	292	Cochliopodium minus 18S ribosomal RNA gene, partial sequence	blastn	19535	501	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minus
28436010	28436010	PRJNA546018_S_NODE_13586_length_455_cov_3.116751_g13262_i0	PRJNA546018	13586	455	3.116751	14.18121705	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	72.8	2.79e-13	NR	PRP78805.1	1890364	g13262	i0	59.3	0.389010989010989	59	23	38.9	1	418	242	1	58	PRP78805.1 hypothetical protein PROFUN_00978 [Planoprotostelium fungivorum]	diamond	177	72.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29540899	29540899	PRJNA546018_S_NODE_34770_length_263_cov_3.153465_g34445_i0	PRJNA546018	34770	263	3.153465	8.29361295	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	47.8	5.57e-4	NR	XP_004351187.1	261658	g34445	i0	36.6	1.6425855513308	71	37	81	2	22	234	148	210	XP_004351187.1 translocon-associated protein subunit beta [Cavenderia fasciculata]	diamond	432	47.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
30994245	30994245	PRJNA546018_S_NODE_52534_length_209_cov_2.013514_g52209_i0	PRJNA546018	52534	209	2.013514	4.20824426	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	83.2	1.34e-16	NR	PRP73456.1	1890364	g52209	i0	59.4	0.91866028708134	64	26	91.9	0	204	13	245	308	PRP73456.1 component of SCAR regulatory complex, partial [Planoprotostelium fungivorum]	diamond	192	83.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
31183485	31183485	PRJNA546018_S_NODE_58015_length_200_cov_3.223022_g57690_i0	PRJNA546018	58015	200	3.223022	6.446044	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	55.8	4.59e-8	NR	KAH3757450.1	1580589	g57690	i0	47.8	1.395	46	24	69	0	7	144	42	87	KAH3757450.1 hypothetical protein Pelo_10776 [Pelomyxa schiedti]	diamond	279	55.8	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
31657938	31657938	PRJNA546018_S_NODE_12777_length_472_cov_11.586375_g12453_i0	PRJNA546018	12777	472	11.586375	54.68769	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	113	1.15e-28	NR	XP_004356446.1	1257118	g12453	i0	67.1	0.444915254237288	70	23	44.5	0	225	434	72	141	XP_004356446.1 cytochrome-c oxidase [Acanthamoeba castellanii str. Neff]	diamond	210	113	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32638318	32638318	PRJNA546018_S_NODE_33640_length_268_cov_2.628019_g33315_i0	PRJNA546018	33640	268	2.628019	7.04309092	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	53.1	1.15e-5	NR	KYR03085.1	361077	g33315	i0	52.2	1.02985074626866	46	22	51.5	0	201	64	1194	1239	KYR03085.1 DOCK family protein [Tieghemostelium lacteum]	diamond	276	53.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
32827558	32827558	PRJNA546018_S_NODE_17180_length_396_cov_4.053731_g16855_i0	PRJNA546018	17180	396	4.053731	16.05277476	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	138	1.03e-39	NR	YP_003540819.1	5778	g16855	i0	84	1.13636363636364	75	12	56.8	0	171	395	7	81	YP_003540819.1 ribosomal protein S19 [Vermamoeba vermiformis]	diamond	450	138	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
32890347	32890347	PRJNA546018_S_NODE_4340_length_883_cov_17.532847_g4115_i0	PRJNA546018	4340	883	17.532847	154.81503901	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	134	2.31e-33	NR	PRP87951.1	1890364	g4115	i0	51.2	0.431483578708947	127	61	42.8	1	663	286	26	152	PRP87951.1 hypothetical protein PROFUN_02688 [Planoprotostelium fungivorum]	diamond	381	134	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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