metadata: contig_metadata: 14 rows where bioproject = "PRJNA782551", tax_phylum = "Acidobacteriota" and tax

14 rows where bioproject = "PRJNA782551", 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
3314877	3314877	PRJNA782551_P_NODE_13103_length_270_cov_1.365482_g12981_i0	PRJNA782551	13103	270	1.365482	3.6868014	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	248	2.94e-61	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g12981	i0	83.908	6.99259259259259	261	40	96	2	3	262	3054976	3055235	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	1888	248	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4591926	4591926	PRJNA782551_P_NODE_15624_length_251_cov_1.415730_g15502_i0	PRJNA782551	15624	251	1.41573	3.5534823	Bacteria	2	Bacteria	Bacteria	82.8	4.08e-17	NR	MBL8142375.1	1978231	g15502	i0	71.2	3.52589641434263	59	17	70.5	0	72	248	1	59	MBL8142375.1 glycosyltransferase family 2 protein [Acidobacteriota bacterium]	diamond	885	83.2	0.995192307692308	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10967712	10967712	PRJNA782551_P_NODE_13609_length_266_cov_1.404145_g13487_i0	PRJNA782551	13609	266	1.404145	3.7350257	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	130	5.14e-34	NR	MEJ7712721.1	2283092	g13487	i0	67.8	0.981203007518797	87	28	98.1	0	261	1	197	283	MEJ7712721.1 alcohol dehydrogenase catalytic domain-containing protein [Pyrinomonadaceae bacterium]	diamond	261	130	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
11416379	11416379	PRJNA782551_P_NODE_16329_length_251_cov_0.865169_g16207_i0	PRJNA782551	16329	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	149	1.1e-40	NR	MBA3269812.1	1978231	g16207	i0	85.2	1.94820717131474	81	12	96.8	0	1	243	296	376	MBA3269812.1 long-chain-fatty-acid--CoA ligase [Acidobacteriota bacterium]	diamond	489	150	0.993333333333333	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13517354	13517354	PRJNA782551_P_NODE_11851_length_280_cov_1.207729_g11729_i0	PRJNA782551	11851	280	1.207729	3.3816412	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	139	6.72e-36	NR	HLG58229.1	2910147	g11729	i0	72	2.94642857142857	93	26	99.6	0	280	2	188	280	HLG58229.1 LpqB family beta-propeller domain-containing protein [Vicinamibacterales bacterium]	diamond	825	139	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
13517436	13517436	PRJNA782551_P_NODE_17671_length_249_cov_0.875000_g17549_i0	PRJNA782551	17671	249	0.875	2.17875	uncultured Vicinamibacterales bacterium	3036250	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2546137835\|emb\|OY282382.1\|	3036250	g17549	i0	96.97	0.132530120481928	33	0	13	1	203	234	903674	903706	MAG: uncultured Vicinamibacterales bacterium isolate e65da963-7c29-4b68-91ce-224fd25ea74c genome assembly, chromosome: 1	blastn	33	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			uncultured Vicinamibacterales bacterium
17790208	17790208	PRJNA782551_P_NODE_19614_length_247_cov_0.885057_g19492_i0	PRJNA782551	19614	247	0.885057	2.18609079	Candidatus Solibacter	332162	Bacteria	Bacteria	385	1.94e-102	NTclustered	gi\|76574290\|gb\|DQ139438.1\|	171953	g19492	i0	94.758	101.97975708502	248	11	100	2	1	247	779	533	Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence	blastn	25189	385	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
27685756	27685756	PRJNA782551_P_NODE_14024_length_263_cov_1.252632_g13902_i0	PRJNA782551	14024	263	1.252632	3.29442216	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	53.9	8.73e-7	NR	MDM7922926.1	2283092	g13902	i0	92	0.285171102661597	25	2	28.5	0	187	261	1	25	MDM7922926.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	75	53.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27780301	27780301	PRJNA782551_P_NODE_14784_length_257_cov_1.673913_g14662_i0	PRJNA782551	14784	257	1.673913	4.30195641	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	73.2	8.47e-13	NR	MCL5742685.1	1978231	g14662	i0	50.6	0.992217898832685	85	42	99.2	0	256	2	19	103	MCL5742685.1 SpoIIE family protein phosphatase [Acidobacteriota bacterium]	diamond	255	73.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27884156	27884156	PRJNA782551_P_NODE_20605_length_246_cov_0.890173_g20483_i0	PRJNA782551	20605	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	127	1.89e-32	NR	MEO8043121.1	1978231	g20483	i0	74.1	4.92682926829268	81	21	98.8	0	3	245	396	476	MEO8043121.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Acidobacteriota bacterium]	diamond	1212	128	0.9921875	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29516590	29516590	PRJNA782551_P_NODE_11970_length_279_cov_1.330097_g11848_i0	PRJNA782551	11970	279	1.330097	3.71097063	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	94.7	3.02e-20	NR	MFN7971425.1	1978231	g11848	i0	55.4	2.56989247311828	83	37	89.2	0	277	29	8	90	MFN7971425.1 PKD domain-containing protein [Acidobacteriota bacterium]	diamond	717	94.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29841802	29841802	PRJNA782551_P_NODE_19691_length_247_cov_0.885057_g19569_i0	PRJNA782551	19691	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	143	1.13e-37	NR	MCA1620909.1	1978231	g19569	i0	84	1.95546558704453	81	13	98.4	0	245	3	490	570	MCA1620909.1 DUF4214 domain-containing protein [Acidobacteriota bacterium]	diamond	483	143	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30370019	30370019	PRJNA782551_P_NODE_19612_length_247_cov_0.885057_g19490_i0	PRJNA782551	19612	247	0.885057	2.18609079	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	49.3	1.98e-4	NR	MCI0387792.1	1978231	g19490	i0	37.8	2.27125506072874	90	42	92.3	2	1	228	13	102	MCI0387792.1 HEAT repeat domain-containing protein [Acidobacteriota bacterium]	diamond	561	49.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32803245	32803245	PRJNA782551_P_NODE_13080_length_270_cov_1.563452_g12958_i0	PRJNA782551	13080	270	1.563452	4.2213204	Luteitalea sp.	2004800	Bacteria	Bacteria	153	3.51e-41	NR	WP_291984931.1	2004800	g12958	i0	86.5	1.97777777777778	89	12	98.9	0	2	268	524	612	WP_291984931.1 thioredoxin domain-containing protein [Luteitalea sp.]	diamond	534	153	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea 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);;