metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1092581" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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
1470891	1470891	PRJNA1092581_P_NODE_19662_length_628_cov_2.612613_g19143_i0	PRJNA1092581	19662	628	2.612613	16.40720964	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	407	1.15e-108	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g19143	i0	80.106	59.0971337579618	568	96	90	13	13	575	5784066	5784621	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	37113	407	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2746683	2746683	PRJNA1092581_P_NODE_121783_length_216_cov_20.797203_g121250_i0	PRJNA1092581	121783	216	20.797203	44.92195848	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	193	1.0800000000000001e-44	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g121250	i0	93.13	132.305555555556	131	9	61	0	22	152	1822672	1822542	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	28578	193	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
2746694	2746694	PRJNA1092581_P_NODE_122463_length_214_cov_7.978723_g121930_i0	PRJNA1092581	122463	214	7.978723	17.07446722	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	248	2.24e-61	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g121930	i0	89.848	74.3224299065421	197	15	91	5	21	214	317252	317446	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	15905	248	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
3569231	3569231	PRJNA1092581_P_NODE_78863_length_291_cov_16.041284_g78330_i0	PRJNA1092581	78863	291	16.041284	46.68013644	Pseudomonadati	3379134	Bacteria	Bacteria	215	3.25e-51	NTclustered	gi\|112980879\|gb\|DQ829683.1\|	171953	g78330	i0	84.141	139.907216494845	227	31	77	5	16	239	586	362	Uncultured Acidobacteria bacterium clone DON28 23S ribosomal RNA gene, partial sequence	blastn	40713	215	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4022564	4022564	PRJNA1092581_P_NODE_119184_length_224_cov_7.973510_g118651_i0	PRJNA1092581	119184	224	7.97351	17.8606624	Luteitalea pratensis	1855912	Bacteria	Bacteria	287	5.009999999999999e-73	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g118651	i0	93.717	9.21428571428571	191	12	85	0	21	211	654756	654946	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	2064	287	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
6573938	6573938	PRJNA1092581_P_NODE_126466_length_202_cov_6.689922_g125933_i0	PRJNA1092581	126466	202	6.689922	13.51364244	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	213	7.62e-51	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g125933	i0	95.489	142.490099009901	133	6	66	0	21	153	1822674	1822542	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	28783	213	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
6575509	6575509	PRJNA1092581_P_NODE_71026_length_310_cov_3.869198_g70493_i0	PRJNA1092581	71026	310	3.869198	11.9945138	Holophagales bacterium	2478486	Bacteria	Bacteria	156	2.15e-33	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g70493	i0	81.407	15.441935483871	199	30	63	6	21	215	1061621	1061426	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	4787	156	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
6576066	6576066	PRJNA1092581_P_NODE_93086_length_264_cov_2.267016_g92553_i0	PRJNA1092581	93086	264	2.267016	5.98492224	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	241	4.8e-59	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g92553	i0	84.426	85.2765151515152	244	38	94	0	21	264	3557911	3557668	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	22513	241	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
7848273	7848273	PRJNA1092581_P_NODE_104547_length_247_cov_1.488506_g104014_i0	PRJNA1092581	104547	247	1.488506	3.67660982	Bryobacterales bacterium	2026791	Bacteria	Bacteria	353	5.46e-93	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g104014	i0	94.397	169.68016194332	232	10	93	3	18	247	6659355	6659125	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	41911	353	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
7848942	7848942	PRJNA1092581_P_NODE_18827_length_641_cov_4.130282_g18310_i0	PRJNA1092581	18827	641	4.130282	26.47510762	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	874	0	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g18310	i0	92.038	230.546021840874	628	41	97	8	20	641	359608	360232	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	147780	874	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
9946344	9946344	PRJNA1092581_P_NODE_27648_length_528_cov_37.819780_g27116_i0	PRJNA1092581	27648	528	37.81978	199.6884384	Bacteria	2	Bacteria	Bacteria	647	0	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g27116	i0	89.768	444.768939393939	518	36	96	14	1	507	715737	716248	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	234838	647	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10401415	10401415	PRJNA1092581_P_NODE_88309_length_272_cov_6.748744_g87776_i0	PRJNA1092581	88309	272	6.748744	18.35658368	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	305	1.74e-78	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g87776	i0	89.069	302.172794117647	247	26	90	1	21	266	3298213	3298459	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	82191	305	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11676255	11676255	PRJNA1092581_P_NODE_69770_length_313_cov_7.925000_g69237_i0	PRJNA1092581	69770	313	7.925	24.80525	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	387	7.069999999999998e-103	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g69237	i0	90.69	164.600638977636	290	27	93	0	2	291	3298452	3298163	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	51520	387	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14224500	14224500	PRJNA1092581_P_NODE_111492_length_237_cov_8.213415_g110959_i0	PRJNA1092581	111492	237	8.213415	19.46579355	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	351	1.87e-92	NTclustered	gi\|2874253852\|emb\|OY969908.1\|	194844	g110959	i0	95.853	92.2236286919831	217	9	92	0	1	217	2169497	2169281	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1	blastn	21857	351	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
15500508	15500508	PRJNA1092581_P_NODE_78993_length_291_cov_4.706422_g78460_i0	PRJNA1092581	78993	291	4.706422	13.69568802	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	366	8.48e-97	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g78460	i0	90.975	84.3539518900344	277	18	94	6	19	291	3299713	3299986	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	24547	366	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15500658	15500658	PRJNA1092581_P_NODE_84813_length_279_cov_3.184466_g84280_i0	PRJNA1092581	84813	279	3.184466	8.88466014	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	436	6.069999999999999e-118	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g84280	i0	96.935	173.698924731183	261	7	93	1	1	260	284	24	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	48462	436	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16774931	16774931	PRJNA1092581_P_NODE_78674_length_292_cov_2.958904_g78141_i0	PRJNA1092581	78674	292	2.958904	8.63999968	Luteitalea pratensis	1855912	Bacteria	Bacteria	89.8	2.06e-13	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g78141	i0	88.889	14.9246575342466	72	8	25	0	87	158	4678848	4678919	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	4358	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
18049207	18049207	PRJNA1092581_P_NODE_65735_length_324_cov_10.067729_g65202_i0	PRJNA1092581	65735	324	10.067729	32.61944196	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	366	9.57e-97	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g65202	i0	88.487	101.388888888889	304	34	94	1	22	324	317252	317555	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	32850	366	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
20598235	20598235	PRJNA1092581_P_NODE_52577_length_369_cov_6.560811_g52044_i0	PRJNA1092581	52577	369	6.560811	24.20939259	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	329	1.45e-85	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g52044	i0	84.32	3.47425474254743	338	51	91	2	11	347	2651009	2651345	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	1282	329	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21875022	21875022	PRJNA1092581_P_NODE_92498_length_265_cov_2.270833_g91965_i0	PRJNA1092581	92498	265	2.270833	6.01770745	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	156	1.7900000000000002e-33	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g91965	i0	86.62	1	142	17	53	2	125	265	9437355	9437215	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	265	156	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24421784	24421784	PRJNA1092581_P_NODE_119800_length_222_cov_31.416107_g119267_i0	PRJNA1092581	119800	222	31.416107	69.74375754	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	246	8.419999999999999e-61	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g119267	i0	88.614	103.072072072072	202	23	91	0	1	202	202	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	22882	246	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);;