metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax_clade = "Discoba"

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
2331296	2331296	PRJNA207343_S_NODE_8662_length_189_cov_1.421053_g8125_i0	PRJNA207343	8662	189	1.421053	2.68579017	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	187	4.26e-43	NTclustered	gi\|11037201\|gb\|AF208879.1\|AF208879	140242	g8125	i0	99.038	69.2275132275132	104	1	55	0	86	189	497	600	Cruzella marina large subunit ribosomal RNA gene, partial sequence	blastn	13084	187	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Cruzella	Cruzella marina
2331317	2331317	PRJNA207343_S_NODE_9722_length_172_cov_1.503704_g9185_i0	PRJNA207343	9722	172	1.503704	2.58637088	Naegleria	5761	Heterolobosea	other_Eukaryota	313	5.989999999999998e-81	NTclustered	gi\|418968536\|gb\|KC164221.1\|	51634	g9185	i0	100	98.2441860465116	169	0	98	0	4	172	54	222	Naegleria australiensis clone CF4-34 18S ribosomal RNA gene, partial sequence	blastn	16898	313	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria australiensis
11259056	11259056	PRJNA207343_S_NODE_10489_length_162_cov_1.056000_g9952_i0	PRJNA207343	10489	162	1.056	1.71072	Naegleria	5761	Heterolobosea	other_Eukaryota	233	4.49e-57	NTclustered	gi\|2289385106\|gb\|OP297026.1\|	5762	g9952	i0	96.454	87.037037037037	141	5	87	0	1	141	396	536	Naegleria gruberi strain 3HKMJS1 small subunit ribosomal RNA gene, partial sequence	blastn	14100	233	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
12534564	12534564	PRJNA207343_S_NODE_5490_length_285_cov_3.709677_g4953_i0	PRJNA207343	5490	285	3.709677	10.57257945	Trypanosoma	5690	Euglenozoa	other_Eukaryota	433	8.05e-117	NTclustered	gi\|2026667530\|dbj\|LC618030.1\|	67003	g4953	i0	94.056	158.919298245614	286	15	100	2	1	285	4692	4408	Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence	blastn	45292	433	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
21457748	21457748	PRJNA207343_S_NODE_8577_length_190_cov_3.163399_g8040_i0	PRJNA207343	8577	190	3.163399	6.0104581	Naegleria	5761	Heterolobosea	other_Eukaryota	351	1.4399999999999997e-92	NTclustered	gi\|2618963742\|gb\|OR769034.1\|	5762	g8040	i0	100	9.69473684210526	190	0	100	0	1	190	5456	5645	Naegleria gruberi strain NEG-M rDNA-containing extrachromosomal element genomic sequence; and 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence	blastn	1842	351	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi

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