metadata: contig_metadata: 10 rows where bioproject = "PRJNA675331", tax_phylum = "Acidobacteriota" and tax

10 rows where bioproject = "PRJNA675331", 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
27745550	27745550	PRJNA675331_P_NODE_8704_length_333_cov_1.307692_g8532_i0	PRJNA675331	8704	333	1.307692	4.35461436	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	67.4	2.79e-11	NR	HEV7671987.1	2651171	g8532	i0	48.1	0.72972972972973	81	37	70.3	3	39	272	82	160	HEV7671987.1 M12 family metallo-peptidase [Thermoanaerobaculia bacterium]	diamond	243	67.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28218662	28218662	PRJNA675331_P_NODE_20306_length_247_cov_0.885057_g20134_i0	PRJNA675331	20306	247	0.885057	2.18609079	Terriglobia bacterium	2081523	Bacteria	Bacteria	89	1.74e-18	NR	HLI29903.1	2081523	g20134	i0	50	2.84210526315789	78	38	94.7	1	238	5	341	417	HLI29903.1 cytochrome P450 [Terriglobia bacterium]	diamond	702	89	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
28735949	28735949	PRJNA675331_P_NODE_647_length_1092_cov_1.568204_g537_i0	PRJNA675331	647	1092	1.568204	17.12478768	Pseudomonadati	3379134	Bacteria	Bacteria	86.3	2.28e-15	NR	MFP5206222.1	1978231	g537	i0	30.7	2.68406593406593	241	133	64.6	8	1051	347	25	237	MFP5206222.1 carbonic anhydrase [Acidobacteriota bacterium]	diamond	2931	87	0.991954022988506	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28881884	28881884	PRJNA675331_P_NODE_20948_length_246_cov_0.890173_g20776_i0	PRJNA675331	20948	246	0.890173	2.18982558	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	46.6	8.53e-4	NR	HYM25921.1	2910147	g20776	i0	35.4	1.95121951219512	82	50	96.3	2	245	9	64	145	HYM25921.1 RDD family protein [Vicinamibacterales bacterium]	diamond	480	46.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29355687	29355687	PRJNA675331_P_NODE_19909_length_248_cov_0.880000_g19737_i0	PRJNA675331	19909	248	0.88	2.1824	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	43.9	0.014	NR	HVT16750.1	2651171	g19737	i0	34.7	0.870967741935484	72	40	87.1	3	15	230	169	233	HVT16750.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	216	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
29576348	29576348	PRJNA675331_P_NODE_22110_length_244_cov_0.900585_g21938_i0	PRJNA675331	22110	244	0.900585	2.1974274	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	76.3	4.3e-14	NR	PYX79323.1	1978231	g21938	i0	46.2	0.959016393442623	78	41	95.9	1	9	242	258	334	PYX79323.1 MAG: multidrug MFS transporter, partial [Acidobacteriota bacterium]	diamond	234	76.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30030632	30030632	PRJNA675331_P_NODE_4651_length_441_cov_1.861413_g4479_i0	PRJNA675331	4651	441	1.861413	8.20883133	Acidobacteriota	57723	Bacteria	Bacteria	97.1	7.33e-21	NR	HSE38944.1	2052146	g4479	i0	37.9	4.06122448979592	153	83	99.3	4	1	438	36	183	HSE38944.1 hypothetical protein [Blastocatellia bacterium]	diamond	1791	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
30946994	30946994	PRJNA675331_P_NODE_3574_length_496_cov_1.245863_g3403_i0	PRJNA675331	3574	496	1.245863	6.17948048	Pseudomonadati	3379134	Bacteria	Bacteria	65.5	5.95e-9	NR	OLE67551.1	1803430	g3403	i0	46.9	4.34274193548387	145	64	80.4	7	414	16	174	317	OLE67551.1 MAG: hypothetical protein AUG09_01890 [Acidobacteria bacterium 13_1_20CM_2_68_7]	diamond	2154	65.9	0.993930197268589	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium 13_1_20CM_2_68_7
31282535	31282535	PRJNA675331_P_NODE_23295_length_242_cov_0.911243_g23123_i0	PRJNA675331	23295	242	0.911243	2.20520806	Chloracidobacterium validum	2821543	Bacteria	Bacteria	43.1	0.0244	NR	WP_211428916.1	2821543	g23123	i0	35.4	0.59504132231405	48	31	59.5	0	97	240	55	102	WP_211428916.1 prolipoprotein diacylglyceryl transferase [Chloracidobacterium validum]	diamond	144	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium validum
31725353	31725353	PRJNA675331_P_NODE_23677_length_242_cov_0.911243_g23505_i0	PRJNA675331	23677	242	0.911243	2.20520806	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	102	9.39e-24	NR	HLZ41158.1	2771375	g23505	i0	60.8	1.95867768595041	79	30	97.9	1	1	237	12	89	HLZ41158.1 NADP-dependent oxidoreductase [Candidatus Sulfotelmatobacter sp.]	diamond	474	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.

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