metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA930380" 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
26613235	26613235	PRJNA930380_P_NODE_11461_length_251_cov_0.865169_g11408_i0	PRJNA930380	11461	251	0.865169	2.17157419	Bacteroidota bacterium	1898104	Bacteria	Bacteria	96.3	6.2e-21	NR	MEM7104478.1	1898104	g11408	i0	62.5	0.860557768924303	72	27	86.1	0	11	226	4	75	MEM7104478.1 Ig-like domain-containing protein [Bacteroidota bacterium]	diamond	216	96.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26810465	26810465	PRJNA930380_P_NODE_5261_length_295_cov_3.490991_g5208_i0	PRJNA930380	5261	295	3.490991	10.29842345	Bacteria	2	Bacteria	Bacteria	50.4	1.39e-4	NR	MCH1596527.1	1871037	g5208	i0	41.9	5.47118644067797	62	34	61	1	25	204	897	958	MCH1596527.1 endonuclease/exonuclease/phosphatase family protein [Flavobacteriaceae bacterium]	diamond	1614	50.8	0.992125984251969	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
26961488	26961488	PRJNA930380_P_NODE_4742_length_302_cov_3.847162_g4689_i0	PRJNA930380	4742	302	3.847162	11.61842924	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.9	0.0282	NR	MCE2942906.1	2026742	g4689	i0	31.9	0.903973509933775	91	41	69.5	3	68	277	90	180	MCE2942906.1 beta-lactamase family protein [Gemmatimonadota bacterium]	diamond	273	43.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27214418	27214418	PRJNA930380_P_NODE_9122_length_276_cov_2.492611_g9069_i0	PRJNA930380	9122	276	2.492611	6.87960636	Bacteroidota bacterium	1898104	Bacteria	Bacteria	72.4	2.03e-12	NR	MEL7062654.1	1898104	g9069	i0	42.9	10.1739130434783	91	48	94.6	3	271	11	96	186	MEL7062654.1 reverse transcriptase family protein [Bacteroidota bacterium]	diamond	2808	72.8	0.994505494505495	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27372921	27372921	PRJNA930380_P_NODE_13423_length_244_cov_0.900585_g13370_i0	PRJNA930380	13423	244	0.900585	2.1974274	Phocaeicola vulgatus	821	Bacteria	Bacteria	40	0.0439	NR	WP_227238842.1	821	g13370	i0	40	0.491803278688525	40	22	46.7	1	99	212	11	50	WP_227238842.1 hypothetical protein, partial [Phocaeicola vulgatus]	diamond	120	40	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
28130547	28130547	PRJNA930380_P_NODE_3965_length_326_cov_1.383399_g3912_i0	PRJNA930380	3965	326	1.383399	4.50988074	Balneolaceae bacterium	2053516	Bacteria	Bacteria	45.1	0.0155	NR	TVQ06314.1	2053516	g3912	i0	34	0.920245398773006	100	57	84.7	4	307	32	109	207	TVQ06314.1 MAG: T9SS C-terminal target domain-containing protein [Balneolaceae bacterium]	diamond	300	45.1	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
29330197	29330197	PRJNA930380_P_NODE_9849_length_272_cov_1.175879_g9796_i0	PRJNA930380	9849	272	1.175879	3.19839088	Bacteroidales bacterium	2030927	Bacteria	Bacteria	57.4	3.37e-7	NR	MCD8313594.1	2030927	g9796	i0	40.5	0.871323529411765	79	42	83.8	3	269	42	196	272	MCD8313594.1 hypothetical protein [Bacteroidales bacterium]	diamond	237	57.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31036296	31036296	PRJNA930380_P_NODE_5635_length_293_cov_1.400000_g5582_i0	PRJNA930380	5635	293	1.4	4.102	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.0433	NR	MEM8486685.1	1898104	g5582	i0	30.8	0.931740614334471	91	56	86	2	10	261	84	174	MEM8486685.1 TerB family tellurite resistance protein [Bacteroidota bacterium]	diamond	273	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31067792	31067792	PRJNA930380_P_NODE_8355_length_281_cov_1.033654_g8302_i0	PRJNA930380	8355	281	1.033654	2.90456774	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	55.8	1.43e-6	NR	MCH1595862.1	1871037	g8302	i0	37.5	5.3914590747331	72	45	76.9	0	54	269	130	201	MCH1595862.1 reverse transcriptase family protein [Flavobacteriaceae bacterium]	diamond	1515	56.2	0.99288256227758	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
32396180	32396180	PRJNA930380_P_NODE_10679_length_263_cov_1.594737_g10626_i0	PRJNA930380	10679	263	1.594737	4.19415831	Cloacibacterium sp.	1913682	Bacteria	Bacteria	156	6.04e-42	NR	WP_414985015.1	1913682	g10626	i0	94.3	0.992395437262357	87	5	99.2	0	2	262	45	131	WP_414985015.1 TonB-dependent receptor domain-containing protein [Cloacibacterium sp.]	diamond	261	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium sp.

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