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

26 rows where analysis = "blastn", bioproject = "PRJNA605033" 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
582180	582180	PRJNA605033_P_NODE_210501_length_162_cov_1.181102_g208932_i0	PRJNA605033	210501	162	1.181102	1.91338524	Tunturiibacter lichenicola	2051959	Bacteria	Bacteria	76.8	8e-10	NTclustered	gi\|2304905231\|gb\|CP073696.1\|	2051959	g208932	i0	94	0.308641975308642	50	3	31	0	33	82	4391007	4390958	Tunturiibacter lichenicola strain DSM 104462 chromosome, complete genome	blastn	50	76.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter lichenicola
583065	583065	PRJNA605033_P_NODE_73021_length_222_cov_2.877005_g71452_i0	PRJNA605033	73021	222	2.877005	6.3869511	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g71452	i0	94.444	0.162162162162162	36	0	16	2	186	220	2708381	2708415	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	36	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1145665	1145665	PRJNA605033_P_NODE_3541_length_784_cov_57.967957_g2342_i0	PRJNA605033	3541	784	57.967957	454.46878288	Granulicella	940557	Bacteria	Bacteria	1182	0	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g2342	i0	93.734	139.343112244898	798	34	100	7	1	784	695474	694679	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	109245	1192	0.991610738255034	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
1858400	1858400	PRJNA605033_P_NODE_244682_length_151_cov_1.344828_g243113_i0	PRJNA605033	244682	151	1.344828	2.03069028	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	89.8	9.39e-14	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g243113	i0	83.333	0.675496688741722	102	12	66	5	35	133	607040	606941	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	102	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
4973330	4973330	PRJNA605033_P_NODE_20324_length_320_cov_40.196491_g18764_i0	PRJNA605033	20324	320	40.196491	128.6287712	Acidobacteriaceae	204434	Bacteria	Bacteria	558	1.45e-154	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g18764	i0	98.125	327.128125	320	6	100	0	1	320	4737919	4738238	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	104681	558	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
5686175	5686175	PRJNA605033_P_NODE_231165_length_155_cov_1.283333_g229596_i0	PRJNA605033	231165	155	1.283333	1.98916615	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	58.4	2.74e-4	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g229596	i0	90.698	0.27741935483871	43	4	28	0	113	155	1923068	1923026	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	43	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
6960889	6960889	PRJNA605033_P_NODE_26646_length_290_cov_1.764706_g25084_i0	PRJNA605033	26646	290	1.764706	5.1176474	Terriglobus roseus	392734	Bacteria	Bacteria	392	1.39e-104	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g25084	i0	91.065	61.3172413793103	291	25	100	1	1	290	928124	928414	Terriglobus roseus DSM 18391, complete genome	blastn	17782	392	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
8234389	8234389	PRJNA605033_P_NODE_106347_length_222_cov_1.850267_g104778_i0	PRJNA605033	106347	222	1.850267	4.10759274	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	87.9	5.4e-13	NTclustered	gi\|2874253679\|emb\|OY969113.1\|	171953	g104778	i0	94.643	0.252252252252252	56	3	25	0	154	209	551858	551803	MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.1.55 genome assembly, chromosome: 1	blastn	56	87.9	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9509759	9509759	PRJNA605033_P_NODE_13068_length_387_cov_1.826705_g11530_i0	PRJNA605033	13068	387	1.826705	7.06934835	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	350	1.17e-91	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g11530	i0	85.345	262.188630490956	348	40	88	10	45	386	3298525	3298183	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	101467	350	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10073284	10073284	PRJNA605033_P_NODE_13048_length_387_cov_2.303977_g11510_i0	PRJNA605033	13048	387	2.303977	8.91639099	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	399	1.1499999999999998e-106	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g11510	i0	87.896	122.320413436693	347	33	88	8	2	343	3298183	3298525	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	47338	401	0.99501246882793	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13336088	13336088	PRJNA605033_P_NODE_182031_length_174_cov_1.539568_g180462_i0	PRJNA605033	182031	174	1.539568	2.67884832	Occallatibacter riparius	1002689	Bacteria	Bacteria	211	2.28e-50	NTclustered	gi\|2304899767\|gb\|CP093313.1\|	1002689	g180462	i0	88.889	96.7586206896552	171	19	98	0	1	171	1411457	1411627	Occallatibacter riparius strain DSM 25168 chromosome, complete genome	blastn	16836	211	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Occallatibacter	Occallatibacter riparius
14610923	14610923	PRJNA605033_P_NODE_185972_length_172_cov_1.591241_g184403_i0	PRJNA605033	185972	172	1.591241	2.73693452	Granulicella sp. WH15	2602070	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g184403	i0	100	0.174418604651163	30	0	17	0	120	149	321503	321474	Granulicella sp. WH15 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15
15884079	15884079	PRJNA605033_P_NODE_106013_length_222_cov_1.855615_g104444_i0	PRJNA605033	106013	222	1.855615	4.1194653	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	100	6.93e-17	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g104444	i0	90.667	0.662162162162162	75	7	34	0	148	222	2923389	2923463	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	147	100	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15885246	15885246	PRJNA605033_P_NODE_221693_length_158_cov_1.300813_g220124_i0	PRJNA605033	221693	158	1.300813	2.05528454	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	99	1.65e-16	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g220124	i0	80.952	35.898734177215204	126	22	79	2	9	133	3721653	3721777	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	5672	99	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18434054	18434054	PRJNA605033_P_NODE_181035_length_174_cov_3.014388_g179466_i0	PRJNA605033	181035	174	3.014388	5.24503512	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	132	1.83e-26	NTclustered	gi\|2874253980\|emb\|OY970305.1\|	194844	g179466	i0	80.347	5.87931034482759	173	34	99	0	2	174	3119353	3119525	MAG: uncultured Acidobacteriaceae bacterium isolate MFD03726.bin.c.10 genome assembly, chromosome: 1	blastn	1023	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
19707776	19707776	PRJNA605033_P_NODE_104356_length_222_cov_1.882353_g102787_i0	PRJNA605033	104356	222	1.882353	4.17882366	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	71.3	5.44e-8	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g102787	i0	97.561	0.554054054054054	41	1	18	0	6	46	4086944	4086904	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	123	71.3	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19708887	19708887	PRJNA605033_P_NODE_22176_length_309_cov_5.021898_g20615_i0	PRJNA605033	22176	309	5.021898	15.51766482	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	488	1.86e-133	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g20615	i0	95.146	215.181229773463	309	15	100	0	1	309	2365646	2365954	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	66491	488	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
20985048	20985048	PRJNA605033_P_NODE_3517_length_787_cov_52.793883_g2322_i0	PRJNA605033	3517	787	52.793883	415.48785921	Alloacidobacterium dinghuense	2763107	Bacteria	Bacteria	1190	0	NTclustered	gi\|1895675831\|gb\|CP060394.1\|	2763107	g2322	i0	94.036	111.913595933926	788	42	100	4	1	787	4007814	4008597	Alloacidobacterium dinghuense strain 4Y35 chromosome, complete genome	blastn	88076	1190	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Alloacidobacterium	Alloacidobacterium dinghuense
22258445	22258445	PRJNA605033_P_NODE_129998_length_217_cov_1.120879_g128429_i0	PRJNA605033	129998	217	1.120879	2.43230743	Granulicella mallensis	940614	Bacteria	Bacteria	224	3.84e-54	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g128429	i0	89.011	21.7741935483871	182	19	84	1	34	215	5983901	5984081	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	4725	224	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
22259691	22259691	PRJNA605033_P_NODE_245378_length_151_cov_0.905172_g243809_i0	PRJNA605033	245378	151	0.905172	1.36680972	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	102	1.21e-17	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g243809	i0	98.276	32.2649006622517	58	1	38	0	94	151	1202668	1202611	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	4872	102	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
22260314	22260314	PRJNA605033_P_NODE_90558_length_222_cov_2.171123_g88989_i0	PRJNA605033	90558	222	2.171123	4.81989306	Luteitalea pratensis	1855912	Bacteria	Bacteria	84.2	6.98e-12	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g88989	i0	89.394	11.0045045045045	66	7	30	0	152	217	750702	750637	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	2443	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
23535647	23535647	PRJNA605033_P_NODE_89299_length_222_cov_2.203209_g87730_i0	PRJNA605033	89299	222	2.203209	4.89112398	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	86.1	1.94e-12	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g87730	i0	96.154	0.882882882882883	52	2	23	0	1	52	367475	367424	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	196	86.1	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24096520	24096520	PRJNA605033_P_NODE_109939_length_222_cov_1.796791_g108370_i0	PRJNA605033	109939	222	1.796791	3.98887602	Pseudomonadati	3379134	Bacteria	Bacteria	106	1.49e-18	NTclustered	gi\|2874254057\|emb\|OY970381.1\|	194844	g108370	i0	94.203	29.5855855855856	69	4	31	0	154	222	2146575	2146507	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1	blastn	6568	106	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
24808493	24808493	PRJNA605033_P_NODE_211240_length_161_cov_3.238095_g209671_i0	PRJNA605033	211240	161	3.238095	5.21333295	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2893356059\|emb\|OZ220482.1\|	2651171	g209671	i0	100	0.180124223602484	29	0	18	0	45	73	3059818	3059790	MAG: Thermoanaerobaculia bacterium isolate 1ba308f5-42e2-4878-81ff-2dc7ade272f8 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
24809005	24809005	PRJNA605033_P_NODE_34660_length_265_cov_2.269565_g33093_i0	PRJNA605033	34660	265	2.269565	6.01434725	Terriglobus roseus	392734	Bacteria	Bacteria	82.4	3.09e-11	NTclustered	gi\|1085637902\|emb\|LT629690.1\|	392734	g33093	i0	96	70.0641509433962	50	2	19	0	20	69	2867316	2867365	Terriglobus roseus strain GAS232 genome assembly, chromosome: I	blastn	18567	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
25370914	25370914	PRJNA605033_P_NODE_10660_length_425_cov_23.351282_g9133_i0	PRJNA605033	10660	425	23.351282	99.2429485	Granulicella	940557	Bacteria	Bacteria	619	8.949999999999998e-173	NTclustered	gi\|2874254057\|emb\|OY970381.1\|	194844	g9133	i0	92.941	213.625882352941	425	30	100	0	1	425	1656859	1657283	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1	blastn	90791	619	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae 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);;