metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA493827" 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
3656268	3656268	PRJNA493827_P_NODE_176303_length_257_cov_1.500000_g174105_i0	PRJNA493827	176303	257	1.5	3.855	Bacillati	1783272	Bacteria	Bacteria	108	4.92e-19	NTclustered	gi\|510021827\|emb\|HF951689.1\|	1303518	g174105	i0	96.875	2.75875486381323	64	2	25	0	17	80	2136211	2136148	Chthonomonas calidirosea T49 complete genome	blastn	709	108	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
4298416	4298416	PRJNA493827_P_NODE_197524_length_248_cov_1.462857_g195326_i0	PRJNA493827	197524	248	1.462857	3.62788536	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	167	7.679999999999999e-37	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g195326	i0	82	0.806451612903226	200	32	80	4	1	198	850202	850399	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	200	167	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4934458	4934458	PRJNA493827_P_NODE_92224_length_357_cov_1.686620_g90026_i0	PRJNA493827	92224	357	1.68662	6.0212334	Fimbriimonas	1005038	Bacteria	Bacteria	512	1.29e-140	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g90026	i0	92.918	844.717086834734	353	24	99	1	1	352	27189	26837	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	301564	512	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
6848339	6848339	PRJNA493827_P_NODE_157986_length_272_cov_3.226131_g155788_i0	PRJNA493827	157986	272	3.226131	8.77507632	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	381	2.8e-101	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g155788	i0	91.912	129.176470588235	272	22	100	0	1	272	1879639	1879368	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	35136	381	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
7482816	7482816	PRJNA493827_P_NODE_132626_length_296_cov_22.008969_g130428_i0	PRJNA493827	132626	296	22.008969	65.14654824	Armatimonadota	67819	Bacteria	Bacteria	339	1.88e-88	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g130428	i0	88.612	192.003378378378	281	28	94	4	2	280	37100	37378	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	56833	339	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
8757941	8757941	PRJNA493827_P_NODE_158027_length_272_cov_2.703518_g155829_i0	PRJNA493827	158027	272	2.703518	7.35356896	Fimbriimonas	1005038	Bacteria	Bacteria	346	1.02e-90	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g155829	i0	89.781	253.121323529412	274	23	100	5	1	272	27864	28134	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	68849	348	0.994252873563218	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
10033645	10033645	PRJNA493827_P_NODE_183308_length_251_cov_1.764045_g181110_i0	PRJNA493827	183308	251	1.764045	4.42775295	Chthonomonas	1077265	Bacteria	Bacteria	287	5.73e-73	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g181110	i0	87.352	2.68525896414343	253	28	100	4	1	251	1226	1476	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	674	287	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
15772766	15772766	PRJNA493827_P_NODE_129933_length_300_cov_1.237885_g127735_i0	PRJNA493827	129933	300	1.237885	3.713655	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	185	2.6399999999999998e-42	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g127735	i0	79.11	11.4233333333333	292	43	93	9	22	300	2045300	2045014	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	3427	185	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15774191	15774191	PRJNA493827_P_NODE_196573_length_249_cov_0.875000_g194375_i0	PRJNA493827	196573	249	0.875	2.17875	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	172	1.66e-38	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g194375	i0	80	0.983935742971888	245	40	97	6	1	242	4652556	4652318	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	245	172	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
19597013	19597013	PRJNA493827_P_NODE_174776_length_258_cov_1.735135_g172578_i0	PRJNA493827	174776	258	1.735135	4.4766483	Fimbriimonas sp.	1936159	Bacteria	Bacteria	346	9.619999999999999e-91	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g172578	i0	91.016	566.313953488372	256	23	99	0	3	258	1688257	1688002	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	146109	346	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.

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