metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax

24 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
3951014	3951014	PRJEB58983_P_NODE_25284_length_264_cov_0.874346_g24869_i0	PRJEB58983	25284	264	0.874346	2.30827344	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	303	6.03e-78	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g24869	i0	87.778	265.42803030303	270	20	99	13	2	264	31405	31668	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	70073	303	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5227187	5227187	PRJEB58983_P_NODE_11345_length_373_cov_5.476667_g10930_i0	PRJEB58983	11345	373	5.476667	20.42796791	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	497	3.79e-136	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g10930	i0	91.033	100.672922252011	368	33	99	0	4	371	4651725	4651358	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	37551	497	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
7777390	7777390	PRJEB58983_P_NODE_2547_length_786_cov_2.002805_g2171_i0	PRJEB58983	2547	786	2.002805	15.7420473	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	1055	0	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g2171	i0	90.943	94.8066157760814	795	57	100	13	1	786	4650282	4649494	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	74518	1055	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9052073	9052073	PRJEB58983_P_NODE_21568_length_281_cov_2.985577_g21153_i0	PRJEB58983	21568	281	2.985577	8.38947137	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	241	5.15e-59	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g21153	i0	84.4	3.41281138790036	250	33	89	5	6	254	2741652	2741896	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	959	241	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9052122	9052122	PRJEB58983_P_NODE_23708_length_271_cov_1.575758_g23293_i0	PRJEB58983	23708	271	1.575758	4.27030418	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	274	4.87e-69	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g23293	i0	84.982	263.520295202952	273	38	100	2	1	271	4652312	4652041	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	71414	274	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9052341	9052341	PRJEB58983_P_NODE_34508_length_228_cov_2.767742_g34093_i0	PRJEB58983	34508	228	2.767742	6.31045176	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	143	1.17e-29	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g34093	i0	79.464	2.13157894736842	224	28	94	16	14	228	707021	706807	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	486	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
10328002	10328002	PRJEB58983_P_NODE_27129_length_256_cov_1.032787_g26714_i0	PRJEB58983	27129	256	1.032787	2.64393472	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	121	6.29e-23	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g26714	i0	83.333	43.87109375	132	20	51	2	1	131	4746742	4746612	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	11231	121	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11603270	11603270	PRJEB58983_P_NODE_20890_length_285_cov_1.500000_g20475_i0	PRJEB58983	20890	285	1.5	4.275	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	466	7.93e-127	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g20475	i0	96.14	103.368421052632	285	11	100	0	1	285	635134	635418	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	29460	466	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
11603673	11603673	PRJEB58983_P_NODE_730_length_1525_cov_162.620523_g527_i0	PRJEB58983	730	1525	162.620523	2479.96297575	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	1938	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g527	i0	89.621	435.611147540984	1532	147	100	10	1	1525	3299697	3298171	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	664307	1938	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
12471053	12471053	PRJEB58983_P_NODE_1950_length_908_cov_2.956886_g1606_i0	PRJEB58983	1950	908	2.956886	26.84852488	Geothrix	44675	Bacteria	Bacteria	1375	0	NTclustered	gi\|84452196\|emb\|AM180894.1\|	44676	g1606	i0	93.969	108.286343612335	912	50	100	5	1	908	1911	1001	Geothrix fermentans partial 23S rRNA gene, strain DSM 14018	blastn	98324	1386	0.992063492063492	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix fermentans
12878261	12878261	PRJEB58983_P_NODE_12671_length_354_cov_6.227758_g12256_i0	PRJEB58983	12671	354	6.227758	22.04626332	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	379	1.35e-100	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g12256	i0	86.275	86.9830508474576	357	40	99	8	2	353	317620	317268	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	30792	379	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14153373	14153373	PRJEB58983_P_NODE_27072_length_256_cov_1.601093_g26657_i0	PRJEB58983	27072	256	1.601093	4.09879808	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	368	2.03e-97	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g26657	i0	92.664	361.64453125	259	14	100	5	1	256	4356971	4357227	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	92581	368	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16294863	16294863	PRJEB58983_P_NODE_8253_length_431_cov_3.949721_g7839_i0	PRJEB58983	8253	431	3.949721	17.02329751	Chloracidobacterium	458032	Bacteria	Bacteria	394	5.999999999999998e-105	NTclustered	gi\|470487921\|ref\|NR_076842.1\|	458033	g7839	i0	92.727	227.150812064965	275	17	63	2	157	429	1594	1867	Chloracidobacterium thermophilum strain B 23S ribosomal RNA, complete sequence	blastn	97902	394	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
17976204	17976204	PRJEB58983_P_NODE_10335_length_389_cov_2.617089_g9920_i0	PRJEB58983	10335	389	2.617089	10.18047621	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	623	6.279999999999999e-174	NTclustered	gi\|84452200\|emb\|AM180898.1\|	171953	g9920	i0	96.791	245.375321336761	374	11	96	1	10	383	618	246	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone LS_LKC22_kan3	blastn	95451	623	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17976470	17976470	PRJEB58983_P_NODE_22995_length_274_cov_2.497512_g22580_i0	PRJEB58983	22995	274	2.497512	6.84318288	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	401	2.1699999999999993e-107	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g22580	i0	93.066	271.773722627737	274	19	100	0	1	274	4648993	4648720	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	74466	401	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19250386	19250386	PRJEB58983_P_NODE_19856_length_290_cov_7.184332_g19441_i0	PRJEB58983	19856	290	7.184332	20.8345628	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	285	2.43e-72	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g19441	i0	87.302	129.620689655172	252	29	87	3	7	257	4232780	4233029	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	37590	285	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19250488	19250488	PRJEB58983_P_NODE_25096_length_264_cov_4.439791_g24681_i0	PRJEB58983	25096	264	4.439791	11.72104824	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	416	7.419999999999999e-112	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g24681	i0	95.076	94.0833333333333	264	13	100	0	1	264	4651517	4651780	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	24838	416	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19250527	19250527	PRJEB58983_P_NODE_26976_length_256_cov_2.464481_g26561_i0	PRJEB58983	26976	256	2.464481	6.30907136	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	418	1.9899999999999994e-112	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g26561	i0	96.094	147.64453125	256	10	100	0	1	256	635888	636143	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	37797	418	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
20525982	20525982	PRJEB58983_P_NODE_30337_length_247_cov_0.896552_g29922_i0	PRJEB58983	30337	247	0.896552	2.21448344	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	396	8.95e-106	NTclustered	gi\|2874254139\|emb\|OY970224.1\|	171953	g29922	i0	95.547	191.093117408907	247	11	100	0	1	247	1717380	1717134	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.6 genome assembly, chromosome: 1	blastn	47200	396	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21801844	21801844	PRJEB58983_P_NODE_33398_length_236_cov_2.042945_g32983_i0	PRJEB58983	33398	236	2.042945	4.8213502	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	337	5.22e-88	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g32983	i0	92.405	702.864406779661	237	17	100	1	1	236	715142	715378	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	165876	337	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23076978	23076978	PRJEB58983_P_NODE_26139_length_260_cov_1.470588_g25724_i0	PRJEB58983	26139	260	1.470588	3.8235288	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	250	7.83e-62	NTclustered	gi\|76574291\|gb\|DQ139439.1\|	171953	g25724	i0	84.436	9.97692307692308	257	36	98	4	1	255	1546	1292	Uncultured Acidobacteria bacterium clone CAL9 23S ribosomal RNA gene, partial sequence	blastn	2594	250	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23077157	23077157	PRJEB58983_P_NODE_35479_length_203_cov_4.015385_g35064_i0	PRJEB58983	35479	203	4.015385	8.15123155	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	174	3.62e-39	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g35064	i0	83.77	1.9064039408867	191	23	92	8	1	187	3631880	3631694	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	387	174	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24350860	24350860	PRJEB58983_P_NODE_31160_length_245_cov_0.906977_g30745_i0	PRJEB58983	31160	245	0.906977	2.22209365	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	95.3	3.62e-15	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g30745	i0	87.059	225.812244897959	85	9	34	2	163	245	1821047	1820963	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	55324	95.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
25218147	25218147	PRJEB58983_P_NODE_15220_length_327_cov_3.216535_g14805_i0	PRJEB58983	15220	327	3.216535	10.51806945	Chloracidobacterium	458032	Bacteria	Bacteria	110	1.8e-19	NTclustered	gi\|157273292\|gb\|EF531339.1\|	458033	g14805	i0	85.321	3.41896024464832	109	12	33	3	220	327	90390	90285	Candidatus Chloracidobacterium thermophilum clone BAC M60-018 J19, complete sequence	blastn	1118	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum

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);;