metadata: contig_metadata: 9 rows where bioproject = "PRJNA436017", tax_clade = "Amoebozoa" and tax

9 rows where bioproject = "PRJNA436017", tax_clade = "Amoebozoa" 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
2364427	2364427	PRJNA436017_P_NODE_1242_length_843_cov_4.050868_g1059_i0	PRJNA436017	1242	843	4.050868	34.14881724	root	1	Root_unresolved	Root_unresolved	161	1.3499999999999999e-34	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g1059	i0	82.609	40.0166073546856	184	30	22	2	334	516	27349	27531	Hartmannella vermiformis mitochondrion, complete genome	blastn	33734	161	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
13184548	13184548	PRJNA436017_P_NODE_27311_length_156_cov_1.579832_g27013_i0	PRJNA436017	27311	156	1.579832	2.46453792	uncultured Rhizamoeba	1260765	Tubulinea	other_Eukaryota	141	2.67e-29	NTclustered	gi\|511487963\|gb\|JX898537.1\|	1260765	g27013	i0	93.684	6.91666666666667	95	5	61	1	1	95	283	376	Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence	blastn	1079	141	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae		uncultured Rhizamoeba
15733282	15733282	PRJNA436017_P_NODE_15393_length_211_cov_1.758621_g15095_i0	PRJNA436017	15393	211	1.758621	3.71069031	Spumochlamys bryora	675832	Tubulinea	other_Eukaryota	390	3.459999999999999e-104	NTclustered	gi\|259595677\|gb\|FJ705341.1\|	675832	g15095	i0	100	34.3507109004739	211	0	100	0	1	211	374	164	Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence	blastn	7248	390	1	Eukaryota	Amoebozoa	Tubulinea	Corycida		Microchlamyiidae	Spumochlamys	Spumochlamys bryora
17666697	17666697	PRJNA436017_P_NODE_27894_length_155_cov_0.932203_g27596_i0	PRJNA436017	27894	155	0.932203	1.44491465	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	287	3.21e-73	NTclustered	gi\|399764274\|gb\|JQ271785.1\|	1215994	g27596	i0	100	12.0709677419355	155	0	100	0	1	155	500	346	Tubulinea group 04 sp. BCHM5 18S ribosomal RNA gene, partial sequence	blastn	1871	287	1	Eukaryota	Amoebozoa	Tubulinea					Tubulinea group 04 sp. BCHM5
18282665	18282665	PRJNA436017_P_NODE_9655_length_279_cov_2.061983_g9357_i0	PRJNA436017	9655	279	2.061983	5.75293257	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	444	3.63e-120	NTclustered	gi\|292559443\|ref\|NC_013986.1\|	5778	g9357	i0	95.341	21.8853046594982	279	13	100	0	1	279	26264	26542	Hartmannella vermiformis mitochondrion, complete genome	blastn	6106	444	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
20215348	20215348	PRJNA436017_P_NODE_7976_length_313_cov_2.126812_g7679_i0	PRJNA436017	7976	313	2.126812	6.65692156	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	551	2.369999999999999e-152	NTclustered	gi\|300078496\|gb\|GU001158.1\|	5778	g7679	i0	98.403	76.6421725239617	313	5	100	0	1	313	922	1234	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	23989	551	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
20832375	20832375	PRJNA436017_P_NODE_17917_length_194_cov_0.980892_g17619_i0	PRJNA436017	17917	194	0.980892	1.90293048	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	311	2.5000000000000004e-80	NTclustered	gi\|909719647\|gb\|KT185627.1\|	5778	g17619	i0	95.408	28.0051546391753	196	7	100	1	1	194	26819	27014	Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome	blastn	5433	311	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
20832477	20832477	PRJNA436017_P_NODE_23197_length_169_cov_2.166667_g22899_i0	PRJNA436017	23197	169	2.166667	3.66166723	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	279	5.95e-71	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g22899	i0	96.45	1.92899408284024	169	6	100	0	1	169	7056	6888	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	326	279	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
24657208	24657208	PRJNA436017_P_NODE_27460_length_156_cov_1.151261_g27162_i0	PRJNA436017	27460	156	1.151261	1.79596716	Spumochlamys bryora	675832	Tubulinea	other_Eukaryota	261	1.96e-65	NTclustered	gi\|259595677\|gb\|FJ705341.1\|	675832	g27162	i0	96.795	67.4807692307692	156	5	100	0	1	156	1065	1220	Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence	blastn	10527	261	1	Eukaryota	Amoebozoa	Tubulinea	Corycida		Microchlamyiidae	Spumochlamys	Spumochlamys bryora

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