metadata: contig_metadata: 66 rows where bioproject = "PRJNA560029" and tax

66 rows where bioproject = "PRJNA560029" 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
543857	543857	PRJNA560029_S_NODE_22621_length_290_cov_3.129032_g22397_i0	PRJNA560029	22621	290	3.129032	9.0741928	Pseudoalteromonas xiamenensis	882626	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2571540407\|gb\|CP099917.1\|	882626	g22397	i0	100	0.1	29	0	10	0	222	250	3671275	3671247	Pseudoalteromonas xiamenensis strain PSDB chromosome 1, complete sequence	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Pseudoalteromonadaceae	Pseudoalteromonas	Pseudoalteromonas xiamenensis
1819590	1819590	PRJNA560029_S_NODE_22942_length_289_cov_1.425926_g22718_i0	PRJNA560029	22942	289	1.425926	4.12092614	root	1	Root_unresolved	Root_unresolved	89.7	3.89e-20	NR	WP_140424235.1	562	g22718	i0	82.6	5.76124567474048	46	8	47.8	0	1	138	124	169	WP_140424235.1 ADP-ribosylation factor-like protein, partial [Escherichia coli]	diamond	1665	89.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
1819592	1819592	PRJNA560029_S_NODE_23042_length_288_cov_3.232558_g22818_i0	PRJNA560029	23042	288	3.232558	9.30976704	Necropsobacter massiliensis	1400001	Bacteria	Bacteria	141	6.379999999999999e-37	NR	WP_040976343.1	1400001	g22818	i0	81.1	4.94791666666667	95	18	99	0	286	2	533	627	WP_040976343.1 MacB family efflux pump subunit [Necropsobacter massiliensis]	diamond	1425	141	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Necropsobacter	Necropsobacter massiliensis
4371423	4371423	PRJNA560029_S_NODE_27924_length_267_cov_1.881443_g27700_i0	PRJNA560029	27924	267	1.881443	5.02345281	Plesiomonas shigelloides	703	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|1913912090\|gb\|CP062197.1\|	703	g27700	i0	100	5	267	0	100	0	1	267	97177	96911	Plesiomonas shigelloides strain P5462 plasmid p1, complete sequence	blastn	1335	494	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
6234049	6234049	PRJNA560029_S_NODE_9665_length_370_cov_2.942761_g9441_i0	PRJNA560029	9665	370	2.942761	10.8882157	root	1	Root_unresolved	Root_unresolved	678	0	NTclustered	gi\|857129904\|gb\|CP011230.1\|	730	g9441	i0	99.73	100.402702702703	370	1	100	0	1	370	1190693	1190324	[Haemophilus] ducreyi strain DMC64 chromosome	blastn	37149	678	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	[Haemophilus] ducreyi
6921866	6921866	PRJNA560029_S_NODE_22226_length_292_cov_2.168950_g22002_i0	PRJNA560029	22226	292	2.16895	6.333334	Haemophilus parainfluenzae	729	Bacteria	Bacteria	484	2.2499999999999993e-132	NTclustered	gi\|1919211880\|gb\|CP063116.1\|	729	g22002	i0	97.213	93.0616438356164	287	7	98	1	6	292	1284432	1284147	Haemophilus parainfluenzae strain M1C146_1 chromosome, complete genome	blastn	27174	484	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
6922019	6922019	PRJNA560029_S_NODE_29306_length_262_cov_0.894180_g29082_i0	PRJNA560029	29306	262	0.89418	2.3427516	Pluralibacter gergoviae	61647	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|2863505422\|gb\|CP139937.1\|	61647	g29082	i0	99.618	77.8015267175573	262	1	100	0	1	262	3856994	3856733	Pluralibacter gergoviae strain L1 chromosome, complete genome	blastn	20384	479	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pluralibacter	Pluralibacter gergoviae
8196648	8196648	PRJNA560029_S_NODE_14067_length_337_cov_1.458333_g13843_i0	PRJNA560029	14067	337	1.458333	4.91458221	Pluralibacter gergoviae	61647	Bacteria	Bacteria	606	5.409999999999998e-169	NTclustered	gi\|689257448\|gb\|CP009450.1\|	61647	g13843	i0	99.11	4	337	3	100	0	1	337	5407446	5407110	Pluralibacter gergoviae strain FB2, complete genome	blastn	1348	606	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pluralibacter	Pluralibacter gergoviae
8196710	8196710	PRJNA560029_S_NODE_17947_length_313_cov_3.133333_g17723_i0	PRJNA560029	17947	313	3.133333	9.80733229	Vibrio cholerae	666	Bacteria	Bacteria	579	1.0899999999999999e-160	NTclustered	gi\|1858885135\|gb\|CP053795.1\|	666	g17723	i0	100	1	313	0	100	0	1	313	633188	633500	Vibrio cholerae strain W10G chromosome 2, complete sequence	blastn	313	579	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio cholerae
8197144	8197144	PRJNA560029_S_NODE_5167_length_432_cov_2.445682_g4943_i0	PRJNA560029	5167	432	2.445682	10.56534624	Plesiomonas shigelloides	703	Bacteria	Bacteria	782	0	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g4943	i0	99.306	68.2893518518518	432	3	100	0	1	432	1855650	1856081	Plesiomonas shigelloides strain Colony13 chromosome	blastn	29501	782	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
8783334	8783334	PRJNA560029_S_NODE_26047_length_275_cov_1.247525_g25823_i0	PRJNA560029	26047	275	1.247525	3.43069375	Pseudomonas	286	Bacteria	Bacteria	492	1.26e-134	NTclustered	gi\|1797741011\|dbj\|AP022324.1\|	303	g25823	i0	98.909	683.138181818182	275	3	100	0	1	275	672734	673008	Pseudomonas putida TS312 DNA, complete genome	blastn	187863	492	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas putida
10058966	10058966	PRJNA560029_S_NODE_17708_length_314_cov_6.053942_g17484_i0	PRJNA560029	17708	314	6.053942	19.00937788	root	1	Root_unresolved	Root_unresolved	553	6.609999999999998e-153	NTclustered	gi\|2626477927\|gb\|CP139410.1\|	548	g17484	i0	98.408	102.990445859873	314	5	100	0	1	314	8608	8295	Klebsiella aerogenes strain C252072 plasmid pC252072-2, complete sequence	blastn	32339	553	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella aerogenes
10748039	10748039	PRJNA560029_S_NODE_13889_length_338_cov_2.177358_g13665_i0	PRJNA560029	13889	338	2.177358	7.35947004	Faucicola osloensis	34062	Bacteria	Bacteria	625	1.4999999999999999e-174	NTclustered	gi\|1654271667\|gb\|CP040257.1\|	34062	g13665	i0	100	23.5621301775148	338	0	100	0	1	338	298088	298425	Moraxella osloensis strain MOXF1 chromosome, complete genome	blastn	7964	625	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
11333574	11333574	PRJNA560029_S_NODE_19549_length_305_cov_2.456897_g19325_i0	PRJNA560029	19549	305	2.456897	7.49353585	Comamonas	283	Bacteria	Bacteria	564	2.95e-156	NTclustered	gi\|1885879519\|gb\|CP043568.1\|	285	g19325	i0	100	493.950819672131	305	0	100	0	1	305	593892	593588	Comamonas testosteroni strain T5-67 chromosome, complete genome	blastn	150655	564	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas testosteroni
11333594	11333594	PRJNA560029_S_NODE_32889_length_248_cov_2.000000_g32665_i0	PRJNA560029	32889	248	2	4.96	Gammaproteobacteria	1236	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1185671278\|gb\|KX784503.1\|	546	g32665	i0	100	104	248	0	100	0	1	248	42516	42269	Citrobacter freundii strain 17285 plasmid p17285-IMP, complete sequence	blastn	25792	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter freundii
12023024	12023024	PRJNA560029_S_NODE_24590_length_281_cov_3.822115_g24366_i0	PRJNA560029	24590	281	3.822115	10.74014315	Vibrio sp. HDW18	2714948	Bacteria	Bacteria	150	8.929999999999999e-32	NTclustered	gi\|1821214403\|gb\|CP049913.1\|	2714948	g24366	i0	81.443	0.690391459074733	194	27	66	3	93	278	1512152	1511960	Vibrio sp. HDW18 chromosome, complete genome	blastn	194	150	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio sp. HDW18
12023276	12023276	PRJNA560029_S_NODE_35830_length_239_cov_2.246988_g35606_i0	PRJNA560029	35830	239	2.246988	5.37030132	Pluralibacter gergoviae	61647	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|2863505422\|gb\|CP139937.1\|	61647	g35606	i0	98.745	2.98744769874477	239	3	100	0	1	239	3825789	3825551	Pluralibacter gergoviae strain L1 chromosome, complete genome	blastn	714	425	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pluralibacter	Pluralibacter gergoviae
12609425	12609425	PRJNA560029_S_NODE_930_length_807_cov_39.123978_g756_i0	PRJNA560029	930	807	39.123978	315.73050246	Enterobacteriaceae	543	Bacteria	Bacteria	1452	0	NTclustered	gi\|2179861008\|gb\|CP071862.1\|	550	g756	i0	99.873	27.2527881040892	790	0	98	1	1	789	173261	174050	Enterobacter cloacae strain GX1Z-1L plasmid pGX1Z-1L, complete sequence	blastn	21993	1452	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter cloacae
13297965	13297965	PRJNA560029_S_NODE_22051_length_293_cov_1.750000_g21827_i0	PRJNA560029	22051	293	1.75	5.1275	Faucicola osloensis	34062	Bacteria	Bacteria	531	2.86e-146	NTclustered	gi\|1282077041\|gb\|CP024185.2\|	34062	g21827	i0	99.317	13.8600682593857	293	2	100	0	1	293	2275929	2275637	Moraxella osloensis strain TT16 chromosome, complete genome	blastn	4061	531	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
13298184	13298184	PRJNA560029_S_NODE_32211_length_250_cov_2.610169_g31987_i0	PRJNA560029	32211	250	2.610169	6.5254225	Moraxella sp. DOX410	3076087	Bacteria	Bacteria	418	1.9399999999999998e-112	NTclustered	gi\|2586132762\|gb\|CP135138.1\|	3076087	g31987	i0	96.8	15.624	250	8	100	0	1	250	1838023	1838272	Moraxella sp. DOX410 chromosome, complete genome	blastn	3906	418	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Moraxella	Moraxella sp. DOX410
13298213	13298213	PRJNA560029_S_NODE_33351_length_247_cov_1.189655_g33127_i0	PRJNA560029	33351	247	1.189655	2.93844785	Pluralibacter gergoviae	61647	Bacteria	Bacteria	429	8.83e-116	NTclustered	gi\|2863505422\|gb\|CP139937.1\|	61647	g33127	i0	97.976	40.8016194331984	247	5	100	0	1	247	2167729	2167975	Pluralibacter gergoviae strain L1 chromosome, complete genome	blastn	10078	429	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pluralibacter	Pluralibacter gergoviae
13298227	13298227	PRJNA560029_S_NODE_33831_length_245_cov_5.540698_g33607_i0	PRJNA560029	33831	245	5.540698	13.5747101	Faucicola osloensis	34062	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1278991277\|gb\|CP024180.2\|	34062	g33607	i0	98.776	16.8204081632653	245	3	100	0	1	245	327210	327454	Moraxella osloensis strain KSH chromosome, complete genome	blastn	4121	436	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
13298367	13298367	PRJNA560029_S_NODE_8571_length_381_cov_1.629870_g8347_i0	PRJNA560029	8571	381	1.62987	6.2098047	Plesiomonas shigelloides	703	Bacteria	Bacteria	429	1.44e-115	NTclustered	gi\|1037176310\|emb\|LT575468.1\|	703	g8347	i0	100	4.87139107611549	232	0	61	0	20	251	2485440	2485209	Plesiomonas shigelloides strain NCTC10360 genome assembly, chromosome: 1	blastn	1856	429	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
14572834	14572834	PRJNA560029_S_NODE_23452_length_286_cov_4.000000_g23228_i0	PRJNA560029	23452	286	4	11.44	Plesiomonas shigelloides	703	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1370756710\|gb\|CP027852.1\|	703	g23228	i0	100	752.321678321678	286	0	100	0	1	286	1709081	1708796	Plesiomonas shigelloides strain MS-17-188 chromosome, complete genome	blastn	215164	529	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
14572835	14572835	PRJNA560029_S_NODE_23492_length_286_cov_2.892019_g23268_i0	PRJNA560029	23492	286	2.892019	8.27117434	Acinetobacter johnsonii	40214	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1934492808\|gb\|CP059080.1\|	40214	g23268	i0	100	114.548951048951	286	0	100	0	1	286	2819928	2820213	Acinetobacter johnsonii strain E10B chromosome, complete genome	blastn	32761	529	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
14573057	14573057	PRJNA560029_S_NODE_32652_length_249_cov_1.312500_g32428_i0	PRJNA560029	32652	249	1.3125	3.268125	Vibrio sp. HDW18	2714948	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|1821214403\|gb\|CP049913.1\|	2714948	g32428	i0	99.598	1	249	1	100	0	1	249	1495797	1496045	Vibrio sp. HDW18 chromosome, complete genome	blastn	249	455	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio sp. HDW18
15158468	15158468	PRJNA560029_S_NODE_24792_length_280_cov_5.086957_g24568_i0	PRJNA560029	24792	280	5.086957	14.2434796	Vibrio	662	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|2217766341\|dbj\|AP023379.1\|	666	g24568	i0	100	858.978571428571	271	0	97	0	10	280	2943116	2943386	Vibrio cholerae O51 RIMD 2214289 DNA, chromosome 1, complete genome	blastn	240514	501	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio cholerae
15158495	15158495	PRJNA560029_S_NODE_8732_length_379_cov_3.839869_g8508_i0	PRJNA560029	8732	379	3.839869	14.55310351	Moraxellaceae	468	Bacteria	Bacteria	695	0	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g8508	i0	99.737	427.094986807388	380	0	100	1	1	379	1497796	1497417	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	161869	695	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
15846482	15846482	PRJNA560029_S_NODE_11313_length_356_cov_3.236749_g11089_i0	PRJNA560029	11313	356	3.236749	11.52282644	Pluralibacter gergoviae	61647	Bacteria	Bacteria	274	6.609999999999998e-69	NTclustered	gi\|689257448\|gb\|CP009450.1\|	61647	g11089	i0	94.857	25.4438202247191	175	9	49	0	3	177	2303755	2303929	Pluralibacter gergoviae strain FB2, complete genome	blastn	9058	274	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pluralibacter	Pluralibacter gergoviae
17121496	17121496	PRJNA560029_S_NODE_17514_length_315_cov_6.413223_g17290_i0	PRJNA560029	17514	315	6.413223	20.20165245	Buchnera aphidicola	9	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2736169490\|gb\|CP140043.1\|	3093912	g17290	i0	96.97	0.104761904761905	33	1	10	0	1	33	102441	102473	MAG: Buchnera aphidicola (Schlechtendalia peitan) isolate R2 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
19670202	19670202	PRJNA560029_S_NODE_14196_length_336_cov_1.912548_g13972_i0	PRJNA560029	14196	336	1.912548	6.42616128	Pluralibacter gergoviae	61647	Bacteria	Bacteria	616	8.96e-172	NTclustered	gi\|2863505422\|gb\|CP139937.1\|	61647	g13972	i0	99.702	91.5119047619048	336	1	100	0	1	336	421070	420735	Pluralibacter gergoviae strain L1 chromosome, complete genome	blastn	30748	616	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pluralibacter	Pluralibacter gergoviae
19670707	19670707	PRJNA560029_S_NODE_5176_length_432_cov_1.228412_g4952_i0	PRJNA560029	5176	432	1.228412	5.30673984	Vibrio sp. HDW18	2714948	Bacteria	Bacteria	749	0	NTclustered	gi\|1821214403\|gb\|CP049913.1\|	2714948	g4952	i0	98.135	0.993055555555556	429	8	99	0	1	429	1499364	1499792	Vibrio sp. HDW18 chromosome, complete genome	blastn	429	749	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio sp. HDW18
20946230	20946230	PRJNA560029_S_NODE_30437_length_257_cov_1.951087_g30213_i0	PRJNA560029	30437	257	1.951087	5.01429359	Plesiomonas shigelloides	703	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g30213	i0	99.611	11.3151750972763	257	1	100	0	1	257	2858169	2858425	Plesiomonas shigelloides strain Colony13 chromosome	blastn	2908	470	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
22220824	22220824	PRJNA560029_S_NODE_14738_length_332_cov_4.119691_g14514_i0	PRJNA560029	14738	332	4.119691	13.67737412	Acidocella sp. MX-AZ03	2697363	Bacteria	Bacteria	58.4	6.72e-4	NTclustered	gi\|2423887861\|gb\|CP110774.1\|	2697363	g14514	i0	97.059	0.102409638554217	34	1	10	0	166	199	1479217	1479250	Acidocella sp. MX-AZ03 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acidocellaceae	Acidocella	Acidocella sp. MX-AZ03
23496471	23496471	PRJNA560029_S_NODE_31439_length_253_cov_1.677778_g31215_i0	PRJNA560029	31439	253	1.677778	4.24477834	Buchnera aphidicola	9	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2736166897\|gb\|CP140036.1\|	3093911	g31215	i0	94.444	0.142292490118577	36	0	13	2	132	165	309291	309326	MAG: Buchnera aphidicola (Nurudea yanoniella) isolate R13 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
24770089	24770089	PRJNA560029_S_NODE_19180_length_307_cov_1.662393_g18956_i0	PRJNA560029	19180	307	1.662393	5.10354651	Faucicola osloensis	34062	Bacteria	Bacteria	545	1.0799999999999999e-150	NTclustered	gi\|1278991277\|gb\|CP024180.2\|	34062	g18956	i0	98.697	34.9218241042345	307	4	100	0	1	307	1947542	1947848	Moraxella osloensis strain KSH chromosome, complete genome	blastn	10721	545	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
24770102	24770102	PRJNA560029_S_NODE_19720_length_304_cov_2.783550_g19496_i0	PRJNA560029	19720	304	2.78355	8.461992	Pluralibacter gergoviae	61647	Bacteria	Bacteria	523	4.989999999999998e-144	NTclustered	gi\|2863505422\|gb\|CP139937.1\|	61647	g19496	i0	97.705	100.703947368421	305	6	100	1	1	304	5370999	5370695	Pluralibacter gergoviae strain L1 chromosome, complete genome	blastn	30614	523	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pluralibacter	Pluralibacter gergoviae
25356747	25356747	PRJNA560029_S_NODE_25140_length_279_cov_1.470874_g24916_i0	PRJNA560029	25140	279	1.470874	4.10373846	Burkholderia	32008	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|685677664\|gb\|CP008726.1\|	342113	g24916	i0	100	0.537634408602151	30	0	11	0	1	30	2608889	2608860	Burkholderia oklahomensis strain EO147 chromosome 1, complete sequence	blastn	150	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia oklahomensis
26712902	26712902	PRJNA560029_S_NODE_14161_length_336_cov_2.832700_g13937_i0	PRJNA560029	14161	336	2.8327	9.517872	Brevundimonas	41275	Bacteria	Bacteria	61.6	2.64e-9	NR	WP_288757434.1	213418	g13937	i0	31.5	2.375	92	58	77.7	1	1	261	18	109	WP_288757434.1 helix-turn-helix domain-containing protein [uncultured Brevundimonas sp.]	diamond	798	61.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	uncultured Brevundimonas sp.
26903287	26903287	PRJNA560029_S_NODE_3121_length_504_cov_5.146172_g2899_i0	PRJNA560029	3121	504	5.146172	25.93670688	Pseudomonadati	3379134	Bacteria	Bacteria	87	2.28e-16	NR	WP_006747729.1	108010	g2899	i0	51.2	1	84	41	50	0	503	252	1063	1146	WP_006747729.1 hypothetical protein [Thioalkalivibrio paradoxus]	diamond	504	87.4	0.995423340961098	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Ectothiorhodospiraceae	Thioalkalivibrio	Thioalkalivibrio paradoxus
27110377	27110377	PRJNA560029_S_NODE_23262_length_287_cov_2.714953_g23038_i0	PRJNA560029	23262	287	2.714953	7.79191511	Pseudomonas aeruginosa	287	Bacteria	Bacteria	191	1.3e-57	NR	WP_128675315.1	287	g23038	i0	93.6	4.94425087108014	94	6	98.3	0	1	282	269	362	WP_128675315.1 AAA family ATPase [Pseudomonas aeruginosa]	diamond	1419	191	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
28261357	28261357	PRJNA560029_S_NODE_32306_length_250_cov_1.542373_g32082_i0	PRJNA560029	32306	250	1.542373	3.8559325	Gammaproteobacteria	1236	Bacteria	Bacteria	157	1.73e-47	NR	WP_280287793.1	287	g32082	i0	94.8	1.848	77	4	92.4	0	16	246	1	77	WP_280287793.1 hypothetical protein [Pseudomonas aeruginosa]	diamond	462	157	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
28500242	28500242	PRJNA560029_S_NODE_18707_length_309_cov_2.593220_g18483_i0	PRJNA560029	18707	309	2.59322	8.0130498	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	95.5	5.26e-22	NR	RYY03573.1	1913989	g18483	i0	62.7	6.61165048543689	75	28	72.8	0	231	7	1	75	RYY03573.1 MAG: superoxide dismutase [Fe] [Gammaproteobacteria bacterium]	diamond	2043	95.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
28500248	28500248	PRJNA560029_S_NODE_4927_length_438_cov_2.350685_g4703_i0	PRJNA560029	4927	438	2.350685	10.2960003	Massilia aerilata	453817	Bacteria	Bacteria	269	3.18e-84	NR	WP_379767854.1	453817	g4703	i0	90.3	0.986301369863014	144	14	98.6	0	1	432	29	172	WP_379767854.1 esterase/lipase family protein [Massilia aerilata]	diamond	432	269	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia aerilata
28608882	28608882	PRJNA560029_S_NODE_2247_length_569_cov_4.032258_g2026_i0	PRJNA560029	2247	569	4.032258	22.94354802	Pseudomonadati	3379134	Bacteria	Bacteria	112	2.21e-27	NR	TAK50721.1	1913989	g2026	i0	65.8	1.20738137082601	73	20	38.5	2	547	329	117	184	TAK50721.1 MAG: superoxide dismutase [Gammaproteobacteria bacterium]	diamond	687	112	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
28721230	28721230	PRJNA560029_S_NODE_15867_length_325_cov_2.333333_g15643_i0	PRJNA560029	15867	325	2.333333	7.58333225	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	67	2.81e-10	NR	MBQ8251038.1	1913988	g15643	i0	43.4	0.701538461538462	76	42	70.2	1	96	323	105	179	MBQ8251038.1 aryl-sulfate sulfotransferase [Alphaproteobacteria bacterium]	diamond	228	67	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
28987965	28987965	PRJNA560029_S_NODE_31648_length_252_cov_2.581006_g31424_i0	PRJNA560029	31648	252	2.581006	6.50413512	Gammaproteobacteria	1236	Bacteria	Bacteria	112	1.31e-28	NR	WP_029933506.1	934	g31424	i0	70.9	1.9047619047619	79	23	94	0	8	244	1	79	WP_029933506.1 5'-methylthioadenosine/S-adenosylhomocysteine nucleosidase [Thiomicrospira pelophila]	diamond	480	112	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Piscirickettsiaceae	Thiomicrospira	Thiomicrospira pelophila
29226584	29226584	PRJNA560029_S_NODE_5549_length_423_cov_56.982857_g5325_i0	PRJNA560029	5549	423	56.982857	241.03748511	Enterobacter hormaechei	158836	Bacteria	Bacteria	249	2.97e-83	NR	WP_223145253.1	158836	g5325	i0	99.2	0.865248226950355	122	1	86.5	0	1	366	1	122	WP_223145253.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	366	249	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29447138	29447138	PRJNA560029_S_NODE_13090_length_343_cov_3.270370_g12866_i0	PRJNA560029	13090	343	3.2703700000000002	11.2173691	Glaciecola sp.	1905676	Bacteria	Bacteria	65.1	6.18e-10	NR	WP_415049859.1	1905676	g12866	i0	56.1	6.6297376093294504	57	25	49.9	0	89	259	151	207	WP_415049859.1 DUF1294 domain-containing protein [Glaciecola sp.]	diamond	2274	65.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Glaciecola	Glaciecola sp.
29573441	29573441	PRJNA560029_S_NODE_11430_length_355_cov_3.244681_g11206_i0	PRJNA560029	11430	355	3.244681	11.51861755	Enterobacter hormaechei	158836	Bacteria	Bacteria	104	2.62e-26	NR	RAM39467.1	158836	g11206	i0	100	0.794366197183099	47	0	39.7	0	1	141	71	117	RAM39467.1 hypothetical protein DOZ52_29115 [Enterobacter hormaechei]	diamond	282	104	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29587339	29587339	PRJNA560029_S_NODE_22830_length_289_cov_3.291667_g22606_i0	PRJNA560029	22830	289	3.291667	9.51291763	Enterobacter	547	Bacteria	Bacteria	137	1.59e-36	NR	WP_314352737.1	158836	g22606	i0	100	2.05536332179931	66	0	68.5	0	200	3	1	66	WP_314352737.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	594	137	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29682044	29682044	PRJNA560029_S_NODE_14450_length_334_cov_3.540230_g14226_i0	PRJNA560029	14450	334	3.54023	11.8243682	Gammaproteobacteria	1236	Bacteria	Bacteria	61.2	2.93e-8	NR	URM14412.1	29497	g14226	i0	40.8	1.66167664670659	71	39	61.1	1	332	129	92	162	URM14412.1 glycosyltransferase [Vibrio splendidus]	diamond	555	61.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio splendidus
30205071	30205071	PRJNA560029_S_NODE_23232_length_287_cov_3.892523_g23008_i0	PRJNA560029	23232	287	3.892523	11.17154101	Ralstonia pickettii	329	Bacteria	Bacteria	179	1.0499999999999999e-54	NR	WP_173004240.1	329	g23008	i0	98.9	0.909407665505226	87	1	90.9	0	261	1	1	87	WP_173004240.1 response regulator transcription factor [Ralstonia pickettii]	diamond	261	179	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
30236962	30236962	PRJNA560029_S_NODE_8932_length_377_cov_2.802632_g8708_i0	PRJNA560029	8932	377	2.802632	10.56592264	Sphingomonas sp.	28214	Bacteria	Bacteria	91.7	1.27e-18	NR	RZL28055.1	28214	g8708	i0	59.5	0.588859416445623	74	30	58.9	0	2	223	586	659	RZL28055.1 MAG: hypothetical protein EOP64_05680 [Sphingomonas sp.]	diamond	222	91.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp.
30268850	30268850	PRJNA560029_S_NODE_24692_length_281_cov_1.846154_g24468_i0	PRJNA560029	24692	281	1.846154	5.18769274	Nitrosomonas halophila	44576	Bacteria	Bacteria	43.9	0.0227	NR	WP_090414403.1	44576	g24468	i0	36.2	0.736654804270463	69	44	73.7	0	53	259	512	580	WP_090414403.1 hypothetical protein [Nitrosomonas halophila]	diamond	207	43.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Nitrosomonadaceae	Nitrosomonas	Nitrosomonas halophila
30314658	30314658	PRJNA560029_S_NODE_37292_length_224_cov_4.649007_g37068_i0	PRJNA560029	37292	224	4.649007	10.41377568	Bacteria	2	Bacteria	Bacteria	82	1.56e-16	NR	MFK7995568.1	1943584	g37068	i0	60	10.8214285714286	55	22	73.7	0	168	4	3	57	MFK7995568.1 NAD(P)/FAD-dependent oxidoreductase [Granulosicoccus sp.]	diamond	2424	82	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Granulosicoccaceae	Granulosicoccus	Granulosicoccus sp.
30552760	30552760	PRJNA560029_S_NODE_10233_length_365_cov_2.342466_g10009_i0	PRJNA560029	10233	365	2.342466	8.5500009	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	79	1.31e-15	NR	MFC1602388.1	1977087	g10009	i0	62.3	2.28493150684932	53	20	43.6	0	354	196	113	165	MFC1602388.1 thiol peroxidase [Pseudomonadota bacterium]	diamond	834	79	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
30552768	30552768	PRJNA560029_S_NODE_28293_length_265_cov_3.609375_g28069_i0	PRJNA560029	28293	265	3.609375	9.56484375	Pseudomonas fluorescens	294	Bacteria	Bacteria	58.5	1.37e-7	NR	WP_081006351.1	294	g28069	i0	36.6	3.70188679245283	82	50	90.6	1	22	261	216	297	WP_081006351.1 metallophosphoesterase [Pseudomonas fluorescens]	diamond	981	58.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
30584316	30584316	PRJNA560029_S_NODE_6953_length_401_cov_1.865854_g6729_i0	PRJNA560029	6953	401	1.865854	7.48207454	Neisseriaceae bacterium	2014784	Bacteria	Bacteria	141	2.34e-38	NR	MFH4416074.1	2014784	g6729	i0	58.6	3.34413965087282	111	46	83	0	1	333	197	307	MFH4416074.1 glycosyltransferase family 2 protein [Neisseriaceae bacterium]	diamond	1341	141	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae		Neisseriaceae bacterium
31027005	31027005	PRJNA560029_S_NODE_6295_length_410_cov_13.821958_g6071_i0	PRJNA560029	6295	410	13.821958	56.6700278	Wohlfahrtiimonas chitiniclastica	400946	Bacteria	Bacteria	146	4.48e-42	NR	WP_094491519.1	400946	g6071	i0	60.3	3.71707317073171	126	50	92.2	0	21	398	17	142	WP_094491519.1 GNAT family N-acetyltransferase [Wohlfahrtiimonas chitiniclastica]	diamond	1524	146	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cardiobacteriales	Ignatzschineriaceae	Wohlfahrtiimonas	Wohlfahrtiimonas chitiniclastica
31469630	31469630	PRJNA560029_S_NODE_14356_length_335_cov_1.763359_g14132_i0	PRJNA560029	14356	335	1.763359	5.90725265	Aggregatibacter actinomycetemcomitans	714	Bacteria	Bacteria	127	3.4399999999999996e-35	NR	WP_231098916.1	714	g14132	i0	71.1	1.4865671641791	83	24	74.3	0	83	331	48	130	WP_231098916.1 hypothetical protein [Aggregatibacter actinomycetemcomitans]	diamond	498	127	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Aggregatibacter	Aggregatibacter actinomycetemcomitans
31596208	31596208	PRJNA560029_S_NODE_19196_length_307_cov_1.452991_g18972_i0	PRJNA560029	19196	307	1.452991	4.46068237	Simplicispira hankyongi	2315688	Bacteria	Bacteria	46.6	0.00178	NR	WP_158606155.1	2315688	g18972	i0	34.4	0.596091205211726	61	35	59.6	1	286	104	82	137	WP_158606155.1 flavodoxin family protein [Simplicispira hankyongi]	diamond	183	46.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Simplicispira	Simplicispira hankyongi
31627522	31627522	PRJNA560029_S_NODE_12216_length_349_cov_2.981884_g11992_i0	PRJNA560029	12216	349	2.981884	10.40677516	Thiolinea sp.	2212699	Bacteria	Bacteria	50.4	2.16e-4	NR	HPY41230.1	2212699	g11992	i0	48.3	1.00573065902579	60	31	51.6	0	349	170	246	305	HPY41230.1 PfkB family carbohydrate kinase [Thiolinea sp.]	diamond	351	50.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Thiolinaceae	Thiolinea	Thiolinea sp.
31989508	31989508	PRJNA560029_S_NODE_21738_length_294_cov_3.144796_g21514_i0	PRJNA560029	21738	294	3.144796	9.24570024	Bacteria	2	Bacteria	Bacteria	119	5.83e-30	NR	WP_220359234.1	727	g21514	i0	64.4	6.26530612244898	87	30	88.8	1	289	29	132	217	WP_220359234.1 DNA cytosine methyltransferase [Haemophilus influenzae]	diamond	1842	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus influenzae
32464349	32464349	PRJNA560029_S_NODE_8759_length_379_cov_2.016340_g8535_i0	PRJNA560029	8759	379	2.01634	7.6419286	Bacteria	2	Bacteria	Bacteria	115	3.1e-28	NR	WP_028451386.1	362520	g8535	i0	53.3	2.75461741424802	120	53	94.2	3	4	360	204	321	WP_028451386.1 gluconeogenesis factor YvcK family protein [Chitinilyticum aquatile]	diamond	1044	115	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chitinibacteraceae	Chitinilyticum	Chitinilyticum aquatile
32608175	32608175	PRJNA560029_S_NODE_10160_length_365_cov_10.102740_g9936_i0	PRJNA560029	10160	365	10.10274	36.875001	Sphingobium rhizovicinum	432308	Bacteria	Bacteria	60.5	1.34e-8	NR	WP_380798192.1	432308	g9936	i0	33.7	1.65205479452055	104	63	83.8	2	353	48	53	152	WP_380798192.1 MarR family winged helix-turn-helix transcriptional regulator [Sphingobium rhizovicinum]	diamond	603	60.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingobium	Sphingobium rhizovicinum

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