metadata: contig_metadata: 9 rows where bioproject = "PRJEB58983", tax_kingdom = "Bacillati" and tax

9 rows where bioproject = "PRJEB58983", tax_kingdom = "Bacillati" 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
2267349	2267349	PRJEB58983_P_NODE_21382_length_282_cov_2.406699_g20967_i0	PRJEB58983	21382	282	2.406699	6.78689118	Fimbriimonas	1005038	Bacteria	Bacteria	370	6.319999999999999e-98	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g20967	i0	90.459	658.528368794326	283	24	99	3	2	282	29490	29771	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	185705	370	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
6095291	6095291	PRJEB58983_P_NODE_32205_length_242_cov_2.195266_g31790_i0	PRJEB58983	32205	242	2.195266	5.31254372	Fimbriimonas	1005038	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g31790	i0	96.035	186.111570247934	227	9	94	0	16	242	28714	28488	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	45039	370	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7777266	7777266	PRJEB58983_P_NODE_19667_length_292_cov_1.082192_g19252_i0	PRJEB58983	19667	292	1.082192	3.16000064	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	172	1.06e-49	NR	MBC7527023.1	2739509	g19252	i0	91.8	4.98287671232877	97	8	99.7	0	2	292	127	223	MBC7527023.1 type II secretion system F family protein [Chthonomonadaceae bacterium]	diamond	1455	172	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
12471126	12471126	PRJEB58983_P_NODE_33030_length_238_cov_2.727273_g32615_i0	PRJEB58983	33030	238	2.727273	6.49090974	Fimbriimonas	1005038	Bacteria	Bacteria	339	1.4699999999999999e-88	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g32615	i0	92.437	447.415966386555	238	17	100	1	1	238	28229	28465	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	106485	340	0.997058823529412	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
12878743	12878743	PRJEB58983_P_NODE_34411_length_229_cov_2.134615_g33996_i0	PRJEB58983	34411	229	2.134615	4.88826835	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	171	5.41e-38	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g33996	i0	82.11	413.157205240175	218	22	92	10	1	211	3409098	3408891	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	94613	171	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
15019960	15019960	PRJEB58983_P_NODE_26812_length_257_cov_1.646739_g26397_i0	PRJEB58983	26812	257	1.646739	4.23211923	Fimbriimonas	1005038	Bacteria	Bacteria	448	2.5499999999999995e-121	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g26397	i0	98.054	487.739299610895	257	5	100	0	1	257	27157	26901	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	125349	448	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15427492	15427492	PRJEB58983_P_NODE_33193_length_237_cov_2.597561_g32778_i0	PRJEB58983	33193	237	2.597561	6.15621957	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	172	1.5599999999999999e-38	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g32778	i0	82.587	44.5949367088608	201	29	84	6	1	198	3915008	3914811	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	10569	172	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
21394195	21394195	PRJEB58983_P_NODE_28697_length_251_cov_0.876404_g28282_i0	PRJEB58983	28697	251	0.876404	2.19977404	Chthonomonas	1077265	Bacteria	Bacteria	171	6.02e-38	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g28282	i0	79.681	15.5019920318725	251	40	99	9	1	250	1305581	1305821	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	3891	171	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
32783235	32783235	PRJEB58983_P_NODE_32640_length_241_cov_2.351190_g32225_i0	PRJEB58983	32640	241	2.35119	5.6663679	Armatimonadetes bacterium Cent15-Ar3	1987502	Bacteria	Bacteria	95.1	3.3400000000000003e-22	NR	OWU65760.1	1987502	g32225	i0	59.7	0.896265560165975	72	28	88.4	1	27	239	59	130	OWU65760.1 MAG: hypothetical protein CBB60_003025 [Armatimonadetes bacterium Cent15-Ar3]	diamond	216	95.1	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Cent15-Ar3

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