metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA897077" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA897077" 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
3424416	3424416	PRJNA897077_P_NODE_17483_length_248_cov_0.891429_g17356_i0	PRJNA897077	17483	248	0.891429	2.21074392	Bacteroidota bacterium	1898104	Bacteria	Bacteria	105	4.53e-24	NR	MEN9347876.1	1898104	g17356	i0	69.1	0.979838709677419	81	25	98	0	243	1	519	599	MEN9347876.1 hypothetical protein [Bacteroidota bacterium]	diamond	243	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
11077094	11077094	PRJNA897077_P_NODE_15169_length_253_cov_0.866667_g15042_i0	PRJNA897077	15169	253	0.866667	2.19266751	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	139	1.2899999999999999e-38	NR	MBN2637135.1	2053594	g15042	i0	79.8	0.99604743083004	84	16	99.6	1	252	1	153	235	MBN2637135.1 prephenate dehydratase [Prolixibacteraceae bacterium]	diamond	252	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
17451811	17451811	PRJNA897077_P_NODE_17734_length_247_cov_0.896552_g17607_i0	PRJNA897077	17734	247	0.896552	2.21448344	Flavobacterium sp. N2	468057	Bacteria	Bacteria	70.5	2.33e-12	NR	WP_264551877.1	2986829	g17607	i0	69.2	1.40890688259109	39	12	47.4	0	245	129	212	250	WP_264551877.1 hypothetical protein [Flavobacterium sp. N2038]	diamond	348	70.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2038
21646311	21646311	PRJNA897077_P_NODE_16977_length_249_cov_0.886364_g16850_i0	PRJNA897077	16977	249	0.886364	2.20704636	Bacteroidota bacterium	1898104	Bacteria	Bacteria	171	3.4099999999999996e-48	NR	MBS1920145.1	1898104	g16850	i0	100	0.987951807228916	82	0	98.8	0	247	2	494	575	MBS1920145.1 acetate--CoA ligase [Bacteroidota bacterium]	diamond	246	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
25470834	25470834	PRJNA897077_P_NODE_13100_length_274_cov_1.547264_g12973_i0	PRJNA897077	13100	274	1.547264	4.23950336	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	169	4.78e-47	NR	NUQ12829.1	2026741	g12973	i0	91.1	0.985401459854015	90	8	98.5	0	272	3	556	645	NUQ12829.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Gemmatimonadaceae bacterium]	diamond	270	169	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27213562	27213562	PRJNA897077_P_NODE_12562_length_280_cov_1.280193_g12435_i0	PRJNA897077	12562	280	1.280193	3.5845404	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	76.3	1.68e-15	NR	HEY3013408.1	2448054	g12435	i0	45.6	1.71428571428571	90	49	96.4	0	7	276	17	106	HEY3013408.1 tetratricopeptide repeat protein [Gemmatimonadales bacterium]	diamond	480	76.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
27245345	27245345	PRJNA897077_P_NODE_16823_length_249_cov_0.886364_g16696_i0	PRJNA897077	16823	249	0.886364	2.20704636	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	94.7	1.99e-20	NR	HEX5072692.1	2026741	g16696	i0	57.5	2.86746987951807	80	34	96.4	0	247	8	496	575	HEX5072692.1 DUF2723 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	714	94.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28255761	28255761	PRJNA897077_P_NODE_16646_length_250_cov_0.881356_g16519_i0	PRJNA897077	16646	250	0.881356	2.20339	Cytophagales bacterium CG18_big_fil_WC_8_21_14_2_5	2053541	Bacteria	Bacteria	139	4.01e-37	NR	PIQ22398.1	1973956	g16519	i0	81.9	1.992	83	15	99.6	0	2	250	35	117	PIQ22398.1 MAG: UDP-glucose 6-dehydrogenase [Cytophagales bacterium CG18_big_fil_WC_8_21_14_2_50_42_9]	diamond	498	139	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium CG18_big_fil_WC_8_21_14_2_50_42_9
28263395	28263395	PRJNA897077_P_NODE_5846_length_401_cov_2.426829_g5719_i0	PRJNA897077	5846	401	2.426829	9.73158429	root	1	Root_unresolved	Root_unresolved	44.7	0.0421	NR	WP_290872743.1	239	g5719	i0	34.3	1.61596009975062	99	63	72.6	1	18	308	189	287	WP_290872743.1 Tex family protein [Flavobacterium sp.]	diamond	648	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30055562	30055562	PRJNA897077_P_NODE_15871_length_252_cov_0.871508_g15744_i0	PRJNA897077	15871	252	0.871508	2.19620016	Bacteroidales bacterium	2030927	Bacteria	Bacteria	137	8.49e-38	NR	HEY5471184.1	2030927	g15744	i0	75.9	0.988095238095238	83	20	98.8	0	4	252	200	282	HEY5471184.1 class I SAM-dependent methyltransferase [Bacteroidales bacterium]	diamond	249	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30118783	30118783	PRJNA897077_P_NODE_16432_length_250_cov_0.881356_g16305_i0	PRJNA897077	16432	250	0.881356	2.20339	Desertivirga xinjiangensis	539206	Bacteria	Bacteria	55.1	1.88e-6	NR	WP_256012532.1	539206	g16305	i0	45.3	1.512	64	26	76.8	1	240	49	921	975	WP_256012532.1 hypothetical protein [Desertivirga xinjiangensis]	diamond	378	55.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Desertivirga	Desertivirga xinjiangensis
30182023	30182023	PRJNA897077_P_NODE_18512_length_245_cov_0.906977_g18385_i0	PRJNA897077	18512	245	0.906977	2.22209365	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	94	1.91e-20	NR	MBT5874984.1	2053570	g18385	i0	54.2	4.06530612244898	83	36	99.2	2	243	1	48	130	MBT5874984.1 acetylxylan esterase [Candidatus Latescibacterota bacterium]	diamond	996	94	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota					Candidatus Latescibacterota bacterium
30529572	30529572	PRJNA897077_P_NODE_4993_length_434_cov_1.634349_g4866_i0	PRJNA897077	4993	434	1.634349	7.09307466	Candidatus Aegiribacteria sp.	2528271	Bacteria	Bacteria	77.8	9.7e-16	NR	MFO8183585.1	2528271	g4866	i0	58.1	0.428571428571429	62	26	42.9	0	6	191	18	79	MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.]	diamond	186	77.8	1	Bacteria	FCB group	Pseudomonadati					Candidatus Aegiribacteria	Candidatus Aegiribacteria sp.
31224641	31224641	PRJNA897077_P_NODE_16515_length_250_cov_0.881356_g16388_i0	PRJNA897077	16515	250	0.881356	2.20339	Bacteroidales bacterium	2030927	Bacteria	Bacteria	174	2.89e-50	NR	NLY22912.1	2030927	g16388	i0	100	0.984	82	0	98.4	0	248	3	266	347	NLY22912.1 hypothetical protein [Bacteroidales bacterium]	diamond	246	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31453990	31453990	PRJNA897077_P_NODE_17316_length_248_cov_0.891429_g17189_i0	PRJNA897077	17316	248	0.891429	2.21074392	Pseudomonadati	3379134	Bacteria	Bacteria	94	9.18e-21	NR	MBB27874.1	2026742	g17189	i0	68.2	2.39516129032258	66	21	79.8	0	198	1	1	66	MBB27874.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	594	94	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
32174020	32174020	PRJNA897077_P_NODE_19718_length_242_cov_0.923077_g19591_i0	PRJNA897077	19718	242	0.923077	2.23384634	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	102	3.06e-26	NR	HJR66347.1	2026741	g19591	i0	96.4	0.681818181818182	55	2	68.2	0	241	77	34	88	HJR66347.1 DUF2277 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	165	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32426948	32426948	PRJNA897077_P_NODE_18479_length_245_cov_0.906977_g18352_i0	PRJNA897077	18479	245	0.906977	2.22209365	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	107	1.6200000000000003e-27	NR	HET9636793.1	2026741	g18352	i0	64.5	0.930612244897959	76	27	93.1	0	230	3	1	76	HET9636793.1 isoprenylcysteine carboxylmethyltransferase family protein [Gemmatimonadaceae bacterium]	diamond	228	107	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32553786	32553786	PRJNA897077_P_NODE_59_length_2443_cov_6.406329_g50_i0	PRJNA897077	59	2443	6.406329	156.50661747	Flavobacterium collinsii	1114861	Bacteria	Bacteria	52	0.00681	NR	WP_395341608.1	1114861	g50	i0	26.7	0.353663528448629	288	156	31.7	14	200	973	47	309	WP_395341608.1 hypothetical protein [Flavobacterium collinsii]	diamond	864	52	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium collinsii

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