metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA534016" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA534016" 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
18359005	18359005	PRJNA534016_P_NODE_16635_length_245_cov_0.895349_g16545_i0	PRJNA534016	16635	245	0.895349	2.19360505	Pyrenomonadales	589342	Heterolobosea	other_Eukaryota	117	1.9699999999999999e-28	NR	XP_044544774.1	51637	g16545	i0	75	11.7428571428571	80	20	98	0	244	5	514	593	XP_044544774.1 uncharacterized protein C9374_009028 [Naegleria lovaniensis]	diamond	2877	117	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria lovaniensis
26888173	26888173	PRJNA534016_P_NODE_10501_length_275_cov_1.524752_g10411_i0	PRJNA534016	10501	275	1.524752	4.193068	Andalucia godoyi	505711	Root_unresolved	Root_unresolved	90.9	2.26e-21	NR	KAF0852643.1	505711	g10411	i0	48.9	4.77818181818182	88	45	96	0	9	272	1	88	KAF0852643.1 60S large subunit ribosomal protein eL33 (rpL35A) [Andalucia godoyi]	diamond	1314	90.9	1	Eukaryota	Discoba			Jakobida	Andaluciidae	Andalucia	Andalucia godoyi
26982843	26982843	PRJNA534016_P_NODE_13022_length_255_cov_1.692308_g12932_i0	PRJNA534016	13022	255	1.692308	4.3153854	Diplonema papillatum	91374	Euglenozoa	other_Eukaryota	74.7	6.19e-15	NR	KAJ9461071.1	91374	g12932	i0	46.3	0.964705882352941	82	44	96.5	0	253	8	6	87	KAJ9461071.1 60S ribosomal protein L24-A [Diplonema papillatum]	diamond	246	74.7	1	Eukaryota	Discoba	Euglenozoa	Diplonemea		Diplonemidae	Diplonema	Diplonema papillatum
27930638	27930638	PRJNA534016_P_NODE_17385_length_243_cov_0.905882_g17295_i0	PRJNA534016	17385	243	0.905882	2.20129326	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	61.2	1.16e-8	NR	KAL0488113.1	1008807	g17295	i0	46.3	2.22222222222222	54	28	66.7	1	7	168	126	178	KAL0488113.1 actinin alpha [Acrasis kona]	diamond	540	61.2	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
28499136	28499136	PRJNA534016_P_NODE_16367_length_245_cov_0.895349_g16277_i0	PRJNA534016	16367	245	0.895349	2.19360505	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	71.2	8.04e-13	NR	XP_002672291.1	5762	g16277	i0	48.8	1.00408163265306	82	38	99.2	3	244	2	84	162	XP_002672291.1 uncharacterized protein NAEGRDRAFT_72744 [Naegleria gruberi]	diamond	246	71.2	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
28593784	28593784	PRJNA534016_P_NODE_15587_length_247_cov_0.885057_g15497_i0	PRJNA534016	15587	247	0.885057	2.18609079	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	136	9.51e-37	NR	XP_002673670.1	5762	g15497	i0	83.8	0.898785425101215	74	12	89.9	0	234	13	1	74	XP_002673670.1 ChacC and PUA domain-containing protein [Naegleria gruberi]	diamond	222	136	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
32858860	32858860	PRJNA534016_P_NODE_17220_length_243_cov_1.470588_g17130_i0	PRJNA534016	17220	243	1.470588	3.57352884	Euglena gracilis	3039	Euglenozoa	other_Eukaryota	108	1.57e-27	NR	QLA09566.1	3039	g17130	i0	66.3	0.987654320987654	80	26	98.8	1	242	3	29	107	QLA09566.1 40S small subunit ribosomal protein uS4 [Euglena gracilis]	diamond	240	108	1	Eukaryota	Discoba	Euglenozoa	Euglenida	Euglenales	Euglenaceae	Euglena	Euglena gracilis

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