metadata: contig_metadata: 40 rows where analysis = "diamond", bioproject = "PRJNA1073005" and tax

40 rows where analysis = "diamond", bioproject = "PRJNA1073005" 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
5289766	5289766	PRJNA1073005_P_NODE_7325_length_310_cov_0.974684_g7206_i0	PRJNA1073005	7325	310	0.974684	3.0215204	root	1	Root_unresolved	Root_unresolved	149	2.01e-39	NR	WP_060116597.1	101571	g7206	i0	72.8	1.99354838709677	103	28	99.7	0	1	309	176	278	WP_060116597.1 pyruvate, phosphate dikinase [Burkholderia ubonensis]	diamond	618	150	0.993333333333333	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia ubonensis
6564951	6564951	PRJNA1073005_P_NODE_8006_length_283_cov_1.033333_g7887_i0	PRJNA1073005	8006	283	1.033333	2.92433239	Pseudomonadati	3379134	Bacteria	Bacteria	99.4	5.16e-22	NR	HRJ01765.1	87	g7887	i0	59.1	2.87279151943463	93	38	98.6	0	283	5	150	242	HRJ01765.1 transposase [Hyphomonas sp.]	diamond	813	100	0.994	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomonadales	Hyphomonadaceae	Hyphomonas	Hyphomonas sp.
14215647	14215647	PRJNA1073005_P_NODE_10092_length_243_cov_0.905882_g9973_i0	PRJNA1073005	10092	243	0.905882	2.20129326	Diaphorobacter nitroreducens	164759	Bacteria	Bacteria	147	5.999999999999998e-39	NR	WP_088887292.1	164759	g9973	i0	90	3.95061728395062	80	8	98.8	0	2	241	2651	2730	WP_088887292.1 non-ribosomal peptide synthetase [Diaphorobacter nitroreducens]	diamond	960	147	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Diaphorobacter	Diaphorobacter nitroreducens
15489602	15489602	PRJNA1073005_P_NODE_10253_length_242_cov_0.911243_g10134_i0	PRJNA1073005	10253	242	0.911243	2.20520806	Asticcacaulis	76890	Bacteria	Bacteria	68.6	3.05e-11	NR	WP_209721371.1	76890	g10134	i0	89.5	0.471074380165289	38	4	47.1	0	93	206	1355	1392	WP_209721371.1 MULTISPECIES: calcium-binding protein [Asticcacaulis]	diamond	114	68.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Asticcacaulis
16318498	16318498	PRJNA1073005_P_NODE_7813_length_289_cov_1.134259_g7694_i0	PRJNA1073005	7813	289	1.134259	3.27800851	Melaminivora alkalimesophila	1165852	Bacteria	Bacteria	180	9.59e-52	NR	WP_019372995.1	1165852	g7694	i0	100	1.97231833910035	95	0	98.6	0	3	287	238	332	WP_019372995.1 efflux RND transporter permease subunit, partial [Melaminivora alkalimesophila]	diamond	570	180	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Melaminivora	Melaminivora alkalimesophila
16763898	16763898	PRJNA1073005_P_NODE_7674_length_295_cov_1.040541_g7555_i0	PRJNA1073005	7674	295	1.040541	3.06959595	Melaminivora alkalimesophila	1165852	Bacteria	Bacteria	183	6.039999999999998e-56	NR	WP_019375096.1	1165852	g7555	i0	98	1.99322033898305	98	2	99.7	0	294	1	49	146	WP_019375096.1 type I-F CRISPR-associated protein Csy3, partial [Melaminivora alkalimesophila]	diamond	588	183	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Melaminivora	Melaminivora alkalimesophila
16763907	16763907	PRJNA1073005_P_NODE_9634_length_246_cov_0.890173_g9515_i0	PRJNA1073005	9634	246	0.890173	2.18982558	Aquabacterium commune	70586	Bacteria	Bacteria	131	1.01e-33	NR	WP_243738460.1	70586	g9515	i0	93.8	0.98780487804878	81	5	98.8	0	245	3	242	322	WP_243738460.1 efflux transporter outer membrane subunit [Aquabacterium commune]	diamond	243	131	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium commune
17593807	17593807	PRJNA1073005_P_NODE_9914_length_244_cov_0.900585_g9795_i0	PRJNA1073005	9914	244	0.900585	2.1974274	Melaminivora alkalimesophila	1165852	Bacteria	Bacteria	170	3.519999999999999e-47	NR	WP_019374943.1	1165852	g9795	i0	100	0.995901639344262	81	0	99.6	0	243	1	672	752	WP_019374943.1 FdhF/YdeP family oxidoreductase [Melaminivora alkalimesophila]	diamond	243	170	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Melaminivora	Melaminivora alkalimesophila
19312647	19312647	PRJNA1073005_P_NODE_10456_length_228_cov_6.716129_g10337_i0	PRJNA1073005	10456	228	6.716129	15.31277412	Bacteria	2	Bacteria	Bacteria	149	2.399999999999999e-41	NR	MBU4581331.1	1977087	g10337	i0	86.1	12.4736842105263	72	10	94.7	0	218	3	62	133	MBU4581331.1 dissimilatory-type sulfite reductase subunit alpha [Pseudomonadota bacterium]	diamond	2844	150	0.993333333333333	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
19312659	19312659	PRJNA1073005_P_NODE_7156_length_316_cov_1.901235_g7037_i0	PRJNA1073005	7156	316	1.901235	6.0079026	Rhodocyclaceae bacterium	1898103	Bacteria	Bacteria	210	5.68e-68	NR	HCO76784.1	1898103	g7037	i0	100	0.987341772151899	104	0	98.7	0	314	3	14	117	HCO76784.1 hypothetical protein [Rhodocyclaceae bacterium]	diamond	312	210	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae		Rhodocyclaceae bacterium
27035768	27035768	PRJNA1073005_P_NODE_8862_length_253_cov_1.283333_g8743_i0	PRJNA1073005	8862	253	1.283333	3.24683249	unclassified Variovorax	663243	Bacteria	Bacteria	78.6	9.86e-15	NR	WP_093221399.1	663243	g8743	i0	44.6	0.984189723320158	83	43	98.4	1	3	251	420	499	WP_093221399.1 MULTISPECIES: GMC family oxidoreductase [unclassified Variovorax]	diamond	249	78.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax
27130183	27130183	PRJNA1073005_P_NODE_6142_length_364_cov_1.415808_g6023_i0	PRJNA1073005	6142	364	1.415808	5.15354112	Thiomonas intermedia	926	Bacteria	Bacteria	43.9	0.0199	NR	WP_079419830.1	926	g6023	i0	41.5	0.997252747252747	41	23	33	1	184	65	80	120	WP_079419830.1 lysozyme inhibitor LprI family protein [Thiomonas intermedia]	diamond	363	43.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Thiomonas	Thiomonas intermedia
27541438	27541438	PRJNA1073005_P_NODE_8224_length_275_cov_1.143564_g8105_i0	PRJNA1073005	8224	275	1.143564	3.144801	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	122	8.1e-31	NR	MDO5691852.1	1977087	g8105	i0	68.5	0.970909090909091	89	28	97.1	0	8	274	131	219	MDO5691852.1 MFS transporter [Pseudomonadota bacterium]	diamond	267	122	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27572912	27572912	PRJNA1073005_P_NODE_9224_length_249_cov_0.875000_g9105_i0	PRJNA1073005	9224	249	0.875	2.17875	Hydrogenophilus thermoluteolus	297	Bacteria	Bacteria	150	1.4e-42	NR	HNU19043.1	297	g9105	i0	89.2	1	83	9	100	0	249	1	4	86	HNU19043.1 type III-B CRISPR module RAMP protein Cmr4 [Hydrogenophilus thermoluteolus]	diamond	249	150	1	Bacteria	Pseudomonadati	Pseudomonadota	Hydrogenophilia	Hydrogenophilales	Hydrogenophilaceae	Hydrogenophilus	Hydrogenophilus thermoluteolus
28046474	28046474	PRJNA1073005_P_NODE_10305_length_241_cov_0.916667_g10186_i0	PRJNA1073005	10305	241	0.916667	2.20916747	Roseisalinus antarcticus	254357	Bacteria	Bacteria	42.4	0.0475	NR	WP_085880771.1	254357	g10186	i0	41.8	0.684647302904564	55	26	67.2	2	235	74	260	309	WP_085880771.1 penicillin-insensitive murein endopeptidase [Roseisalinus antarcticus]	diamond	165	42.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Roseisalinus	Roseisalinus antarcticus
28046475	28046475	PRJNA1073005_P_NODE_9405_length_248_cov_0.880000_g9286_i0	PRJNA1073005	9405	248	0.88	2.1824	Comamonas denitrificans	117506	Bacteria	Bacteria	148	1.19e-41	NR	WP_242700391.1	117506	g9286	i0	97.4	0.919354838709677	76	2	91.9	0	2	229	148	223	WP_242700391.1 Lrp/AsnC family transcriptional regulator [Comamonas denitrificans]	diamond	228	148	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas denitrificans
28330608	28330608	PRJNA1073005_P_NODE_7386_length_307_cov_1.316239_g7267_i0	PRJNA1073005	7386	307	1.316239	4.04085373	Escherichia coli	562	Bacteria	Bacteria	44.7	0.00172	NR	WP_206682113.1	562	g7267	i0	77.8	0.263843648208469	27	6	26.4	0	10	90	1	27	WP_206682113.1 hypothetical protein, partial [Escherichia coli]	diamond	81	44.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
28741132	28741132	PRJNA1073005_P_NODE_10287_length_241_cov_1.375000_g10168_i0	PRJNA1073005	10287	241	1.375	3.31375	Tepidimonas charontis	2267262	Bacteria	Bacteria	169	2.9999999999999996e-49	NR	WP_144329326.1	2267262	g10168	i0	100	0.995850622406639	80	0	99.6	0	241	2	37	116	WP_144329326.1 phage terminase large subunit [Tepidimonas charontis]	diamond	240	169	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Tepidimonas	Tepidimonas charontis
28898839	28898839	PRJNA1073005_P_NODE_8968_length_251_cov_0.865169_g8849_i0	PRJNA1073005	8968	251	0.865169	2.17157419	Paenalcaligenes	1100891	Bacteria	Bacteria	154	2.69e-44	NR	WP_300647651.1	1100891	g8849	i0	97.6	0.99203187250996006	83	2	99.2	0	3	251	62	144	WP_300647651.1 MULTISPECIES: D-glycero-beta-D-manno-heptose-7-phosphate kinase [Paenalcaligenes]	diamond	249	154	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Paenalcaligenes
29088547	29088547	PRJNA1073005_P_NODE_8168_length_277_cov_1.186275_g8049_i0	PRJNA1073005	8168	277	1.186275	3.28598175	Cellvibrio sp.	1965322	Bacteria	Bacteria	84.3	1.34e-16	NR	HTF96769.1	1965322	g8049	i0	43.9	2.07942238267148	98	41	96.4	3	277	11	374	466	HTF96769.1 hypothetical protein [Cellvibrio sp.]	diamond	576	84.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Cellvibrionaceae	Cellvibrio	Cellvibrio sp.
29183374	29183374	PRJNA1073005_P_NODE_9589_length_246_cov_1.572254_g9470_i0	PRJNA1073005	9589	246	1.572254	3.86774484	Burkholderiales bacterium	1891238	Bacteria	Bacteria	42	0.0364	NR	HXZ52049.1	1891238	g9470	i0	29.9	0.939024390243902	77	45	84.1	3	222	16	19	94	HXZ52049.1 GFA family protein [Burkholderiales bacterium]	diamond	231	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
29909577	29909577	PRJNA1073005_P_NODE_9671_length_246_cov_0.890173_g9552_i0	PRJNA1073005	9671	246	0.890173	2.18982558	Betaproteobacteria bacterium	1891241	Bacteria	Bacteria	77	3.02e-14	NR	MDE2268578.1	1891241	g9552	i0	58.2	0.963414634146341	79	31	96.3	1	8	244	316	392	MDE2268578.1 ATP-dependent Clp protease ATP-binding subunit [Betaproteobacteria bacterium]	diamond	237	77	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria				Betaproteobacteria bacterium
30027445	30027445	PRJNA1073005_P_NODE_9991_length_244_cov_0.900585_g9872_i0	PRJNA1073005	9991	244	0.900585	2.1974274	Hydrogenophilus	70774	Bacteria	Bacteria	130	5.33e-36	NR	GLW61751.1	297	g9872	i0	100	1.47540983606557	60	0	73.8	0	242	63	149	208	GLW61751.1 hypothetical protein Hthe01_21000 [Hydrogenophilus thermoluteolus]	diamond	360	130	1	Bacteria	Pseudomonadati	Pseudomonadota	Hydrogenophilia	Hydrogenophilales	Hydrogenophilaceae	Hydrogenophilus	Hydrogenophilus thermoluteolus
30352307	30352307	PRJNA1073005_P_NODE_9812_length_245_cov_0.895349_g9693_i0	PRJNA1073005	9812	245	0.895349	2.19360505	Candidatus Competibacteraceae bacterium	2053538	Bacteria	Bacteria	43.1	0.0259	NR	MEZ5583371.1	2053538	g9693	i0	38.5	0.795918367346939	65	34	79.6	2	224	30	210	268	MEZ5583371.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Candidatus Competibacteraceae bacterium]	diamond	195	43.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria		Candidatus Competibacteraceae		Candidatus Competibacteraceae bacterium
30699198	30699198	PRJNA1073005_P_NODE_7934_length_285_cov_1.363208_g7815_i0	PRJNA1073005	7934	285	1.363208	3.8851428	Melaminivora alkalimesophila	1165852	Bacteria	Bacteria	191	2.94e-59	NR	WP_040437208.1	1165852	g7815	i0	98.9	0.989473684210526	94	1	98.9	0	283	2	24	117	WP_040437208.1 molybdate ABC transporter substrate-binding protein [Melaminivora alkalimesophila]	diamond	282	191	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Melaminivora	Melaminivora alkalimesophila
30762577	30762577	PRJNA1073005_P_NODE_5314_length_408_cov_1.310448_g5195_i0	PRJNA1073005	5314	408	1.310448	5.34662784	Hydrogenophilus thiooxidans	2820326	Bacteria	Bacteria	175	2.3199999999999994e-54	NR	WP_217127118.1	2820326	g5195	i0	100	0.632352941176471	86	0	63.2	0	259	2	1	86	WP_217127118.1 CRISPR-associated endonuclease Cas2 [Hydrogenophilus thiooxidans]	diamond	258	175	1	Bacteria	Pseudomonadati	Pseudomonadota	Hydrogenophilia	Hydrogenophilales	Hydrogenophilaceae	Hydrogenophilus	Hydrogenophilus thiooxidans
30880337	30880337	PRJNA1073005_P_NODE_8054_length_281_cov_1.346154_g7935_i0	PRJNA1073005	8054	281	1.346154	3.78269274	Burkholderiales	80840	Bacteria	Bacteria	79.7	4.49e-16	NR	HLO96258.1	2030806	g7935	i0	60.6	2.0711743772242	66	25	70.5	1	81	278	3	67	HLO96258.1 hypothetical protein [Burkholderiaceae bacterium]	diamond	582	79.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae		Burkholderiaceae bacterium
30920661	30920661	PRJNA1073005_P_NODE_5674_length_387_cov_13.458599_g5555_i0	PRJNA1073005	5674	387	13.458599	52.08477813	Herbaspirillum rubrisubalbicans	80842	Bacteria	Bacteria	82.8	1.28e-17	NR	WP_237742021.1	80842	g5555	i0	86.4	0.341085271317829	44	6	34.1	0	150	19	65	108	WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans]	diamond	132	82.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum rubrisubalbicans
31394735	31394735	PRJNA1073005_P_NODE_8956_length_251_cov_0.865169_g8837_i0	PRJNA1073005	8956	251	0.865169	2.17157419	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	94.4	1.3400000000000002e-21	NR	MBS0293768.1	1977087	g8837	i0	69.9	1.9840637450199201	83	25	99.2	0	250	2	67	149	MBS0293768.1 DUF4124 domain-containing protein [Pseudomonadota bacterium]	diamond	498	94.4	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
31426193	31426193	PRJNA1073005_P_NODE_10036_length_243_cov_0.905882_g9917_i0	PRJNA1073005	10036	243	0.905882	2.20129326	Glacieibacterium frigidum	2593303	Bacteria	Bacteria	144	7.419999999999999e-38	NR	WP_144237703.1	2593303	g9917	i0	88.5	0.962962962962963	78	9	96.3	0	243	10	814	891	WP_144237703.1 hypothetical protein [Glacieibacterium frigidum]	diamond	234	144	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingosinicellaceae	Glacieibacterium	Glacieibacterium frigidum
31607533	31607533	PRJNA1073005_P_NODE_9096_length_250_cov_0.870056_g8977_i0	PRJNA1073005	9096	250	0.870056	2.17514	Pseudomonadota	1224	Bacteria	Bacteria	163	1.99e-44	NR	MBW7657067.1	297	g8977	i0	98.8	1.992	83	1	99.6	0	250	2	478	560	MBW7657067.1 hypothetical protein [Hydrogenophilus thermoluteolus]	diamond	498	163	1	Bacteria	Pseudomonadati	Pseudomonadota	Hydrogenophilia	Hydrogenophilales	Hydrogenophilaceae	Hydrogenophilus	Hydrogenophilus thermoluteolus
31679139	31679139	PRJNA1073005_P_NODE_9097_length_250_cov_0.870056_g8978_i0	PRJNA1073005	9097	250	0.870056	2.17514	Endozoicomonas sp.	1892382	Bacteria	Bacteria	53.1	8.7e-6	NR	WP_402522497.1	1892382	g8978	i0	39.2	0.612	51	29	61.2	1	5	157	482	530	WP_402522497.1 hypothetical protein [Endozoicomonas sp.]	diamond	153	53.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Endozoicomonadaceae	Endozoicomonas	Endozoicomonas sp.
31932217	31932217	PRJNA1073005_P_NODE_9837_length_245_cov_0.895349_g9718_i0	PRJNA1073005	9837	245	0.895349	2.19360505	Hyphomonadaceae bacterium	2026748	Bacteria	Bacteria	42.7	0.0322	NR	MBL8546722.1	2026748	g9718	i0	44.1	0.722448979591837	59	31	71	2	194	21	1	58	MBL8546722.1 hypothetical protein [Hyphomonadaceae bacterium]	diamond	177	42.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomonadales	Hyphomonadaceae		Hyphomonadaceae bacterium
32122359	32122359	PRJNA1073005_P_NODE_10038_length_243_cov_0.905882_g9919_i0	PRJNA1073005	10038	243	0.905882	2.20129326	Lysobacteraceae bacterium	1926873	Bacteria	Bacteria	132	1.0799999999999998e-37	NR	HAI60122.1	1926873	g9919	i0	85.3	0.925925925925926	75	11	92.6	0	234	10	51	125	HAI60122.1 hypothetical protein [Lysobacteraceae bacterium]	diamond	225	132	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae		Lysobacteraceae bacterium
32217160	32217160	PRJNA1073005_P_NODE_9298_length_249_cov_0.875000_g9179_i0	PRJNA1073005	9298	249	0.875	2.17875	Cellvibrio fibrivorans	126350	Bacteria	Bacteria	59.7	1.17e-8	NR	WP_310073671.1	126350	g9179	i0	87.9	0.819277108433735	33	4	39.8	0	249	151	141	173	WP_310073671.1 Crp/Fnr family transcriptional regulator [Cellvibrio fibrivorans]	diamond	204	59.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Cellvibrionaceae	Cellvibrio	Cellvibrio fibrivorans
32249074	32249074	PRJNA1073005_P_NODE_9898_length_244_cov_1.000000_g9779_i0	PRJNA1073005	9898	244	1	2.44	Ottowia sp.	1898956	Bacteria	Bacteria	47.8	6.13e-4	NR	MCK9516971.1	1898956	g9779	i0	67.9	0.344262295081967	28	9	34.4	0	85	2	1	28	MCK9516971.1 hypothetical protein [Ottowia sp.]	diamond	84	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Ottowia	Ottowia sp.
32366989	32366989	PRJNA1073005_P_NODE_7399_length_306_cov_2.274678_g7280_i0	PRJNA1073005	7399	306	2.274678	6.96051468	root	1	Root_unresolved	Root_unresolved	106	6.72e-26	NR	MCI3325496.1	562	g7280	i0	59.8	3	102	38	100	1	306	1	3	101	MCI3325496.1 L30/L7 family 60S ribosomal protein [Escherichia coli]	diamond	918	106	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32533705	32533705	PRJNA1073005_P_NODE_8059_length_281_cov_1.153846_g7940_i0	PRJNA1073005	8059	281	1.153846	3.24230726	Aidingimonas lacisalsi	2604086	Bacteria	Bacteria	96.7	9.34e-22	NR	WP_148253387.1	2604086	g7940	i0	46.2	0.97153024911032	91	49	97.2	0	281	9	30	120	WP_148253387.1 hypothetical protein [Aidingimonas lacisalsi]	diamond	273	96.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Aidingimonas	Aidingimonas lacisalsi
32565442	32565442	PRJNA1073005_P_NODE_9439_length_248_cov_0.880000_g9320_i0	PRJNA1073005	9439	248	0.88	2.1824	Acidithiobacillus sp.	1872118	Bacteria	Bacteria	110	4.5e-26	NR	WP_287684302.1	1872118	g9320	i0	63.9	1.00403225806452	83	28	98	1	244	2	106	188	WP_287684302.1 hypothetical protein [Acidithiobacillus sp.]	diamond	249	110	1	Bacteria	Pseudomonadati	Pseudomonadota	Acidithiobacillia	Acidithiobacillales	Acidithiobacillaceae	Acidithiobacillus	Acidithiobacillus sp.
32785421	32785421	PRJNA1073005_P_NODE_8440_length_268_cov_1.071795_g8321_i0	PRJNA1073005	8440	268	1.071795	2.8724106	Magnetospirillum sp.	31872	Bacteria	Bacteria	42.7	0.0462	NR	MCA1907165.1	31872	g8321	i0	37.9	0.738805970149254	66	25	57.1	2	80	232	88	152	MCA1907165.1 DMT family transporter [Magnetospirillum sp.]	diamond	198	42.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Rhodospirillaceae	Magnetospirillum	Magnetospirillum sp.

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