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

18 rows where bioproject = "PRJNA591127" 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
4392568	4392568	PRJNA591127_P_NODE_24924_length_169_cov_1.212121_g24755_i0	PRJNA591127	24924	169	1.212121	2.04848449	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	222	1.02e-53	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g24755	i0	94.444	152.686390532544	144	8	85	0	5	148	3919182	3919325	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	25804	222	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5668716	5668716	PRJNA591127_P_NODE_11965_length_213_cov_1.857955_g11796_i0	PRJNA591127	11965	213	1.857955	3.95744415	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	217	6.279999999999999e-52	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g11796	i0	90.058	619.81220657277	171	12	79	4	43	211	1750	1583	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	132020	217	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8218320	8218320	PRJNA591127_P_NODE_3027_length_410_cov_3.152815_g2859_i0	PRJNA591127	3027	410	3.152815	12.9265415	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	486	9.109999999999999e-133	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g2859	i0	93.072	192.378048780488	332	23	81	0	79	410	3298550	3298881	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	78875	486	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10769399	10769399	PRJNA591127_P_NODE_3049_length_409_cov_2.212366_g2881_i0	PRJNA591127	3049	409	2.212366	9.04857694	uncultured Acidobacteria bacterium HF4000_26D02	710731	Bacteria	Bacteria	538	2.4699999999999994e-148	NTclustered	gi\|297182479\|gb\|GU474896.1\|	710731	g2881	i0	91.067	146.168704156479	403	28	98	8	1	400	7175	7572	Uncultured Acidobacteria bacterium HF4000_26D02 genomic sequence	blastn	59783	538	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteria bacterium HF4000_26D02
12044260	12044260	PRJNA591127_P_NODE_30990_length_151_cov_1.508772_g30821_i0	PRJNA591127	30990	151	1.508772	2.27824572	Luteitalea pratensis	1855912	Bacteria	Bacteria	224	2.4699999999999993e-54	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g30821	i0	93.919	86.6158940397351	148	9	98	0	4	151	653601	653454	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	13079	224	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
14593993	14593993	PRJNA591127_P_NODE_32252_length_150_cov_1.380531_g32083_i0	PRJNA591127	32252	150	1.380531	2.0707965	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	75	2.61e-9	NTclustered	gi\|2621701354\|emb\|OY760074.1\|	1978231	g32083	i0	91.228	0.38	57	2	37	3	96	150	1225934	1225879	MAG: Acidobacteriota bacterium isolate e8b00ceb-3b51-4674-b3e1-58c3ce2e7457 genome assembly, chromosome: 1	blastn	57	75	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14593999	14593999	PRJNA591127_P_NODE_3932_length_364_cov_4.535168_g3764_i0	PRJNA591127	3932	364	4.535168	16.50801152	Terriglobus roseus	392734	Bacteria	Bacteria	497	3.69e-136	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g3764	i0	94.19	103.703296703297	327	18	90	1	39	364	927029	926703	Terriglobus roseus DSM 18391, complete genome	blastn	37748	497	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
21540611	21540611	PRJNA591127_P_NODE_13777_length_198_cov_1.639752_g13608_i0	PRJNA591127	13777	198	1.639752	3.24670896	Luteitalea	2004797	Bacteria	Bacteria	302	1.54e-77	NTclustered	gi\|112980855\|gb\|DQ829659.1\|	171953	g13608	i0	93.939	106.318181818182	198	12	100	0	1	198	644	841	Uncultured Acidobacteria bacterium clone DON16 23S ribosomal RNA gene, partial sequence	blastn	21051	305	0.99016393442623	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22816089	22816089	PRJNA591127_P_NODE_3758_length_372_cov_6.773134_g3590_i0	PRJNA591127	3758	372	6.773134	25.19605848	Pseudomonadati	3379134	Bacteria	Bacteria	512	1.35e-140	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g3590	i0	91.826	120.66935483871	367	30	99	0	6	372	3870925	3870559	Terriglobus saanensis SP1PR4, complete genome	blastn	44889	512	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
23517480	23517480	PRJNA591127_P_NODE_27819_length_155_cov_0.898305_g27650_i0	PRJNA591127	27819	155	0.898305	1.39237275	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	241	2.53e-59	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g27650	i0	94.805	30.174193548387105	154	8	99	0	1	154	634741	634894	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	4677	241	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
24090543	24090543	PRJNA591127_P_NODE_10779_length_224_cov_2.497326_g10611_i0	PRJNA591127	10779	224	2.497326	5.59401024	Pseudomonadati	3379134	Bacteria	Bacteria	86.1	1.96e-12	NTclustered	gi\|112980858\|gb\|DQ829662.1\|	171953	g10611	i0	96.154	12.9821428571429	52	2	23	0	2	53	1257	1308	Uncultured Acidobacteria bacterium clone DON23 23S ribosomal RNA gene, partial sequence	blastn	2908	86.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
28658888	28658888	PRJNA591127_P_NODE_18267_length_197_cov_2.256250_g18098_i0	PRJNA591127	18267	197	2.25625	4.4448125	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	54.3	1.69e-6	NR	MEJ7860460.1	2283092	g18098	i0	92	1.14213197969543	25	2	38.1	0	197	123	447	471	MEJ7860460.1 S8 family serine peptidase [Pyrinomonadaceae bacterium]	diamond	225	54.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28721967	28721967	PRJNA591127_P_NODE_18767_length_197_cov_2.143750_g18598_i0	PRJNA591127	18767	197	2.14375	4.2231875	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	65.5	1.96e-10	NR	HWB87206.1	2212468	g18598	i0	50.7	2.11675126903553	69	30	99	1	2	196	675	743	HWB87206.1 TonB-dependent receptor [Bryobacteraceae bacterium]	diamond	417	65.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
28893056	28893056	PRJNA591127_P_NODE_14968_length_197_cov_3.643750_g14799_i0	PRJNA591127	14968	197	3.64375	7.1781875	Pseudomonadati	3379134	Bacteria	Bacteria	48.1	8.45e-5	NR	PYR90542.1	1978231	g14799	i0	88	3.41116751269036	25	3	38.1	0	196	122	10	34	PYR90542.1 MAG: glyoxalase [Acidobacteriota bacterium]	diamond	672	48.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
29258349	29258349	PRJNA591127_P_NODE_11789_length_215_cov_1.286517_g11620_i0	PRJNA591127	11789	215	1.286517	2.76601155	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	50.1	6.6e-5	NR	MBP9936645.1	2283092	g11620	i0	71.4	0.488372093023256	35	10	48.8	0	75	179	2	36	MBP9936645.1 GTPase ObgE [Pyrinomonadaceae bacterium]	diamond	105	50.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
30030077	30030077	PRJNA591127_P_NODE_28691_length_151_cov_6.157895_g28522_i0	PRJNA591127	28691	151	6.157895	9.29842145	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	46.2	5.5e-4	NR	HZS07219.1	2052146	g28522	i0	80	2.54304635761589	25	5	49.7	0	150	76	144	168	HZS07219.1 acetyltransferase [Blastocatellia bacterium]	diamond	384	46.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia				Blastocatellia bacterium
31565290	31565290	PRJNA591127_P_NODE_22236_length_186_cov_4.926174_g22067_i0	PRJNA591127	22236	186	4.926174	9.16268364	Geothrix limicola	2927978	Bacteria	Bacteria	77.4	8.43e-15	NR	WP_285576364.1	2927978	g22067	i0	54.8	1.98387096774194	62	27	100	1	1	186	110	170	WP_285576364.1 O-antigen ligase family protein [Geothrix limicola]	diamond	369	77.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix limicola
32432924	32432924	PRJNA591127_P_NODE_22919_length_181_cov_8.604167_g22750_i0	PRJNA591127	22919	181	8.604167	15.57354227	Pseudomonadati	3379134	Bacteria	Bacteria	78.6	1.98e-16	NR	MFN0164788.1	2212468	g22750	i0	69.6	15.3812154696133	46	14	76.2	0	43	180	2	47	MFN0164788.1 phage tail protein [Bryobacteraceae bacterium]	diamond	2784	78.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;