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

5 rows where analysis = "blastn", bioproject = "PRJNA773778" 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
3302343	3302343	PRJNA773778_S_NODE_36243_length_262_cov_1.857143_g36093_i0	PRJNA773778	36243	262	1.857143	4.86571466	Rapaza viridis	1112050	Euglenozoa	other_Eukaryota	202	2.24e-47	NTclustered	gi\|383210384\|dbj\|AB679269.1\|	1112050	g36093	i0	85.5	0.763358778625954	200	21	76	6	8	205	1527	1334	Rapaza viridis gene for small subunit ribosomal RNA, partial sequence	blastn	200	202	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Rapazida	Rapazidae	Rapaza	Rapaza viridis
7585382	7585382	PRJNA773778_S_NODE_37886_length_257_cov_2.510870_g37736_i0	PRJNA773778	37886	257	2.51087	6.4529359	Neobodo	312470	Euglenozoa	other_Eukaryota	464	2.5299999999999998e-126	NTclustered	gi\|1832418760\|gb\|MT355131.1\|	2728140	g37736	i0	99.222	74.3618677042802	257	2	100	0	1	257	906	650	Neobodo sp. HFCC729 small subunit ribosomal RNA gene, partial sequence	blastn	19111	464	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Neobodonida		Neobodo	Neobodo sp. HFCC729
16053404	16053404	PRJNA773778_S_NODE_19593_length_331_cov_10.895349_g19443_i0	PRJNA773778	19593	331	10.895349	36.06360519	Naegleria fowleri	5763	Heterolobosea	other_Eukaryota	180	1.3699999999999996e-40	NTclustered	gi\|2031924363\|emb\|OD955780.1\|	5763	g19443	i0	85.799	86.5347432024169	169	24	51	0	163	331	1438	1270	Naegleria fowleri Karachi_NF001 strain	blastn	28643	180	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria fowleri
19878238	19878238	PRJNA773778_S_NODE_4416_length_574_cov_4.211577_g4268_i0	PRJNA773778	4416	574	4.211577	24.17445198	Peranema trichophorum	56466	Euglenozoa	other_Eukaryota	1011	0	NTclustered	gi\|427188201\|dbj\|AB757706.1\|	56466	g4268	i0	99.11	22.698606271777	562	5	98	0	13	574	1044	483	Peranema trichophorum rpl3 mRNA for 60S ribosomal protein L3, partial cds, strain: K-01	blastn	13029	1011	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Heteronematales	Peranemidae	Peranema	Peranema trichophorum
23704058	23704058	PRJNA773778_S_NODE_31259_length_278_cov_3.497561_g31109_i0	PRJNA773778	31259	278	3.497561	9.72321958	Rapaza viridis	1112050	Euglenozoa	other_Eukaryota	278	3.88e-70	NTclustered	gi\|383210384\|dbj\|AB679269.1\|	1112050	g31109	i0	84.698	8.11870503597122	281	39	100	3	1	278	99	378	Rapaza viridis gene for small subunit ribosomal RNA, partial sequence	blastn	2257	278	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Rapazida	Rapazidae	Rapaza	Rapaza viridis

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