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

17 rows where bioproject = "PRJNA1129273", 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
283263	283263	PRJNA1129273_P_NODE_5481_length_302_cov_1.659389_g5201_i0	PRJNA1129273	5481	302	1.659389	5.01135478	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	230	1.2099999999999995e-55	NTclustered	gi\|2621704107\|emb\|OY761556.1\|	1978231	g5201	i0	80.528	149.937086092715	303	55	99	4	1	301	804998	804698	MAG: Acidobacteriota bacterium isolate 5ca539cc-3996-4499-a76f-7ad0c810d377 genome assembly, chromosome: 1	blastn	45281	230	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
4110267	4110267	PRJNA1129273_P_NODE_4784_length_326_cov_1.434783_g4504_i0	PRJNA1129273	4784	326	1.434783	4.67739258	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	340	5.839999999999999e-89	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g4504	i0	85.583	106.634969325153	326	46	99	1	1	325	3298176	3298501	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	34763	340	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5386438	5386438	PRJNA1129273_P_NODE_11425_length_202_cov_6.178295_g11145_i0	PRJNA1129273	11425	202	6.178295	12.4801559	Bryobacterales bacterium	2026791	Bacteria	Bacteria	320	4.37e-83	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g11145	i0	95.122	198.336633663366	205	6	99	2	2	202	6659462	6659258	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	40064	320	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
5386459	5386459	PRJNA1129273_P_NODE_5625_length_298_cov_1.342222_g5345_i0	PRJNA1129273	5625	298	1.342222	3.99982156	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	357	5.24e-94	NTclustered	gi\|76574297\|gb\|DQ139445.1\|	171953	g5345	i0	88.514	204.070469798658	296	33	99	1	1	295	74	369	Uncultured Acidobacteria bacterium clone CAL4 23S ribosomal RNA gene, partial sequence	blastn	60813	357	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6661139	6661139	PRJNA1129273_P_NODE_6886_length_274_cov_1.611940_g6606_i0	PRJNA1129273	6886	274	1.61194	4.4167156	Bryobacterales bacterium	2026791	Bacteria	Bacteria	448	2.7499999999999993e-121	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g6606	i0	96.337	559.956204379562	273	9	99	1	2	274	6658160	6658431	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	153428	448	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
7936309	7936309	PRJNA1129273_P_NODE_6967_length_273_cov_1.515000_g6687_i0	PRJNA1129273	6967	273	1.515	4.13595	Occallatibacter riparius	1002689	Bacteria	Bacteria	496	9.63e-136	NTclustered	gi\|2304899767\|gb\|CP093313.1\|	1002689	g6687	i0	99.631	113.78021978022	271	1	99	0	2	272	6620010	6619740	Occallatibacter riparius strain DSM 25168 chromosome, complete genome	blastn	31062	496	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Occallatibacter	Occallatibacter riparius
7936316	7936316	PRJNA1129273_P_NODE_7867_length_260_cov_1.663102_g7587_i0	PRJNA1129273	7867	260	1.663102	4.3240652	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	412	9.43e-111	NTclustered	gi\|112980849\|gb\|DQ829653.1\|	171953	g7587	i0	95.367	178.603846153846	259	12	99	0	2	260	930	1188	Uncultured Acidobacteria bacterium clone DON8 23S ribosomal RNA gene, partial sequence	blastn	46437	412	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9211248	9211248	PRJNA1129273_P_NODE_3128_length_421_cov_1.537356_g2849_i0	PRJNA1129273	3128	421	1.537356	6.47226876	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	773	0	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g2849	i0	99.762	102.70783847981	421	1	100	0	1	421	2169933	2170353	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	43240	773	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
10486803	10486803	PRJNA1129273_P_NODE_9169_length_248_cov_3.514286_g8889_i0	PRJNA1129273	9169	248	3.514286	8.71542928	Bryobacterales bacterium	2026791	Bacteria	Bacteria	357	4.24e-94	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g8889	i0	92.8	167.459677419355	250	12	99	5	1	245	2776947	2777195	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	41530	357	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
15586170	15586170	PRJNA1129273_P_NODE_1733_length_616_cov_2.926335_g1465_i0	PRJNA1129273	1733	616	2.926335	18.0262236	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	961	0	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g1465	i0	95.372	100.909090909091	605	27	98	1	7	610	284685	285289	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	62160	961	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
16860452	16860452	PRJNA1129273_P_NODE_6574_length_279_cov_1.490291_g6294_i0	PRJNA1129273	6574	279	1.490291	4.15791189	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	344	3.79e-90	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g6294	i0	89.085	650.412186379928	284	21	99	8	2	278	715754	716034	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	181465	344	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18135020	18135020	PRJNA1129273_P_NODE_5335_length_306_cov_4.167382_g5055_i0	PRJNA1129273	5335	306	4.167382	12.75218892	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	401	2.4599999999999992e-107	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g5055	i0	90.461	200.441176470588	304	29	99	0	2	305	3559017	3559320	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	61335	401	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
21960017	21960017	PRJNA1129273_P_NODE_1298_length_740_cov_2.818591_g1046_i0	PRJNA1129273	1298	740	2.818591	20.8575734	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	815	0	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g1046	i0	86.898	70.2162162162162	748	72	99	20	1	739	3558226	3557496	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	51960	815	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
26627143	26627143	PRJNA1129273_P_NODE_9821_length_245_cov_1.726744_g9541_i0	PRJNA1129273	9821	245	1.726744	4.2305228	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	60.8	1.34e-8	NR	MBK8197439.1	1978231	g9541	i0	53.7	1.18775510204082	54	25	66.1	0	164	3	30	83	MBK8197439.1 hypothetical protein [Acidobacteriota bacterium]	diamond	291	60.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27659836	27659836	PRJNA1129273_P_NODE_4744_length_327_cov_2.370079_g4464_i0	PRJNA1129273	4744	327	2.370079	7.75015833	Acidobacteriota	57723	Bacteria	Bacteria	134	3.85e-36	NR	HUH63403.1	1964191	g4464	i0	63.9	10.7155963302752	108	39	99.1	0	3	326	169	276	HUH63403.1 aldolase/citrate lyase family protein [Terracidiphilus sp.]	diamond	3504	134	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
29533459	29533459	PRJNA1129273_P_NODE_4950_length_320_cov_3.040486_g4670_i0	PRJNA1129273	4950	320	3.040486	9.7295552	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	84.3	2.21e-16	NR	MDR3736461.1	2052142	g4670	i0	74.5	0.478125	51	13	47.8	0	319	167	89	139	MDR3736461.1 chaperonin GroEL [Acidobacteriaceae bacterium]	diamond	153	84.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
32788345	32788345	PRJNA1129273_P_NODE_10960_length_232_cov_3.094340_g10680_i0	PRJNA1129273	10960	232	3.09434	7.1788688	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	43.1	0.0215	NR	MBV6495434.1	2283092	g10680	i0	33.9	0.724137931034483	56	31	72.4	1	10	177	199	248	MBV6495434.1 Gamma-glutamyl-gamma-aminobutyrate hydrolase PuuD [Pyrinomonadaceae bacterium]	diamond	168	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae 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);;