metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA1111077" 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
214350	214350	PRJNA1111077_P_NODE_11981_length_342_cov_6.947955_g11760_i0	PRJNA1111077	11981	342	6.947955	23.7620061	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	571	2.0099999999999995e-158	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g11760	i0	97.05	102.099415204678	339	10	99	0	4	342	11480	11142	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	34918	571	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1489169	1489169	PRJNA1111077_P_NODE_15442_length_310_cov_3.101266_g15221_i0	PRJNA1111077	15442	310	3.101266	9.6139246	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	87.9	7.94e-13	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g15221	i0	98	0.274193548387097	50	1	16	0	56	105	4801074	4801025	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	85	87.9	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1489343	1489343	PRJNA1111077_P_NODE_22542_length_278_cov_2.941463_g22321_i0	PRJNA1111077	22542	278	2.941463	8.17726714	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	475	1.2799999999999997e-129	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g22321	i0	97.482	161.892086330935	278	7	100	0	1	278	4573328	4573051	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	45006	475	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
1489424	1489424	PRJNA1111077_P_NODE_26082_length_266_cov_1.461140_g25861_i0	PRJNA1111077	26082	266	1.46114	3.8866324	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	285	2.2e-72	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g25861	i0	86.486	63.3157894736842	259	35	97	0	8	266	318693	318951	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	16842	285	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
2296567	2296567	PRJNA1111077_P_NODE_25762_length_267_cov_1.587629_g25541_i0	PRJNA1111077	25762	267	1.587629	4.23896943	Terriglobus	392733	Bacteria	Bacteria	422	1.62e-113	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g25541	i0	95.131	57.0224719101124	267	13	100	0	1	267	3869999	3870265	Terriglobus saanensis SP1PR4, complete genome	blastn	15225	422	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
2765459	2765459	PRJNA1111077_P_NODE_28243_length_258_cov_1.405405_g28022_i0	PRJNA1111077	28243	258	1.405405	3.6259449	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	200	7.93e-47	NTclustered	gi\|559114290\|tpe\|HG526005.1\|	234267	g28022	i0	81.25	4.95736434108527	256	40	98	8	1	253	48	298	TPA: Candidatus Solibacter usitatus Ellin6076 tmRNA gene Solib_usita_Ellin6	blastn	1279	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
4041298	4041298	PRJNA1111077_P_NODE_14984_length_310_cov_4.059072_g14763_i0	PRJNA1111077	14984	310	4.059072	12.5831232	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	104	7.88e-18	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g14763	i0	79.861	4.41935483870968	144	27	46	2	168	310	2217316	2217174	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	1370	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
4041447	4041447	PRJNA1111077_P_NODE_20984_length_283_cov_4.385714_g20763_i0	PRJNA1111077	20984	283	4.385714	12.411570620000001	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	481	2.81e-131	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g20763	i0	97.518	2.99293286219081	282	6	99	1	2	283	3813243	3813523	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	847	481	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5317837	5317837	PRJNA1111077_P_NODE_35685_length_242_cov_5.230769_g35464_i0	PRJNA1111077	35685	242	5.230769	12.65846098	Luteitalea pratensis	1855912	Bacteria	Bacteria	222	1.57e-53	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g35464	i0	86.667	51.6528925619835	210	16	83	11	42	242	4171518	4171724	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	12500	222	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
6592547	6592547	PRJNA1111077_P_NODE_14806_length_310_cov_4.898734_g14585_i0	PRJNA1111077	14806	310	4.898734	15.1860754	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	267	9.5e-67	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g14585	i0	98.667	57.4741935483871	150	2	97	0	161	310	2908018	2907869	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	17817	267	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6592642	6592642	PRJNA1111077_P_NODE_18786_length_291_cov_1.151376_g18565_i0	PRJNA1111077	18786	291	1.151376	3.35050416	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	104	7.34e-18	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g18565	i0	88.636	0.302405498281787	88	7	30	3	205	290	2211193	2211107	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	88	104	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6593190	6593190	PRJNA1111077_P_NODE_5866_length_474_cov_9.743142_g5645_i0	PRJNA1111077	5866	474	9.743142	46.18249308	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	577	6.15e-160	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g5645	i0	88.595	220.886075949367	491	35	100	15	1	474	11662	12148	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	104700	577	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7398858	7398858	PRJNA1111077_P_NODE_19126_length_290_cov_1.064516_g18905_i0	PRJNA1111077	19126	290	1.064516	3.0870964	Acidobacteriaceae	204434	Bacteria	Bacteria	106	2.03e-18	NTclustered	gi\|225791207\|gb\|CP001472.1\|	240015	g18905	i0	93.056	21.0034482758621	72	5	25	0	34	105	1583185	1583256	Acidobacterium capsulatum ATCC 51196, complete genome	blastn	6091	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
7867748	7867748	PRJNA1111077_P_NODE_37647_length_232_cov_2.528302_g37426_i0	PRJNA1111077	37647	232	2.528302	5.86566064	Paludibaculum fermentans	1473598	Bacteria	Bacteria	231	2.48e-56	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g37426	i0	85.52	17.9870689655172	221	32	95	0	1	221	5810360	5810580	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	4173	231	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
9141978	9141978	PRJNA1111077_P_NODE_11288_length_352_cov_5.028674_g11067_i0	PRJNA1111077	11288	352	5.028674	17.70093248	Bryobacterales bacterium	2026791	Bacteria	Bacteria	562	1.2399999999999997e-155	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g11067	i0	95.455	67.3096590909091	352	16	100	0	1	352	6659785	6659434	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	23693	562	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
12968207	12968207	PRJNA1111077_P_NODE_11551_length_348_cov_3.749091_g11330_i0	PRJNA1111077	11551	348	3.749091	13.04683668	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	638	1.99e-178	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g11330	i0	99.713	108.997126436782	348	1	100	0	1	348	4732895	4732548	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	37931	638	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14243860	14243860	PRJNA1111077_P_NODE_4172_length_552_cov_5.313152_g3951_i0	PRJNA1111077	4172	552	5.313152	29.32859904	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	800	0	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g3951	i0	92.679	112.101449275362	560	33	100	5	1	552	4732915	4733474	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	61880	800	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14243929	14243929	PRJNA1111077_P_NODE_6452_length_454_cov_3.766404_g6231_i0	PRJNA1111077	6452	454	3.766404	17.09947416	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	433	1.35e-116	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g6231	i0	93.197	237.748898678414	294	20	98	0	161	454	2907345	2907052	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	107938	433	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15517568	15517568	PRJNA1111077_P_NODE_36733_length_241_cov_0.916667_g36512_i0	PRJNA1111077	36733	241	0.916667	2.20916747	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|2814788339\|emb\|OY761475.2\|	2910147	g36512	i0	89.958	5.78423236514523	239	24	99	0	1	239	1406646	1406884	MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1	blastn	1394	309	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
19340867	19340867	PRJNA1111077_P_NODE_36816_length_241_cov_0.916667_g36595_i0	PRJNA1111077	36816	241	0.916667	2.20916747	Luteitalea pratensis	1855912	Bacteria	Bacteria	379	8.759999999999998e-101	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g36595	i0	95.021	1	241	12	100	0	1	241	2415198	2414958	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	241	379	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
19340903	19340903	PRJNA1111077_P_NODE_38396_length_204_cov_8.786260_g38175_i0	PRJNA1111077	38396	204	8.78626	17.9239704	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	113	8.050000000000001e-21	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g38175	i0	88.421	2.71078431372549	95	9	46	2	49	142	3020170	3020077	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	553	113	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20615516	20615516	PRJNA1111077_P_NODE_10257_length_368_cov_11.779661_g10036_i0	PRJNA1111077	10257	368	11.779661	43.34915248	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	158	7.2e-34	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g10036	i0	77.288	3.90217391304348	295	49	79	16	79	368	4464786	4465067	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	1436	158	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
20616097	20616097	PRJNA1111077_P_NODE_34617_length_244_cov_1.432749_g34396_i0	PRJNA1111077	34617	244	1.432749	3.49590756	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	102	2.15e-17	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g34396	i0	81.203	0.545081967213115	133	20	54	5	112	242	4506654	4506525	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	133	102	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21891224	21891224	PRJNA1111077_P_NODE_12958_length_329_cov_5.195312_g12737_i0	PRJNA1111077	12958	329	5.195312	17.09257648	Holophagales bacterium	2478486	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g12737	i0	100	0.088145896656535	29	0	9	0	301	329	860345	860373	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
21891381	21891381	PRJNA1111077_P_NODE_18818_length_290_cov_4.631336_g18597_i0	PRJNA1111077	18818	290	4.631336	13.4308744	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	313	1.12e-80	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g18597	i0	87.544	184.4	281	22	93	7	1	270	2907726	2907448	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	53476	313	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21891650	21891650	PRJNA1111077_P_NODE_30018_length_251_cov_1.460674_g29797_i0	PRJNA1111077	30018	251	1.460674	3.66629174	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	65.8	2.92e-6	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g29797	i0	91.489	0.390438247011952	47	4	19	0	53	99	5513890	5513936	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	98	65.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
21891852	21891852	PRJNA1111077_P_NODE_38258_length_214_cov_15.333333_g38037_i0	PRJNA1111077	38258	214	15.333333	32.81333262	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	270	4.779999999999999e-68	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g38037	i0	94.318	173.747663551402	176	10	82	0	36	211	11855	12030	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	37182	270	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23973331	23973331	PRJNA1111077_P_NODE_14079_length_315_cov_8.780992_g13858_i0	PRJNA1111077	14079	315	8.780992	27.6601248	Luteitalea	2004797	Bacteria	Bacteria	566	8.519999999999997e-157	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g13858	i0	99.048	444.733333333333	315	3	100	0	1	315	654450	654764	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	140091	566	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
24440640	24440640	PRJNA1111077_P_NODE_260_length_1534_cov_12.409309_g174_i0	PRJNA1111077	260	1534	12.409309	190.35880006	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	1805	0	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g174	i0	87.974	96.0241199478488	1555	154	99	22	2	1534	3558917	3557374	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	147301	1805	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae 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);;