metadata: contig_metadata: 27 rows where bioproject = "PRJNA1198392" and tax

27 rows where bioproject = "PRJNA1198392" 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
1599400	1599400	PRJNA1198392_P_NODE_5522_length_341_cov_1.723881_g5381_i0	PRJNA1198392	5522	341	1.723881	5.87843421	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	508	1.59e-139	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g5381	i0	93.567	110.202346041056	342	20	100	2	1	341	4355647	4355987	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	37579	508	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1599461	1599461	PRJNA1198392_P_NODE_9002_length_287_cov_1.350467_g8861_i0	PRJNA1198392	9002	287	1.350467	3.87584029	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	464	2.8799999999999993e-126	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g8861	i0	95.848	176.574912891986	289	8	100	3	1	287	4575094	4575380	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	50677	464	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
2875280	2875280	PRJNA1198392_P_NODE_13923_length_262_cov_1.629630_g13782_i0	PRJNA1198392	13923	262	1.62963	4.2696306	Paludibaculum fermentans	1473598	Bacteria	Bacteria	292	1.2899999999999999e-74	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g13782	i0	87.072	142.675572519084	263	29	99	5	2	262	4786067	4786326	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	37381	292	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
6146596	6146596	PRJNA1198392_P_NODE_19865_length_244_cov_0.900585_g19724_i0	PRJNA1198392	19865	244	0.900585	2.1974274	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	178	7.46e-50	NR	HEX8197776.1	2283092	g19724	i0	97.5	1.99180327868852	81	2	99.6	0	1	243	391	471	HEX8197776.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	486	178	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
7421708	7421708	PRJNA1198392_P_NODE_8686_length_288_cov_1.790698_g8545_i0	PRJNA1198392	8686	288	1.790698	5.15721024	Bacteria	2	Bacteria	Bacteria	418	2.28e-112	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g8545	i0	93.056	118.381944444444	288	17	100	3	1	288	3298965	3298681	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	34094	418	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9252464	9252464	PRJNA1198392_P_NODE_15448_length_252_cov_1.720670_g15307_i0	PRJNA1198392	15448	252	1.72067	4.3360884	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	420	5.44e-113	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g15307	i0	97.177	98.8690476190476	248	7	98	0	5	252	3918452	3918205	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	24915	420	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12522427	12522427	PRJNA1198392_P_NODE_15670_length_251_cov_1.432584_g15529_i0	PRJNA1198392	15670	251	1.432584	3.59578584	Geothrix	44675	Bacteria	Bacteria	76.8	1.35e-9	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g15529	i0	88.889	1.01593625498008	63	6	25	1	190	251	3112970	3113032	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	255	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
12522444	12522444	PRJNA1198392_P_NODE_20590_length_242_cov_0.911243_g20449_i0	PRJNA1198392	20590	242	0.911243	2.20520806	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	136	3.869999999999999e-37	NR	HEX4783608.1	2771375	g20449	i0	85	2.96280991735537	80	12	99.2	0	241	2	202	281	HEX4783608.1 xanthine dehydrogenase family protein subunit M [Candidatus Sulfotelmatobacter sp.]	diamond	717	136	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
13078170	13078170	PRJNA1198392_P_NODE_17411_length_248_cov_0.880000_g17270_i0	PRJNA1198392	17411	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	108	9.35e-26	NR	HYK90489.1	1978231	g17270	i0	66.3	3.93145161290323	80	27	96.8	0	243	4	312	391	HYK90489.1 phosphoglycerate kinase [Acidobacteriota bacterium]	diamond	975	109	0.990825688073395	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
20725951	20725951	PRJNA1198392_P_NODE_18357_length_246_cov_1.780347_g18216_i0	PRJNA1198392	18357	246	1.780347	4.37965362	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g18216	i0	100	101.69512195122	246	0	100	0	1	246	4356430	4356675	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	25017	455	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
26787837	26787837	PRJNA1198392_P_NODE_11681_length_274_cov_1.532338_g11540_i0	PRJNA1198392	11681	274	1.532338	4.19860612	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	97.1	1.66e-21	NR	MFT3743348.1	2283092	g11540	i0	59	3.64598540145985	83	34	90.9	0	25	273	1	83	MFT3743348.1 M20 family metallopeptidase [Pyrinomonadaceae bacterium]	diamond	999	97.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
26914252	26914252	PRJNA1198392_P_NODE_21062_length_241_cov_1.523810_g20921_i0	PRJNA1198392	21062	241	1.52381	3.6723821	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	164	1.8299999999999998e-47	NR	MDI9627488.1	1978231	g20921	i0	92.4	1.95435684647303	79	6	98.3	0	239	3	252	330	MDI9627488.1 sugar kinase [Acidobacteriota bacterium]	diamond	471	164	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26914253	26914253	PRJNA1198392_P_NODE_7902_length_293_cov_1.722727_g7761_i0	PRJNA1198392	7902	293	1.722727	5.04759011	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	62.8	1.46e-9	NR	HVE59804.1	2283092	g7761	i0	75	1.22866894197952	40	10	41	0	138	19	1	40	HVE59804.1 enoyl-CoA hydratase/isomerase family protein [Pyrinomonadaceae bacterium]	diamond	360	62.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27009132	27009132	PRJNA1198392_P_NODE_8822_length_288_cov_1.153488_g8681_i0	PRJNA1198392	8822	288	1.153488	3.32204544	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	82	3.49e-16	NR	HEX8736880.1	2283092	g8681	i0	55.2	1.34375	67	30	69.8	0	287	87	197	263	HEX8736880.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	387	82	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27672925	27672925	PRJNA1198392_P_NODE_17844_length_247_cov_1.770115_g17703_i0	PRJNA1198392	17844	247	1.770115	4.37218405	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	102	1.0099999999999999e-23	NR	MEW6321406.1	1978231	g17703	i0	60.2	1.06882591093117	88	28	98.4	2	5	247	233	320	MEW6321406.1 serine hydrolase domain-containing protein [Acidobacteriota bacterium]	diamond	264	102	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27849384	27849384	PRJNA1198392_P_NODE_17744_length_248_cov_0.880000_g17603_i0	PRJNA1198392	17744	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	92.8	2.22e-21	NR	MBK8812984.1	1978231	g17603	i0	63.8	4.59677419354839	69	25	83.5	0	248	42	62	130	MBK8812984.1 PqqD family protein [Acidobacteriota bacterium]	diamond	1140	92.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28070525	28070525	PRJNA1198392_P_NODE_20265_length_243_cov_0.905882_g20124_i0	PRJNA1198392	20265	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	98.6	2.65e-22	NR	NWG14980.1	1978231	g20124	i0	60.5	3.79012345679012	76	30	93.8	0	231	4	160	235	NWG14980.1 hypothetical protein [Acidobacteriota bacterium]	diamond	921	98.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28083131	28083131	PRJNA1198392_P_NODE_10465_length_280_cov_1.487923_g10324_i0	PRJNA1198392	10465	280	1.487923	4.1661844	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	98.6	1.95e-22	NR	HEY0376946.1	2283092	g10324	i0	58	2.83928571428571	88	37	94.3	0	272	9	48	135	HEY0376946.1 NADP-dependent oxidoreductase [Pyrinomonadaceae bacterium]	diamond	795	98.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29220057	29220057	PRJNA1198392_P_NODE_19009_length_245_cov_0.895349_g18868_i0	PRJNA1198392	19009	245	0.895349	2.19360505	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	106	1.17e-24	NR	HEX8265742.1	2283092	g18868	i0	72.5	0.979591836734694	80	22	98	0	4	243	394	473	HEX8265742.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	240	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30439196	30439196	PRJNA1198392_P_NODE_21333_length_241_cov_0.916667_g21192_i0	PRJNA1198392	21333	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	119	8.69e-32	NR	MBW8827398.1	1978231	g21192	i0	77.2	5.88796680497925	79	18	98.3	0	239	3	17	95	MBW8827398.1 oligoribonuclease [Acidobacteriota bacterium]	diamond	1419	119	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30988914	30988914	PRJNA1198392_P_NODE_8474_length_289_cov_1.425926_g8333_i0	PRJNA1198392	8474	289	1.425926	4.12092614	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	84.3	3.31e-19	NR	HEX8636701.1	2283092	g8333	i0	88.6	0.456747404844291	44	5	45.7	0	156	287	1	44	HEX8636701.1 MM0924 family protein [Pyrinomonadaceae bacterium]	diamond	132	84.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
31052253	31052253	PRJNA1198392_P_NODE_16635_length_250_cov_0.870056_g16494_i0	PRJNA1198392	16635	250	0.870056	2.17514	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	83.6	1.75e-16	NR	HEY0321330.1	2283092	g16494	i0	49.4	1.02	85	41	99.6	2	250	2	501	585	HEY0321330.1 ABC transporter permease [Pyrinomonadaceae bacterium]	diamond	255	83.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
31260550	31260550	PRJNA1198392_P_NODE_16555_length_250_cov_0.870056_g16414_i0	PRJNA1198392	16555	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	159	9.55e-45	NR	KXK00717.1	1617423	g16414	i0	91.6	9.96	83	7	99.6	0	2	250	161	243	KXK00717.1 MAG: excinuclease ABC subunit C [Acidobacteria bacterium OLB17]	diamond	2490	159	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium OLB17
31431326	31431326	PRJNA1198392_P_NODE_15776_length_251_cov_0.865169_g15635_i0	PRJNA1198392	15776	251	0.865169	2.17157419	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	55.8	5.47e-8	NR	HYP08473.1	2212468	g15635	i0	55.6	1.64940239043825	54	24	64.5	0	89	250	1	54	HYP08473.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	414	55.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31589710	31589710	PRJNA1198392_P_NODE_16556_length_250_cov_0.870056_g16415_i0	PRJNA1198392	16556	250	0.870056	2.17514	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	133	1.1199999999999999e-38	NR	MDQ3129976.1	1978231	g16415	i0	93.8	3.12	65	4	78	0	250	56	13	77	MDQ3129976.1 sorbosone dehydrogenase family protein [Acidobacteriota bacterium]	diamond	780	133	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31842394	31842394	PRJNA1198392_P_NODE_8577_length_289_cov_1.226852_g8436_i0	PRJNA1198392	8577	289	1.226852	3.54560228	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	91.3	5.25e-19	NR	MCW5961948.1	2283092	g8436	i0	65.2	0.685121107266436	66	23	68.5	0	199	2	411	476	MCW5961948.1 methyltransferase regulatory domain-containing protein [Pyrinomonadaceae bacterium]	diamond	198	91.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32759190	32759190	PRJNA1198392_P_NODE_11680_length_274_cov_1.532338_g11539_i0	PRJNA1198392	11680	274	1.532338	4.19860612	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	130	5.92e-36	NR	MBK6589609.1	1978231	g11539	i0	70.3	1.99270072992701	91	27	99.6	0	1	273	30	120	MBK6589609.1 BON domain-containing protein [Acidobacteriota bacterium]	diamond	546	130	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota 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);;