metadata: contig_metadata: 10 rows where bioproject = "PRJNA741997", tax_phylum = "Armatimonadota" and tax

10 rows where bioproject = "PRJNA741997", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"

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
1997664	1997664	PRJNA741997_P_NODE_71902_length_251_cov_0.865169_g70782_i0	PRJNA741997	71902	251	0.865169	2.17157419	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	206	1.65e-48	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g70782	i0	85.366	387.665338645418	205	23	80	6	1	201	1305164	1305365	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	97304	206	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
14750487	14750487	PRJNA741997_P_NODE_57592_length_283_cov_1.466667_g56472_i0	PRJNA741997	57592	283	1.466667	4.15066761	Armatimonadota bacterium	2033014	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2314718026\|dbj\|AP024674.1\|	2033014	g56472	i0	100	0.0989399293286219	28	0	10	0	238	265	965254	965281	MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome	blastn	28	52.8	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);;