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

18 rows where bioproject = "PRJNA289590" 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
1647433	1647433	PRJNA289590_P_NODE_2_length_26078_cov_14.641746_g1_i0	PRJNA289590	2	26078	14.641746	3818.27452188	Pseudomonadati	3379134	Bacteria	Bacteria	902	1.32e-290	NR	WP_005034683.1	35839	g1	i0	70	2.9507630953294	690	201	7.9	2	2167	4233	1	685	WP_005034683.1 flagellar biosynthesis protein FlhA [Holophaga foetida]	diamond	76950	910	0.991208791208791	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	Holophaga foetida
13126183	13126183	PRJNA289590_P_NODE_14071_length_242_cov_1.393782_g13847_i0	PRJNA289590	14071	242	1.393782	3.37295244	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	80.5	1e-10	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g13847	i0	88.06	1.55371900826446	67	8	28	0	51	117	2362876	2362810	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	376	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
13126185	13126185	PRJNA289590_P_NODE_14111_length_242_cov_1.020725_g13887_i0	PRJNA289590	14111	242	1.020725	2.4701545	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	353	5.34e-93	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g13887	i0	94.714	100.028925619835	227	12	94	0	16	242	4651609	4651383	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	24207	353	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26884509	26884509	PRJNA289590_P_NODE_5661_length_411_cov_1.881215_g5437_i0	PRJNA289590	5661	411	1.881215	7.73179365	Terriglobales bacterium	2282142	Bacteria	Bacteria	47.4	0.00546	NR	HKR33070.1	2282142	g5437	i0	32.8	1.62773722627737	67	43	47.4	1	180	374	164	230	HKR33070.1 PAS domain S-box protein [Terriglobales bacterium]	diamond	669	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
28481411	28481411	PRJNA289590_P_NODE_27546_length_167_cov_0.881356_g27322_i0	PRJNA289590	27546	167	0.881356	1.47186452	Pseudomonadati	3379134	Bacteria	Bacteria	56.6	1.68e-7	NR	MBW4032803.1	1978231	g27322	i0	57.1	5.22754491017964	49	21	88	0	21	167	244	292	MBW4032803.1 M3 family metallopeptidase [Acidobacteriota bacterium]	diamond	873	56.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28779348	28779348	PRJNA289590_P_NODE_14707_length_236_cov_0.834225_g14483_i0	PRJNA289590	14707	236	0.834225	1.968771	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	93.6	1.5600000000000002e-21	NR	MFM8393176.1	1978231	g14483	i0	74.1	0.686440677966102	54	14	68.6	0	2	163	160	213	MFM8393176.1 hypothetical protein [Acidobacteriota bacterium]	diamond	162	93.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28874159	28874159	PRJNA289590_P_NODE_21108_length_193_cov_1.354167_g20884_i0	PRJNA289590	21108	193	1.354167	2.61354231	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	65.1	3.68e-11	NR	MEM7245756.1	1978231	g20884	i0	54.1	0.948186528497409	61	28	94.8	0	2	184	96	156	MEM7245756.1 GNAT family N-acetyltransferase [Acidobacteriota bacterium]	diamond	183	65.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
28874164	28874164	PRJNA289590_P_NODE_24748_length_174_cov_1.664000_g24524_i0	PRJNA289590	24748	174	1.664	2.89536	Geothrix sp.	1962974	Bacteria	Bacteria	87	3.24e-18	NR	HJW44006.1	1962974	g24524	i0	71.9	0.982758620689655	57	16	98.3	0	173	3	236	292	HJW44006.1 S28 family serine protease [Geothrix sp.]	diamond	171	87	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
29473844	29473844	PRJNA289590_P_NODE_23810_length_179_cov_1.600000_g23586_i0	PRJNA289590	23810	179	1.6	2.864	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	58.5	4.16e-8	NR	HEX2711882.1	2952895	g23586	i0	45.9	1.02234636871508	61	30	97.2	1	176	3	81	141	HEX2711882.1 hypothetical protein [Candidatus Acidiferrales bacterium]	diamond	183	58.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
29473851	29473851	PRJNA289590_P_NODE_30990_length_162_cov_0.920354_g30766_i0	PRJNA289590	30990	162	0.920354	1.49097348	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	72.4	4.4e-13	NR	HEX5601181.1	2283092	g30766	i0	67.3	4.85185185185185	52	17	96.3	0	7	162	664	715	HEX5601181.1 condensation domain-containing protein [Pyrinomonadaceae bacterium]	diamond	786	72.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30516486	30516486	PRJNA289590_P_NODE_26673_length_168_cov_0.873950_g26449_i0	PRJNA289590	26673	168	0.87395	1.468236	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	42	0.0254	NR	HXK11049.1	2793154	g26449	i0	38	1.66071428571429	50	30	87.5	1	2	148	352	401	HXK11049.1 hypothetical protein [Vicinamibacteria bacterium]	diamond	279	42	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
30737557	30737557	PRJNA289590_P_NODE_25954_length_169_cov_0.866667_g25730_i0	PRJNA289590	25954	169	0.866667	1.46466723	Terriglobales bacterium	2282142	Bacteria	Bacteria	63.9	4.49e-10	NR	HEU5402244.1	2282142	g25730	i0	48.2	3.85207100591716	56	29	99.4	0	2	169	66	121	HEU5402244.1 hypothetical protein [Terriglobales bacterium]	diamond	651	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
30832432	30832432	PRJNA289590_P_NODE_26014_length_169_cov_0.866667_g25790_i0	PRJNA289590	26014	169	0.866667	1.46466723	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	41.2	0.0493	NR	MDE3136122.1	1978231	g25790	i0	57.1	0.621301775147929	35	15	62.1	0	62	166	365	399	MDE3136122.1 oligopeptide:H+ symporter [Acidobacteriota bacterium]	diamond	105	41.2	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31085259	31085259	PRJNA289590_P_NODE_3875_length_523_cov_4.360759_g3657_i0	PRJNA289590	3875	523	4.360759	22.80676957	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	168	1.03e-47	NR	MFN3326867.1	2212468	g3657	i0	71	1.19885277246654	107	31	61.4	0	342	22	1	107	MFN3326867.1 hypothetical protein [Bryobacteraceae bacterium]	diamond	627	168	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31450779	31450779	PRJNA289590_P_NODE_9116_length_309_cov_2.119231_g8892_i0	PRJNA289590	9116	309	2.119231	6.54842379	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	1.89e-6	NR	HXK61697.1	1978231	g8892	i0	61.4	1.78640776699029	44	17	42.7	0	299	168	1	44	HXK61697.1 PKD domain-containing protein [Acidobacteriota bacterium]	diamond	552	56.2	0.99288256227758	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32129148	32129148	PRJNA289590_P_NODE_1918_length_871_cov_6.378345_g1722_i0	PRJNA289590	1918	871	6.378345	55.55538495	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	279	9.369999999999999e-91	NR	HEX6182357.1	2283092	g1722	i0	53.9	1.57749712973594	230	106	79.2	0	870	181	8	237	HEX6182357.1 HNH endonuclease [Pyrinomonadaceae bacterium]	diamond	1374	279	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32634625	32634625	PRJNA289590_P_NODE_27160_length_167_cov_1.762712_g26936_i0	PRJNA289590	27160	167	1.762712	2.94372904	Candidatus Sulfotelmatobacter sp.	2771375	Bacteria	Bacteria	81.3	2.93e-17	NR	HVI52293.1	2771375	g26936	i0	69.1	2.96407185628743	55	17	98.8	0	1	165	117	171	HVI52293.1 class I SAM-dependent methyltransferase [Candidatus Sulfotelmatobacter sp.]	diamond	495	81.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Sulfotelmatobacter	Candidatus Sulfotelmatobacter sp.
32760798	32760798	PRJNA289590_P_NODE_21940_length_189_cov_0.900000_g21716_i0	PRJNA289590	21940	189	0.9	1.701	Holophaga sp.	2582906	Bacteria	Bacteria	93.6	2.21e-20	NR	MBK8792650.1	2582906	g21716	i0	77	6.79365079365079	61	14	96.8	0	3	185	491	551	MBK8792650.1 chemotaxis protein CheA [Holophaga sp.]	diamond	1284	93.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	Holophaga 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);;