metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA193544" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA193544" 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
365846	365846	PRJNA193544_S_NODE_1061_length_246_cov_7.460829_g1046_i0	PRJNA193544	1061	246	7.460829	18.35363934	Amoebozoa sp. SZA19	1089205	Root_unresolved	Root_unresolved	370	5.399999999999999e-98	NTclustered	gi\|441475832\|emb\|FN562422.4\|	1089205	g1046	i0	95.671	44.4471544715447	231	8	93	2	17	246	634	405	Amoebozoa sp. SZA19 18S rRNA gene, isolate SZA19	blastn	10934	370	1	Eukaryota	Amoebozoa						Amoebozoa sp. SZA19
365892	365892	PRJNA193544_S_NODE_3141_length_157_cov_12.421875_g3126_i0	PRJNA193544	3141	157	12.421875	19.50234375	Vannella septentrionalis	197531	Discosea	other_Eukaryota	274	2.54e-69	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g3126	i0	98.089	43.2165605095541	157	3	100	0	1	157	866	1022	Vannella septentrionalis 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	6785	274	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis
1640697	1640697	PRJNA193544_S_NODE_722_length_283_cov_15.629921_g707_i0	PRJNA193544	722	283	15.629921	44.23267643	Tubulinea group 04 sp. CAL5	1215995	Tubulinea	other_Eukaryota	427	3.7099999999999998e-115	NTclustered	gi\|399764275\|gb\|JQ271786.1\|	1215995	g707	i0	93.993	13.6183745583039	283	15	100	2	1	283	458	178	Tubulinea group 04 sp. CAL5 18S ribosomal RNA gene, partial sequence	blastn	3854	427	1	Eukaryota	Amoebozoa	Tubulinea					Tubulinea group 04 sp. CAL5
2916530	2916530	PRJNA193544_S_NODE_1203_length_233_cov_3040.176471_g1188_i0	PRJNA193544	1203	233	3040.176471	7083.61117743	Vannella septentrionalis	197531	Discosea	other_Eukaryota	305	1.45e-78	NTclustered	gi\|300078499\|gb\|GU001161.1\|	197531	g1188	i0	96.721	11.9828326180258	183	6	79	0	1	183	2961	3143	Vannella septentrionalis 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	2792	305	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella septentrionalis
3605715	3605715	PRJNA193544_S_NODE_283_length_363_cov_1848.269461_g268_i0	PRJNA193544	283	363	1848.269461	6709.21814343	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	521	2.18e-143	NTclustered	gi\|407369299\|emb\|FN562423.1\|	688087	g268	i0	96.519	82.4187327823691	316	9	87	2	50	363	584	269	Amoebozoa sp. Pa24 partial 18S rRNA gene, isolate Pa24	blastn	29918	521	1	Eukaryota	Amoebozoa						Amoebozoa sp. Pa24
9983296	9983296	PRJNA193544_S_NODE_3448_length_151_cov_3.459016_g3433_i0	PRJNA193544	3448	151	3.459016	5.22311416	Vermamoeba	1260114	Tubulinea	other_Eukaryota	185	1.1599999999999999e-42	NTclustered	gi\|909719645\|gb\|KT185625.1\|	5778	g3433	i0	99.029	66.4105960264901	103	1	68	0	11	113	4837	4735	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	10028	185	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
11258459	11258459	PRJNA193544_S_NODE_2529_length_173_cov_310.576389_g2514_i0	PRJNA193544	2529	173	310.576389	537.29715297	Hartmannellidae	5776	Tubulinea	other_Eukaryota	320	3.61e-83	NTclustered	gi\|11527309\|gb\|AF293902.1\|AF293902	136464	g2514	i0	100	96.7919075144509	173	0	100	0	1	173	2	174	Saccamoeba limax small subunit ribosomal RNA gene, complete sequence	blastn	16745	320	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba limax
14394970	14394970	PRJNA193544_S_NODE_2032_length_190_cov_13.987578_g2017_i0	PRJNA193544	2032	190	13.987578	26.5763982	Mastigamoeba balamuthi	108607	Evosea	other_Eukaryota	76.8	9.69e-10	NTclustered	gi\|19911164\|dbj\|AB066364.1\|	108607	g2017	i0	94	0.589473684210526	50	3	26	0	141	190	1710	1661	Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR2	blastn	112	76.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba balamuthi
15668657	15668657	PRJNA193544_S_NODE_1133_length_240_cov_8.085308_g1118_i0	PRJNA193544	1133	240	8.085308	19.4047392	uncultured Vannellidae	544561	Discosea	other_Eukaryota	394	3.11e-105	NTclustered	gi\|270381377\|emb\|FN598227.1\|	544561	g1118	i0	97.414	89.3625	232	5	96	1	1	231	812	1043	Uncultured Vannellidae partial 18S rRNA gene, clone BIO1_A11	blastn	21447	394	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae		uncultured Vannellidae
16943189	16943189	PRJNA193544_S_NODE_734_length_282_cov_16.367589_g719_i0	PRJNA193544	734	282	16.367589	46.15660098	Rhizamoeba saxonica	200886	Tubulinea	other_Eukaryota	76.8	1.54e-9	NTclustered	gi\|300078497\|gb\|GU001159.1\|	200886	g719	i0	82.653	151.251773049645	98	6	33	9	190	281	2849	2941	Rhizamoeba saxonica 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	42653	76.8	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae	Rhizamoeba	Rhizamoeba saxonica
18906687	18906687	PRJNA193544_S_NODE_2035_length_190_cov_8.658385_g2020_i0	PRJNA193544	2035	190	8.6583850000000009	16.4509315	Hartmannellidae	5776	Tubulinea	other_Eukaryota	130	7.33e-26	NTclustered	gi\|11527309\|gb\|AF293902.1\|AF293902	136464	g2020	i0	97.368	39.2421052631579	76	2	40	0	115	190	691	616	Saccamoeba limax small subunit ribosomal RNA gene, complete sequence	blastn	7456	130	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba limax
22042490	22042490	PRJNA193544_S_NODE_118_length_448_cov_8.818616_g105_i0	PRJNA193544	118	448	8.818616	39.50739968	uncultured Rhizamoeba	1260765	Tubulinea	other_Eukaryota	459	2.1899999999999997e-124	NTclustered	gi\|511487963\|gb\|JX898537.1\|	1260765	g105	i0	86.279	36.4866071428571	430	50	95	9	1	426	131	555	Uncultured Rhizamoeba clone HCA_D03-34 28S ribosomal RNA gene, partial sequence	blastn	16346	459	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Leptomyxida	Flabellulidae		uncultured Rhizamoeba
22042491	22042491	PRJNA193544_S_NODE_1218_length_232_cov_5.014778_g1203_i0	PRJNA193544	1218	232	5.014778	11.63428496	Tubulinea sp. 4388	1216001	Tubulinea	other_Eukaryota	339	1.42e-88	NTclustered	gi\|399764265\|gb\|JQ271776.1\|	1216001	g1203	i0	93.133	8.50862068965517	233	13	99	3	1	231	232	1	Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence	blastn	1974	339	1	Eukaryota	Amoebozoa	Tubulinea					Tubulinea sp. 4388
22732018	22732018	PRJNA193544_S_NODE_618_length_299_cov_5.077778_g603_i0	PRJNA193544	618	299	5.077778	15.18255622	Amoebidae	35218	Tubulinea	other_Eukaryota	329	1.15e-85	NTclustered	gi\|17897589\|emb\|AJ314604.1\|	5775	g603	i0	87.5	76.4882943143813	288	32	95	4	2	285	1054	767	Amoeba proteus partial 16S rRNA gene, strain Geneva	blastn	22870	329	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
24007234	24007234	PRJNA193544_S_NODE_799_length_273_cov_14.323770_g784_i0	PRJNA193544	799	273	14.32377	39.1038921	Hartmannellidae	5776	Tubulinea	other_Eukaryota	337	6.18e-88	NTclustered	gi\|11527309\|gb\|AF293902.1\|AF293902	136464	g784	i0	89.552	93.8534798534799	268	24	97	4	1	266	1228	963	Saccamoeba limax small subunit ribosomal RNA gene, complete sequence	blastn	25622	337	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Saccamoeba	Saccamoeba limax

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