metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA864829" 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
11440633	11440633	PRJNA864829_S_NODE_12929_length_178_cov_2.302326_g12843_i0	PRJNA864829	12929	178	2.302326	4.09814028	Fimbriimonas	1005038	Bacteria	Bacteria	307	2.91e-79	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g12843	i0	97.753	772.061797752809	178	4	100	0	1	178	27158	26981	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	137427	307	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
12326404	12326404	PRJNA864829_S_NODE_10770_length_193_cov_2.215278_g10684_i0	PRJNA864829	10770	193	2.215278	4.27548654	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	206	1.21e-48	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g10684	i0	88.69	82.5284974093264	168	19	87	0	1	168	1879496	1879663	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	15928	206	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15264784	15264784	PRJNA864829_S_NODE_7592_length_224_cov_1.360000_g7506_i0	PRJNA864829	7592	224	1.36	3.0464	Fimbriimonas	1005038	Bacteria	Bacteria	239	1.42e-58	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g7506	i0	88.177	232.888392857143	203	20	90	4	24	224	27634	27434	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	52167	239	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
17814326	17814326	PRJNA864829_S_NODE_254_length_826_cov_3.574003_g202_i0	PRJNA864829	254	826	3.574003	29.52126478	Fimbriimonas	1005038	Bacteria	Bacteria	981	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g202	i0	88.249	159.434624697337	834	80	99	13	1	825	29215	28391	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	131693	981	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
23799532	23799532	PRJNA864829_S_NODE_3039_length_315_cov_3.409774_g2953_i0	PRJNA864829	3039	315	3.409774	10.7407881	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	407	5.459999999999999e-109	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g2953	i0	91.304	148.965079365079	299	25	95	1	18	315	668769	669067	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	46924	407	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
25073395	25073395	PRJNA864829_S_NODE_80_length_1202_cov_5.633998_g61_i0	PRJNA864829	80	1202	5.633998	67.72065596	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	484	1.02e-131	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g61	i0	74.895	110.520798668885	1191	236	96	57	1	1158	1305837	1306997	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	132846	484	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
25463564	25463564	PRJNA864829_S_NODE_6460_length_239_cov_7.242105_g6374_i0	PRJNA864829	6460	239	7.242105	17.30863095	Armatimonadota	67819	Bacteria	Bacteria	255	1.53e-63	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g6374	i0	90.306	116.338912133891	196	17	82	2	45	239	37378	37184	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	27805	255	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus

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