metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJEB49404" and tax

13 rows where analysis = "blastn", bioproject = "PRJEB49404" 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
1390873	1390873	PRJEB49404_P_NODE_621042_length_155_cov_2.120690_g607241_i0	PRJEB49404	621042	155	2.12069	3.2870695	uncultured Candidatus Solibacter sp.	708629	Bacteria	Bacteria	139	9.51e-29	NTclustered	gi\|310755104\|gb\|HQ212994.1\|	708629	g607241	i0	84.783	1.74193548387097	138	21	89	0	1	138	1207	1070	Uncultured Candidatus Solibacter sp. clone 2_M07 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	270	139	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	uncultured Candidatus Solibacter sp.
2646858	2646858	PRJEB49404_P_NODE_210463_length_339_cov_52.796667_g196664_i0	PRJEB49404	210463	339	52.796667	178.98070113	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	514	3.4e-141	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g196664	i0	94.083	283.728613569322	338	20	99	0	1	338	4652301	4651964	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	96184	514	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
2662077	2662077	PRJEB49404_P_NODE_528363_length_175_cov_0.904412_g514562_i0	PRJEB49404	528363	175	0.904412	1.582721	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	141	3.06e-29	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g514562	i0	83.784	0.845714285714286	148	24	85	0	26	173	1397446	1397299	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	148	141	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
3934916	3934916	PRJEB49404_P_NODE_461764_length_193_cov_1.038961_g447963_i0	PRJEB49404	461764	193	1.038961	2.00519473	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	292	9.01e-75	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g447963	i0	94.241	103.051813471503	191	11	99	0	1	191	4732659	4732469	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	19889	292	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3937901	3937901	PRJEB49404_P_NODE_523844_length_176_cov_1.197080_g510043_i0	PRJEB49404	523844	176	1.19708	2.1068608	Paludibaculum fermentans	1473598	Bacteria	Bacteria	182	1.82e-41	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g510043	i0	86.585	72.4715909090909	164	22	93	0	12	175	2625018	2625181	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	12755	182	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
6094058	6094058	PRJEB49404_P_NODE_286725_length_272_cov_3.167382_g272924_i0	PRJEB49404	286725	272	3.167382	8.61527904	Bacteria	2	Bacteria	Bacteria	193	1.41e-44	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g272924	i0	87.425	63.7279411764706	167	21	61	0	39	205	30170	30336	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	17334	193	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6472115	6472115	PRJEB49404_P_NODE_144126_length_444_cov_1.962963_g130352_i0	PRJEB49404	144126	444	1.962963	8.71555572	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	479	1.6599999999999993e-130	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g130352	i0	86.13	44.5968468468468	447	58	99	4	1	443	3557646	3558092	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	19801	479	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
9919175	9919175	PRJEB49404_P_NODE_315148_length_254_cov_3.632558_g301347_i0	PRJEB49404	315148	254	3.632558	9.22669732	Bacteria	2	Bacteria	Bacteria	200	7.78e-47	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g301347	i0	84.135	239.511811023622	208	32	82	1	1	208	712800	712594	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	60836	200	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14143278	14143278	PRJEB49404_P_NODE_587752_length_162_cov_1.000000_g573951_i0	PRJEB49404	587752	162	1	1.62	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	167	4.609999999999999e-37	NTclustered	gi\|217038894\|gb\|EU810984.1\|	171953	g573951	i0	85.185	2	162	24	100	0	1	162	242	81	Uncultured Acidobacteria bacterium clone 01QD4 23S ribosomal RNA gene, partial sequence	blastn	324	167	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15413273	15413273	PRJEB49404_P_NODE_505253_length_180_cov_2.269504_g491452_i0	PRJEB49404	505253	180	2.269504	4.0851072	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	244	2.35e-60	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g491452	i0	91.111	133.911111111111	180	16	100	0	1	180	4233950	4233771	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	24104	244	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17959184	17959184	PRJEB49404_P_NODE_436515_length_200_cov_4.062112_g422714_i0	PRJEB49404	436515	200	4.062112	8.124224	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	246	7.43e-61	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g422714	i0	88.945	95.525	199	22	99	0	1	199	4233536	4233734	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	19105	246	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17962901	17962901	PRJEB49404_P_NODE_513115_length_178_cov_2.179856_g499314_i0	PRJEB49404	513115	178	2.179856	3.88014368	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	171	3.98e-38	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g499314	i0	86.452	78.9269662921348	155	21	87	0	24	178	308481	308635	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	14049	171	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20512580	20512580	PRJEB49404_P_NODE_520197_length_177_cov_1.050725_g506396_i0	PRJEB49404	520197	177	1.050725	1.85978325	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	8.44e-45	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g506396	i0	87.209	118.378531073446	172	18	96	4	8	177	4233662	4233493	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	20953	193	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured 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);;