metadata: contig_metadata: 9 rows where bioproject = "PRJNA540466", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA540466", 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
27204069	27204069	PRJNA540466_S_NODE_58922_length_248_cov_1.320000_g58373_i0	PRJNA540466	58922	248	1.32	3.2736	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	84	1.24e-16	NR	MBX7171502.1	2283092	g58373	i0	58.8	0.82258064516129	68	28	82.3	0	224	21	185	252	MBX7171502.1 FG-GAP-like repeat-containing protein [Pyrinomonadaceae bacterium]	diamond	204	84	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27314161	27314161	PRJNA540466_S_NODE_61683_length_244_cov_2.005848_g61134_i0	PRJNA540466	61683	244	2.005848	4.89426912	Pseudomonadati	3379134	Bacteria	Bacteria	40.8	0.026	NR	HEX7705778.1	2651171	g61134	i0	35.7	1.35245901639344	56	25	57.8	2	191	51	7	60	HEX7705778.1 type II toxin-antitoxin system HicB family antitoxin [Thermoanaerobaculia bacterium]	diamond	330	41.2	0.990291262135922	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
27772992	27772992	PRJNA540466_S_NODE_41584_length_285_cov_2.207547_g41035_i0	PRJNA540466	41584	285	2.207547	6.29150895	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	86.3	2.46e-18	NR	HEY0080641.1	2283092	g41035	i0	57.4	1.49473684210526	68	29	71.6	0	2	205	132	199	HEY0080641.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	426	86.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28562238	28562238	PRJNA540466_S_NODE_10227_length_529_cov_1.824561_g9695_i0	PRJNA540466	10227	529	1.824561	9.65192769	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	261	2.94e-84	NR	HYP50651.1	2283092	g9695	i0	85.4	0.890359168241966	157	23	89	0	471	1	19	175	HYP50651.1 metallophosphoesterase [Pyrinomonadaceae bacterium]	diamond	471	261	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28972734	28972734	PRJNA540466_S_NODE_46528_length_272_cov_1.793970_g45979_i0	PRJNA540466	46528	272	1.79397	4.8795984	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	118	6.22e-30	NR	HKV12617.1	2651171	g45979	i0	64.8	0.970588235294118	88	31	97.1	0	267	4	247	334	HKV12617.1 isoaspartyl peptidase/L-asparaginase [Thermoanaerobaculia bacterium]	diamond	264	118	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
28987734	28987734	PRJNA540466_S_NODE_48848_length_267_cov_1.087629_g48299_i0	PRJNA540466	48848	267	1.087629	2.90396943	Pseudomonadati	3379134	Bacteria	Bacteria	62.4	6.36e-9	NR	MDH3530177.1	1978231	g48299	i0	69	2.30337078651685	42	13	47.2	0	267	142	1169	1210	MDH3530177.1 MG2 domain-containing protein [Acidobacteriota bacterium]	diamond	615	62.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30346014	30346014	PRJNA540466_S_NODE_26772_length_345_cov_6.025735_g26223_i0	PRJNA540466	26772	345	6.025735	20.78878575	Pseudomonadati	3379134	Bacteria	Bacteria	47	0.00404	NR	HEX4950403.1	2052146	g26223	i0	37.3	1.98260869565217	59	35	51.3	1	342	166	966	1022	HEX4950403.1 protein kinase [Blastocatellia bacterium]	diamond	684	47.4	0.991561181434599	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
31183392	31183392	PRJNA540466_S_NODE_31015_length_324_cov_1.083665_g30466_i0	PRJNA540466	31015	324	1.083665	3.5110746	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	75.1	2.05e-13	NR	HEX6284846.1	2283092	g30466	i0	45.6	2.49074074074074	90	40	83.3	3	25	294	219	299	HEX6284846.1 homoserine kinase [Pyrinomonadaceae bacterium]	diamond	807	75.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32795719	32795719	PRJNA540466_S_NODE_55900_length_252_cov_3.832402_g55351_i0	PRJNA540466	55900	252	3.832402	9.65765304	Terracidiphilus sp.	1964191	Bacteria	Bacteria	43.9	0.00375	NR	MDR3737751.1	1964191	g55351	i0	43.6	0.654761904761905	55	29	63.1	1	3	161	16	70	MDR3737751.1 hypothetical protein [Terracidiphilus sp.]	diamond	165	43.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus 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);;