metadata: contig_metadata: 17 rows where bioproject = "PRJNA527965", tax_phylum = "Acidobacteriota" and tax

17 rows where bioproject = "PRJNA527965", tax_phylum = "Acidobacteriota" 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
1772029	1772029	PRJNA527965_S_NODE_2422_length_248_cov_5.352113_g2339_i0	PRJNA527965	2422	248	5.352113	13.27324024	Bryobacterales bacterium	2026791	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g2339	i0	95.565	203.895161290323	248	11	100	0	1	248	6658456	6658209	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	50566	398	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
3047892	3047892	PRJNA527965_S_NODE_443_length_496_cov_8.876356_g362_i0	PRJNA527965	443	496	8.876356	44.02672576	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	811	0	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g362	i0	97.479	98.4596774193548	476	11	96	1	22	496	653	1128	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	48836	811	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
5600695	5600695	PRJNA527965_S_NODE_2465_length_246_cov_2.597156_g2382_i0	PRJNA527965	2465	246	2.597156	6.38900376	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	244	3.42e-60	NTclustered	gi\|112980874\|gb\|DQ829678.1\|	171953	g2382	i0	85.124	135.5	242	33	98	3	4	244	252	13	Uncultured Acidobacteria bacterium clone DON4 23S ribosomal RNA gene, partial sequence	blastn	33333	244	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5600715	5600715	PRJNA527965_S_NODE_3425_length_205_cov_3.529412_g3342_i0	PRJNA527965	3425	205	3.529412	7.2352946	Paludibaculum fermentans	1473598	Bacteria	Bacteria	261	2.7300000000000002e-65	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g3342	i0	89.952	121.268292682927	209	12	100	5	1	205	4786338	4786541	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	24860	261	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
5600748	5600748	PRJNA527965_S_NODE_5185_length_164_cov_4.410853_g5102_i0	PRJNA527965	5185	164	4.410853	7.23379892	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g5102	i0	100	127.823170731707	164	0	100	0	1	164	4649132	4649295	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	20963	303	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
6217827	6217827	PRJNA527965_S_NODE_2785_length_229_cov_6.051546_g2702_i0	PRJNA527965	2785	229	6.051546	13.85804034	Bacteria	2	Bacteria	Bacteria	346	8.370000000000001e-91	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g2702	i0	93.939	106.17903930131	231	11	100	3	1	229	4231464	4231693	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	24315	346	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6874576	6874576	PRJNA527965_S_NODE_5066_length_166_cov_3.977099_g4983_i0	PRJNA527965	5066	166	3.977099	6.60198434	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	211	2.17e-50	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g4983	i0	90.244	53.1927710843374	164	13	99	2	1	164	3556441	3556601	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	8830	211	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
9425140	9425140	PRJNA527965_S_NODE_428_length_503_cov_1.784188_g347_i0	PRJNA527965	428	503	1.784188	8.97446564	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	651	0	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g347	i0	91.134	108.491053677932	485	36	96	7	16	496	1282	1763	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	54571	651	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
10700829	10700829	PRJNA527965_S_NODE_1749_length_294_cov_16.806950_g1666_i0	PRJNA527965	1749	294	16.80695	49.412433	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	486	6.3099999999999985e-133	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g1666	i0	97.535	459.414965986395	284	7	97	0	11	294	4233122	4232839	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	135068	486	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11975609	11975609	PRJNA527965_S_NODE_1650_length_301_cov_3.823308_g1567_i0	PRJNA527965	1650	301	3.823308	11.50815708	Bryobacterales bacterium	2026791	Bacteria	Bacteria	399	8.679999999999998e-107	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g1567	i0	90.615	263.12292358804	309	18	99	8	3	301	6659138	6659445	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	79200	399	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
11975688	11975688	PRJNA527965_S_NODE_5590_length_158_cov_2.276423_g5507_i0	PRJNA527965	5590	158	2.276423	3.59674834	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	272	9.21e-69	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g5507	i0	98.077	167.677215189873	156	3	99	0	1	156	1803	1648	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	26493	272	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
18348426	18348426	PRJNA527965_S_NODE_3955_length_191_cov_1.993590_g3872_i0	PRJNA527965	3955	191	1.99359	3.8077569000000002	Paludibaculum fermentans	1473598	Bacteria	Bacteria	257	3.2400000000000005e-64	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g3872	i0	91.099	103.062827225131	191	15	100	1	1	191	4786287	4786475	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	19685	257	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
18348428	18348428	PRJNA527965_S_NODE_4015_length_189_cov_2.857143_g3932_i0	PRJNA527965	4015	189	2.857143	5.40000027	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	8.97e-60	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g3932	i0	90.71	339.31746031746	183	16	96	1	8	189	2907600	2907418	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	64131	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19622860	19622860	PRJNA527965_S_NODE_1696_length_298_cov_4.935361_g1613_i0	PRJNA527965	1696	298	4.935361	14.70737578	Bryobacterales bacterium	2026791	Bacteria	Bacteria	503	6.36e-138	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g1613	i0	97.01	198.530201342282	301	6	100	1	1	298	6658509	6658209	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	59162	503	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
20899030	20899030	PRJNA527965_S_NODE_4797_length_171_cov_1.257353_g4714_i0	PRJNA527965	4797	171	1.257353	2.15007363	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	294	2.16e-75	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g4714	i0	97.661	13.3859649122807	171	4	100	0	1	171	172	2	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	2289	294	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24722908	24722908	PRJNA527965_S_NODE_2860_length_226_cov_3.523560_g2777_i0	PRJNA527965	2860	226	3.52356	7.9632456	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	324	3.86e-84	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g2777	i0	92.478	64.6194690265487	226	17	100	0	1	226	3558157	3558382	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	14604	324	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
24722910	24722910	PRJNA527965_S_NODE_2980_length_221_cov_3.354839_g2897_i0	PRJNA527965	2980	221	3.354839	7.41419419	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	342	1.0399999999999997e-89	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g2897	i0	94.57	182.276018099548	221	12	100	0	1	221	3556446	3556666	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	40283	342	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;