metadata: contig_metadata: 11 rows where bioproject = "PRJNA657343", tax_phylum = "Acidobacteriota" and tax

11 rows where bioproject = "PRJNA657343", 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_genus	tax_species
19751100	19751100	PRJNA657343_S_NODE_31756_length_155_cov_5.047170_g31731_i0	PRJNA657343	31756	155	5.04717	7.8231135	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	254	3.25e-63	NTclustered	gi\|112980873\|gb\|DQ829677.1\|	171953	g31731	i0	96.129	101.025806451613	155	6	100	0	1	155	935	781	Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence	blastn	15659	254	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
27049850	27049850	PRJNA657343_P_NODE_16902_length_221_cov_0.895349_g16878_i0	PRJNA657343	16902	221	0.895349	1.97872129	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	42.7	0.0286	NR	HEY0514863.1	2651171	g16878	i0	35.2	0.963800904977376	71	44	93.7	2	218	12	543	613	HEY0514863.1 TIGR03032 family protein [Thermoanaerobaculia bacterium]	diamond	213	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
27839278	27839278	PRJNA657343_P_NODE_26164_length_188_cov_1.489209_g26140_i0	PRJNA657343	26164	188	1.489209	2.79971292	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	59.7	1.84e-8	NR	MES1243646.1	1978231	g26140	i0	54.5	2.68085106382979	55	25	87.8	0	171	7	405	459	MES1243646.1 Glu/Leu/Phe/Val dehydrogenase [Acidobacteriota bacterium]	diamond	504	59.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28439493	28439493	PRJNA657343_P_NODE_8926_length_280_cov_1.523810_g8902_i0	PRJNA657343	8926	280	1.52381	4.266668	Thermotomaculum hydrothermale	981385	Bacteria	Bacteria	82.4	3.89e-16	NR	WP_201328004.1	981385	g8902	i0	50.7	2.95714285714286	73	36	78.2	0	280	62	3	75	WP_201328004.1 molecular chaperone DnaJ [Thermotomaculum hydrothermale]	diamond	828	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Thermotomaculales	Thermotomaculaceae	Thermotomaculum	Thermotomaculum hydrothermale
28817911	28817911	PRJNA657343_P_NODE_14168_length_236_cov_1.064171_g14144_i0	PRJNA657343	14168	236	1.064171	2.51144356	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	58.2	1.23e-7	NR	MBA2603637.1	1978231	g14144	i0	44.3	2.46610169491525	61	33	77.5	1	188	6	364	423	MBA2603637.1 MBL fold metallo-hydrolase [Acidobacteriota bacterium]	diamond	582	58.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28881300	28881300	PRJNA657343_P_NODE_14308_length_235_cov_1.580645_g14284_i0	PRJNA657343	14308	235	1.580645	3.71451575	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	48.9	2.29e-4	NR	HEV7923420.1	2651171	g14284	i0	47.5	0.778723404255319	61	27	76.6	3	26	205	167	223	HEV7923420.1 M1 family metallopeptidase [Thermoanaerobaculia bacterium]	diamond	183	48.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
30397815	30397815	PRJNA657343_P_NODE_7533_length_298_cov_0.807229_g7509_i0	PRJNA657343	7533	298	0.807229	2.40554242	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	81.6	7.18e-16	NR	MDR3737318.1	2052142	g7509	i0	50	0.845637583892617	84	42	84.6	0	257	6	227	310	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	252	81.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
30492146	30492146	PRJNA657343_P_NODE_29053_length_181_cov_1.545455_g29029_i0	PRJNA657343	29053	181	1.545455	2.79727355	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	90.1	3.23e-19	NR	MDR3736461.1	2052142	g29029	i0	69.5	1.95580110497238	59	18	97.8	0	1	177	91	149	MDR3736461.1 chaperonin GroEL [Acidobacteriaceae bacterium]	diamond	354	90.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
31230846	31230846	PRJNA657343_P_NODE_37915_length_167_cov_0.881356_g37891_i0	PRJNA657343	37915	167	0.881356	1.47186452	Acidobacteriota	57723	Bacteria	Bacteria	52	1.06e-6	NR	HLI84642.1	2212468	g37891	i0	59.1	3.25149700598802	44	17	77.2	1	157	29	43	86	HLI84642.1 RNA-binding protein [Bryobacteraceae bacterium]	diamond	543	52.4	0.99236641221374	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31673721	31673721	PRJNA657343_P_NODE_38897_length_166_cov_0.888889_g38873_i0	PRJNA657343	38897	166	0.888889	1.47555574	Bacteria	2	Bacteria	Bacteria	48.1	1.67e-4	NR	MCC6131522.1	1978231	g38873	i0	44.2	5.92771084337349	52	29	94	0	159	4	242	293	MCC6131522.1 protein kinase [Acidobacteriota bacterium]	diamond	984	48.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32326383	32326383	PRJNA657343_P_NODE_41799_length_164_cov_0.904348_g41775_i0	PRJNA657343	41799	164	0.904348	1.48313072	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.4	0.0178	NR	PYR51180.1	1978231	g41775	i0	42.2	0.823170731707317	45	25	82.3	1	149	15	708	751	PYR51180.1 MAG: hypothetical protein DMF89_06935 [Acidobacteriota bacterium]	diamond	135	42.4	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);;