metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1249042" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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
1052159	1052159	PRJNA1249042_S_NODE_115381_length_151_cov_1.657407_g115167_i0	PRJNA1249042	115381	151	1.657407	2.50268457	Fimbriimonas	1005038	Bacteria	Bacteria	217	4.13e-52	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g115167	i0	92.667	195.476821192053	150	11	99	0	2	151	1689637	1689488	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	29517	217	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
1052313	1052313	PRJNA1249042_S_NODE_5921_length_362_cov_5.206897_g5707_i0	PRJNA1249042	5921	362	5.206897	18.84896714	Fimbriimonas	1005038	Bacteria	Bacteria	492	1.71e-134	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g5707	i0	91.62	238.232044198895	358	26	98	4	7	362	29042	28687	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	86240	492	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4880286	4880286	PRJNA1249042_S_NODE_29204_length_243_cov_1.920000_g28990_i0	PRJNA1249042	29204	243	1.92	4.6656	Fimbriimonas	1005038	Bacteria	Bacteria	180	9.63e-41	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g28990	i0	81.498	8.77777777777778	227	35	92	6	19	242	28213	27991	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	2133	180	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4880306	4880306	PRJNA1249042_S_NODE_3604_length_465_cov_6.203791_g3393_i0	PRJNA1249042	3604	465	6.203791	28.84762815	Fimbriimonas	1005038	Bacteria	Bacteria	534	3.68e-147	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g3393	i0	88.053	81.2924731182796	452	53	97	1	1	452	28272	27822	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	37801	534	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
10558753	10558753	PRJNA1249042_S_NODE_60829_length_197_cov_2.136364_g60615_i0	PRJNA1249042	60829	197	2.136364	4.20863708	Armatimonadetes bacterium Uphvl-Ar1	2004467	Bacteria	Bacteria	292	9.23e-75	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g60615	i0	93.467	3.3248730964467	199	9	100	4	1	197	1549253	1549449	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	655	292	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
18903828	18903828	PRJNA1249042_S_NODE_61475_length_196_cov_2.901961_g61261_i0	PRJNA1249042	61475	196	2.901961	5.68784356	Armatimonadota	67819	Bacteria	Bacteria	134	5.89e-27	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g61261	i0	79.793	5.98979591836735	193	31	97	7	1	191	35655	35841	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	1174	134	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);;