metadata: contig_metadata: 16 rows where bioproject = "PRJNA603943", tax_kingdom = "Pseudomonadati" and tax

16 rows where bioproject = "PRJNA603943", tax_kingdom = "Pseudomonadati" 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
9506323	9506323	PRJNA603943_P_NODE_64668_length_244_cov_0.900585_g64476_i0	PRJNA603943	64668	244	0.900585	2.1974274	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g64476	i0	96.97	0.364754098360656	33	1	14	0	179	211	6729796	6729764	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	89	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
18429642	18429642	PRJNA603943_P_NODE_54135_length_250_cov_1.576271_g53943_i0	PRJNA603943	54135	250	1.576271	3.9406775	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	287	5.7e-73	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g53943	i0	87.402	72.844	254	27	100	4	1	250	4840751	4840499	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	18211	287	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21544951	21544951	PRJNA603943_P_NODE_23337_length_361_cov_3.017361_g23145_i0	PRJNA603943	23337	361	3.017361	10.89267321	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	186	1.1099999999999999e-54	NR	HVN76182.1	2699758	g23145	i0	71.7	3.98891966759003	120	34	99.7	0	2	361	277	396	HVN76182.1 citrate (Si)-synthase [Thermoanaerobaculaceae bacterium]	diamond	1440	186	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
21545212	21545212	PRJNA603943_P_NODE_65877_length_243_cov_1.358824_g65685_i0	PRJNA603943	65877	243	1.358824	3.30194232	Bacteria	2	Bacteria	Bacteria	108	4.61e-19	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g65685	i0	88.636	33.679012345679	88	10	36	0	156	243	3433815	3433902	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	8184	108	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
26681631	26681631	PRJNA603943_P_NODE_54101_length_250_cov_1.740113_g53909_i0	PRJNA603943	54101	250	1.740113	4.3502825	Pseudomonadati	3379134	Bacteria	Bacteria	53.9	2.77e-6	NR	MBZ5591012.1	2081523	g53909	i0	42.6	2.568	68	36	80.4	2	233	33	158	223	MBZ5591012.1 7-carboxy-7-deazaguanine synthase QueE [Terriglobia bacterium]	diamond	642	53.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
27396210	27396210	PRJNA603943_P_NODE_17023_length_407_cov_2.757485_g16831_i0	PRJNA603943	17023	407	2.757485	11.22296395	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	125	4.589999999999999e-31	NR	HSE24136.1	2283092	g16831	i0	50	0.899262899262899	122	58	87.7	1	396	40	350	471	HSE24136.1 aminotransferase class V-fold PLP-dependent enzyme [Pyrinomonadaceae bacterium]	diamond	366	125	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27490871	27490871	PRJNA603943_P_NODE_58483_length_248_cov_0.880000_g58291_i0	PRJNA603943	58483	248	0.88	2.1824	Terriglobia bacterium	2081523	Bacteria	Bacteria	42.7	0.0383	NR	HZT70379.1	2081523	g58291	i0	50	0.459677419354839	38	16	46	1	172	59	362	396	HZT70379.1 bifunctional glutamate N-acetyltransferase/amino-acid acetyltransferase ArgJ [Terriglobia bacterium]	diamond	114	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
27680506	27680506	PRJNA603943_P_NODE_10024_length_505_cov_1.034722_g9833_i0	PRJNA603943	10024	505	1.034722	5.2253461	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	111	8.91e-25	NR	WP_260705149.1	1933044	g9833	i0	43.3	0.837623762376238	141	75	82	3	2	415	1302	1440	WP_260705149.1 Ig-like domain repeat protein [Edaphobacter flagellatus]	diamond	423	111	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
28154027	28154027	PRJNA603943_P_NODE_24865_length_353_cov_1.100000_g24673_i0	PRJNA603943	24865	353	1.1	3.883	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	83.2	5.63e-16	NR	HEY6242829.1	2283092	g24673	i0	47.7	0.747875354107649	88	44	73.1	2	3	260	292	379	HEY6242829.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	264	83.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29605863	29605863	PRJNA603943_P_NODE_53610_length_251_cov_0.865169_g53418_i0	PRJNA603943	53610	251	0.865169	2.17157419	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	119	5.8599999999999994e-30	NR	HEY4901929.1	2771375	g53418	i0	65.5	2.00796812749004	84	28	99.2	1	249	1	76	159	HEY4901929.1 acyltransferase [Candidatus Sulfotelmatobacter sp.]	diamond	504	119	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
29682284	29682284	PRJNA603943_P_NODE_3670_length_770_cov_2.053085_g3497_i0	PRJNA603943	3670	770	2.053085	15.8087545	Pseudomonadati	3379134	Bacteria	Bacteria	97.8	2.1500000000000003e-21	NR	HPS68479.1	2582906	g3497	i0	46.8	2.13506493506494	111	57	42.9	2	444	115	42	151	HPS68479.1 Hsp20/alpha crystallin family protein [Holophaga sp.]	diamond	1644	97.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	Holophaga sp.
30142810	30142810	PRJNA603943_P_NODE_69572_length_241_cov_0.916667_g69380_i0	PRJNA603943	69572	241	0.916667	2.20916747	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	42.4	0.0495	NR	MFI5058729.1	2952895	g69380	i0	45.8	0.597510373443983	48	22	59.8	1	46	189	244	287	MFI5058729.1 hypothetical protein [Candidatus Acidiferrales bacterium]	diamond	144	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
30333219	30333219	PRJNA603943_P_NODE_59572_length_247_cov_0.885057_g59380_i0	PRJNA603943	59572	247	0.885057	2.18609079	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	116	5.51e-28	NR	HMJ92195.1	3069120	g59380	i0	76.3	0.97165991902834	80	19	97.2	0	7	246	99	178	HMJ92195.1 di-heme oxidoredictase family protein [Candidatus Acidiferrum sp.]	diamond	240	116	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
31153835	31153835	PRJNA603943_P_NODE_49535_length_261_cov_1.159574_g49343_i0	PRJNA603943	49535	261	1.159574	3.02648814	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	68.2	7.81e-12	NR	HEY4050133.1	2052142	g49343	i0	88.6	0.402298850574713	35	4	40.2	0	156	260	46	80	HEY4050133.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	105	68.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
31438723	31438723	PRJNA603943_P_NODE_63836_length_245_cov_0.895349_g63644_i0	PRJNA603943	63836	245	0.895349	2.19360505	Blastocatellia bacterium	2052146	Bacteria	Bacteria	73.2	7.29e-13	NR	HMZ20540.1	2052146	g63644	i0	66.1	1.44489795918367	59	20	72.2	0	67	243	387	445	HMZ20540.1 FG-GAP repeat protein [Blastocatellia bacterium]	diamond	354	73.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
31470640	31470640	PRJNA603943_P_NODE_70216_length_241_cov_0.916667_g70024_i0	PRJNA603943	70216	241	0.916667	2.20916747	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	43.1	0.00349	NR	HJY92050.1	3069120	g70024	i0	50	0.423236514522822	34	17	42.3	0	104	3	1	34	HJY92050.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	102	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.

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);;