metadata: contig_metadata: 18 rows where bioproject = "PRJNA670521", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJNA670521", 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
1914323	1914323	PRJNA670521_P_NODE_32322_length_350_cov_1.660650_g31577_i0	PRJNA670521	32322	350	1.66065	5.812275	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	200	1.92e-57	NR	MBY0375661.1	2212468	g31577	i0	88.8	0.994285714285714	116	13	99.4	0	348	1	551	666	MBY0375661.1 HAD-IC family P-type ATPase [Bryobacteraceae bacterium]	diamond	348	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
12117286	12117286	PRJNA670521_P_NODE_17190_length_449_cov_1.183511_g16448_i0	PRJNA670521	17190	449	1.183511	5.31396439	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	124	1.82e-33	NR	MDQ7008654.1	1978231	g16448	i0	77.5	0.594654788418708	89	19	59.5	1	444	178	24	111	MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium]	diamond	267	124	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19764984	19764984	PRJNA670521_P_NODE_2416_length_1122_cov_2.699714_g1932_i0	PRJNA670521	2416	1122	2.699714	30.29079108	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	466	3.93e-161	NR	MEM1181554.1	1978231	g1932	i0	62.8	3.85294117647059	360	133	96.3	1	18	1097	4	362	MEM1181554.1 alkene reductase [Acidobacteriota bacterium]	diamond	4323	466	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26872539	26872539	PRJNA670521_P_NODE_82481_length_246_cov_0.890173_g81736_i0	PRJNA670521	82481	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	110	6.07e-28	NR	MDQ3043056.1	1978231	g81736	i0	82.8	3.78048780487805	64	11	78	0	53	244	1	64	MDQ3043056.1 hypothetical protein [Acidobacteriota bacterium]	diamond	930	110	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28092392	28092392	PRJNA670521_P_NODE_81505_length_246_cov_0.890173_g80760_i0	PRJNA670521	81505	246	0.890173	2.18982558	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	45.8	0.00299	NR	HZT78566.1	2910147	g80760	i0	36	0.914634146341463	75	48	91.5	0	2	226	26	100	HZT78566.1 zinc-binding dehydrogenase [Vicinamibacterales bacterium]	diamond	225	45.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28913062	28913062	PRJNA670521_P_NODE_43788_length_312_cov_1.481172_g43043_i0	PRJNA670521	43788	312	1.481172	4.62125664	Terracidiphilus sp.	1964191	Bacteria	Bacteria	57.4	2.45e-8	NR	MDR3737750.1	1964191	g43043	i0	60	0.384615384615385	40	16	38.5	0	192	311	2	41	MDR3737750.1 hypothetical protein [Terracidiphilus sp.]	diamond	120	57.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
29071403	29071403	PRJNA670521_P_NODE_75008_length_249_cov_0.875000_g74263_i0	PRJNA670521	75008	249	0.875	2.17875	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	53.9	2.92e-6	NR	HUK13977.1	2699758	g74263	i0	44.6	0.674698795180723	56	30	67.5	1	171	4	26	80	HUK13977.1 hypothetical protein [Thermoanaerobaculaceae bacterium]	diamond	168	53.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
29765669	29765669	PRJNA670521_P_NODE_75931_length_249_cov_0.875000_g75186_i0	PRJNA670521	75931	249	0.875	2.17875	Terriglobia bacterium	2081523	Bacteria	Bacteria	48.9	2.68e-4	NR	MBZ5554703.1	2081523	g75186	i0	35.8	0.807228915662651	67	42	80.7	1	233	33	355	420	MBZ5554703.1 putative Ig domain-containing protein [Terriglobia bacterium]	diamond	201	48.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
30207775	30207775	PRJNA670521_P_NODE_33872_length_344_cov_1.738007_g33127_i0	PRJNA670521	33872	344	1.738007	5.97874408	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	167	2.03e-45	NR	MBY0375661.1	2212468	g33127	i0	85.8	0.98546511627907	113	16	98.5	0	342	4	171	283	MBY0375661.1 HAD-IC family P-type ATPase [Bryobacteraceae bacterium]	diamond	339	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
30398161	30398161	PRJNA670521_P_NODE_82913_length_245_cov_1.343023_g82168_i0	PRJNA670521	82913	245	1.343023	3.29040635	Terracidiphilus sp.	1964191	Bacteria	Bacteria	79.3	2.53e-17	NR	MDR3737750.1	1964191	g82168	i0	61.1	0.661224489795918	54	21	66.1	0	83	244	2	55	MDR3737750.1 hypothetical protein [Terracidiphilus sp.]	diamond	162	79.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
30429648	30429648	PRJNA670521_P_NODE_84613_length_245_cov_0.895349_g83868_i0	PRJNA670521	84613	245	0.895349	2.19360505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	115	4.88e-31	NR	MEO8075251.1	1978231	g83868	i0	79	0.991836734693878	81	17	99.2	0	243	1	14	94	MEO8075251.1 polymer-forming cytoskeletal protein [Acidobacteriota bacterium]	diamond	243	115	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30472928	30472928	PRJNA670521_P_NODE_52453_length_290_cov_1.069124_g51708_i0	PRJNA670521	52453	290	1.069124	3.1004596	Bacteria	2	Bacteria	Bacteria	43.9	0.0252	NR	HEV2245092.1	2081523	g51708	i0	31.2	3.34137931034483	109	50	92.1	6	3	269	95	198	HEV2245092.1 hypothetical protein [Terriglobia bacterium]	diamond	969	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
30567265	30567265	PRJNA670521_P_NODE_73033_length_250_cov_0.870056_g72288_i0	PRJNA670521	73033	250	0.870056	2.17514	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	48.1	5.14e-4	NR	HEV7429049.1	2651171	g72288	i0	48.8	1.704	41	21	49.2	0	240	118	23	63	HEV7429049.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	426	48.5	0.991752577319588	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30618771	30618771	PRJNA670521_P_NODE_82093_length_246_cov_0.890173_g81348_i0	PRJNA670521	82093	246	0.890173	2.18982558	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	149	6.2699999999999996e-40	NR	MDQ2745940.1	1978231	g81348	i0	80.5	1	82	16	100	0	246	1	502	583	MDQ2745940.1 DUF3857 and transglutaminase domain-containing protein [Acidobacteriota bacterium]	diamond	246	149	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30745209	30745209	PRJNA670521_P_NODE_51514_length_292_cov_1.406393_g50769_i0	PRJNA670521	51514	292	1.406393	4.10666756	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	123	2.7199999999999997e-30	NR	MBY0375661.1	2212468	g50769	i0	61.9	0.996575342465753	97	36	99.7	1	292	2	370	465	MBY0375661.1 HAD-IC family P-type ATPase [Bryobacteraceae bacterium]	diamond	291	123	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31725134	31725134	PRJNA670521_P_NODE_64197_length_263_cov_2.057895_g63452_i0	PRJNA670521	64197	263	2.057895	5.41226385	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	91.7	1.52e-19	NR	HYH47885.1	2651171	g63452	i0	59.5	0.958174904942966	84	30	95.8	3	252	1	164	243	HYH47885.1 thiolase family protein [Thermoanaerobaculia bacterium]	diamond	252	91.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
32073267	32073267	PRJNA670521_P_NODE_88298_length_243_cov_0.905882_g87553_i0	PRJNA670521	88298	243	0.905882	2.20129326	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	48.9	2.44e-4	NR	HEU4711796.1	2283092	g87553	i0	53.3	4.85185185185185	45	21	55.6	0	240	106	22	66	HEU4711796.1 ankyrin repeat domain-containing protein [Pyrinomonadaceae bacterium]	diamond	1179	48.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32548114	32548114	PRJNA670521_P_NODE_92759_length_241_cov_0.916667_g92014_i0	PRJNA670521	92759	241	0.916667	2.20916747	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42	0.00979	NR	MDQ3132426.1	1978231	g92014	i0	45.9	0.460580912863071	37	20	46.1	0	153	43	1	37	MDQ3132426.1 hypothetical protein [Acidobacteriota bacterium]	diamond	111	42	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);;