metadata: contig_metadata: 31 rows where bioproject = "PRJNA1031674" and tax

31 rows where bioproject = "PRJNA1031674" and tax_phylum = "Acidobacteriota"

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
166650	166650	PRJNA1031674_P_NODE_18521_length_264_cov_2.581152_g18310_i0	PRJNA1031674	18521	264	2.581152	6.81424128	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	433	7.37e-117	NTclustered	gi\|76574290\|gb\|DQ139438.1\|	171953	g18310	i0	96.212	33.2992424242424	264	10	100	0	1	264	1267	1004	Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence	blastn	8791	433	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1006747	1006747	PRJNA1031674_P_NODE_15321_length_276_cov_1.517241_g15110_i0	PRJNA1031674	15321	276	1.517241	4.18758516	Bacteria	2	Bacteria	Bacteria	283	8.269999999999999e-72	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g15110	i0	90.323	171.721014492754	217	20	79	1	36	252	1285	1500	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	47395	285	0.992982456140351	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3993341	3993341	PRJNA1031674_P_NODE_28924_length_228_cov_4.277419_g28713_i0	PRJNA1031674	28924	228	4.277419	9.75251532	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	55.1	1.36e-6	NR	HJQ31064.1	2283092	g28713	i0	44.8	0.881578947368421	67	37	88.2	0	225	25	257	323	HJQ31064.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	201	55.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
5269656	5269656	PRJNA1031674_P_NODE_26485_length_243_cov_2.264706_g26274_i0	PRJNA1031674	26485	243	2.264706	5.50323558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g26274	i0	93.852	59.0205761316872	244	13	100	2	1	243	406	164	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	14342	366	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7819344	7819344	PRJNA1031674_P_NODE_19907_length_259_cov_1.655914_g19696_i0	PRJNA1031674	19907	259	1.655914	4.28881726	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	143	1.36e-29	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g19696	i0	83.333	4.25096525096525	156	24	60	2	26	180	6468655	6468501	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	1101	143	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9094096	9094096	PRJNA1031674_P_NODE_10708_length_291_cov_1.848624_g10497_i0	PRJNA1031674	10708	291	1.848624	5.37949584	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	167	9.23e-37	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g10497	i0	85.897	0.536082474226804	156	22	54	0	129	284	3649506	3649661	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	156	167	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12485668	12485668	PRJNA1031674_P_NODE_18810_length_263_cov_2.231579_g18599_i0	PRJNA1031674	18810	263	2.231579	5.86905277	Bacteria	2	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|157142601\|gb\|EU122872.1\|	171953	g18599	i0	100	100.106463878327	263	0	100	0	1	263	23	285	Uncultured Acidobacteria bacterium clone REF-104 16S ribosomal RNA gene, partial sequence	blastn	26328	486	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20567757	20567757	PRJNA1031674_P_NODE_16457_length_272_cov_1.547739_g16246_i0	PRJNA1031674	16457	272	1.547739	4.20985008	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	462	9.729999999999999e-126	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g16246	i0	97.426	137.136029411765	272	6	100	1	1	272	6633468	6633198	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	37301	462	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
21408936	21408936	PRJNA1031674_P_NODE_29017_length_227_cov_2.519481_g28806_i0	PRJNA1031674	29017	227	2.519481	5.71922187	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	115	3.2499999999999998e-28	NR	HEY3122172.1	2793154	g28806	i0	72	0.991189427312775	75	21	99.1	0	227	3	190	264	HEY3122172.1 ethanolamine permease [Vicinamibacteria bacterium]	diamond	225	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
27193023	27193023	PRJNA1031674_P_NODE_26882_length_243_cov_0.905882_g26671_i0	PRJNA1031674	26882	243	0.905882	2.20129326	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	58.5	8.99e-9	NR	MCX6618797.1	1978231	g26671	i0	37.9	1.75308641975309	66	41	81.5	0	45	242	34	99	MCX6618797.1 DUF2460 domain-containing protein [Acidobacteriota bacterium]	diamond	426	58.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28519586	28519586	PRJNA1031674_P_NODE_14927_length_277_cov_1.980392_g14716_i0	PRJNA1031674	14927	277	1.980392	5.48568584	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	142	4.9199999999999996e-40	NR	HEX8287390.1	2283092	g14716	i0	87.5	2.53429602888087	80	10	86.6	0	2	241	162	241	HEX8287390.1 C4-type zinc ribbon domain-containing protein [Pyrinomonadaceae bacterium]	diamond	702	142	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28551215	28551215	PRJNA1031674_P_NODE_15747_length_274_cov_3.014925_g15536_i0	PRJNA1031674	15747	274	3.014925	8.2608945	Pyrinomonas sp.	2080306	Bacteria	Bacteria	43.9	0.00739	NR	WP_352432448.1	2080306	g15536	i0	38.5	0.711678832116788	65	39	71.2	1	200	6	61	124	WP_352432448.1 IS200/IS605 family transposase [Pyrinomonas sp.]	diamond	195	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonas	Pyrinomonas sp.
29119604	29119604	PRJNA1031674_P_NODE_20269_length_258_cov_1.124324_g20058_i0	PRJNA1031674	20269	258	1.124324	2.90075592	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	139	6.72e-36	NR	MDP2390640.1	1978231	g20058	i0	82.1	1.95348837209302	84	15	97.7	0	253	2	9	92	MDP2390640.1 PDZ domain-containing protein [Acidobacteriota bacterium]	diamond	504	139	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29403572	29403572	PRJNA1031674_P_NODE_16649_length_271_cov_2.328283_g16438_i0	PRJNA1031674	16649	271	2.328283	6.30964693	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	125	3.1e-33	NR	HEY4356640.1	2052142	g16438	i0	67.8	1.92619926199262	90	29	99.6	0	270	1	146	235	HEY4356640.1 GAF domain-containing protein [Acidobacteriaceae bacterium]	diamond	522	125	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
29529923	29529923	PRJNA1031674_P_NODE_21530_length_252_cov_3.413408_g21319_i0	PRJNA1031674	21530	252	3.413408	8.60178816	Terriglobus tenax	1111115	Bacteria	Bacteria	165	3.2299999999999993e-46	NR	WP_263410592.1	1111115	g21319	i0	96.4	2	84	3	100	0	1	252	358	441	WP_263410592.1 M28 family peptidase [Terriglobus tenax]	diamond	504	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus tenax
29845579	29845579	PRJNA1031674_P_NODE_15091_length_277_cov_1.289216_g14880_i0	PRJNA1031674	15091	277	1.289216	3.57112832	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	87	5.72e-20	NR	MEO6193934.1	2651171	g14880	i0	77.4	1.14801444043321	53	12	57.4	0	118	276	1	53	MEO6193934.1 type II toxin-antitoxin system RelE/ParE family toxin [Thermoanaerobaculia bacterium]	diamond	318	87	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30477592	30477592	PRJNA1031674_P_NODE_26913_length_243_cov_0.905882_g26702_i0	PRJNA1031674	26913	243	0.905882	2.20129326	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	65.5	2.69e-10	NR	HYT31741.1	2651171	g26702	i0	74.4	0.530864197530864	43	11	53.1	0	44	172	271	313	HYT31741.1 SPFH domain-containing protein [Thermoanaerobaculia bacterium]	diamond	129	65.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30509063	30509063	PRJNA1031674_P_NODE_19873_length_259_cov_1.784946_g19662_i0	PRJNA1031674	19873	259	1.784946	4.62301014	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	137	5.469999999999999e-37	NR	HEY8133971.1	2651171	g19662	i0	70.6	8.8030888030888	85	25	98.5	0	259	5	254	338	HEY8133971.1 Lrp/AsnC family transcriptional regulator [Thermoanaerobaculia bacterium]	diamond	2280	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30730190	30730190	PRJNA1031674_P_NODE_15514_length_275_cov_2.217822_g15303_i0	PRJNA1031674	15514	275	2.217822	6.0990105	Terriglobus saanensis	870903	Bacteria	Bacteria	131	4.34e-33	NR	WP_013566782.1	870903	g15303	i0	67	0.992727272727273	91	30	99.3	0	2	274	580	670	WP_013566782.1 EAL domain-containing protein [Terriglobus saanensis]	diamond	273	131	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
31046471	31046471	PRJNA1031674_P_NODE_21635_length_252_cov_1.720670_g21424_i0	PRJNA1031674	21635	252	1.72067	4.3360884	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	100	3.21e-23	NR	HEY0156614.1	2651171	g21424	i0	67.9	2.85714285714286	78	25	92.9	0	16	249	246	323	HEY0156614.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	720	100	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
31140554	31140554	PRJNA1031674_P_NODE_9715_length_299_cov_2.420354_g9504_i0	PRJNA1031674	9715	299	2.420354	7.23685846	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	44.7	0.0137	NR	MBS1795981.1	1978231	g9504	i0	37.3	0.752508361204013	75	46	75.3	1	298	74	229	302	MBS1795981.1 diacylglycerol kinase family lipid kinase [Acidobacteriota bacterium]	diamond	225	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31203695	31203695	PRJNA1031674_P_NODE_23955_length_248_cov_0.880000_g23744_i0	PRJNA1031674	23955	248	0.88	2.1824	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	84.7	2.73e-17	NR	HYA29754.1	1978231	g23744	i0	70.7	2.10483870967742	58	17	70.2	0	247	74	208	265	HYA29754.1 ABC transporter substrate-binding protein [Acidobacteriota bacterium]	diamond	522	84.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31330609	31330609	PRJNA1031674_P_NODE_25896_length_244_cov_2.684211_g25685_i0	PRJNA1031674	25896	244	2.684211	6.54947484	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	76.6	1.49e-14	NR	HXH26671.1	3069120	g25685	i0	75.9	1.26639344262295	54	13	66.4	0	163	2	164	217	HXH26671.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	309	76.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
31362469	31362469	PRJNA1031674_P_NODE_2576_length_483_cov_1.617073_g2366_i0	PRJNA1031674	2576	483	1.617073	7.81046259	Candidatus Angelobacter sp.	2976921	Bacteria	Bacteria	178	1.9e-52	NR	HZJ34516.1	2976921	g2366	i0	58.1	0.919254658385093	148	60	91.3	2	5	445	134	280	HZJ34516.1 glycosyltransferase [Candidatus Angelobacter sp.]	diamond	444	178	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia			Candidatus Angelobacter	Candidatus Angelobacter sp.
31449336	31449336	PRJNA1031674_P_NODE_23776_length_248_cov_0.880000_g23565_i0	PRJNA1031674	23776	248	0.88	2.1824	Pseudomonadati	3379134	Bacteria	Bacteria	103	1.09e-26	NR	MBL8144344.1	1978231	g23565	i0	65.3	8.98790322580645	75	26	90.7	0	248	24	9	83	MBL8144344.1 penicillin acylase family protein [Acidobacteriota bacterium]	diamond	2229	103	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31805068	31805068	PRJNA1031674_P_NODE_11377_length_288_cov_5.744186_g11166_i0	PRJNA1031674	11377	288	5.744186	16.54325568	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	45.4	0.00655	NR	HZT28892.1	2212468	g11166	i0	32.6	0.958333333333333	92	62	95.8	0	280	5	231	322	HZT28892.1 PQQ-binding-like beta-propeller repeat protein [Bryobacteraceae bacterium]	diamond	276	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31836539	31836539	PRJNA1031674_P_NODE_10937_length_290_cov_1.419355_g10726_i0	PRJNA1031674	10937	290	1.419355	4.1161295	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	165	2.04e-46	NR	MSO55335.1	1978231	g10726	i0	81.3	1.98620689655172	96	18	99.3	0	289	2	169	264	MSO55335.1 glycogen synthase GlgA [Acidobacteriota bacterium]	diamond	576	165	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31836543	31836543	PRJNA1031674_P_NODE_19577_length_260_cov_2.288770_g19366_i0	PRJNA1031674	19577	260	2.28877	5.950802	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	63.9	1.5e-9	NR	HEX8288850.1	2283092	g19366	i0	38.1	0.969230769230769	84	50	96.9	1	3	254	163	244	HEX8288850.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	252	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32026634	32026634	PRJNA1031674_P_NODE_16998_length_270_cov_1.979695_g16787_i0	PRJNA1031674	16998	270	1.979695	5.3451765	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	123	2.84e-30	NR	MCM3871460.1	2283092	g16787	i0	65.2	0.988888888888889	89	30	98.9	1	267	1	489	576	MCM3871460.1 alpha/beta fold hydrolase [Pyrinomonadaceae bacterium]	diamond	267	123	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32311662	32311662	PRJNA1031674_P_NODE_12419_length_285_cov_1.924528_g12208_i0	PRJNA1031674	12419	285	1.924528	5.4849048	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	183	7.97e-54	NR	MEO7134736.1	2910147	g12208	i0	95.6	0.957894736842105	91	4	95.8	0	285	13	214	304	MEO7134736.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	273	183	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
32438155	32438155	PRJNA1031674_P_NODE_13079_length_283_cov_1.885714_g12868_i0	PRJNA1031674	13079	283	1.885714	5.33657062	Holophagales bacterium	2478486	Bacteria	Bacteria	118	3.299999999999999e-29	NR	MCG8455057.1	2478486	g12868	i0	60.6	0.996466431095406	94	37	99.6	0	283	2	216	309	MCG8455057.1 adenosylmethionine--8-amino-7-oxononanoate transaminase [Holophagales bacterium]	diamond	282	118	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales 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);;