metadata: contig_metadata: 22 rows where bioproject = "PRJNA690234" and tax

22 rows where bioproject = "PRJNA690234" 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
670378	670378	PRJNA690234_P_NODE_31181_length_243_cov_0.917647_g30814_i0	PRJNA690234	31181	243	0.917647	2.22988221	Cloacibacterium caeni	2004710	Bacteria	Bacteria	424	4.03e-114	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g30814	i0	98.34	3.95473251028807	241	4	99	0	1	241	1703420	1703660	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	961	424	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
5773764	5773764	PRJNA690234_P_NODE_24605_length_255_cov_1.686813_g24238_i0	PRJNA690234	24605	255	1.686813	4.30137315	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	366	7.28e-97	NTclustered	gi\|1640052653\|emb\|LR590484.1\|	259	g24238	i0	92.549	463.003921568627	255	19	100	0	1	255	1037431	1037685	Sphingobacterium thalpophilum strain NCTC11429 genome assembly, chromosome: 1	blastn	118066	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
6282857	6282857	PRJNA690234_P_NODE_20765_length_278_cov_2.439024_g20398_i0	PRJNA690234	20765	278	2.439024	6.78048672	Dysgonomonadaceae	2005520	Bacteria	Bacteria	431	2.81e-116	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g20398	i0	94.604	290.172661870504	278	15	100	0	1	278	1012783	1012506	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	80668	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
7048785	7048785	PRJNA690234_P_NODE_24546_length_255_cov_2.434066_g24179_i0	PRJNA690234	24546	255	2.434066	6.2068683	Dysgonomonadaceae bacterium zrk40	2811465	Bacteria	Bacteria	239	1.66e-58	NTclustered	gi\|1992198317\|gb\|CP070276.1\|	2811465	g24179	i0	87.264	323.576470588235	212	24	99	3	1	210	4980	5190	Dysgonomonadaceae bacterium zrk40 chromosome, complete genome	blastn	82512	239	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae		Dysgonomonadaceae bacterium zrk40
14698941	14698941	PRJNA690234_P_NODE_16412_length_314_cov_1.278008_g16045_i0	PRJNA690234	16412	314	1.278008	4.01294512	Hymenobacter sp. 21/4	369951	Bacteria	Bacteria	496	1.1299999999999999e-135	NTclustered	gi\|87042293\|gb\|DQ365992.1\|	369951	g16045	i0	95.223	99.8025477707006	314	13	99	2	1	313	273	585	Hymenobacter sp. 21/4 16S ribosomal RNA gene, partial sequence	blastn	31338	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 21/4
19797133	19797133	PRJNA690234_P_NODE_24696_length_254_cov_5.243094_g24329_i0	PRJNA690234	24696	254	5.243094	13.31745876	Cloacibacterium caeni	2004710	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g24329	i0	99.606	126.263779527559	254	1	100	0	1	254	1875941	1875688	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	32071	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
21072565	21072565	PRJNA690234_P_NODE_22117_length_270_cov_1.187817_g21750_i0	PRJNA690234	22117	270	1.187817	3.2071059	Mucilaginibacter robiniae	2728022	Bacteria	Bacteria	62.1	4.11e-5	NTclustered	gi\|1835012336\|gb\|CP051682.1\|	2728022	g21750	i0	92.857	0.155555555555556	42	3	16	0	51	92	3141518	3141559	Mucilaginibacter robiniae strain F39-2 chromosome, complete genome	blastn	42	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter robiniae
21072714	21072714	PRJNA690234_P_NODE_28077_length_248_cov_0.891429_g27710_i0	PRJNA690234	28077	248	0.891429	2.21074392	Cloacibacterium caeni	2004710	Bacteria	Bacteria	442	1.1399999999999995e-119	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g27710	i0	98.79	18.8709677419355	248	3	100	0	1	248	1190719	1190472	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	4680	442	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
24896449	24896449	PRJNA690234_P_NODE_25060_length_253_cov_0.866667_g24693_i0	PRJNA690234	25060	253	0.866667	2.19266751	Cloacibacterium normanense	237258	Bacteria	Bacteria	418	1.9599999999999994e-112	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g24693	i0	96.443	4.93280632411067	253	9	100	0	1	253	890718	890970	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1248	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
26861221	26861221	PRJNA690234_P_NODE_25461_length_252_cov_1.743017_g25094_i0	PRJNA690234	25461	252	1.743017	4.39240284	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	136	3.36e-36	NR	MFI5203427.1	2021391	g25094	i0	75	32.7738095238095	84	21	100	0	252	1	245	328	MFI5203427.1 ornithine--oxo-acid transaminase [Flavobacteriales bacterium]	diamond	8259	136	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27335409	27335409	PRJNA690234_P_NODE_6043_length_526_cov_20.041943_g5679_i0	PRJNA690234	6043	526	20.041943	105.42062018	Candidatus Aegiribacteria sp.	2528271	Bacteria	Bacteria	94.7	5.88e-22	NR	MFO8183585.1	2528271	g5679	i0	57.7	1.39733840304182	78	33	44.5	0	505	272	2	79	MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.]	diamond	735	94.7	1	Bacteria	FCB group	Pseudomonadati					Candidatus Aegiribacteria	Candidatus Aegiribacteria sp.
27430268	27430268	PRJNA690234_P_NODE_10703_length_390_cov_1.637224_g10337_i0	PRJNA690234	10703	390	1.637224	6.3851736	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	44.3	0.0444	NR	MBI34595.1	2021391	g10337	i0	32.4	0.569230769230769	74	47	56.9	1	228	7	118	188	MBI34595.1 hypothetical protein [Flavobacteriales bacterium]	diamond	222	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
27682961	27682961	PRJNA690234_P_NODE_2024_length_929_cov_5.154206_g1746_i0	PRJNA690234	2024	929	5.154206	47.88257374	Yeosuana aromativorans	288019	Bacteria	Bacteria	52.8	4.14e-4	NR	WP_188650315.1	288019	g1746	i0	26.8	0.67491926803014	209	131	62.3	6	859	281	9	211	WP_188650315.1 LolA family protein [Yeosuana aromativorans]	diamond	627	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Yeosuana	Yeosuana aromativorans
27883445	27883445	PRJNA690234_P_NODE_23765_length_260_cov_1.363636_g23398_i0	PRJNA690234	23765	260	1.363636	3.5454536	FCB group	1783270	Bacteria	Bacteria	67.8	6.88e-11	NR	MFT5210989.1	239	g23398	i0	48.2	10.4884615384615	85	43	98.1	1	256	2	196	279	MFT5210989.1 choline dehydrogenase-like flavoprotein [Flavobacterium sp.]	diamond	2727	67.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
27883446	27883446	PRJNA690234_P_NODE_25405_length_253_cov_0.866667_g25038_i0	PRJNA690234	25405	253	0.866667	2.19266751	Flavobacteriales	200644	Bacteria	Bacteria	58.2	1.44e-7	NR	HEY6143543.1	239	g25038	i0	82.4	3.61660079051383	34	6	40.3	0	152	253	1	34	HEY6143543.1 acyltransferase family protein [Flavobacterium sp.]	diamond	915	58.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
30082240	30082240	PRJNA690234_P_NODE_27892_length_248_cov_1.337143_g27525_i0	PRJNA690234	27892	248	1.337143	3.31611464	Bacteroidales bacterium	2030927	Bacteria	Bacteria	61.6	7.29e-9	NR	MCX7953585.1	2030927	g27525	i0	46.6	2.84274193548387	58	31	70.2	0	73	246	22	79	MCX7953585.1 NAD-dependent epimerase/dehydratase family protein [Bacteroidales bacterium]	diamond	705	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30461978	30461978	PRJNA690234_P_NODE_22333_length_268_cov_2.507692_g21966_i0	PRJNA690234	22333	268	2.507692	6.72061456	Parafilimonas sp.	1969739	Bacteria	Bacteria	89.4	1.03e-18	NR	HYK45670.1	1969739	g21966	i0	50.6	0.951492537313433	85	42	95.1	0	268	14	35	119	HYK45670.1 HesA/MoeB/ThiF family protein [Parafilimonas sp.]	diamond	255	89.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Parafilimonas	Parafilimonas sp.
30650848	30650848	PRJNA690234_P_NODE_12173_length_363_cov_1.851724_g11806_i0	PRJNA690234	12173	363	1.851724	6.72175812	Lacibacter sp.	1915409	Bacteria	Bacteria	47	0.00307	NR	WP_324232586.1	1915409	g11806	i0	31.9	0.776859504132231	94	63	76.9	1	44	322	3	96	WP_324232586.1 hypothetical protein [Lacibacter sp.]	diamond	282	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp.
30650851	30650851	PRJNA690234_P_NODE_16013_length_318_cov_0.918367_g15646_i0	PRJNA690234	16013	318	0.918367	2.92040706	Bacteroidia bacterium	2044936	Bacteria	Bacteria	43.5	0.0474	NR	MEI8115686.1	2044936	g15646	i0	36.1	0.575471698113208	61	36	57.5	1	119	301	621	678	MEI8115686.1 Ig-like domain-containing protein [Bacteroidia bacterium]	diamond	183	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
31314721	31314721	PRJNA690234_P_NODE_22895_length_265_cov_1.625000_g22528_i0	PRJNA690234	22895	265	1.625	4.30625	Weeksellaceae bacterium A-14	3143028	Bacteria	Bacteria	42.4	0.0473	NR	MEN2436866.1	3143028	g22528	i0	34.8	1.00754716981132	89	50	95.1	2	263	12	92	177	MEN2436866.1 hypothetical protein [Weeksellaceae bacterium A-14]	diamond	267	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium A-14
31441174	31441174	PRJNA690234_P_NODE_26296_length_251_cov_0.876404_g25929_i0	PRJNA690234	26296	251	0.876404	2.19977404	Kaistella carnis	1241979	Bacteria	Bacteria	126	1.7399999999999999e-31	NR	WP_312820434.1	1241979	g25929	i0	75.9	0.99203187250996006	83	20	99.2	0	250	2	175	257	WP_312820434.1 UvrD-helicase domain-containing protein [Kaistella carnis]	diamond	249	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella carnis
31757531	31757531	PRJNA690234_P_NODE_21197_length_275_cov_2.361386_g20830_i0	PRJNA690234	21197	275	2.361386	6.4938115	Salibacteraceae bacterium	2832350	Bacteria	Bacteria	52.4	2.11e-5	NR	MDC1222222.1	2832350	g20830	i0	41	2.07272727272727	61	35	65.5	1	94	273	2	62	MDC1222222.1 DnaJ domain-containing protein [Salibacteraceae bacterium]	diamond	570	52.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Salibacteraceae		Salibacteraceae 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);;