metadata: contig_metadata: 35 rows where bioproject = "PRJNA195897" and tax

35 rows where bioproject = "PRJNA195897" 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
1640743	1640743	PRJNA195897_P_NODE_202_length_1110_cov_3.933082_g186_i0	PRJNA195897	202	1110	3.933082	43.6572102	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	306	1.3e-94	NR	MCB1054384.1	1978231	g186	i0	47.9	0.964864864864865	357	177	94.6	6	1097	48	93	447	MCB1054384.1 M4 family metallopeptidase [Acidobacteriota bacterium]	diamond	1071	306	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
2916677	2916677	PRJNA195897_P_NODE_5103_length_214_cov_0.945455_g5070_i0	PRJNA195897	5103	214	0.945455	2.0232737	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	130	8.47e-26	NTclustered	gi\|2874253959\|emb\|OY970284.1\|	2651171	g5070	i0	77.88	12.3224299065421	217	42	100	6	1	214	3500221	3500008	MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1	blastn	2637	130	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
4193085	4193085	PRJNA195897_P_NODE_4_length_4771_cov_3.249259_g3_i0	PRJNA195897	4	4771	3.249259	155.02214689	Blastocatellia bacterium	2052146	Bacteria	Bacteria	188	5.76e-44	NR	HMV46425.1	2052146	g3	i0	48.6	0.465311255501991	257	114	15.3	7	1911	1180	285	536	HMV46425.1 DUF4394 domain-containing protein [Blastocatellia bacterium]	diamond	2220	188	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
7433176	7433176	PRJNA195897_P_NODE_11226_length_164_cov_1.782609_g11193_i0	PRJNA195897	11226	164	1.782609	2.92347876	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	82	9.07e-17	NR	HEX6737292.1	2793154	g11193	i0	72.2	5.92682926829268	54	15	98.8	0	162	1	140	193	HEX6737292.1 isocitrate dehydrogenase (NAD(+)) [Vicinamibacteria bacterium]	diamond	972	82	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
8019398	8019398	PRJNA195897_P_NODE_947_length_546_cov_3.080483_g916_i0	PRJNA195897	947	546	3.080483	16.81943718	Sulfidibacter	2915177	Bacteria	Bacteria	242	2.03e-75	NR	MCB9397577.1	1978231	g916	i0	77.9	16.510989010989	149	33	81.9	0	99	545	7	155	MCB9397577.1 adenosylhomocysteinase [Acidobacteriota bacterium]	diamond	9015	242	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10570076	10570076	PRJNA195897_P_NODE_5889_length_201_cov_1.657895_g5856_i0	PRJNA195897	5889	201	1.657895	3.33236895	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g5856	i0	100	0.278606965174129	28	0	14	0	117	144	3145741	3145768	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
13119807	13119807	PRJNA195897_P_NODE_8271_length_175_cov_1.238095_g8238_i0	PRJNA195897	8271	175	1.238095	2.16666625	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	85.5	4.15e-18	NR	MFN7987048.1	2651171	g8238	i0	70.7	0.994285714285714	58	15	99.4	1	2	175	230	285	MFN7987048.1 zinc metalloprotease [Thermoanaerobaculia bacterium]	diamond	174	85.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22042600	22042600	PRJNA195897_P_NODE_2658_length_305_cov_1.375000_g2625_i0	PRJNA195897	2658	305	1.375	4.19375	Pseudomonadati	3379134	Bacteria	Bacteria	91.3	5.94e-19	NR	WP_158911805.1	204434	g2625	i0	79.6	11.5573770491803	49	10	48.2	0	3	149	352	400	WP_158911805.1 MULTISPECIES: decarboxylating NADP(+)-dependent phosphogluconate dehydrogenase [Acidobacteriaceae]	diamond	3525	91.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae
24592213	24592213	PRJNA195897_P_NODE_3180_length_275_cov_1.150442_g3147_i0	PRJNA195897	3180	275	1.150442	3.1637155	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	122	2.55e-33	NR	HKB79268.1	2651171	g3147	i0	60.4	0.992727272727273	91	36	99.3	0	1	273	28	118	HKB79268.1 GNAT family N-acetyltransferase [Thermoanaerobaculia bacterium]	diamond	273	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
26870577	26870577	PRJNA195897_P_NODE_7921_length_178_cov_1.209302_g7888_i0	PRJNA195897	7921	178	1.209302	2.15255756	root	1	Root_unresolved	Root_unresolved	55.5	5.08e-7	NR	HYU97546.1	2283092	g7888	i0	48.3	7.70224719101124	58	30	97.8	0	174	1	18	75	HYU97546.1 TonB family protein [Pyrinomonadaceae bacterium]	diamond	1371	55.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27231967	27231967	PRJNA195897_P_NODE_4223_length_233_cov_1.086957_g4190_i0	PRJNA195897	4223	233	1.086957	2.53260981	Blastocatellia bacterium	2052146	Bacteria	Bacteria	67	9.05e-11	NR	MFN0120391.1	2052146	g4190	i0	44.9	3.01287553648069	78	41	99.1	2	231	1	429	505	MFN0120391.1 M28 family peptidase [Blastocatellia bacterium]	diamond	702	67	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
27326859	27326859	PRJNA195897_P_NODE_8143_length_176_cov_1.228346_g8110_i0	PRJNA195897	8143	176	1.228346	2.16188896	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	41.6	0.0381	NR	HEX6730643.1	2283092	g8110	i0	43.5	0.784090909090909	46	25	78.4	1	172	35	238	282	HEX6730643.1 FhaA domain-containing protein [Pyrinomonadaceae bacterium]	diamond	138	41.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27547860	27547860	PRJNA195897_P_NODE_1644_length_406_cov_0.871148_g1611_i0	PRJNA195897	1644	406	0.871148	3.53686088	Thermoanaerobaculales bacterium	2873827	Bacteria	Bacteria	96.7	3.21e-21	NR	MCW8985116.1	2873827	g1611	i0	41.4	1.96551724137931	133	75	97.5	3	406	11	110	240	MCW8985116.1 alpha/beta hydrolase [Thermoanaerobaculales bacterium]	diamond	798	96.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales			Thermoanaerobaculales bacterium
27597408	27597408	PRJNA195897_P_NODE_484_length_769_cov_1.994444_g456_i0	PRJNA195897	484	769	1.994444	15.33727436	Pseudomonadati	3379134	Bacteria	Bacteria	322	1.58e-105	NR	MBX3297142.1	1978231	g456	i0	63.2	11.9960988296489	261	86	99.9	2	2	769	135	390	MBX3297142.1 acetyl-CoA hydrolase/transferase family protein [Acidobacteriota bacterium]	diamond	9225	325	0.990769230769231	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27863541	27863541	PRJNA195897_P_NODE_5205_length_212_cov_1.276074_g5172_i0	PRJNA195897	5205	212	1.276074	2.70527688	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	60.8	1e-8	NR	MBX3265733.1	1978231	g5172	i0	47.9	0.679245283018868	48	24	67.9	1	207	64	189	235	MBX3265733.1 hypothetical protein [Acidobacteriota bacterium]	diamond	144	60.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28179112	28179112	PRJNA195897_P_NODE_2986_length_285_cov_1.093220_g2953_i0	PRJNA195897	2986	285	1.09322	3.115677	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	54.3	5.31e-6	NR	HKN17167.1	2771375	g2953	i0	44.3	1.86315789473684	70	38	73.7	1	74	283	36	104	HKN17167.1 hypothetical protein [Candidatus Sulfotelmatobacter sp.]	diamond	531	54.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
28463705	28463705	PRJNA195897_P_NODE_1906_length_374_cov_1.427692_g1873_i0	PRJNA195897	1906	374	1.427692	5.33956808	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	58.9	3.49e-7	NR	MEO1367069.1	1978231	g1873	i0	33.7	2.64705882352941	92	57	73.8	1	373	98	609	696	MEO1367069.1 choice-of-anchor A family protein [Acidobacteriota bacterium]	diamond	990	58.9	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28653016	28653016	PRJNA195897_P_NODE_3687_length_252_cov_1.137931_g3654_i0	PRJNA195897	3687	252	1.137931	2.86758612	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	61.2	1.08e-8	NR	MDR3737318.1	2052142	g3654	i0	46.6	0.869047619047619	73	38	85.7	1	242	27	235	307	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	219	61.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
28747706	28747706	PRJNA195897_P_NODE_4247_length_232_cov_1.420765_g4214_i0	PRJNA195897	4247	232	1.420765	3.2961748	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	47	0.00107	NR	HST52493.1	2283092	g4214	i0	56.5	0.594827586206897	46	18	56.9	1	228	97	972	1017	HST52493.1 PQQ-dependent sugar dehydrogenase [Pyrinomonadaceae bacterium]	diamond	138	47	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28923233	28923233	PRJNA195897_P_NODE_11068_length_165_cov_0.896552_g11035_i0	PRJNA195897	11068	165	0.896552	1.4793108	Bacteria	2	Bacteria	Bacteria	49.7	4.25e-5	NR	MDX2436169.1	1978231	g11035	i0	53.5	2.34545454545455	43	20	78.2	0	157	29	193	235	MDX2436169.1 alpha/beta hydrolase [Acidobacteriota bacterium]	diamond	387	50.1	0.992015968063872	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29095142	29095142	PRJNA195897_P_NODE_10268_length_166_cov_1.615385_g10235_i0	PRJNA195897	10268	166	1.615385	2.6815391	Terriglobia bacterium	2081523	Bacteria	Bacteria	41.6	0.0348	NR	HEV2351301.1	2081523	g10235	i0	50	0.72289156626506	40	19	72.3	1	10	129	661	699	HEV2351301.1 bifunctional YncE family protein/alkaline phosphatase family protein [Terriglobia bacterium]	diamond	120	41.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
29112896	29112896	PRJNA195897_P_NODE_1388_length_450_cov_1.366584_g1355_i0	PRJNA195897	1388	450	1.366584	6.149628	Bacteria	2	Bacteria	Bacteria	47	0.0104	NR	MFN7973693.1	1978231	g1355	i0	40.7	1.21333333333333	54	31	35.3	1	436	278	229	282	MFN7973693.1 hypothetical protein [Acidobacteriota bacterium]	diamond	546	47	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29189903	29189903	PRJNA195897_P_NODE_9529_length_168_cov_0.873950_g9496_i0	PRJNA195897	9529	168	0.87395	1.468236	Blastocatellia bacterium	2052146	Bacteria	Bacteria	49.3	5.2e-5	NR	HEU4388188.1	2052146	g9496	i0	51.1	1.60714285714286	45	22	80.4	0	22	156	114	158	HEU4388188.1 metallophosphoesterase [Blastocatellia bacterium]	diamond	270	49.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
29284262	29284262	PRJNA195897_P_NODE_8229_length_175_cov_1.603175_g8196_i0	PRJNA195897	8229	175	1.603175	2.80555625	Blastocatellia bacterium	2052146	Bacteria	Bacteria	53.5	2.36e-6	NR	HEX9001155.1	2052146	g8196	i0	56.8	6.03428571428571	44	19	75.4	0	132	1	37	80	HEX9001155.1 hypothetical protein [Blastocatellia bacterium]	diamond	1056	53.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
29757936	29757936	PRJNA195897_P_NODE_2131_length_349_cov_1.960000_g2098_i0	PRJNA195897	2131	349	1.96	6.8404	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	61.6	1.06e-8	NR	HJU55860.1	2283092	g2098	i0	39.8	0.756446991404012	88	47	70.5	1	338	93	106	193	HJU55860.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	264	61.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30281727	30281727	PRJNA195897_P_NODE_6952_length_188_cov_1.496403_g6919_i0	PRJNA195897	6952	188	1.496403	2.81323764	Pseudomonadati	3379134	Bacteria	Bacteria	90.9	1.37e-20	NR	HMZ82411.1	1978231	g6919	i0	71	8.90425531914894	62	18	98.9	0	1	186	132	193	HMZ82411.1 zinc metalloprotease [Acidobacteriota bacterium]	diamond	1674	91.3	0.995618838992333	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30345050	30345050	PRJNA195897_P_NODE_7912_length_178_cov_1.279070_g7879_i0	PRJNA195897	7912	178	1.27907	2.2767446	Bacteria	2	Bacteria	Bacteria	44.3	0.00446	NR	MBV8895267.1	2052142	g7879	i0	40.7	3.9438202247191	59	34	99.4	1	177	1	66	123	MBV8895267.1 class I SAM-dependent methyltransferase [Acidobacteriaceae bacterium]	diamond	702	44.7	0.991051454138702	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
30674160	30674160	PRJNA195897_P_NODE_233_length_1059_cov_1.949505_g214_i0	PRJNA195897	233	1059	1.949505	20.64525795	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	90.1	1.58e-15	NR	MBI4907469.1	1978231	g214	i0	32.6	0.844192634560907	298	175	80.7	14	204	1058	320	604	MBI4907469.1 hypothetical protein [Acidobacteriota bacterium]	diamond	894	90.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31008039	31008039	PRJNA195897_P_NODE_4314_length_230_cov_1.419890_g4281_i0	PRJNA195897	4314	230	1.41989	3.265747	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	49.3	1.57e-4	NR	HKY42128.1	2283092	g4281	i0	46.8	1.78695652173913	62	30	80.9	2	9	194	601	659	HKY42128.1 Calx-beta domain-containing protein [Pyrinomonadaceae bacterium]	diamond	411	49.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
31337810	31337810	PRJNA195897_P_NODE_1156_length_495_cov_1.849776_g1125_i0	PRJNA195897	1156	495	1.849776	9.1563912	Terriglobales bacterium	2282142	Bacteria	Bacteria	185	4.3e-52	NR	HXY13262.1	2282142	g1125	i0	52.2	12.7454545454545	161	73	97.6	2	494	12	435	591	HXY13262.1 M2 family metallopeptidase [Terriglobales bacterium]	diamond	6309	185	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
32083194	32083194	PRJNA195897_P_NODE_878_length_572_cov_1.913958_g848_i0	PRJNA195897	878	572	1.913958	10.94783976	Bacteria	2	Bacteria	Bacteria	236	5.86e-73	NR	MCH8820063.1	1978231	g848	i0	60.9	22.1905594405594	184	70	96	2	5	553	16	198	MCH8820063.1 phosphoenolpyruvate carboxykinase (GTP) [Acidobacteriota bacterium]	diamond	12693	236	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32255689	32255689	PRJNA195897_P_NODE_9158_length_169_cov_0.866667_g9125_i0	PRJNA195897	9158	169	0.866667	1.46466723	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.4	0.0183	NR	MEL7061177.1	1978231	g9125	i0	47.2	0.940828402366864	53	24	94.1	2	167	9	123	171	MEL7061177.1 NAD(P)-binding domain-containing protein [Acidobacteriota bacterium]	diamond	159	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32476950	32476950	PRJNA195897_P_NODE_12359_length_162_cov_0.920354_g12326_i0	PRJNA195897	12359	162	0.920354	1.49097348	Silvibacterium sp.	1964179	Bacteria	Bacteria	45.4	9.29e-4	NR	HTA87488.1	1964179	g12326	i0	51.6	0.574074074074074	31	15	57.4	0	11	103	11	41	HTA87488.1 PAS domain S-box protein [Silvibacterium sp.]	diamond	93	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Silvibacterium	Silvibacterium sp.
32526574	32526574	PRJNA195897_P_NODE_7419_length_183_cov_1.552239_g7386_i0	PRJNA195897	7419	183	1.552239	2.84059737	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	3.02e-6	NR	NIL99891.1	1978231	g7386	i0	74.2	1.54098360655738	31	8	50.8	0	95	3	27	57	NIL99891.1 peptide-methionine (S)-S-oxide reductase MsrA [Acidobacteriota bacterium]	diamond	282	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32760566	32760566	PRJNA195897_P_NODE_1120_length_502_cov_2.203091_g1089_i0	PRJNA195897	1120	502	2.203091	11.05951682	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	77	5.3e-14	NR	MDX1390150.1	1978231	g1089	i0	35.8	1.13545816733068	95	61	56.8	0	304	20	4	98	MDX1390150.1 fatty acid desaturase [Acidobacteriota bacterium]	diamond	570	77	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);;