metadata: contig_metadata: 13 rows where bioproject = "PRJNA1111448" and tax

13 rows where bioproject = "PRJNA1111448" 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_species
9146134	9146134	PRJNA1111448_S_NODE_88168_length_285_cov_1.971698_g87345_i0	PRJNA1111448	88168	285	1.971698	5.6193393	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	184	7.87e-53	NR	HTK37367.1	2283092	g87345	i0	98.9	20	95	1	100	0	285	1	110	204	HTK37367.1 molecular chaperone DnaK [Pyrinomonadaceae bacterium]	diamond	5700	184	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
11696869	11696869	PRJNA1111448_S_NODE_58850_length_330_cov_1.077821_g58027_i0	PRJNA1111448	58850	330	1.077821	3.5568093	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	291	6.0499999999999996e-74	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g58027	i0	86.517	18.9363636363636	267	33	80	3	1	265	266	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	6249	291	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
16795529	16795529	PRJNA1111448_S_NODE_88154_length_285_cov_2.014151_g87331_i0	PRJNA1111448	88154	285	2.014151	5.74033035	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	377	3.82e-100	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g87331	i0	90.592	190.178947368421	287	23	100	3	1	285	715777	716061	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	54201	377	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
18069178	18069178	PRJNA1111448_S_NODE_129755_length_246_cov_0.890173_g128932_i0	PRJNA1111448	129755	246	0.890173	2.18982558	Blastocatellia bacterium	2052146	Bacteria	Bacteria	85.1	5.04e-19	NR	MBK7993908.1	2052146	g128932	i0	97.8	0.548780487804878	45	1	54.9	0	3	137	87	131	MBK7993908.1 30S ribosomal protein S9 [Blastocatellia bacterium]	diamond	135	85.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia			Blastocatellia bacterium
26656076	26656076	PRJNA1111448_S_NODE_126941_length_247_cov_1.770115_g126118_i0	PRJNA1111448	126941	247	1.770115	4.37218405	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	143	3.56e-40	NR	MBI4853953.1	1978231	g126118	i0	92.7	0.995951417004049	82	6	99.6	0	246	1	199	280	MBI4853953.1 right-handed parallel beta-helix repeat-containing protein [Acidobacteriota bacterium]	diamond	246	143	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
27983777	27983777	PRJNA1111448_S_NODE_129965_length_246_cov_0.890173_g129142_i0	PRJNA1111448	129965	246	0.890173	2.18982558	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	134	6.91e-35	NR	MBI4850223.1	1978231	g129142	i0	80.2	0.98780487804878	81	16	98.8	0	2	244	65	145	MBI4850223.1 hypothetical protein [Acidobacteriota bacterium]	diamond	243	134	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
28385453	28385453	PRJNA1111448_S_NODE_126146_length_248_cov_0.880000_g125323_i0	PRJNA1111448	126146	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	87.4	4.76e-18	NR	MBK7993574.1	2052146	g125323	i0	81.3	3.96774193548387	48	9	58.1	0	105	248	7	54	MBK7993574.1 NAD(P)/FAD-dependent oxidoreductase [Blastocatellia bacterium]	diamond	984	87.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia			Blastocatellia bacterium
29111826	29111826	PRJNA1111448_S_NODE_136208_length_242_cov_1.822485_g135385_i0	PRJNA1111448	136208	242	1.822485	4.4104137	Bacteria	2	Bacteria	Bacteria	58.9	7.18e-8	NR	HYP51175.1	2283092	g135385	i0	42.5	2.97520661157025	80	46	99.2	0	241	2	454	533	HYP51175.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium]	diamond	720	58.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
30122059	30122059	PRJNA1111448_S_NODE_59712_length_328_cov_1.729412_g58889_i0	PRJNA1111448	59712	328	1.729412	5.67247136	Bacteria	2	Bacteria	Bacteria	139	3.61e-39	NR	MBA3631983.1	1978231	g58889	i0	66.1	2.96341463414634	109	37	99.7	0	1	327	42	150	MBA3631983.1 hypothetical protein [Acidobacteriota bacterium]	diamond	972	139	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30122060	30122060	PRJNA1111448_S_NODE_97732_length_274_cov_1.522388_g96909_i0	PRJNA1111448	97732	274	1.522388	4.17134312	Pseudomonadati	3379134	Bacteria	Bacteria	61.6	1.24e-8	NR	HSR68861.1	1978231	g96909	i0	54.1	5.51824817518248	61	26	66.8	1	21	203	151	209	HSR68861.1 Ig-like domain-containing protein [Acidobacteriota bacterium]	diamond	1512	61.6	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30478686	30478686	PRJNA1111448_S_NODE_85793_length_288_cov_2.148837_g84970_i0	PRJNA1111448	85793	288	2.148837	6.18865056	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	157	4.75e-42	NR	MBI4854314.1	1978231	g84970	i0	85.3	0.989583333333333	95	14	99	0	286	2	866	960	MBI4854314.1 VCBS repeat-containing protein [Acidobacteriota bacterium]	diamond	285	157	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
31395177	31395177	PRJNA1111448_S_NODE_131196_length_245_cov_1.255814_g130373_i0	PRJNA1111448	131196	245	1.255814	3.0767443	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	129	5.49e-33	NR	MEO6589169.1	2283092	g130373	i0	93	2.59591836734694	71	5	86.9	0	2	214	378	448	MEO6589169.1 signal recognition particle protein [Pyrinomonadaceae bacterium]	diamond	636	129	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae	Pyrinomonadaceae bacterium
32439289	32439289	PRJNA1111448_S_NODE_64399_length_320_cov_0.935223_g63576_i0	PRJNA1111448	64399	320	0.935223	2.9927136	Candidatus Polarisedimenticolia bacterium	3069555	Bacteria	Bacteria	45.1	0.0131	NR	HKQ98057.1	3069555	g63576	i0	38.2	0.7125	76	45	69.4	1	250	29	35	110	HKQ98057.1 YifB family Mg chelatase-like AAA ATPase [Candidatus Polarisedimenticolia bacterium]	diamond	228	45.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Candidatus Polarisedimenticolia			Candidatus Polarisedimenticolia 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);;