metadata: contig_metadata: 48 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax

48 rows where analysis = "diamond", bioproject = "PRJNA602115" 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
575840	575840	PRJNA602115_P_NODE_9361_length_208_cov_0.870748_g9336_i0	PRJNA602115	9361	208	0.870748	1.81115584	Nevskiaceae	568386	Bacteria	Bacteria	89.7	6.14e-19	NR	WP_072895824.1	490188	g9336	i0	89.8	4.94711538461539	49	5	70.7	0	206	60	489	537	WP_072895824.1 NAD+ synthase [Hydrocarboniphaga daqingensis]	diamond	1029	90.1	0.995560488346282	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Nevskiales	Nevskiaceae	Hydrocarboniphaga	Hydrocarboniphaga daqingensis
1142866	1142866	PRJNA602115_P_NODE_10641_length_204_cov_0.895105_g10616_i0	PRJNA602115	10641	204	0.895105	1.8260142	Perlucidibaca sp.	2020467	Bacteria	Bacteria	118	6.26e-29	NR	MEL0028347.1	2020467	g10616	i0	85.3	1	68	10	100	0	1	204	420	487	MEL0028347.1 polysaccharide biosynthesis tyrosine autokinase [Perlucidibaca sp.]	diamond	204	118	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Perlucidibacaceae	Perlucidibaca	Perlucidibaca sp.
4970992	4970992	PRJNA602115_P_NODE_4104_length_306_cov_0.938776_g4079_i0	PRJNA602115	4104	306	0.938776	2.87265456	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	187	4.69e-56	NR	MCX7069928.1	1913989	g4079	i0	100	1	102	0	100	0	1	306	2	103	MCX7069928.1 GGDEF domain-containing protein [Gammaproteobacteria bacterium]	diamond	306	187	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
8228830	8228830	PRJNA602115_P_NODE_11667_length_201_cov_0.914286_g11642_i0	PRJNA602115	11667	201	0.914286	1.83771486	Limnobacter sp.	2003368	Bacteria	Bacteria	110	1.4999999999999996e-29	NR	WP_409711231.1	2003368	g11642	i0	98.2	0.82089552238806	55	1	82.1	0	201	37	35	89	WP_409711231.1 integration host factor subunit beta [Limnobacter sp.]	diamond	165	110	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
10780070	10780070	PRJNA602115_P_NODE_6189_length_256_cov_0.984615_g6164_i0	PRJNA602115	6189	256	0.984615	2.5206144	Limnobacter	131079	Bacteria	Bacteria	163	4e-48	NR	WP_256763029.1	131079	g6164	i0	97.6	2.96484375	84	2	98.4	0	2	253	5	88	WP_256763029.1 MULTISPECIES: 30S ribosomal protein S3 [Limnobacter]	diamond	759	163	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter
15878456	15878456	PRJNA602115_P_NODE_10453_length_205_cov_0.888889_g10428_i0	PRJNA602115	10453	205	0.888889	1.82222245	Lysobacteraceae bacterium	1926873	Bacteria	Bacteria	104	5.73e-25	NR	MBA4286778.1	1926873	g10428	i0	86.7	0.878048780487805	60	8	87.8	0	193	14	6	65	MBA4286778.1 aspartate-semialdehyde dehydrogenase [Lysobacteraceae bacterium]	diamond	180	104	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae		Lysobacteraceae bacterium
15878705	15878705	PRJNA602115_P_NODE_9253_length_208_cov_0.870748_g9228_i0	PRJNA602115	9253	208	0.870748	1.81115584	Limnobacter sp.	2003368	Bacteria	Bacteria	128	5.669999999999999e-34	NR	WP_409705534.1	2003368	g9228	i0	98.5	0.980769230769231	68	1	98.1	0	3	206	186	253	WP_409705534.1 2-dehydropantoate 2-reductase [Limnobacter sp.]	diamond	204	128	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
17153397	17153397	PRJNA602115_P_NODE_3094_length_345_cov_0.778169_g3069_i0	PRJNA602115	3094	345	0.778169	2.68468305	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	196	3.8699999999999998e-62	NR	MDI9336466.1	1913989	g3069	i0	96.9	0.843478260869565	97	3	84.3	0	345	55	42	138	MDI9336466.1 hypothetical protein [Gammaproteobacteria bacterium]	diamond	291	196	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
26636699	26636699	PRJNA602115_P_NODE_9961_length_206_cov_0.882759_g9936_i0	PRJNA602115	9961	206	0.882759	1.81848354	Limnobacter sp.	2003368	Bacteria	Bacteria	110	3.4300000000000005e-27	NR	WP_305566316.1	2003368	g9936	i0	85.3	0.990291262135922	68	10	99	0	1	204	238	305	WP_305566316.1 acetyl-CoA carboxylase carboxyltransferase subunit alpha [Limnobacter sp.]	diamond	204	110	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
26649866	26649866	PRJNA602115_P_NODE_9741_length_207_cov_0.876712_g9716_i0	PRJNA602115	9741	207	0.876712	1.81479384	Hydrogenophaga	47420	Bacteria	Bacteria	112	2.45e-28	NR	MES3009939.1	1977087	g9716	i0	82.1	3.88405797101449	67	12	97.1	0	5	205	58	124	MES3009939.1 TatD family hydrolase [Pseudomonadota bacterium]	diamond	804	112	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27237921	27237921	PRJNA602115_P_NODE_8423_length_215_cov_1.006494_g8398_i0	PRJNA602115	8423	215	1.006494	2.1639621	Burkholderia sp. Tr-862	2608331	Bacteria	Bacteria	40.4	0.0431	NR	NIF42936.1	2608331	g8398	i0	37.5	0.781395348837209	56	31	72.6	2	3	158	3	58	NIF42936.1 hypothetical protein [Burkholderia sp. Tr-862]	diamond	168	40.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia sp. Tr-862
27301271	27301271	PRJNA602115_P_NODE_7783_length_226_cov_1.157576_g7758_i0	PRJNA602115	7783	226	1.157576	2.61612176	Limnobacter sp.	2003368	Bacteria	Bacteria	125	2.97e-33	NR	WP_409709411.1	2003368	g7758	i0	93.9	0.876106194690266	66	4	87.6	0	225	28	1	66	WP_409709411.1 UDP-3-O-acyl-N-acetylglucosamine deacetylase [Limnobacter sp.]	diamond	198	125	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
27522229	27522229	PRJNA602115_P_NODE_8963_length_209_cov_0.864865_g8938_i0	PRJNA602115	8963	209	0.864865	1.80756785	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	149	2.95e-42	NR	MCX7070011.1	1913989	g8938	i0	98.6	0.990430622009569	69	1	99	0	209	3	12	80	MCX7070011.1 2Fe-2S iron-sulfur cluster-binding protein [Gammaproteobacteria bacterium]	diamond	207	149	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
27869473	27869473	PRJNA602115_P_NODE_6545_length_248_cov_1.368984_g6520_i0	PRJNA602115	6545	248	1.368984	3.39508032	Limnobacter sp.	2003368	Bacteria	Bacteria	149	9.28e-40	NR	WP_409708180.1	2003368	g6520	i0	98.8	0.991935483870968	82	1	99.2	0	3	248	144	225	WP_409708180.1 TolC family outer membrane protein [Limnobacter sp.]	diamond	246	149	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
27901013	27901013	PRJNA602115_P_NODE_11125_length_203_cov_0.901408_g11100_i0	PRJNA602115	11125	203	0.901408	1.82985824	Comamonadaceae bacterium OS-4	2993873	Bacteria	Bacteria	75.9	2.42e-14	NR	BDT73269.1	2993873	g11100	i0	59.7	0.990147783251232	67	27	99	0	2	202	60	126	BDT73269.1 hypothetical protein os4_28170 [Comamonadaceae bacterium OS-4]	diamond	201	75.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae		Comamonadaceae bacterium OS-4
27996024	27996024	PRJNA602115_P_NODE_10885_length_203_cov_1.105634_g10860_i0	PRJNA602115	10885	203	1.105634	2.24443702	Lysobacteraceae bacterium	1926873	Bacteria	Bacteria	125	2.2099999999999998e-32	NR	MBA4285394.1	1926873	g10860	i0	92.5	0.990147783251232	67	5	99	0	3	203	63	129	MBA4285394.1 trigger factor [Lysobacteraceae bacterium]	diamond	201	125	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae		Lysobacteraceae bacterium
28027594	28027594	PRJNA602115_P_NODE_10685_length_204_cov_0.895105_g10660_i0	PRJNA602115	10685	204	0.895105	1.8260142	Curvibacter sp.	1888168	Bacteria	Bacteria	122	1.55e-30	NR	RUP35422.1	1888168	g10660	i0	97.1	1	68	2	100	0	204	1	3094	3161	RUP35422.1 MAG: hypothetical protein EKK45_01130, partial [Curvibacter sp.]	diamond	204	122	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Curvibacter	Curvibacter sp.
28451408	28451408	PRJNA602115_P_NODE_10706_length_204_cov_0.895105_g10681_i0	PRJNA602115	10706	204	0.895105	1.8260142	Enterobacteriaceae	543	Bacteria	Bacteria	40.4	0.0256	NR	WP_304998635.1	562	g10681	i0	61.5	1	26	10	38.2	0	125	48	11	36	WP_304998635.1 hypothetical protein, partial [Escherichia coli]	diamond	204	40.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28501179	28501179	PRJNA602115_P_NODE_11107_length_203_cov_0.901408_g11082_i0	PRJNA602115	11107	203	0.901408	1.82985824	Limnobacter humi	1778671	Bacteria	Bacteria	119	1.12e-29	NR	WP_256762603.1	1778671	g11082	i0	89.6	0.990147783251232	67	7	99	0	202	2	56	122	WP_256762603.1 DHA2 family efflux MFS transporter permease subunit [Limnobacter humi]	diamond	201	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter humi
28532861	28532861	PRJNA602115_P_NODE_11567_length_202_cov_0.872340_g11542_i0	PRJNA602115	11567	202	0.87234	1.7621268	Limnobacter sp.	2003368	Bacteria	Bacteria	120	1.0099999999999999e-32	NR	WP_409704947.1	2003368	g11542	i0	94.7	0.846534653465347	57	3	84.7	0	200	30	131	187	WP_409704947.1 flagellar transcriptional regulator FlhC [Limnobacter sp.]	diamond	171	120	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
28690758	28690758	PRJNA602115_P_NODE_9807_length_206_cov_1.324138_g9782_i0	PRJNA602115	9807	206	1.324138	2.72772428	Limnobacter sp.	2003368	Bacteria	Bacteria	110	3.02e-26	NR	WP_409704656.1	2003368	g9782	i0	83.6	0.975728155339806	67	11	97.6	0	203	3	515	581	WP_409704656.1 hypothetical protein [Limnobacter sp.]	diamond	201	110	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
28753668	28753668	PRJNA602115_P_NODE_5647_length_268_cov_0.898551_g5622_i0	PRJNA602115	5647	268	0.898551	2.40811668	Limnobacter sp.	2003368	Bacteria	Bacteria	136	4.95e-35	NR	WP_409706160.1	2003368	g5622	i0	95.7	0.772388059701492	69	3	77.2	0	266	60	1	69	WP_409706160.1 SpoIIE family protein phosphatase [Limnobacter sp.]	diamond	207	136	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
29006684	29006684	PRJNA602115_P_NODE_6248_length_255_cov_0.989691_g6223_i0	PRJNA602115	6248	255	0.989691	2.52371205	Limnobacter sp.	2003368	Bacteria	Bacteria	63.9	2.07e-10	NR	WP_409706832.1	2003368	g6223	i0	91.4	0.411764705882353	35	3	41.2	0	207	103	125	159	WP_409706832.1 disulfide bond formation protein B [Limnobacter sp.]	diamond	105	63.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
29006685	29006685	PRJNA602115_P_NODE_9988_length_206_cov_0.882759_g9963_i0	PRJNA602115	9988	206	0.882759	1.81848354	Limnobacter sp.	2003368	Bacteria	Bacteria	134	1.32e-36	NR	WP_409706408.1	2003368	g9963	i0	100	0.990291262135922	68	0	99	0	2	205	12	79	WP_409706408.1 YicC/YloC family endoribonuclease [Limnobacter sp.]	diamond	204	134	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
29132734	29132734	PRJNA602115_P_NODE_10469_length_205_cov_0.888889_g10444_i0	PRJNA602115	10469	205	0.888889	1.82222245	Limnobacter sp.	2003368	Bacteria	Bacteria	89.4	8.53e-19	NR	WP_409708303.1	2003368	g10444	i0	93.9	0.717073170731707	49	3	71.7	0	149	3	517	565	WP_409708303.1 beta strand repeat-containing protein [Limnobacter sp.]	diamond	147	89.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
29164382	29164382	PRJNA602115_P_NODE_9829_length_206_cov_0.882759_g9804_i0	PRJNA602115	9829	206	0.882759	1.81848354	Limnobacter sp.	2003368	Bacteria	Bacteria	139	5.46e-37	NR	WP_409708098.1	2003368	g9804	i0	100	0.990291262135922	68	0	99	0	2	205	32	99	WP_409708098.1 glucose-6-phosphate dehydrogenase [Limnobacter sp.]	diamond	204	139	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
29366979	29366979	PRJNA602115_P_NODE_10649_length_204_cov_0.895105_g10624_i0	PRJNA602115	10649	204	0.895105	1.8260142	Limnobacter	131079	Bacteria	Bacteria	87.4	3.89e-18	NR	WP_105028789.1	131079	g10624	i0	93.3	4.60294117647059	45	3	66.2	0	3	137	130	174	WP_105028789.1 MULTISPECIES: CTP synthase [Limnobacter]	diamond	939	87.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter
29385295	29385295	PRJNA602115_P_NODE_9709_length_207_cov_0.876712_g9684_i0	PRJNA602115	9709	207	0.876712	1.81479384	Lysobacteraceae bacterium	1926873	Bacteria	Bacteria	134	3.5799999999999997e-37	NR	MBA4287227.1	1926873	g9684	i0	91.2	0.985507246376812	68	6	98.6	0	205	2	161	228	MBA4287227.1 type III pantothenate kinase [Lysobacteraceae bacterium]	diamond	204	134	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae		Lysobacteraceae bacterium
30048161	30048161	PRJNA602115_P_NODE_10051_length_206_cov_0.882759_g10026_i0	PRJNA602115	10051	206	0.882759	1.81848354	Limnobacter sp.	2003368	Bacteria	Bacteria	140	6.48e-37	NR	WP_409708432.1	2003368	g10026	i0	97.1	0.990291262135922	68	2	99	0	1	204	163	230	WP_409708432.1 PKD domain-containing protein [Limnobacter sp.]	diamond	204	140	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
30174662	30174662	PRJNA602115_P_NODE_10772_length_204_cov_0.895105_g10747_i0	PRJNA602115	10772	204	0.895105	1.8260142	Pseudochelatococcus lubricantis	1538102	Bacteria	Bacteria	76.6	2.55e-14	NR	WP_377590675.1	1538102	g10747	i0	62.3	1.01470588235294	69	25	100	1	1	204	430	498	WP_377590675.1 COG4223 family protein [Pseudochelatococcus lubricantis]	diamond	207	76.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Chelatococcaceae	Pseudochelatococcus	Pseudochelatococcus lubricantis
30174663	30174663	PRJNA602115_P_NODE_6292_length_254_cov_0.968912_g6267_i0	PRJNA602115	6292	254	0.968912	2.46103648	Limnobacter sp.	2003368	Bacteria	Bacteria	164	5.76e-48	NR	WP_409705133.1	2003368	g6267	i0	100	0.968503937007874	82	0	96.9	0	2	247	130	211	WP_409705133.1 GAF domain-containing protein [Limnobacter sp.]	diamond	246	164	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
30237939	30237939	PRJNA602115_P_NODE_11072_length_203_cov_0.901408_g11047_i0	PRJNA602115	11072	203	0.901408	1.82985824	Limnobacter sp.	2003368	Bacteria	Bacteria	90.9	2.92e-20	NR	WP_409711247.1	2003368	g11047	i0	100	0.650246305418719	44	0	65	0	1	132	221	264	WP_409711247.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Limnobacter sp.]	diamond	132	90.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
30396342	30396342	PRJNA602115_P_NODE_10213_length_205_cov_0.888889_g10188_i0	PRJNA602115	10213	205	0.888889	1.82222245	Methylobacterium fujisawaense	107400	Bacteria	Bacteria	91.3	1.64e-19	NR	WP_127993272.1	107400	g10188	i0	80	2.64878048780488	60	12	87.8	0	6	185	186	245	WP_127993272.1 NADH-quinone oxidoreductase subunit L [Methylobacterium fujisawaense]	diamond	543	91.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium fujisawaense
30459513	30459513	PRJNA602115_P_NODE_10053_length_206_cov_0.882759_g10028_i0	PRJNA602115	10053	206	0.882759	1.81848354	Limnobacter sp.	2003368	Bacteria	Bacteria	46.2	6.26e-4	NR	WP_409705893.1	2003368	g10028	i0	100	0.33495145631068	23	0	33.5	0	1	69	132	154	WP_409705893.1 phasin family protein [Limnobacter sp.]	diamond	69	46.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
30553719	30553719	PRJNA602115_P_NODE_10973_length_203_cov_0.901408_g10948_i0	PRJNA602115	10973	203	0.901408	1.82985824	Solimonas sp. K1W22B-7	2303331	Bacteria	Bacteria	125	6.53e-34	NR	WP_117291429.1	2303331	g10948	i0	97	0.990147783251232	67	2	99	0	2	202	70	136	WP_117291429.1 MotA/TolQ/ExbB proton channel family protein [Solimonas sp. K1W22B-7]	diamond	201	125	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Nevskiales	Nevskiaceae	Solimonas	Solimonas sp. K1W22B-7
30711802	30711802	PRJNA602115_P_NODE_4394_length_297_cov_1.355932_g4369_i0	PRJNA602115	4394	297	1.355932	4.02711804	Vibrio variabilis	990271	Bacteria	Bacteria	44.3	0.0192	NR	WP_112480122.1	990271	g4369	i0	34.2	0.737373737373737	73	43	70.7	3	77	286	312	382	WP_112480122.1 MATE family efflux transporter DinF [Vibrio variabilis]	diamond	219	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio variabilis
30806674	30806674	PRJNA602115_P_NODE_3054_length_347_cov_1.097902_g3029_i0	PRJNA602115	3054	347	1.097902	3.80971994	Limnobacter sp.	2003368	Bacteria	Bacteria	139	9.02e-41	NR	WP_409705092.1	2003368	g3029	i0	100	0.622478386167147	72	0	62.2	0	311	96	1	72	WP_409705092.1 hypothetical protein [Limnobacter sp.]	diamond	216	139	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
30964754	30964754	PRJNA602115_P_NODE_7314_length_234_cov_1.052023_g7289_i0	PRJNA602115	7314	234	1.052023	2.46173382	Limnobacter sp.	2003368	Bacteria	Bacteria	145	6.56e-39	NR	WP_409709245.1	2003368	g7289	i0	96.1	0.987179487179487	77	3	98.7	0	232	2	382	458	WP_409709245.1 hypothetical protein [Limnobacter sp.]	diamond	231	145	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
31027976	31027976	PRJNA602115_P_NODE_10355_length_205_cov_0.888889_g10330_i0	PRJNA602115	10355	205	0.888889	1.82222245	Burkholderiaceae bacterium	2030806	Bacteria	Bacteria	126	1.77e-35	NR	NBV01511.1	2030806	g10330	i0	83.8	0.995121951219512	68	11	99.5	0	205	2	48	115	NBV01511.1 hypothetical protein [Burkholderiaceae bacterium]	diamond	204	126	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae		Burkholderiaceae bacterium
31122214	31122214	PRJNA602115_P_NODE_11355_length_202_cov_0.907801_g11330_i0	PRJNA602115	11355	202	0.907801	1.83375802	Burkholderiales bacterium	1891238	Bacteria	Bacteria	40	0.0195	NR	HZN27103.1	1891238	g11330	i0	62.5	0.356435643564356	24	9	35.6	0	86	15	1	24	HZN27103.1 adenylyltransferase/cytidyltransferase family protein [Burkholderiales bacterium]	diamond	72	40	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
31216991	31216991	PRJNA602115_P_NODE_7815_length_225_cov_1.170732_g7790_i0	PRJNA602115	7815	225	1.170732	2.634147	Gammaproteobacteria bacterium	1913989	Bacteria	Bacteria	119	2.78e-33	NR	MDI9336468.1	1913989	g7790	i0	100	0.733333333333333	55	0	73.3	0	224	60	28	82	MDI9336468.1 hypothetical protein [Gammaproteobacteria bacterium]	diamond	165	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
31691806	31691806	PRJNA602115_P_NODE_5297_length_276_cov_0.893023_g5272_i0	PRJNA602115	5297	276	0.893023	2.46474348	Xenorhabdus griffiniae	351672	Bacteria	Bacteria	71.2	1.66e-13	NR	WP_047771832.1	351672	g5272	i0	45.7	2.66304347826087	81	33	82.6	3	2	229	19	93	WP_047771832.1 structural protein, partial [Xenorhabdus griffiniae]	diamond	735	71.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Xenorhabdus	Xenorhabdus griffiniae
31944717	31944717	PRJNA602115_P_NODE_11057_length_203_cov_0.901408_g11032_i0	PRJNA602115	11057	203	0.901408	1.82985824	Limnobacter	131079	Bacteria	Bacteria	85.1	2.43e-17	NR	WP_171098568.1	131079	g11032	i0	83.7	1.44827586206897	49	8	72.4	0	2	148	13	61	WP_171098568.1 MULTISPECIES: NADH-quinone oxidoreductase subunit M [Limnobacter]	diamond	294	85.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter
32198051	32198051	PRJNA602115_P_NODE_2638_length_372_cov_1.028939_g2613_i0	PRJNA602115	2638	372	1.028939	3.82765308	Psychrobacter sp.	56811	Bacteria	Bacteria	90.5	1.5e-18	NR	WP_193215998.1	56811	g2613	i0	65.1	0.508064516129032	63	22	50.8	0	109	297	282	344	WP_193215998.1 zonular occludens toxin domain-containing protein [Psychrobacter sp.]	diamond	189	90.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter	Psychrobacter sp.
32546280	32546280	PRJNA602115_P_NODE_9319_length_208_cov_0.870748_g9294_i0	PRJNA602115	9319	208	0.870748	1.81115584	Limnobacter sp.	2003368	Bacteria	Bacteria	102	1.24e-24	NR	WP_409705300.1	2003368	g9294	i0	100	0.778846153846154	54	0	77.9	0	207	46	145	198	WP_409705300.1 acetyl-CoA carboxylase, carboxyltransferase subunit beta [Limnobacter sp.]	diamond	162	102	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp.
32609166	32609166	PRJNA602115_P_NODE_7620_length_229_cov_1.130952_g7595_i0	PRJNA602115	7620	229	1.130952	2.58988008	Magnetococcus sp. YQC-3	2763146	Bacteria	Bacteria	97.4	2.13e-22	NR	MEO5351424.1	2763146	g7595	i0	70.7	0.759825327510917	58	17	76	0	2	175	235	292	MEO5351424.1 hypothetical protein [Magnetococcus sp. YQC-3]	diamond	174	97.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Magnetococcia	Magnetococcales	Magnetococcaceae	Magnetococcus	Magnetococcus sp. YQC-3
32766513	32766513	PRJNA602115_P_NODE_7420_length_232_cov_1.356725_g7395_i0	PRJNA602115	7420	232	1.356725	3.147602	Limnobacter	131079	Bacteria	Bacteria	67.8	4.77e-13	NR	WP_256762574.1	131079	g7395	i0	82.6	0.594827586206897	46	8	59.5	0	58	195	15	60	WP_256762574.1 MULTISPECIES: Flp family type IVb pilin [Limnobacter]	diamond	138	67.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter
32829630	32829630	PRJNA602115_P_NODE_5640_length_268_cov_0.946860_g5615_i0	PRJNA602115	5640	268	0.94686	2.5375848	Lysobacteraceae bacterium	1926873	Bacteria	Bacteria	134	2.18e-34	NR	MBA4283936.1	1926873	g5615	i0	83.9	0.973880597014925	87	14	97.4	0	263	3	40	126	MBA4283936.1 LPS-assembly protein LptD [Lysobacteraceae bacterium]	diamond	261	134	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae		Lysobacteraceae 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);;