metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA741997" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA741997" and tax_phylum = "Armatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1997465	1997465	PRJNA741997_P_NODE_36782_length_358_cov_1.350877_g35662_i0	PRJNA741997	36782	358	1.350877	4.83613966	Armatimonadota bacterium	2033014	Bacteria	Bacteria	58.2	3.81e-7	NR	MEY4882066.1	2033014	g35662	i0	34	0.787709497206704	94	49	78.8	2	344	63	187	267	MEY4882066.1 hypothetical protein [Armatimonadota bacterium]	diamond	282	58.2	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
26735633	26735633	PRJNA741997_P_NODE_82001_length_245_cov_1.343023_g80881_i0	PRJNA741997	82001	245	1.343023	3.29040635	Armatimonadota bacterium	2033014	Bacteria	Bacteria	41.2	0.0485	NR	MBI2844719.1	2033014	g80881	i0	40.8	0.6	49	29	60	0	81	227	1	49	MBI2844719.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Armatimonadota bacterium]	diamond	147	41.2	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27020914	27020914	PRJNA741997_P_NODE_19722_length_518_cov_2.959551_g18607_i0	PRJNA741997	19722	518	2.959551	15.33047418	Capsulimonadales bacterium	2971800	Bacteria	Bacteria	47.4	0.0126	NR	MDX1933652.1	2971800	g18607	i0	32.1	0.631274131274131	109	66	62.5	4	95	418	568	669	MDX1933652.1 PQQ-binding-like beta-propeller repeat protein [Capsulimonadales bacterium]	diamond	327	47.4	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales			Capsulimonadales bacterium
29105366	29105366	PRJNA741997_P_NODE_53488_length_293_cov_1.809091_g52368_i0	PRJNA741997	53488	293	1.809091	5.30063663	Armatimonadota bacterium	2033014	Bacteria	Bacteria	131	1.54e-33	NR	MBS1726118.1	2033014	g52368	i0	69.4	2.71331058020478	85	26	87	0	256	2	374	458	MBS1726118.1 MmgE/PrpD family protein [Armatimonadota bacterium]	diamond	795	131	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29736421	29736421	PRJNA741997_P_NODE_24630_length_451_cov_1.026455_g23510_i0	PRJNA741997	24630	451	1.026455	4.62931205	Fimbriimonas sp.	1936159	Bacteria	Bacteria	58.2	1.47e-6	NR	HSI72541.1	1936159	g23510	i0	42.6	1.98891352549889	68	35	43.2	3	10	204	102	168	HSI72541.1 hypothetical protein [Fimbriimonas sp.]	diamond	897	58.2	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
30557842	30557842	PRJNA741997_P_NODE_41313_length_338_cov_1.162264_g40193_i0	PRJNA741997	41313	338	1.162264	3.92845232	Armatimonadota bacterium	2033014	Bacteria	Bacteria	62.4	4.85e-9	NR	MFQ6097217.1	2033014	g40193	i0	40.5	0.745562130177515	84	42	70.1	2	6	242	40	120	MFQ6097217.1 Kelch repeat-containing protein [Armatimonadota bacterium]	diamond	252	62.4	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31949007	31949007	PRJNA741997_P_NODE_79757_length_247_cov_0.885057_g78637_i0	PRJNA741997	79757	247	0.885057	2.18609079	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	66.6	8.8e-11	NR	MCX7688986.1	2682145	g78637	i0	49.3	5.72064777327935	67	33	81.4	1	21	221	8	73	MCX7688986.1 HAD-IIA family hydrolase [Fimbriimonadales bacterium]	diamond	1413	66.6	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
32518918	32518918	PRJNA741997_P_NODE_55579_length_288_cov_1.074419_g54459_i0	PRJNA741997	55579	288	1.074419	3.09432672	Armatimonadota bacterium	2033014	Bacteria	Bacteria	44.7	0.0125	NR	NLB96135.1	2033014	g54459	i0	30.3	1.03125	99	63	96.9	2	285	7	65	163	NLB96135.1 CHRD domain-containing protein [Armatimonadota bacterium]	diamond	297	44.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium

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