metadata: contig_metadata: 13 rows where bioproject = "PRJNA315314", tax_phylum = "Armatimonadota" and tax

13 rows where bioproject = "PRJNA315314", 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
1655596	1655596	PRJNA315314_S_NODE_20842_length_181_cov_7.361842_g20521_i0	PRJNA315314	20842	181	7.361842	13.32493402	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	318	1.37e-82	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g20521	i0	98.343	113.049723756906	181	3	100	0	1	181	669466	669646	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	20462	318	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
3615969	3615969	PRJNA315314_S_NODE_5123_length_354_cov_281.280000_g4802_i0	PRJNA315314	5123	354	281.28	995.7312	Fimbriimonas	1005038	Bacteria	Bacteria	472	2.17e-128	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g4802	i0	90.678	254.607344632768	354	33	100	0	1	354	27121	27474	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	90131	472	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
3615988	3615988	PRJNA315314_S_NODE_6843_length_309_cov_11.925000_g6522_i0	PRJNA315314	6843	309	11.925	36.84825	Fimbriimonas	1005038	Bacteria	Bacteria	318	2.5799999999999998e-82	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g6522	i0	86.622	154.89644012945	299	27	95	10	15	309	28714	28425	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	47863	318	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
5484265	5484265	PRJNA315314_S_NODE_20065_length_184_cov_9.432258_g19744_i0	PRJNA315314	20065	184	9.432258	17.35535472	Fimbriimonas sp.	1936159	Bacteria	Bacteria	257	3.1e-64	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g19744	i0	91.848	93.4510869565217	184	15	100	0	1	184	1688385	1688202	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	17195	257	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
5484574	5484574	PRJNA315314_S_NODE_8505_length_277_cov_39.278226_g8184_i0	PRJNA315314	8505	277	39.278226	108.80068602	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	272	1.7999999999999996e-68	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g8184	i0	85.075	256.480144404332	268	39	96	1	1	267	667649	667382	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	71045	272	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
6758373	6758373	PRJNA315314_S_NODE_14966_length_211_cov_5.796703_g14645_i0	PRJNA315314	14966	211	5.796703	12.23104333	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	130	8.32e-26	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g14645	i0	77.934	1.71563981042654	213	44	100	3	1	211	787746	787535	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	362	130	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
11859361	11859361	PRJNA315314_S_NODE_14110_length_217_cov_5.372340_g13789_i0	PRJNA315314	14110	217	5.37234	11.6579778	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	220	4.96e-53	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g13789	i0	87.766	173.764976958525	188	23	87	0	1	188	667495	667682	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	37707	220	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
13134572	13134572	PRJNA315314_S_NODE_2431_length_507_cov_15.543933_g2128_i0	PRJNA315314	2431	507	15.543933000000001	78.80774031	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	701	0	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g2128	i0	91.865	74.7495069033531	504	38	99	3	1	503	669212	668711	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	37898	701	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15683443	15683443	PRJNA315314_S_NODE_20353_length_183_cov_4.090909_g20032_i0	PRJNA315314	20353	183	4.090909	7.48636347	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	154	4.15e-33	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g20032	i0	82.759	45.4699453551913	174	29	95	1	5	177	2722441	2722614	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	8321	154	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
15683648	15683648	PRJNA315314_S_NODE_4973_length_359_cov_359.615152_g4652_i0	PRJNA315314	4973	359	359.615152	1291.01839568	Capsulimonas corticalis	2219043	Bacteria	Bacteria	383	1.0599999999999996e-101	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g4652	i0	88.438	438.821727019499	320	33	88	4	5	320	593567	593886	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	157537	383	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
16958431	16958431	PRJNA315314_S_NODE_6034_length_328_cov_40.093645_g5713_i0	PRJNA315314	6034	328	40.093645	131.5071556	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	374	5.8e-99	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g5713	i0	88.636	383.734756097561	308	34	94	1	20	327	1879665	1879359	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	125865	374	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
18232670	18232670	PRJNA315314_S_NODE_5155_length_353_cov_66.422840_g4834_i0	PRJNA315314	5155	353	66.42284	234.4726252	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	357	6.32e-94	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g4834	i0	86.687	332.917847025496	323	41	92	2	31	353	1878010	1877690	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	117520	357	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
22057114	22057114	PRJNA315314_S_NODE_10958_length_244_cov_43.074419_g10637_i0	PRJNA315314	10958	244	43.074419	105.10158236	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	327	3.27e-85	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g10637	i0	90.984	267.081967213115	244	20	99	2	2	244	667698	667456	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	65168	327	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae 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);;