metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA977246" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA977246" 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
8921957	8921957	PRJNA977246_S_NODE_4907_length_734_cov_358.561702_g4288_i0	PRJNA977246	4907	734	358.561702	2631.84289268	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	166	1.08e-42	NR	MDQ3214113.1	1978231	g4288	i0	40.7	0.964577656675749	236	129	93.6	4	724	38	270	501	MDQ3214113.1 Ig-like domain repeat protein [Acidobacteriota bacterium]	diamond	708	166	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11155156	11155156	PRJNA977246_S_NODE_46449_length_162_cov_3.368421_g45457_i0	PRJNA977246	46449	162	3.368421	5.45684202	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	84	1.8e-17	NR	MEK6280361.1	1978231	g45457	i0	75.6	0.833333333333333	45	11	83.3	0	20	154	36	80	MEK6280361.1 hypothetical protein [Acidobacteriota bacterium]	diamond	135	84	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17528985	17528985	PRJNA977246_S_NODE_18254_length_330_cov_3.511628_g17262_i0	PRJNA977246	18254	330	3.511628	11.5883724	Bacteria	2	Bacteria	Bacteria	171	1.8700000000000002e-49	NR	MCC7180033.1	1978231	g17262	i0	79.1	3	110	23	100	0	1	330	212	321	MCC7180033.1 cysteine desulfurase [Acidobacteriota bacterium]	diamond	990	171	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
20395118	20395118	PRJNA977246_S_NODE_15716_length_365_cov_5450.809524_g14726_i0	PRJNA977246	15716	365	5450.809524	19895.4547626	Granulicella	940557	Bacteria	Bacteria	129	7.169999999999999e-32	NR	WP_317890972.1	940613	g14726	i0	80.2	1.24931506849315	81	15	66.6	1	20	262	215	294	WP_317890972.1 YjhG/YagF family D-xylonate dehydratase [Granulicella arctica]	diamond	456	129	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella arctica
24220489	24220489	PRJNA977246_S_NODE_25519_length_257_cov_7989.561404_g24527_i0	PRJNA977246	25519	257	7989.561404	20533.17280828	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	61.6	7.08e-10	NR	MFL6280472.1	2910147	g24527	i0	77.5	1.42412451361868	40	9	46.7	0	208	89	78	117	MFL6280472.1 STAS/SEC14 domain-containing protein [Vicinamibacterales bacterium]	diamond	366	61.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
26899665	26899665	PRJNA977246_S_NODE_51321_length_151_cov_2.327869_g50329_i0	PRJNA977246	51321	151	2.327869	3.51508219	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	80.5	7.97e-17	NR	HYO79788.1	2212468	g50329	i0	83	0.933774834437086	47	8	93.4	0	10	150	28	74	HYO79788.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	141	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
27310845	27310845	PRJNA977246_S_NODE_35203_length_200_cov_4.286550_g34211_i0	PRJNA977246	35203	200	4.28655	8.5731	uncultured Pyrinomonadaceae bacterium	2283094	Bacteria	Bacteria	100	5.5e-24	NR	CAA9388759.1	2283094	g34211	i0	84.5	0.87	58	9	87	0	174	1	207	264	CAA9388759.1 MAG: Short-chain dehydrogenase/reductase SDR? [uncultured Pyrinomonadaceae bacterium]	diamond	174	100	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		uncultured Pyrinomonadaceae bacterium
27973728	27973728	PRJNA977246_S_NODE_14205_length_391_cov_4.649171_g13220_i0	PRJNA977246	14205	391	4.649171	18.17825861	Terracidiphilus sp.	1964191	Bacteria	Bacteria	110	2.4800000000000003e-27	NR	HWA94887.1	1964191	g13220	i0	47.9	1.81841432225064	117	61	89.8	0	21	371	103	219	HWA94887.1 TetR/AcrR family transcriptional regulator [Terracidiphilus sp.]	diamond	711	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
28068419	28068419	PRJNA977246_S_NODE_26645_length_249_cov_4.213636_g25653_i0	PRJNA977246	26645	249	4.213636	10.49195364	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	56.2	6.47e-7	NR	MEP0774906.1	1978231	g25653	i0	72.5	0.481927710843373	40	11	48.2	0	63	182	130	169	MEP0774906.1 UPF0236 family protein [Acidobacteriota bacterium]	diamond	120	56.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28637008	28637008	PRJNA977246_S_NODE_14267_length_390_cov_4.526316_g13281_i0	PRJNA977246	14267	390	4.526316	17.6526324	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	94	7.07e-20	NR	MCM3879371.1	2910147	g13281	i0	65.1	1.36923076923077	86	26	66.2	2	264	7	10	91	MCM3879371.1 hypothetical protein [Vicinamibacterales bacterium]	diamond	534	94	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28794470	28794470	PRJNA977246_S_NODE_44727_length_167_cov_1.855072_g43735_i0	PRJNA977246	44727	167	1.855072	3.09797024	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	63.5	5.92e-10	NR	HLY16477.1	2212468	g43735	i0	55.8	2.7125748502994	52	23	93.4	0	166	11	58	109	HLY16477.1 glycosyltransferase family 4 protein [Bryobacteraceae bacterium]	diamond	453	63.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29047361	29047361	PRJNA977246_S_NODE_33108_length_210_cov_2.530387_g32116_i0	PRJNA977246	33108	210	2.530387	5.3138127	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	82.8	8.08e-17	NR	HYO81688.1	2212468	g32116	i0	76.5	0.728571428571429	51	12	72.9	0	56	208	200	250	HYO81688.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	153	82.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29709933	29709933	PRJNA977246_S_NODE_18930_length_322_cov_3.320819_g17938_i0	PRJNA977246	18930	322	3.320819	10.69303718	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	47	0.00296	NR	HUQ90326.1	2212468	g17938	i0	35.2	2.92546583850932	105	61	94.1	4	20	322	276	377	HUQ90326.1 phage/plasmid primase, P4 family [Bryobacteraceae bacterium]	diamond	942	47	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
29741609	29741609	PRJNA977246_S_NODE_37750_length_190_cov_2.229814_g36758_i0	PRJNA977246	37750	190	2.229814	4.2366466	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	115	4.32e-28	NR	MBI2150612.1	1978231	g36758	i0	87.3	0.994736842105263	63	6	96.3	1	8	190	527	589	MBI2150612.1 pyrroloquinoline quinone-dependent dehydrogenase [Acidobacteriota bacterium]	diamond	189	115	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30374114	30374114	PRJNA977246_S_NODE_42972_length_172_cov_1.902098_g41980_i0	PRJNA977246	42972	172	1.902098	3.27160856	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	77	1.19e-14	NR	HEX4966361.1	2651171	g41980	i0	68.4	1.97093023255814	57	18	99.4	0	171	1	195	251	HEX4966361.1 Ig-like domain-containing protein [Thermoanaerobaculia bacterium]	diamond	339	77	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30531585	30531585	PRJNA977246_S_NODE_27093_length_246_cov_3.004608_g26101_i0	PRJNA977246	27093	246	3.004608	7.39133568	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	151	5.18e-44	NR	HYO79788.1	2212468	g26101	i0	77.8	0.98780487804878	81	18	98.8	0	245	3	136	216	HYO79788.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	243	151	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31005613	31005613	PRJNA977246_S_NODE_29574_length_229_cov_3.610000_g28582_i0	PRJNA977246	29574	229	3.61	8.2669	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	45.1	0.00477	NR	MEM8933937.1	1978231	g28582	i0	37.5	2.80349344978166	72	45	94.3	0	1	216	442	513	MEM8933937.1 tetratricopeptide repeat protein [Acidobacteriota bacterium]	diamond	642	45.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31137848	31137848	PRJNA977246_S_NODE_9455_length_501_cov_2.870763_g8550_i0	PRJNA977246	9455	501	2.870763	14.38252263	Bacteria	2	Bacteria	Bacteria	258	5.6e-84	NR	MBI2835607.1	1978231	g8550	i0	72.6	20.2934131736527	168	40	99.4	3	498	1	44	207	MBI2835607.1 hypothetical protein [Acidobacteriota bacterium]	diamond	10167	260	0.992307692307692	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31258415	31258415	PRJNA977246_S_NODE_33315_length_209_cov_2.844444_g32323_i0	PRJNA977246	33315	209	2.844444	5.94488796	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	86.7	7.91e-18	NR	HEX7797361.1	2910147	g32323	i0	73.9	0.990430622009569	69	13	99	2	208	2	354	417	HEX7797361.1 flagellar basal-body MS-ring/collar protein FliF [Vicinamibacterales bacterium]	diamond	207	86.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31391231	31391231	PRJNA977246_S_NODE_39456_length_183_cov_4.175325_g38464_i0	PRJNA977246	39456	183	4.175325	7.64084475	Acidobacteriota	57723	Bacteria	Bacteria	65.9	1.12e-10	NR	WP_041856917.1	658062	g38464	i0	54.4	7.22950819672131	57	24	93.4	1	173	3	372	426	WP_041856917.1 3-phosphoshikimate 1-carboxyvinyltransferase [Candidatus Korobacter versatilis]	diamond	1323	65.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Korobacter	Candidatus Korobacter versatilis
31454454	31454454	PRJNA977246_S_NODE_40156_length_181_cov_2.513158_g39164_i0	PRJNA977246	40156	181	2.513158	4.54881598	Bacteria	2	Bacteria	Bacteria	64.7	2.82e-10	NR	MCA1602594.1	1978231	g39164	i0	46.6	6.69613259668508	58	31	96.1	0	179	6	580	637	MCA1602594.1 protein kinase [Acidobacteriota bacterium]	diamond	1212	64.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31480112	31480112	PRJNA977246_S_NODE_43276_length_171_cov_2.352113_g42284_i0	PRJNA977246	43276	171	2.352113	4.02211323	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	85.5	1.24e-17	NR	MDQ2921341.1	1978231	g42284	i0	81.6	0.859649122807018	49	9	86	0	1	147	541	589	MDQ2921341.1 YCF48-related protein [Acidobacteriota bacterium]	diamond	147	85.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31890983	31890983	PRJNA977246_S_NODE_19217_length_318_cov_3165.273356_g18225_i0	PRJNA977246	19217	318	3165.273356	10065.56927208	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	66.2	2.47e-10	NR	HWN84278.1	2910147	g18225	i0	88.9	0.339622641509434	36	4	34	0	196	89	1	36	HWN84278.1 creatininase family protein [Vicinamibacterales bacterium]	diamond	108	66.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
32112575	32112575	PRJNA977246_S_NODE_12658_length_421_cov_3.181122_g11687_i0	PRJNA977246	12658	421	3.181122	13.39252362	Geothrix sp.	1962974	Bacteria	Bacteria	127	1.4e-32	NR	MDP1830588.1	1962974	g11687	i0	88.6	1.99524940617577	70	8	49.9	0	7	216	255	324	MDP1830588.1 phosphate ABC transporter substrate-binding protein [Geothrix sp.]	diamond	840	127	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
32460691	32460691	PRJNA977246_S_NODE_29099_length_232_cov_3.630542_g28107_i0	PRJNA977246	29099	232	3.630542	8.42285744	Terriglobia bacterium	2081523	Bacteria	Bacteria	102	2.0299999999999998e-23	NR	HYR45037.1	2081523	g28107	i0	63.2	0.982758620689655	76	28	98.3	0	3	230	4	79	HYR45037.1 AAA family ATPase [Terriglobia bacterium]	diamond	228	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
32744601	32744601	PRJNA977246_S_NODE_4600_length_764_cov_4.129252_g4008_i0	PRJNA977246	4600	764	4.129252	31.54748528	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	231	8.359999999999998e-69	NR	HEX3231412.1	2283092	g4008	i0	88.4	0.541884816753927	138	16	54.2	0	740	327	414	551	HEX3231412.1 CSLREA domain-containing protein [Pyrinomonadaceae bacterium]	diamond	414	231	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae 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);;