metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJEB29441" and tax

12 rows where analysis = "blastn", bioproject = "PRJEB29441" 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
26857	26857	PRJEB29441_P_NODE_7761_length_415_cov_3.942623_g7322_i0	PRJEB29441	7761	415	3.942623	16.36188545	Capsulimonas corticalis	2219043	Bacteria	Bacteria	564	4.149999999999999e-156	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g7322	i0	91.892	909.2	407	27	97	6	8	411	594467	594064	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	377318	564	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
988356	988356	PRJEB29441_P_NODE_3961_length_611_cov_5.973310_g3556_i0	PRJEB29441	3961	611	5.97331	36.4969241	Chthonomonas	1077265	Bacteria	Bacteria	564	6.289999999999998e-156	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g3556	i0	83.524	107.795417348609	613	92	99	8	1	607	1226	1835	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	65863	564	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
988371	988371	PRJEB29441_P_NODE_42461_length_164_cov_1.773913_g42020_i0	PRJEB29441	42461	164	1.773913	2.90921732	Bacteria	2	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|95115294\|gb\|DQ501336.1\|	157466	g42020	i0	100	100.957317073171	164	0	100	0	1	164	960	1123	Uncultured candidate division OP10 bacterium clone ST11-34 16S ribosomal RNA gene, partial sequence	blastn	16557	303	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
3538910	3538910	PRJEB29441_P_NODE_37103_length_171_cov_1.401639_g36662_i0	PRJEB29441	37103	171	1.401639	2.39680269	Fimbriimonas	1005038	Bacteria	Bacteria	233	4.77e-57	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g36662	i0	91.279	8.4093567251462	172	13	100	2	1	171	28178	28348	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	1438	233	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8953652	8953652	PRJEB29441_P_NODE_3808_length_625_cov_2.289931_g3410_i0	PRJEB29441	3808	625	2.289931	14.31206875	Capsulimonas corticalis	2219043	Bacteria	Bacteria	841	0	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g3410	i0	93.056	301.5744	576	38	92	2	52	625	593968	593393	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	188484	841	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
14054945	14054945	PRJEB29441_P_NODE_45032_length_162_cov_1.805310_g44591_i0	PRJEB29441	45032	162	1.80531	2.9246022	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	191	2.74e-44	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g44591	i0	89.474	227.308641975309	152	15	94	1	2	153	2201890	2201740	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	36824	191	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
15015998	15015998	PRJEB29441_P_NODE_10232_length_353_cov_2.427632_g9791_i0	PRJEB29441	10232	353	2.427632	8.56954096	Fimbriimonas	1005038	Bacteria	Bacteria	357	6.32e-94	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g9791	i0	85.154	33.8923512747875	357	43	100	8	1	353	28214	28564	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	11964	357	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
16290951	16290951	PRJEB29441_P_NODE_28553_length_196_cov_1.394558_g28112_i0	PRJEB29441	28553	196	1.394558	2.73333368	Armatimonadota	67819	Bacteria	Bacteria	185	1.6e-42	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g28112	i0	92.913	384.887755102041	127	9	65	0	70	196	37129	37255	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	75438	185	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
20427591	20427591	PRJEB29441_P_NODE_8397_length_395_cov_10.479769_g7958_i0	PRJEB29441	8397	395	10.479769	41.39508755	Capsulimonas corticalis	2219043	Bacteria	Bacteria	353	9.25e-93	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g7958	i0	87.302	219.855696202532	315	32	79	6	1	311	595561	595251	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	86843	353	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
21390317	21390317	PRJEB29441_P_NODE_11777_length_325_cov_2.847826_g11336_i0	PRJEB29441	11777	325	2.847826	9.2554345	Fimbriimonas	1005038	Bacteria	Bacteria	435	2.6e-117	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11336	i0	90.798	433.338461538462	326	28	100	2	1	325	27428	27752	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	140835	435	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
21390326	21390326	PRJEB29441_P_NODE_12897_length_308_cov_2.447876_g12456_i0	PRJEB29441	12897	308	2.447876	7.53945808	Fimbriimonas	1005038	Bacteria	Bacteria	368	2.51e-97	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g12456	i0	88.599	159.821428571429	307	30	99	3	4	308	27837	28140	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	49225	370	0.994594594594595	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
23940657	23940657	PRJEB29441_P_NODE_33299_length_181_cov_1.931818_g32858_i0	PRJEB29441	33299	181	1.931818	3.49659058	Fimbriimonas	1005038	Bacteria	Bacteria	174	3.14e-39	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g32858	i0	84.153	185.204419889503	183	26	100	3	1	181	29744	29563	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	33522	174	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli

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