metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA400171" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA400171" 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
1081031	1081031	PRJNA400171_S_NODE_6201_length_179_cov_3.353333_g6111_i0	PRJNA400171	6201	179	3.353333	6.00246607	Candidatus Cloacimonas sp. SDB	1732214	Bacteria	Bacteria	91.3	4.82e-20	NR	KQC03743.1	1732214	g6111	i0	64.4	1.94413407821229	59	21	98.9	0	2	178	145	203	KQC03743.1 MAG: mannose-1-phosphate guanylyltransferase [Candidatus Cloacimonas sp. SDB]	diamond	348	91.3	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota	Candidatus Cloacimonadia	Candidatus Cloacimonadales	Candidatus Cloacimonadaceae	Candidatus Cloacimonas	Candidatus Cloacimonas sp. SDB
27075397	27075397	PRJNA400171_S_NODE_5842_length_184_cov_2.535484_g5752_i0	PRJNA400171	5842	184	2.535484	4.66529056	Alistipes sp.	1872444	Bacteria	Bacteria	39.7	0.0457	NR	MDE5622180.1	1872444	g5752	i0	46.3	0.668478260869565	41	22	66.8	0	134	12	2	42	MDE5622180.1 tRNA nucleotidyltransferase [Alistipes sp.]	diamond	123	39.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
28860513	28860513	PRJNA400171_S_NODE_428_length_448_cov_2.565632_g339_i0	PRJNA400171	428	448	2.565632	11.49403136	Bacteria	2	Bacteria	Bacteria	81.6	4.46e-15	NR	NQU91124.1	1898104	g339	i0	30.6	2.44419642857143	124	84	81.7	1	447	82	29	152	NQU91124.1 hypothetical protein [Bacteroidota bacterium]	diamond	1095	81.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28906823	28906823	PRJNA400171_S_NODE_3628_length_219_cov_3.821053_g3538_i0	PRJNA400171	3628	219	3.821053	8.36810607	Duncaniella sp.	2518496	Bacteria	Bacteria	51.2	2.63e-5	NR	MDE6378369.1	2518496	g3538	i0	44.1	3.0958904109589	68	34	87.7	2	217	26	221	288	MDE6378369.1 serine/threonine-protein kinase [Duncaniella sp.]	diamond	678	51.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Duncaniella	Duncaniella sp.
29506863	29506863	PRJNA400171_S_NODE_5550_length_187_cov_3.575949_g5460_i0	PRJNA400171	5550	187	3.575949	6.68702463	Lentimicrobium sp.	2034841	Bacteria	Bacteria	81.3	1.66e-16	NR	WP_323437469.1	2034841	g5460	i0	54.8	0.994652406417112	62	28	99.5	0	2	187	165	226	WP_323437469.1 hypothetical protein [Lentimicrobium sp.]	diamond	186	81.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Lentimicrobiaceae	Lentimicrobium	Lentimicrobium sp.
29696002	29696002	PRJNA400171_S_NODE_7330_length_167_cov_3.434783_g7240_i0	PRJNA400171	7330	167	3.434783	5.73608761	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	51.6	9.9e-6	NR	MCI9286015.1	2498093	g7240	i0	45.5	0.988023952095808	55	23	98.8	1	2	166	41	88	MCI9286015.1 hypothetical protein [Muribaculaceae bacterium]	diamond	165	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
31086490	31086490	PRJNA400171_S_NODE_3595_length_220_cov_3.094241_g3505_i0	PRJNA400171	3595	220	3.094241	6.8073302	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	42.7	0.0272	NR	MBL0153367.1	1869212	g3505	i0	32.9	1.03636363636364	76	42	95.5	3	215	6	298	370	MBL0153367.1 M28 family peptidase [Chitinophagaceae bacterium]	diamond	228	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32558534	32558534	PRJNA400171_S_NODE_2079_length_267_cov_2.390756_g1989_i0	PRJNA400171	2079	267	2.390756	6.38331852	Bacteroidota	976	Bacteria	Bacteria	117	4.41e-29	NR	WP_188618491.1	517423	g1989	i0	65.5	12.7977528089888	84	28	94.4	1	265	14	290	372	WP_188618491.1 NAD(P)/FAD-dependent oxidoreductase [Cloacibacterium rupense]	diamond	3417	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium rupense
32825074	32825074	PRJNA400171_S_NODE_4380_length_205_cov_2.738636_g4290_i0	PRJNA400171	4380	205	2.738636	5.6142038	Hymenobacter wooponensis	1525360	Bacteria	Bacteria	79	3.95e-15	NR	WP_135530093.1	1525360	g4290	i0	50.8	0.921951219512195	63	31	92.2	0	13	201	338	400	WP_135530093.1 DEAD/DEAH box helicase [Hymenobacter wooponensis]	diamond	189	79	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter wooponensis

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