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

5 rows where bioproject = "PRJNA898105" 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
6348221	6348221	PRJNA898105_P_NODE_3805_length_295_cov_0.887387_g3605_i0	PRJNA898105	3805	295	0.887387	2.61779165	Naegleria	5761	Heterolobosea	other_Eukaryota	540	4.79e-149	NTclustered	gi\|2618963742\|gb\|OR769034.1\|	5762	g3605	i0	99.661	29.064406779661	295	1	100	0	1	295	3550	3256	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	8574	540	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
14901855	14901855	PRJNA898105_P_NODE_8492_length_227_cov_2.214286_g8292_i0	PRJNA898105	8492	227	2.214286	5.02642922	Trypanosoma theileri	67003	Euglenozoa	other_Eukaryota	374	3.8e-99	NTclustered	gi\|2026667531\|dbj\|LC618031.1\|	67003	g8292	i0	96.476	158.488986784141	227	6	99	2	2	227	4630	4405	Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence	blastn	35977	374	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Trypanosoma	Trypanosoma theileri
20000484	20000484	PRJNA898105_P_NODE_876_length_698_cov_2.574400_g689_i0	PRJNA898105	876	698	2.5744	17.969312	Naegleria sp.	37103	Heterolobosea	other_Eukaryota	1290	0	NTclustered	gi\|2651357798\|gb\|PP174311.1\|	37103	g689	i0	100	26.7349570200573	698	0	100	0	1	698	3797	3100	Naegleria sp. isolate 33 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	18661	1290	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria sp.
28823946	28823946	PRJNA898105_P_NODE_4448_length_281_cov_2.831731_g4248_i0	PRJNA898105	4448	281	2.831731	7.95716411	Bodo saltans	75058	Euglenozoa	other_Eukaryota	76.3	1e-13	NR	CUF68560.1	75058	g4248	i0	41.8	0.97153024911032	91	53	97.2	0	277	5	1919	2009	CUF68560.1 membrane-associated protein, putative [Bodo saltans]	diamond	273	76.3	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
30821710	30821710	PRJNA898105_P_NODE_7314_length_246_cov_0.890173_g7114_i0	PRJNA898105	7314	246	0.890173	2.18982558	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62	6.53e-9	NR	XP_002668194.1	5762	g7114	i0	44	4.09756097560976	84	42	98.8	4	4	246	74	155	XP_002668194.1 uncharacterized protein NAEGRDRAFT_60092 [Naegleria gruberi]	diamond	1008	62.4	0.993589743589744	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);;