metadata: contig_metadata: 5 rows where bioproject = "PRJNA399711" and tax

5 rows where bioproject = "PRJNA399711" 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
25565182	25565182	PRJNA399711_S_NODE_89929_length_161_cov_1.967742_g89787_i0	PRJNA399711	89929	161	1.967742	3.16806462	Seculamonas ecuadoriensis	221724	Root_unresolved	Root_unresolved	75	2.85e-9	NTclustered	gi\|501673477\|ref\|NC_021128.1\|	221724	g89787	i0	94	1.46583850931677	50	2	30	1	111	159	21158	21207	Seculamonas ecuadoriensis strain ATCC 50688 mitochondrion, complete genome	blastn	236	75	1	Eukaryota	Discoba			Jakobida		Seculamonas	Seculamonas ecuadoriensis
25699462	25699462	PRJNA399711_S_NODE_38594_length_218_cov_10.558011_g38452_i0	PRJNA399711	38594	218	10.558011	23.01646398	Colacium vesiculosum	102910	Euglenozoa	other_Eukaryota	121	5.209999999999999e-23	NTclustered	gi\|480512001\|gb\|JN674636.2\|	102910	g38452	i0	89.583	0.981651376146789	96	9	44	1	100	194	74792	74887	Colacium vesiculosum chloroplast, partial genome	blastn	214	121	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Colacium	Colacium vesiculosum
26108828	26108828	PRJNA399711_S_NODE_64629_length_181_cov_4.840278_g64487_i0	PRJNA399711	64629	181	4.840278	8.76090318	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	56.5	0.001	NTclustered	gi\|290991054\|ref\|XM_002678105.1\|	5762	g64487	i0	100	0.165745856353591	30	0	17	0	141	170	390	361	Naegleria gruberi nucleoside diphosphate kinase (NAEGRDRAFT_60551), partial mRNA	blastn	30	56.5	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
32952185	32952185	PRJNA399711_S_NODE_65474_length_180_cov_7.258741_g65332_i0	PRJNA399711	65474	180	7.258741	13.0657338	Porcisia hertigi	2761500	Euglenozoa	other_Eukaryota	49.7	5.74e-5	NR	XP_067752445.1	2761500	g65332	i0	43.3	1	60	34	100	0	180	1	266	325	XP_067752445.1 hypothetical protein JKF63_00236 [Porcisia hertigi]	diamond	180	49.7	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Porcisia	Porcisia hertigi
33156816	33156816	PRJNA399711_S_NODE_80552_length_167_cov_8.153846_g80410_i0	PRJNA399711	80552	167	8.153846	13.61692282	Eutreptiella sp. CCMP1594	1867818	Euglenozoa	other_Eukaryota	51.6	3.3e-7	NR	UXD06458.1	1867818	g80410	i0	80	4.86826347305389	35	7	62.9	0	105	1	3	37	UXD06458.1 photosystem II protein I [Eutreptiella sp. CCMP1594]	diamond	813	51.6	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Eutreptiales	Eutreptiaceae	Eutreptiella	Eutreptiella sp. CCMP1594

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