metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA229468" 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
4194372	4194372	PRJNA229468_S_NODE_484_length_227_cov_1.146067_g471_i0	PRJNA229468	484	227	1.146067	2.60157209	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	132	1.66e-34	NR	KAL0485592.1	1008807	g471	i0	80	14.8678414096916	75	15	99.1	0	225	1	394	468	KAL0485592.1 adenosylhomocysteinase [Acrasis kona]	diamond	3375	132	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
26757323	26757323	PRJNA229468_S_NODE_241_length_319_cov_1.459259_g228_i0	PRJNA229468	241	319	1.459259	4.65503621	Andalucia godoyi	505711	Root_unresolved	Root_unresolved	174	6.52e-53	NR	KAF0852243.1	505711	g228	i0	81.7	5.21943573667712	93	17	87.5	0	280	2	18	110	KAF0852243.1 60S large subunit ribosomal protein uL16 (rpL10) [Andalucia godoyi]	diamond	1665	174	1	Eukaryota	Discoba			Jakobida	Andaluciidae	Andalucia	Andalucia godoyi
27390249	27390249	PRJNA229468_S_NODE_443_length_236_cov_1.363636_g430_i0	PRJNA229468	443	236	1.363636	3.21818096	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	48.9	2.15e-4	NR	XP_002674994.1	5762	g430	i0	41.8	0.699152542372881	55	29	69.9	1	180	16	31	82	XP_002674994.1 uncharacterized protein NAEGRDRAFT_83230 [Naegleria gruberi]	diamond	165	48.9	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28084588	28084588	PRJNA229468_S_NODE_1005_length_170_cov_1.487603_g992_i0	PRJNA229468	1005	170	1.487603	2.5289251	Strigomonas culicis	28005	Euglenozoa	other_Eukaryota	72	7.2e-15	NR	EPY33267.1	28005	g992	i0	56.4	1.94117647058824	55	24	97.1	0	170	6	27	81	EPY33267.1 large subunit ribosomal protein L23e [Strigomonas culicis]	diamond	330	72	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Trypanosomatida	Trypanosomatidae	Strigomonas	Strigomonas culicis
30263873	30263873	PRJNA229468_S_NODE_472_length_228_cov_1.994413_g459_i0	PRJNA229468	472	228	1.994413	4.54726164	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	47	9.67e-4	NR	KAL0491943.1	1008807	g459	i0	46.2	0.684210526315789	52	28	68.4	0	69	224	377	428	KAL0491943.1 ATP-binding cassette, subfamily G [Acrasis kona]	diamond	156	47	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
31496289	31496289	PRJNA229468_S_NODE_736_length_191_cov_1.077465_g723_i0	PRJNA229468	736	191	1.077465	2.05795815	Bodo saltans	75058	Euglenozoa	other_Eukaryota	51.6	1.37e-5	NR	CUG91657.1	75058	g723	i0	40	1.17801047120419	75	30	97.4	3	189	4	208	280	CUG91657.1 Hypothetical protein, putative, partial [Bodo saltans]	diamond	225	51.6	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans

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