metadata: contig_metadata: 18 rows where bioproject = "PRJNA631796", tax_phylum = "Acidobacteriota" and tax

18 rows where bioproject = "PRJNA631796", 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
1152018	1152018	PRJNA631796_P_NODE_3521_length_373_cov_1.576923_g3244_i0	PRJNA631796	3521	373	1.576923	5.88192279	Bacteria	2	Bacteria	Bacteria	579	1.3199999999999996e-160	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g3244	i0	94.638	100.986595174263	373	20	100	0	1	373	11428	11056	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	37668	584	0.991438356164384	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1879547	1879547	PRJNA631796_P_NODE_4122_length_343_cov_1.226950_g3844_i0	PRJNA631796	4122	343	1.22695	4.2084385	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	536	7.349999999999999e-148	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g3844	i0	95.015	104.775510204082	341	17	99	0	3	343	3556442	3556782	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	35938	536	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
1879565	1879565	PRJNA631796_P_NODE_7842_length_242_cov_1.779006_g7564_i0	PRJNA631796	7842	242	1.779006	4.30519452	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	235	2.02e-57	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g7564	i0	84.426	88.2438016528926	244	33	100	5	1	242	6633611	6633851	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	21355	235	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
3703691	3703691	PRJNA631796_P_NODE_6143_length_277_cov_1.180556_g5865_i0	PRJNA631796	6143	277	1.180556	3.27014012	Bacteria	2	Bacteria	Bacteria	324	4.89e-84	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g5865	i0	87.814	64.3212996389892	279	30	100	3	1	277	715743	716019	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	17817	324	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4431139	4431139	PRJNA631796_P_NODE_9184_length_226_cov_2.260606_g8906_i0	PRJNA631796	9184	226	2.260606	5.10896956	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	283	6.55e-72	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g8906	i0	92.5	275.774336283186	200	12	87	3	3	199	285574	285375	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	62325	283	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
8256555	8256555	PRJNA631796_P_NODE_2947_length_410_cov_2.068768_g2670_i0	PRJNA631796	2947	410	2.068768	8.4819488	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	494	5.44e-135	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2670	i0	88.725	111.870731707317	408	41	99	3	1	404	3299802	3299396	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	45867	494	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10807597	10807597	PRJNA631796_P_NODE_4289_length_335_cov_1.791971_g4011_i0	PRJNA631796	4289	335	1.791971	6.00310285	Luteitalea pratensis	1855912	Bacteria	Bacteria	619	6.91e-173	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g4011	i0	100	265.471641791045	335	0	100	0	1	335	654802	655136	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	88933	619	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
13357575	13357575	PRJNA631796_P_NODE_3211_length_390_cov_5.203647_g2934_i0	PRJNA631796	3211	390	5.203647	20.2942233	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	411	5.34e-110	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g2934	i0	94.074	124.751282051282	270	16	69	0	121	390	2367340	2367609	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	48653	411	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13357595	13357595	PRJNA631796_P_NODE_7651_length_245_cov_2.858696_g7373_i0	PRJNA631796	7651	245	2.858696	7.0038052	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	396	8.869999999999996e-106	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g7373	i0	96.639	904.726530612245	238	8	97	0	1	238	3301036	3300799	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	221658	396	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13357622	13357622	PRJNA631796_S_NODE_132551_length_199_cov_4.137681_g132384_i0	PRJNA631796	132551	199	4.137681	8.23398519	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	209	9.68e-50	NTclustered	gi\|76574291\|gb\|DQ139439.1\|	171953	g132384	i0	85.644	9.06030150753769	202	25	100	3	1	199	1524	1324	Uncultured Acidobacteria bacterium clone CAL9 23S ribosomal RNA gene, partial sequence	blastn	1803	209	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15906198	15906198	PRJNA631796_P_NODE_12253_length_204_cov_1.496503_g11975_i0	PRJNA631796	12253	204	1.496503	3.05286612	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	316	5.72e-82	NTclustered	gi\|31789363\|gb\|AY281352.1\|	171953	g11975	i0	94.608	101.004901960784	204	11	100	0	1	204	3638	3435	Uncultured Acidobacteria bacterium clone 23k22 genomic sequence	blastn	20605	316	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17181344	17181344	PRJNA631796_P_NODE_10954_length_209_cov_1.527027_g10676_i0	PRJNA631796	10954	209	1.527027	3.19148643	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	370	4.45e-98	NTclustered	gi\|31789387\|gb\|AY281353.1\|	171953	g10676	i0	98.565	208.909090909091	209	3	100	0	1	209	31369	31161	Uncultured Acidobacteria bacterium clone 32d1 genomic sequence	blastn	43662	370	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17181363	17181363	PRJNA631796_P_NODE_12754_length_202_cov_1.829787_g12476_i0	PRJNA631796	12754	202	1.829787	3.69616974	Paludibaculum fermentans	1473598	Bacteria	Bacteria	261	2.68e-65	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g12476	i0	92.021	159.727722772277	188	12	93	3	16	202	4785931	4786116	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	32265	261	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
21005792	21005792	PRJNA631796_P_NODE_3157_length_395_cov_2.107784_g2880_i0	PRJNA631796	3157	395	2.107784	8.3257468	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	381	4.239999999999999e-101	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g2880	i0	84.264	94.1569620253165	394	59	99	3	4	395	406	14	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	37192	381	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21005848	21005848	PRJNA631796_S_NODE_132697_length_198_cov_4.270073_g132530_i0	PRJNA631796	132697	198	4.270073	8.45474454	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	344	2.53e-90	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g132530	i0	97.98	106.449494949495	198	4	100	0	1	198	3556814	3556617	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	21077	344	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
22280433	22280433	PRJNA631796_P_NODE_10038_length_217_cov_3.282051_g9760_i0	PRJNA631796	10038	217	3.282051	7.12205067	Luteitalea pratensis	1855912	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g9760	i0	100	140.248847926267	217	0	100	0	1	217	655590	655374	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	30434	401	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
24103960	24103960	PRJNA631796_S_NODE_21839_length_263_cov_3.193069_g21672_i0	PRJNA631796	21839	263	3.193069	8.39777147	Bacteria	2	Bacteria	Bacteria	292	1.3e-74	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g21672	i0	86.742	203.847908745247	264	33	100	2	1	263	13	275	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	53612	292	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24829646	24829646	PRJNA631796_P_NODE_12960_length_202_cov_0.907801_g12682_i0	PRJNA631796	12960	202	0.907801	1.83375802	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	318	1.57e-82	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g12682	i0	95.05	301.960396039604	202	10	100	0	1	202	3558202	3558403	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	60996	318	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);;