metadata: contig_metadata: 16 rows where bioproject = "PRJNA896758", tax_phylum = "Acidobacteriota" and tax

16 rows where bioproject = "PRJNA896758", 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
2148255	2148255	PRJNA896758_P_NODE_6142_length_459_cov_1.316062_g5753_i0	PRJNA896758	6142	459	1.316062	6.04072458	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	577	5.939999999999999e-160	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g5753	i0	100	216.80174291939	312	0	68	0	1	312	312	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	99512	577	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4701380	4701380	PRJNA896758_P_NODE_18964_length_267_cov_1.474227_g18574_i0	PRJNA896758	18964	267	1.474227	3.93618609	uncultured Holophaga sp.	188475	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621785467\|emb\|OY781925.1\|	188475	g18574	i0	100	0.112359550561798	30	0	11	0	89	118	878245	878216	MAG: uncultured Holophaga sp. isolate 48fd71e5-2ffc-43bf-b6f5-ca4e00a42c30 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
11076386	11076386	PRJNA896758_P_NODE_24509_length_245_cov_0.895349_g24119_i0	PRJNA896758	24509	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	207	4.46e-49	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g24119	i0	84.434	531.134693877551	212	32	86	1	1	211	3298248	3298459	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	130128	207	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
16175651	16175651	PRJNA896758_P_NODE_6193_length_457_cov_1.617188_g5804_i0	PRJNA896758	6193	457	1.617188	7.39054916	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g5804	i0	100	0.0634573304157549	29	0	6	0	301	329	234563	234591	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19095444	19095444	PRJNA896758_P_NODE_23735_length_246_cov_1.832370_g23345_i0	PRJNA896758	23735	246	1.83237	4.5076302	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	422	1.47e-113	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g23345	i0	97.561	166.260162601626	246	6	100	0	1	246	3299771	3300016	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	40900	422	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27750923	27750923	PRJNA896758_P_NODE_5544_length_483_cov_1.946341_g5155_i0	PRJNA896758	5544	483	1.946341	9.40082703	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	122	2.55e-32	NR	HUD68307.1	2771375	g5155	i0	42.6	2.6583850931677	148	84	91.9	1	460	17	1	147	HUD68307.1 DUF1772 domain-containing protein [Candidatus Sulfotelmatobacter sp.]	diamond	1284	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
30624235	30624235	PRJNA896758_P_NODE_17653_length_276_cov_1.384236_g17263_i0	PRJNA896758	17653	276	1.384236	3.82049136	Chloracidobacterium sp.	2099375	Bacteria	Bacteria	62.4	6.69e-9	NR	MBK8467647.1	2099375	g17263	i0	44.8	0.728260869565217	67	36	72.8	1	75	275	1	66	MBK8467647.1 hypothetical protein [Chloracidobacterium sp.]	diamond	201	62.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp.
30782383	30782383	PRJNA896758_P_NODE_24754_length_244_cov_1.631579_g24364_i0	PRJNA896758	24754	244	1.631579	3.98105276	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	47.8	1.04e-4	NR	HYP04956.1	2212468	g24364	i0	42.9	0.688524590163934	56	25	68.9	1	77	244	4	52	HYP04956.1 PEP-CTERM sorting domain-containing protein [Bryobacteraceae bacterium]	diamond	168	47.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31003638	31003638	PRJNA896758_P_NODE_26594_length_241_cov_0.916667_g26204_i0	PRJNA896758	26594	241	0.916667	2.20916747	Candidatus Solibacter sp.	2068625	Bacteria	Bacteria	46.2	0.00216	NR	MCU1234346.1	2068625	g26204	i0	33.8	1.58091286307054	65	41	78.4	1	1	189	106	170	MCU1234346.1 hypothetical protein [Candidatus Solibacter sp.]	diamond	381	46.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
31161164	31161164	PRJNA896758_P_NODE_1055_length_1122_cov_1.870353_g782_i0	PRJNA896758	1055	1122	1.870353	20.98536066	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	52.4	0.00335	NR	MBL8169063.1	1978231	g782	i0	26.8	0.548128342245989	205	98	54.8	7	219	833	360	512	MBL8169063.1 hypothetical protein [Acidobacteriota bacterium]	diamond	615	52.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31825554	31825554	PRJNA896758_P_NODE_26257_length_241_cov_1.833333_g25867_i0	PRJNA896758	26257	241	1.833333	4.41833253	Holophaga sp.	2582906	Bacteria	Bacteria	54.7	1.6e-6	NR	HWQ07801.1	2582906	g25867	i0	52.7	2.4149377593361	55	24	68.5	1	5	169	120	172	HWQ07801.1 tail fiber protein [Holophaga sp.]	diamond	582	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	Holophaga sp.
31952159	31952159	PRJNA896758_P_NODE_11237_length_342_cov_6.003717_g10847_i0	PRJNA896758	11237	342	6.003717	20.53271214	Terracidiphilus sp.	1964191	Bacteria	Bacteria	45.4	0.00242	NR	MDR3737751.1	1964191	g10847	i0	36.5	0.552631578947368	63	38	53.5	1	276	94	8	70	MDR3737751.1 hypothetical protein [Terracidiphilus sp.]	diamond	189	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
32300659	32300659	PRJNA896758_P_NODE_12979_length_319_cov_1.565041_g12589_i0	PRJNA896758	12979	319	1.565041	4.99248079	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	60.5	1.35e-8	NR	HEX9186464.1	2793154	g12589	i0	36.4	0.827586206896552	88	52	82.8	2	50	313	37	120	HEX9186464.1 pyridoxamine 5'-phosphate oxidase family protein [Vicinamibacteria bacterium]	diamond	264	60.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
32490358	32490358	PRJNA896758_P_NODE_21479_length_251_cov_0.865169_g21089_i0	PRJNA896758	21479	251	0.865169	2.17157419	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	128	9.16e-36	NR	HEY7160253.1	1978231	g21089	i0	76.9	0.932270916334661	78	18	93.2	0	251	18	72	149	HEY7160253.1 nuclear transport factor 2 family protein [Acidobacteriota bacterium]	diamond	234	128	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32592786	32592786	PRJNA896758_P_NODE_15519_length_290_cov_1.244240_g15129_i0	PRJNA896758	15519	290	1.24424	3.608296	Bacteria	2	Bacteria	Bacteria	81.6	4.18e-16	NR	PYX78286.1	1978231	g15129	i0	38.9	1.96551724137931	95	57	98.3	1	3	287	179	272	PYX78286.1 MAG: NAD(P)-dependent oxidoreductase [Acidobacteriota bacterium]	diamond	570	81.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32710851	32710851	PRJNA896758_P_NODE_21220_length_251_cov_0.865169_g20830_i0	PRJNA896758	21220	251	0.865169	2.17157419	Sulfidibacter corallicola	2818388	Bacteria	Bacteria	43.1	0.0133	NR	WP_237384035.1	2818388	g20830	i0	52.8	0.430278884462151	36	17	43	0	115	8	82	117	WP_237384035.1 type II toxin-antitoxin system VapC family toxin [Sulfidibacter corallicola]	diamond	108	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Acanthopleuribacterales	Acanthopleuribacteraceae	Sulfidibacter	Sulfidibacter corallicola

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