metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA980839" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA980839" 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
957639	957639	PRJNA980839_P_NODE_161901_length_277_cov_1.274510_g158117_i0	PRJNA980839	161901	277	1.27451	3.5303927	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	327	3.78e-85	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g158117	i0	88.043	3.93140794223827	276	33	99	0	2	277	3060164	3060439	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	1089	327	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
958596	958596	PRJNA980839_P_NODE_209221_length_248_cov_0.880000_g205437_i0	PRJNA980839	209221	248	0.88	2.1824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	130	1.01e-25	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g205437	i0	96.203	2.45161290322581	79	3	32	0	144	222	2234832	2234754	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	608	130	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1270535	1270535	PRJNA980839_P_NODE_51141_length_595_cov_1.446360_g47399_i0	PRJNA980839	51141	595	1.44636	8.605842	Pseudomonadati	3379134	Bacteria	Bacteria	121	1.59e-22	NTclustered	gi\|2874254120\|emb\|OY970205.1\|	194844	g47399	i0	93.75	15.1310924369748	80	5	13	0	325	404	4109345	4109266	MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1	blastn	9003	121	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
2234270	2234270	PRJNA980839_P_NODE_226322_length_244_cov_0.900585_g222538_i0	PRJNA980839	226322	244	0.900585	2.1974274	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	224	4.4099999999999997e-54	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g222538	i0	83.333	1.00819672131148	246	37	100	4	1	244	6686459	6686216	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	246	224	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
4785506	4785506	PRJNA980839_P_NODE_141404_length_296_cov_1.035874_g137620_i0	PRJNA980839	141404	296	1.035874	3.06618704	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	202	2.58e-47	NTclustered	gi\|2874253940\|emb\|OY970265.1\|	171953	g137620	i0	79.381	3.22635135135135	291	56	98	4	8	296	1827328	1827040	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.1.56 genome assembly, chromosome: 1	blastn	955	202	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4785665	4785665	PRJNA980839_P_NODE_150184_length_287_cov_1.275701_g146400_i0	PRJNA980839	150184	287	1.275701	3.66126187	Geothrix sp.	1962974	Bacteria	Bacteria	398	2.9599999999999997e-106	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g146400	i0	91.667	63.3275261324042	288	22	100	2	1	287	2311910	2312196	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	18175	398	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
4785753	4785753	PRJNA980839_P_NODE_154604_length_283_cov_1.385714_g150820_i0	PRJNA980839	154604	283	1.385714	3.92157062	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2626255659\|emb\|OY843766.1\|	1241325	g150820	i0	100	0.0989399293286219	28	0	10	0	125	152	2832460	2832487	MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
6061465	6061465	PRJNA980839_P_NODE_188265_length_257_cov_1.255435_g184481_i0	PRJNA980839	188265	257	1.255435	3.22646795	Luteitalea pratensis	1855912	Bacteria	Bacteria	215	2.82e-51	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g184481	i0	81.853	1.00778210116732	259	43	100	4	1	257	1060341	1060597	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	259	215	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
8923415	8923415	PRJNA980839_P_NODE_61227_length_515_cov_1.185520_g57450_i0	PRJNA980839	61227	515	1.18552	6.105428	Pseudomonadati	3379134	Bacteria	Bacteria	789	0	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g57450	i0	95.19	101.570873786408	499	24	97	0	17	515	1909	1411	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	52309	789	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
9885973	9885973	PRJNA980839_P_NODE_174068_length_267_cov_1.587629_g170284_i0	PRJNA980839	174068	267	1.587629	4.23896943	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	139	1.82e-28	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g170284	i0	89.189	3.33333333333333	111	12	42	0	1	111	4603189	4603299	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	890	139	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
9887357	9887357	PRJNA980839_P_NODE_243028_length_233_cov_4.131250_g239244_i0	PRJNA980839	243028	233	4.13125	9.6258125	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	178	3.3e-40	NTclustered	gi\|2874254114\|emb\|OY970199.1\|	194844	g239244	i0	81.081	0.952789699570815	222	42	95	0	12	233	2288244	2288023	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04463.bin.1.15 genome assembly, chromosome: 1	blastn	222	178	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
11162309	11162309	PRJNA980839_P_NODE_225849_length_244_cov_0.900585_g222065_i0	PRJNA980839	225849	244	0.900585	2.1974274	Paludibaculum fermentans	1473598	Bacteria	Bacteria	324	4.22e-84	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g222065	i0	90.574	1	244	23	100	0	1	244	2549398	2549155	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	244	324	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
12436601	12436601	PRJNA980839_P_NODE_149890_length_287_cov_1.439252_g146106_i0	PRJNA980839	149890	287	1.439252	4.13065324	Terriglobia bacterium	2081523	Bacteria	Bacteria	270	6.7299999999999984e-68	NTclustered	gi\|2874253655\|emb\|OY968796.1\|	2081523	g146106	i0	83.681	9.03135888501742	288	46	100	1	1	287	16743	16456	MAG: Terriglobia bacterium isolate MFD04463.bin.1.19 genome assembly, chromosome: 1	blastn	2592	270	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
14986752	14986752	PRJNA980839_P_NODE_222972_length_245_cov_0.895349_g219188_i0	PRJNA980839	222972	245	0.895349	2.19360505	Terriglobus roseus	392734	Bacteria	Bacteria	220	5.73e-53	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g219188	i0	82.927	2.01224489795918	246	40	100	2	1	245	4683608	4683364	Terriglobus roseus DSM 18391, complete genome	blastn	493	220	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
16261450	16261450	PRJNA980839_P_NODE_206913_length_249_cov_0.875000_g203129_i0	PRJNA980839	206913	249	0.875	2.17875	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	87.9	6.18e-13	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g203129	i0	100	0.188755020080321	47	0	19	0	149	195	2593397	2593351	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	47	87.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
17536261	17536261	PRJNA980839_P_NODE_196514_length_251_cov_1.730337_g192730_i0	PRJNA980839	196514	251	1.730337	4.34314587	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	274	4.46e-69	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g192730	i0	86.561	65.1752988047809	253	29	99	5	1	250	2716185	2716435	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	16359	274	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17537044	17537044	PRJNA980839_P_NODE_237334_length_241_cov_0.916667_g233550_i0	PRJNA980839	237334	241	0.916667	2.20916747	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	219	2.02e-52	NTclustered	gi\|2874253950\|emb\|OY970275.1\|	171953	g233550	i0	83.128	1.00829875518672	243	37	100	4	1	241	1116859	1117099	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.c.2 genome assembly, chromosome: 1	blastn	243	219	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20084859	20084859	PRJNA980839_P_NODE_197816_length_251_cov_0.865169_g194032_i0	PRJNA980839	197816	251	0.865169	2.17157419	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	182	2.78e-41	NTclustered	gi\|2874253679\|emb\|OY969113.1\|	171953	g194032	i0	80.591	1.81274900398406	237	44	94	2	1	236	2104056	2104291	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.1.55 genome assembly, chromosome: 1	blastn	455	182	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20085132	20085132	PRJNA980839_P_NODE_210896_length_248_cov_0.880000_g207112_i0	PRJNA980839	210896	248	0.88	2.1824	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	259	1.23e-64	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g207112	i0	85.542	1.39516129032258	249	34	100	2	1	248	3860794	3860547	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	346	259	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
20087056	20087056	PRJNA980839_P_NODE_91436_length_384_cov_1.588424_g87652_i0	PRJNA980839	91436	384	1.588424	6.09954816	Geothrix oryzae	2927975	Bacteria	Bacteria	65.8	4.71e-6	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g87652	i0	100	0.315104166666667	35	0	9	0	5	39	2233433	2233467	Geothrix oryzae Red222 DNA, complete genome	blastn	121	65.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
21360452	21360452	PRJNA980839_P_NODE_198217_length_251_cov_0.865169_g194433_i0	PRJNA980839	198217	251	0.865169	2.17157419	Bryobacterales bacterium	2026791	Bacteria	Bacteria	167	7.789999999999999e-37	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g194433	i0	82.796	53.9721115537849	186	32	74	0	12	197	6692154	6692339	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	13547	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
23910868	23910868	PRJNA980839_P_NODE_193539_length_253_cov_1.711111_g189755_i0	PRJNA980839	193539	253	1.711111	4.32911083	Geothrix sp.	1962974	Bacteria	Bacteria	254	5.86e-63	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g189755	i0	84.861	1.98418972332016	251	38	99	0	1	251	1366086	1366336	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	502	254	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
23911043	23911043	PRJNA980839_P_NODE_201219_length_250_cov_1.141243_g197435_i0	PRJNA980839	201219	250	1.141243	2.8531075	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	9.61e-66	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g197435	i0	85.944	9.656	249	31	99	4	3	250	2366887	2367132	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	2414	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23911423	23911423	PRJNA980839_P_NODE_222139_length_245_cov_0.895349_g218355_i0	PRJNA980839	222139	245	0.895349	2.19360505	Terriglobia bacterium	2081523	Bacteria	Bacteria	137	5.93e-28	NTclustered	gi\|2874253655\|emb\|OY968796.1\|	2081523	g218355	i0	87.931	21.7591836734694	116	14	47	0	129	244	200324	200209	MAG: Terriglobia bacterium isolate MFD04463.bin.1.19 genome assembly, chromosome: 1	blastn	5331	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
25183720	25183720	PRJNA980839_P_NODE_156500_length_281_cov_1.937500_g152716_i0	PRJNA980839	156500	281	1.9375	5.444375	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	187	6.809999999999998e-43	NTclustered	gi\|2874253721\|emb\|OY969563.1\|	2952895	g152716	i0	79.259	1.23487544483986	270	54	96	2	13	281	4462572	4462840	MAG: Candidatus Acidoferrales bacterium isolate MFD05580.bin.1.43 genome assembly, chromosome: 1	blastn	347	187	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
25184247	25184247	PRJNA980839_P_NODE_182060_length_261_cov_1.638298_g178276_i0	PRJNA980839	182060	261	1.638298	4.27595778	Geothrix oryzae	2927975	Bacteria	Bacteria	281	2.79e-71	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g178276	i0	86.26	1.00383141762452	262	32	99	4	2	261	544127	543868	Geothrix oryzae Red222 DNA, complete genome	blastn	262	281	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae

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