metadata: contig_metadata: 6 rows where bioproject = "PRJNA1105232", tax_kingdom = "Pseudomonadati" and tax

6 rows where bioproject = "PRJNA1105232", 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
26837657	26837657	PRJNA1105232_S_NODE_18361_length_155_cov_2.226415_g18145_i0	PRJNA1105232	18361	155	2.226415	3.45094325	Pseudomonadati	3379134	Bacteria	Bacteria	73.2	2.06e-13	NR	MCM3870453.1	2283092	g18145	i0	58	2.90322580645161	50	21	96.8	0	2	151	438	487	MCM3870453.1 aldehyde dehydrogenase (NADP(+)) [Pyrinomonadaceae bacterium]	diamond	450	73.9	0.990527740189445	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27478487	27478487	PRJNA1105232_S_NODE_2503_length_346_cov_1.845118_g2287_i0	PRJNA1105232	2503	346	1.845118	6.38410828	Acanthopleuribacter pedis	442870	Bacteria	Bacteria	105	8.09e-24	NR	WP_207857133.1	442870	g2287	i0	49.1	1.95086705202312	114	56	98.8	2	343	2	328	439	WP_207857133.1 M28 family metallopeptidase [Acanthopleuribacter pedis]	diamond	675	105	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Acanthopleuribacterales	Acanthopleuribacteraceae	Acanthopleuribacter	Acanthopleuribacter pedis
28046810	28046810	PRJNA1105232_S_NODE_3805_length_295_cov_1.991870_g3589_i0	PRJNA1105232	3805	295	1.99187	5.8760165	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	51.6	2.43e-6	NR	MFN3330291.1	2283092	g3589	i0	50	0.528813559322034	52	23	52.9	1	156	1	6	54	MFN3330291.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	156	51.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28646844	28646844	PRJNA1105232_S_NODE_1047_length_478_cov_8.762238_g835_i0	PRJNA1105232	1047	478	8.762238	41.88349764	Blastocatellia bacterium	2052146	Bacteria	Bacteria	120	4.54e-28	NR	MFN7944981.1	2052146	g835	i0	47.4	3.92887029288703	156	79	96.7	3	4	465	338	492	MFN7944981.1 S8 family serine peptidase [Blastocatellia bacterium]	diamond	1878	120	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
30352604	30352604	PRJNA1105232_S_NODE_3412_length_308_cov_2.606178_g3196_i0	PRJNA1105232	3412	308	2.606178	8.02702824	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	45.1	0.0117	NR	HEV7859644.1	2283092	g3196	i0	48.3	0.564935064935065	58	24	52.6	3	265	104	54	109	HEV7859644.1 D-Ala-D-Ala carboxypeptidase family metallohydrolase [Pyrinomonadaceae bacterium]	diamond	174	45.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32461912	32461912	PRJNA1105232_S_NODE_959_length_493_cov_11.545045_g747_i0	PRJNA1105232	959	493	11.545045	56.91707185	Pseudomonadati	3379134	Bacteria	Bacteria	148	4.64e-38	NR	MFN7944981.1	2052146	g747	i0	48.8	5.81135902636917	160	77	94.3	2	492	28	342	501	MFN7944981.1 S8 family serine peptidase [Blastocatellia bacterium]	diamond	2865	148	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia 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);;