metadata: contig_metadata: 12 rows where bioproject = "PRJNA385396", tax_phylum = "Acidobacteriota" and tax

12 rows where bioproject = "PRJNA385396", 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
8060006	8060006	PRJNA385396_P_NODE_12107_length_262_cov_1.486772_g12015_i0	PRJNA385396	12107	262	1.486772	3.89534264	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	94	2.2e-20	NR	UCF68842.1	1978231	g12015	i0	65.3	4.41984732824428	72	22	82.4	1	220	5	6	74	UCF68842.1 MAG: molecular chaperone DnaJ [Acidobacteriota bacterium]	diamond	1158	94	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13160644	13160644	PRJNA385396_P_NODE_17471_length_246_cov_0.890173_g17379_i0	PRJNA385396	17471	246	0.890173	2.18982558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g17379	i0	83.412	0.857723577235772	211	35	86	0	25	235	276970	277180	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	211	196	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24633649	24633649	PRJNA385396_P_NODE_9780_length_287_cov_1.294393_g9688_i0	PRJNA385396	9780	287	1.294393	3.71490791	Bacteria	2	Bacteria	Bacteria	108	6.43e-25	NR	MBX3298465.1	1978231	g9688	i0	92.3	4.75609756097561	65	5	67.9	0	197	3	1	65	MBX3298465.1 efflux RND transporter permease subunit [Acidobacteriota bacterium]	diamond	1365	109	0.990825688073395	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27092084	27092084	PRJNA385396_P_NODE_17942_length_245_cov_0.895349_g17850_i0	PRJNA385396	17942	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	79.3	3.76e-15	NR	HUB53504.1	1964191	g17850	i0	43.7	19.334693877551	87	43	99.2	3	244	2	140	226	HUB53504.1 endo-1,4-beta-xylanase [Terracidiphilus sp.]	diamond	4737	79.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
27801884	27801884	PRJNA385396_P_NODE_6464_length_334_cov_1.149425_g6372_i0	PRJNA385396	6464	334	1.149425	3.8390795	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	54.7	7.24e-6	NR	HKD10095.1	2212468	g6372	i0	44.3	5.32634730538922	88	43	74.6	3	334	86	187	273	HKD10095.1 putative Ig domain-containing protein [Bryobacteraceae bacterium]	diamond	1779	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
27959575	27959575	PRJNA385396_P_NODE_21365_length_241_cov_0.916667_g21273_i0	PRJNA385396	21365	241	0.916667	2.20916747	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	154	9e-43	NR	HEU4691883.1	2910147	g21273	i0	88.8	0.995850622406639	80	9	99.6	0	2	241	287	366	HEU4691883.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	240	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28843531	28843531	PRJNA385396_P_NODE_20288_length_242_cov_0.911243_g20196_i0	PRJNA385396	20288	242	0.911243	2.20520806	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	79	6.59e-15	NR	HEY0458860.1	2283092	g20196	i0	57.1	2.90082644628099	77	31	95.5	2	11	241	291	365	HEY0458860.1 M36 family metallopeptidase [Pyrinomonadaceae bacterium]	diamond	702	79	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29159638	29159638	PRJNA385396_P_NODE_13109_length_253_cov_1.016667_g13017_i0	PRJNA385396	13109	253	1.016667	2.57216751	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	98.6	2.32e-24	NR	HTC90217.1	2212468	g13017	i0	65	1.43478260869565	60	21	71.1	0	253	74	51	110	HTC90217.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	363	98.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29980465	29980465	PRJNA385396_P_NODE_6591_length_331_cov_1.891473_g6499_i0	PRJNA385396	6591	331	1.891473	6.26077563	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	94.4	6.98e-22	NR	HXI40267.1	2212468	g6499	i0	43.5	0.978851963746224	108	61	97.9	0	6	329	1	108	HXI40267.1 pilus assembly protein N-terminal domain-containing protein [Bryobacteraceae bacterium]	diamond	324	94.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31971748	31971748	PRJNA385396_P_NODE_17718_length_246_cov_0.890173_g17626_i0	PRJNA385396	17718	246	0.890173	2.18982558	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	113	6.34e-27	NR	MBS1829543.1	1978231	g17626	i0	74	1.8780487804878	77	20	93.9	0	245	15	864	940	MBS1829543.1 hypothetical protein [Acidobacteriota bacterium]	diamond	462	113	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32320196	32320196	PRJNA385396_P_NODE_13919_length_251_cov_0.865169_g13827_i0	PRJNA385396	13919	251	0.865169	2.17157419	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	113	6.920000000000001e-27	NR	HET8546730.1	2212468	g13827	i0	83.3	1.75697211155378	66	11	78.9	0	200	3	20	85	HET8546730.1 TonB-dependent receptor [Bryobacteraceae bacterium]	diamond	441	113	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32667307	32667307	PRJNA385396_P_NODE_21400_length_241_cov_0.916667_g21308_i0	PRJNA385396	21400	241	0.916667	2.20916747	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	95.1	1.2099999999999999e-23	NR	HET9469270.1	2910147	g21308	i0	78.2	2.04149377593361	55	12	68.5	0	241	77	22	76	HET9469270.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	492	95.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;