metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA864829" 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
847257	847257	PRJNA864829_S_NODE_15401_length_166_cov_2.316239_g15315_i0	PRJNA864829	15401	166	2.316239	3.84495674	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	255	9.870000000000001e-64	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g15315	i0	94.578	63.7710843373494	166	8	100	1	1	166	1690510	1690346	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	10586	255	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
847303	847303	PRJNA864829_S_NODE_8321_length_215_cov_3.825301_g8235_i0	PRJNA864829	8321	215	3.825301	8.22439715	Terriglobia bacterium	2081523	Bacteria	Bacteria	307	3.66e-79	NTclustered	gi\|2814788349\|emb\|OY760650.2\|	2081523	g8235	i0	93.269	105.893023255814	208	14	97	0	1	208	2203050	2203257	MAG: Terriglobia bacterium isolate 5d79d33f-5ea2-468b-941e-0445094ce055 genome assembly, chromosome: 1	blastn	22767	307	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
2122668	2122668	PRJNA864829_S_NODE_6322_length_241_cov_7.541667_g6236_i0	PRJNA864829	6322	241	7.541667	18.17541747	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	255	1.54e-63	NTclustered	gi\|217038917\|gb\|EU811008.1\|	171953	g6236	i0	85.95	10.9875518672199	242	31	100	3	1	241	307	68	Uncultured Acidobacteria bacterium clone 01QCW 23S ribosomal RNA gene, partial sequence	blastn	2648	255	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2122677	2122677	PRJNA864829_S_NODE_7942_length_219_cov_2.658824_g7856_i0	PRJNA864829	7942	219	2.658824	5.82282456	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	283	6.31e-72	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g7856	i0	92.929	440.013698630137	198	9	89	5	1	195	715251	715446	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	96363	283	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3398017	3398017	PRJNA864829_S_NODE_3383_length_303_cov_3.669291_g3297_i0	PRJNA864829	3383	303	3.669291	11.11795173	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	375	1.4699999999999999e-99	NTclustered	gi\|117557517\|emb\|AM180906.2\|	171953	g3297	i0	89.18	419.316831683168	305	28	100	5	1	303	59	360	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone UD6 LS_LKC22_kan3	blastn	127053	375	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3788777	3788777	PRJNA864829_S_NODE_1003_length_480_cov_2.911833_g917_i0	PRJNA864829	1003	480	2.911833	13.9767984	Bacteria	2	Bacteria	Bacteria	300	1.51e-76	NTclustered	gi\|112980853\|gb\|DQ829657.1\|	171953	g917	i0	81.414	99.4125	382	58	78	10	107	480	1494	1870	Uncultured Acidobacteria bacterium clone DON33 23S ribosomal RNA gene, partial sequence	blastn	47718	300	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4675706	4675706	PRJNA864829_S_NODE_14944_length_168_cov_1.386555_g14858_i0	PRJNA864829	14944	168	1.386555	2.3294124	Sulfidibacter corallicola	2818388	Bacteria	Bacteria	137	3.79e-28	NTclustered	gi\|2013124720\|gb\|CP071793.1\|	2818388	g14858	i0	84.672	0.81547619047619	137	21	82	0	32	168	10531866	10531730	Sulfidibacter corallicola strain M133 chromosome, complete genome	blastn	137	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Acanthopleuribacterales	Acanthopleuribacteraceae	Sulfidibacter	Sulfidibacter corallicola
4675715	4675715	PRJNA864829_S_NODE_2004_length_366_cov_2.750789_g1918_i0	PRJNA864829	2004	366	2.750789	10.06788774	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	357	6.58e-94	NTclustered	gi\|117557517\|emb\|AM180906.2\|	171953	g1918	i0	86.053	56.1639344262295	337	42	92	5	9	344	1144	1476	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone UD6 LS_LKC22_kan3	blastn	20556	357	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4675723	4675723	PRJNA864829_S_NODE_324_length_736_cov_11.339156_g263_i0	PRJNA864829	324	736	11.339156	83.45618816	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	281	8.64e-71	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g263	i0	75.914	195.417119565217	602	116	80	25	5	591	3918103	3917516	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	143827	281	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5950561	5950561	PRJNA864829_S_NODE_13285_length_176_cov_1.535433_g13199_i0	PRJNA864829	13285	176	1.535433	2.70236208	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	246	6.349999999999999e-61	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g13199	i0	96.026	111.625	151	6	86	0	26	176	4652062	4652212	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	19646	246	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5950570	5950570	PRJNA864829_S_NODE_16305_length_160_cov_2.675676_g16219_i0	PRJNA864829	16305	160	2.675676	4.2810816	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	200	4.48e-47	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g16219	i0	89.308	270.84375	159	17	99	0	1	159	3176886	3177044	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	43335	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
5950578	5950578	PRJNA864829_S_NODE_2545_length_336_cov_2.229965_g2459_i0	PRJNA864829	2545	336	2.229965	7.4926824	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	532	9.289999999999999e-147	NTclustered	gi\|117557517\|emb\|AM180906.2\|	171953	g2459	i0	95.252	100.526785714286	337	15	100	1	1	336	485	821	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone UD6 LS_LKC22_kan3	blastn	33777	532	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5950612	5950612	PRJNA864829_S_NODE_9925_length_200_cov_1.741722_g9839_i0	PRJNA864829	9925	200	1.741722	3.483444	Paludibaculum fermentans	1473598	Bacteria	Bacteria	270	4.4099999999999986e-68	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g9839	i0	91.837	17.615	196	13	97	3	7	200	4785920	4785726	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	3523	270	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
9775324	9775324	PRJNA864829_S_NODE_6848_length_234_cov_1.854054_g6762_i0	PRJNA864829	6848	234	1.854054	4.33848636	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	206	1.52e-48	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g6762	i0	82.627	88.4358974358974	236	37	100	4	1	234	9814	10047	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	20694	206	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12326408	12326408	PRJNA864829_S_NODE_1190_length_448_cov_12.203008_g1104_i0	PRJNA864829	1190	448	12.203008	54.66947584	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	520	9.89e-143	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g1104	i0	87.773	115.361607142857	458	39	99	15	1	447	2284797	2285248	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	51682	520	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12326412	12326412	PRJNA864829_S_NODE_13150_length_177_cov_1.265625_g13064_i0	PRJNA864829	13150	177	1.265625	2.24015625	Granulicella sp. WH15	2602070	Bacteria	Bacteria	106	1.13e-18	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g13064	i0	92	77.1751412429379	75	6	42	0	19	93	399010	399084	Granulicella sp. WH15 chromosome, complete genome	blastn	13660	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15
13600939	13600939	PRJNA864829_S_NODE_11231_length_190_cov_1.439716_g11145_i0	PRJNA864829	11231	190	1.439716	2.7354604	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	211	2.54e-50	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g11145	i0	92.568	383.478947368421	148	10	77	1	25	171	715296	715149	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	72861	211	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13600959	13600959	PRJNA864829_S_NODE_2451_length_339_cov_7.241379_g2365_i0	PRJNA864829	2451	339	7.241379	24.54827481	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	385	2.78e-102	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g2365	i0	88.818	324.814159292035	313	35	92	0	3	315	3559017	3559329	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	110112	385	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
14875289	14875289	PRJNA864829_S_NODE_2612_length_332_cov_2.406360_g2526_i0	PRJNA864829	2612	332	2.40636	7.9891152	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	377	4.54e-100	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g2526	i0	87.311	97.2771084337349	331	40	99	2	1	330	1785108	1784779	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	32296	377	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15264764	15264764	PRJNA864829_S_NODE_1072_length_465_cov_7.045673_g986_i0	PRJNA864829	1072	465	7.045673	32.76237945	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	135	4.36e-27	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g986	i0	91.837	2.31827956989247	98	6	21	2	240	337	3097255	3097160	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	1078	135	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17425473	17425473	PRJNA864829_S_NODE_454_length_640_cov_18.296108_g382_i0	PRJNA864829	454	640	18.296108	117.0950912	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	957	0	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g382	i0	93.548	143.8734375	651	29	100	7	1	640	715727	715079	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	92079	957	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18698599	18698599	PRJNA864829_S_NODE_13255_length_176_cov_2.118110_g13169_i0	PRJNA864829	13255	176	2.11811	3.7278736	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	110	8.69e-20	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g13169	i0	83.333	0.681818181818182	120	18	68	2	58	176	1174335	1174217	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	120	110	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
18698601	18698601	PRJNA864829_S_NODE_13735_length_173_cov_2.524194_g13649_i0	PRJNA864829	13735	173	2.524194	4.36685562	uncultured Thermoanaerobaculia bacterium	3036248	Bacteria	Bacteria	148	1.7999999999999998e-31	NTclustered	gi\|2518540615\|emb\|OX638294.1\|	3036248	g13649	i0	82.081	16.4971098265896	173	31	100	0	1	173	2657038	2657210	MAG: uncultured Thermoanaerobaculia bacterium isolate 42478a12-5572-4d71-959b-92ffd854a98d genome assembly, chromosome: 1	blastn	2854	148	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				uncultured Thermoanaerobaculia bacterium
18698614	18698614	PRJNA864829_S_NODE_295_length_767_cov_17.669916_g237_i0	PRJNA864829	295	767	17.669916	135.52825572	Bryobacterales bacterium	2026791	Bacteria	Bacteria	887	0	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g237	i0	88.503	103.637548891786	748	67	96	17	1	737	6659104	6659843	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	79490	887	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
19973906	19973906	PRJNA864829_S_NODE_7096_length_230_cov_5.138122_g7010_i0	PRJNA864829	7096	230	5.138122	11.8176806	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	228	3.1799999999999992e-55	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g7010	i0	84.681	475.686956521739	235	28	100	7	1	230	2285467	2285236	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	109408	228	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19973908	19973908	PRJNA864829_S_NODE_7236_length_228_cov_4.044693_g7150_i0	PRJNA864829	7236	228	4.044693	9.22190004	Paludibaculum fermentans	1473598	Bacteria	Bacteria	198	2.4699999999999998e-46	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g7150	i0	84.577	23.6184210526316	201	29	88	2	26	225	4787470	4787271	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	5385	198	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
21249415	21249415	PRJNA864829_S_NODE_10057_length_199_cov_1.386667_g9971_i0	PRJNA864829	10057	199	1.386667	2.75946733	Mesoterricola sediminis	2927980	Bacteria	Bacteria	150	5.95e-32	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g9971	i0	82.022	39.3819095477387	178	30	88	2	24	199	2520415	2520592	Mesoterricola sediminis W786 DNA, complete genome	blastn	7837	150	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
21249449	21249449	PRJNA864829_S_NODE_5157_length_261_cov_1.707547_g5071_i0	PRJNA864829	5157	261	1.707547	4.45669767	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	58.4	5.12e-4	NTclustered	gi\|2913438576\|emb\|OZ223985.1\|	2793154	g5071	i0	89.362	0.360153256704981	47	3	18	2	163	209	3724986	3725030	MAG: Vicinamibacteria bacterium isolate c1004ee9-65a7-452c-baee-c28c3200ebb6 genome assembly, chromosome: 1	blastn	94	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
22914564	22914564	PRJNA864829_S_NODE_598_length_584_cov_9.790654_g382_i1	PRJNA864829	598	584	9.790654	57.17741936	Bacteria	2	Bacteria	Bacteria	821	0	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g382	i1	91.933	132.686643835616	595	35	100	7	1	584	715727	715135	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	77489	821	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25073370	25073370	PRJNA864829_S_NODE_260_length_814_cov_11.415686_g208_i0	PRJNA864829	260	814	11.415686000000001	92.92368404	Bryobacterales bacterium	2026791	Bacteria	Bacteria	955	0	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g208	i0	87.879	133.114250614251	825	84	100	15	1	814	6659104	6659923	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	108355	955	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
25073400	25073400	PRJNA864829_S_NODE_900_length_500_cov_10.547672_g814_i0	PRJNA864829	900	500	10.547672	52.73836	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	425	2.5e-114	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g814	i0	83.772	99.974	456	67	90	6	1	451	28	481	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	49987	425	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);;