metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJNA870096" and tax

30 rows where analysis = "diamond", bioproject = "PRJNA870096" 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
12329405	12329405	PRJNA870096_S_NODE_58430_length_230_cov_1.026738_g56766_i0	PRJNA870096	58430	230	1.026738	2.3614974	Flavobacterium sp.	239	Bacteria	Bacteria	132	2.9399999999999996e-37	NR	WP_300977051.1	239	g56766	i0	89.5	0.991304347826087	76	8	99.1	0	3	230	100	175	WP_300977051.1 ExbD/TolR family protein [Flavobacterium sp.]	diamond	228	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
18701163	18701163	PRJNA870096_S_NODE_142935_length_151_cov_1.046296_g141271_i0	PRJNA870096	142935	151	1.046296	1.57990696	Bacteroidota	976	Bacteria	Bacteria	89.4	4.01e-19	NR	MCG8476851.1	2053541	g141271	i0	82	10.7682119205298	50	9	99.3	0	151	2	478	527	MCG8476851.1 aspartate--tRNA ligase [Cytophagales bacterium]	diamond	1626	89.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium
19088853	19088853	PRJNA870096_S_NODE_83095_length_193_cov_0.960000_g81431_i0	PRJNA870096	83095	193	0.96	1.8528	Bacteroidetes bacterium RIFCSPLOWO2_12_FULL_37_12	1797365	Bacteria	Bacteria	75.9	3.82e-14	NR	OFY71298.1	1797365	g81431	i0	64.6	3.01554404145078	65	21	99.5	2	1	192	329	392	OFY71298.1 MAG: saccharopine dehydrogenase [Bacteroidetes bacterium RIFCSPLOWO2_12_FULL_37_12]	diamond	582	75.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium RIFCSPLOWO2_12_FULL_37_12
26738229	26738229	PRJNA870096_S_NODE_84901_length_191_cov_0.972973_g83237_i0	PRJNA870096	84901	191	0.972973	1.85837843	Flavobacterium sp.	239	Bacteria	Bacteria	82.8	7.42e-19	NR	MCU0349639.1	239	g83237	i0	74.5	1.72774869109948	55	14	86.4	0	3	167	40	94	MCU0349639.1 NADH-quinone oxidoreductase subunit NuoK [Flavobacterium sp.]	diamond	330	82.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
26801929	26801929	PRJNA870096_S_NODE_101621_length_175_cov_1.916667_g99957_i0	PRJNA870096	101621	175	1.916667	3.35416725	Bacteroidales bacterium	2030927	Bacteria	Bacteria	71.2	6.75e-13	NR	MBQ5575953.1	2030927	g99957	i0	61.7	2.41714285714286	47	18	80.6	0	143	3	219	265	MBQ5575953.1 glutamine--tRNA ligase [Bacteroidales bacterium]	diamond	423	71.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27086880	27086880	PRJNA870096_S_NODE_48862_length_252_cov_1.837321_g47198_i0	PRJNA870096	48862	252	1.837321	4.63004892	Bacteroidales bacterium	2030927	Bacteria	Bacteria	61.6	7.85e-10	NR	MFQ3579520.1	2030927	g47198	i0	45.3	0.761904761904762	64	35	76.2	0	2	193	57	120	MFQ3579520.1 response regulator [Bacteroidales bacterium]	diamond	192	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27537277	27537277	PRJNA870096_S_NODE_144723_length_150_cov_1.794393_g143059_i0	PRJNA870096	144723	150	1.794393	2.6915895	Bacteria	2	Bacteria	Bacteria	58.5	1.96e-9	NR	WP_298360625.1	1960881	g143059	i0	57.1	1.96	49	20	98	1	150	4	37	84	WP_298360625.1 DUF952 domain-containing protein [Runella sp.]	diamond	294	58.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp.
27939706	27939706	PRJNA870096_S_NODE_113285_length_167_cov_1.161290_g111621_i0	PRJNA870096	113285	167	1.16129	1.9393543	Flavobacterium sp. LM5	1938610	Bacteria	Bacteria	115	2.37e-28	NR	WP_078212560.1	1938610	g111621	i0	98.2	1.97604790419162	55	1	98.8	0	165	1	596	650	WP_078212560.1 SusC/RagA family TonB-linked outer membrane protein [Flavobacterium sp. LM5]	diamond	330	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. LM5
28381638	28381638	PRJNA870096_S_NODE_90446_length_185_cov_1.352113_g88782_i0	PRJNA870096	90446	185	1.352113	2.50140905	Rikenellaceae bacterium	2049048	Bacteria	Bacteria	42.7	0.017	NR	MFR9503429.1	2049048	g88782	i0	40.4	1.84864864864865	57	32	92.4	1	184	14	245	299	MFR9503429.1 alpha/beta hydrolase [Rikenellaceae bacterium]	diamond	342	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae		Rikenellaceae bacterium
28697561	28697561	PRJNA870096_S_NODE_88747_length_187_cov_0.979167_g87083_i0	PRJNA870096	88747	187	0.979167	1.83104229	Flavobacterium	237	Bacteria	Bacteria	113	5.950000000000001e-29	NR	WP_024981981.1	237	g87083	i0	93.4	0.978609625668449	61	4	97.9	0	187	5	6	66	WP_024981981.1 MULTISPECIES: energy transducer TonB [Flavobacterium]	diamond	183	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium
28894778	28894778	PRJNA870096_S_NODE_14128_length_487_cov_19.295045_g12492_i0	PRJNA870096	14128	487	19.295044999999998	93.96686915	Bacteroidota	976	Bacteria	Bacteria	151	8.81e-44	NR	WP_294821787.1	165435	g12492	i0	59	1.60780287474333	144	56	88.7	3	485	54	4	144	WP_294821787.1 carboxymuconolactone decarboxylase family protein [uncultured Flavobacterium sp.]	diamond	783	152	0.993421052631579	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
28981778	28981778	PRJNA870096_S_NODE_75408_length_202_cov_1.125786_g73744_i0	PRJNA870096	75408	202	1.125786	2.27408772	Flavobacterium succinicans	29536	Bacteria	Bacteria	127	2.45e-32	NR	WP_024982681.1	29536	g73744	i0	98.5	0.995049504950495	67	1	99.5	0	202	2	174	240	WP_024982681.1 formate C-acetyltransferase [Flavobacterium succinicans]	diamond	201	127	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium succinicans
29076425	29076425	PRJNA870096_S_NODE_114268_length_166_cov_1.560976_g112604_i0	PRJNA870096	114268	166	1.560976	2.59122016	Flavobacterium sp.	239	Bacteria	Bacteria	41.2	0.0449	NR	WP_320814553.1	239	g112604	i0	48.1	0.487951807228916	27	14	48.8	0	149	69	82	108	WP_320814553.1 glycosyltransferase [Flavobacterium sp.]	diamond	81	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
29084467	29084467	PRJNA870096_S_NODE_37708_length_290_cov_1.522267_g36044_i0	PRJNA870096	37708	290	1.522267	4.4145743	Bacteria	2	Bacteria	Bacteria	149	6.38e-41	NR	KPP99708.1	1666909	g36044	i0	68.8	2.97931034482759	96	30	99.3	0	3	290	327	422	KPP99708.1 MAG: Xaa-Pro aminopeptidase PepP [Bacteroidetes bacterium HLUCCA01]	diamond	864	149	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium HLUCCA01
29454790	29454790	PRJNA870096_S_NODE_67490_length_213_cov_1.941176_g65826_i0	PRJNA870096	67490	213	1.941176	4.13470488	Bacteroidota bacterium	1898104	Bacteria	Bacteria	89	2.23e-20	NR	MEM7575617.1	1898104	g65826	i0	57.7	1	71	29	100	1	213	1	68	137	MEM7575617.1 VOC family protein [Bacteroidota bacterium]	diamond	213	89	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29557811	29557811	PRJNA870096_S_NODE_116230_length_165_cov_1.180328_g114566_i0	PRJNA870096	116230	165	1.180328	1.9475412	Bacteroidota	976	Bacteria	Bacteria	59.3	1.8e-8	NR	HIA11736.1	2021391	g114566	i0	61.4	6	44	17	80	0	151	20	651	694	HIA11736.1 AMP-dependent synthetase [Flavobacteriales bacterium]	diamond	990	59.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
29770752	29770752	PRJNA870096_S_NODE_120031_length_162_cov_2.352941_g118367_i0	PRJNA870096	120031	162	2.352941	3.81176442	Aquimarina sp. W85	3342246	Bacteria	Bacteria	41.2	0.0311	NR	WP_378187602.1	3342246	g118367	i0	46.2	0.722222222222222	39	20	72.2	1	154	38	12	49	WP_378187602.1 hypothetical protein [Aquimarina sp. W85]	diamond	117	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. W85
29897347	29897347	PRJNA870096_S_NODE_95091_length_181_cov_1.043478_g93427_i0	PRJNA870096	95091	181	1.043478	1.88869518	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	77.4	9.87e-15	NR	MCB0761182.1	2021391	g93427	i0	66.7	1.85635359116022	54	18	89.5	0	181	20	283	336	MCB0761182.1 choice-of-anchor B family protein [Flavobacteriales bacterium]	diamond	336	77.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
30118250	30118250	PRJNA870096_S_NODE_68472_length_212_cov_1.136095_g66808_i0	PRJNA870096	68472	212	1.136095	2.4085214	Flagellimonas maritima	1383885	Bacteria	Bacteria	63.2	2.19e-10	NR	WP_112376765.1	1383885	g66808	i0	44.3	1.9811320754717	70	38	99.1	1	1	210	86	154	WP_112376765.1 GNAT family N-acetyltransferase [Flagellimonas maritima]	diamond	420	63.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flagellimonas	Flagellimonas maritima
30276683	30276683	PRJNA870096_S_NODE_137192_length_153_cov_0.872727_g135528_i0	PRJNA870096	137192	153	0.872727	1.33527231	Flavobacterium sp. LM5	1938610	Bacteria	Bacteria	94	9.63e-21	NR	WP_078212823.1	1938610	g135528	i0	88	0.980392156862745	50	6	98	0	152	3	41	90	WP_078212823.1 M1 family metallopeptidase [Flavobacterium sp. LM5]	diamond	150	94	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. LM5
30908409	30908409	PRJNA870096_S_NODE_29314_length_331_cov_2.527778_g27650_i0	PRJNA870096	29314	331	2.527778	8.36694518	Bacteroidota bacterium	1898104	Bacteria	Bacteria	151	1.18e-41	NR	MEN9840053.1	1898104	g27650	i0	69.5	0.95166163141994	105	32	95.2	0	5	319	289	393	MEN9840053.1 hypothetical protein [Bacteroidota bacterium]	diamond	315	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30916533	30916533	PRJNA870096_S_NODE_119374_length_163_cov_1.200000_g117710_i0	PRJNA870096	119374	163	1.2	1.956	Pseudomonadati	3379134	Bacteria	Bacteria	42.4	0.0169	NR	MBC8485093.1	1898104	g117710	i0	50	1.25153374233129	34	17	62.6	0	5	106	62	95	MBC8485093.1 tetratricopeptide repeat protein [Bacteroidota bacterium]	diamond	204	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31255857	31255857	PRJNA870096_S_NODE_137335_length_153_cov_0.872727_g135671_i0	PRJNA870096	137335	153	0.872727	1.33527231	Pedobacter hiemivivus	2530454	Bacteria	Bacteria	94.7	5.4e-21	NR	WP_136879922.1	2530454	g135671	i0	94.1	1	51	3	100	0	1	153	749	799	WP_136879922.1 replication restart helicase PriA [Pedobacter hiemivivus]	diamond	153	94.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter hiemivivus
31358975	31358975	PRJNA870096_S_NODE_105476_length_172_cov_2.410853_g103812_i0	PRJNA870096	105476	172	2.410853	4.14666716	Psychroflexus	83612	Bacteria	Bacteria	60.5	7.94e-9	NR	MDR9400673.1	1921580	g103812	i0	71.1	1.30813953488372	38	11	66.3	0	1	114	390	427	MDR9400673.1 ornithine--oxo-acid transaminase [Psychroflexus sp.]	diamond	225	60.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroflexus	Psychroflexus sp.
31445652	31445652	PRJNA870096_S_NODE_140896_length_152_cov_0.880734_g139232_i0	PRJNA870096	140896	152	0.880734	1.33871568	Bacteroidota bacterium	1898104	Bacteria	Bacteria	42.7	0.0108	NR	MEY3320431.1	1898104	g139232	i0	43.2	0.868421052631579	44	25	86.8	0	149	18	331	374	MEY3320431.1 hypothetical protein [Bacteroidota bacterium]	diamond	132	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31666958	31666958	PRJNA870096_S_NODE_69557_length_210_cov_1.437126_g67893_i0	PRJNA870096	69557	210	1.437126	3.0179646	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	43.5	0.0116	NR	RYG34286.1	1869212	g67893	i0	40	0.714285714285714	50	29	71.4	1	38	187	131	179	RYG34286.1 MAG: RNA methyltransferase [Chitinophagaceae bacterium]	diamond	150	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31801465	31801465	PRJNA870096_S_NODE_84277_length_191_cov_2.270270_g82613_i0	PRJNA870096	84277	191	2.27027	4.3362157	FCB group	1783270	Bacteria	Bacteria	53.5	1.64e-6	NR	HEB84969.1	1898104	g82613	i0	41	3.73821989528796	61	36	95.8	0	190	8	148	208	HEB84969.1 uridine kinase [Bacteroidota bacterium]	diamond	714	53.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31864711	31864711	PRJNA870096_S_NODE_123517_length_160_cov_1.641026_g121853_i0	PRJNA870096	123517	160	1.641026	2.6256416	Bacteria	2	Bacteria	Bacteria	82.8	7.26e-17	NR	MBI1268056.1	1898111	g121853	i0	69.8	8.85	53	16	99.4	0	1	159	291	343	MBI1268056.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Cryomorphaceae bacterium]	diamond	1416	83.6	0.990430622009569	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Cryomorphaceae		Cryomorphaceae bacterium
32394837	32394837	PRJNA870096_S_NODE_81979_length_194_cov_1.271523_g80315_i0	PRJNA870096	81979	194	1.271523	2.46675462	Flavobacterium	237	Bacteria	Bacteria	113	6.06e-28	NR	WP_024982685.1	237	g80315	i0	96.9	0.989690721649485	64	2	99	0	193	2	77	140	WP_024982685.1 MULTISPECIES: tetratricopeptide repeat protein [Flavobacterium]	diamond	192	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium
32615970	32615970	PRJNA870096_S_NODE_146440_length_150_cov_0.897196_g144776_i0	PRJNA870096	146440	150	0.897196	1.345794	Bacteroidota bacterium	1898104	Bacteria	Bacteria	65.9	7.05e-11	NR	MES2429740.1	1898104	g144776	i0	71.1	6.84	38	11	76	0	149	36	402	439	MES2429740.1 aspartate kinase [Bacteroidota bacterium]	diamond	1026	65.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota 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);;