metadata: contig_metadata: 18 rows where bioproject = "PRJEB12237", tax_phylum = "Acidobacteriota" and tax

18 rows where bioproject = "PRJEB12237", 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
6398820	6398820	PRJEB12237_P_NODE_5686_length_248_cov_2.488263_g5490_i0	PRJEB12237	5686	248	2.488263	6.17089224	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g5490	i0	87.097	81.6008064516129	248	32	100	0	1	248	318951	318704	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	20237	281	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8947697	8947697	PRJEB12237_P_NODE_8408_length_189_cov_1.051948_g8212_i0	PRJEB12237	8408	189	1.051948	1.98818172	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	283	5.28e-72	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g8212	i0	93.651	102.666666666667	189	12	100	0	1	189	671	859	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	19404	283	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11498720	11498720	PRJEB12237_P_NODE_6150_length_235_cov_2.310000_g5954_i0	PRJEB12237	6150	235	2.31	5.4285	Paludibaculum fermentans	1473598	Bacteria	Bacteria	324	4.04e-84	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g5954	i0	91.525	58.8	236	19	100	1	1	235	4786173	4785938	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	13818	324	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
11498731	11498731	PRJEB12237_P_NODE_7330_length_207_cov_2.029070_g7134_i0	PRJEB12237	7330	207	2.02907	4.2001749	Paludibaculum fermentans	1473598	Bacteria	Bacteria	265	2.1399999999999997e-66	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g7134	i0	90.64	240.811594202899	203	13	98	5	1	202	4785874	4785677	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	49848	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
19146150	19146150	PRJEB12237_P_NODE_10496_length_163_cov_3.078125_g10300_i0	PRJEB12237	10496	163	3.078125	5.01734375	Paludibaculum fermentans	1473598	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g10300	i0	95.092	108.41717791411	163	8	100	0	1	163	4784767	4784929	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	17672	257	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
20421366	20421366	PRJEB12237_P_NODE_8517_length_187_cov_2.078947_g8321_i0	PRJEB12237	8517	187	2.078947	3.88763089	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	202	1.4999999999999996e-47	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g8321	i0	86.316	12.7593582887701	190	21	100	4	1	187	3298172	3298359	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	2386	202	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26868674	26868674	PRJEB12237_P_NODE_2661_length_430_cov_1.716456_g2465_i0	PRJEB12237	2661	430	1.716456	7.3807608	Pseudomonadati	3379134	Bacteria	Bacteria	59.3	4.29e-7	NR	MBX3265733.1	1978231	g2465	i0	34.8	1.3046511627907	89	52	59.3	4	354	100	146	232	MBX3265733.1 hypothetical protein [Acidobacteriota bacterium]	diamond	561	59.7	0.993299832495812	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
27032932	27032932	PRJEB12237_P_NODE_9682_length_172_cov_1.459854_g9486_i0	PRJEB12237	9682	172	1.459854	2.51094888	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	47	4.62e-4	NR	NNF01029.1	2283092	g9486	i0	48.7	1.90116279069767	39	20	68	0	171	55	366	404	NNF01029.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	327	47	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
27949034	27949034	PRJEB12237_P_NODE_3085_length_387_cov_4.221591_g2889_i0	PRJEB12237	3085	387	4.221591	16.33755717	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	125	1.42e-34	NR	MDQ7008653.1	1978231	g2889	i0	83.8	0.62015503875969	80	13	62	0	146	385	24	103	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	240	125	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29085838	29085838	PRJEB12237_P_NODE_6008_length_239_cov_1.568627_g5812_i0	PRJEB12237	6008	239	1.568627	3.74901853	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	70.9	4.43e-13	NR	HSE24404.1	2283092	g5812	i0	52.9	0.853556485355649	68	32	85.4	0	237	34	103	170	HSE24404.1 globin family protein [Pyrinomonadaceae bacterium]	diamond	204	70.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29338331	29338331	PRJEB12237_P_NODE_10349_length_165_cov_1.230769_g10153_i0	PRJEB12237	10349	165	1.230769	2.03076885	Blastocatellia bacterium	2052146	Bacteria	Bacteria	53.9	7.63e-7	NR	HQR39838.1	2052146	g10153	i0	52.3	0.8	44	21	80	0	163	32	73	116	HQR39838.1 hypothetical protein [Blastocatellia bacterium]	diamond	132	53.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
29748462	29748462	PRJEB12237_P_NODE_9111_length_179_cov_1.666667_g8915_i0	PRJEB12237	9111	179	1.666667	2.98333393	Terriglobia bacterium	2081523	Bacteria	Bacteria	54.3	1.29e-6	NR	MBV8732832.1	2081523	g8915	i0	42.4	0.988826815642458	59	31	98.9	2	3	179	125	180	MBV8732832.1 hypothetical protein [Terriglobia bacterium]	diamond	177	54.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
29780295	29780295	PRJEB12237_P_NODE_2011_length_504_cov_2.400853_g1823_i0	PRJEB12237	2011	504	2.400853	12.10029912	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	107	1.13e-26	NR	MDQ7008654.1	1978231	g1823	i0	86.8	0.404761904761905	68	8	40.5	1	504	301	45	111	MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium]	diamond	204	107	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30089772	30089772	PRJEB12237_P_NODE_9452_length_175_cov_1.300000_g9256_i0	PRJEB12237	9452	175	1.3	2.275	Pseudomonadati	3379134	Bacteria	Bacteria	47.4	3.55e-4	NR	HKQ62042.1	2910585	g9256	i0	59.5	3.41142857142857	37	15	63.4	0	111	1	600	636	HKQ62042.1 metallophosphoesterase [Candidatus Polarisedimenticolaceae bacterium]	diamond	597	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Candidatus Polarisedimenticolia	Candidatus Polarisedimenticolales	Candidatus Polarisedimenticolaceae		Candidatus Polarisedimenticolaceae bacterium
30886062	30886062	PRJEB12237_P_NODE_3094_length_387_cov_1.715909_g2898_i0	PRJEB12237	3094	387	1.715909	6.64056783	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	101	5.38e-25	NR	MDQ7008653.1	1978231	g2898	i0	83.1	0.503875968992248	65	11	50.4	0	222	28	45	109	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	195	101	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31992808	31992808	PRJEB12237_P_NODE_5078_length_272_cov_1.518987_g4882_i0	PRJEB12237	5078	272	1.518987	4.13164464	Blastocatellia bacterium	2052146	Bacteria	Bacteria	69.7	9.02e-12	NR	MFN7928494.1	2052146	g4882	i0	45.1	2.00735294117647	91	36	99.3	3	3	272	173	250	MFN7928494.1 pirin family protein [Blastocatellia bacterium]	diamond	546	69.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
32246285	32246285	PRJEB12237_P_NODE_12158_length_150_cov_1.391304_g11962_i0	PRJEB12237	12158	150	1.391304	2.086956	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	95.1	3.6100000000000005e-21	NR	MCB1042508.1	1978231	g11962	i0	75.5	4.9	49	12	98	0	149	3	291	339	MCB1042508.1 acetate--CoA ligase [Acidobacteriota bacterium]	diamond	735	95.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32782593	32782593	PRJEB12237_P_NODE_3200_length_376_cov_1.768328_g3004_i0	PRJEB12237	3200	376	1.768328	6.64891328	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	89.4	2.57e-18	NR	MDR3737318.1	2052142	g3004	i0	44.8	0.997340425531915	125	61	95.7	4	362	3	186	307	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	375	89.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae 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);;