metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1158727" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1158727" 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
1577821	1577821	PRJNA1158727_P_NODE_105002_length_286_cov_0.985915_g97541_i0	PRJNA1158727	105002	286	0.985915	2.8197169	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	457	4.79e-124	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g97541	i0	95.455	183.255244755245	286	13	100	0	1	286	2365690	2365975	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	52411	457	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1578876	1578876	PRJNA1158727_P_NODE_155262_length_244_cov_0.900585_g147800_i0	PRJNA1158727	155262	244	0.900585	2.1974274	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g147800	i0	100	1	244	0	100	0	1	244	1019094	1018851	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	244	451	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
2854283	2854283	PRJNA1158727_P_NODE_111983_length_277_cov_1.308824_g104522_i0	PRJNA1158727	111983	277	1.308824	3.62544248	Mesoterricola silvestris	2927979	Bacteria	Bacteria	204	6.65e-48	NTclustered	gi\|2490891634\|dbj\|AP027080.1\|	2927979	g104522	i0	84.615	72.6534296028881	208	28	74	4	72	277	1105132	1105337	Mesoterricola silvestris W79 DNA, complete genome	blastn	20125	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola silvestris
2854582	2854582	PRJNA1158727_P_NODE_126283_length_260_cov_1.647059_g118822_i0	PRJNA1158727	126283	260	1.647059	4.2823534	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	215	2.86e-51	NTclustered	gi\|2874253980\|emb\|OY970305.1\|	194844	g118822	i0	85.167	18.4615384615385	209	31	80	0	52	260	3584338	3584130	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03726.bin.c.10 genome assembly, chromosome: 1	blastn	4800	215	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
5406976	5406976	PRJNA1158727_P_NODE_137485_length_250_cov_1.305085_g130023_i0	PRJNA1158727	137485	250	1.305085	3.2627125	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|76574291\|gb\|DQ139439.1\|	171953	g130023	i0	83.264	104.492	239	32	94	8	2	236	1552	1318	Uncultured Acidobacteria bacterium clone CAL9 23S ribosomal RNA gene, partial sequence	blastn	26123	213	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7956428	7956428	PRJNA1158727_P_NODE_110667_length_278_cov_3.902439_g103206_i0	PRJNA1158727	110667	278	3.902439	10.84878042	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	309	1.3800000000000002e-79	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g103206	i0	86.691	177.86690647482	278	37	100	0	1	278	3559021	3559298	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	49447	309	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
9231301	9231301	PRJNA1158727_P_NODE_110128_length_279_cov_1.495146_g102667_i0	PRJNA1158727	110128	279	1.495146	4.17145734	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	124	5.37e-24	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g102667	i0	79.885	0.623655913978495	174	31	61	4	109	279	4108556	4108728	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	174	124	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
9965878	9965878	PRJNA1158727_P_NODE_64068_length_402_cov_2.574468_g56607_i0	PRJNA1158727	64068	402	2.574468	10.34936136	Bacteria	2	Bacteria	Bacteria	640	6.47e-179	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g56607	i0	95.739	102.863184079602	399	14	99	3	4	402	954	559	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	41351	641	0.998439937597504	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15065147	15065147	PRJNA1158727_P_NODE_125432_length_261_cov_1.638298_g117971_i0	PRJNA1158727	125432	261	1.638298	4.27595778	Chloracidobacterium	458032	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2033640757\|gb\|CP072635.1\|	2821536	g117971	i0	100	0.64367816091954	28	0	11	0	149	176	221326	221353	Chloracidobacterium sp. D chromosome 2, complete sequence	blastn	168	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp. D
15606519	15606519	PRJNA1158727_P_NODE_128753_length_257_cov_2.277174_g121292_i0	PRJNA1158727	128753	257	2.277174	5.85233718	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	473	4.2099999999999996e-129	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g121292	i0	100	0.996108949416342	256	0	99	0	2	257	239842	240097	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	256	473	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
17615131	17615131	PRJNA1158727_P_NODE_106434_length_284_cov_1.213270_g98973_i0	PRJNA1158727	106434	284	1.21327	3.4456868	Chloracidobacterium	458032	Bacteria	Bacteria	219	2.44e-52	NTclustered	gi\|2033635510\|gb\|CP072632.1\|	458033	g98973	i0	82.031	1.80281690140845	256	46	90	0	1	256	119423	119168	Chloracidobacterium thermophilum strain B chromosome 1, complete sequence	blastn	512	219	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium thermophilum
19429432	19429432	PRJNA1158727_P_NODE_113496_length_275_cov_1.470297_g106035_i0	PRJNA1158727	113496	275	1.470297	4.04331675	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	333	8.06e-87	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g106035	i0	93.013	85.7818181818182	229	14	83	2	32	259	3558042	3558269	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	23590	333	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
20704666	20704666	PRJNA1158727_P_NODE_110337_length_279_cov_1.422330_g102876_i0	PRJNA1158727	110337	279	1.42233	3.9683007	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	505	1.6399999999999995e-138	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g102876	i0	99.283	1	279	2	100	0	1	279	281503	281225	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	279	505	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
20707771	20707771	PRJNA1158727_P_NODE_77617_length_347_cov_1.248175_g70156_i0	PRJNA1158727	77617	347	1.248175	4.33116725	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	490	5.879999999999998e-134	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g70156	i0	92.219	47.0057636887608	347	25	99	2	2	347	634839	634494	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	16311	490	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
25264056	25264056	PRJNA1158727_P_NODE_83180_length_330_cov_2.906615_g75719_i0	PRJNA1158727	83180	330	2.906615	9.5918295	Bacteria	2	Bacteria	Bacteria	523	5.479999999999998e-144	NTclustered	gi\|76574295\|gb\|DQ139443.1\|	171953	g75719	i0	95.181	106.509090909091	332	14	100	2	1	330	890	559	Uncultured Acidobacteria bacterium clone CAL2 23S ribosomal RNA gene, partial sequence	blastn	35148	523	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);;