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

18 rows where analysis = "diamond", bioproject = "PRJNA891846" 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
16170093	16170093	PRJNA891846_P_NODE_40853_length_247_cov_0.885057_g40633_i0	PRJNA891846	40853	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	162	7.35e-48	NR	MBU6192931.1	1898104	g40633	i0	100	1.9919028340081	82	0	99.6	0	246	1	57	138	MBU6192931.1 transposase [Bacteroidota bacterium]	diamond	492	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26612258	26612258	PRJNA891846_P_NODE_41281_length_247_cov_0.885057_g41061_i0	PRJNA891846	41281	247	0.885057	2.18609079	Sinomicrobium sp.	1969735	Bacteria	Bacteria	100	4.91e-23	NR	MCB0376263.1	1969735	g41061	i0	63.4	0.995951417004049	82	30	99.6	0	1	246	30	111	MCB0376263.1 aldehyde dehydrogenase [Sinomicrobium sp.]	diamond	246	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Sinomicrobium	Sinomicrobium sp.
27276964	27276964	PRJNA891846_P_NODE_38723_length_249_cov_0.875000_g38503_i0	PRJNA891846	38723	249	0.875	2.17875	Bacteroidota bacterium	1898104	Bacteria	Bacteria	45.4	9.14e-4	NR	MFN5055717.1	1898104	g38503	i0	95	0.240963855421687	20	1	24.1	0	1	60	83	102	MFN5055717.1 hypothetical protein [Bacteroidota bacterium]	diamond	60	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27371990	27371990	PRJNA891846_P_NODE_47243_length_241_cov_0.916667_g47023_i0	PRJNA891846	47243	241	0.916667	2.20916747	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	42.4	0.0456	NR	HVX52277.1	1869212	g47023	i0	36.8	0.70954356846473	57	36	71	0	173	3	205	261	HVX52277.1 tyrosine-type recombinase/integrase [Chitinophagaceae bacterium]	diamond	171	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27560927	27560927	PRJNA891846_P_NODE_39004_length_249_cov_0.875000_g38784_i0	PRJNA891846	39004	249	0.875	2.17875	Bacteroidota bacterium	1898104	Bacteria	Bacteria	163	1.24e-44	NR	MFM8492274.1	1898104	g38784	i0	100	2.96385542168675	82	0	98.8	0	247	2	413	494	MFM8492274.1 M43 family zinc metalloprotease [Bacteroidota bacterium]	diamond	738	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27624437	27624437	PRJNA891846_P_NODE_14944_length_392_cov_1.200627_g14725_i0	PRJNA891846	14944	392	1.2006270000000001	4.70645784	Candidatus Opimibacter skivensis	2982028	Bacteria	Bacteria	58.5	6.27e-7	NR	MBK8829718.1	2982028	g14725	i0	52.3	1.85969387755102	44	21	33.7	0	261	392	2228	2271	MBK8829718.1 proprotein convertase P-domain-containing protein [Candidatus Opimibacter skivensis]	diamond	729	58.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae	Candidatus Opimibacter	Candidatus Opimibacter skivensis
28161210	28161210	PRJNA891846_P_NODE_35685_length_254_cov_1.596685_g35465_i0	PRJNA891846	35685	254	1.596685	4.0555799	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	41.6	0.0486	NR	HET7604195.1	2448054	g35465	i0	40.4	0.614173228346457	52	30	61.4	1	207	52	44	94	HET7604195.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	156	41.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
28326523	28326523	PRJNA891846_P_NODE_38866_length_249_cov_0.875000_g38646_i0	PRJNA891846	38866	249	0.875	2.17875	Saprospirales	1936988	Bacteria	Bacteria	153	2.8999999999999996e-44	NR	MFN5788723.1	1898104	g38646	i0	98.8	5.92771084337349	82	1	98.8	0	248	3	119	200	MFN5788723.1 glycosyl hydrolase [Bacteroidota bacterium]	diamond	1476	153	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28729403	28729403	PRJNA891846_P_NODE_45087_length_243_cov_0.905882_g44867_i0	PRJNA891846	45087	243	0.905882	2.20129326	Mucilaginibacter myungsuensis	649104	Bacteria	Bacteria	55.8	9.17e-7	NR	WP_194110161.1	649104	g44867	i0	36.2	0.851851851851852	69	42	82.7	1	1	201	465	533	WP_194110161.1 tetratricopeptide repeat protein [Mucilaginibacter myungsuensis]	diamond	207	55.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter myungsuensis
29589306	29589306	PRJNA891846_P_NODE_43550_length_245_cov_0.889535_g43330_i0	PRJNA891846	43550	245	0.889535	2.17936075	Chryseobacterium	59732	Bacteria	Bacteria	43.9	0.0144	NR	WP_153398067.1	59732	g43330	i0	35.2	13.9102040816327	71	39	78.4	2	37	228	220	290	WP_153398067.1 MULTISPECIES: Pycsar system effector family protein [Chryseobacterium]	diamond	3408	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium
29707709	29707709	PRJNA891846_P_NODE_40750_length_247_cov_0.885057_g40530_i0	PRJNA891846	40750	247	0.885057	2.18609079	Candidatus Kapaibacterium sp.	2447898	Bacteria	Bacteria	151	2.62e-40	NR	MBU3678480.1	2447898	g40530	i0	86.4	0.983805668016194	81	11	98.4	0	245	3	370	450	MBU3678480.1 YfhO family protein [Candidatus Kapaibacterium sp.]	diamond	243	151	1	Bacteria	FCB group	Pseudomonadati	Candidatus Kapaibacteriota	Candidatus Kapaibacteriia	Candidatus Kapaibacteriales	Candidatus Kapaibacteriaceae	Candidatus Kapaibacterium	Candidatus Kapaibacterium sp.
29771141	29771141	PRJNA891846_P_NODE_43211_length_245_cov_0.895349_g42991_i0	PRJNA891846	43211	245	0.895349	2.19360505	Bacteroidota bacterium	1898104	Bacteria	Bacteria	164	5.709999999999999e-46	NR	MFM1893460.1	1898104	g42991	i0	98.8	0.991836734693878	81	1	99.2	0	243	1	213	293	MFM1893460.1 hypothetical protein [Bacteroidota bacterium]	diamond	243	164	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
29802812	29802812	PRJNA891846_P_NODE_41551_length_246_cov_1.670520_g41331_i0	PRJNA891846	41551	246	1.67052	4.1094792	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	45.4	0.00431	NR	MDB5104163.1	2052160	g41331	i0	56.1	1	41	14	45.1	1	233	123	498	538	MDB5104163.1 hypothetical protein [Fibrobacterota bacterium]	diamond	246	45.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30537310	30537310	PRJNA891846_P_NODE_44293_length_244_cov_0.900585_g44073_i0	PRJNA891846	44293	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	117	4.0699999999999997e-32	NR	MEY3541988.1	1898104	g44073	i0	72.2	1.77049180327869	72	20	88.5	0	1	216	33	104	MEY3541988.1 iron-sulfur cluster assembly accessory protein [Bacteroidota bacterium]	diamond	432	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30592613	30592613	PRJNA891846_P_NODE_40833_length_247_cov_0.885057_g40613_i0	PRJNA891846	40833	247	0.885057	2.18609079	Flavobacteriia bacterium	2044941	Bacteria	Bacteria	85.5	7.67e-19	NR	NBV09774.1	2044941	g40613	i0	76	0.607287449392713	50	12	60.7	0	2	151	53	102	NBV09774.1 hypothetical protein [Flavobacteriia bacterium]	diamond	150	85.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				Flavobacteriia bacterium
30813839	30813839	PRJNA891846_P_NODE_44414_length_244_cov_0.900585_g44194_i0	PRJNA891846	44414	244	0.900585	2.1974274	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	106	9.39e-26	NR	TAG97405.1	2044944	g44194	i0	79.7	0.848360655737705	69	14	84.8	0	243	37	186	254	TAG97405.1 MAG: 23S rRNA pseudouridine(2604) synthase RluF [Sphingobacteriales bacterium]	diamond	207	106	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
31129485	31129485	PRJNA891846_P_NODE_38155_length_250_cov_0.870056_g37935_i0	PRJNA891846	38155	250	0.870056	2.17514	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	119	1.41e-29	NR	MCU0381210.1	1869212	g37935	i0	65.1	1.992	83	29	99.6	0	250	2	77	159	MCU0381210.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Chitinophagaceae bacterium]	diamond	498	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31446058	31446058	PRJNA891846_P_NODE_39796_length_248_cov_0.880000_g39576_i0	PRJNA891846	39796	248	0.88	2.1824	Bacteroidota bacterium	1898104	Bacteria	Bacteria	112	1.59e-28	NR	MBM3168109.1	1898104	g39576	i0	94.8	0.701612903225806	58	3	70.2	0	248	75	184	241	MBM3168109.1 class I SAM-dependent methyltransferase [Bacteroidota bacterium]	diamond	174	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium

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