metadata: contig_metadata: 26 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax

26 rows where analysis = "diamond", bioproject = "PRJNA560029" 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
1130494	1130494	PRJNA560029_S_NODE_8041_length_387_cov_3.229299_g7817_i0	PRJNA560029	8041	387	3.229299	12.49738713	Bacteria	2	Bacteria	Bacteria	160	1.49e-42	NR	MCX6245136.1	1898104	g7817	i0	73.8	2.3953488372093	103	27	79.8	0	78	386	1	103	MCX6245136.1 N-6 DNA methylase [Bacteroidota bacterium]	diamond	927	161	0.993788819875776	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
6921917	6921917	PRJNA560029_S_NODE_2486_length_547_cov_7.185654_g2265_i0	PRJNA560029	2486	547	7.185654	39.30552738	Bacteroidota	976	Bacteria	Bacteria	235	2.06e-72	NR	WP_247814495.1	104663	g2265	i0	64.4	4.92504570383912	180	62	97.6	1	1	534	76	255	WP_247814495.1 dGTP triphosphohydrolase [Chitinophaga filiformis]	diamond	2694	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga filiformis
14573242	14573242	PRJNA560029_S_NODE_9552_length_371_cov_3.986577_g9328_i0	PRJNA560029	9552	371	3.986577	14.79020067	Pedobacter	84567	Bacteria	Bacteria	69.7	2.39e-11	NR	WP_037443138.1	34086	g9328	i0	55.2	3.84097035040431	58	26	46.9	0	193	366	1	58	WP_037443138.1 glycosyltransferase family 2 protein [Pedobacter antarcticus]	diamond	1425	70.1	0.994293865905849	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter antarcticus
26794204	26794204	PRJNA560029_S_NODE_25101_length_279_cov_1.970874_g24877_i0	PRJNA560029	25101	279	1.970874	5.49873846	Flavobacterium sp.	239	Bacteria	Bacteria	77	4.25e-14	NR	WP_343614066.1	239	g24877	i0	40.2	2.95698924731183	92	53	97.8	2	278	6	220	310	WP_343614066.1 hypothetical protein [Flavobacterium sp.]	diamond	825	77	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
27268568	27268568	PRJNA560029_S_NODE_21763_length_294_cov_2.638009_g21539_i0	PRJNA560029	21763	294	2.638009	7.75574646	Sunxiuqinia indica	2692584	Bacteria	Bacteria	76.6	7.17e-16	NR	WP_159520970.1	2692584	g21539	i0	50.6	0.806122448979592	79	39	80.6	0	8	244	11	89	WP_159520970.1 acylphosphatase [Sunxiuqinia indica]	diamond	237	76.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae	Sunxiuqinia	Sunxiuqinia indica
28658130	28658130	PRJNA560029_S_NODE_19967_length_303_cov_1.686957_g19743_i0	PRJNA560029	19967	303	1.686957	5.11147971	Bacteroidetes bacterium GWF2_38_335	1797344	Bacteria	Bacteria	56.6	9.98e-7	NR	OFY36820.1	1797344	g19743	i0	48.1	0.98019801980198	52	27	51.5	0	300	145	434	485	OFY36820.1 MAG: malate dehydrogenase [Bacteroidetes bacterium GWF2_38_335]	diamond	297	56.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium GWF2_38_335
29005727	29005727	PRJNA560029_S_NODE_13508_length_340_cov_4.014981_g13284_i0	PRJNA560029	13508	340	4.014981	13.6509354	Sphingobacterium luzhongxinii	2654181	Bacteria	Bacteria	225	6.03e-71	NR	WP_164126298.1	2654181	g13284	i0	96.4	0.988235294117647	112	4	98.8	0	3	338	232	343	WP_164126298.1 uroporphyrinogen decarboxylase [Sphingobacterium luzhongxinii]	diamond	336	225	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium luzhongxinii
29194943	29194943	PRJNA560029_S_NODE_8649_length_380_cov_3.084691_g8425_i0	PRJNA560029	8649	380	3.084691	11.7218258	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	173	3.389999999999999e-47	NR	HCQ29562.1	2021391	g8425	i0	61.1	10.8236842105263	126	49	99.5	0	378	1	831	956	HCQ29562.1 DNA methyltransferase [Flavobacteriales bacterium]	diamond	4113	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
29320991	29320991	PRJNA560029_S_NODE_13149_length_343_cov_1.477778_g12925_i0	PRJNA560029	13149	343	1.477778	5.06877854	Bacteroidota bacterium	1898104	Bacteria	Bacteria	72	2.06e-13	NR	MDA0671222.1	1898104	g12925	i0	75.6	0.393586005830904	45	11	39.4	0	135	1	1	45	MDA0671222.1 RidA family protein [Bacteroidota bacterium]	diamond	135	72	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29415674	29415674	PRJNA560029_S_NODE_8109_length_386_cov_5.939297_g7885_i0	PRJNA560029	8109	386	5.939297	22.92568642	Bacteroidales bacterium	2030927	Bacteria	Bacteria	144	5.26e-40	NR	MEX0987166.1	2030927	g7885	i0	58.3	3.87046632124352	120	50	93.3	0	1	360	114	233	MEX0987166.1 (d)CMP kinase [Bacteroidales bacterium]	diamond	1494	144	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29668035	29668035	PRJNA560029_S_NODE_34790_length_243_cov_1.082353_g34566_i0	PRJNA560029	34790	243	1.082353	2.63011779	Bergeyella sp.	1962306	Bacteria	Bacteria	80.9	1.02e-15	NR	MDL1913531.1	1962306	g34566	i0	51.3	0.987654320987654	80	38	98.8	1	240	1	231	309	MDL1913531.1 glycosyltransferase [Bergeyella sp.]	diamond	240	80.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella sp.
30141742	30141742	PRJNA560029_S_NODE_1612_length_645_cov_2.452797_g1401_i0	PRJNA560029	1612	645	2.452797	15.82054065	Dysgonamonadaceae bacterium	2065189	Bacteria	Bacteria	57	1.72e-5	NR	MDR0681304.1	2065189	g1401	i0	26.9	2.6046511627907	186	107	75.8	6	639	151	696	875	MDR0681304.1 metallophosphoesterase [Dysgonamonadaceae bacterium]	diamond	1680	57	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonamonadaceae bacterium
30300583	30300583	PRJNA560029_S_NODE_8132_length_386_cov_3.182109_g7908_i0	PRJNA560029	8132	386	3.182109	12.28294074	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	51.2	1.64e-4	NR	MCB0689479.1	2202734	g7908	i0	49.2	0.489637305699482	63	26	45.9	3	3	179	256	316	MCB0689479.1 aldo/keto reductase [Saprospiraceae bacterium]	diamond	189	51.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
30440658	30440658	PRJNA560029_S_NODE_5913_length_417_cov_4.087209_g5689_i0	PRJNA560029	5913	417	4.087209	17.04366153	Tenuifilaceae	2760872	Bacteria	Bacteria	100	1.1200000000000002e-21	NR	OFY36820.1	1797344	g5689	i0	57.1	6.74820143884892	84	36	60.4	0	412	161	402	485	OFY36820.1 MAG: malate dehydrogenase [Bacteroidetes bacterium GWF2_38_335]	diamond	2814	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium GWF2_38_335
30566609	30566609	PRJNA560029_S_NODE_8233_length_385_cov_2.323718_g8009_i0	PRJNA560029	8233	385	2.323718	8.9463143	root	1	Root_unresolved	Root_unresolved	47	0.00424	NR	WP_299798980.1	431308	g8009	i0	37.3	1.48051948051948	75	31	53	2	364	161	127	192	WP_299798980.1 hypothetical protein [uncultured Maribacter sp.]	diamond	570	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Maribacter	uncultured Maribacter sp.
30647430	30647430	PRJNA560029_S_NODE_16313_length_322_cov_4.449799_g16089_i0	PRJNA560029	16313	322	4.449799	14.32835278	Bacteroidales bacterium	2030927	Bacteria	Bacteria	43.9	0.0233	NR	NLF41670.1	2030927	g16089	i0	35.8	0.624223602484472	67	36	62.4	1	201	1	1	60	NLF41670.1 hypothetical protein [Bacteroidales bacterium]	diamond	201	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30742455	30742455	PRJNA560029_S_NODE_29734_length_260_cov_1.673797_g29510_i0	PRJNA560029	29734	260	1.673797	4.3518722	Bacteroidota bacterium	1898104	Bacteria	Bacteria	122	3.7899999999999997e-32	NR	MBI1192210.1	1898104	g29510	i0	65.1	8.74615384615385	86	30	99.2	0	2	259	157	242	MBI1192210.1 ATP-binding cassette domain-containing protein [Bacteroidota bacterium]	diamond	2274	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30900576	30900576	PRJNA560029_S_NODE_13434_length_341_cov_1.861940_g13210_i0	PRJNA560029	13434	341	1.86194	6.3492154	Phocaeicola plebeius	310297	Bacteria	Bacteria	50.8	4.5e-5	NR	WP_373136069.1	310297	g13210	i0	52.6	0.589442815249267	38	18	33.4	0	212	325	16	53	WP_373136069.1 recombination protein NinG [Phocaeicola plebeius]	diamond	201	50.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola plebeius
31135310	31135310	PRJNA560029_S_NODE_23015_length_288_cov_4.604651_g22791_i0	PRJNA560029	23015	288	4.604651	13.26139488	Bacteroidota	976	Bacteria	Bacteria	46.6	0.00276	NR	MDR1809236.1	59823	g22791	i0	37.3	4.20833333333333	59	36	60.4	1	285	112	347	405	MDR1809236.1 ATP-binding protein [Prevotella sp.]	diamond	1212	46.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
31216011	31216011	PRJNA560029_S_NODE_13855_length_338_cov_3.120755_g13631_i0	PRJNA560029	13855	338	3.120755	10.5481519	Pontibacter mangrovi	2589816	Bacteria	Bacteria	82	4.73e-16	NR	WP_140621011.1	2589816	g13631	i0	45.9	4.52662721893491	109	48	94.1	5	18	335	165	265	WP_140621011.1 Cof-type HAD-IIB family hydrolase [Pontibacter mangrovi]	diamond	1530	82	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter mangrovi
31578415	31578415	PRJNA560029_S_NODE_30676_length_256_cov_2.267760_g30452_i0	PRJNA560029	30676	256	2.26776	5.8054656	Bacteroidota	976	Bacteria	Bacteria	90.1	7.34e-19	NR	WP_320581409.1	1004	g30452	i0	70.4	18.3515625	71	21	83.2	0	215	3	5	75	WP_320581409.1 dGTP triphosphohydrolase [Chitinophaga sancti]	diamond	4698	90.9	0.991199119911991	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sancti
31831193	31831193	PRJNA560029_S_NODE_28537_length_264_cov_4.031414_g28313_i0	PRJNA560029	28537	264	4.031414	10.64293296	FCB group	1783270	Bacteria	Bacteria	86.3	1.54e-17	NR	MBD5180834.1	2030927	g28313	i0	44.4	4.70454545454545	81	45	92	0	21	263	101	181	MBD5180834.1 L-serine ammonia-lyase [Bacteroidales bacterium]	diamond	1242	86.7	0.995386389850058	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31862822	31862822	PRJNA560029_S_NODE_12617_length_346_cov_3.142857_g12393_i0	PRJNA560029	12617	346	3.142857	10.87428522	FCB group	1783270	Bacteria	Bacteria	137	3.26e-36	NR	TDY42867.1	1073327	g12393	i0	61.4	5.77456647398844	114	44	98.8	0	344	3	239	352	TDY42867.1 glycosyltransferase involved in cell wall biosynthesis [Algoriphagus zhangzhouensis]	diamond	1998	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus zhangzhouensis
32418625	32418625	PRJNA560029_S_NODE_29479_length_261_cov_1.638298_g29255_i0	PRJNA560029	29479	261	1.638298	4.27595778	Flavobacterium sp. CS2	239	Bacteria	Bacteria	54.7	1.33e-6	NR	WP_247653514.1	2775246	g29255	i0	71.2	0.758620689655172	66	19	75.9	0	3	200	130	195	WP_247653514.1 acetyltransferase [Flavobacterium sp. CS20]	diamond	198	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. CS20
32590805	32590805	PRJNA560029_S_NODE_7039_length_400_cov_1.186544_g6815_i0	PRJNA560029	7039	400	1.186544	4.746176	Bacteria	2	Bacteria	Bacteria	91.7	1.46e-19	NR	MCI7315347.1	2030927	g6815	i0	67.2	1.785	61	20	45.8	0	207	389	3	63	MCI7315347.1 MBL fold metallo-hydrolase [Bacteroidales bacterium]	diamond	714	91.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32608186	32608186	PRJNA560029_S_NODE_36580_length_232_cov_2.264151_g36356_i0	PRJNA560029	36580	232	2.264151	5.25283032	Hymenobacter glaciei	877209	Bacteria	Bacteria	125	3.5099999999999993e-31	NR	WP_345052279.1	877209	g36356	i0	79.7	1.93965517241379	74	15	95.7	0	231	10	72	145	WP_345052279.1 cadherin-like domain-containing protein [Hymenobacter glaciei]	diamond	450	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter glaciei

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