metadata: contig_metadata: 29 rows where analysis = "diamond", bioproject = "PRJEB65099" and tax

29 rows where analysis = "diamond", bioproject = "PRJEB65099" and tax_clade = "FCB group"

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
9921991	9921991	PRJEB65099_P_NODE_6468_length_244_cov_0.912281_g6363_i0	PRJEB65099	6468	244	0.912281	2.22596564	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	137	4.5299999999999997e-38	NR	MBA3496714.1	2448054	g6363	i0	86.4	0.995901639344262	81	11	99.6	0	1	243	111	191	MBA3496714.1 ABC transporter ATP-binding protein [Gemmatimonadales bacterium]	diamond	243	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
12883550	12883550	PRJEB65099_P_NODE_5111_length_252_cov_0.871508_g5006_i0	PRJEB65099	5111	252	0.871508	2.19620016	Bacteroidales bacterium	2030927	Bacteria	Bacteria	177	2.49e-50	NR	MCF8338423.1	2030927	g5006	i0	95.2	1	84	4	100	0	252	1	422	505	MCF8338423.1 S9 family peptidase [Bacteroidales bacterium]	diamond	252	177	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
23946295	23946295	PRJEB65099_P_NODE_6399_length_244_cov_1.824561_g6294_i0	PRJEB65099	6399	244	1.824561	4.45192884	Porphyromonas gingivalis	837	Bacteria	Bacteria	103	1.41e-26	NR	PDP72243.1	837	g6294	i0	98.8	0.983606557377049	80	1	98.4	0	3	242	1	80	PDP72243.1 peptidase, partial [Porphyromonas gingivalis]	diamond	240	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
26748592	26748592	PRJEB65099_P_NODE_5121_length_252_cov_0.871508_g5016_i0	PRJEB65099	5121	252	0.871508	2.19620016	Ihuprevotella massiliensis	1852368	Bacteria	Bacteria	74.7	7.08e-14	NR	WP_075565226.1	1852368	g5016	i0	92.7	0.488095238095238	41	3	48.8	0	125	3	1	41	WP_075565226.1 ComEA family DNA-binding protein [Ihuprevotella massiliensis]	diamond	123	74.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Ihuprevotella	Ihuprevotella massiliensis
26780833	26780833	PRJEB65099_P_NODE_5501_length_250_cov_0.881356_g5396_i0	PRJEB65099	5501	250	0.881356	2.20339	Chitinophagaceae bacterium LWZ2-11	3369651	Bacteria	Bacteria	173	5.879999999999999e-48	NR	MFL9482518.1	3369651	g5396	i0	100	0.996	83	0	99.6	0	249	1	264	346	MFL9482518.1 triple tyrosine motif-containing protein [Chitinophagaceae bacterium LWZ2-11]	diamond	249	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LWZ2-11
26970511	26970511	PRJEB65099_P_NODE_5122_length_252_cov_0.871508_g5017_i0	PRJEB65099	5122	252	0.871508	2.19620016	Flavobacterium cheonanense	706183	Bacteria	Bacteria	136	2.92e-36	NR	WP_344815000.1	706183	g5017	i0	81.9	0.988095238095238	83	15	98.8	0	3	251	255	337	WP_344815000.1 hypothetical protein [Flavobacterium cheonanense]	diamond	249	136	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cheonanense
27381738	27381738	PRJEB65099_P_NODE_5963_length_247_cov_0.896552_g5858_i0	PRJEB65099	5963	247	0.896552	2.21448344	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.4	0.0478	NR	HEU5217613.1	2448054	g5858	i0	45.1	0.619433198380567	51	27	60.7	1	226	77	86	136	HEU5217613.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	153	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27753655	27753655	PRJEB65099_P_NODE_4624_length_260_cov_1.668449_g4519_i0	PRJEB65099	4624	260	1.668449	4.3379674	Cytophagales	768507	Bacteria	Bacteria	42.7	0.0113	NR	WP_143785884.1	688867	g4519	i0	74.1	1.55769230769231	27	7	31.2	0	178	258	9	35	WP_143785884.1 hypothetical protein [Ohtaekwangia koreensis]	diamond	405	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Ohtaekwangia	Ohtaekwangia koreensis
27848007	27848007	PRJEB65099_P_NODE_6044_length_246_cov_0.901734_g5939_i0	PRJEB65099	6044	246	0.901734	2.21826564	Bacteroidota	976	Bacteria	Bacteria	48.9	2.51e-4	NR	WP_332369504.1	2183553	g5939	i0	95.7	1.1219512195122	23	1	28	0	244	176	486	508	WP_332369504.1 phosphoenolpyruvate synthase [Spirosoma telluris]	diamond	276	49.3	0.991886409736308	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma telluris
28170926	28170926	PRJEB65099_P_NODE_6466_length_244_cov_0.912281_g6361_i0	PRJEB65099	6466	244	0.912281	2.22596564	Prevotella aurantiaca	596085	Bacteria	Bacteria	150	2.8299999999999993e-42	NR	WP_025000870.1	596085	g6361	i0	88.9	0.995901639344262	81	9	99.6	0	243	1	201	281	WP_025000870.1 metallophosphoesterase [Prevotella aurantiaca]	diamond	243	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella aurantiaca
28297173	28297173	PRJEB65099_P_NODE_5926_length_247_cov_0.896552_g5821_i0	PRJEB65099	5926	247	0.896552	2.21448344	Flavobacterium piscis	1114874	Bacteria	Bacteria	150	5.229999999999998e-43	NR	MCA1920081.1	1114874	g5821	i0	98.8	0.995951417004049	82	1	99.6	0	246	1	183	264	MCA1920081.1 ATP synthase F1 subunit gamma [Flavobacterium piscis]	diamond	246	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium piscis
28897047	28897047	PRJEB65099_P_NODE_6368_length_245_cov_0.906977_g6263_i0	PRJEB65099	6368	245	0.906977	2.22209365	Flavobacterium sp.	239	Bacteria	Bacteria	165	1.8e-47	NR	WP_396210528.1	239	g6263	i0	98.8	1.98367346938776	81	1	99.2	0	3	245	79	159	WP_396210528.1 restriction endonuclease subunit S [Flavobacterium sp.]	diamond	486	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
29370848	29370848	PRJEB65099_P_NODE_5949_length_247_cov_0.896552_g5844_i0	PRJEB65099	5949	247	0.896552	2.21448344	Porphyromonas bennonis	501496	Bacteria	Bacteria	165	4.919999999999998e-47	NR	WP_018107236.1	501496	g5844	i0	100	0.995951417004049	82	0	99.6	0	246	1	271	352	WP_018107236.1 TolC family protein [Porphyromonas bennonis]	diamond	246	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas bennonis
29876056	29876056	PRJEB65099_P_NODE_5071_length_252_cov_0.871508_g4966_i0	PRJEB65099	5071	252	0.871508	2.19620016	Bacteroidales bacterium	2030927	Bacteria	Bacteria	128	2.8499999999999996e-32	NR	MCF8232109.1	2030927	g4966	i0	71.4	1	84	24	100	0	252	1	440	523	MCF8232109.1 2-oxoglutarate dehydrogenase E1 component [Bacteroidales bacterium]	diamond	252	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30160056	30160056	PRJEB65099_P_NODE_7012_length_236_cov_2.184049_g6907_i0	PRJEB65099	7012	236	2.184049	5.15435564	Porphyromonas sp. HMSC	1924944	Bacteria	Bacteria	105	3.7799999999999996e-24	NR	WP_070466782.1	1739394	g6907	i0	100	0.622881355932203	49	0	62.3	0	147	1	1	49	WP_070466782.1 methionine--tRNA ligase [Porphyromonas sp. HMSC065F10]	diamond	147	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. HMSC065F10
30223427	30223427	PRJEB65099_P_NODE_6412_length_244_cov_1.479532_g6307_i0	PRJEB65099	6412	244	1.479532	3.61005808	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	72.4	1.08e-12	NR	MBL7941645.1	2021391	g6307	i0	53.4	1.08196721311475	88	32	97.1	2	238	2	217	304	MBL7941645.1 hypothetical protein [Flavobacteriales bacterium]	diamond	264	72.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
30350407	30350407	PRJEB65099_P_NODE_3752_length_288_cov_1.390698_g3647_i0	PRJEB65099	3752	288	1.390698	4.00521024	Hymenobacter sp. GOD-1	1898978	Bacteria	Bacteria	101	4.54e-24	NR	WP_324680207.1	3093922	g3647	i0	63	0.84375	81	30	84.4	0	8	250	142	222	WP_324680207.1 hypothetical protein [Hymenobacter sp. GOD-10R]	diamond	243	101	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. GOD-10R
30476393	30476393	PRJEB65099_P_NODE_6433_length_244_cov_0.912281_g6328_i0	PRJEB65099	6433	244	0.912281	2.22596564	Flavobacterium araucananum	946678	Bacteria	Bacteria	51.6	7.47e-6	NR	OXG09652.1	946678	g6328	i0	92	0.590163934426229	25	2	30.7	0	77	3	34	58	OXG09652.1 hypothetical protein B0A64_00030 [Flavobacterium araucananum]	diamond	144	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium araucananum
30634043	30634043	PRJEB65099_P_NODE_4873_length_253_cov_1.700000_g4768_i0	PRJEB65099	4873	253	1.7	4.301	Arenibacter sp. GZD-96	3106030	Bacteria	Bacteria	129	1.4799999999999998e-32	NR	WP_322928857.1	3106030	g4768	i0	72.3	0.984189723320158	83	23	98.4	0	251	3	946	1028	WP_322928857.1 PVC-type heme-binding CxxCH protein [Arenibacter sp. GZD-96]	diamond	249	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aurantibrevibacter	Aurantibrevibacter litoralis
30792178	30792178	PRJEB65099_P_NODE_6294_length_245_cov_0.906977_g6189_i0	PRJEB65099	6294	245	0.906977	2.22209365	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	92	2.5300000000000003e-22	NR	MFQ5746296.1	2026742	g6189	i0	80.8	2.49795918367347	52	10	63.7	0	88	243	11	62	MFQ5746296.1 30S ribosomal protein S18 [Gemmatimonadota bacterium]	diamond	612	92	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
30823817	30823817	PRJEB65099_P_NODE_3854_length_284_cov_2.137441_g3749_i0	PRJEB65099	3854	284	2.137441	6.07033244	Hymenobacter defluvii	2054411	Bacteria	Bacteria	165	2e-45	NR	WP_208308634.1	2054411	g3749	i0	93.6	0.992957746478873	94	6	99.3	0	282	1	420	513	WP_208308634.1 DUF3732 domain-containing protein [Hymenobacter defluvii]	diamond	282	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter defluvii
30918762	30918762	PRJEB65099_P_NODE_4434_length_266_cov_1.248705_g4329_i0	PRJEB65099	4434	266	1.248705	3.3215553	Chitinophagaceae bacterium LWZ2-11	3369651	Bacteria	Bacteria	165	1.1699999999999999e-46	NR	MFL9485587.1	3369651	g4329	i0	100	0.947368421052632	84	0	94.7	0	1	252	260	343	MFL9485587.1 TolC family protein [Chitinophagaceae bacterium LWZ2-11]	diamond	252	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LWZ2-11
31076686	31076686	PRJEB65099_P_NODE_6555_length_244_cov_0.912281_g6450_i0	PRJEB65099	6555	244	0.912281	2.22596564	Chitinophagaceae bacterium LWZ2-11	3369651	Bacteria	Bacteria	151	2.4e-40	NR	MFL9485297.1	3369651	g6450	i0	98.8	0.995901639344262	81	1	99.6	0	1	243	34	114	MFL9485297.1 TonB-dependent receptor domain-containing protein [Chitinophagaceae bacterium LWZ2-11]	diamond	243	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LWZ2-11
31139381	31139381	PRJEB65099_P_NODE_5255_length_251_cov_0.876404_g5150_i0	PRJEB65099	5255	251	0.876404	2.19977404	Chryseobacterium sp. ON_d1	2583211	Bacteria	Bacteria	154	7.559999999999999e-43	NR	WP_172617133.1	2583211	g5150	i0	96.4	0.99203187250996006	83	3	99.2	0	251	3	4	86	WP_172617133.1 S41 family peptidase [Chryseobacterium sp. ON_d1]	diamond	249	154	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ON_d1
31297772	31297772	PRJEB65099_P_NODE_4055_length_278_cov_1.409756_g3950_i0	PRJEB65099	4055	278	1.409756	3.91912168	Fodinibius salsisoli	2820877	Bacteria	Bacteria	178	8.92e-56	NR	MCW9709273.1	2820877	g3950	i0	90.1	2.94604316546763	91	9	98.2	0	275	3	3	93	MCW9709273.1 isoprenylcysteine carboxyl methyltransferase [Fodinibius salsisoli]	diamond	819	178	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Fodinibius	Fodinibius salsisoli
31740505	31740505	PRJEB65099_P_NODE_5397_length_250_cov_0.881356_g5292_i0	PRJEB65099	5397	250	0.881356	2.20339	Taibaiella sp.	1869185	Bacteria	Bacteria	173	3.1e-52	NR	MBZ0097801.1	1869185	g5292	i0	98.8	0.972	81	1	97.2	0	6	248	1	81	MBZ0097801.1 TerC/Alx family metal homeostasis membrane protein [Taibaiella sp.]	diamond	243	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Taibaiella	Taibaiella sp.
31772244	31772244	PRJEB65099_P_NODE_4697_length_258_cov_1.637838_g4592_i0	PRJEB65099	4697	258	1.637838	4.22562204	Hymenobacter sp. UYCo722	3156335	Bacteria	Bacteria	157	1.5799999999999994e-42	NR	WP_354584035.1	3156335	g4592	i0	89.4	1.97674418604651	85	9	98.8	0	3	257	362	446	WP_354584035.1 TonB-dependent receptor [Hymenobacter sp. UYCo722]	diamond	510	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. UYCo722
31803752	31803752	PRJEB65099_P_NODE_6657_length_243_cov_0.917647_g6552_i0	PRJEB65099	6657	243	0.917647	2.22988221	Candidatus Zhuqueibacterota bacterium	2172550	Bacteria	Bacteria	161	2.57e-45	NR	NIR71008.1	2172550	g6552	i0	92.5	2.96296296296296	80	6	98.8	0	242	3	26	105	NIR71008.1 methionine--tRNA ligase [Candidatus Zhuqueibacterota bacterium]	diamond	720	161	1	Bacteria	FCB group	Pseudomonadati						Candidatus Zhuqueibacterota bacterium
32151966	32151966	PRJEB65099_P_NODE_5658_length_249_cov_0.886364_g5553_i0	PRJEB65099	5658	249	0.886364	2.20704636	Flavobacterium	237	Bacteria	Bacteria	112	7.11e-29	NR	WP_166236440.1	237	g5553	i0	61.4	1	83	32	100	0	249	1	26	108	WP_166236440.1 response regulator transcription factor [Flavobacterium celericrescens]	diamond	249	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium

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