metadata: contig_metadata: 53 rows where analysis = "diamond", bioproject = "PRJNA1145276" and tax

53 rows where analysis = "diamond", bioproject = "PRJNA1145276" 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	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
10492062	10492062	PRJNA1145276_P_NODE_19509_length_241_cov_0.916667_g19452_i0	PRJNA1145276	19509	241	0.916667	2.20916747	Sphingobium sp. AS12	2849495	Bacteria	Bacteria	67.8	5.17e-11	NR	WP_254798751.1	2849495	g19452	i0	69.8	0.535269709543568	43	13	53.5	66	194	292	334	WP_254798751.1 endonuclease/exonuclease/phosphatase family protein [Sphingobium sp. AS12]	diamond	129	67.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingobium	Sphingobium sp. AS12
26627375	26627375	PRJNA1145276_P_NODE_18701_length_243_cov_0.905882_g18644_i0	PRJNA1145276	18701	243	0.905882	2.20129326	Escherichia coli	562	Bacteria	Bacteria	41.2	0.0162	NR	MDW4608164.1	562	g18644	i0	52.6	0.469135802469136	38	18	46.9	214	101	19	56	MDW4608164.1 hypothetical protein [Escherichia coli]	diamond	114	41.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
26658791	26658791	PRJNA1145276_P_NODE_18741_length_243_cov_0.905882_g18684_i0	PRJNA1145276	18741	243	0.905882	2.20129326	Escherichia coli	562	Bacteria	Bacteria	47.8	4.25e-5	NR	RJK33917.1	562	g18684	i0	65.6	1.17283950617284	32	11	39.5	92	187	29	60	RJK33917.1 hypothetical protein CMV54_26000 [Escherichia coli]	diamond	285	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27038884	27038884	PRJNA1145276_P_NODE_9222_length_335_cov_1.469466_g9165_i0	PRJNA1145276	9222	335	1.469466	4.9227111	Escherichia coli	562	Bacteria	Bacteria	63.9	3.91e-9	NR	WP_265935246.1	562	g9165	i0	50.9	7.38805970149254	55	27	49.3	249	85	217	271	WP_265935246.1 host specificity protein J, partial [Escherichia coli]	diamond	2475	63.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27070515	27070515	PRJNA1145276_P_NODE_12542_length_287_cov_1.341121_g12485_i0	PRJNA1145276	12542	287	1.341121	3.84901727	Escherichia coli	562	Bacteria	Bacteria	64.3	1.59e-9	NR	WP_172945367.1	562	g12485	i0	42.7	116.811846689895	75	43	78.4	286	62	224	298	WP_172945367.1 host specificity protein J, partial [Escherichia coli]	diamond	33525	64.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27091128	27091128	PRJNA1145276_P_NODE_3682_length_509_cov_1.149083_g3625_i0	PRJNA1145276	3682	509	1.149083	5.84883247	root	1	Root_unresolved	Root_unresolved	124	8.9099999999999993e-33	NR	MCV5426276.1	562	g3625	i0	57.9	6.68369351669941	126	53	74.3	56	433	17	142	MCV5426276.1 helix-turn-helix domain-containing protein [Escherichia coli]	diamond	3402	125	0.992	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27122355	27122355	PRJNA1145276_P_NODE_17482_length_246_cov_1.323699_g17425_i0	PRJNA1145276	17482	246	1.323699	3.25629954	Bacteria	2	Bacteria	Bacteria	162	1.59e-45	NR	WP_171921453.1	562	g17425	i0	98.8	6	82	1	100	246	1	249	330	WP_171921453.1 DNA ligase [Escherichia coli]	diamond	1476	163	0.993865030674847	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27153858	27153858	PRJNA1145276_P_NODE_14262_length_267_cov_2.056701_g14205_i0	PRJNA1145276	14262	267	2.056701	5.49139167	FCB group	1783270	Bacteria	Bacteria	80.1	4.92e-17	NR	MBP3075880.1	470	g14205	i0	56.9	15.3370786516854	72	31	80.9	216	1	36	107	MBP3075880.1 hypothetical protein [Acinetobacter baumannii]	diamond	4095	80.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
27323469	27323469	PRJNA1145276_P_NODE_15303_length_255_cov_1.269231_g15246_i0	PRJNA1145276	15303	255	1.269231	3.23653905	Stutzerimonas stutzeri	316	Bacteria	Bacteria	58.9	3.58e-9	NR	WP_219853451.1	316	g15246	i0	54.7	0.623529411764706	53	24	62.4	203	45	30	82	WP_219853451.1 hypothetical protein, partial [Stutzerimonas stutzeri]	diamond	159	58.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Stutzerimonas	Stutzerimonas stutzeri
27438986	27438986	PRJNA1145276_P_NODE_14843_length_261_cov_1.031915_g14786_i0	PRJNA1145276	14843	261	1.031915	2.69329815	Escherichia	561	Bacteria	Bacteria	53.9	5.31e-6	NR	HAX2052223.1	562	g14786	i0	40	1.98850574712644	60	36	69	181	2	289	348	HAX2052223.1 phage portal protein [Escherichia coli]	diamond	519	53.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27639409	27639409	PRJNA1145276_P_NODE_18664_length_243_cov_0.905882_g18607_i0	PRJNA1145276	18664	243	0.905882	2.20129326	Escherichia coli	562	Bacteria	Bacteria	50.1	6.67e-6	NR	WP_410242068.1	562	g18607	i0	54.5	0.54320987654321	44	20	54.3	222	91	9	52	WP_410242068.1 hypothetical protein [Escherichia coli]	diamond	132	50.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
27702690	27702690	PRJNA1145276_P_NODE_824_length_1017_cov_4.738347_g785_i0	PRJNA1145276	824	1017	4.738347	48.18898899	Yersinia pestis	632	Bacteria	Bacteria	65.9	1.65e-9	NR	MDL1223685.1	632	g785	i0	53	0.389380530973451	66	31	19.5	192	389	30	95	MDL1223685.1 hypothetical protein [Yersinia pestis]	diamond	396	65.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Yersinia	Yersinia pestis
28238924	28238924	PRJNA1145276_P_NODE_2366_length_628_cov_1.248649_g2310_i0	PRJNA1145276	2366	628	1.248649	7.84151572	Escherichia coli	562	Bacteria	Bacteria	133	7.42e-32	NR	EFC6890875.1	562	g2310	i0	56.1	65.8949044585987	155	68	74	134	598	886	1040	EFC6890875.1 host specificity protein J [Escherichia coli]	diamond	41382	133	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28270504	28270504	PRJNA1145276_P_NODE_12186_length_291_cov_1.197248_g12129_i0	PRJNA1145276	12186	291	1.197248	3.48399168	Escherichia coli DEC5E	868159	Bacteria	Bacteria	88.6	7.670000000000001e-21	NR	EHV50479.1	868159	g12129	i0	64.6	0.670103092783505	65	23	67	250	56	3	67	EHV50479.1 hypothetical protein ECDEC5E_0458 [Escherichia coli DEC5E]	diamond	195	88.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28460341	28460341	PRJNA1145276_P_NODE_18246_length_244_cov_1.350877_g18189_i0	PRJNA1145276	18246	244	1.350877	3.29613988	Escherichia coli	562	Bacteria	Bacteria	58.5	1.06e-8	NR	WP_160516105.1	562	g18189	i0	59.6	0.700819672131147	57	23	70.1	34	204	34	90	WP_160516105.1 tyrosine-type recombinase/integrase, partial [Escherichia coli]	diamond	171	58.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28681339	28681339	PRJNA1145276_P_NODE_13627_length_274_cov_2.298507_g13570_i0	PRJNA1145276	13627	274	2.298507	6.29790918	Escherichia coli	562	Bacteria	Bacteria	58.9	6.72e-9	NR	STE86717.1	562	g13570	i0	63.9	0.394160583941606	36	13	39.4	267	160	1	36	STE86717.1 Prophage tail fiber domain protein [Escherichia coli]	diamond	108	58.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28681340	28681340	PRJNA1145276_P_NODE_18807_length_243_cov_0.905882_g18750_i0	PRJNA1145276	18807	243	0.905882	2.20129326	Escherichia coli	562	Bacteria	Bacteria	53.5	5.03e-6	NR	GCL11899.1	562	g18750	i0	56.6	8.19753086419753	53	23	65.4	83	241	68	120	GCL11899.1 hypothetical protein BvCmsD61A_04662 [Escherichia coli]	diamond	1992	53.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28681341	28681341	PRJNA1145276_P_NODE_3347_length_532_cov_1.028322_g3290_i0	PRJNA1145276	3347	532	1.028322	5.47067304	Escherichia coli	562	Bacteria	Bacteria	57.8	2.26e-6	NR	WP_373891178.1	562	g3290	i0	60.5	0.857142857142857	76	30	42.9	504	277	163	238	WP_373891178.1 phage tail protein, partial [Escherichia coli]	diamond	456	57.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28712811	28712811	PRJNA1145276_P_NODE_13647_length_274_cov_1.532338_g13590_i0	PRJNA1145276	13647	274	1.532338	4.19860612	Candidatus Thiodiazotropha endolucinida	1655433	Bacteria	Bacteria	113	2.88e-27	NR	ODJ85636.1	1655433	g13590	i0	61.1	0.985401459854015	90	35	98.5	5	274	23	112	ODJ85636.1 putative signal peptide peptidase SppA [Candidatus Thiodiazotropha endolucinida]	diamond	270	113	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Sedimenticolaceae	Candidatus Thiodiazotropha	Candidatus Thiodiazotropha endolucinida
28775812	28775812	PRJNA1145276_P_NODE_6967_length_381_cov_1.256494_g6910_i0	PRJNA1145276	6967	381	1.256494	4.78724214	Salmonella enterica subsp. enterica serovar Dessau	2564349	Bacteria	Bacteria	47.4	2.31e-4	NR	QUS47091.1	2564349	g6910	i0	64.7	0.267716535433071	34	12	26.8	133	32	2	35	QUS47091.1 hypothetical protein F1331_25955 [Salmonella enterica subsp. enterica serovar Dessau]	diamond	102	47.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
28827784	28827784	PRJNA1145276_P_NODE_14248_length_268_cov_1.020513_g14191_i0	PRJNA1145276	14248	268	1.020513	2.73497484	root	1	Root_unresolved	Root_unresolved	46.6	5.87e-4	NR	NBZ12677.1	573	g14191	i0	50	1.08582089552239	46	23	51.5	139	2	17	62	NBZ12677.1 hypothetical protein [Klebsiella pneumoniae]	diamond	291	46.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
28859421	28859421	PRJNA1145276_P_NODE_3808_length_501_cov_1.221963_g3751_i0	PRJNA1145276	3808	501	1.221963	6.12203463	Escherichia	561	Bacteria	Bacteria	77.4	6.41e-15	NR	WP_187640792.1	562	g3751	i0	52.5	20.1137724550898	59	28	35.3	24	200	59	117	WP_187640792.1 phage tail protein, partial [Escherichia coli]	diamond	10077	77.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28890936	28890936	PRJNA1145276_P_NODE_8468_length_349_cov_1.394928_g8411_i0	PRJNA1145276	8468	349	1.394928	4.86829872	Pseudomonadati	3379134	Bacteria	Bacteria	75.5	1.59e-13	NR	HAW0597555.1	562	g8411	i0	77.8	3.48137535816619	45	10	38.7	69	203	21	65	HAW0597555.1 serine/threonine protein phosphatase [Escherichia coli]	diamond	1215	75.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29028773	29028773	PRJNA1145276_P_NODE_10928_length_308_cov_1.625532_g10871_i0	PRJNA1145276	10928	308	1.625532	5.00663856	Escherichia coli	562	Bacteria	Bacteria	70.1	1.9e-11	NR	SQM55563.1	562	g10871	i0	43.8	0.711038961038961	73	41	71.1	270	52	387	459	SQM55563.1 phage portal protein (minor capsid protein) [Escherichia coli]	diamond	219	70.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29123493	29123493	PRJNA1145276_P_NODE_16409_length_249_cov_1.125000_g16352_i0	PRJNA1145276	16409	249	1.125	2.80125	Escherichia coli	562	Bacteria	Bacteria	87.4	3.05e-19	NR	KZO73721.1	562	g16352	i0	50.6	4.75903614457831	79	39	95.2	248	12	82	160	KZO73721.1 hypothetical protein TH56_22795 [Escherichia coli]	diamond	1185	87.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29143995	29143995	PRJNA1145276_P_NODE_9549_length_330_cov_1.198444_g9492_i0	PRJNA1145276	9549	330	1.198444	3.9548652	Gammaproteobacteria	1236	Bacteria	Bacteria	89	4.41e-20	NR	WP_248081466.1	550	g9492	i0	51.2	32.8636363636364	82	40	74.5	327	82	47	128	WP_248081466.1 terminase small subunit, partial [Enterobacter cloacae]	diamond	10845	89.4	0.995525727069351	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter cloacae
29344312	29344312	PRJNA1145276_P_NODE_3969_length_491_cov_1.387560_g3912_i0	PRJNA1145276	3969	491	1.38756	6.8129196	Escherichia coli	562	Bacteria	Bacteria	120	1.09e-29	NR	GDB63797.1	562	g3912	i0	52.7	1.36863543788187	112	53	68.4	340	5	1	112	GDB63797.1 hypothetical protein HmCmsJML188_04337 [Escherichia coli]	diamond	672	120	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29565187	29565187	PRJNA1145276_P_NODE_16370_length_249_cov_1.312500_g16313_i0	PRJNA1145276	16370	249	1.3125	3.268125	Escherichia coli	562	Bacteria	Bacteria	117	8.089999999999999e-32	NR	VCY73363.1	562	g16313	i0	68.3	9.87951807228916	82	26	98.8	2	247	7	88	VCY73363.1 hypothetical protein BANRA_03998 [Escherichia coli]	diamond	2460	117	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29596452	29596452	PRJNA1145276_P_NODE_13630_length_274_cov_2.169154_g13573_i0	PRJNA1145276	13630	274	2.169154	5.94348196	Escherichia coli OK1357	670905	Bacteria	Bacteria	86.3	8.21e-20	NR	EFZ71056.1	670905	g13573	i0	65	0.656934306569343	60	21	65.7	267	88	12	71	EFZ71056.1 hypothetical protein ECOK1357_1059 [Escherichia coli OK1357]	diamond	180	86.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29743360	29743360	PRJNA1145276_P_NODE_6450_length_394_cov_1.258567_g6393_i0	PRJNA1145276	6450	394	1.258567	4.95875398	Bacteria	2	Bacteria	Bacteria	127	1.58e-34	NR	HGU0922076.1	562	g6393	i0	61.8	5.98477157360406	131	50	99.7	2	394	9	139	HGU0922076.1 protein rexA [Escherichia coli]	diamond	2358	127	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
29754527	29754527	PRJNA1145276_P_NODE_3991_length_490_cov_0.803357_g3934_i0	PRJNA1145276	3991	490	0.803357	3.9364493	Enterobacter hormaechei	158836	Bacteria	Bacteria	103	9.42e-26	NR	WP_251276324.1	158836	g3934	i0	69	0.43469387755102	71	22	43.5	476	264	1	71	WP_251276324.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	213	103	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
29912767	29912767	PRJNA1145276_P_NODE_9771_length_326_cov_1.470356_g9714_i0	PRJNA1145276	9771	326	1.470356	4.79336056	Pseudomonas capeferrum	1495066	Bacteria	Bacteria	56.2	1.21e-6	NR	WP_339471085.1	1495066	g9714	i0	73.2	1.1319018404908	41	11	37.7	203	325	132	172	WP_339471085.1 reverse transcriptase family protein, partial [Pseudomonas capeferrum]	diamond	369	56.6	0.992932862190813	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas capeferrum
29975773	29975773	PRJNA1145276_P_NODE_13031_length_281_cov_1.591346_g12974_i0	PRJNA1145276	13031	281	1.591346	4.47168226	Escherichia coli	562	Bacteria	Bacteria	54.7	3.04e-7	NR	WP_214703757.1	562	g12974	i0	42.6	0.725978647686833	68	39	72.6	46	249	3	70	WP_214703757.1 hypothetical protein, partial [Escherichia coli]	diamond	204	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30007539	30007539	PRJNA1145276_P_NODE_7651_length_366_cov_1.245734_g7594_i0	PRJNA1145276	7651	366	1.245734	4.55938644	Escherichia coli FDA5	562	Bacteria	Bacteria	52.8	1.24e-5	NR	EKH24674.1	1005470	g7594	i0	45.8	0.483606557377049	59	32	48.4	333	157	1	59	EKH24674.1 hypothetical protein ECFDA504_3205, partial [Escherichia coli FDA504]	diamond	177	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30038921	30038921	PRJNA1145276_P_NODE_3971_length_491_cov_1.330144_g3914_i0	PRJNA1145276	3971	491	1.330144	6.53100704	Escherichia coli	562	Bacteria	Bacteria	83.2	2.64e-17	NR	WP_119918988.1	562	g3914	i0	60.3	3.46435845213849	63	25	38.5	468	280	19	81	WP_119918988.1 antitermination protein N [Escherichia coli]	diamond	1701	83.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30070447	30070447	PRJNA1145276_P_NODE_14472_length_265_cov_1.203125_g14415_i0	PRJNA1145276	14472	265	1.203125	3.18828125	Escherichia coli	562	Bacteria	Bacteria	70.5	6.32e-13	NR	WP_143403160.1	562	g14415	i0	49.3	167.62641509434	67	34	75.8	253	53	57	123	WP_143403160.1 NlpC/P60 family protein, partial [Escherichia coli]	diamond	44421	70.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30196763	30196763	PRJNA1145276_P_NODE_11252_length_304_cov_0.822511_g11195_i0	PRJNA1145276	11252	304	0.822511	2.50043344	Stutzerimonas stutzeri	316	Bacteria	Bacteria	45.4	0.00113	NR	WP_219853451.1	316	g11195	i0	53.7	0.404605263157895	41	19	40.5	182	60	36	76	WP_219853451.1 hypothetical protein, partial [Stutzerimonas stutzeri]	diamond	123	45.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Stutzerimonas	Stutzerimonas stutzeri
30228452	30228452	PRJNA1145276_P_NODE_3972_length_491_cov_1.289474_g3915_i0	PRJNA1145276	3972	491	1.289474	6.33131734	Escherichia coli	562	Bacteria	Bacteria	60.1	5.34e-9	NR	WP_197569370.1	562	g3915	i0	73.2	0.25050916496945	41	11	25.1	6	128	7	47	WP_197569370.1 phage holin family protein, partial [Escherichia coli]	diamond	123	60.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30355426	30355426	PRJNA1145276_P_NODE_14432_length_265_cov_1.713542_g14375_i0	PRJNA1145276	14432	265	1.713542	4.5408863	Escherichia coli	562	Bacteria	Bacteria	83.2	1.01e-17	NR	WP_024179172.1	562	g14375	i0	50.7	2.43396226415094	73	36	82.6	224	6	52	124	WP_024179172.1 phage minor tail protein L, partial [Escherichia coli]	diamond	645	83.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30355429	30355429	PRJNA1145276_P_NODE_19252_length_242_cov_0.911243_g19195_i0	PRJNA1145276	19252	242	0.911243	2.20520806	Escherichia coli	562	Bacteria	Bacteria	89	9.8e-20	NR	SQP56330.1	562	g19195	i0	52.6	1.8099173553719	76	36	94.2	242	15	93	168	SQP56330.1 Superoxide dismutase [Escherichia coli]	diamond	438	89	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30375853	30375853	PRJNA1145276_P_NODE_16772_length_248_cov_0.880000_g16715_i0	PRJNA1145276	16772	248	0.88	2.1824	root	1	Root_unresolved	Root_unresolved	59.7	6.83e-10	NR	WP_249821447.1	562	g16715	i0	52.1	16.633064516129	48	23	58.1	165	22	2	49	WP_249821447.1 excisionase, partial [Escherichia coli]	diamond	4125	59.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30564658	30564658	PRJNA1145276_P_NODE_1833_length_705_cov_1.569620_g1780_i0	PRJNA1145276	1833	705	1.56962	11.065821	root	1	Root_unresolved	Root_unresolved	105	5.53e-25	NR	WP_159182371.1	562	g1780	i0	56.7	5.08510638297872	97	42	41.3	302	12	3	99	WP_159182371.1 glycoside hydrolase family 104 protein, partial [Escherichia coli]	diamond	3585	105	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30607538	30607538	PRJNA1145276_P_NODE_4613_length_458_cov_1.200000_g4556_i0	PRJNA1145276	4613	458	1.2	5.496	Escherichia coli	562	Bacteria	Bacteria	63.9	8.65e-10	NR	EEW1880186.1	562	g4556	i0	33.3	0.707423580786026	108	72	70.7	73	396	1	108	EEW1880186.1 hypothetical protein [Escherichia coli]	diamond	324	63.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30734028	30734028	PRJNA1145276_P_NODE_18294_length_244_cov_0.959064_g18237_i0	PRJNA1145276	18294	244	0.959064	2.34011616	Enterobacter hormaechei	158836	Bacteria	Bacteria	74.7	1.3e-15	NR	WP_251276324.1	158836	g18237	i0	58.1	0.762295081967213	62	26	76.2	2	187	10	71	WP_251276324.1 hypothetical protein, partial [Enterobacter hormaechei]	diamond	186	74.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
30828810	30828810	PRJNA1145276_P_NODE_11754_length_297_cov_0.982143_g11697_i0	PRJNA1145276	11754	297	0.982143	2.91696471	Escherichia coli	562	Bacteria	Bacteria	56.2	9.21e-8	NR	MCA7454802.1	562	g11697	i0	51	7.42424242424242	49	24	49.5	160	14	1	49	MCA7454802.1 YqaJ viral recombinase family protein [Escherichia coli]	diamond	2205	56.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30923869	30923869	PRJNA1145276_P_NODE_15014_length_258_cov_1.664865_g14957_i0	PRJNA1145276	15014	258	1.664865	4.2953517	Escherichia coli	562	Bacteria	Bacteria	99.4	5.45e-22	NR	WP_404855513.1	562	g14957	i0	65.7	0.779069767441861	67	23	77.9	203	3	555	621	WP_404855513.1 terminase gpA endonuclease subunit [Escherichia coli]	diamond	201	99.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31302848	31302848	PRJNA1145276_P_NODE_4575_length_459_cov_1.466321_g4518_i0	PRJNA1145276	4575	459	1.466321	6.73041339	Pseudocitrobacter faecalis	1398493	Bacteria	Bacteria	92.4	5.8e-20	NR	WP_407732263.1	1398493	g4518	i0	39.1	3.34640522875817	128	78	83.7	456	73	8	135	WP_407732263.1 antitermination protein [Pseudocitrobacter faecalis]	diamond	1536	92.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Pseudocitrobacter	Pseudocitrobacter faecalis
31777275	31777275	PRJNA1145276_P_NODE_17057_length_247_cov_1.764368_g17000_i0	PRJNA1145276	17057	247	1.764368	4.35798896	Shigella sonnei	624	Bacteria	Bacteria	75.9	8.88e-16	NR	EFY1197791.1	624	g17000	i0	61.7	3.64372469635628	60	23	72.9	244	65	36	95	EFY1197791.1 hypothetical protein [Shigella sonnei]	diamond	900	75.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella sonnei
31955911	31955911	PRJNA1145276_P_NODE_12037_length_293_cov_1.050000_g11980_i0	PRJNA1145276	12037	293	1.05	3.0765	Escherichia	561	Bacteria	Bacteria	48.9	2.74e-5	NR	WP_213060497.1	562	g11980	i0	47.7	0.901023890784983	44	23	45.1	151	20	20	63	WP_213060497.1 hypothetical protein, partial [Escherichia coli]	diamond	264	48.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32177676	32177676	PRJNA1145276_P_NODE_2718_length_589_cov_1.864341_g2662_i0	PRJNA1145276	2718	589	1.864341	10.98096849	Bacteria	2	Bacteria	Bacteria	107	4.06e-25	NR	WP_250271761.1	562	g2662	i0	49.5	339.74363327674	103	52	52.5	350	42	66	168	WP_250271761.1 phage terminase large subunit family protein, partial [Escherichia coli]	diamond	200109	107	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32410200	32410200	PRJNA1145276_P_NODE_15139_length_257_cov_1.255435_g15082_i0	PRJNA1145276	15139	257	1.255435	3.22646795	Pseudomonas aeruginosa	287	Bacteria	Bacteria	53.9	1.81e-7	NR	WP_335929172.1	287	g15082	i0	50	0.583657587548638	50	25	58.4	151	2	2	51	WP_335929172.1 hypothetical protein, partial [Pseudomonas aeruginosa]	diamond	150	53.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
32462413	32462413	PRJNA1145276_P_NODE_9639_length_328_cov_1.811765_g9582_i0	PRJNA1145276	9639	328	1.811765	5.9425892	root	1	Root_unresolved	Root_unresolved	77.8	2.74e-16	NR	WP_345786791.1	470	g9582	i0	69	7.42682926829268	58	18	53	92	265	14	71	WP_345786791.1 super-infection exclusion protein B, partial [Acinetobacter baumannii]	diamond	2436	77.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
32662564	32662564	PRJNA1145276_P_NODE_15120_length_257_cov_1.271739_g15063_i0	PRJNA1145276	15120	257	1.271739	3.26836923	Escherichia sp. MOD1-EC2449	2093859	Bacteria	Bacteria	61.6	6.92e-10	NR	WP_105268838.1	2093859	g15063	i0	35.6	0.852140077821012	73	47	85.2	253	35	45	117	WP_105268838.1 phage tail assembly protein T [Escherichia sp. MOD1-EC2449]	diamond	219	61.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia sp. MOD1-EC2449

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