metadata: contig_metadata: 18 rows where bioproject = "PRJNA975724", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJNA975724", tax_kingdom = "Pseudomonadati" 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
4774187	4774187	PRJNA975724_S_NODE_30624_length_346_cov_1.692308_g30443_i0	PRJNA975724	30624	346	1.692308	5.85538568	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	88.6	3.33e-18	NR	MEM9293740.1	1978231	g30443	i0	41.4	0.858381502890173	99	56	85.8	1	2	298	214	310	MEM9293740.1 serine protease [Acidobacteriota bacterium]	diamond	297	88.6	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9873684	9873684	PRJNA975724_S_NODE_1668_length_697_cov_2.687500_g1508_i0	PRJNA975724	1668	697	2.6875	18.731875	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	780	0	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g1508	i0	87.776	340.200860832138	679	68	96	14	1	672	317922	317252	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	237120	780	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15294710	15294710	PRJNA975724_S_NODE_15952_length_407_cov_3.401198_g15771_i0	PRJNA975724	15952	407	3.401198	13.84287586	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	132	1.46e-36	NR	MBI4750349.1	1978231	g15771	i0	64.2	2.04176904176904	95	34	70	0	391	107	46	140	MBI4750349.1 RidA family protein [Acidobacteriota bacterium]	diamond	831	132	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15294729	15294729	PRJNA975724_S_NODE_28132_length_354_cov_2.807829_g27951_i0	PRJNA975724	28132	354	2.807829	9.93971466	Bacteria	2	Bacteria	Bacteria	122	3.77e-33	NR	OFV82256.1	1797171	g27951	i0	54.9	5.1271186440678	102	45	86.4	1	330	25	33	133	OFV82256.1 MAG: CoA-binding protein [Acidobacteria bacterium RBG_13_68_16]	diamond	1815	122	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium RBG_13_68_16
18798751	18798751	PRJNA975724_S_NODE_7135_length_483_cov_13.078049_g6954_i0	PRJNA975724	7135	483	13.078049	63.16697667	Geothrix sp.	1962974	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g6954	i0	100	0.12008281573499	30	0	6	0	284	313	1874545	1874516	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	58	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
21348118	21348118	PRJNA975724_S_NODE_377_length_1070_cov_2.296891_g321_i0	PRJNA975724	377	1070	2.296891	24.5767337	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	1496	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g321	i0	91.922	173.084112149533	1077	75	100	11	1	1070	3300090	3299019	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	185200	1496	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27310704	27310704	PRJNA975724_S_NODE_29183_length_350_cov_10.079422_g29002_i0	PRJNA975724	29183	350	10.079422	35.277977	Terracidiphilus sp.	1964191	Bacteria	Bacteria	44.3	0.0338	NR	MDR3739218.1	1964191	g29002	i0	38.8	0.685714285714286	80	46	66.9	2	88	321	112	190	MDR3739218.1 glycosyltransferase family 39 protein [Terracidiphilus sp.]	diamond	240	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
27500096	27500096	PRJNA975724_S_NODE_19143_length_390_cov_6.031546_g18962_i0	PRJNA975724	19143	390	6.031546	23.5230294	Terriglobales bacterium	2282142	Bacteria	Bacteria	72.4	7.89e-12	NR	HSY98728.1	2282142	g18962	i0	44.3	2.33846153846154	79	40	60	2	2	235	604	679	HSY98728.1 M13 family metallopeptidase [Terriglobales bacterium]	diamond	912	72.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
29646611	29646611	PRJNA975724_S_NODE_72150_length_259_cov_2.897849_g71969_i0	PRJNA975724	72150	259	2.897849	7.50542891	Holophagales bacterium	2478486	Bacteria	Bacteria	77	3.93e-14	NR	MBK9090875.1	2478486	g71969	i0	52.1	5.07335907335907	73	34	84.6	1	253	35	664	735	MBK9090875.1 penicillin acylase family protein [Holophagales bacterium]	diamond	1314	77	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
29709801	29709801	PRJNA975724_S_NODE_22350_length_376_cov_1.452145_g22169_i0	PRJNA975724	22350	376	1.452145	5.4600652	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	137	1.4e-36	NR	MEM7050594.1	1978231	g22169	i0	63.5	0.829787234042553	104	38	83	0	2	313	231	334	MEM7050594.1 NADP-dependent oxidoreductase [Acidobacteriota bacterium]	diamond	312	137	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30190126	30190126	PRJNA975724_S_NODE_30912_length_345_cov_1.698529_g30731_i0	PRJNA975724	30912	345	1.698529	5.85992505	Pseudomonadati	3379134	Bacteria	Bacteria	129	7.579999999999998e-32	NR	HMV85460.1	2052146	g30731	i0	72.2	20.4260869565217	79	22	68.7	0	336	100	1942	2020	HMV85460.1 alpha-2-macroglobulin family protein [Blastocatellia bacterium]	diamond	7047	129	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
30279144	30279144	PRJNA975724_S_NODE_90992_length_241_cov_1.375000_g90811_i0	PRJNA975724	90992	241	1.375	3.31375	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	149	4.8099999999999985e-43	NR	HEY0460243.1	2283092	g90811	i0	93.8	6.95850622406639	80	5	99.6	0	2	241	138	217	HEY0460243.1 RNA polymerase sigma factor [Pyrinomonadaceae bacterium]	diamond	1677	149	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30689386	30689386	PRJNA975724_S_NODE_52833_length_292_cov_1.054795_g52652_i0	PRJNA975724	52833	292	1.054795	3.0800014	Edaphobacter modestus	388466	Bacteria	Bacteria	71.6	4.62e-12	NR	WP_165420076.1	388466	g52652	i0	47.9	0.986301369863014	96	48	98.6	2	3	290	157	250	WP_165420076.1 beta strand repeat-containing protein [Edaphobacter modestus]	diamond	288	71.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter modestus
30695705	30695705	PRJNA975724_S_NODE_25113_length_365_cov_2.770548_g24932_i0	PRJNA975724	25113	365	2.770548	10.1125002	Bacteria	2	Bacteria	Bacteria	101	1.76e-22	NR	HTB16640.1	2212468	g24932	i0	77	10.5534246575342	61	14	50.1	0	2	184	338	398	HTB16640.1 acyl-CoA dehydrogenase family protein [Bryobacteraceae bacterium]	diamond	3852	101	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
31384954	31384954	PRJNA975724_S_NODE_38996_length_322_cov_1.855422_g38815_i0	PRJNA975724	38996	322	1.855422	5.97445884	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	50.4	1.83e-4	NR	MEE8199672.1	2952895	g38815	i0	70.6	0.316770186335404	34	10	31.7	0	283	182	575	608	MEE8199672.1 protein kinase [Candidatus Acidiferrales bacterium]	diamond	102	50.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
31384959	31384959	PRJNA975724_S_NODE_57656_length_283_cov_1.100000_g57475_i0	PRJNA975724	57656	283	1.1	3.113	Candidatus Polarisedimenticolaceae bacterium	2910585	Bacteria	Bacteria	55.5	1.96e-6	NR	HEX6849897.1	2910585	g57475	i0	71.4	0.742049469964664	35	10	37.1	0	282	178	399	433	HEX6849897.1 citrate (Si)-synthase, eukaryotic [Candidatus Polarisedimenticolaceae bacterium]	diamond	210	55.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Candidatus Polarisedimenticolia	Candidatus Polarisedimenticolales	Candidatus Polarisedimenticolaceae		Candidatus Polarisedimenticolaceae bacterium
32150337	32150337	PRJNA975724_S_NODE_52818_length_292_cov_1.054795_g52637_i0	PRJNA975724	52818	292	1.054795	3.0800014	Bacteria	2	Bacteria	Bacteria	81.3	6.49e-16	NR	MBX3290175.1	1978231	g52637	i0	57.1	2.58904109589041	63	26	64.7	1	272	84	233	294	MBX3290175.1 glycerophosphodiester phosphodiesterase [Acidobacteriota bacterium]	diamond	756	81.3	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32618348	32618348	PRJNA975724_S_NODE_40040_length_319_cov_4.382114_g39859_i0	PRJNA975724	40040	319	4.382114	13.97894366	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	70.5	1.59e-11	NR	MSO56058.1	1978231	g39859	i0	56.7	6.13166144200627	60	26	56.4	0	3	182	542	601	MSO56058.1 translational GTPase TypA [Acidobacteriota bacterium]	diamond	1956	70.5	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);;