metadata: contig_metadata: 25 rows where analysis = "diamond", bioproject = "PRJNA951388" and tax

25 rows where analysis = "diamond", bioproject = "PRJNA951388" 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
1262682	1262682	PRJNA951388_S_NODE_2741_length_464_cov_7.406650_g2614_i0	PRJNA951388	2741	464	7.40665	34.366856	Bacteria	2	Bacteria	Bacteria	91.7	1.73e-18	NR	MDC0385804.1	2026775	g2614	i0	47.1	3.43965517241379	87	45	55.6	1	258	1	4	90	MDC0385804.1 hypothetical protein [Pelagibacteraceae bacterium]	diamond	1596	91.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Candidatus Pelagibacterales	Candidatus Pelagibacteraceae		Pelagibacteraceae bacterium
17512893	17512893	PRJNA951388_S_NODE_5754_length_353_cov_3.228571_g5627_i0	PRJNA951388	5754	353	3.228571	11.39685563	unclassified Phyllobacterium	2638441	Bacteria	Bacteria	221	3.13e-71	NR	WP_112528800.1	2638441	g5627	i0	94.9	0.994334277620397	117	6	99.4	0	3	353	13	129	WP_112528800.1 MULTISPECIES: LexA family transcriptional regulator [unclassified Phyllobacterium]	diamond	351	221	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium
26905643	26905643	PRJNA951388_S_NODE_4761_length_383_cov_4.532258_g4634_i0	PRJNA951388	4761	383	4.532258	17.35854814	Alphaproteobacteria	28211	Bacteria	Bacteria	127	2.46e-31	NR	MEJ2457329.1	1874826	g4634	i0	62.9	6.55613577023499	97	36	76	0	378	88	435	531	MEJ2457329.1 choline dehydrogenase [Novosphingobium sp.]	diamond	2511	128	0.9921875	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium sp.
26930683	26930683	PRJNA951388_S_NODE_2702_length_466_cov_10.012723_g2575_i0	PRJNA951388	2702	466	10.012723	46.65928918	Buchnera aphidicola	9	Bacteria	Bacteria	54.3	3.2e-5	NR	WP_367671453.1	9	g2575	i0	31	0.811158798283262	126	69	78.5	4	416	51	275	386	WP_367671453.1 trypsin-like peptidase domain-containing protein [Buchnera aphidicola]	diamond	378	54.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
26993702	26993702	PRJNA951388_S_NODE_6742_length_327_cov_3.870079_g6615_i0	PRJNA951388	6742	327	3.870079	12.65515833	Phyllobacterium calauticae	2817027	Bacteria	Bacteria	184	7.749999999999999e-56	NR	WP_223614632.1	2817027	g6615	i0	99	0.880733944954128	96	1	88.1	0	40	327	1	96	WP_223614632.1 SDR family oxidoreductase [Phyllobacterium calauticae]	diamond	288	184	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium calauticae
27025578	27025578	PRJNA951388_S_NODE_9442_length_271_cov_2.656566_g9315_i0	PRJNA951388	9442	271	2.656566	7.19929386	Phyllobacterium sp.	1871046	Bacteria	Bacteria	168	1.33e-52	NR	MBN9137479.1	1871046	g9315	i0	100	1.61623616236162	73	0	80.8	0	52	270	1	73	MBN9137479.1 DUF1326 domain-containing protein [Phyllobacterium sp.]	diamond	438	168	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
27183479	27183479	PRJNA951388_S_NODE_9702_length_266_cov_2.274611_g9575_i0	PRJNA951388	9702	266	2.274611	6.05046526	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	164	5.849999999999998e-47	NR	WP_182550566.1	28101	g9575	i0	95.5	0.992481203007519	88	4	99.2	0	265	2	79	166	WP_182550566.1 CmpA/NrtA family ABC transporter substrate-binding protein [Phyllobacterium myrsinacearum]	diamond	264	164	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
27562484	27562484	PRJNA951388_S_NODE_7764_length_304_cov_2.480519_g7637_i0	PRJNA951388	7764	304	2.480519	7.54077776	uncultured Acetobacteraceae bacterium	169975	Bacteria	Bacteria	132	1.3699999999999998e-35	NR	CAA9267969.1	169975	g7637	i0	81	0.986842105263158	100	18	98.7	1	3	302	138	236	CAA9267969.1 MAG: hypothetical protein AVDCRST_MAG08-3041 [uncultured Acetobacteraceae bacterium]	diamond	300	132	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae		uncultured Acetobacteraceae bacterium
27626036	27626036	PRJNA951388_S_NODE_6884_length_324_cov_3.537849_g6757_i0	PRJNA951388	6884	324	3.537849	11.46263076	Citreimonas salinaria	321339	Bacteria	Bacteria	112	3.5200000000000004e-26	NR	WP_089877977.1	321339	g6757	i0	55.6	10.5555555555556	108	43	100	1	324	1	104	206	WP_089877977.1 aminomethyl-transferring glycine dehydrogenase [Citreimonas salinaria]	diamond	3420	112	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Citreimonas	Citreimonas salinaria
28005002	28005002	PRJNA951388_S_NODE_5865_length_350_cov_2.509025_g5738_i0	PRJNA951388	5865	350	2.509025	8.7815875	Porticoccus sp.	2024853	Bacteria	Bacteria	102	1.2099999999999999e-23	NR	MAD57955.1	2024853	g5738	i0	50	6.69428571428571	112	54	96	2	339	4	108	217	MAD57955.1 electron transfer flavoprotein subunit alpha [Porticoccus sp.]	diamond	2343	102	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Porticoccaceae	Porticoccus	Porticoccus sp.
28036437	28036437	PRJNA951388_S_NODE_7765_length_304_cov_2.333333_g7638_i0	PRJNA951388	7765	304	2.333333	7.09333232	Thiogranum longum	1537524	Bacteria	Bacteria	50.1	5.68e-5	NR	WP_207891768.1	1537524	g7638	i0	27.7	1.54934210526316	94	64	92.8	1	19	300	52	141	WP_207891768.1 rhodanese-like domain-containing protein [Thiogranum longum]	diamond	471	50.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Ectothiorhodospiraceae	Thiogranum	Thiogranum longum
28636491	28636491	PRJNA951388_S_NODE_3967_length_408_cov_11.558209_g3840_i0	PRJNA951388	3967	408	11.558209	47.15749272	Limnobacter sp. 13	2003368	Bacteria	Bacteria	76.6	2.76e-13	NR	WP_159568531.1	2653147	g3840	i0	40.9	1.65441176470588	115	65	83.8	2	394	53	314	426	WP_159568531.1 thiolase family protein [Limnobacter sp. 130]	diamond	675	76.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter sp. 130
28920235	28920235	PRJNA951388_S_NODE_5508_length_360_cov_2.554007_g5381_i0	PRJNA951388	5508	360	2.554007	9.1944252	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	45.4	0.0139	NR	KAA3628728.1	1977087	g5381	i0	41	0.691666666666667	83	45	68.3	3	355	110	268	347	KAA3628728.1 MAG: heme A synthase [Pseudomonadota bacterium]	diamond	249	45.4	1	Bacteria		Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
29046819	29046819	PRJNA951388_S_NODE_4828_length_381_cov_1.000000_g4701_i0	PRJNA951388	4828	381	1	3.81	Agrobacterium tumefaciens	358	Bacteria	Bacteria	174	4.81e-53	NR	WP_146236589.1	358	g4701	i0	97	0.779527559055118	99	3	78	0	26	322	67	165	WP_146236589.1 hypothetical protein [Agrobacterium tumefaciens]	diamond	297	174	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Agrobacterium	Agrobacterium tumefaciens
29204762	29204762	PRJNA951388_S_NODE_6929_length_323_cov_3.416000_g6802_i0	PRJNA951388	6929	323	3.416	11.03368	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	206	1.1399999999999999e-62	NR	WP_245457824.1	28101	g6802	i0	97.2	0.993808049535604	107	3	99.4	0	322	2	2	108	WP_245457824.1 glycosyltransferase family 4 protein [Phyllobacterium myrsinacearum]	diamond	321	206	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
29330817	29330817	PRJNA951388_S_NODE_4209_length_400_cov_7.152905_g4082_i0	PRJNA951388	4209	400	7.152905	28.61162	endosymbiont of Galathealinum brachiosum	2200906	Bacteria	Bacteria	122	4.95e-32	NR	RDH84424.1	2200906	g4082	i0	49.2	1.83	122	57	91.5	1	400	35	96	212	RDH84424.1 MAG: pyridoxamine 5'-phosphate oxidase [endosymbiont of Galathealinum brachiosum]	diamond	732	122	1	Bacteria	sulfur-oxidizing symbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				endosymbiont of Galathealinum brachiosum
29905962	29905962	PRJNA951388_S_NODE_7011_length_321_cov_3.104839_g6884_i0	PRJNA951388	7011	321	3.104839	9.96653319	Pseudomonadati	3379134	Bacteria	Bacteria	112	4.44e-26	NR	WP_034842341.1	1137799	g6884	i0	58.7	12	104	38	97.2	2	314	3	219	317	WP_034842341.1 aminomethyl-transferring glycine dehydrogenase [Endozoicomonas numazuensis]	diamond	3852	112	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Endozoicomonadaceae	Endozoicomonas	Endozoicomonas numazuensis
30151719	30151719	PRJNA951388_S_NODE_12072_length_230_cov_2.777070_g11945_i0	PRJNA951388	12072	230	2.77707	6.387261	Halioglobus sp.	2024834	Bacteria	Bacteria	41.6	0.0338	NR	MEH6593323.1	2024834	g11945	i0	40.8	0.639130434782609	49	24	63.9	1	217	71	13	56	MEH6593323.1 hypothetical protein [Halioglobus sp.]	diamond	147	41.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Halieaceae	Halioglobus	Halioglobus sp.
30310480	30310480	PRJNA951388_S_NODE_9112_length_277_cov_2.377451_g8985_i0	PRJNA951388	9112	277	2.377451	6.58553927	Marinicella rhabdoformis	2580566	Bacteria	Bacteria	45.1	0.0087	NR	WP_154221932.1	2580566	g8985	i0	36.8	0.736462093862816	68	33	70.4	2	264	70	121	181	WP_154221932.1 M13 family metallopeptidase [Marinicella rhabdoformis]	diamond	204	45.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Marinicellaceae	Marinicella	Marinicella rhabdoformis
30878620	30878620	PRJNA951388_S_NODE_10534_length_253_cov_4.950000_g10407_i0	PRJNA951388	10534	253	4.95	12.5235	Rhizomicrobium sp.	1978228	Bacteria	Bacteria	43.5	0.0199	NR	HEX4532838.1	1978228	g10407	i0	51.4	1.71936758893281	37	18	43.9	0	2	112	87	123	HEX4532838.1 hypothetical protein [Rhizomicrobium sp.]	diamond	435	43.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Micropepsales	Micropepsaceae	Rhizomicrobium	Rhizomicrobium sp.
31454354	31454354	PRJNA951388_S_NODE_8876_length_281_cov_4.754808_g8749_i0	PRJNA951388	8876	281	4.754808	13.36101048	Bacteria	2	Bacteria	Bacteria	54.7	3.61e-6	NR	WP_124022842.1	82993	g8749	i0	57.1	12.1494661921708	42	18	44.8	0	74	199	12	53	WP_124022842.1 alpha-amylase family protein [Buttiauxella warmboldiae]	diamond	3414	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Buttiauxella	Buttiauxella warmboldiae
31763941	31763941	PRJNA951388_S_NODE_2497_length_477_cov_46.049505_g2370_i0	PRJNA951388	2497	477	46.049505	219.65613885	Methylocella sp. CPCC 1	1978226	Bacteria	Bacteria	45.8	0.0319	NR	WP_311850367.1	2987531	g2370	i0	30.1	0.647798742138365	103	51	64.2	3	401	96	201	283	WP_311850367.1 ABC transporter permease [Methylocella sp. CPCC 101449]	diamond	309	45.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Beijerinckiaceae	Methylocella	Methylocella sp. CPCC 101449
31770472	31770472	PRJNA951388_S_NODE_1797_length_530_cov_32.765864_g1675_i0	PRJNA951388	1797	530	32.765864	173.6590792	Bacteria	2	Bacteria	Bacteria	131	1.7900000000000002e-33	NR	WP_090960727.1	1855334	g1675	i0	47.7	2.64339622641509	153	75	86.6	2	1	459	175	322	WP_090960727.1 malate dehydrogenase [Nitrosospira sp. Nsp18]	diamond	1401	132	0.992424242424242	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Nitrosomonadaceae	Nitrosospira	Nitrosospira sp. Nsp18
32491830	32491830	PRJNA951388_S_NODE_6619_length_330_cov_3.000000_g6492_i0	PRJNA951388	6619	330	3	9.9	Reyranella sp.	1929291	Bacteria	Bacteria	149	1.45e-39	NR	WP_395713281.1	1929291	g6492	i0	76.6	5.26363636363636	94	22	85.5	0	285	4	8	101	WP_395713281.1 acetyl-CoA carboxylase biotin carboxylase subunit [Reyranella sp.]	diamond	1737	149	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Reyranellaceae	Reyranella	Reyranella sp.
32586661	32586661	PRJNA951388_S_NODE_7339_length_314_cov_2.161826_g7212_i0	PRJNA951388	7339	314	2.161826	6.78813364	Marinobacter sp. es.	50741	Bacteria	Bacteria	75.9	1.97e-13	NR	WP_088827542.1	1761795	g7212	i0	36.7	5.18789808917197	109	64	99.4	2	3	314	496	604	WP_088827542.1 long-chain-acyl-CoA synthetase [Marinobacter sp. es.048]	diamond	1629	75.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Marinobacteraceae	Marinobacter	Marinobacter sp. es.048

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