metadata: contig_metadata: 35 rows where analysis = "diamond", bioproject = "PRJNA764222" and tax

35 rows where analysis = "diamond", bioproject = "PRJNA764222" and tax_phylum = "Bacteroidota"

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
3757509	3757509	PRJNA764222_S_NODE_1663_length_453_cov_4.147783_g1505_i0	PRJNA764222	1663	453	4.147783	18.78945699	Aureivirga marina	1182451	Bacteria	Bacteria	145	5.4e-39	NR	WP_196895326.1	1182451	g1505	i0	48.9	4.52317880794702	139	68	90.1	1	428	21	228	366	WP_196895326.1 glycosyltransferase [Aureivirga marina]	diamond	2049	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureivirga	Aureivirga marina
26619614	26619614	PRJNA764222_S_NODE_27141_length_180_cov_1.473684_g26983_i0	PRJNA764222	27141	180	1.473684	2.6526312	Prevotella	838	Bacteria	Bacteria	112	1.3e-29	NR	MFC2489204.1	59823	g26983	i0	96.6	2.95	59	2	98.3	0	178	2	51	109	MFC2489204.1 lipocalin-like domain-containing protein [Prevotella sp.]	diamond	531	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
26958088	26958088	PRJNA764222_S_NODE_18382_length_217_cov_1.500000_g18224_i0	PRJNA764222	18382	217	1.5	3.255	Myroides odoratimimus	76832	Bacteria	Bacteria	129	1.2699999999999998e-35	NR	WP_286393428.1	76832	g18224	i0	94.4	0.995391705069124	72	4	99.5	0	217	2	81	152	WP_286393428.1 BfmA/BtgA family mobilization protein [Myroides odoratimimus]	diamond	216	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
27306213	27306213	PRJNA764222_S_NODE_19103_length_213_cov_2.777108_g18945_i0	PRJNA764222	19103	213	2.777108	5.91524004	Prevotella sp.	59823	Bacteria	Bacteria	130	9.169999999999999e-35	NR	MBQ7424469.1	59823	g18945	i0	90.1	1	71	7	100	0	1	213	195	265	MBQ7424469.1 toprim domain-containing protein [Prevotella sp.]	diamond	213	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
27527142	27527142	PRJNA764222_S_NODE_8423_length_275_cov_1.785088_g8265_i0	PRJNA764222	8423	275	1.785088	4.908992	Bacteroidales bacterium	2030927	Bacteria	Bacteria	158	3.8e-44	NR	MBR5499397.1	2030927	g8265	i0	82.4	0.992727272727273	91	16	99.3	0	274	2	53	143	MBR5499397.1 FtsW/RodA/SpoVE family cell cycle protein [Bacteroidales bacterium]	diamond	273	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27590519	27590519	PRJNA764222_S_NODE_29824_length_170_cov_1.634146_g29666_i0	PRJNA764222	29824	170	1.634146	2.7780482	Bacteroidales bacterium	2030927	Bacteria	Bacteria	107	1.7e-25	NR	MBQ6755090.1	2030927	g29666	i0	98.2	0.988235294117647	56	1	98.8	0	170	3	56	111	MBQ6755090.1 leucine-rich repeat domain-containing protein [Bacteroidales bacterium]	diamond	168	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27717014	27717014	PRJNA764222_S_NODE_18664_length_215_cov_3.035714_g18506_i0	PRJNA764222	18664	215	3.035714	6.5267851	Cloacibacterium rupense	517423	Bacteria	Bacteria	128	3.92e-36	NR	WP_188616715.1	517423	g18506	i0	93	0.990697674418605	71	5	99.1	0	215	3	50	120	WP_188616715.1 Hsp20/alpha crystallin family protein [Cloacibacterium rupense]	diamond	213	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium rupense
27758121	27758121	PRJNA764222_S_NODE_25744_length_185_cov_2.239130_g25586_i0	PRJNA764222	25744	185	2.23913	4.1423905	Cyclobacteriaceae	563798	Bacteria	Bacteria	106	5.75e-26	NR	MCE2776392.1	1872435	g25586	i0	84.5	2.87027027027027	58	9	94.1	0	174	1	252	309	MCE2776392.1 glycosyltransferase family 2 protein [Algoriphagus sp.]	diamond	531	107	0.990654205607477	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sp.
27779888	27779888	PRJNA764222_S_NODE_1324_length_510_cov_3.133909_g1172_i0	PRJNA764222	1324	510	3.133909	15.9829359	Panacibacter sp.	1874622	Bacteria	Bacteria	105	2.48e-24	NR	MEP6844369.1	1874622	g1172	i0	46.3	0.8	136	65	78.2	4	415	17	62	192	MEP6844369.1 hypothetical protein [Panacibacter sp.]	diamond	408	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter sp.
27905771	27905771	PRJNA764222_S_NODE_6785_length_289_cov_2.776860_g6627_i0	PRJNA764222	6785	289	2.77686	8.0251254	Bacteroidales bacterium	2030927	Bacteria	Bacteria	44.7	0.0109	NR	MCQ2327712.1	2030927	g6627	i0	46.5	0.44636678200692	43	23	44.6	0	192	64	188	230	MCQ2327712.1 endonuclease/exonuclease/phosphatase family protein [Bacteroidales bacterium]	diamond	129	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28158884	28158884	PRJNA764222_S_NODE_6065_length_297_cov_1.216000_g5907_i0	PRJNA764222	6065	297	1.216	3.61152	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	143	9.85e-41	NR	MBO7294913.1	2212467	g5907	i0	100	1.41414141414141	70	0	70.7	0	88	297	1	70	MBO7294913.1 SDR family NAD(P)-dependent oxidoreductase [Bacteroidaceae bacterium]	diamond	420	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
28853055	28853055	PRJNA764222_S_NODE_15448_length_231_cov_1.679348_g15290_i0	PRJNA764222	15448	231	1.679348	3.87929388	Prevotella sp.	59823	Bacteria	Bacteria	61.2	8.31e-10	NR	MBQ2951659.1	59823	g15290	i0	71.8	0.506493506493506	39	11	50.6	0	117	1	1	39	MBQ2951659.1 hypothetical protein [Prevotella sp.]	diamond	117	61.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
28948238	28948238	PRJNA764222_S_NODE_25748_length_185_cov_2.231884_g25590_i0	PRJNA764222	25748	185	2.231884	4.1289854	Cecembia lonarensis	645110	Bacteria	Bacteria	114	1.86e-28	NR	WP_009183171.1	645110	g25590	i0	91.8	0.989189189189189	61	5	98.9	0	185	3	314	374	WP_009183171.1 hypothetical protein [Cecembia lonarensis]	diamond	183	114	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia lonarensis
28948240	28948240	PRJNA764222_S_NODE_32128_length_163_cov_1.732759_g31970_i0	PRJNA764222	32128	163	1.732759	2.82439717	Bacteroidales bacterium	2030927	Bacteria	Bacteria	47	4.84e-5	NR	MCQ2327714.1	2030927	g31970	i0	71.4	0.644171779141104	35	10	64.4	0	107	3	2	36	MCQ2327714.1 hypothetical protein [Bacteroidales bacterium]	diamond	105	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29516150	29516150	PRJNA764222_S_NODE_25030_length_188_cov_1.808511_g24872_i0	PRJNA764222	25030	188	1.808511	3.40000068	Cloacibacterium sp.	1913682	Bacteria	Bacteria	99.8	2.4699999999999994e-23	NR	MBP7357097.1	1913682	g24872	i0	77.4	1.97872340425532	62	14	98.9	0	3	188	42	103	MBP7357097.1 ABC transporter substrate-binding protein [Cloacibacterium sp.]	diamond	372	99.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium sp.
29526035	29526035	PRJNA764222_S_NODE_22830_length_197_cov_1.700000_g22672_i0	PRJNA764222	22830	197	1.7	3.349	Bacteroides	816	Bacteria	Bacteria	128	1.3599999999999999e-34	NR	MBQ8239596.1	29523	g22672	i0	96.9	4.9492385786802	65	2	99	0	196	2	22	86	MBQ8239596.1 pyruvate, phosphate dikinase [Bacteroides sp.]	diamond	975	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
29588752	29588752	PRJNA764222_S_NODE_23390_length_195_cov_1.060811_g23232_i0	PRJNA764222	23390	195	1.060811	2.06858145	Flavobacteriaceae	49546	Bacteria	Bacteria	90.9	4.84e-20	NR	WP_298223674.1	239	g23232	i0	64.5	14.4307692307692	62	22	95.4	0	191	6	122	183	WP_298223674.1 ABC transporter ATP-binding protein [Flavobacterium sp.]	diamond	2814	90.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
29895348	29895348	PRJNA764222_S_NODE_27511_length_178_cov_2.396947_g27353_i0	PRJNA764222	27511	178	2.396947	4.26656566	Belliella baltica DSM 15883	866536	Bacteria	Bacteria	44.3	6.36e-4	NR	AFL84240.1	866536	g27353	i0	51.4	0.589887640449438	35	16	59	1	6	110	27	60	AFL84240.1 hypothetical protein Belba_1634 [Belliella baltica DSM 15883]	diamond	105	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Belliella	Belliella baltica
30053078	30053078	PRJNA764222_S_NODE_17511_length_221_cov_1.241379_g17353_i0	PRJNA764222	17511	221	1.241379	2.74344759	Parabacteroides sp.	1869337	Bacteria	Bacteria	50.8	3.13e-5	NR	MCD8242841.1	1869337	g17353	i0	45.8	0.65158371040724	48	26	65.2	0	3	146	108	155	MCD8242841.1 class I SAM-dependent methyltransferase [Parabacteroides sp.]	diamond	144	50.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides sp.
30116274	30116274	PRJNA764222_S_NODE_13992_length_238_cov_8.607330_g13834_i0	PRJNA764222	13992	238	8.60733	20.4854454	Chitinophagales bacterium	2448779	Bacteria	Bacteria	42.7	0.0348	NR	MBP7476988.1	2448779	g13834	i0	33.3	0.831932773109244	66	35	74.4	2	35	211	93	156	MBP7476988.1 hypothetical protein [Chitinophagales bacterium]	diamond	198	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
30369634	30369634	PRJNA764222_S_NODE_10092_length_262_cov_2.441860_g9934_i0	PRJNA764222	10092	262	2.44186	6.3976732	Bacteroidales bacterium	2030927	Bacteria	Bacteria	140	2.05e-36	NR	MBQ4420693.1	2030927	g9934	i0	100	0.847328244274809	74	0	84.7	0	2	223	615	688	MBQ4420693.1 T9SS type A sorting domain-containing protein [Bacteroidales bacterium]	diamond	222	140	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31064499	31064499	PRJNA764222_S_NODE_10155_length_262_cov_1.576744_g9997_i0	PRJNA764222	10155	262	1.576744	4.13106928	Prevotella sp.	59823	Bacteria	Bacteria	106	2.3700000000000003e-27	NR	MBD9300280.1	59823	g9997	i0	58	1.87786259541985	81	34	92.7	0	9	251	23	103	MBD9300280.1 endonuclease [Prevotella sp.]	diamond	492	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
31380553	31380553	PRJNA764222_S_NODE_6676_length_290_cov_2.975309_g6518_i0	PRJNA764222	6676	290	2.975309	8.6283961	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.5	0.0221	NR	MDP4291576.1	1898104	g6518	i0	36.5	0.537931034482759	52	32	52.8	1	213	61	122	173	MDP4291576.1 YqgE/AlgH family protein [Bacteroidota bacterium]	diamond	156	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31390194	31390194	PRJNA764222_S_NODE_7876_length_279_cov_3.129310_g7718_i0	PRJNA764222	7876	279	3.12931	8.7307749	root	1	Root_unresolved	Root_unresolved	110	9.18e-26	NR	MBR4591326.1	2212467	g7718	i0	62.5	6.51612903225806	88	33	94.6	0	4	267	760	847	MBR4591326.1 PHP domain-containing protein [Bacteroidaceae bacterium]	diamond	1818	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
31516755	31516755	PRJNA764222_S_NODE_20216_length_208_cov_2.527950_g20058_i0	PRJNA764222	20216	208	2.52795	5.258136	Cloacibacterium	501783	Bacteria	Bacteria	134	3.07e-36	NR	WP_188618685.1	517423	g20058	i0	86.8	2.94230769230769	68	9	98.1	0	3	206	41	108	WP_188618685.1 glycosyltransferase family 1 protein [Cloacibacterium rupense]	diamond	612	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium rupense
31570422	31570422	PRJNA764222_S_NODE_33356_length_157_cov_2.290909_g33198_i0	PRJNA764222	33356	157	2.290909	3.59672713	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	70.9	1.4e-12	NR	MBQ6800376.1	2212467	g33198	i0	64.7	0.974522292993631	51	18	97.5	0	4	156	91	141	MBQ6800376.1 AAA family ATPase [Bacteroidaceae bacterium]	diamond	153	70.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
31664950	31664950	PRJNA764222_S_NODE_21697_length_202_cov_1.296774_g21539_i0	PRJNA764222	21697	202	1.296774	2.61948348	Bacteroidales	171549	Bacteria	Bacteria	129	1.02e-32	NR	WP_118058669.1	171549	g21539	i0	92.4	2.97029702970297	66	5	98	0	2	199	61	126	WP_118058669.1 MULTISPECIES: TrlF family AAA-like ATPase [Bacteroidales]	diamond	600	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales
31759924	31759924	PRJNA764222_S_NODE_28657_length_174_cov_1.622047_g28499_i0	PRJNA764222	28657	174	1.622047	2.82236178	Cecembia lonarensis	645110	Bacteria	Bacteria	103	4.6e-27	NR	WP_009183117.1	645110	g28499	i0	89.5	0.982758620689655	57	6	98.3	0	172	2	35	91	WP_009183117.1 hypothetical protein [Cecembia lonarensis]	diamond	171	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia lonarensis
31823080	31823080	PRJNA764222_S_NODE_12937_length_244_cov_3.060914_g12779_i0	PRJNA764222	12937	244	3.060914	7.46863016	Bacteroidales bacterium	2030927	Bacteria	Bacteria	97.8	1.5300000000000002e-21	NR	MBQ7238624.1	2030927	g12779	i0	59.5	0.971311475409836	79	32	97.1	0	3	239	329	407	MBQ7238624.1 TonB-dependent receptor [Bacteroidales bacterium]	diamond	237	97.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31854777	31854777	PRJNA764222_S_NODE_19557_length_211_cov_2.743902_g19399_i0	PRJNA764222	19557	211	2.743902	5.78963322	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	42.7	0.0248	NR	MCF8202174.1	2026728	g19399	i0	37	0.767772511848341	54	32	76.8	1	173	12	1765	1816	MCF8202174.1 hypothetical protein [Crocinitomicaceae bacterium]	diamond	162	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
31854783	31854783	PRJNA764222_S_NODE_30217_length_169_cov_0.885246_g30059_i0	PRJNA764222	30217	169	0.885246	1.49606574	Bacteroides sp.	29523	Bacteria	Bacteria	84.3	2.64e-18	NR	MBQ8673559.1	29523	g30059	i0	81.8	0.781065088757396	44	8	78.1	0	2	133	129	172	MBQ8673559.1 hypothetical protein [Bacteroides sp.]	diamond	132	84.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
32519574	32519574	PRJNA764222_S_NODE_12939_length_244_cov_3.010152_g12781_i0	PRJNA764222	12939	244	3.010152	7.34477088	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	77.8	1.65e-14	NR	MBO7230110.1	2212467	g12781	i0	100	0.454918032786885	37	0	45.5	0	3	113	605	641	MBO7230110.1 hypothetical protein [Bacteroidaceae bacterium]	diamond	111	77.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
32614005	32614005	PRJNA764222_S_NODE_13820_length_239_cov_3.739583_g13662_i0	PRJNA764222	13820	239	3.739583	8.93760337	Bacteroidales bacterium	2030927	Bacteria	Bacteria	76.3	3.91e-15	NR	MBQ8838347.1	2030927	g13662	i0	94.7	0.95397489539749	38	2	47.7	0	239	126	139	176	MBQ8838347.1 ABC transporter ATP-binding protein [Bacteroidales bacterium]	diamond	228	76.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32843899	32843899	PRJNA764222_S_NODE_10540_length_259_cov_2.245283_g10382_i0	PRJNA764222	10540	259	2.245283	5.81528297	Cyclobacteriaceae	563798	Bacteria	Bacteria	158	1.9899999999999992e-43	NR	WP_009033700.1	579922	g10382	i0	90.7	7.96911196911197	86	8	99.6	0	1	258	148	233	WP_009033700.1 sodium:solute symporter [Indibacter alkaliphilus]	diamond	2064	159	0.993710691823899	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Indibacter	Indibacter alkaliphilus
32865836	32865836	PRJNA764222_S_NODE_11340_length_254_cov_1.705314_g11182_i0	PRJNA764222	11340	254	1.705314	4.33149756	Cecembia lonarensis	645110	Bacteria	Bacteria	162	3.1099999999999995e-48	NR	WP_009186065.1	645110	g11182	i0	94	0.992125984251969	84	5	99.2	0	253	2	122	205	WP_009186065.1 carbonic anhydrase [Cecembia lonarensis]	diamond	252	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia lonarensis

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