metadata: contig_metadata: 15 rows where bioproject = "PRJNA782235", tax_phylum = "Acidobacteriota" and tax

15 rows where bioproject = "PRJNA782235", 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
13517187	13517187	PRJNA782235_P_NODE_24431_length_244_cov_0.900585_g24242_i0	PRJNA782235	24431	244	0.900585	2.1974274	Luteitalea pratensis	1855912	Bacteria	Bacteria	272	1.55e-68	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g24242	i0	86.831	1.40573770491803	243	32	99	0	1	243	4715681	4715923	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	343	272	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
14792083	14792083	PRJNA782235_P_NODE_6332_length_351_cov_1.661871_g6143_i0	PRJNA782235	6332	351	1.661871	5.83316721	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	207	1.27e-61	NR	GMU66463.1	1978231	g6143	i0	89.7	0.991452991452991	116	12	99.1	0	349	2	14	129	GMU66463.1 MAG: aspartate--tRNA ligase [Acidobacteriota bacterium]	diamond	348	207	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
18614993	18614993	PRJNA782235_P_NODE_23315_length_245_cov_0.895349_g23126_i0	PRJNA782235	23315	245	0.895349	2.19360505	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g23126	i0	97.059	0.26530612244898	34	1	14	0	86	119	5072884	5072851	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	65	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19890166	19890166	PRJNA782235_P_NODE_21416_length_247_cov_0.885057_g21227_i0	PRJNA782235	21416	247	0.885057	2.18609079	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	322	1.54e-83	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g21227	i0	90.283	93.7732793522267	247	23	100	1	1	247	287	42	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	23162	322	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22440669	22440669	PRJNA782235_P_NODE_19558_length_248_cov_1.411429_g19369_i0	PRJNA782235	19558	248	1.411429	3.50034392	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	166	6.859999999999999e-46	NR	GMU65421.1	1978231	g19369	i0	90.2	0.991935483870968	82	8	99.2	0	3	248	140	221	GMU65421.1 MAG: oligopeptidase B [Acidobacteriota bacterium]	diamond	246	166	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26958464	26958464	PRJNA782235_P_NODE_10042_length_289_cov_1.425926_g9853_i0	PRJNA782235	10042	289	1.425926	4.12092614	Luteitalea sp.	2004800	Bacteria	Bacteria	144	1.0999999999999999e-38	NR	HTU99217.1	2004800	g9853	i0	77.3	0.913494809688581	88	20	91.3	0	287	24	337	424	HTU99217.1 non-homologous end-joining DNA ligase [Luteitalea sp.]	diamond	264	144	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp.
27274900	27274900	PRJNA782235_P_NODE_23283_length_245_cov_0.895349_g23094_i0	PRJNA782235	23283	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	109	3e-26	NR	GMU65126.1	1978231	g23094	i0	79.7	0.844897959183673	69	14	84.5	0	208	2	1	69	GMU65126.1 MAG: hypothetical protein AMXMBFR36_14000 [Acidobacteriota bacterium]	diamond	207	109	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27306587	27306587	PRJNA782235_P_NODE_25083_length_244_cov_0.900585_g24894_i0	PRJNA782235	25083	244	0.900585	2.1974274	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	103	4.66e-25	NR	MBZ0114820.1	2651171	g24894	i0	60.5	0.995901639344262	81	32	99.6	0	1	243	114	194	MBZ0114820.1 phytanoyl-CoA dioxygenase family protein [Thermoanaerobaculia bacterium]	diamond	243	103	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28190384	28190384	PRJNA782235_P_NODE_22006_length_246_cov_0.890173_g21817_i0	PRJNA782235	22006	246	0.890173	2.18982558	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	100	2.8099999999999998e-24	NR	HVQ14204.1	2910147	g21817	i0	61.7	0.98780487804878	81	31	98.8	0	244	2	85	165	HVQ14204.1 FliH/SctL family protein [Vicinamibacterales bacterium]	diamond	243	100	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28411742	28411742	PRJNA782235_P_NODE_23466_length_245_cov_0.895349_g23277_i0	PRJNA782235	23466	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	104	1.16e-24	NR	MCI0391273.1	1978231	g23277	i0	63.2	4.82448979591837	76	28	93.1	0	245	18	212	287	MCI0391273.1 beta-lactamase family protein [Acidobacteriota bacterium]	diamond	1182	104	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29232697	29232697	PRJNA782235_P_NODE_10609_length_285_cov_1.533019_g10420_i0	PRJNA782235	10609	285	1.533019	4.36910415	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	123	2.05e-30	NR	HEX8638730.1	2283092	g10420	i0	72.9	1.55789473684211	85	20	87.4	2	35	283	462	545	HEX8638730.1 M20/M25/M40 family metallo-hydrolase [Pyrinomonadaceae bacterium]	diamond	444	123	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30306869	30306869	PRJNA782235_P_NODE_24912_length_244_cov_0.900585_g24723_i0	PRJNA782235	24912	244	0.900585	2.1974274	Bryobacterales bacterium	2026791	Bacteria	Bacteria	124	3.19e-34	NR	MCU0227583.1	2026791	g24723	i0	75	3.60245901639344	72	18	88.5	0	27	242	74	145	MCU0227583.1 acetyl-CoA carboxylase biotin carboxyl carrier protein [Bryobacterales bacterium]	diamond	879	124	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
30370013	30370013	PRJNA782235_P_NODE_19392_length_249_cov_0.875000_g19203_i0	PRJNA782235	19392	249	0.875	2.17875	Blastocatellia bacterium	2052146	Bacteria	Bacteria	156	4.53e-44	NR	HXG66790.1	2052146	g19203	i0	89	1.97590361445783	82	9	98.8	0	247	2	278	359	HXG66790.1 CocE/NonD family hydrolase [Blastocatellia bacterium]	diamond	492	156	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
30653768	30653768	PRJNA782235_P_NODE_28433_length_241_cov_0.916667_g28244_i0	PRJNA782235	28433	241	0.916667	2.20916747	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	162	1.12e-46	NR	MBI4904863.1	1978231	g28244	i0	93.8	0.995850622406639	80	5	99.6	0	241	2	3	82	MBI4904863.1 TonB-dependent receptor [Acidobacteriota bacterium]	diamond	240	162	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31349293	31349293	PRJNA782235_P_NODE_18556_length_249_cov_0.875000_g18367_i0	PRJNA782235	18556	249	0.875	2.17875	Blastocatellia bacterium	2052146	Bacteria	Bacteria	144	7.699999999999999e-38	NR	MBO0726968.1	2052146	g18367	i0	78	1.97590361445783	82	18	98.8	0	248	3	846	927	MBO0726968.1 YfhO family protein [Blastocatellia bacterium]	diamond	492	144	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia 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);;