metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA565584" 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
1830256	1830256	PRJNA565584_P_NODE_127482_length_277_cov_1.431373_g126330_i0	PRJNA565584	127482	277	1.431373	3.96490321	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g126330	i0	96.97	0.11913357400722	33	1	12	0	231	263	951627	951659	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
3105670	3105670	PRJNA565584_P_NODE_128523_length_276_cov_1.891626_g127371_i0	PRJNA565584	128523	276	1.891626	5.22088776	Mesoterricola sediminis	2927980	Bacteria	Bacteria	147	1.13e-30	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g127371	i0	76.838	12.7210144927536	272	55	97	5	2	269	1787414	1787147	Mesoterricola sediminis W786 DNA, complete genome	blastn	3511	147	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
13309960	13309960	PRJNA565584_P_NODE_192411_length_246_cov_0.890173_g191259_i0	PRJNA565584	192411	246	0.890173	2.18982558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	244	3.42e-60	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g191259	i0	84.959	11.5121951219512	246	32	99	3	1	245	4504310	4504551	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	2832	244	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15857351	15857351	PRJNA565584_P_NODE_121833_length_280_cov_3.091787_g120681_i0	PRJNA565584	121833	280	3.091787	8.6570036	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	215	3.11e-51	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g120681	i0	87.234	30.6	188	24	67	0	5	192	5160665	5160478	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	8568	215	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15858259	15858259	PRJNA565584_P_NODE_169393_length_251_cov_0.865169_g168241_i0	PRJNA565584	169393	251	0.865169	2.17157419	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	183	7.73e-42	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g168241	i0	83.5	0.796812749003984	200	30	80	1	1	200	1572833	1573029	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	200	183	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15858261	15858261	PRJNA565584_P_NODE_169833_length_251_cov_0.865169_g168681_i0	PRJNA565584	169833	251	0.865169	2.17157419	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	69.4	2.26e-7	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g168681	i0	87.097	1.0996015936255	62	7	24	1	3	63	1133195	1133134	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	276	69.4	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17132830	17132830	PRJNA565584_P_NODE_146834_length_264_cov_1.612565_g145682_i0	PRJNA565584	146834	264	1.612565	4.2571716	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	69.4	2.39e-7	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g145682	i0	87.931	0.465909090909091	58	7	22	0	107	164	361541	361598	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	123	69.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
17134031	17134031	PRJNA565584_P_NODE_219014_length_234_cov_2.664596_g217862_i0	PRJNA565584	219014	234	2.664596	6.23515464	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	143	1.21e-29	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g217862	i0	98.75	2.14957264957265	80	1	40	0	86	165	3880760	3880681	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	503	143	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18407732	18407732	PRJNA565584_P_NODE_178095_length_249_cov_0.875000_g176943_i0	PRJNA565584	178095	249	0.875	2.17875	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	220	5.84e-53	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g176943	i0	83.544	0.951807228915663	237	37	95	2	1	236	1573634	1573869	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	237	220	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);;