metadata: contig_metadata: 35 rows where bioproject = "PRJNA849646", tax_phylum = "Acidobacteriota" and tax

35 rows where bioproject = "PRJNA849646", 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
5941464	5941464	PRJNA849646_P_NODE_29005_length_251_cov_1.949438_g28887_i0	PRJNA849646	29005	251	1.949438	4.89308938	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	152	1.3099999999999999e-42	NR	HEU4891817.1	2910147	g28887	i0	85.4	0.9800796812749	82	12	98	0	4	249	221	302	HEU4891817.1 radical SAM family heme chaperone HemW [Vicinamibacterales bacterium]	diamond	246	152	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
5941465	5941465	PRJNA849646_P_NODE_29085_length_251_cov_1.730337_g28967_i0	PRJNA849646	29085	251	1.730337	4.34314587	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	231	2.7199999999999997e-56	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g28967	i0	84.783	1.58964143426295	230	35	92	0	17	246	588703	588932	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	399	231	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
11041811	11041811	PRJNA849646_P_NODE_19969_length_268_cov_2.707692_g19851_i0	PRJNA849646	19969	268	2.707692	7.25661456	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	185	7.979999999999998e-56	NR	HEU4693165.1	2910147	g19851	i0	92.1	2.98880597014925	89	7	99.6	0	1	267	186	274	HEU4693165.1 thioredoxin domain-containing protein [Vicinamibacterales bacterium]	diamond	801	185	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
11041996	11041996	PRJNA849646_P_NODE_3809_length_310_cov_6.607595_g3691_i0	PRJNA849646	3809	310	6.607595	20.4835445	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	85.1	1.06e-16	NR	MBA2354947.1	1978231	g3691	i0	76	0.483870967741935	50	12	48.4	0	310	161	486	535	MBA2354947.1 NAD+ synthase [Acidobacteriota bacterium]	diamond	150	85.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
12317431	12317431	PRJNA849646_P_NODE_31930_length_248_cov_1.748571_g31812_i0	PRJNA849646	31930	248	1.748571	4.33645608	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	231	2.68e-56	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g31812	i0	84.783	1.74596774193548	230	35	93	0	18	247	4809735	4809964	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	433	231	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13591962	13591962	PRJNA849646_P_NODE_31491_length_249_cov_0.875000_g31373_i0	PRJNA849646	31491	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	142	7.059999999999999e-38	NR	MDQ3584176.1	1978231	g31373	i0	80.5	2.96385542168675	82	16	98.8	0	247	2	298	379	MDQ3584176.1 MFS transporter [Acidobacteriota bacterium]	diamond	738	142	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13592085	13592085	PRJNA849646_P_NODE_42571_length_219_cov_4.520548_g42453_i0	PRJNA849646	42571	219	4.520548	9.90000012	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	351	1.7099999999999995e-92	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g42453	i0	95.853	182.493150684931	217	9	99	0	1	217	4358265	4358481	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	39966	351	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14866085	14866085	PRJNA849646_P_NODE_18152_length_272_cov_1.547739_g18034_i0	PRJNA849646	18152	272	1.547739	4.20985008	Bryobacter	911113	Bacteria	Bacteria	158	1.18e-45	NR	WP_031498636.1	360054	g18034	i0	76.7	6.94852941176471	90	21	99.3	0	1	270	139	228	WP_031498636.1 sugar phosphate isomerase/epimerase family protein [Bryobacter aggregatus]	diamond	1890	158	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacter	Bryobacter aggregatus
16141159	16141159	PRJNA849646_P_NODE_4733_length_310_cov_3.451477_g4615_i0	PRJNA849646	4733	310	3.451477	10.6995787	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	62.1	4.81e-5	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g4615	i0	88.679	1.40967741935484	53	2	16	4	206	256	284757	284807	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	437	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18689363	18689363	PRJNA849646_P_NODE_14315_length_279_cov_2.048544_g14197_i0	PRJNA849646	14315	279	2.048544	5.71543776	Chloracidobacterium validum	2821543	Bacteria	Bacteria	250	8.49e-62	NTclustered	gi\|2033661925\|gb\|CP072649.1\|	2821543	g14197	i0	83.395	11.8243727598566	271	43	97	2	1	270	662450	662181	Chloracidobacterium validum strain BV2-C chromosome 2, complete sequence	blastn	3299	250	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium validum
19964700	19964700	PRJNA849646_P_NODE_30756_length_249_cov_2.397727_g30638_i0	PRJNA849646	30756	249	2.397727	5.97034023	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	92	3.32e-20	NR	MBV8069374.1	2052142	g30638	i0	58.8	0.963855421686747	80	31	94	1	16	249	98	177	MBV8069374.1 M20/M25/M40 family metallo-hydrolase [Acidobacteriaceae bacterium]	diamond	240	92	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
22910982	22910982	PRJNA849646_P_NODE_38298_length_241_cov_1.553571_g38180_i0	PRJNA849646	38298	241	1.553571	3.74410611	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	155	7.59e-44	NR	HET7219843.1	2910147	g38180	i0	98.8	0.995850622406639	80	1	99.6	0	2	241	162	241	HET7219843.1 P1 family peptidase [Vicinamibacterales bacterium]	diamond	240	155	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
23790285	23790285	PRJNA849646_P_NODE_10159_length_287_cov_2.640187_g10041_i0	PRJNA849646	10159	287	2.640187	7.57733669	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2814788339\|emb\|OY761475.2\|	2910147	g10041	i0	94.118	0.355400696864112	34	2	12	0	204	237	4674293	4674260	MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1	blastn	102	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26674720	26674720	PRJNA849646_P_NODE_17001_length_274_cov_1.791045_g16883_i0	PRJNA849646	17001	274	1.791045	4.9074633	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	160	3.44e-46	NR	HEU4892778.1	2910147	g16883	i0	95.6	0.996350364963504	91	4	99.6	0	2	274	170	260	HEU4892778.1 ABC transporter permease [Vicinamibacterales bacterium]	diamond	273	160	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26778483	26778483	PRJNA849646_P_NODE_22381_length_264_cov_1.308901_g22263_i0	PRJNA849646	22381	264	1.308901	3.45549864	Bacteria	2	Bacteria	Bacteria	138	5.58e-39	NR	MDQ3714405.1	1978231	g22263	i0	85.5	11.3181818181818	76	11	86.4	0	1	228	124	199	MDQ3714405.1 4-hydroxy-tetrahydrodipicolinate synthase [Acidobacteriota bacterium]	diamond	2988	139	0.992805755395683	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26801630	26801630	PRJNA849646_P_NODE_6041_length_310_cov_2.704641_g5923_i0	PRJNA849646	6041	310	2.704641	8.3843871	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	136	1.7999999999999998e-36	NR	MDQ3635052.1	1978231	g5923	i0	60.5	1.10322580645161	114	33	98.7	2	3	308	166	279	MDQ3635052.1 SDR family oxidoreductase [Acidobacteriota bacterium]	diamond	342	136	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26833454	26833454	PRJNA849646_P_NODE_11481_length_285_cov_1.367925_g11363_i0	PRJNA849646	11481	285	1.367925	3.89858625	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	101	4.36e-24	NR	MEP7366213.1	1978231	g11363	i0	62.3	3.10526315789474	77	26	77.9	1	223	2	6	82	MEP7366213.1 sulfite oxidase-like oxidoreductase [Acidobacteriota bacterium]	diamond	885	101	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26991367	26991367	PRJNA849646_P_NODE_19502_length_269_cov_2.285714_g19384_i0	PRJNA849646	19502	269	2.285714	6.14857066	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	43.9	0.01	NR	MCD9188677.1	2283092	g19384	i0	88	0.278810408921933	25	3	27.9	0	267	193	132	156	MCD9188677.1 SRPBCC family protein [Pyrinomonadaceae bacterium]	diamond	75	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27149272	27149272	PRJNA849646_P_NODE_37122_length_242_cov_2.508876_g37004_i0	PRJNA849646	37122	242	2.508876	6.07147992	Terriglobales bacterium	2282142	Bacteria	Bacteria	157	2.05e-44	NR	HKR83471.1	2282142	g37004	i0	93.8	0.991735537190083	80	5	99.2	0	241	2	121	200	HKR83471.1 branched-chain amino acid ABC transporter substrate-binding protein [Terriglobales bacterium]	diamond	240	157	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27189506	27189506	PRJNA849646_P_NODE_23042_length_262_cov_3.280423_g22924_i0	PRJNA849646	23042	262	3.280423	8.59470826	Pseudomonadati	3379134	Bacteria	Bacteria	141	1.4199999999999998e-37	NR	HET9942210.1	2081523	g22924	i0	73.6	13.9465648854962	87	23	99.6	0	261	1	143	229	HET9942210.1 PrkA family serine protein kinase [Terriglobia bacterium]	diamond	3654	141	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
27655366	27655366	PRJNA849646_P_NODE_41624_length_228_cov_2.903226_g41506_i0	PRJNA849646	41624	228	2.903226	6.61935528	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	137	4.96e-37	NR	MEP7339627.1	1978231	g41506	i0	86.7	2.96052631578947	75	10	98.7	0	227	3	208	282	MEP7339627.1 Gfo/Idh/MocA family oxidoreductase [Acidobacteriota bacterium]	diamond	675	137	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28949912	28949912	PRJNA849646_P_NODE_32788_length_247_cov_1.770115_g32670_i0	PRJNA849646	32788	247	1.770115	4.37218405	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	164	2.46e-48	NR	HSF41086.1	2651171	g32670	i0	95.1	2.98785425101215	82	4	99.6	0	246	1	189	270	HSF41086.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	738	164	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
29612390	29612390	PRJNA849646_P_NODE_40710_length_232_cov_2.993711_g40592_i0	PRJNA849646	40710	232	2.993711	6.94540952	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	151	2.08e-41	NR	HEU4926531.1	2910147	g40592	i0	93.4	0.982758620689655	76	5	98.3	0	230	3	294	369	HEU4926531.1 4-alpha-glucanotransferase [Vicinamibacterales bacterium]	diamond	228	151	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29960091	29960091	PRJNA849646_P_NODE_1631_length_411_cov_2.091716_g1514_i0	PRJNA849646	1631	411	2.091716	8.59695276	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	103	1.82e-22	NR	HEY0378331.1	2283092	g1514	i0	48.1	0.759124087591241	104	53	75.9	1	99	410	1682	1784	HEY0378331.1 RHS repeat-associated core domain-containing protein [Pyrinomonadaceae bacterium]	diamond	312	103	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30117966	30117966	PRJNA849646_P_NODE_39412_length_238_cov_2.418182_g39294_i0	PRJNA849646	39412	238	2.418182	5.75527316	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	99.8	1.8299999999999994e-23	NR	MDX2180598.1	2212468	g39294	i0	59.7	0.970588235294118	77	31	97.1	0	3	233	154	230	MDX2180598.1 methyltransferase domain-containing protein [Bryobacteraceae bacterium]	diamond	231	99.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
30117968	30117968	PRJNA849646_P_NODE_43352_length_202_cov_5.193798_g43234_i0	PRJNA849646	43352	202	5.193798	10.49147196	Terriglobus sp. TAA 43	278961	Bacteria	Bacteria	95.5	8.439999999999999e-23	NR	WP_047490629.1	278961	g43234	i0	95.8	0.712871287128713	48	2	71.3	0	58	201	73	120	WP_047490629.1 hypothetical protein [Terriglobus sp. TAA 43]	diamond	144	95.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus sp. TAA 43
30979627	30979627	PRJNA849646_P_NODE_8774_length_290_cov_2.290323_g8656_i0	PRJNA849646	8774	290	2.290323	6.6419367	Acidobacteriota	57723	Bacteria	Bacteria	138	1.85e-37	NR	MFL6281595.1	2283092	g8656	i0	65.6	2.97931034482759	96	33	99.3	0	1	288	188	283	MFL6281595.1 SRPBCC family protein [Pyrinomonadaceae bacterium]	diamond	864	138	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
31128786	31128786	PRJNA849646_P_NODE_19035_length_270_cov_1.994924_g18917_i0	PRJNA849646	19035	270	1.994924	5.3862948	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	136	5.169999999999998e-35	NR	HEY7500637.1	2910147	g18917	i0	76.4	0.988888888888889	89	21	98.9	0	268	2	254	342	HEY7500637.1 protein kinase [Vicinamibacterales bacterium]	diamond	267	136	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31223750	31223750	PRJNA849646_P_NODE_14055_length_280_cov_1.260870_g13937_i0	PRJNA849646	14055	280	1.26087	3.530436	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	199	1.93e-60	NR	GIU78994.1	2212468	g13937	i0	96.8	0.996428571428571	93	3	99.6	0	280	2	198	290	GIU78994.1 MAG: NADH-dependent dehydrogenase [Bryobacteraceae bacterium]	diamond	279	199	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31603584	31603584	PRJNA849646_P_NODE_14676_length_278_cov_3.629268_g14558_i0	PRJNA849646	14676	278	3.629268	10.08936504	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	187	1.0199999999999998e-55	NR	HEU4891662.1	2910147	g14558	i0	100	0.992805755395683	92	0	99.3	0	277	2	116	207	HEU4891662.1 P1 family peptidase [Vicinamibacterales bacterium]	diamond	276	187	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31603589	31603589	PRJNA849646_P_NODE_26636_length_255_cov_6.626374_g26518_i0	PRJNA849646	26636	255	6.626374	16.8972537	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	174	1.18e-51	NR	GIU77663.1	2212468	g26518	i0	95.2	0.988235294117647	84	4	98.8	0	2	253	209	292	GIU77663.1 MAG: aminodeoxychorismate lyase [Bryobacteraceae bacterium]	diamond	252	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31706695	31706695	PRJNA849646_P_NODE_34377_length_245_cov_2.936047_g34259_i0	PRJNA849646	34377	245	2.936047	7.19331515	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	142	4.769999999999999e-37	NR	MDX6406149.1	2052146	g34259	i0	80.2	14.8775510204082	81	16	99.2	0	3	245	833	913	MDX6406149.1 hypothetical protein [Blastocatellia bacterium]	diamond	3645	143	0.993006993006993	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
32173160	32173160	PRJNA849646_P_NODE_16438_length_275_cov_1.965347_g16320_i0	PRJNA849646	16438	275	1.965347	5.40470425	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	103	2.2799999999999994e-23	NR	HEX2456117.1	2910147	g16320	i0	81.7	1.30909090909091	60	11	65.5	0	181	2	418	477	HEX2456117.1 protein kinase [Vicinamibacterales bacterium]	diamond	360	103	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
32434676	32434676	PRJNA849646_P_NODE_26159_length_256_cov_3.114754_g26041_i0	PRJNA849646	26159	256	3.114754	7.97377024	Pseudomonadati	3379134	Bacteria	Bacteria	45.1	0.00667	NR	MFM2125201.1	1978231	g26041	i0	50	2.4140625	36	18	42.2	0	1	108	458	493	MFM2125201.1 hypothetical protein [Acidobacteriota bacterium]	diamond	618	45.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32718447	32718447	PRJNA849646_P_NODE_4140_length_310_cov_4.286920_g4022_i0	PRJNA849646	4140	310	4.28692	13.289452	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	56.6	1.15e-6	NR	HXJ96401.1	2081523	g4022	i0	42.9	1.10322580645161	56	31	53.2	1	145	309	584	639	HXJ96401.1 PAS domain S-box protein [Terriglobia bacterium]	diamond	342	56.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia 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);;