metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA934472" 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
4739546	4739546	PRJNA934472_P_NODE_35964_length_249_cov_0.875000_g35586_i0	PRJNA934472	35964	249	0.875	2.17875	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	141	1.1199999999999999e-38	NR	HMH53600.1	3069120	g35586	i0	88.7	0.855421686746988	71	8	85.5	0	1	213	266	336	HMH53600.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	213	141	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
12390285	12390285	PRJNA934472_P_NODE_32870_length_259_cov_3.446237_g32492_i0	PRJNA934472	32870	259	3.446237	8.92575383	Bacteria	2	Bacteria	Bacteria	169	1.07e-46	NR	MDQ3132639.1	1978231	g32492	i0	95.3	1.96911196911197	85	4	98.5	0	256	2	235	319	MDQ3132639.1 isoleucine--tRNA ligase [Acidobacteriota bacterium]	diamond	510	169	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17489398	17489398	PRJNA934472_P_NODE_31754_length_264_cov_1.450262_g31376_i0	PRJNA934472	31754	264	1.450262	3.82869168	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	173	1.13e-50	NR	MBA2736577.1	2283092	g31376	i0	92	16	88	7	100	0	264	1	89	176	MBA2736577.1 type IV pilus twitching motility protein PilT [Pyrinomonadaceae bacterium]	diamond	4224	173	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
26803328	26803328	PRJNA934472_P_NODE_38521_length_242_cov_0.911243_g38143_i0	PRJNA934472	38521	242	0.911243	2.20520806	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	116	1.58e-28	NR	HYC62907.1	2651171	g38143	i0	70	1.97107438016529	80	24	99.2	0	1	240	74	153	HYC62907.1 DUF4097 family beta strand repeat-containing protein [Thermoanaerobaculia bacterium]	diamond	477	116	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
27024958	27024958	PRJNA934472_P_NODE_30662_length_268_cov_1.989744_g30284_i0	PRJNA934472	30662	268	1.989744	5.33251392	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	97.4	2.11e-21	NR	HYI13064.1	2651171	g30284	i0	93.2	2.48507462686567	44	3	49.3	0	135	266	1	44	HYI13064.1 benzoyl-CoA 2,3-epoxidase subunit BoxB [Thermoanaerobaculia bacterium]	diamond	666	97.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
27182808	27182808	PRJNA934472_P_NODE_34762_length_252_cov_2.061453_g34384_i0	PRJNA934472	34762	252	2.061453	5.19486156	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	75.1	2.92e-15	NR	HET7436009.1	2651171	g34384	i0	72.9	1.10714285714286	48	13	57.1	0	144	1	14	61	HET7436009.1 hypothetical protein [Thermoanaerobaculia bacterium]	diamond	279	75.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
27214443	27214443	PRJNA934472_P_NODE_34382_length_254_cov_1.276243_g34004_i0	PRJNA934472	34382	254	1.276243	3.24165722	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	142	2.3e-40	NR	MDQ3132110.1	1978231	g34004	i0	79.8	0.992125984251969	84	17	99.2	0	1	252	96	179	MDQ3132110.1 YggS family pyridoxal phosphate-dependent enzyme [Acidobacteriota bacterium]	diamond	252	142	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27569056	27569056	PRJNA934472_P_NODE_33804_length_256_cov_1.420765_g33426_i0	PRJNA934472	33804	256	1.420765	3.6371584	Bacteria	2	Bacteria	Bacteria	155	9.079999999999998e-42	NR	MBK6725481.1	1978231	g33426	i0	86.9	3.9375	84	11	98.4	0	254	3	380	463	MBK6725481.1 formate dehydrogenase subunit alpha [Acidobacteriota bacterium]	diamond	1008	155	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28983192	28983192	PRJNA934472_P_NODE_27728_length_281_cov_1.298077_g27350_i0	PRJNA934472	27728	281	1.298077	3.64759637	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	143	1.5499999999999998e-37	NR	HEX8197557.1	2283092	g27350	i0	80.9	0.950177935943061	89	17	95	0	1	267	189	277	HEX8197557.1 amidohydrolase family protein [Pyrinomonadaceae bacterium]	diamond	267	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29014829	29014829	PRJNA934472_P_NODE_27428_length_282_cov_1.770335_g27050_i0	PRJNA934472	27428	282	1.770335	4.9923447	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	100	8.709999999999999e-23	NR	HXW08717.1	2910147	g27050	i0	79.3	3.45744680851064	58	12	61.7	0	2	175	334	391	HXW08717.1 pyridoxal phosphate-dependent aminotransferase [Vicinamibacterales bacterium]	diamond	975	100	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29519644	29519644	PRJNA934472_P_NODE_31310_length_266_cov_1.243523_g30932_i0	PRJNA934472	31310	266	1.243523	3.30777118	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	147	3.469999999999999e-42	NR	HLL99710.1	2283092	g30932	i0	77.9	0.969924812030075	86	19	97	0	3	260	82	167	HLL99710.1 GNAT family N-acetyltransferase [Pyrinomonadaceae bacterium]	diamond	258	147	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30467643	30467643	PRJNA934472_P_NODE_35493_length_250_cov_1.491525_g35115_i0	PRJNA934472	35493	250	1.491525	3.7288125	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	137	2.82e-35	NR	MDQ3132612.1	1978231	g35115	i0	87.8	1.968	82	10	98.4	0	3	248	349	430	MDQ3132612.1 hypothetical protein [Acidobacteriota bacterium]	diamond	492	137	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31700093	31700093	PRJNA934472_P_NODE_35777_length_249_cov_1.670455_g35399_i0	PRJNA934472	35777	249	1.670455	4.15943295	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	155	2.91e-43	NR	HSF14912.1	2793154	g35399	i0	100	0.987951807228916	82	0	98.8	0	247	2	82	163	HSF14912.1 YMGG-like glycine zipper-containing protein [Vicinamibacteria bacterium]	diamond	246	155	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
32774681	32774681	PRJNA934472_P_NODE_26140_length_288_cov_1.739535_g25762_i0	PRJNA934472	26140	288	1.739535	5.0098608	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	109	2.51e-25	NR	MDQ3130306.1	1978231	g25762	i0	44.6	1.91666666666667	184	13	99	2	286	2	170	353	MDQ3130306.1 prolyl oligopeptidase family serine peptidase [Acidobacteriota bacterium]	diamond	552	109	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);;