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

18 rows where bioproject = "PRJEB36940", 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
4816857	4816857	PRJEB36940_P_NODE_14664_length_245_cov_1.610465_g14535_i0	PRJEB36940	14664	245	1.610465	3.94563925	Bacteria	2	Bacteria	Bacteria	364	2.5e-96	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g14535	i0	93.469	165.065306122449	245	16	100	0	1	245	4841922	4841678	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	40441	364	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15358906	15358906	PRJEB36940_P_NODE_2393_length_547_cov_3.183544_g2267_i0	PRJEB36940	2393	547	3.183544	17.41398568	Luteitalea pratensis	1855912	Bacteria	Bacteria	785	0	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g2267	i0	92.804	359.471663619744	542	39	99	0	1	542	654511	655052	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	196631	785	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
17908352	17908352	PRJEB36940_P_NODE_14595_length_246_cov_0.890173_g14466_i0	PRJEB36940	14595	246	0.890173	2.18982558	Luteitalea sp.	2004800	Bacteria	Bacteria	115	9.82e-28	NR	WP_396626171.1	2004800	g14466	i0	71.6	2.95121951219512	81	23	98.8	0	3	245	868	948	WP_396626171.1 response regulator [Luteitalea sp.]	diamond	726	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp.
17908478	17908478	PRJEB36940_P_NODE_7795_length_310_cov_1.151899_g7666_i0	PRJEB36940	7795	310	1.151899	3.5708869	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2893358421\|emb\|OZ220713.1\|	2793154	g7666	i0	100	0.193548387096774	28	0	9	0	98	125	2884239	2884266	MAG: Vicinamibacteria bacterium isolate f5636fb4-303b-4095-abf0-868cc3675b90 genome assembly, chromosome: 1	blastn	60	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
22665828	22665828	PRJEB36940_P_NODE_14038_length_247_cov_0.896552_g13909_i0	PRJEB36940	14038	247	0.896552	2.21448344	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	157	9.43e-47	NR	MDQ3418520.1	1978231	g13909	i0	96.2	1.91902834008097	79	3	96	0	237	1	1	79	MDQ3418520.1 GTP-binding protein [Acidobacteriota bacterium]	diamond	474	157	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
26653150	26653150	PRJEB36940_P_NODE_11561_length_259_cov_2.080645_g11432_i0	PRJEB36940	11561	259	2.080645	5.38887055	Alloacidobacterium dinghuense	2763107	Bacteria	Bacteria	46.2	0.00259	NR	WP_186743498.1	2763107	g11432	i0	36.1	0.961389961389961	83	48	91.5	3	251	15	181	262	WP_186743498.1 phosphate ABC transporter substrate-binding protein PstS [Alloacidobacterium dinghuense]	diamond	249	46.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Alloacidobacterium	Alloacidobacterium dinghuense
26938250	26938250	PRJEB36940_P_NODE_7442_length_317_cov_1.274590_g7313_i0	PRJEB36940	7442	317	1.27459	4.0404503	Terriglobales bacterium	2282142	Bacteria	Bacteria	43.5	0.0448	NR	HVO82397.1	2282142	g7313	i0	44.1	0.558359621451104	59	28	51.1	1	24	185	108	166	HVO82397.1 sigma 54-interacting transcriptional regulator [Terriglobales bacterium]	diamond	177	43.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27222761	27222761	PRJEB36940_P_NODE_10763_length_268_cov_1.548718_g10634_i0	PRJEB36940	10763	268	1.548718	4.15056424	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	176	6.53e-53	NR	MCL6507207.1	2212468	g10634	i0	100	0.985074626865672	88	0	98.5	0	3	266	166	253	MCL6507207.1 glycosyltransferase family 4 protein [Bryobacteraceae bacterium]	diamond	264	176	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
27602194	27602194	PRJEB36940_P_NODE_11064_length_265_cov_1.187500_g10935_i0	PRJEB36940	11064	265	1.1875	3.146875	Bryobacterales bacterium	2026791	Bacteria	Bacteria	42.7	0.0494	NR	MCC6540497.1	2026791	g10935	i0	56.3	0.362264150943396	32	14	36.2	0	110	205	91	122	MCC6540497.1 S9 family peptidase [Bryobacterales bacterium]	diamond	96	42.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
28991605	28991605	PRJEB36940_P_NODE_14768_length_245_cov_0.906977_g14639_i0	PRJEB36940	14768	245	0.906977	2.22209365	Blastocatellia bacterium	2052146	Bacteria	Bacteria	151	1.96e-40	NR	HXF06097.1	2052146	g14639	i0	95.1	0.991836734693878	81	4	99.2	0	1	243	765	845	HXF06097.1 pitrilysin family protein [Blastocatellia bacterium]	diamond	243	151	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
29016631	29016631	PRJEB36940_P_NODE_6848_length_330_cov_0.910506_g6719_i0	PRJEB36940	6848	330	0.910506	3.0046698	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	44.7	0.00991	NR	MEM1176927.1	1978231	g6719	i0	40.7	2.83636363636364	54	32	49.1	0	168	7	75	128	MEM1176927.1 class I tRNA ligase family protein [Acidobacteriota bacterium]	diamond	936	44.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29496447	29496447	PRJEB36940_P_NODE_10430_length_272_cov_1.336683_g10301_i0	PRJEB36940	10430	272	1.336683	3.63577776	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	79.7	5.59e-17	NR	MDQ7008653.1	1978231	g10301	i0	73.3	0.661764705882353	60	16	66.2	0	182	3	17	76	MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium]	diamond	180	79.7	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
30064808	30064808	PRJEB36940_P_NODE_3752_length_440_cov_1.416894_g3623_i0	PRJEB36940	3752	440	1.416894	6.2343336	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	65.5	3.65e-9	NR	MCX6615362.1	1978231	g3623	i0	34.6	3.98181818181818	156	75	96.8	4	11	436	191	333	MCX6615362.1 SBBP repeat-containing protein [Acidobacteriota bacterium]	diamond	1752	65.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
31201909	31201909	PRJEB36940_P_NODE_3035_length_487_cov_2.391304_g2908_i0	PRJEB36940	3035	487	2.391304	11.64565048	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	110	9.11e-25	NR	HYT66950.1	2910147	g2908	i0	52.7	0.68993839835729	112	51	68.4	2	483	151	239	349	HYT66950.1 DUF4394 domain-containing protein [Vicinamibacterales bacterium]	diamond	336	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
31866408	31866408	PRJEB36940_P_NODE_4437_length_405_cov_3.542169_g4308_i0	PRJEB36940	4437	405	3.542169	14.34578445	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	55.8	3.43e-6	NR	HEX8070575.1	2283092	g4308	i0	32.3	1.76296296296296	130	72	89.6	5	373	11	44	166	HEX8070575.1 CAP domain-containing protein [Pyrinomonadaceae bacterium]	diamond	714	55.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32436385	32436385	PRJEB36940_P_NODE_12619_length_251_cov_1.606742_g12490_i0	PRJEB36940	12619	251	1.606742	4.03292242	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	114	6.43e-29	NR	MBA2353031.1	1978231	g12490	i0	70.4	2.90438247011952	81	24	96.8	0	244	2	97	177	MBA2353031.1 DUF481 domain-containing protein [Acidobacteriota bacterium]	diamond	729	114	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
32619097	32619097	PRJEB36940_P_NODE_11900_length_256_cov_1.278689_g11771_i0	PRJEB36940	11900	256	1.278689	3.27344384	Bacteria	2	Bacteria	Bacteria	52	2.28e-5	NR	MEO7672713.1	2283092	g11771	i0	26.9	2.42578125	78	57	91.4	0	2	235	169	246	MEO7672713.1 FHA domain-containing protein [Pyrinomonadaceae bacterium]	diamond	621	52.4	0.99236641221374	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
32846024	32846024	PRJEB36940_P_NODE_14660_length_245_cov_1.668605_g14531_i0	PRJEB36940	14660	245	1.668605	4.08808225	Bryobacterales bacterium	2026791	Bacteria	Bacteria	144	2.0199999999999998e-38	NR	MBL8214381.1	2026791	g14531	i0	87.7	0.991836734693878	81	10	99.2	0	1	243	388	468	MBL8214381.1 glycosyltransferase family 2 protein [Bryobacterales bacterium]	diamond	243	144	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales 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);;