metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA716463" 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
14737167	14737167	PRJNA716463_P_NODE_58152_length_285_cov_1.452830_g57735_i0	PRJNA716463	58152	285	1.45283	4.1405655	Andalucia godoyi	505711	Root_unresolved	Root_unresolved	185	1.56e-53	NR	WCZ58456.1	505711	g57735	i0	98.9	0.989473684210526	94	1	98.9	0	284	3	370	463	WCZ58456.1 katanin p60 ATPase-containing subunit A [Andalucia godoyi]	diamond	282	185	1	Eukaryota	Discoba			Jakobida	Andaluciidae	Andalucia	Andalucia godoyi
23661633	23661633	PRJNA716463_P_NODE_83779_length_265_cov_3.447917_g83362_i0	PRJNA716463	83779	265	3.447917	9.13698005	Bodo saltans	75058	Euglenozoa	other_Eukaryota	181	1.35e-56	NR	CUG51243.1	75058	g83362	i0	97.7	0.99622641509434	88	2	99.6	0	2	265	59	146	CUG51243.1 40S ribosomal protein S19, putative [Bodo saltans]	diamond	264	181	1	Eukaryota	Discoba	Euglenozoa	Kinetoplastea	Eubodonida	Bodonidae	Bodo	Bodo saltans
31410899	31410899	PRJNA716463_P_NODE_117776_length_232_cov_2.905660_g117358_i0	PRJNA716463	117776	232	2.90566	6.7411312	Naegleria gruberi	5762	Heterolobosea	other_Eukaryota	46.6	0.00147	NR	XP_002679895.1	5762	g117358	i0	73.9	0.297413793103448	23	6	29.7	0	141	73	326	348	XP_002679895.1 uncharacterized protein NAEGRDRAFT_65095 [Naegleria gruberi]	diamond	69	46.6	1	Eukaryota	Discoba	Heterolobosea			Vahlkampfiidae	Naegleria	Naegleria gruberi
31726998	31726998	PRJNA716463_P_NODE_119977_length_228_cov_3.812903_g119559_i0	PRJNA716463	119977	228	3.812903	8.69341884	Acrasis kona	1008807	Heterolobosea	other_Eukaryota	114	1.3100000000000002e-27	NR	KAL0487225.1	1008807	g119559	i0	72	0.986842105263158	75	21	98.7	0	227	3	243	317	KAL0487225.1 acyl-CoA oxidase [Acrasis kona]	diamond	225	114	1	Eukaryota	Discoba	Heterolobosea			Acrasidae	Acrasis	Acrasis kona
32170311	32170311	PRJNA716463_P_NODE_95998_length_255_cov_1.692308_g95581_i0	PRJNA716463	95998	255	1.692308	4.3153854	Bodo saltans	75058	Euglenozoa	other_Eukaryota	97.8	1.9300000000000003e-21	NR	CUE71036.1	75058	g95581	i0	44.7	2.95294117647059	85	46	98.8	1	1	252	895	979	CUE71036.1 membrane-associated protein, putative [Bodo saltans]	diamond	753	97.8	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);;