metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA681822" 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
1930250	1930250	PRJNA681822_P_NODE_311302_length_271_cov_1.555556_g309813_i0	PRJNA681822	311302	271	1.555556	4.21555676	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	246	1.06e-60	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g309813	i0	83.577	94.5092250922509	274	34	100	9	1	271	1821174	1820909	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	25612	246	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
1930279	1930279	PRJNA681822_P_NODE_313822_length_270_cov_2.197970_g312333_i0	PRJNA681822	313822	270	2.19797	5.934519	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	65.8	3.18e-6	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g312333	i0	90.196	10.6148148148148	51	4	21	1	155	205	2285101	2285150	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	2866	65.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3204144	3204144	PRJNA681822_P_NODE_233123_length_290_cov_1.857143_g231634_i0	PRJNA681822	233123	290	1.857143	5.3857147	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	248	3.19e-61	NTclustered	gi\|2874253980\|emb\|OY970305.1\|	194844	g231634	i0	87.156	80.6310344827586	218	28	75	0	3	220	3964428	3964645	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03726.bin.c.10 genome assembly, chromosome: 1	blastn	23383	248	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
3206483	3206483	PRJNA681822_P_NODE_432763_length_246_cov_0.890173_g431274_i0	PRJNA681822	432763	246	0.890173	2.18982558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	231	2.6599999999999996e-56	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g431274	i0	84.016	1.98373983739837	244	35	98	4	4	245	1386302	1386061	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	488	231	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3722677	3722677	PRJNA681822_P_NODE_451603_length_244_cov_0.900585_g450113_i0	PRJNA681822	451603	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	167	7.529999999999998e-37	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g450113	i0	87.943	56.4795081967213	141	17	58	0	3	143	2785310	2785450	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	13781	167	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5757397	5757397	PRJNA681822_P_NODE_276465_length_280_cov_1.439614_g274976_i0	PRJNA681822	276465	280	1.439614	4.0309192	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	327	3.83e-85	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g274976	i0	87.814	0.996428571428571	279	34	99	0	2	280	6073938	6073660	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	279	327	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
5758974	5758974	PRJNA681822_P_NODE_406165_length_249_cov_0.875000_g404676_i0	PRJNA681822	406165	249	0.875	2.17875	Luteitalea pratensis	1855912	Bacteria	Bacteria	326	1.2e-84	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g404676	i0	90.323	0.995983935742972	248	24	99	0	1	248	5930140	5929893	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	248	326	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
7033886	7033886	PRJNA681822_P_NODE_403226_length_249_cov_0.875000_g401737_i0	PRJNA681822	403226	249	0.875	2.17875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	176	1.28e-39	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g401737	i0	82.741	0.791164658634538	197	34	79	0	5	201	4283034	4282838	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	197	176	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7547801	7547801	PRJNA681822_P_NODE_136786_length_352_cov_1.806452_g135299_i0	PRJNA681822	136786	352	1.806452	6.35871104	Bacteria	2	Bacteria	Bacteria	564	3.4599999999999995e-156	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g135299	i0	95.48	100.315340909091	354	14	100	2	1	352	4653318	4653671	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	35311	564	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8310375	8310375	PRJNA681822_P_NODE_81907_length_422_cov_1.160458_g80427_i0	PRJNA681822	81907	422	1.160458	4.89713276	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	368	3.55e-97	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g80427	i0	82.783	72.2772511848341	424	61	99	9	5	422	1641	1224	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	30501	368	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
10855702	10855702	PRJNA681822_P_NODE_121909_length_366_cov_1.498294_g120422_i0	PRJNA681822	121909	366	1.498294	5.48375604	Terriglobia bacterium	2081523	Bacteria	Bacteria	394	5.01e-105	NTclustered	gi\|2874253792\|emb\|OY969776.1\|	2081523	g120422	i0	87.464	17.6803278688525	343	42	93	1	25	366	951033	950691	MAG: Terriglobia bacterium isolate MFD00008.bin.1.63 genome assembly, chromosome: 1	blastn	6471	394	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
12132285	12132285	PRJNA681822_P_NODE_207730_length_304_cov_1.000000_g206242_i0	PRJNA681822	207730	304	1	3.04	Granulicella sp. WH15	2602070	Bacteria	Bacteria	84.2	1e-11	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g206242	i0	94.444	0.177631578947368	54	3	18	0	233	286	2656216	2656269	Granulicella sp. WH15 chromosome, complete genome	blastn	54	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15
14683364	14683364	PRJNA681822_P_NODE_317192_length_269_cov_2.908163_g315703_i0	PRJNA681822	317192	269	2.908163	7.82295847	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	172	1.81e-38	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g315703	i0	84.571	2.2453531598513	175	25	65	2	3	176	4269444	4269617	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	604	172	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14684669	14684669	PRJNA681822_P_NODE_426932_length_247_cov_0.885057_g425443_i0	PRJNA681822	426932	247	0.885057	2.18609079	Luteitalea pratensis	1855912	Bacteria	Bacteria	209	1.25e-49	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g425443	i0	85.572	1.62753036437247	201	28	81	1	48	247	4700058	4699858	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	402	209	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
14685467	14685467	PRJNA681822_P_NODE_490732_length_230_cov_2.929936_g489242_i0	PRJNA681822	490732	230	2.929936	6.7388528	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2893358426\|emb\|OZ220718.1\|	2910147	g489242	i0	100	0.121739130434783	28	0	12	0	148	175	66727	66700	MAG: Vicinamibacterales bacterium isolate 0ce2d42f-2bf0-44bc-a671-070680eb922c genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
17232329	17232329	PRJNA681822_P_NODE_323954_length_268_cov_1.184615_g322465_i0	PRJNA681822	323954	268	1.184615	3.1747682	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	462	9.57e-126	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g322465	i0	97.761	128.097014925373	268	6	100	0	1	268	4573043	4573310	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	34330	462	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
18506270	18506270	PRJNA681822_P_NODE_30375_length_685_cov_1.919935_g29006_i0	PRJNA681822	30375	685	1.919935	13.15155475	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	156	5.06e-33	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g29006	i0	78.689	0.72992700729927	244	44	35	7	39	278	1650620	1650859	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	500	156	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18507548	18507548	PRJNA681822_P_NODE_411135_length_248_cov_1.417143_g409646_i0	PRJNA681822	411135	248	1.417143	3.51451464	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|192805089\|emb\|FM175891.1\|	194844	g409646	i0	100	99.866935483871	248	0	100	0	1	248	314	67	Uncultured Acidobacteriaceae bacterium partial 16S rRNA gene, clone CL4.E2	blastn	24767	459	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
18508069	18508069	PRJNA681822_P_NODE_454115_length_244_cov_0.900585_g452625_i0	PRJNA681822	454115	244	0.900585	2.1974274	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	320	5.46e-83	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g452625	i0	90.871	224.495901639344	241	18	98	3	1	239	716062	715824	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	54777	320	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21058471	21058471	PRJNA681822_P_NODE_449317_length_244_cov_1.520468_g447827_i0	PRJNA681822	449317	244	1.520468	3.70994192	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	156	1.63e-33	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g447827	i0	85.065	0.631147540983607	154	22	63	1	3	156	3013394	3013546	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	154	156	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22331754	22331754	PRJNA681822_P_NODE_323058_length_268_cov_1.410256_g321569_i0	PRJNA681822	323058	268	1.410256	3.77948608	Luteitalea pratensis	1855912	Bacteria	Bacteria	315	2.8299999999999998e-81	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g321569	i0	88.192	1.94402985074627	271	22	100	6	1	268	4963202	4963465	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	521	315	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
22332388	22332388	PRJNA681822_P_NODE_376278_length_252_cov_3.111732_g374789_i0	PRJNA681822	376278	252	3.111732	7.84156464	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	169	2.17e-37	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g374789	i0	80.349	2.45238095238095	229	39	90	6	12	237	5460182	5459957	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	618	169	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
24881201	24881201	PRJNA681822_P_NODE_380420_length_251_cov_1.730337_g378931_i0	PRJNA681822	380420	251	1.730337	4.34314587	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	172	1.67e-38	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g378931	i0	86.25	1.51792828685259	160	20	63	2	93	251	1989661	1989819	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	381	172	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
24881480	24881480	PRJNA681822_P_NODE_401620_length_249_cov_1.329545_g400131_i0	PRJNA681822	401620	249	1.329545	3.31056705	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	165	2.77e-36	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g400131	i0	85.276	0.654618473895582	163	20	65	3	17	177	3116416	3116256	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	163	165	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24882514	24882514	PRJNA681822_P_NODE_482700_length_241_cov_0.916667_g481210_i0	PRJNA681822	482700	241	0.916667	2.20916747	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	178	3.43e-40	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g481210	i0	80.083	1	241	46	99	2	1	240	4453230	4453469	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	241	178	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);;