metadata: contig_metadata: 19 rows where bioproject = "PRJNA1132896", tax_phylum = "Acidobacteriota" and tax

19 rows where bioproject = "PRJNA1132896", 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
7936638	7936638	PRJNA1132896_P_NODE_3927_length_290_cov_1.198157_g3836_i0	PRJNA1132896	3927	290	1.198157	3.4746553	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	147	4.3099999999999997e-42	NR	MCA1734261.1	1978231	g3836	i0	75	2.97931034482759	96	24	99.3	0	3	290	58	153	MCA1734261.1 S1 RNA-binding domain-containing protein [Acidobacteriota bacterium]	diamond	864	147	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
7936665	7936665	PRJNA1132896_P_NODE_6027_length_260_cov_2.080214_g5936_i0	PRJNA1132896	6027	260	2.080214	5.4085564	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	307	4.58e-79	NTclustered	gi\|112980870\|gb\|DQ829674.1\|	171953	g5936	i0	88.672	437.692307692308	256	24	97	5	8	260	314	61	Uncultured Acidobacteria bacterium clone DON24 23S ribosomal RNA gene, partial sequence	blastn	113800	307	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
26912062	26912062	PRJNA1132896_P_NODE_9822_length_242_cov_0.911243_g9731_i0	PRJNA1132896	9822	242	0.911243	2.20520806	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	142	3.91e-40	NR	HET9525901.1	2283092	g9731	i0	80	2.97520661157025	80	16	99.2	0	241	2	75	154	HET9525901.1 class I SAM-dependent methyltransferase [Pyrinomonadaceae bacterium]	diamond	720	142	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27164990	27164990	PRJNA1132896_P_NODE_7122_length_250_cov_0.870056_g7031_i0	PRJNA1132896	7122	250	0.870056	2.17514	Candidatus Angelobacter sp.	2976921	Bacteria	Bacteria	59.7	8.1e-9	NR	HKD82437.1	2976921	g7031	i0	63.6	0.66	55	20	66	0	81	245	1	55	HKD82437.1 hypothetical protein [Candidatus Angelobacter sp.]	diamond	165	59.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Candidatus Angelobacter	Candidatus Angelobacter sp.
27217198	27217198	PRJNA1132896_P_NODE_9302_length_244_cov_0.900585_g9211_i0	PRJNA1132896	9302	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	5.28e-7	NR	MBV9405644.1	2052142	g9211	i0	39.5	6.87295081967213	81	15	99.6	1	244	2	25	71	MBV9405644.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	1677	56.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
27354982	27354982	PRJNA1132896_P_NODE_3783_length_292_cov_2.780822_g3692_i0	PRJNA1132896	3783	292	2.780822	8.12000024	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	166	1.5e-50	NR	MBP6003260.1	2283092	g3692	i0	96.6	0.904109589041096	88	3	90.4	0	265	2	1	88	MBP6003260.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	264	166	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27512778	27512778	PRJNA1132896_P_NODE_6063_length_260_cov_1.192513_g5972_i0	PRJNA1132896	6063	260	1.192513	3.1005338	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	138	9.28e-36	NR	PYS06267.1	1978231	g5972	i0	76.7	1.98461538461538	86	20	99.2	0	3	260	175	260	PYS06267.1 MAG: DNA polymerase I [Acidobacteriota bacterium]	diamond	516	138	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27986333	27986333	PRJNA1132896_P_NODE_6845_length_251_cov_0.865169_g6754_i0	PRJNA1132896	6845	251	0.865169	2.17157419	Candidatus Solibacter sp.	2068625	Bacteria	Bacteria	99.4	8.7e-23	NR	MEO8370591.1	2068625	g6754	i0	78	1.41035856573705	59	13	70.5	0	250	74	266	324	MEO8370591.1 VOC family protein [Candidatus Solibacter sp.]	diamond	354	99.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter sp.
28017997	28017997	PRJNA1132896_P_NODE_10305_length_241_cov_0.916667_g10214_i0	PRJNA1132896	10305	241	0.916667	2.20916747	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	154	1.0699999999999999e-43	NR	HEU4939548.1	2910147	g10214	i0	91.3	1.99170124481328	80	7	99.6	0	2	241	31	110	HEU4939548.1 methyltransferase [Vicinamibacterales bacterium]	diamond	480	154	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29112197	29112197	PRJNA1132896_P_NODE_3008_length_322_cov_1.309237_g2917_i0	PRJNA1132896	3008	322	1.309237	4.21574314	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	116	1.4700000000000002e-27	NR	HZQ44649.1	2052142	g2917	i0	59.1	8.52484472049689	88	36	82	0	4	267	474	561	HZQ44649.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	2745	117	0.991452991452991	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
29501762	29501762	PRJNA1132896_P_NODE_3990_length_289_cov_1.273148_g3899_i0	PRJNA1132896	3990	289	1.273148	3.67939772	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	67	1.97e-10	NR	HZT78371.1	2910147	g3899	i0	45.3	1.72318339100346	95	51	98.6	1	1	285	615	708	HZT78371.1 alkaline phosphatase family protein [Vicinamibacterales bacterium]	diamond	498	67	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29754334	29754334	PRJNA1132896_P_NODE_8811_length_245_cov_0.895349_g8720_i0	PRJNA1132896	8811	245	0.895349	2.19360505	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	155	2.94e-44	NR	HKY42124.1	2283092	g8720	i0	90.1	3.96734693877551	81	8	99.2	0	243	1	38	118	HKY42124.1 acetate--CoA ligase family protein [Pyrinomonadaceae bacterium]	diamond	972	155	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30038730	30038730	PRJNA1132896_P_NODE_8531_length_246_cov_0.890173_g8440_i0	PRJNA1132896	8531	246	0.890173	2.18982558	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	63.9	1.34e-9	NR	HTT63577.1	2212468	g8440	i0	57.7	1.25609756097561	52	22	63.4	0	159	4	4	55	HTT63577.1 CocE/NonD family hydrolase [Bryobacteraceae bacterium]	diamond	309	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
30101793	30101793	PRJNA1132896_P_NODE_9432_length_243_cov_0.905882_g9341_i0	PRJNA1132896	9432	243	0.905882	2.20129326	Blastocatellia bacterium AA13	2169413	Bacteria	Bacteria	107	8.74e-25	NR	PYP82944.1	2169413	g9341	i0	60.8	0.975308641975309	79	31	97.5	0	241	5	80	158	PYP82944.1 MAG: decarboxylase [Blastocatellia bacterium AA13]	diamond	237	107	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium AA13
30133168	30133168	PRJNA1132896_P_NODE_6772_length_251_cov_0.865169_g6681_i0	PRJNA1132896	6772	251	0.865169	2.17157419	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	110	8.19e-26	NR	MDM7921362.1	2283092	g6681	i0	90.8	1.66135458167331	65	6	77.7	0	57	251	366	430	MDM7921362.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	417	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30344365	30344365	PRJNA1132896_P_NODE_6692_length_251_cov_1.730337_g6601_i0	PRJNA1132896	6692	251	1.730337	4.34314587	Pseudomonadati	3379134	Bacteria	Bacteria	57	1.62e-7	NR	MEA2692907.1	1978231	g6601	i0	44.1	1.60159362549801	59	31	70.5	1	224	48	42	98	MEA2692907.1 hypothetical protein [Acidobacteriota bacterium]	diamond	402	57	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32473371	32473371	PRJNA1132896_P_NODE_4719_length_279_cov_1.242718_g4628_i0	PRJNA1132896	4719	279	1.242718	3.46718322	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	152	1.81e-45	NR	HXH25530.1	2910147	g4628	i0	83.1	5.75268817204301	89	15	95.7	0	267	1	4	92	HXH25530.1 response regulator transcription factor [Vicinamibacterales bacterium]	diamond	1605	152	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
32599658	32599658	PRJNA1132896_P_NODE_9820_length_242_cov_0.911243_g9729_i0	PRJNA1132896	9820	242	0.911243	2.20520806	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	55.8	8.14e-8	NR	MEX2264363.1	2212468	g9729	i0	92.3	0.322314049586777	26	2	32.2	0	241	164	82	107	MEX2264363.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	78	55.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32757015	32757015	PRJNA1132896_P_NODE_8440_length_246_cov_0.890173_g8349_i0	PRJNA1132896	8440	246	0.890173	2.18982558	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	73.6	2.96e-13	NR	HEX7360491.1	2212468	g8349	i0	48.6	0.853658536585366	70	36	85.4	0	244	35	131	200	HEX7360491.1 RluA family pseudouridine synthase [Bryobacteraceae bacterium]	diamond	210	73.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;