metadata: contig_metadata: 8 rows where bioproject = "PRJNA893346", tax_phylum = "Acidobacteriota" and tax

8 rows where bioproject = "PRJNA893346", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

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_species
11447023	11447023	PRJNA893346_P_NODE_32869_length_253_cov_1.283333_g32379_i0	PRJNA893346	32869	253	1.283333	3.24683249	Bacteria	2	Bacteria	Bacteria	134	5.569999999999998e-35	NR	HZP23708.1	2282142	g32379	i0	67.5	10.8142292490119	83	27	98.4	0	249	1	392	474	HZP23708.1 aldehyde dehydrogenase family protein [Terriglobales bacterium]	diamond	2736	134	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales		Terriglobales bacterium
21270090	21270090	PRJNA893346_P_NODE_26977_length_290_cov_2.110599_g26487_i0	PRJNA893346	26977	290	2.110599	6.1207371	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	114	8.36e-30	NR	MEO1085940.1	1978231	g26487	i0	70.3	2.32758620689655	74	22	76.6	0	12	233	1	74	MEO1085940.1 peptidylprolyl isomerase [Acidobacteriota bacterium]	diamond	675	114	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
26897525	26897525	PRJNA893346_P_NODE_16321_length_384_cov_0.990354_g15833_i0	PRJNA893346	16321	384	0.990354	3.80295936	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	138	7.38e-39	NR	MEJ7577361.1	2283092	g15833	i0	60.6	1.703125	109	43	85.2	0	58	384	7	115	MEJ7577361.1 pyridoxamine 5'-phosphate oxidase family protein [Pyrinomonadaceae bacterium]	diamond	654	138	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
27379690	27379690	PRJNA893346_P_NODE_24423_length_308_cov_1.948936_g23933_i0	PRJNA893346	24423	308	1.948936	6.00272288	Bacteria	2	Bacteria	Bacteria	162	1.26e-47	NR	OLD57858.1	1803441	g23933	i0	76.2	12.7207792207792	101	24	98.4	0	307	5	138	238	OLD57858.1 MAG: hypothetical protein AUI54_01120, partial [Acidobacteria bacterium 13_1_40CM_2_56_5]	diamond	3918	163	0.993865030674847	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteria bacterium 13_1_40CM_2_56_5
27592873	27592873	PRJNA893346_P_NODE_39024_length_242_cov_0.911243_g38534_i0	PRJNA893346	39024	242	0.911243	2.20520806	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	137	2.6299999999999996e-37	NR	HLK17486.1	2212468	g38534	i0	85	9.91735537190083	80	12	99.2	0	1	240	190	269	HLK17486.1 aldehyde dehydrogenase family protein [Bryobacteraceae bacterium]	diamond	2400	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacteraceae bacterium
30750782	30750782	PRJNA893346_P_NODE_35174_length_248_cov_0.880000_g34684_i0	PRJNA893346	35174	248	0.88	2.1824	Bryobacterales bacterium	2026791	Bacteria	Bacteria	40.8	0.0322	NR	MCZ2154825.1	2026791	g34684	i0	44.4	0.653225806451613	54	28	62.9	2	195	40	21	74	MCZ2154825.1 hypothetical protein [Bryobacterales bacterium]	diamond	162	40.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium
32395271	32395271	PRJNA893346_P_NODE_28659_length_280_cov_1.222222_g28169_i0	PRJNA893346	28659	280	1.222222	3.4222216	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	55.1	7.85e-7	NR	HEX7280516.1	2910147	g28169	i0	42.9	0.6	56	32	60	0	3	170	92	147	HEX7280516.1 universal stress protein [Vicinamibacterales bacterium]	diamond	168	55.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales		Vicinamibacterales bacterium
32836715	32836715	PRJNA893346_P_NODE_31120_length_264_cov_1.481675_g30630_i0	PRJNA893346	31120	264	1.481675	3.911622	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	44.7	0.00348	NR	HXK11615.1	2793154	g30630	i0	40.6	0.727272727272727	64	33	67	1	243	67	67	130	HXK11615.1 hypothetical protein [Vicinamibacteria bacterium]	diamond	192	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria			Vicinamibacteria 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);;