metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJEB55122" and tax

30 rows where analysis = "blastn", bioproject = "PRJEB55122" 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
120739	120739	PRJEB55122_P_NODE_21961_length_233_cov_2.179348_g21564_i0	PRJEB55122	21961	233	2.179348	5.07788084	Cloacibacterium caeni	2004710	Bacteria	Bacteria	403	4.9999999999999985e-108	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g21564	i0	97.854	331	233	5	100	0	1	233	1987897	1988129	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	77123	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
121355	121355	PRJEB55122_P_NODE_42361_length_163_cov_0.912281_g41964_i0	PRJEB55122	42361	163	0.912281	1.48701803	Cloacibacterium caeni	2004710	Bacteria	Bacteria	198	1.6499999999999999e-46	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g41964	i0	89.677	2.8159509202454	155	16	95	0	9	163	2615836	2615682	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	459	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
1395149	1395149	PRJEB55122_P_NODE_21722_length_235_cov_1.623656_g21325_i0	PRJEB55122	21722	235	1.623656	3.8155916	Candidatus Shikimatogenerans bostrichidophilus	2943807	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2492073264\|gb\|CP099825.1\|	2943807	g21325	i0	100	0.119148936170213	28	0	12	0	21	48	164313	164286	MAG: Candidatus Shikimatogenerans bostrichidophilus isolate TIMP chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales		Candidatus Shikimatogenerans	Candidatus Shikimatogenerans bostrichidophilus
3542327	3542327	PRJEB55122_P_NODE_42743_length_163_cov_0.912281_g42346_i0	PRJEB55122	42743	163	0.912281	1.48701803	Weeksellaceae	2762318	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g42346	i0	100	9.87730061349693	163	0	100	0	1	163	956361	956199	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	1610	302	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
4819739	4819739	PRJEB55122_P_NODE_8664_length_450_cov_3.645885_g8270_i0	PRJEB55122	8664	450	3.645885	16.4064825	Aquimarina	290174	Bacteria	Bacteria	78.7	7.19e-10	NTclustered	gi\|2261239293\|emb\|OX030782.1\|	1191912	g8270	i0	83.951	1.42666666666667	81	13	18	0	256	336	5385456	5385536	Aquimarina sp. Aq107 genome assembly, chromosome: 1	blastn	642	78.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. Aq107
5223651	5223651	PRJEB55122_P_NODE_35205_length_173_cov_1.653226_g34808_i0	PRJEB55122	35205	173	1.653226	2.86008098	Prevotella corporis	28128	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|2446185766\|gb\|CP118020.1\|	28128	g34808	i0	99.422	195.445086705202	173	1	100	0	1	173	1695765	1695593	Prevotella corporis strain OB21 FMU 4 chromosome 1, complete sequence	blastn	33812	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella corporis
6499265	6499265	PRJEB55122_P_NODE_31146_length_187_cov_2.014493_g30749_i0	PRJEB55122	31146	187	2.014493	3.76710191	Runella sp. SP2	2268026	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g30749	i0	100	237.946524064171	187	0	100	0	1	187	5734505	5734691	Runella sp. SP2 chromosome, complete genome	blastn	44496	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
6499295	6499295	PRJEB55122_P_NODE_31946_length_184_cov_2.296296_g31549_i0	PRJEB55122	31946	184	2.296296	4.22518464	Prevotella sp. CAG:755	1262935	Bacteria	Bacteria	108	3.3e-19	NTclustered	gi\|2729058689\|emb\|OZ006989.1\|	1262935	g31549	i0	96.923	0.71195652173913	65	1	35	1	39	103	2563506	2563569	MAG: Prevotella sp. CAG:755 isolate metabat2_pooled_metaflye.50 MAG genome assembly, chromosome: 1	blastn	131	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. CAG:755
9048483	9048483	PRJEB55122_P_NODE_36988_length_169_cov_0.866667_g36591_i0	PRJEB55122	36988	169	0.866667	1.46466723	Cloacibacterium caeni	2004710	Bacteria	Bacteria	274	2.7699999999999997e-69	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g36591	i0	96.933	8.39644970414201	163	5	96	0	1	163	431442	431604	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	1419	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
9919951	9919951	PRJEB55122_P_NODE_25888_length_210_cov_1.291925_g25491_i0	PRJEB55122	25888	210	1.291925	2.7130425	Prevotella	838	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g25491	i0	99.524	224.690476190476	210	1	100	0	1	210	168868	168659	Prevotella nigrescens strain FDAARGOS_1486 chromosome, complete genome	blastn	47185	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
9919953	9919953	PRJEB55122_P_NODE_29148_length_195_cov_1.424658_g28751_i0	PRJEB55122	29148	195	1.424658	2.7780831	root	1	Root_unresolved	Root_unresolved	361	2.46e-95	NTclustered	gi\|744825509\|gb\|KP326380.1\|	28129	g28751	i0	100	102	195	0	100	0	1	195	524	718	Prevotella denticola strain 67-4a 16S ribosomal RNA gene, partial sequence	blastn	19890	361	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
10323275	10323275	PRJEB55122_P_NODE_10149_length_401_cov_2.715909_g9755_i0	PRJEB55122	10149	401	2.715909	10.89079509	Epilithonimonas zeae	1416779	Bacteria	Bacteria	734	0	NTclustered	gi\|2235581928\|gb\|CP075338.1\|	1416779	g9755	i0	99.75	479.473815461347	400	1	99	0	1	400	2242885	2242486	Epilithonimonas zeae strain ZM18 chromosome, complete genome	blastn	192269	734	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas zeae
10323905	10323905	PRJEB55122_P_NODE_27009_length_205_cov_0.852564_g26612_i0	PRJEB55122	27009	205	0.852564	1.7477562	Algibacter lectus	221126	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2889355551\|gb\|CP151840.1\|	221126	g26612	i0	100	0.136585365853659	28	0	14	0	159	186	2394785	2394812	Algibacter lectus strain AS40 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter lectus
11598961	11598961	PRJEB55122_P_NODE_17430_length_272_cov_1.748879_g17033_i0	PRJEB55122	17430	272	1.748879	4.75695088	Prevotella nigrescens	28133	Bacteria	Bacteria	488	1.6099999999999996e-133	NTclustered	gi\|2093903713\|gb\|CP082842.1\|	28133	g17033	i0	99.259	256.720588235294	270	2	99	0	3	272	168309	168040	Prevotella nigrescens strain FDAARGOS_1486 chromosome, complete genome	blastn	69828	488	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
11599298	11599298	PRJEB55122_P_NODE_26550_length_207_cov_1.189873_g26153_i0	PRJEB55122	26550	207	1.189873	2.46303711	Bacteroidales bacterium SW299	2510306	Bacteria	Bacteria	327	2.69e-85	NTclustered	gi\|2729058721\|emb\|OZ007021.1\|	2510306	g26153	i0	95.215	414.449275362319	209	6	100	2	1	207	290563	290357	MAG: Bacteroidales bacterium SW299 isolate 6755_HET_CTRL_contig_977_metaflye_circ MAG genome assembly, chromosome: 1	blastn	85791	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium SW299
11599489	11599489	PRJEB55122_P_NODE_32070_length_184_cov_1.429630_g31673_i0	PRJEB55122	32070	184	1.42963	2.6305192	Phocaeicola salanitronis	376805	Bacteria	Bacteria	231	1.88e-56	NTclustered	gi\|324316725\|gb\|CP002530.1\|	667015	g31673	i0	89.418	336.353260869565	189	12	100	6	1	184	2619150	2619335	Bacteroides salanitronis DSM 18170, complete genome	blastn	61889	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola salanitronis
12470758	12470758	PRJEB55122_P_NODE_38690_length_167_cov_0.881356_g38293_i0	PRJEB55122	38690	167	0.881356	1.47186452	Phocaeicola	909656	Bacteria	Bacteria	303	3.5e-78	NTclustered	gi\|1840190378\|gb\|CP046425.1\|	357276	g38293	i0	99.401	33.7724550898204	167	1	100	0	1	167	961766	961600	Phocaeicola dorei strain JR02 chromosome, complete genome	blastn	5640	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola dorei
12874704	12874704	PRJEB55122_P_NODE_34571_length_175_cov_1.650794_g34174_i0	PRJEB55122	34571	175	1.650794	2.8888895	Cloacibacterium caeni	2004710	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g34174	i0	100	377.148571428571	175	0	100	0	1	175	1872252	1872426	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	66001	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
12874742	12874742	PRJEB55122_P_NODE_36091_length_170_cov_1.719008_g35694_i0	PRJEB55122	36091	170	1.719008	2.9223136	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	215	1.71e-51	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g35694	i0	89.412	1	170	18	100	0	1	170	1353153	1352984	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	170	215	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
14149310	14149310	PRJEB55122_P_NODE_29492_length_194_cov_1.000000_g29095_i0	PRJEB55122	29492	194	1	1.94	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1893901207\|gb\|CP059225.1\|	1653831	g29095	i0	100	0.149484536082474	29	0	15	0	2	30	364281	364309	Blattabacterium cuenoti strain NYCTIBsp chromosome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
15423034	15423034	PRJEB55122_P_NODE_20293_length_246_cov_0.994924_g19896_i0	PRJEB55122	20293	246	0.994924	2.44751304	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	381	2.5e-101	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g19896	i0	94.715	483.735772357724	246	12	100	1	1	246	443260	443016	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	118999	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
16294452	16294452	PRJEB55122_P_NODE_26953_length_205_cov_1.179487_g26556_i0	PRJEB55122	26953	205	1.179487	2.41794835	Alistipes	239759	Bacteria	Bacteria	333	5.709999999999999e-87	NTclustered	gi\|507148351\|ref\|NR_103154.1\|	214856	g26556	i0	95.694	169.014634146341	209	5	100	3	1	205	830	1038	Alistipes finegoldii strain AHN 2437 23S ribosomal RNA gene, complete sequence	blastn	34648	333	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes finegoldii
16697501	16697501	PRJEB55122_P_NODE_25134_length_214_cov_1.260606_g24737_i0	PRJEB55122	25134	214	1.260606	2.69769684	Marinoscillum sp.	2024838	Bacteria	Bacteria	291	3.67e-74	NTclustered	gi\|2836248207\|gb\|CP121337.1\|	2024838	g24737	i0	91.469	501.107476635514	211	18	99	0	1	211	3407935	3407725	MAG: Marinoscillum sp. isolate NCC532_bact_3502 chromosome, complete genome	blastn	107237	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Reichenbachiellaceae	Marinoscillum	Marinoscillum sp.
16697951	16697951	PRJEB55122_P_NODE_39174_length_166_cov_1.572650_g38777_i0	PRJEB55122	39174	166	1.57265	2.610599	Prevotella denticola	28129	Bacteria	Bacteria	300	4.5e-77	NTclustered	gi\|2030190567\|gb\|CP073339.1\|	28129	g38777	i0	99.394	255.493975903614	165	1	99	0	2	166	222454	222618	Prevotella denticola strain F0105 chromosome	blastn	42412	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
17569629	17569629	PRJEB55122_P_NODE_42874_length_162_cov_2.504425_g42477_i0	PRJEB55122	42874	162	2.504425	4.0571685	Flavobacteriales	200644	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2428403098\|gb\|CP115636.1\|	238	g42477	i0	100	448	162	0	100	0	1	162	168054	168215	Elizabethkingia meningoseptica strain 2022CK-00380 chromosome, complete genome	blastn	72576	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
20118295	20118295	PRJEB55122_P_NODE_42176_length_163_cov_0.912281_g41779_i0	PRJEB55122	42176	163	0.912281	1.48701803	Adhaeribacter	299566	Bacteria	Bacteria	60.2	8.12e-5	NTclustered	gi\|1891111643\|gb\|CP055154.1\|	2086471	g41779	i0	92.683	0.662576687116564	41	3	25	0	99	139	46373	46413	Adhaeribacter swui strain KCTC 52873 plasmid unnamed1, complete sequence	blastn	108	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
21393886	21393886	PRJEB55122_P_NODE_8037_length_474_cov_2.701176_g7645_i0	PRJEB55122	8037	474	2.701176	12.80357424	Cloacibacterium	501783	Bacteria	Bacteria	832	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g7645	i0	98.312	469.978902953586	474	8	100	0	1	474	1872375	1872848	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	222770	837	0.994026284348865	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
23072630	23072630	PRJEB55122_P_NODE_18919_length_258_cov_0.990431_g18522_i0	PRJEB55122	18919	258	0.990431	2.55531198	Prevotella nigrescens	28133	Bacteria	Bacteria	470	5.47e-128	NTclustered	gi\|2028840811\|gb\|CP072335.1\|	28133	g18522	i0	99.611	217.294573643411	257	1	99	0	2	258	96359	96103	Prevotella nigrescens strain F0630 chromosome 1, complete sequence	blastn	56062	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella nigrescens
23944065	23944065	PRJEB55122_P_NODE_33039_length_180_cov_2.671756_g32642_i0	PRJEB55122	33039	180	2.671756	4.8091608	Weeksellaceae	2762318	Bacteria	Bacteria	316	4.899999999999999e-82	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g32642	i0	98.343	453.677777777778	181	2	100	1	1	180	2942740	2942920	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	81662	316	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
25217876	25217876	PRJEB55122_P_NODE_44220_length_156_cov_2.084112_g43823_i0	PRJEB55122	44220	156	2.084112	3.25121472	Cloacibacterium	501783	Bacteria	Bacteria	279	5.41e-71	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g43823	i0	99.355	485.820512820513	155	0	99	1	3	156	131996	131842	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	75788	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense

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