metadata: contig_metadata: 53 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax

53 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax_phylum = "Pseudomonadota"

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
319837	319837	PRJNA1186363_P_NODE_30281_length_314_cov_1.601660_g29393_i0	PRJNA1186363	30281	314	1.60166	5.0292124	Faucicola osloensis	34062	Bacteria	Bacteria	580	3.0299999999999992e-161	NTclustered	gi\|1958308771\|gb\|CP068109.1\|	34062	g29393	i0	100	62.6082802547771	314	0	100	0	1	314	1592510	1592197	Moraxella osloensis strain FDAARGOS_1130 chromosome, complete genome	blastn	19659	580	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
319882	319882	PRJNA1186363_P_NODE_40861_length_248_cov_0.891429_g39973_i0	PRJNA1186363	40861	248	0.891429	2.21074392	Candidatus Symbiodolus clandestinus	3234017	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2724612512\|gb\|CP152425.1\|	3234017	g39973	i0	96.875	0.129032258064516	32	0	13	1	61	91	1338731	1338762	MAG: Candidatus Symbiodolus clandestinus isolate Ogal chromosome, complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales		Candidatus Symbiodolus	Candidatus Symbiodolus clandestinus
1594327	1594327	PRJNA1186363_P_NODE_16222_length_486_cov_1.653753_g15335_i0	PRJNA1186363	16222	486	1.653753	8.03723958	Xanthomonas arboricola	56448	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2130528182\|emb\|HG992336.1\|	56448	g15335	i0	100	0.0596707818930041	29	0	6	0	299	327	4748651	4748623	Xanthomonas arboricola strain 1311a genome assembly, chromosome: XA1311A	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Xanthomonas	Xanthomonas arboricola
1594463	1594463	PRJNA1186363_P_NODE_34942_length_277_cov_2.470588_g34054_i0	PRJNA1186363	34942	277	2.470588	6.84352876	Pseudomonas kermanshahensis	2745482	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|2260437839\|gb\|CP099575.1\|	2745482	g34054	i0	99.639	641.032490974729	277	1	100	0	1	277	2891	3167	Pseudomonas kermanshahensis strain F8 chromosome, complete genome	blastn	177566	507	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas kermanshahensis
2317316	2317316	PRJNA1186363_P_NODE_20782_length_413_cov_1.317647_g19894_i0	PRJNA1186363	20782	413	1.317647	5.44188211	Dickeya	204037	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|2864254841\|gb\|CP146228.1\|	1326752	g19894	i0	96.875	0.309927360774818	32	0	8	1	231	262	1221679	1221649	Dickeya sp. CFBP 1272 chromosome, complete genome	blastn	128	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Pectobacteriaceae	Dickeya	Dickeya sp. CFBP 1272
4146592	4146592	PRJNA1186363_P_NODE_23344_length_381_cov_1.629870_g22456_i0	PRJNA1186363	23344	381	1.62987	6.2098047	uncultured Gammaproteobacteria bacterium	86473	Bacteria	Bacteria	627	4.7499999999999997e-175	NTclustered	gi\|2874253898\|emb\|OY970073.1\|	86473	g22456	i0	96.335	185.622047244094	382	12	100	2	1	381	3255687	3255307	MAG: uncultured Gammaproteobacteria bacterium isolate MFD05513.bin.2.20 genome assembly, chromosome: 1	blastn	70722	627	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				uncultured Gammaproteobacteria bacterium
4146718	4146718	PRJNA1186363_P_NODE_42724_length_244_cov_0.912281_g41836_i0	PRJNA1186363	42724	244	0.912281	2.22596564	Bartonella grahamii	33045	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|240266805\|gb\|CP001562.1\|	634504	g41836	i0	100	0.122950819672131	30	0	12	0	8	37	445519	445548	Bartonella grahamii as4aup, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Bartonellaceae	Bartonella	Bartonella grahamii
4870086	4870086	PRJNA1186363_P_NODE_15144_length_508_cov_1.022989_g14258_i0	PRJNA1186363	15144	508	1.022989	5.19678412	Methylocystis	133	Bacteria	Bacteria	54.7	0.014	NTclustered	gi\|2359340975\|gb\|CP107558.1\|	2654282	g14258	i0	100	0.171259842519685	29	0	6	0	73	101	1229881	1229853	Methylocystis sp. MJC1 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylocystaceae	Methylocystis	Methylocystis sp. MJC1
4870091	4870091	PRJNA1186363_P_NODE_1864_length_1415_cov_5.114009_g1530_i0	PRJNA1186363	1864	1415	5.114009	72.36322735	Shewanella	22	Bacteria	Bacteria	54.7	0.04	NTclustered	gi\|2040459686\|gb\|CP074572.1\|	712036	g1530	i0	100	0.0409893992932862	29	0	2	0	744	772	1625872	1625844	Shewanella dokdonensis strain DSM 23626 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella dokdonensis
5422851	5422851	PRJNA1186363_P_NODE_28025_length_334_cov_1.180077_g27137_i0	PRJNA1186363	28025	334	1.180077	3.94145718	Glaesserella parasuis	738	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|674177996\|gb\|CP009237.1\|	738	g27137	i0	100	0.0838323353293413	28	0	8	0	130	157	1411860	1411833	Glaesserella parasuis strain KL0318 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Glaesserella	Glaesserella parasuis
5422887	5422887	PRJNA1186363_P_NODE_33065_length_291_cov_1.788991_g32177_i0	PRJNA1186363	33065	291	1.788991	5.20596381	Pseudoduganella aquatica	2660641	Bacteria	Bacteria	63.9	1.25e-5	NTclustered	gi\|2136494013\|gb\|CP086370.1\|	2660641	g32177	i0	95	0.13745704467354	40	2	14	0	65	104	5476678	5476639	Pseudoduganella aquatica strain HC52 chromosome, complete genome	blastn	40	63.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Pseudoduganella	Pseudoduganella aquatica
5422899	5422899	PRJNA1186363_P_NODE_34425_length_281_cov_2.096154_g33537_i0	PRJNA1186363	34425	281	2.096154	5.89019274	Acinetobacter larvae	1789224	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1051353495\|gb\|CP016895.1\|	1789224	g33537	i0	100	0.099644128113879	28	0	10	0	45	72	2673255	2673228	Acinetobacter larvae strain BRTC-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter larvae
5422941	5422941	PRJNA1186363_P_NODE_42265_length_245_cov_0.906977_g41377_i0	PRJNA1186363	42265	245	0.906977	2.22209365	Faucicola osloensis	34062	Bacteria	Bacteria	396	8.869999999999996e-106	NTclustered	gi\|1279135894\|gb\|CP024186.1\|	34062	g41377	i0	100	229.440816326531	214	0	87	0	32	245	50194	49981	Moraxella osloensis strain TT16 plasmid p1, complete sequence	blastn	56213	396	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
5422984	5422984	PRJNA1186363_P_NODE_6985_length_803_cov_1.235616_g6196_i0	PRJNA1186363	6985	803	1.235616	9.92199648	Pararoseomonas sp. SCSIO 73927	3114537	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2693424943\|gb\|CP146232.1\|	3114537	g6196	i0	94.737	0.0473225404732254	38	0	5	2	182	218	4113974	4113938	Pararoseomonas sp. SCSIO 73927 chromosome, complete genome	blastn	38	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Pararoseomonas	Pararoseomonas sp. SCSIO 73927
6697647	6697647	PRJNA1186363_P_NODE_29226_length_323_cov_1.248000_g28338_i0	PRJNA1186363	29226	323	1.248	4.03104	Mesorhizobium sp. ISC25	3077335	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2810067692\|gb\|CP135441.1\|	3077335	g28338	i0	100	0.0928792569659443	30	0	9	0	1	30	6180173	6180202	Mesorhizobium sp. ISC25 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Mesorhizobium	Mesorhizobium sp. ISC25
8694975	8694975	PRJNA1186363_P_NODE_15487_length_501_cov_1.278037_g14601_i0	PRJNA1186363	15487	501	1.278037	6.40296537	Variovorax	34072	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2921406765\|gb\|CP157609.1\|	1566272	g14601	i0	97.143	1.08183632734531	35	0	7	1	392	426	7168662	7168629	Variovorax sp. NFACC29 chromosome, complete genome	blastn	542	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. NFACC29
8694993	8694993	PRJNA1186363_P_NODE_28107_length_333_cov_1.296154_g27219_i0	PRJNA1186363	28107	333	1.296154	4.31619282	Delftia	80865	Bacteria	Bacteria	616	8.87e-172	NTclustered	gi\|2490585958\|gb\|CP104581.1\|	180282	g27219	i0	100	364.321321321321	333	0	100	0	1	333	683719	684051	Delftia tsuruhatensis strain GD03927 chromosome, complete genome	blastn	121319	616	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia tsuruhatensis
9247721	9247721	PRJNA1186363_P_NODE_38408_length_253_cov_0.866667_g37520_i0	PRJNA1186363	38408	253	0.866667	2.19266751	uncultured Pseudomonadota bacterium	153809	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|110753943\|gb\|DQ828630.1\|	153809	g37520	i0	98.024	100.02371541502	253	5	100	0	1	253	309	57	Uncultured proteobacterium clone DOK_CONFYM_clone370 16S ribosomal RNA gene, partial sequence	blastn	25306	440	1	Bacteria	Pseudomonadati	Pseudomonadota					uncultured Pseudomonadota bacterium
9247750	9247750	PRJNA1186363_P_NODE_44028_length_235_cov_2.833333_g43140_i0	PRJNA1186363	44028	235	2.833333	6.65833255	Aromatoleum petrolei	76116	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2023472114\|gb\|CP059560.1\|	76116	g43140	i0	100	0.127659574468085	30	0	13	0	206	235	4436998	4437027	Aromatoleum petrolei strain ToN1 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae	Aromatoleum	Aromatoleum petrolei
9970071	9970071	PRJNA1186363_P_NODE_12228_length_581_cov_2.185039_g11346_i0	PRJNA1186363	12228	581	2.185039	12.69507659	Pseudoxanthomonas	83618	Bacteria	Bacteria	937	0	NTclustered	gi\|2523011304\|gb\|CP095475.1\|	2480810	g11346	i0	95.719	270.889845094664	584	21	100	4	1	581	3863554	3862972	Pseudoxanthomonas winnipegensis strain ZSY-33 chromosome, complete genome	blastn	157387	937	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Pseudoxanthomonas	Pseudoxanthomonas winnipegensis
10523453	10523453	PRJNA1186363_P_NODE_30389_length_313_cov_1.354167_g29501_i0	PRJNA1186363	30389	313	1.354167	4.23854271	Vibrio diabolicus	50719	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1976400539\|gb\|CP069195.1\|	50719	g29501	i0	100	0.0958466453674121	30	0	10	0	250	279	2921270	2921241	Vibrio diabolicus strain SLV18 chromosome 1, complete sequence	blastn	30	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio diabolicus
10523502	10523502	PRJNA1186363_P_NODE_40169_length_249_cov_1.465909_g39281_i0	PRJNA1186363	40169	249	1.465909	3.65011341	Caldimonas aquatica	376175	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2840726774\|gb\|CP171806.1\|	376175	g39281	i0	100	2.24899598393574	249	0	100	0	1	249	1321925	1322173	Caldimonas aquatica strain HS-12-14 chromosome, complete genome	blastn	560	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas aquatica
11798448	11798448	PRJNA1186363_P_NODE_40490_length_249_cov_0.886364_g39602_i0	PRJNA1186363	40490	249	0.886364	2.20704636	Bradyrhizobium sp. PSBB068	2715960	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1979381481\|gb\|CP069300.1\|	2715960	g39602	i0	100	105.016064257028	249	0	100	0	1	249	189100	189348	Bradyrhizobium sp. PSBB068 chromosome, complete genome	blastn	26149	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. PSBB068
11798450	11798450	PRJNA1186363_P_NODE_40590_length_249_cov_0.886364_g39702_i0	PRJNA1186363	40590	249	0.886364	2.20704636	Phreatobacter cathodiphilus	1868589	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1364845349\|gb\|CP027668.1\|	1868589	g39702	i0	99.598	144.012048192771	249	1	100	0	1	249	856697	856945	Phreatobacter cathodiphilus strain S-12 chromosome, complete genome	blastn	35859	455	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phreatobacteraceae	Phreatobacter	Phreatobacter cathodiphilus
11798451	11798451	PRJNA1186363_P_NODE_40650_length_248_cov_1.337143_g39762_i0	PRJNA1186363	40650	248	1.337143	3.31611464	Pleomorphomonas sp. PLEO	3239306	Bacteria	Bacteria	351	1.97e-92	NTclustered	gi\|2788698862\|gb\|CP166625.1\|	3239306	g39762	i0	92.369	226.45564516129	249	16	100	3	1	248	724390	724144	Pleomorphomonas sp. PLEO chromosome, complete genome	blastn	56161	351	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Pleomorphomonadaceae	Pleomorphomonas	Pleomorphomonas sp. PLEO
11798511	11798511	PRJNA1186363_P_NODE_7630_length_764_cov_2.503618_g4923_i1	PRJNA1186363	7630	764	2.503618	19.12764152	Paraburkholderia dokdonensis	2211211	Bacteria	Bacteria	62.1	1.27e-4	NTclustered	gi\|1409665483\|gb\|CP029641.1\|	2211211	g4923	i1	94.872	0.0510471204188482	39	2	5	0	137	175	985040	985078	Paraburkholderia dokdonensis chromosome 2, complete sequence	blastn	39	62.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Paraburkholderia	Paraburkholderia dokdonensis
13073412	13073412	PRJNA1186363_P_NODE_43431_length_243_cov_0.917647_g42543_i0	PRJNA1186363	43431	243	0.917647	2.22988221	Stenotrophomonas maltophilia	40324	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2161673779\|gb\|CP088244.1\|	40324	g42543	i0	99.177	100	243	2	100	0	1	243	348261	348019	Stenotrophomonas maltophilia strain 2013-SM4 chromosome, complete genome	blastn	24300	438	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas maltophilia
14348761	14348761	PRJNA1186363_P_NODE_25732_length_356_cov_1.084806_g24844_i0	PRJNA1186363	25732	356	1.084806	3.86190936	Orientia tsutsugamushi	784	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1389097765\|emb\|LS398549.1\|	784	g24844	i0	100	0.0814606741573034	29	0	8	0	16	44	864339	864311	Orientia tsutsugamushi isolate TA686 genome assembly, chromosome: I	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Orientia	Orientia tsutsugamushi
14348814	14348814	PRJNA1186363_P_NODE_34592_length_280_cov_1.497585_g33704_i0	PRJNA1186363	34592	280	1.497585	4.193238	Enterobacteriaceae endosymbiont of Donacia simplex	2675784	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1833265032\|gb\|CP046192.1\|	2675784	g33704	i0	100	0.103571428571429	29	0	10	0	243	271	320011	319983	Enterobacteriaceae endosymbiont of Donacia simplex isolate DsimSym chromosome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae		Enterobacteriaceae endosymbiont of Donacia simplex
14348820	14348820	PRJNA1186363_P_NODE_35492_length_273_cov_1.540000_g34604_i0	PRJNA1186363	35492	273	1.54	4.2042	Xanthomonas fragariae	48664	Bacteria	Bacteria	62.1	4.16e-5	NTclustered	gi\|1198214654\|emb\|LT853882.1\|	48664	g34604	i0	97.222	13.1721611721612	36	1	13	0	188	223	3700578	3700543	Xanthomonas fragariae strain PD885 genome assembly, chromosome: 1	blastn	3596	62.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Xanthomonas	Xanthomonas fragariae
14348869	14348869	PRJNA1186363_P_NODE_43472_length_243_cov_0.917647_g42584_i0	PRJNA1186363	43472	243	0.917647	2.22988221	Bradyrhizobium sp. PSBB068	2715960	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1979381481\|gb\|CP069300.1\|	2715960	g42584	i0	100	100.049382716049	243	0	100	0	1	243	1787526	1787768	Bradyrhizobium sp. PSBB068 chromosome, complete genome	blastn	24312	449	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. PSBB068
15069720	15069720	PRJNA1186363_P_NODE_29192_length_323_cov_1.576000_g28304_i0	PRJNA1186363	29192	323	1.576	5.09048	Comamonadaceae	80864	Bacteria	Bacteria	551	2.449999999999999e-152	NTclustered	gi\|1972901683\|gb\|CP063167.1\|	34073	g28304	i0	97.523	197.287925696594	323	6	99	2	2	323	487626	487947	Variovorax paradoxus strain VAI-C plasmid unnamed, complete sequence	blastn	63724	556	0.991007194244604	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
15069722	15069722	PRJNA1186363_P_NODE_30092_length_316_cov_0.962963_g29204_i0	PRJNA1186363	30092	316	0.962963	3.04296308	root	1	Root_unresolved	Root_unresolved	52.8	0.03	NTclustered	gi\|1390249357\|gb\|CP029343.1\|	945844	g29204	i0	100	0.177215189873418	28	0	9	0	27	54	1034696	1034723	Massilia oculi strain CCUG 43427 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia oculi
15622553	15622553	PRJNA1186363_P_NODE_3653_length_1087_cov_11.822485_g3121_i0	PRJNA1186363	3653	1087	11.822485	128.51041195	Variovorax sp. PBS-H4	434008	Bacteria	Bacteria	93.5	6.51e-14	NTclustered	gi\|1795698971\|emb\|LR594675.1\|	434008	g3121	i0	88.608	137.009199632015	79	6	7	2	820	898	2525160	2525085	Variovorax sp. PBS-H4 genome assembly, chromosome: 1	blastn	148929	93.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PBS-H4
16344527	16344527	PRJNA1186363_P_NODE_30613_length_311_cov_1.680672_g29725_i0	PRJNA1186363	30613	311	1.680672	5.22688992	Oxalobacteraceae	75682	Bacteria	Bacteria	527	3.9599999999999996e-145	NTclustered	gi\|1861348618\|gb\|CP049828.1\|	29581	g29725	i0	98.339	511.549839228296	301	4	97	1	1	301	212801	213100	Janthinobacterium lividum strain EIF2 chromosome, complete genome	blastn	159092	529	0.996219281663516	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium	Janthinobacterium lividum
16896716	16896716	PRJNA1186363_P_NODE_10234_length_647_cov_1.522648_g9356_i0	PRJNA1186363	10234	647	1.522648	9.85153256	Gilliamella apicola	1196095	Bacteria	Bacteria	270	1.6299999999999998e-67	NTclustered	gi\|2563321002\|gb\|CP132380.1\|	1196095	g9356	i0	85.283	28.5023183925811	265	35	41	4	1	263	2253004	2252742	Gilliamella apicola strain ESL0178 chromosome, complete genome	blastn	18441	270	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Orbales	Orbaceae	Gilliamella	Gilliamella apicola
16896814	16896814	PRJNA1186363_P_NODE_19294_length_433_cov_3.233333_g18406_i0	PRJNA1186363	19294	433	3.233333	14.00033189	Burkholderia anthina	179879	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|1951799260\|gb\|CP066769.1\|	179879	g18406	i0	100	0.0646651270207852	28	0	6	0	160	187	1649384	1649357	Burkholderia anthina strain BJQ0011 chromosome 1, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia anthina
18171381	18171381	PRJNA1186363_P_NODE_34895_length_278_cov_1.141463_g34007_i0	PRJNA1186363	34895	278	1.141463	3.17326714	Pseudoalteromonas xiamenensis	882626	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2571540407\|gb\|CP099917.1\|	882626	g34007	i0	100	0.10431654676259	29	0	10	0	238	266	3671275	3671247	Pseudoalteromonas xiamenensis strain PSDB chromosome 1, complete sequence	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Pseudoalteromonadaceae	Pseudoalteromonas	Pseudoalteromonas xiamenensis
18171392	18171392	PRJNA1186363_P_NODE_36555_length_265_cov_1.307292_g35667_i0	PRJNA1186363	36555	265	1.307292	3.4643238	Pseudomonas lalucatii	1424203	Bacteria	Bacteria	58.4	5.21e-4	NTclustered	gi\|2042560102\|gb\|CP065340.1\|	1424203	g35667	i0	97.143	0.237735849056604	35	0	13	1	39	73	196740	196707	Pseudomonas lalucatii strain R1b52 chromosome	blastn	63	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas lalucatii
20721039	20721039	PRJNA1186363_P_NODE_18597_length_445_cov_1.115591_g17709_i0	PRJNA1186363	18597	445	1.115591	4.96437995	Salmonella enterica	28901	Bacteria	Bacteria	60.2	2.57e-4	NTclustered	gi\|1821144251\|gb\|CP049874.1\|	2021403	g17709	i0	100	16.7865168539326	32	0	7	0	362	393	737100	737131	Salmonella enterica subsp. enterica serovar Adjame strain 374589 chromosome, complete genome	blastn	7470	60.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
20721152	20721152	PRJNA1186363_P_NODE_34817_length_278_cov_1.902439_g33929_i0	PRJNA1186363	34817	278	1.902439	5.28878042	Pseudomonas helleri	1608996	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2913959169\|gb\|CP181271.1\|	1608996	g33929	i0	94.286	0.12589928057554	35	1	13	1	128	162	1234513	1234546	MAG: Pseudomonas helleri isolate UW_FK_PSEUD1_1 chromosome	blastn	35	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas helleri
21443904	21443904	PRJNA1186363_P_NODE_11017_length_621_cov_1.450730_g10135_i0	PRJNA1186363	11017	621	1.45073	9.0090333	Achromobacter	222	Bacteria	Bacteria	1027	0	NTclustered	gi\|1073951170\|gb\|CP017433.1\|	72557	g10135	i0	96.469	321.565217391304	623	20	100	2	1	621	691612	692234	Achromobacter ruhlandii strain SCCH3:ACH 33-1365 genome	blastn	199692	1027	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Achromobacter	Achromobacter ruhlandii
21996318	21996318	PRJNA1186363_P_NODE_11838_length_593_cov_2.357692_g10956_i0	PRJNA1186363	11838	593	2.357692	13.98111356	Janthinobacterium sp. HH102	1537274	Bacteria	Bacteria	63.9	2.71e-5	NTclustered	gi\|1922988912\|gb\|CP062062.1\|	1537274	g10956	i0	95	5.57504215851602	40	2	7	0	256	295	5248699	5248738	Janthinobacterium sp. HH102 chromosome, complete genome	blastn	3306	63.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium	Janthinobacterium sp. HH102
21996416	21996416	PRJNA1186363_P_NODE_22978_length_386_cov_0.984026_g22090_i0	PRJNA1186363	22978	386	0.984026	3.79834036	Massilia atriviolacea	2495579	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2853209876\|gb\|CP051166.1\|	2495579	g22090	i0	100	0.0725388601036269	28	0	7	0	301	328	2869484	2869457	Massilia atriviolacea strain SOD chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia atriviolacea
21996512	21996512	PRJNA1186363_P_NODE_38238_length_253_cov_1.033333_g37350_i0	PRJNA1186363	38238	253	1.033333	2.61433249	Marichromatium purpuratum	37487	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|570731247\|gb\|CP007031.1\|	765910	g37350	i0	100	0.114624505928854	29	0	11	0	113	141	1730619	1730647	Marichromatium purpuratum 984, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Marichromatium	Marichromatium purpuratum
21996564	21996564	PRJNA1186363_P_NODE_5618_length_899_cov_3.061743_g4923_i0	PRJNA1186363	5618	899	3.061743	27.52506957	Paraburkholderia dokdonensis	2211211	Bacteria	Bacteria	62.1	1.51e-4	NTclustered	gi\|1409665483\|gb\|CP029641.1\|	2211211	g4923	i0	94.872	0.0433815350389321	39	2	4	0	725	763	985078	985040	Paraburkholderia dokdonensis chromosome 2, complete sequence	blastn	39	62.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Paraburkholderia	Paraburkholderia dokdonensis
23271927	23271927	PRJNA1186363_P_NODE_27219_length_342_cov_0.869888_g26331_i0	PRJNA1186363	27219	342	0.869888	2.97501696	Bradyrhizobium japonicum	375	Bacteria	Bacteria	62.1	5.37e-5	NTclustered	gi\|2235744812\|gb\|CP081350.1\|	375	g26331	i0	89.583	0.140350877192982	48	5	14	0	12	59	5801828	5801875	Bradyrhizobium japonicum strain S10J-BJ chromosome, complete genome	blastn	48	62.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium japonicum
23271942	23271942	PRJNA1186363_P_NODE_30379_length_313_cov_1.495833_g29491_i0	PRJNA1186363	30379	313	1.495833	4.68195729	Methylobacterium brachiatum	269660	Bacteria	Bacteria	65.8	3.76e-6	NTclustered	gi\|1498425080\|gb\|CP033231.1\|	269660	g29491	i0	100	5.7667731629393	35	0	11	0	159	193	5234938	5234972	Methylobacterium brachiatum strain TX0642 chromosome	blastn	1805	65.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium brachiatum
23272006	23272006	PRJNA1186363_P_NODE_40419_length_249_cov_0.886364_g39531_i0	PRJNA1186363	40419	249	0.886364	2.20704636	Paracoccus sanguinis	1545044	Bacteria	Bacteria	377	3.27e-100	NTclustered	gi\|1834246727\|gb\|CP051542.1\|	1545044	g39531	i0	94.024	2.33333333333333	251	11	100	3	1	249	2687552	2687800	Paracoccus sanguinis strain OM2164 chromosome, complete genome	blastn	581	377	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus sanguinis
23994104	23994104	PRJNA1186363_P_NODE_11019_length_621_cov_1.383212_g10137_i0	PRJNA1186363	11019	621	1.383212	8.58974652	Burkholderiaceae	119060	Bacteria	Bacteria	67.6	2.2e-6	NTclustered	gi\|2028341685\|dbj\|AP024322.1\|	140098	g10137	i0	97.436	0.251207729468599	39	1	10	0	118	156	2179800	2179838	Burkholderia sp. NK8 DNA, chromosome 1, complete sequence	blastn	156	67.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Caballeronia	Caballeronia sp. NK8
24545638	24545638	PRJNA1186363_P_NODE_14220_length_530_cov_1.024070_g13336_i0	PRJNA1186363	14220	530	1.02407	5.427571	Zymobacter sp. IVIA_5232.4 C2	3394855	Bacteria	Bacteria	54.7	0.014	NTclustered	gi\|2904223134\|gb\|CP179928.1\|	3394855	g13336	i0	100	0.0547169811320755	29	0	5	0	443	471	2195519	2195547	Zymobacter sp. IVIA_5232.4 C2 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Zymobacter	Zymobacter sp. IVIA_5232.4 C2
24545683	24545683	PRJNA1186363_P_NODE_18540_length_445_cov_3.736559_g17652_i0	PRJNA1186363	18540	445	3.736559	16.62768755	Achromobacter sp. B7	2282475	Bacteria	Bacteria	73.1	3.31e-8	NTclustered	gi\|1483529537\|gb\|CP032084.1\|	2282475	g17652	i0	97.619	22.2696629213483	42	1	9	0	151	192	2691473	2691432	Achromobacter sp. B7 chromosome, complete genome	blastn	9910	73.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Achromobacter	Achromobacter sp. B7
25268237	25268237	PRJNA1186363_P_NODE_6300_length_847_cov_61.466408_g5553_i0	PRJNA1186363	6300	847	61.466408	520.62047576	Serratia	613	Bacteria	Bacteria	54.7	0.024	NTclustered	gi\|1654144183\|gb\|CP040182.1\|	47917	g5553	i0	100	0.582054309327037	29	0	3	0	431	459	3283346	3283374	Serratia fonticola strain MS5 chromosome, complete genome	blastn	493	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Serratia	Serratia fonticola

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);;