metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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
4005955	4005955	PRJNA1063685_S_NODE_29104_length_435_cov_8.295580_g28562_i0	PRJNA1063685	29104	435	8.29558	36.085773	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	750	0	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g28562	i0	99.515	99.816091954023	412	2	95	0	24	435	634227	633816	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	43420	750	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
4006055	4006055	PRJNA1063685_S_NODE_40004_length_368_cov_5.267797_g39461_i0	PRJNA1063685	40004	368	5.267797	19.38549296	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	536	7.92e-148	NTclustered	gi\|339646357\|gb\|JN038746.1\|	171953	g39461	i0	95.044	90.1983695652174	343	14	93	3	1	342	341	1	Uncultured Acidobacteria bacterium clone MP-R75 16S ribosomal RNA gene, partial sequence	blastn	33193	536	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5282334	5282334	PRJNA1063685_S_NODE_33985_length_402_cov_8.009119_g33443_i0	PRJNA1063685	33985	402	8.009119	32.19665838	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	617	3.0299999999999996e-172	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g33443	i0	96.042	130.805970149254	379	15	94	0	1	379	2365676	2366054	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	52584	617	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5282546	5282546	PRJNA1063685_S_NODE_57085_length_290_cov_4.483871_g56542_i0	PRJNA1063685	57085	290	4.483871	13.0032259	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	348	3.06e-91	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g56542	i0	90.875	95.551724137931	263	19	90	5	23	282	317252	317512	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	27710	348	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
12933232	12933232	PRJNA1063685_S_NODE_27491_length_447_cov_8.874332_g26950_i0	PRJNA1063685	27491	447	8.874332	39.66826404	Paludibaculum fermentans	1473598	Bacteria	Bacteria	448	4.72e-121	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g26950	i0	86.19	95.662192393736	420	51	93	7	32	447	4786514	4786098	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	42761	448	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
12933257	12933257	PRJNA1063685_S_NODE_30471_length_425_cov_6.125000_g29929_i0	PRJNA1063685	30471	425	6.125	26.03125	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	416	1.26e-111	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g29929	i0	84.687	118.305882352941	431	51	98	11	10	425	4839100	4839530	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	50280	416	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12933630	12933630	PRJNA1063685_S_NODE_81011_length_197_cov_4.322581_g80468_i0	PRJNA1063685	81011	197	4.322581	8.51548457	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	198	2.07e-46	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g80468	i0	87.079	0.903553299492386	178	20	90	3	1	178	4472294	4472120	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	178	198	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14208128	14208128	PRJNA1063685_S_NODE_23352_length_479_cov_5.054187_g22812_i0	PRJNA1063685	23352	479	5.054187	24.20955573	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	488	2.9999999999999998e-133	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g22812	i0	86.087	103.338204592902	460	57	95	5	1	456	3298618	3298162	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	49499	488	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14208588	14208588	PRJNA1063685_S_NODE_74892_length_239_cov_4.132530_g74349_i0	PRJNA1063685	74892	239	4.13253	9.8767467	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	172	1.58e-38	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g74349	i0	97.98	22.7280334728033	99	2	41	0	118	216	5803310	5803212	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	5432	172	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16756707	16756707	PRJNA1063685_S_NODE_61274_length_275_cov_7.559406_g60731_i0	PRJNA1063685	61274	275	7.559406	20.7883665	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	383	7.89e-102	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g60731	i0	93.774	429.494545454545	257	13	93	3	21	275	715483	715228	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	118111	383	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21856297	21856297	PRJNA1063685_S_NODE_20858_length_501_cov_30.030374_g20320_i0	PRJNA1063685	20858	501	30.030374	150.45217374	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	558	2.3699999999999995e-154	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g20320	i0	88.72	96.8403193612775	461	47	91	4	34	490	3558657	3558198	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	48517	558	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
21856350	21856350	PRJNA1063685_S_NODE_27178_length_449_cov_15.630319_g26637_i0	PRJNA1063685	27178	449	15.630319	70.18013231	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	697	0	NTclustered	gi\|338181099\|gb\|JF981607.1\|	171953	g26637	i0	98.25	93.3184855233853	400	4	88	3	7	403	400	1	Uncultured Acidobacteria bacterium clone Upland_8_884 16S ribosomal RNA gene, partial sequence	blastn	41900	697	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21856586	21856586	PRJNA1063685_S_NODE_57198_length_290_cov_2.437788_g56655_i0	PRJNA1063685	57198	290	2.437788	7.0695852	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	394	3.87e-105	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g56655	i0	91.844	260.244827586207	282	23	97	0	9	290	4648590	4648871	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	75471	394	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
21856675	21856675	PRJNA1063685_S_NODE_6998_length_683_cov_5.624590_g6510_i0	PRJNA1063685	6998	683	5.62459	38.4159497	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	933	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g6510	i0	91.317	178.360175695461	691	48	100	12	1	683	3299891	3299205	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	121820	933	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23131937	23131937	PRJNA1063685_S_NODE_45239_length_341_cov_4.141791_g44696_i0	PRJNA1063685	45239	341	4.1417909999999996	14.12350731	Luteitalea pratensis	1855912	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g44696	i0	96.875	0.668621700879765	32	1	9	0	195	226	2559642	2559673	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	228	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
25238079	25238079	PRJNA1063685_S_NODE_1900_length_918_cov_10.998817_g1577_i0	PRJNA1063685	1900	918	10.998817	100.96914006	Bacteria	2	Bacteria	Bacteria	907	0	NTclustered	gi\|76574291\|gb\|DQ139439.1\|	171953	g1577	i0	85.033	84.3758169934641	902	124	97	11	24	918	625	1522	Uncultured Acidobacteria bacterium clone CAL9 23S ribosomal RNA gene, partial sequence	blastn	77457	907	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);;