metadata: contig_metadata: 18 rows where bioproject = "PRJNA1174770" and tax

18 rows where bioproject = "PRJNA1174770" 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
1590898	1590898	PRJNA1174770_P_NODE_11142_length_163_cov_1.570175_g11053_i0	PRJNA1174770	11142	163	1.570175	2.55938525	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	171	3.59e-38	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g11053	i0	85.629	1.02453987730061	167	19	100	4	1	163	4333687	4333852	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	167	171	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
27344446	27344446	PRJNA1174770_P_NODE_10943_length_164_cov_0.895652_g10854_i0	PRJNA1174770	10943	164	0.895652	1.46886928	Bacteria	2	Bacteria	Bacteria	83.2	2.37e-17	NR	MCU1269745.1	2052142	g10854	i0	74.1	1.97560975609756	54	14	98.8	0	1	162	108	161	MCU1269745.1 Carbohydrate kinase [Acidobacteriaceae bacterium]	diamond	324	83.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
27577711	27577711	PRJNA1174770_P_NODE_6124_length_189_cov_1.228571_g6035_i0	PRJNA1174770	6124	189	1.228571	2.32199919	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	42.4	0.012	NR	MCA1630173.1	1978231	g6035	i0	43.9	0.650793650793651	41	23	65.1	0	163	41	55	95	MCA1630173.1 DUF3052 domain-containing protein [Acidobacteriota bacterium]	diamond	123	42.4	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27830273	27830273	PRJNA1174770_P_NODE_11224_length_163_cov_0.912281_g11135_i0	PRJNA1174770	11224	163	0.912281	1.48701803	Blastocatellia bacterium	2052146	Bacteria	Bacteria	100	7.83e-23	NR	HEX4949428.1	2052146	g11135	i0	85.2	0.993865030674847	54	8	99.4	0	162	1	77	130	HEX4949428.1 penicillin-binding protein 2 [Blastocatellia bacterium]	diamond	162	100	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
28303907	28303907	PRJNA1174770_P_NODE_11486_length_163_cov_0.903509_g11397_i0	PRJNA1174770	11486	163	0.903509	1.47271967	Terriglobia bacterium	2081523	Bacteria	Bacteria	107	2.7100000000000004e-26	NR	HEX2522213.1	2081523	g11397	i0	94.4	4.96932515337423	54	3	99.4	0	1	162	207	260	HEX2522213.1 AAA family ATPase [Terriglobia bacterium]	diamond	810	107	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
28430321	28430321	PRJNA1174770_P_NODE_10346_length_165_cov_0.879310_g10257_i0	PRJNA1174770	10346	165	0.87931	1.4508615	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	113	2.0900000000000003e-27	NR	MCX6604842.1	1978231	g10257	i0	90.9	4	55	5	100	0	1	165	117	171	MCX6604842.1 M14 family metallopeptidase [Acidobacteriota bacterium]	diamond	660	113	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29093439	29093439	PRJNA1174770_P_NODE_8828_length_167_cov_0.881356_g8739_i0	PRJNA1174770	8828	167	0.881356	1.47186452	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	102	1.2699999999999999e-23	NR	MBI4905112.1	1978231	g8739	i0	83.6	0.988023952095808	55	9	98.8	0	1	165	1028	1082	MBI4905112.1 BACON domain-containing protein [Acidobacteriota bacterium]	diamond	165	102	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29408954	29408954	PRJNA1174770_P_NODE_10589_length_164_cov_0.904348_g10500_i0	PRJNA1174770	10589	164	0.904348	1.48313072	Blastocatellia bacterium	2052146	Bacteria	Bacteria	50.8	7.29e-6	NR	HKQ75871.1	2052146	g10500	i0	58.7	0.841463414634146	46	19	84.1	0	26	163	110	155	HKQ75871.1 hypothetical protein [Blastocatellia bacterium]	diamond	138	50.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
29566788	29566788	PRJNA1174770_P_NODE_10030_length_165_cov_0.896552_g9941_i0	PRJNA1174770	10030	165	0.896552	1.4793108	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	44.7	0.00203	NR	HKC63948.1	2283092	g9941	i0	69	4.10909090909091	29	9	52.7	0	72	158	43	71	HKC63948.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	678	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29724460	29724460	PRJNA1174770_P_NODE_12370_length_162_cov_0.893805_g12281_i0	PRJNA1174770	12370	162	0.893805	1.4479641	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	95.9	1.39e-22	NR	MBL8136833.1	1978231	g12281	i0	80.8	0.962962962962963	52	10	96.3	0	161	6	187	238	MBL8136833.1 4'-phosphopantetheinyl transferase superfamily protein [Acidobacteriota bacterium]	diamond	156	95.9	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29945922	29945922	PRJNA1174770_P_NODE_10511_length_164_cov_1.365217_g10422_i0	PRJNA1174770	10511	164	1.365217	2.23895588	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	87.8	1.13e-18	NR	HJZ78612.1	2910147	g10422	i0	75.9	0.98780487804878	54	13	98.8	0	163	2	3	56	HJZ78612.1 serine hydrolase domain-containing protein [Vicinamibacterales bacterium]	diamond	162	87.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
29977384	29977384	PRJNA1174770_P_NODE_9751_length_166_cov_0.871795_g9662_i0	PRJNA1174770	9751	166	0.871795	1.4471797	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	81.3	4.04e-17	NR	MEM7244527.1	1978231	g9662	i0	80	0.813253012048193	45	9	81.3	0	32	166	1	45	MEM7244527.1 nitroreductase family protein [Acidobacteriota bacterium]	diamond	135	81.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31557787	31557787	PRJNA1174770_P_NODE_9056_length_167_cov_0.872881_g8967_i0	PRJNA1174770	9056	167	0.872881	1.45771127	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	106	2.76e-26	NR	MFN0166217.1	2212468	g8967	i0	92.7	0.988023952095808	55	4	98.8	0	165	1	188	242	MFN0166217.1 IclR family transcriptional regulator [Bryobacteraceae bacterium]	diamond	165	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32158768	32158768	PRJNA1174770_P_NODE_11038_length_164_cov_0.878261_g10949_i0	PRJNA1174770	11038	164	0.878261	1.44034804	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	85.1	1.49e-17	NR	MFN0172711.1	2212468	g10949	i0	73.6	4.68292682926829	53	14	97	0	161	3	164	216	MFN0172711.1 sigma 54-interacting transcriptional regulator [Bryobacteraceae bacterium]	diamond	768	85.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
32494410	32494410	PRJNA1174770_P_NODE_8379_length_168_cov_0.873950_g8290_i0	PRJNA1174770	8379	168	0.87395	1.468236	root	1	Root_unresolved	Root_unresolved	103	1.58e-24	NR	HEY5444984.1	2283092	g8290	i0	90.9	5.89285714285714	55	5	98.2	0	166	2	33	87	HEY5444984.1 terminase TerL endonuclease subunit [Pyrinomonadaceae bacterium]	diamond	990	103	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32632678	32632678	PRJNA1174770_P_NODE_11400_length_163_cov_0.912281_g11311_i0	PRJNA1174770	11400	163	0.912281	1.48701803	Bryobacter aggregatus	360054	Bacteria	Bacteria	68.9	5.27e-12	NR	WP_031500241.1	360054	g11311	i0	64.2	0.975460122699387	53	19	97.5	0	161	3	223	275	WP_031500241.1 D-alanine--D-alanine ligase family protein [Bryobacter aggregatus]	diamond	159	68.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Bryobacter	Bryobacter aggregatus
32664246	32664246	PRJNA1174770_P_NODE_9320_length_166_cov_0.888889_g9231_i0	PRJNA1174770	9320	166	0.888889	1.47555574	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	61.2	3.22e-9	NR	PYV81635.1	1978231	g9231	i0	62.3	0.957831325301205	53	19	95.8	1	6	164	146	197	PYV81635.1 MAG: hypothetical protein DMG05_29595 [Acidobacteriota bacterium]	diamond	159	61.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32683345	32683345	PRJNA1174770_P_NODE_8380_length_168_cov_0.873950_g8291_i0	PRJNA1174770	8380	168	0.87395	1.468236	Bacteria	2	Bacteria	Bacteria	99.4	4.37e-23	NR	MCX6630374.1	2068625	g8291	i0	81.8	3.92857142857143	55	10	98.2	0	166	2	247	301	MCX6630374.1 IS630 family transposase [Candidatus Solibacter sp.]	diamond	660	99.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter 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);;