metadata: contig_metadata: 30 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax

30 rows where analysis = "diamond", bioproject = "PRJEB49404" 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
5201021	5201021	PRJEB49404_P_NODE_248185_length_302_cov_1.840304_g234384_i0	PRJEB49404	248185	302	1.840304	5.55771808	Chitinophagaceae	563835	Bacteria	Bacteria	168	6.749999999999999e-47	NR	WP_325587243.1	2045100	g234384	i0	75	2.98013245033113	100	25	99.3	0	3	302	275	374	WP_325587243.1 glycoside hydrolase family 2 protein [Puia sp.]	diamond	900	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Puia	Puia sp.
15407793	15407793	PRJEB49404_P_NODE_391473_length_217_cov_2.022472_g377672_i0	PRJEB49404	391473	217	2.022472	4.38876424	Chitinophaga sp.	1869181	Bacteria	Bacteria	92.4	8.79e-20	NR	WP_325535649.1	1869181	g377672	i0	59.7	0.995391705069124	72	29	99.5	0	216	1	3024	3095	WP_325535649.1 non-ribosomal peptide synthetase [Chitinophaga sp.]	diamond	216	92.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga sp.
18842738	18842738	PRJEB49404_P_NODE_576515_length_164_cov_1.312000_g562714_i0	PRJEB49404	576515	164	1.312	2.15168	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	93.6	1.57e-20	NR	HET6763538.1	3047548	g562714	i0	81.5	8.85365853658537	54	10	98.8	0	2	163	702	755	HET6763538.1 heavy metal translocating P-type ATPase [Longimicrobiaceae bacterium]	diamond	1452	93.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
26653380	26653380	PRJEB49404_P_NODE_515441_length_178_cov_1.179856_g501640_i0	PRJEB49404	515441	178	1.179856	2.10014368	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	104	1.19e-25	NR	MBC7843561.1	2026741	g501640	i0	76.3	0.99438202247191	59	14	99.4	0	2	178	22	80	MBC7843561.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	177	104	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
26837089	26837089	PRJEB49404_P_NODE_493501_length_183_cov_2.888889_g479700_i0	PRJEB49404	493501	183	2.888889	5.28666687	Pseudomonadati	3379134	Bacteria	Bacteria	42	0.0255	NR	MEE2899207.1	2026742	g479700	i0	41.4	1.9344262295082	58	31	93.4	2	9	179	13	68	MEE2899207.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	354	42	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27222976	27222976	PRJEB49404_P_NODE_359963_length_231_cov_1.708333_g346162_i0	PRJEB49404	359963	231	1.708333	3.94624923	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	50.1	3.71e-5	NR	RYY83660.1	1869212	g346162	i0	46.2	1.35064935064935	52	27	67.5	1	229	74	121	171	RYY83660.1 MAG: hypothetical protein EOO15_20955 [Chitinophagaceae bacterium]	diamond	312	50.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27286354	27286354	PRJEB49404_P_NODE_334143_length_244_cov_1.678049_g320342_i0	PRJEB49404	334143	244	1.678049	4.09443956	Bacteroidota bacterium	1898104	Bacteria	Bacteria	48.9	2.39e-4	NR	MEM1318645.1	1898104	g320342	i0	47.8	0.565573770491803	46	24	56.6	0	146	9	367	412	MEM1318645.1 polysaccharide deacetylase family protein [Bacteroidota bacterium]	diamond	138	48.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27437900	27437900	PRJEB49404_P_NODE_347203_length_237_cov_2.212121_g333402_i0	PRJEB49404	347203	237	2.212121	5.24272677	Pseudomonadati	3379134	Bacteria	Bacteria	139	4.18e-37	NR	HEX6748314.1	2029185	g333402	i0	76.9	3.9493670886076	78	18	98.7	0	2	235	369	446	HEX6748314.1 epoxide hydrolase [Longimicrobium sp.]	diamond	936	139	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
27911013	27911013	PRJEB49404_P_NODE_271525_length_283_cov_2.196721_g257724_i0	PRJEB49404	271525	283	2.196721	6.21672043	Bacteria	2	Bacteria	Bacteria	47.4	0.00129	NR	MBA3406070.1	2026741	g257724	i0	46.3	0.795053003533569	41	22	43.5	0	131	9	1	41	MBA3406070.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	225	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28044247	28044247	PRJEB49404_P_NODE_502625_length_181_cov_1.591549_g488824_i0	PRJEB49404	502625	181	1.591549	2.88070369	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	60.5	9.08e-9	NR	MCC6430334.1	2026741	g488824	i0	56.7	1.95580110497238	60	26	99.4	0	2	181	56	115	MCC6430334.1 IS66 family transposase [Gemmatimonadaceae bacterium]	diamond	354	60.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28391575	28391575	PRJEB49404_P_NODE_614866_length_156_cov_2.581197_g601065_i0	PRJEB49404	614866	156	2.581197	4.02666732	Bacteroidota bacterium	1898104	Bacteria	Bacteria	91.7	6.53e-20	NR	MDE3056427.1	1898104	g601065	i0	84.3	2.94230769230769	51	8	98.1	0	2	154	649	699	MDE3056427.1 efflux RND transporter permease subunit [Bacteroidota bacterium]	diamond	459	91.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28448207	28448207	PRJEB49404_P_NODE_370606_length_226_cov_1.754011_g356805_i0	PRJEB49404	370606	226	1.754011	3.96406486	Bacteria	2	Bacteria	Bacteria	92	5.95e-21	NR	WP_016274504.1	820	g356805	i0	100	1.71238938053097	43	0	57.1	0	224	96	177	219	WP_016274504.1 hypothetical protein, partial [Bacteroides uniformis]	diamond	387	92	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
29016686	29016686	PRJEB49404_P_NODE_589548_length_161_cov_2.016393_g575747_i0	PRJEB49404	589548	161	2.016393	3.24639273	Polaribacter	52959	Bacteria	Bacteria	44.3	0.00353	NR	WP_105022673.1	102	g575747	i0	55.6	2.01242236024845	36	16	67.1	0	9	116	378	413	WP_105022673.1 TonB-dependent receptor [Polaribacter glomeratus]	diamond	324	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter glomeratus
29149770	29149770	PRJEB49404_P_NODE_616849_length_156_cov_1.589744_g603048_i0	PRJEB49404	616849	156	1.589744	2.48000064	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	92	1.14e-22	NR	HZD84984.1	2026741	g603048	i0	90.2	0.980769230769231	51	5	98.1	0	2	154	43	93	HZD84984.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium]	diamond	153	92	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29433206	29433206	PRJEB49404_P_NODE_430290_length_203_cov_1.054878_g416489_i0	PRJEB49404	430290	203	1.054878	2.14140234	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	142	5.469999999999999e-40	NR	MBN8856689.1	2044944	g416489	i0	100	0.990147783251232	67	0	99	0	3	203	78	144	MBN8856689.1 DNA polymerase III subunit epsilon [Sphingobacteriales bacterium]	diamond	201	142	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
29489806	29489806	PRJEB49404_P_NODE_532530_length_174_cov_0.911111_g518729_i0	PRJEB49404	532530	174	0.911111	1.58533314	Pseudomonadati	3379134	Bacteria	Bacteria	45.8	0.00119	NR	WP_040005850.1	663275	g518729	i0	44.2	5.1551724137931	52	27	86.2	1	17	166	546	597	WP_040005850.1 S9 family peptidase [Fibrisoma limi]	diamond	897	45.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrisoma	Fibrisoma limi
29528332	29528332	PRJEB49404_P_NODE_463430_length_192_cov_1.607843_g449629_i0	PRJEB49404	463430	192	1.607843	3.08705856	Lacibacter cauensis	510947	Bacteria	Bacteria	124	1.7299999999999999e-34	NR	WP_144888756.1	510947	g449629	i0	95.3	1	64	3	100	0	192	1	7	70	WP_144888756.1 JAB domain-containing protein [Lacibacter cauensis]	diamond	192	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter cauensis
30096609	30096609	PRJEB49404_P_NODE_643072_length_151_cov_2.169643_g629271_i0	PRJEB49404	643072	151	2.169643	3.27616093	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	104	4.63e-26	NR	MCA6440760.1	1869212	g629271	i0	100	0.973509933774834	49	0	97.4	0	149	3	22	70	MCA6440760.1 cupin domain-containing protein [Chitinophagaceae bacterium]	diamond	147	104	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
30318425	30318425	PRJEB49404_P_NODE_291592_length_269_cov_2.139130_g277791_i0	PRJEB49404	291592	269	2.13913	5.7542597	Rhodothermales bacterium	2306054	Bacteria	Bacteria	43.5	0.0262	NR	MEQ9105442.1	2306054	g277791	i0	43.8	0.713754646840149	64	34	69.1	1	245	60	264	327	MEQ9105442.1 aminotransferase class V-fold PLP-dependent enzyme [Rhodothermales bacterium]	diamond	192	43.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
30791795	30791795	PRJEB49404_P_NODE_541074_length_172_cov_1.007519_g527273_i0	PRJEB49404	541074	172	1.007519	1.73293268	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	42	0.0276	NR	MFO0359999.1	2021391	g527273	i0	36.4	0.959302325581395	55	27	85.5	2	7	153	223	275	MFO0359999.1 hypothetical protein [Flavobacteriales bacterium]	diamond	165	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
30974806	30974806	PRJEB49404_P_NODE_377394_length_223_cov_1.885870_g363593_i0	PRJEB49404	377394	223	1.88587	4.2054901	Bacteria	2	Bacteria	Bacteria	63.2	1.77e-9	NR	MCC6395586.1	1898104	g363593	i0	61	2.23318385650224	41	16	55.2	0	3	125	430	470	MCC6395586.1 tetratricopeptide repeat protein [Bacteroidota bacterium]	diamond	498	63.5	0.995275590551181	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31423941	31423941	PRJEB49404_P_NODE_613076_length_157_cov_1.322034_g599275_i0	PRJEB49404	613076	157	1.322034	2.07559338	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	53.1	2.47e-6	NR	HXI32920.1	2448054	g599275	i0	50	1.98726114649682	52	26	99.4	0	157	2	444	495	HXI32920.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	312	53.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31740100	31740100	PRJEB49404_P_NODE_585057_length_162_cov_1.764228_g571256_i0	PRJEB49404	585057	162	1.764228	2.85804936	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	52.8	3.25e-6	NR	HXW96391.1	2448054	g571256	i0	52.1	0.888888888888889	48	23	88.9	0	17	160	57	104	HXW96391.1 class I SAM-dependent methyltransferase [Gemmatimonadales bacterium]	diamond	144	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31834964	31834964	PRJEB49404_P_NODE_381337_length_221_cov_2.653846_g367536_i0	PRJEB49404	381337	221	2.653846	5.86499966	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	79.3	2.69e-15	NR	HEX6535207.1	2026741	g367536	i0	66.1	0.841628959276018	62	20	84.2	1	189	4	168	228	HEX6535207.1 OmpA family protein [Gemmatimonadaceae bacterium]	diamond	186	79.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31891672	31891672	PRJEB49404_P_NODE_473297_length_189_cov_1.760000_g459496_i0	PRJEB49404	473297	189	1.76	3.3264	Bacteria	2	Bacteria	Bacteria	84.3	4.13e-17	NR	WP_331876069.1	2029185	g459496	i0	65.1	9	63	22	100	0	189	1	532	594	WP_331876069.1 toxin TcdB middle/N-terminal domain-containing protein, partial [Longimicrobium sp.]	diamond	1701	85.1	0.990599294947121	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
31961633	31961633	PRJEB49404_P_NODE_580838_length_163_cov_1.637097_g567037_i0	PRJEB49404	580838	163	1.637097	2.66846811	Olivibacter sitiensis	376470	Bacteria	Bacteria	62	1.94e-9	NR	WP_281169879.1	376470	g567037	i0	64	2.79754601226994	50	18	92	0	155	6	582	631	WP_281169879.1 Ig-like domain-containing protein [Olivibacter sitiensis]	diamond	456	62	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Olivibacter	Olivibacter sitiensis
32025038	32025038	PRJEB49404_P_NODE_473898_length_189_cov_1.580000_g460097_i0	PRJEB49404	473898	189	1.58	2.9862	Hydrobacter penzbergensis	1235997	Bacteria	Bacteria	77.4	5.61e-15	NR	WP_092723688.1	1235997	g460097	i0	97.4	0.619047619047619	39	1	61.9	0	189	73	274	312	WP_092723688.1 efflux RND transporter periplasmic adaptor subunit [Hydrobacter penzbergensis]	diamond	117	77.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrobacter	Hydrobacter penzbergensis
32025039	32025039	PRJEB49404_P_NODE_483058_length_186_cov_2.231293_g469257_i0	PRJEB49404	483058	186	2.231293	4.15020498	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	67.8	2.63e-11	NR	MBD24551.1	2026760	g469257	i0	50.8	0.983870967741935	61	30	98.4	0	183	1	201	261	MBD24551.1 TonB-dependent receptor [Fidelibacterota bacterium]	diamond	183	67.8	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota					Fidelibacterota bacterium
32056582	32056582	PRJEB49404_P_NODE_269078_length_285_cov_1.878049_g255277_i0	PRJEB49404	269078	285	1.878049	5.35243965	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	182	5.73e-57	NR	MBN8856722.1	2044944	g255277	i0	100	1	95	0	100	0	1	285	31	125	MBN8856722.1 hypothetical protein [Sphingobacteriales bacterium]	diamond	285	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
32246815	32246815	PRJEB49404_P_NODE_447638_length_197_cov_1.550633_g433837_i0	PRJEB49404	447638	197	1.550633	3.05474701	Hydrobacter penzbergensis	1235997	Bacteria	Bacteria	137	2.56e-39	NR	WP_092722684.1	1235997	g433837	i0	100	0.989847715736041	65	0	99	0	1	195	89	153	WP_092722684.1 GNAT family N-acetyltransferase [Hydrobacter penzbergensis]	diamond	195	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrobacter	Hydrobacter penzbergensis

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