metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA1264536" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA1264536" and tax_kingdom = "Pseudomonadati"

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
1638726	1638726	PRJNA1264536_P_NODE_2802_length_334_cov_1.191571_g2728_i0	PRJNA1264536	2802	334	1.191571	3.97984714	Salmonella sp. s51228	3159652	Bacteria	Bacteria	152	1.1599999999999999e-43	NR	WP_411022868.1	3159652	g2728	i0	67.6	13.6437125748503	108	35	97	0	334	11	53	160	WP_411022868.1 GTP-binding protein [Salmonella sp. s51228]	diamond	4557	152	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella sp. s51228
1638777	1638777	PRJNA1264536_P_NODE_5262_length_244_cov_0.912281_g5188_i0	PRJNA1264536	5262	244	0.912281	2.22596564	Aquabacterium sp.	1872578	Bacteria	Bacteria	159	1.7599999999999998e-46	NR	HET6788839.1	1872578	g5188	i0	92.5	5.9016393442623	80	6	98.4	0	242	3	48	127	HET6788839.1 D-alanyl-D-alanine carboxypeptidase family protein [Aquabacterium sp.]	diamond	1440	159	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp.
1638782	1638782	PRJNA1264536_P_NODE_5442_length_243_cov_0.888235_g5368_i0	PRJNA1264536	5442	243	0.888235	2.15841105	Odoribacter sp.	1965233	Bacteria	Bacteria	154	5.079999999999999e-43	NR	MDE7074187.1	1965233	g5368	i0	90	3.95061728395062	80	8	98.8	0	241	2	86	165	MDE7074187.1 IMP dehydrogenase [Odoribacter sp.]	diamond	960	154	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Odoribacteraceae	Odoribacter	Odoribacter sp.
2329327	2329327	PRJNA1264536_P_NODE_5322_length_244_cov_0.912281_g5248_i0	PRJNA1264536	5322	244	0.912281	2.22596564	Candidatus Acidiferrales bacterium	2952895	Bacteria	Bacteria	134	2.38e-34	NR	HKQ88412.1	2952895	g5248	i0	77.8	10.9549180327869	81	18	99.6	0	2	244	475	555	HKQ88412.1 efflux RND transporter permease subunit [Candidatus Acidiferrales bacterium]	diamond	2673	134	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales			Candidatus Acidiferrales bacterium
14393102	14393102	PRJNA1264536_P_NODE_5112_length_246_cov_0.901734_g5038_i0	PRJNA1264536	5112	246	0.901734	2.21826564	Planctomycetia	203683	Bacteria	Bacteria	114	5.77e-28	NR	HWG41202.1	2052164	g5038	i0	91.8	4.48780487804878	61	5	74.4	0	185	3	1	61	HWG41202.1 serine hydroxymethyltransferase [Gemmataceae bacterium]	diamond	1104	114	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
18215650	18215650	PRJNA1264536_P_NODE_4595_length_251_cov_0.876404_g4521_i0	PRJNA1264536	4595	251	0.876404	2.19977404	Hanamia sp.	2930256	Bacteria	Bacteria	166	2.81e-46	NR	HXS57568.1	2930256	g4521	i0	90.4	3.9681274900398402	83	8	99.2	0	250	2	383	465	HXS57568.1 alpha/beta hydrolase-fold protein [Hanamia sp.]	diamond	996	166	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hanamia	Hanamia sp.
20765493	20765493	PRJNA1264536_P_NODE_4877_length_248_cov_0.891429_g4803_i0	PRJNA1264536	4877	248	0.891429	2.21074392	Rhodospirillaceae bacterium	1898112	Bacteria	Bacteria	126	8.99e-33	NR	MEQ9448422.1	1898112	g4803	i0	77.9	2.86693548387097	77	17	93.1	0	231	1	144	220	MEQ9448422.1 acyl-CoA dehydrogenase family protein [Rhodospirillaceae bacterium]	diamond	711	126	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Rhodospirillaceae		Rhodospirillaceae bacterium
26630762	26630762	PRJNA1264536_P_NODE_5081_length_246_cov_0.901734_g5007_i0	PRJNA1264536	5081	246	0.901734	2.21826564	Terriglobales bacterium	2282142	Bacteria	Bacteria	70.1	1.96e-12	NR	HUE52513.1	2282142	g5007	i0	73.8	0.51219512195122	42	11	51.2	0	245	120	172	213	HUE52513.1 hypothetical protein [Terriglobales bacterium]	diamond	126	70.1	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
27136682	27136682	PRJNA1264536_P_NODE_5242_length_244_cov_1.771930_g5168_i0	PRJNA1264536	5242	244	1.77193	4.3235092	Pirellulales bacterium	2715253	Bacteria	Bacteria	48.1	4.61e-4	NR	HEX4146591.1	2715253	g5168	i0	38.8	0.823770491803279	67	40	82.4	1	42	242	19	84	HEX4146591.1 DUF2092 domain-containing protein [Pirellulales bacterium]	diamond	201	48.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
27200104	27200104	PRJNA1264536_P_NODE_5502_length_242_cov_0.923077_g5428_i0	PRJNA1264536	5502	242	0.923077	2.23384634	Roseiarcus sp.	1969460	Bacteria	Bacteria	55.5	1.22e-6	NR	HTR12120.1	1969460	g5428	i0	71.8	0.483471074380165	39	11	48.3	0	125	241	260	298	HTR12120.1 PAS domain S-box protein [Roseiarcus sp.]	diamond	117	55.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Roseiarcaceae	Roseiarcus	Roseiarcus sp.
27831957	27831957	PRJNA1264536_P_NODE_5424_length_243_cov_0.917647_g5350_i0	PRJNA1264536	5424	243	0.917647	2.22988221	Bacteroides sp.	29523	Bacteria	Bacteria	143	2.93e-38	NR	MBP3669283.1	29523	g5350	i0	92.5	0.987654320987654	80	6	98.8	0	242	3	399	478	MBP3669283.1 ComEC/Rec2 family competence protein [Bacteroides sp.]	diamond	240	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
27989978	27989978	PRJNA1264536_P_NODE_5305_length_244_cov_0.912281_g5231_i0	PRJNA1264536	5305	244	0.912281	2.22596564	Bacteroidales bacterium	2030927	Bacteria	Bacteria	80.9	5.15e-16	NR	MFO7844437.1	2030927	g5231	i0	48.1	0.995901639344262	81	42	99.6	0	2	244	199	279	MFO7844437.1 hypothetical protein [Bacteroidales bacterium]	diamond	243	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28495216	28495216	PRJNA1264536_P_NODE_4607_length_251_cov_0.876404_g4533_i0	PRJNA1264536	4607	251	0.876404	2.19977404	Terriglobales bacterium	2282142	Bacteria	Bacteria	123	8.169999999999998e-31	NR	HUK87135.1	2282142	g4533	i0	78.6	1.00398406374502	84	16	99.2	2	3	251	129	211	HUK87135.1 AsmA family protein [Terriglobales bacterium]	diamond	252	123	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
28684713	28684713	PRJNA1264536_P_NODE_5547_length_242_cov_0.923077_g5473_i0	PRJNA1264536	5547	242	0.923077	2.23384634	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	122	5.86e-34	NR	MDE3016639.1	1977087	g5473	i0	68.4	0.979338842975207	79	25	97.9	0	3	239	32	110	MDE3016639.1 hypothetical protein [Pseudomonadota bacterium]	diamond	237	122	1	Bacteria		Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
28860087	28860087	PRJNA1264536_P_NODE_4788_length_249_cov_0.886364_g4714_i0	PRJNA1264536	4788	249	0.886364	2.20704636	Alphaproteobacteria	28211	Bacteria	Bacteria	115	1.42e-30	NR	MEA3070562.1	1913988	g4714	i0	76.9	9.39759036144578	78	18	94	0	6	239	20	97	MEA3070562.1 hypothetical protein [Alphaproteobacteria bacterium]	diamond	2340	115	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
29126804	29126804	PRJNA1264536_P_NODE_5489_length_242_cov_0.923077_g5415_i0	PRJNA1264536	5489	242	0.923077	2.23384634	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	50.4	4.87e-6	NR	MFO7863651.1	2053305	g5415	i0	53.3	0.557851239669422	45	21	55.8	0	51	185	29	73	MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium]	diamond	135	50.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae bacterium
29315985	29315985	PRJNA1264536_P_NODE_4649_length_250_cov_0.881356_g4575_i0	PRJNA1264536	4649	250	0.881356	2.20339	Akkermansia sp.	1872421	Bacteria	Bacteria	60.1	3.19e-8	NR	MBQ8517079.1	1872421	g4575	i0	71.7	0.552	46	13	55.2	0	138	1	1	46	MBQ8517079.1 hypothetical protein [Akkermansia sp.]	diamond	138	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
29820940	29820940	PRJNA1264536_P_NODE_5431_length_243_cov_0.917647_g5357_i0	PRJNA1264536	5431	243	0.917647	2.22988221	Terriglobales bacterium	2282142	Bacteria	Bacteria	106	1.66e-25	NR	HZT74101.1	2282142	g5357	i0	75.7	0.91358024691358	74	18	91.4	0	223	2	178	251	HZT74101.1 ABC transporter permease [Terriglobales bacterium]	diamond	222	106	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
30471043	30471043	PRJNA1264536_P_NODE_5273_length_244_cov_0.912281_g5199_i0	PRJNA1264536	5273	244	0.912281	2.22596564	FCB group	1783270	Bacteria	Bacteria	42.7	0.00533	NR	WP_289539213.1	376804	g5199	i0	44.7	1.81967213114754	38	21	46.7	0	239	126	15	52	WP_289539213.1 hypothetical protein [Phocaeicola barnesiae]	diamond	444	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola barnesiae
30579187	30579187	PRJNA1264536_P_NODE_5133_length_246_cov_0.809249_g5059_i0	PRJNA1264536	5133	246	0.809249	1.99075254	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	50.8	3.69e-6	NR	MFO7863651.1	2053305	g5059	i0	57.8	0.548780487804878	45	19	54.9	0	55	189	29	73	MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium]	diamond	135	50.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae bacterium
31559457	31559457	PRJNA1264536_P_NODE_4436_length_252_cov_0.871508_g4362_i0	PRJNA1264536	4436	252	0.871508	2.19620016	Candidatus Acidiferrum sp.	3069120	Bacteria	Bacteria	46.2	0.00208	NR	HVM46498.1	3069120	g4362	i0	63.6	0.392857142857143	33	11	39.3	1	153	251	1	32	HVM46498.1 hypothetical protein [Candidatus Acidiferrum sp.]	diamond	99	46.2	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Candidatus Acidiferrales		Candidatus Acidiferrum	Candidatus Acidiferrum sp.
31622450	31622450	PRJNA1264536_P_NODE_5516_length_242_cov_0.923077_g5442_i0	PRJNA1264536	5516	242	0.923077	2.23384634	Escherichia coli	562	Bacteria	Bacteria	87.8	4.17e-18	NR	WP_286497621.1	562	g5442	i0	73.2	0.694214876033058	56	15	69.4	0	168	1	78	133	WP_286497621.1 DDE-type integrase/transposase/recombinase [Escherichia coli]	diamond	168	87.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31843797	31843797	PRJNA1264536_P_NODE_4657_length_250_cov_0.881356_g4583_i0	PRJNA1264536	4657	250	0.881356	2.20339	Geobacteraceae bacterium	2282154	Bacteria	Bacteria	81.6	1.62e-16	NR	HET6420541.1	2282154	g4583	i0	77.8	0.648	54	12	64.8	0	248	87	205	258	HET6420541.1 dihydrolipoamide acetyltransferase family protein [Geobacteraceae bacterium]	diamond	162	81.6	1	Bacteria		Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae		Geobacteraceae bacterium
31875409	31875409	PRJNA1264536_P_NODE_3637_length_288_cov_1.381395_g3563_i0	PRJNA1264536	3637	288	1.381395	3.9784176	Bacteroidota bacterium	1898104	Bacteria	Bacteria	68.9	1.24e-12	NR	REK64910.1	1898104	g3563	i0	63.8	0.489583333333333	47	17	49	0	286	146	67	113	REK64910.1 MAG: hypothetical protein DWQ49_01035, partial [Bacteroidota bacterium]	diamond	141	68.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32318852	32318852	PRJNA1264536_P_NODE_4899_length_248_cov_0.891429_g4825_i0	PRJNA1264536	4899	248	0.891429	2.21074392	Candidatus Sulfopaludibacter sp.	2963552	Bacteria	Bacteria	96.3	5.77e-21	NR	HWC97358.1	2963552	g4825	i0	68.5	0.883064516129032	73	20	87.1	2	219	4	1	71	HWC97358.1 alpha/beta hydrolase-fold protein [Candidatus Sulfopaludibacter sp.]	diamond	219	96.3	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Sulfopaludibacter	Candidatus Sulfopaludibacter sp.
32350378	32350378	PRJNA1264536_P_NODE_5199_length_245_cov_0.906977_g5125_i0	PRJNA1264536	5199	245	0.906977	2.22209365	Betaproteobacteria bacterium	1891241	Bacteria	Bacteria	159	7.29e-48	NR	MBU6304130.1	1891241	g5125	i0	93.8	0.991836734693878	81	5	99.2	0	245	3	18	98	MBU6304130.1 VOC family protein [Betaproteobacteria bacterium]	diamond	243	159	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria				Betaproteobacteria bacterium
32666022	32666022	PRJNA1264536_P_NODE_3760_length_281_cov_1.384615_g3686_i0	PRJNA1264536	3760	281	1.384615	3.89076815	Tepidisphaerales bacterium	2795155	Bacteria	Bacteria	184	9.42e-52	NR	MFI5381108.1	2795155	g3686	i0	87.1	2.97864768683274	93	12	99.3	0	2	280	577	669	MFI5381108.1 hypothetical protein [Tepidisphaerales bacterium]	diamond	837	184	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales			Tepidisphaerales bacterium
32854914	32854914	PRJNA1264536_P_NODE_4680_length_250_cov_0.881356_g4606_i0	PRJNA1264536	4680	250	0.881356	2.20339	Salinivirgaceae bacterium	2053305	Bacteria	Bacteria	41.2	0.0218	NR	MFO7863651.1	2053305	g4606	i0	81.8	0.264	22	4	26.4	0	3	68	52	73	MFO7863651.1 hypothetical protein [Salinivirgaceae bacterium]	diamond	66	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Salinivirgaceae		Salinivirgaceae 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);;