metadata: contig_metadata: 19 rows where bioproject = "PRJNA376117", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJNA376117", 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
6777407	6777407	PRJNA376117_P_NODE_19546_length_312_cov_3.096234_g19244_i0	PRJNA376117	19546	312	3.096234	9.66025008	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	518	2.39e-142	NTclustered	gi\|112980846\|gb\|DQ829650.1\|	171953	g19244	i0	96.774	102.842948717949	310	10	99	0	1	310	402	711	Uncultured Acidobacteria bacterium clone DON11 23S ribosomal RNA gene, partial sequence	blastn	32087	518	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8052949	8052949	PRJNA376117_P_NODE_17887_length_327_cov_1.003937_g17585_i0	PRJNA376117	17887	327	1.003937	3.28287399	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	532	9.009999999999999e-147	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g17585	i0	96.865	154.865443425076	319	9	98	1	9	327	3299329	3299012	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	50641	532	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13153560	13153560	PRJNA376117_P_NODE_22771_length_290_cov_1.419355_g22469_i0	PRJNA376117	22771	290	1.419355	4.1161295	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	339	1.84e-88	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g22469	i0	88.153	99.5034482758621	287	31	98	3	1	284	317277	317563	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	28856	339	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13153752	13153752	PRJNA376117_P_NODE_36431_length_249_cov_0.875000_g36129_i0	PRJNA376117	36431	249	0.875	2.17875	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g36129	i0	91.968	241.208835341365	249	20	100	0	1	249	320856	320608	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	60061	350	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
20801347	20801347	PRJNA376117_P_NODE_28537_length_270_cov_1.563452_g28235_i0	PRJNA376117	28537	270	1.563452	4.2213204	Pseudomonadati	3379134	Bacteria	Bacteria	131	6.46e-34	NR	WP_124849713.1	2305226	g28235	i0	73.3	11.1777777777778	86	23	95.6	0	5	262	221	306	WP_124849713.1 ethanolamine permease [Acidipila sp. EB88]	diamond	3018	131	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidipila	Acidipila sp. EB88
22076314	22076314	PRJNA376117_P_NODE_23838_length_286_cov_2.154930_g23536_i0	PRJNA376117	23838	286	2.15493	6.1630998	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	65.8	3.4e-6	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g23536	i0	81.111	0.706293706293706	90	9	30	8	156	241	6285369	6285454	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	202	65.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
22750544	22750544	PRJNA376117_P_NODE_29658_length_266_cov_1.595855_g29356_i0	PRJNA376117	29658	266	1.595855	4.2449743	Pseudomonadati	3379134	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|321161386\|gb\|CP002480.1\|	1198114	g29356	i0	100	1.24812030075188	30	0	17	0	139	168	1030149	1030120	Granulicella tundricola MP5ACTX9, complete genome	blastn	332	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
27201111	27201111	PRJNA376117_P_NODE_12862_length_379_cov_1.483660_g12560_i0	PRJNA376117	12862	379	1.48366	5.6230714	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	51.2	1.45e-4	NR	HYL77325.1	2212468	g12560	i0	31.3	2.84168865435356	67	41	49.1	1	188	3	56	122	HYL77325.1 PDZ domain-containing protein [Bryobacteraceae bacterium]	diamond	1077	51.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
27770081	27770081	PRJNA376117_P_NODE_42404_length_243_cov_0.905882_g42102_i0	PRJNA376117	42404	243	0.905882	2.20129326	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	43.1	0.0256	NR	HEX5108493.1	2910147	g42102	i0	42.9	0.777777777777778	63	34	76.5	2	56	241	212	273	HEX5108493.1 PEP-CTERM sorting domain-containing protein [Vicinamibacterales bacterium]	diamond	189	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
27959257	27959257	PRJNA376117_P_NODE_32125_length_257_cov_1.353261_g31823_i0	PRJNA376117	32125	257	1.353261	3.47788077	Bryobacterales bacterium	2026791	Bacteria	Bacteria	63.9	8.12e-10	NR	MBL8210625.1	2026791	g31823	i0	48.1	0.945525291828794	81	39	91.1	2	246	13	116	196	MBL8210625.1 sel1 repeat family protein [Bryobacterales bacterium]	diamond	243	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
27991000	27991000	PRJNA376117_P_NODE_36705_length_248_cov_1.760000_g36403_i0	PRJNA376117	36705	248	1.76	4.3648	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	137	3.89e-36	NR	HEY8560309.1	2283092	g36403	i0	90.2	0.991935483870968	82	7	99.2	1	1	246	63	143	HEY8560309.1 FHA domain-containing protein [Pyrinomonadaceae bacterium]	diamond	246	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28481592	28481592	PRJNA376117_P_NODE_32226_length_256_cov_2.431694_g31924_i0	PRJNA376117	32226	256	2.431694	6.22513664	Candidatus Sulfomarinibacter	2885991	Bacteria	Bacteria	115	1.55e-27	NR	MEJ2189956.1	1978231	g31924	i0	61	2.90625	82	32	96.1	0	5	250	410	491	MEJ2189956.1 penicillin acylase family protein [Acidobacteriota bacterium]	diamond	744	115	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28559373	28559373	PRJNA376117_P_NODE_30427_length_263_cov_1.621053_g30125_i0	PRJNA376117	30427	263	1.621053	4.26336939	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	46.6	0.00197	NR	HET6959177.1	2910147	g30125	i0	42.6	0.695817490494297	61	33	67.3	1	247	71	289	349	HET6959177.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	183	46.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29176389	29176389	PRJNA376117_P_NODE_14529_length_359_cov_2.590909_g14227_i0	PRJNA376117	14529	359	2.590909	9.30136331	Pseudomonadati	3379134	Bacteria	Bacteria	126	2.6e-31	NR	HWT97031.1	2282142	g14227	i0	87.1	1.03621169916435	62	8	51.8	0	357	172	438	499	HWT97031.1 acetolactate synthase large subunit [Terriglobales bacterium]	diamond	372	126	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
29253581	29253581	PRJNA376117_P_NODE_26369_length_278_cov_1.453659_g26067_i0	PRJNA376117	26369	278	1.453659	4.04117202	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	45.4	0.0012	NR	MBA4123672.1	1978231	g26067	i0	40	0.809352517985611	75	41	77.7	2	17	232	22	95	MBA4123672.1 hypothetical protein [Acidobacteriota bacterium]	diamond	225	45.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30218307	30218307	PRJNA376117_P_NODE_40752_length_244_cov_1.801170_g40450_i0	PRJNA376117	40752	244	1.80117	4.3948548	Pseudomonadati	3379134	Bacteria	Bacteria	47.4	8.83e-4	NR	PYR21723.1	1978231	g40450	i0	47.2	2.23770491803279	53	26	65.2	2	164	6	394	444	PYR21723.1 MAG: hypothetical protein DMF94_07085 [Acidobacteriota bacterium]	diamond	546	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30928097	30928097	PRJNA376117_P_NODE_27194_length_275_cov_1.519802_g26892_i0	PRJNA376117	27194	275	1.519802	4.1794555	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	82	8.19e-16	NR	MDX1630233.1	2651171	g26892	i0	49.4	3.79636363636364	87	39	94.9	3	15	275	48	129	MDX1630233.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	1044	82	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
31324260	31324260	PRJNA376117_P_NODE_26355_length_278_cov_1.492683_g26053_i0	PRJNA376117	26355	278	1.492683	4.14965874	Bacteria	2	Bacteria	Bacteria	104	8.91e-24	NR	WP_231966680.1	392734	g26053	i0	52.7	21	91	43	98.2	0	274	2	255	345	WP_231966680.1 beta-L-arabinofuranosidase domain-containing protein [Terriglobus roseus]	diamond	5838	105	0.990476190476191	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
31908188	31908188	PRJNA376117_P_NODE_45097_length_232_cov_2.421384_g44795_i0	PRJNA376117	45097	232	2.421384	5.61761088	Terriglobales bacterium	2282142	Bacteria	Bacteria	53.5	5.38e-7	NR	HEX6803366.1	2282142	g44795	i0	38.1	1.08620689655172	84	43	97	2	3	227	15	98	HEX6803366.1 RNA-binding protein [Terriglobales bacterium]	diamond	252	53.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales 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);;