metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA853203" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA853203" 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_species
10163118	10163118	PRJNA853203_P_NODE_1128_length_573_cov_1.516000_g981_i0	PRJNA853203	1128	573	1.516	8.68668	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	529	2.1399999999999992e-145	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g981	i0	83.877	64.2739965095986	583	64	100	22	1	573	317918	317356	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	36829	534	0.99063670411985	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
11045041	11045041	PRJNA853203_P_NODE_22609_length_260_cov_2.470588_g22460_i0	PRJNA853203	22609	260	2.470588	6.4235288	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	93.5	1.4e-14	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g22460	i0	82.143	0.430769230769231	112	17	42	3	151	260	1762865	1762755	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	112	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
13988477	13988477	PRJNA853203_P_NODE_2011_length_436_cov_3.289256_g1864_i0	PRJNA853203	2011	436	3.289256	14.34115616	Bacteria	2	Bacteria	Bacteria	507	7.48e-139	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g1864	i0	88.389	107.440366972477	422	48	97	1	7	427	4232779	4233200	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	46844	512	0.990234375	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
16144168	16144168	PRJNA853203_P_NODE_26153_length_253_cov_1.883333_g26004_i0	PRJNA853203	26153	253	1.883333	4.76483249	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	326	1.23e-84	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g26004	i0	89.804	182.332015810277	255	24	100	2	1	253	634986	634732	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	46130	326	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales		Bryobacterales bacterium F-183
17419710	17419710	PRJNA853203_P_NODE_4074_length_352_cov_1.659498_g3925_i0	PRJNA853203	4074	352	1.659498	5.84143296	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	492	1.6499999999999999e-134	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g3925	i0	93.865	93.7840909090909	326	20	93	0	1	326	11220	11545	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	33012	492	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
18692755	18692755	PRJNA853203_P_NODE_29855_length_251_cov_1.584270_g29706_i0	PRJNA853203	29855	251	1.58427	3.9765177	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	398	2.5399999999999994e-106	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g29706	i0	95.918	189.657370517928	245	10	98	0	7	251	9282	9526	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	47604	398	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
18692862	18692862	PRJNA853203_P_NODE_44915_length_243_cov_1.376471_g44766_i0	PRJNA853203	44915	243	1.376471	3.34482453	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g44766	i0	81.405	1.79012345679012	242	39	99	5	1	240	2741966	2741729	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	435	193	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
21636716	21636716	PRJNA853203_P_NODE_18357_length_270_cov_1.050761_g18208_i0	PRJNA853203	18357	270	1.050761	2.8370547	Bacteria	2	Bacteria	Bacteria	318	2.21e-82	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g18208	i0	88.39	149.033333333333	267	28	98	2	6	270	45	310	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	40239	318	1	Bacteria	Pseudomonadati	Acidobacteriota				uncultured Acidobacteriota bacterium
23793799	23793799	PRJNA853203_P_NODE_49939_length_228_cov_2.012903_g49790_i0	PRJNA853203	49939	228	2.012903	4.5894188400000004	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	108	4.28e-19	NTclustered	gi\|2893358421\|emb\|OZ220713.1\|	2793154	g49790	i0	83.761	4.22368421052632	117	15	50	4	1	115	1195035	1194921	MAG: Vicinamibacteria bacterium isolate f5636fb4-303b-4095-abf0-868cc3675b90 genome assembly, chromosome: 1	blastn	963	108	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria			Vicinamibacteria bacterium
25067692	25067692	PRJNA853203_P_NODE_5460_length_327_cov_1.814961_g5311_i0	PRJNA853203	5460	327	1.814961	5.93492247	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	481	3.31e-131	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g5311	i0	93.272	103.639143730887	327	21	100	1	1	327	3557027	3557352	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	33890	481	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);;