metadata: contig_metadata: 67 rows where bioproject = "PRJEB28589" and tax

67 rows where bioproject = "PRJEB28589" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25961	25961	PRJEB28589_S_NODE_5681_length_313_cov_1.898496_g5573_i0	PRJEB28589	5681	313	1.898496	5.94229248	Faucicola osloensis	34062	Bacteria	Bacteria	507	5.2e-139	NTclustered	gi\|2722728872\|dbj\|AP031472.1\|	34062	g5573	i0	98.606	14.6837060702875	287	3	91	1	1	286	203842	203556	Moraxella osloensis NBRC 115781 DNA, complete genome	blastn	4596	507	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
25976	25976	PRJEB28589_S_NODE_7141_length_290_cov_8.127572_g7033_i0	PRJEB28589	7141	290	8.127572	23.5699588	Methylobacterium sp. OTU13CASTA1	2953579	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2261078250\|gb\|CP099611.1\|	2953579	g7033	i0	100	0.096551724137931	28	0	10	0	154	181	3010223	3010196	Methylobacterium sp. OTU13CASTA1 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium sp. OTU13CASTA1
988036	988036	PRJEB28589_S_NODE_8081_length_275_cov_7.359649_g7973_i0	PRJEB28589	8081	275	7.359649	20.23903475	Ralstonia	48736	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2209826444\|gb\|CP093306.1\|	190721	g7973	i0	100	3	275	0	100	0	1	275	226211	226485	Ralstonia insidiosa strain 15-1563-3 plasmid pB1902, complete sequence	blastn	825	508	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia insidiosa
1300199	1300199	PRJEB28589_S_NODE_13042_length_208_cov_1.757764_g12934_i0	PRJEB28589	13042	208	1.757764	3.65614912	Pasteurella multocida	747	Bacteria	Bacteria	385	1.58e-102	NTclustered	gi\|2246232822\|gb\|CP097616.1\|	747	g12934	i0	100	34.25	208	0	100	0	1	208	2229678	2229471	Pasteurella multocida strain P1702 chromosome, complete genome	blastn	7124	385	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Pasteurella	Pasteurella multocida
1300282	1300282	PRJEB28589_S_NODE_8082_length_275_cov_6.828947_g7974_i0	PRJEB28589	8082	275	6.828947	18.77960425	Rickettsia asembonensis	1068590	Bacteria	Bacteria	481	2.72e-131	NTclustered	gi\|2441943819\|gb\|CP116496.1\|	1068590	g7974	i0	98.182	100	275	5	100	0	1	275	89378	89652	MAG: Rickettsia asembonensis isolate Perak chromosome, complete genome	blastn	27500	481	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia asembonensis
2575835	2575835	PRJEB28589_S_NODE_2223_length_401_cov_3.864407_g2115_i0	PRJEB28589	2223	401	3.864407	15.49627207	Rickettsia felis	42862	Bacteria	Bacteria	684	0	NTclustered	gi\|470476969\|ref\|NR_076359.1\|	42862	g2115	i0	100	92.2718204488778	370	0	92	0	32	401	8	377	Rickettsia felis strain URRWXCal2 23S ribosomal RNA gene, complete sequence	blastn	37001	684	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia felis
2575844	2575844	PRJEB28589_S_NODE_3443_length_357_cov_3.961290_g3335_i0	PRJEB28589	3443	357	3.96129	14.1418053	Rickettsia tillamookensis	2761623	Bacteria	Bacteria	641	1.5799999999999994e-179	NTclustered	gi\|2334498913\|gb\|CP060138.2\|	2761623	g3335	i0	99.16	99.9579831932773	357	1	100	1	1	357	1282250	1281896	Rickettsia tillamookensis strain Tillamook 23 chromosome, complete genome	blastn	35685	641	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia tillamookensis
3538633	3538633	PRJEB28589_S_NODE_4863_length_328_cov_3.480427_g4755_i0	PRJEB28589	4863	328	3.480427	11.41580056	Moraxellaceae	468	Bacteria	Bacteria	590	5.29e-164	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g4755	i0	99.088	361.823170731707	329	2	100	1	1	328	1497464	1497792	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	118678	590	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
3538635	3538635	PRJEB28589_S_NODE_7703_length_282_cov_3.255319_g7595_i0	PRJEB28589	7703	282	3.255319	9.17999958	Alcaligenaceae	506	Bacteria	Bacteria	516	7.67e-142	NTclustered	gi\|29242999\|emb\|AJ509008.1\|	511	g7595	i0	99.645	322	282	1	100	0	1	282	723	1004	Alcaligenes faecalis partial 23S rRNA gene, isolate 6713-A1	blastn	90804	521	0.990403071017274	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Alcaligenes	Alcaligenes faecalis
3852161	3852161	PRJEB28589_S_NODE_7404_length_286_cov_5.778243_g7296_i0	PRJEB28589	7404	286	5.778243	16.52577498	Serratia surfactantfaciens	2741499	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1057963632\|gb\|CP016948.1\|	2741499	g7296	i0	100	0.199300699300699	29	0	10	0	14	42	3727940	3727912	Serratia surfactantfaciens strain YD25 chromosome, complete genome	blastn	57	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Serratia	Serratia surfactantfaciens
5128321	5128321	PRJEB28589_S_NODE_11465_length_228_cov_2.198895_g11357_i0	PRJEB28589	11465	228	2.198895	5.0134806	Rickettsia tillamookensis	2761623	Bacteria	Bacteria	374	3.8199999999999984e-99	NTclustered	gi\|2334498913\|gb\|CP060138.2\|	2761623	g11357	i0	96.491	280.078947368421	228	5	100	2	1	228	64371	64595	Rickettsia tillamookensis strain Tillamook 23 chromosome, complete genome	blastn	63858	374	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia tillamookensis
5128334	5128334	PRJEB28589_S_NODE_14325_length_194_cov_1.387755_g14217_i0	PRJEB28589	14325	194	1.387755	2.6922447	Rickettsia tillamookensis	2761623	Bacteria	Bacteria	279	7.06e-71	NTclustered	gi\|2334498913\|gb\|CP060138.2\|	2761623	g14217	i0	96.988	17.180412371134	166	5	86	0	4	169	564892	564727	Rickettsia tillamookensis strain Tillamook 23 chromosome, complete genome	blastn	3333	279	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia tillamookensis
5128386	5128386	PRJEB28589_S_NODE_6325_length_303_cov_5.445312_g6217_i0	PRJEB28589	6325	303	5.445312	16.49929536	Rhodoferax sp. GW822-FHT02A01	3141537	Bacteria	Bacteria	296	1.18e-75	NTclustered	gi\|2724393917\|gb\|CP152376.1\|	3141537	g6217	i0	85.315	18.3795379537954	286	42	94	0	9	294	1965421	1965706	Rhodoferax sp. GW822-FHT02A01 chromosome, complete genome	blastn	5569	296	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Rhodoferax	Rhodoferax sp. GW822-FHT02A01
5128395	5128395	PRJEB28589_S_NODE_8065_length_276_cov_1.572052_g7957_i0	PRJEB28589	8065	276	1.572052	4.33886352	Neisseria sp. Marseille-Q5346	2972775	Bacteria	Bacteria	440	4.6399999999999984e-119	NTclustered	gi\|2306610385\|emb\|OX336253.1\|	2972775	g7957	i0	95.941	16.9420289855072	271	11	98	0	1	271	2293522	2293252	Neisseria sp. Marseille-Q5346 genome assembly, chromosome: contig00001	blastn	4676	440	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria sp. Marseille-Q5346
6091153	6091153	PRJEB28589_S_NODE_7405_length_286_cov_5.661088_g7297_i0	PRJEB28589	7405	286	5.661088	16.19071168	Rickettsia	780	Bacteria	Bacteria	361	3.87e-95	NTclustered	gi\|2441943819\|gb\|CP116496.1\|	1068590	g7297	i0	98.068	75.986013986014	207	4	72	0	1	207	409886	409680	MAG: Rickettsia asembonensis isolate Perak chromosome, complete genome	blastn	21732	361	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia asembonensis
6404174	6404174	PRJEB28589_S_NODE_2406_length_391_cov_5.654070_g2298_i0	PRJEB28589	2406	391	5.65407	22.1074137	Faucicola osloensis	34062	Bacteria	Bacteria	691	0	NTclustered	gi\|1654271667\|gb\|CP040257.1\|	34062	g2298	i0	98.718	14.9335038363171	390	4	99	1	1	390	2676510	2676122	Moraxella osloensis strain MOXF1 chromosome, complete genome	blastn	5839	691	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
6404222	6404222	PRJEB28589_S_NODE_9426_length_256_cov_3.751196_g9318_i0	PRJEB28589	9426	256	3.751196	9.60306176	Faucicola osloensis	34062	Bacteria	Bacteria	446	9.139999999999999e-121	NTclustered	gi\|1278990996\|gb\|CP024443.2\|	34062	g9318	i0	99.19	15.4375	247	2	96	0	10	256	994436	994682	Moraxella osloensis strain NP7 chromosome, complete genome	blastn	3952	446	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
7365649	7365649	PRJEB28589_S_NODE_7746_length_281_cov_5.700855_g7638_i0	PRJEB28589	7746	281	5.700855	16.01940255	Rickettsia	780	Bacteria	Bacteria	520	5.909999999999999e-143	NTclustered	gi\|902717153\|gb\|KR611317.1\|	1133329	g7638	i0	100	22.1459074733096	281	0	100	0	1	281	11510	11790	Rickettsia endosymbiont of Ixodes pacificus strain Humboldt plasmid pREIP, complete sequence	blastn	6223	520	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia endosymbiont of Ixodes pacificus
8952997	8952997	PRJEB28589_S_NODE_4628_length_333_cov_3.527972_g4520_i0	PRJEB28589	4628	333	3.527972	11.74814676	Rickettsia endosymbiont of Cantharis rufa	3066248	Bacteria	Bacteria	313	1.3e-80	NTclustered	gi\|2717309479\|emb\|OZ032150.1\|	3066248	g4520	i0	89.02	293.72972972973	255	25	92	2	58	309	622980	623234	Rickettsia endosymbiont of Cantharis rufa isolate 54716 genome assembly, chromosome: 1	blastn	97812	313	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia endosymbiont of Cantharis rufa
10228756	10228756	PRJEB28589_S_NODE_5269_length_320_cov_3.245421_g5161_i0	PRJEB28589	5269	320	3.245421	10.3853472	Acinetobacter lwoffii	28090	Bacteria	Bacteria	586	6.65e-163	NTclustered	gi\|1751391443\|gb\|CP019143.2\|	28090	g5161	i0	99.688	97.44375	320	1	100	0	1	320	2313475	2313794	Acinetobacter lwoffii strain ZS207 chromosome, complete genome	blastn	31182	586	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
10228787	10228787	PRJEB28589_S_NODE_8649_length_267_cov_2.859091_g8541_i0	PRJEB28589	8649	267	2.859091	7.63377297	Pasteurella multocida	747	Bacteria	Bacteria	455	1.5900000000000002e-123	NTclustered	gi\|2022680428\|gb\|CP072655.1\|	747	g8541	i0	100	92.1348314606742	246	0	92	0	22	267	676852	676607	Pasteurella multocida strain Tibet-Pm1 chromosome, complete genome	blastn	24600	455	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Pasteurella	Pasteurella multocida
11191348	11191348	PRJEB28589_S_NODE_19229_length_157_cov_0.927273_g19121_i0	PRJEB28589	19229	157	0.927273	1.45581861	Rickettsia	780	Bacteria	Bacteria	285	1.17e-72	NTclustered	gi\|749495816\|emb\|LN794217.1\|	109232	g19121	i0	99.363	99.8853503184713	157	1	100	0	1	157	1314972	1315128	Rickettsia monacensis, strain IrR/Munich, complete genome	blastn	15682	285	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia monacensis
12467119	12467119	PRJEB28589_S_NODE_14230_length_195_cov_1.378378_g14122_i0	PRJEB28589	14230	195	1.378378	2.6878371	Rickettsia	780	Bacteria	Bacteria	316	5.41e-82	NTclustered	gi\|291066969\|gb\|GQ385243.1\|	42862	g14122	i0	100	37.5794871794872	171	0	88	0	25	195	2937	3107	Rickettsia felis clone Ar3 outer membrane protein B (ompB) gene, complete cds	blastn	7328	316	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia felis
12467141	12467141	PRJEB28589_S_NODE_8810_length_265_cov_2.288991_g8702_i0	PRJEB28589	8810	265	2.288991	6.06582615	Luteibacter sp. Sphag1AF	2587031	Bacteria	Bacteria	58.9	2.54e-8	NR	WP_183421670.1	2587031	g8702	i0	67.5	0.452830188679245	40	13	45.3	0	239	120	137	176	WP_183421670.1 lipocalin family protein [Luteibacter sp. Sphag1AF]	diamond	120	58.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Luteibacter	Luteibacter sp. Sphag1AF
12779518	12779518	PRJEB28589_S_NODE_271_length_852_cov_4.346584_g207_i0	PRJEB28589	271	852	4.346584	37.03289568	Vibrio furnissii	29494	Bacteria	Bacteria	1519	0	NTclustered	gi\|2522625247\|gb\|CP128203.1\|	29494	g207	i0	98.941	116.744131455399	850	8	99	1	3	852	1145	297	Vibrio furnissii strain VFBJ07 plasmid pVFBJ07-2, complete sequence	blastn	99466	1519	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio furnissii
12779545	12779545	PRJEB28589_S_NODE_5591_length_314_cov_4.752809_g5483_i0	PRJEB28589	5591	314	4.752809	14.92382026	Achromobacter xylosoxidans	85698	Bacteria	Bacteria	580	3.0299999999999992e-161	NTclustered	gi\|2809278131\|gb\|CP116209.1\|	85698	g5483	i0	100	321.722929936306	314	0	100	0	1	314	2018	2331	MAG: Achromobacter xylosoxidans isolate IITD-KLINJ-A02 chromosome	blastn	101021	580	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Achromobacter	Achromobacter xylosoxidans
13741497	13741497	PRJEB28589_S_NODE_13611_length_201_cov_6.954545_g13503_i0	PRJEB28589	13611	201	6.954545	13.97863545	root	1	Root_unresolved	Root_unresolved	372	1.18e-98	NTclustered	gi\|1605306975\|gb\|MK415038.1\|	512	g13503	i0	100	114	201	0	100	0	1	201	1335	1135	Alcaligenes sp. strain IAE89 16S ribosomal RNA gene, partial sequence	blastn	22914	372	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Alcaligenes	Alcaligenes sp.
14054188	14054188	PRJEB28589_S_NODE_9692_length_252_cov_5.058537_g9584_i0	PRJEB28589	9692	252	5.058537	12.74751324	Candidatus Blochmannia vicinus (nom. nud.)	251540	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2246426502\|gb\|CP097756.1\|	251540	g9584	i0	100	0.111111111111111	28	0	11	0	148	175	771668	771641	Candidatus Blochmannia vicinus strain C-028 chromosome, complete genome	blastn	28	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Blochmanniella	Candidatus Blochmannia vicinus (nom. nud.)
15015879	15015879	PRJEB28589_S_NODE_11692_length_225_cov_2.674157_g11584_i0	PRJEB28589	11692	225	2.674157	6.01685325	Bacteria	2	Bacteria	Bacteria	412	7.97e-111	NTclustered	gi\|857113445\|gb\|CP011220.1\|	730	g11584	i0	100	360.262222222222	223	0	99	0	3	225	1639179	1639401	[Haemophilus] ducreyi strain NZS3 chromosome	blastn	81059	416	0.990384615384615	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	[Haemophilus] ducreyi
15015884	15015884	PRJEB28589_S_NODE_14412_length_193_cov_2.082192_g14304_i0	PRJEB28589	14412	193	2.082192	4.01863056	Neisseriaceae	481	Bacteria	Bacteria	316	5.34e-82	NTclustered	gi\|1403355347\|emb\|LS483369.1\|	483	g14304	i0	100	339.79792746114	171	0	89	0	1	171	1114426	1114596	Neisseria cinerea strain NCTC10294 genome assembly, chromosome: 1	blastn	65581	316	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria cinerea
17565889	17565889	PRJEB28589_S_NODE_15114_length_186_cov_2.079137_g15006_i0	PRJEB28589	15114	186	2.079137	3.86719482	Haemophilus	724	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|1540165144\|emb\|LR134481.1\|	729	g15006	i0	100	99.8709677419355	186	0	100	0	1	186	634991	635176	Haemophilus parainfluenzae strain NCTC10665 genome assembly, chromosome: 1	blastn	18576	344	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
19151523	19151523	PRJEB28589_S_NODE_4296_length_339_cov_5.417808_g4188_i0	PRJEB28589	4296	339	5.417808	18.36636912	Haemophilus parahaemolyticus	735	Bacteria	Bacteria	555	1.9999999999999993e-153	NTclustered	gi\|1986026646\|gb\|CP069510.1\|	735	g4188	i0	96.165	592.115044247788	339	13	100	0	1	339	1267988	1267650	Haemophilus parahaemolyticus strain FDAARGOS_1199 chromosome, complete genome	blastn	200727	555	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parahaemolyticus
19151534	19151534	PRJEB28589_S_NODE_5716_length_312_cov_4.766038_g5608_i0	PRJEB28589	5716	312	4.766038	14.87003856	Aeromonas sp. FDAARGOS 1403	2778052	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2058406134\|gb\|CP077249.1\|	2778052	g5608	i0	100	0.0897435897435897	28	0	9	0	218	245	2850412	2850439	Aeromonas sp. FDAARGOS 1403 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas sp. FDAARGOS 1403
20114533	20114533	PRJEB28589_S_NODE_5736_length_312_cov_4.079245_g5628_i0	PRJEB28589	5736	312	4.079245	12.7272444	Rickettsia	780	Bacteria	Bacteria	529	1.1099999999999996e-145	NTclustered	gi\|2755846470\|emb\|OY974112.1\|	35789	g5628	i0	97.419	11.9230769230769	310	8	99	0	3	312	14374	14065	MAG: Rickettsia helvetica isolate Ir_f12_Rh genome assembly, plasmid: 2	blastn	3720	534	0.99063670411985	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia helvetica
21390204	21390204	PRJEB28589_S_NODE_9577_length_254_cov_2.454106_g9469_i0	PRJEB28589	9577	254	2.454106	6.23342924	Pseudomonas	286	Bacteria	Bacteria	259	1.27e-64	NTclustered	gi\|1086042286\|emb\|LT629795.1\|	122355	g9469	i0	91.534	7.93700787401575	189	14	74	2	64	251	56764	56951	Pseudomonas psychrophila strain BS3667 genome assembly, chromosome: I	blastn	2016	259	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas psychrophila
21702663	21702663	PRJEB28589_S_NODE_10698_length_239_cov_1.510417_g10590_i0	PRJEB28589	10698	239	1.510417	3.60989663	Ehrlichia chaffeensis	945	Bacteria	Bacteria	150	7.41e-32	NTclustered	gi\|612495254\|gb\|CP007475.1\|	1249652	g10590	i0	84.177	13.4351464435146	158	22	65	2	55	209	398191	398348	Ehrlichia chaffeensis str. Jax, complete genome	blastn	3211	150	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Ehrlichia	Ehrlichia chaffeensis
22977927	22977927	PRJEB28589_S_NODE_13819_length_199_cov_4.401316_g13711_i0	PRJEB28589	13819	199	4.401316	8.75861884	Jannaschia sp. W003	2867012	Bacteria	Bacteria	235	1.5999999999999998e-57	NTclustered	gi\|2299591745\|gb\|CP083539.1\|	2867012	g13711	i0	88.265	53.7085427135678	196	23	98	0	4	199	2646785	2646590	Jannaschia sp. W003 chromosome, complete genome	blastn	10688	235	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Jannaschia	Jannaschia sp. W003
22977956	22977956	PRJEB28589_S_NODE_2999_length_369_cov_5.198758_g2891_i0	PRJEB28589	2999	369	5.198758	19.18341702	Paucibacter sediminis	3019553	Bacteria	Bacteria	584	2.7999999999999987e-162	NTclustered	gi\|2517185782\|gb\|CP116346.1\|	3019553	g2891	i0	95.2	285.89701897019	375	8	100	9	1	369	899405	899775	Paucibacter sediminis strain S2-9 chromosome, complete genome	blastn	105496	584	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Paucibacter sediminis
22977975	22977975	PRJEB28589_S_NODE_5039_length_324_cov_4.696751_g4931_i0	PRJEB28589	5039	324	4.696751	15.21747324	Faucicola osloensis	34062	Bacteria	Bacteria	549	8.849999999999997e-152	NTclustered	gi\|1282077041\|gb\|CP024185.2\|	34062	g4931	i0	97.222	15.9938271604938	324	9	100	0	1	324	949557	949234	Moraxella osloensis strain TT16 chromosome, complete genome	blastn	5182	549	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
24251737	24251737	PRJEB28589_S_NODE_10560_length_240_cov_6.854922_g10452_i0	PRJEB28589	10560	240	6.854922	16.4518128	Plesiomonas shigelloides	703	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g10452	i0	100	710.991666666667	240	0	100	0	1	240	336546	336307	Plesiomonas shigelloides strain Colony13 chromosome	blastn	170638	444	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
24251773	24251773	PRJEB28589_S_NODE_16960_length_170_cov_1.658537_g16852_i0	PRJEB28589	16960	170	1.658537	2.8195129	Rickettsia asembonensis	1068590	Bacteria	Bacteria	259	7.8e-65	NTclustered	gi\|2441943819\|gb\|CP116496.1\|	1068590	g16852	i0	100	82.3529411764706	140	0	82	0	31	170	1155435	1155296	MAG: Rickettsia asembonensis isolate Perak chromosome, complete genome	blastn	14000	259	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia asembonensis
26811758	26811758	PRJEB28589_S_NODE_17981_length_163_cov_1.715517_g17873_i0	PRJEB28589	17981	163	1.715517	2.79629271	Pseudomonas aeruginosa	287	Bacteria	Bacteria	45.1	1.2e-4	NR	WP_407594693.1	287	g17873	i0	57.5	0.736196319018405	40	17	73.6	0	163	44	1	40	WP_407594693.1 hypothetical protein [Pseudomonas aeruginosa]	diamond	120	45.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
26938169	26938169	PRJEB28589_S_NODE_8742_length_266_cov_1.876712_g8634_i0	PRJEB28589	8742	266	1.876712	4.99205392	Musicola keenii	2884250	Bacteria	Bacteria	93.6	1.08e-20	NR	WP_192459055.1	2884250	g8634	i0	52	0.845864661654135	75	36	84.6	0	266	42	219	293	WP_192459055.1 jacalin-like lectin [Musicola keenii]	diamond	225	93.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Pectobacteriaceae	Musicola	Musicola keenii
27816675	27816675	PRJEB28589_S_NODE_7024_length_292_cov_8.114286_g6916_i0	PRJEB28589	7024	292	8.114286	23.69371512	Pseudomonadota	1224	Bacteria	Bacteria	147	3.959999999999999e-42	NR	WP_034844511.1	171674	g6916	i0	73.3	19.4178082191781	90	24	92.5	0	270	1	131	220	WP_034844511.1 GNAT family N-acetyltransferase [Inquilinus limosus]	diamond	5670	147	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Rhodospirillaceae	Inquilinus	Inquilinus limosus
27917574	27917574	PRJEB28589_S_NODE_4505_length_335_cov_5.902778_g4397_i0	PRJEB28589	4505	335	5.902778	19.7743063	Dickeya lacustris	2259638	Bacteria	Bacteria	70.9	8.11e-12	NR	WP_125258133.1	2259638	g4397	i0	52.5	1.06567164179104	59	28	52.8	0	11	187	237	295	WP_125258133.1 jacalin-like lectin [Dickeya lacustris]	diamond	357	70.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Pectobacteriaceae	Dickeya	Dickeya lacustris
27980892	27980892	PRJEB28589_S_NODE_4085_length_343_cov_6.459459_g3977_i0	PRJEB28589	4085	343	6.459459	22.15594437	Pseudoalteromonas sp.	53249	Bacteria	Bacteria	60.5	7.02e-8	NR	HCV03032.1	53249	g3977	i0	43.2	0.647230320699708	74	42	64.7	0	343	122	467	540	HCV03032.1 hypothetical protein [Pseudoalteromonas sp.]	diamond	222	60.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Pseudoalteromonadaceae	Pseudoalteromonas	Pseudoalteromonas sp.
28195167	28195167	PRJEB28589_S_NODE_10566_length_240_cov_5.492228_g10458_i0	PRJEB28589	10566	240	5.492228	13.1813472	Luteibacter	242605	Bacteria	Bacteria	79	2.7e-16	NR	WP_167124046.1	637577	g10458	i0	71.4	2.45	49	14	61.3	0	239	93	116	164	WP_167124046.1 lipocalin family protein [Luteibacter jiangsuensis]	diamond	588	79.3	0.996216897856242	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Luteibacter	Luteibacter jiangsuensis
28549373	28549373	PRJEB28589_S_NODE_2727_length_378_cov_8.909366_g2619_i0	PRJEB28589	2727	378	8.909366	33.67740348	unclassified Achromobacter	2626865	Bacteria	Bacteria	116	1.97e-30	NR	WP_088597360.1	2626865	g2619	i0	58.1	3.42063492063492	86	35	68.3	1	375	118	68	152	WP_088597360.1 MULTISPECIES: cupin domain-containing protein [unclassified Achromobacter]	diamond	1293	116	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Achromobacter
28549374	28549374	PRJEB28589_S_NODE_4167_length_342_cov_3.179661_g4059_i0	PRJEB28589	4167	342	3.179661	10.87444062	Escherichia coli	562	Bacteria	Bacteria	110	3.5600000000000003e-29	NR	WP_167399334.1	562	g4059	i0	98.1	0.464912280701754	53	1	46.5	0	342	184	10	62	WP_167399334.1 hypothetical protein, partial [Escherichia coli]	diamond	159	110	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28991524	28991524	PRJEB28589_S_NODE_568_length_644_cov_4.809045_g476_i0	PRJEB28589	568	644	4.809045	30.9702498	Alteriqipengyuania lutimaris	1538146	Bacteria	Bacteria	78.6	7.95e-13	NR	WP_147291040.1	1538146	g476	i0	27.7	1.19254658385093	256	133	95.5	9	16	630	2	256	WP_147291040.1 open beta-sheet domain-containing protein [Alteriqipengyuania lutimaris]	diamond	768	78.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Erythrobacteraceae	Alteriqipengyuania	Alteriqipengyuania lutimaris
29370164	29370164	PRJEB28589_S_NODE_6769_length_296_cov_5.261044_g6661_i0	PRJEB28589	6769	296	5.261044	15.57269024	Spartinivicinus marinus	2994442	Bacteria	Bacteria	77.8	1.36e-14	NR	WP_180567848.1	2994442	g6661	i0	46.1	1.54054054054054	76	40	76	1	293	69	219	294	WP_180567848.1 jacalin-like lectin [Spartinivicinus marinus]	diamond	456	77.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Zooshikellaceae	Spartinivicinus	Spartinivicinus marinus
29496377	29496377	PRJEB28589_S_NODE_15490_length_183_cov_1.323529_g15382_i0	PRJEB28589	15490	183	1.323529	2.42205807	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	91.3	1.37e-19	NR	MBN8446259.1	1913989	g15382	i0	68.9	1	61	19	100	0	1	183	17	77	MBN8446259.1 winged helix-turn-helix domain-containing protein [Gammaproteobacteria bacterium]	diamond	183	91.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
29584326	29584326	PRJEB28589_S_NODE_4710_length_331_cov_5.080986_g4602_i0	PRJEB28589	4710	331	5.080986	16.81806366	root	1	Root_unresolved	Root_unresolved	55.8	9.44e-7	NR	WP_250665605.1	562	g4602	i0	69.4	7.51359516616314	36	11	32.6	0	109	2	32	67	WP_250665605.1 RNA-directed DNA polymerase [Escherichia coli]	diamond	2487	55.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29584329	29584329	PRJEB28589_S_NODE_8510_length_269_cov_3.220721_g8402_i0	PRJEB28589	8510	269	3.220721	8.66373949	root	1	Root_unresolved	Root_unresolved	48.9	4.94e-5	NR	WP_303262480.1	446	g8402	i0	41.3	1.22676579925651	63	36	69.1	1	84	269	14	76	WP_303262480.1 hypothetical protein, partial [Legionella pneumophila]	diamond	330	48.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Legionellaceae	Legionella	Legionella pneumophila
29622230	29622230	PRJEB28589_S_NODE_4250_length_340_cov_5.699659_g4142_i0	PRJEB28589	4250	340	5.699659	19.3788406	Bradyrhizobium japonicum	375	Bacteria	Bacteria	86.7	6.46e-18	NR	WP_259225835.1	375	g4142	i0	60.6	0.582352941176471	66	26	58.2	0	227	30	13	78	WP_259225835.1 type II toxin-antitoxin system PemK/MazF family toxin [Bradyrhizobium japonicum]	diamond	198	86.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium japonicum
29653876	29653876	PRJEB28589_S_NODE_15010_length_187_cov_2.321429_g14902_i0	PRJEB28589	15010	187	2.321429	4.34107223	Brevundimonas sp. G8	1350776	Bacteria	Bacteria	80.1	9.97e-18	NR	WP_159848345.1	1350776	g14902	i0	84.4	0.72192513368984	45	7	72.2	0	2	136	57	101	WP_159848345.1 hypothetical protein [Brevundimonas sp. G8]	diamond	135	80.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	Brevundimonas sp. G8
30854681	30854681	PRJEB28589_S_NODE_17194_length_168_cov_2.057851_g17086_i0	PRJEB28589	17194	168	2.057851	3.45718968	Burkholderiaceae bacterium	2030806	Bacteria	Bacteria	44.7	0.00282	NR	HEU5297290.1	2030806	g17086	i0	51.5	0.589285714285714	33	16	58.9	0	68	166	674	706	HEU5297290.1 DUF2339 domain-containing protein [Burkholderiaceae bacterium]	diamond	99	44.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae		Burkholderiaceae bacterium
30949676	30949676	PRJEB28589_S_NODE_6774_length_296_cov_4.590361_g6666_i0	PRJEB28589	6774	296	4.590361	13.58746856	Klebsiella pneumoniae	573	Bacteria	Bacteria	46.6	3.7e-4	NR	MCP6242699.1	573	g6666	i0	60	0.405405405405405	40	16	40.5	0	170	51	10	49	MCP6242699.1 hypothetical protein [Klebsiella pneumoniae]	diamond	120	46.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
31297142	31297142	PRJEB28589_S_NODE_4675_length_332_cov_2.550877_g4567_i0	PRJEB28589	4675	332	2.550877	8.46891164	Rickettsia endosymbiont of Glossina mortisans submortisans	2878925	Bacteria	Bacteria	48.1	0.00131	NR	MCC8418596.1	2878925	g4567	i0	27.5	0.822289156626506	91	59	82.2	1	315	43	182	265	MCC8418596.1 hypothetical protein [Rickettsia endosymbiont of Glossina mortisans submortisans]	diamond	273	48.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Rickettsia	Rickettsia endosymbiont of Glossina mortisans submortisans
31392242	31392242	PRJEB28589_S_NODE_7716_length_282_cov_1.961702_g7608_i0	PRJEB28589	7716	282	1.961702	5.53199964	Pseudomonas sp. PS	306	Bacteria	Bacteria	169	2.0899999999999999e-47	NR	WP_282358805.1	2991439	g7608	i0	98.8	0.914893617021277	86	1	91.5	0	3	260	195	280	WP_282358805.1 hypothetical protein [Pseudomonas sp. PS01303]	diamond	258	169	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. PS01303
31739816	31739816	PRJEB28589_S_NODE_10877_length_236_cov_3.021164_g10769_i0	PRJEB28589	10877	236	3.021164	7.12994704	Rheinheimera sp.	1869214	Bacteria	Bacteria	112	2.6e-27	NR	MDZ7902260.1	1869214	g10769	i0	71.8	1.98305084745763	78	22	99.2	0	236	3	202	279	MDZ7902260.1 response regulator [Rheinheimera sp.]	diamond	468	112	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp.
31803102	31803102	PRJEB28589_S_NODE_4837_length_328_cov_6.843416_g4729_i0	PRJEB28589	4837	328	6.843416	22.446404480000002	Methylococcales bacterium	2304002	Bacteria	Bacteria	88.6	5.08e-20	NR	MEE9412403.1	2304002	g4729	i0	58.1	1.35365853658537	74	31	67.7	0	326	105	48	121	MEE9412403.1 type II toxin-antitoxin system RelE/ParE family toxin [Methylococcales bacterium]	diamond	444	88.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Methylococcales			Methylococcales bacterium
31834691	31834691	PRJEB28589_S_NODE_8857_length_264_cov_4.271889_g8749_i0	PRJEB28589	8857	264	4.271889	11.27778696	Acinetobacter haemolyticus	29430	Bacteria	Bacteria	42.4	0.0111	NR	ATZ65962.1	29430	g8749	i0	38.6	0.647727272727273	57	32	61.4	1	100	261	7	63	ATZ65962.1 hypothetical protein BSR56_00385 [Acinetobacter haemolyticus]	diamond	171	42.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter haemolyticus
31923247	31923247	PRJEB28589_S_NODE_2717_length_379_cov_2.117470_g2609_i0	PRJEB28589	2717	379	2.11747	8.0252113	root	1	Root_unresolved	Root_unresolved	82.4	2.44e-15	NR	WP_225247223.1	953	g2609	i0	40.2	5.53298153034301	107	57	82.3	3	379	68	466	568	WP_225247223.1 MULTISPECIES: tetratricopeptide repeat protein [Wolbachia]	diamond	2097	82.8	0.995169082125604	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Wolbachia
32024758	32024758	PRJEB28589_S_NODE_5438_length_317_cov_4.011111_g5330_i0	PRJEB28589	5438	317	4.011111	12.71522187	unclassified Wolbachia	2640676	Bacteria	Bacteria	70.1	2.19e-11	NR	WP_153295690.1	2640676	g5330	i0	45.2	0.8801261829653	93	46	84.2	2	271	5	319	410	WP_153295690.1 MULTISPECIES: ankyrin repeat domain-containing protein [unclassified Wolbachia]	diamond	279	70.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Wolbachia
32081409	32081409	PRJEB28589_S_NODE_1498_length_455_cov_4.975490_g1391_i0	PRJEB28589	1498	455	4.97549	22.6384795	Massilia	149698	Bacteria	Bacteria	166	1.23e-46	NR	WP_036169810.1	1500894	g1391	i0	64.8	8.85494505494506	122	42	79.8	1	455	93	298	419	WP_036169810.1 glucan 1,4-alpha-maltotetraohydrolase domain-containing protein [Massilia sp. 9096]	diamond	4029	167	0.994011976047904	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. 9096
32246530	32246530	PRJEB28589_S_NODE_1978_length_414_cov_6.574932_g1870_i0	PRJEB28589	1978	414	6.5749320000000004	27.22021848	Stellaceae bacterium	2910174	Bacteria	Bacteria	102	6.34e-24	NR	HTQ33271.1	2910174	g1870	i0	62.2	2.70289855072464	74	28	53.6	0	403	182	162	235	HTQ33271.1 GNAT family protein [Stellaceae bacterium]	diamond	1119	102	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Stellaceae		Stellaceae 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);;