metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA688931" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA688931" 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
1944533	1944533	PRJNA688931_P_NODE_29682_length_186_cov_1.773723_g29469_i0	PRJNA688931	29682	186	1.773723	3.29912478	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	305	1.11e-78	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g29469	i0	96.739	188.569892473118	184	5	99	1	3	186	2170896	2171078	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	35074	305	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
3729942	3729942	PRJNA688931_P_NODE_29223_length_188_cov_1.230216_g29010_i0	PRJNA688931	29223	188	1.230216	2.31280608	Candidatus Korobacter	658061	Bacteria	Bacteria	196	7.029999999999999e-46	NTclustered	gi\|76574294\|gb\|DQ139442.1\|	171953	g29010	i0	85.789	112.122340425532	190	21	100	6	1	188	1762	1947	Uncultured Acidobacteria bacterium clone CAL3 23S ribosomal RNA gene, partial sequence	blastn	21079	196	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3729951	3729951	PRJNA688931_P_NODE_33423_length_174_cov_1.336000_g33210_i0	PRJNA688931	33423	174	1.336	2.32464	Bacteria	2	Bacteria	Bacteria	226	8.149999999999998e-55	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g33210	i0	90.23	92.6034482758621	174	16	100	1	1	174	2908350	2908178	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	16113	228	0.991228070175439	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4496509	4496509	PRJNA688931_P_NODE_23124_length_213_cov_1.091463_g22911_i0	PRJNA688931	23124	213	1.091463	2.32481619	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	327	2.78e-85	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g22911	i0	95.588	85.9154929577465	204	9	96	0	1	204	2367435	2367638	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	18300	327	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4496575	4496575	PRJNA688931_P_NODE_31704_length_179_cov_1.907692_g31491_i0	PRJNA688931	31704	179	1.907692	3.41476868	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	307	2.9300000000000005e-79	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g31491	i0	97.753	123.122905027933	178	4	99	0	2	179	4573532	4573709	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	22039	307	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
5772089	5772089	PRJNA688931_P_NODE_27165_length_196_cov_1.027211_g26952_i0	PRJNA688931	27165	196	1.027211	2.01333356	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	296	7.089999999999998e-76	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g26952	i0	93.878	472.617346938775	196	12	100	0	1	196	3300999	3300804	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	92633	296	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
7047278	7047278	PRJNA688931_P_NODE_7666_length_391_cov_1.122807_g7453_i0	PRJNA688931	7666	391	1.1228070000000001	4.39017537	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	460	5.24e-125	NTclustered	gi\|112980862\|gb\|DQ829666.1\|	171953	g7453	i0	88.071	230.938618925831	394	39	100	7	1	391	514	126	Uncultured Acidobacteria bacterium clone DON18 23S ribosomal RNA gene, partial sequence	blastn	90297	460	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8321618	8321618	PRJNA688931_P_NODE_25387_length_203_cov_1.012987_g25174_i0	PRJNA688931	25387	203	1.012987	2.05636361	Luteitalea pratensis	1855912	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g25174	i0	96.97	0.16256157635468	33	0	16	1	103	135	5559302	5559333	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	33	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
9596935	9596935	PRJNA688931_P_NODE_13588_length_281_cov_2.232759_g13375_i0	PRJNA688931	13588	281	2.232759	6.27405279	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	416	7.969999999999998e-112	NTclustered	gi\|112980855\|gb\|DQ829659.1\|	171953	g13375	i0	93.31	183.338078291815	284	16	100	3	1	281	355	72	Uncultured Acidobacteria bacterium clone DON16 23S ribosomal RNA gene, partial sequence	blastn	51518	416	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9597045	9597045	PRJNA688931_P_NODE_28868_length_189_cov_1.478571_g28655_i0	PRJNA688931	28868	189	1.478571	2.79449919	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	250	5.36e-62	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g28655	i0	90.526	37.1851851851852	190	17	100	1	1	189	317463	317274	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	7028	250	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9597153	9597153	PRJNA688931_P_NODE_42088_length_163_cov_0.912281_g41875_i0	PRJNA688931	42088	163	0.912281	1.48701803	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	156	1.01e-33	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g41875	i0	83.951	0.993865030674847	162	26	99	0	1	162	216470	216631	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	162	156	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12147870	12147870	PRJNA688931_P_NODE_33930_length_172_cov_2.097561_g33717_i0	PRJNA688931	33930	172	2.097561	3.60780492	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	316	4.629999999999998e-82	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g33717	i0	100	395.52325581395303	171	0	99	0	2	172	1149	979	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	68030	316	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
13422471	13422471	PRJNA688931_P_NODE_36651_length_167_cov_1.754237_g36438_i0	PRJNA688931	36651	167	1.754237	2.92957579	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	267	4.599999999999999e-67	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g36438	i0	95.294	168.383233532934	170	5	100	3	1	167	1685	1854	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	28120	267	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
14697405	14697405	PRJNA688931_P_NODE_23172_length_212_cov_3.950920_g22959_i0	PRJNA688931	23172	212	3.95092	8.3759504	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	287	4.69e-73	NTclustered	gi\|76574289\|gb\|DQ139437.1\|	171953	g22959	i0	91.748	69.7452830188679	206	17	97	0	7	212	218	13	Uncultured Acidobacteria bacterium clone CAL8 23S ribosomal RNA gene, partial sequence	blastn	14786	287	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14697420	14697420	PRJNA688931_P_NODE_25152_length_204_cov_1.045161_g24939_i0	PRJNA688931	25152	204	1.045161	2.13212844	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	233	5.919999999999999e-57	NTclustered	gi\|76574290\|gb\|DQ139438.1\|	171953	g24939	i0	89.84	122.887254901961	187	12	91	7	20	204	510	691	Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence	blastn	25069	233	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15971270	15971270	PRJNA688931_P_NODE_34093_length_172_cov_1.268293_g33880_i0	PRJNA688931	34093	172	1.268293	2.18146396	Paludibaculum fermentans	1473598	Bacteria	Bacteria	219	1.34e-52	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g33880	i0	89.535	117.122093023256	172	18	100	0	1	172	4787267	4787438	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	20145	219	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
17246456	17246456	PRJNA688931_P_NODE_36174_length_168_cov_0.873950_g35961_i0	PRJNA688931	36174	168	0.87395	1.468236	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	244	2.1699999999999999e-60	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g35961	i0	92.857	44.0773809523809	168	12	100	0	1	168	634107	633940	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	7405	244	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
17246507	17246507	PRJNA688931_P_NODE_42874_length_162_cov_1.814159_g42661_i0	PRJNA688931	42874	162	1.814159	2.93893758	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	230	5.799999999999999e-56	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g42661	i0	92.547	78.5308641975309	161	11	99	1	1	160	4733160	4733000	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	12722	230	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18520527	18520527	PRJNA688931_P_NODE_23815_length_209_cov_3.925000_g23602_i0	PRJNA688931	23815	209	3.925	8.20325	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	309	9.85e-80	NTclustered	gi\|112980855\|gb\|DQ829659.1\|	171953	g23602	i0	93.301	349.124401913876	209	14	100	0	1	209	1375	1583	Uncultured Acidobacteria bacterium clone DON16 23S ribosomal RNA gene, partial sequence	blastn	72967	309	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18520639	18520639	PRJNA688931_P_NODE_37355_length_167_cov_0.872881_g37142_i0	PRJNA688931	37355	167	0.872881	1.45771127	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	156	1.04e-33	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g37142	i0	86	0.898203592814371	150	16	89	5	19	167	2049116	2048971	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	150	156	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20304434	20304434	PRJNA688931_P_NODE_17396_length_246_cov_1.532995_g17183_i0	PRJNA688931	17396	246	1.532995	3.7711677	Bacteria	2	Bacteria	Bacteria	296	9.3e-76	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g17183	i0	90.667	235.841463414634	225	17	90	2	1	221	9455	9231	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	58017	296	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21070976	21070976	PRJNA688931_P_NODE_34917_length_169_cov_1.725000_g34704_i0	PRJNA688931	34917	169	1.725	2.91525	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	171	3.73e-38	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g34704	i0	86.624	11.3786982248521	157	17	92	4	1	155	634485	634639	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	1923	171	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
23621392	23621392	PRJNA688931_P_NODE_31079_length_182_cov_1.075188_g30866_i0	PRJNA688931	31079	182	1.075188	1.95684216	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	292	8.38e-75	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g30866	i0	95.604	364.626373626374	182	8	100	0	1	182	2907424	2907605	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	66362	292	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24894634	24894634	PRJNA688931_P_NODE_22120_length_217_cov_3.005952_g21907_i0	PRJNA688931	22120	217	3.005952	6.52291584	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	296	8.02e-76	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g21907	i0	91.244	154.175115207373	217	19	100	0	1	217	228	12	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	33456	296	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus

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);;