metadata: contig_metadata: 33 rows where bioproject = "PRJDB12134" and tax

33 rows where bioproject = "PRJDB12134" 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
59	59	PRJDB12134_P_NODE_14401_length_242_cov_0.905325_g14266_i0	PRJDB12134	14401	242	0.905325	2.1908865	Chryseobacterium aureum	2497456	Bacteria	Bacteria	322	1.5e-83	NTclustered	gi\|1543017349\|gb\|CP034661.1\|	2497456	g14266	i0	91.139	16.702479338843	237	21	98	0	6	242	4090501	4090265	Chryseobacterium aureum strain 17S1E7 chromosome	blastn	4042	322	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium aureum
182	182	PRJDB12134_P_NODE_8901_length_315_cov_0.797521_g8766_i0	PRJDB12134	8901	315	0.797521	2.51219115	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	555	1.8399999999999994e-153	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g8766	i0	98.418	461.12380952381	316	3	100	2	1	315	806320	806634	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	145254	555	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
980645	980645	PRJDB12134_P_NODE_9541_length_297_cov_1.834821_g9406_i0	PRJDB12134	9541	297	1.834821	5.44941837	Prevotella	838	Bacteria	Bacteria	532	8.08e-147	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g9406	i0	98.99	234.639730639731	297	3	100	0	1	297	698082	697786	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	69688	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
4808574	4808574	PRJDB12134_P_NODE_9624_length_295_cov_1.842342_g9489_i0	PRJDB12134	9624	295	1.842342	5.4349089	Pedobacter	84567	Bacteria	Bacteria	544	3.71e-150	NTclustered	gi\|470484653\|ref\|NR_076660.1\|	984	g9489	i0	100	331.193220338983	294	0	99	0	1	294	540	833	Pedobacter heparinus strain DSM 2366 23S ribosomal RNA gene, complete sequence	blastn	97702	544	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
9908817	9908817	PRJDB12134_P_NODE_9208_length_305_cov_1.383621_g9073_i0	PRJDB12134	9208	305	1.383621	4.22004405	Haliscomenobacter	2349	Bacteria	Bacteria	250	9.39e-62	NTclustered	gi\|470488547\|ref\|NR_076877.1\|	2350	g9073	i0	89.95	266.291803278689	199	12	65	3	1	199	1648	1458	Haliscomenobacter hydrossis strain DSM 1100 23S ribosomal RNA gene, complete sequence	blastn	81219	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
10202910	10202910	PRJDB12134_P_NODE_13149_length_248_cov_1.748571_g13014_i0	PRJDB12134	13149	248	1.748571	4.33645608	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	162	8.36e-48	NR	MDX1421393.1	2838334	g13014	i0	90.2	0.991935483870968	82	8	99.2	0	247	2	5	86	MDX1421393.1 IS5 family transposase [Rubricoccaceae bacterium]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
10202994	10202994	PRJDB12134_P_NODE_4889_length_484_cov_1.423358_g4755_i0	PRJDB12134	4889	484	1.423358	6.88905272	Dyadobacter chenwenxiniae	2906456	Bacteria	Bacteria	861	0	NTclustered	gi\|2221365986\|gb\|CP094997.1\|	2906456	g4755	i0	98.76	404.092975206612	484	6	100	0	1	484	5504660	5504177	Dyadobacter chenwenxiniae strain LJ419 chromosome, complete genome	blastn	195581	861	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter chenwenxiniae
10203069	10203069	PRJDB12134_P_NODE_9709_length_293_cov_2.809091_g9574_i0	PRJDB12134	9709	293	2.809091	8.23063663	Prevotella sp. oral taxon 475	712471	Bacteria	Bacteria	252	2.4999999999999997e-62	NTclustered	gi\|2028838898\|gb\|CP072334.1\|	712471	g9574	i0	97.297	1.96245733788396	148	4	100	0	146	293	411430	411283	Prevotella sp. oral taxon 475 strain F0059 chromosome, complete genome	blastn	575	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. oral taxon 475
11478024	11478024	PRJDB12134_P_NODE_14070_length_243_cov_1.817647_g13935_i0	PRJDB12134	14070	243	1.817647	4.41688221	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g13935	i0	99.588	22.8312757201646	243	1	100	0	1	243	437308	437066	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	5548	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
12459783	12459783	PRJDB12134_P_NODE_12250_length_253_cov_1.788889_g12115_i0	PRJDB12134	12250	253	1.788889	4.52588917	Adhaeribacter	299566	Bacteria	Bacteria	407	4.2500000000000005e-109	NTclustered	gi\|1891112286\|gb\|CP055156.1\|	2086471	g12115	i0	95.669	271.130434782609	254	9	100	2	1	253	94822	94570	Adhaeribacter swui strain KCTC 52873 chromosome, complete genome	blastn	68596	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
12753541	12753541	PRJDB12134_P_NODE_12851_length_250_cov_0.875706_g12716_i0	PRJDB12134	12851	250	0.875706	2.189265	Chitinophagaceae	563835	Bacteria	Bacteria	149	1.25e-40	NR	WP_240743211.1	2575867	g12716	i0	86.7	4.98	83	11	99.6	0	250	2	192	274	WP_240743211.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Ilyomonas limi]	diamond	1245	149	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ilyomonas	Ilyomonas limi
14028080	14028080	PRJDB12134_P_NODE_13772_length_245_cov_0.906977_g13637_i0	PRJDB12134	13772	245	0.906977	2.22209365	Capnocytophaga leadbetteri	327575	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g13637	i0	98.776	4.86122448979592	245	3	100	0	1	245	1431077	1431321	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	1191	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
15302239	15302239	PRJDB12134_P_NODE_5133_length_470_cov_1.949622_g4999_i0	PRJDB12134	5133	470	1.949622	9.1632234	Pedobacter sp. FW305-3-2-15-E-R2A2	3140251	Bacteria	Bacteria	785	0	NTclustered	gi\|2720698973\|gb\|CP151803.1\|	3140251	g4999	i0	96.809	354.778723404255	470	15	100	0	1	470	6988372	6988841	Pedobacter sp. FW305-3-2-15-E-R2A2 chromosome, complete genome	blastn	166746	785	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. FW305-3-2-15-E-R2A2
16283357	16283357	PRJDB12134_P_NODE_11973_length_258_cov_1.675676_g11838_i0	PRJDB12134	11973	258	1.675676	4.32324408	Pedobacter	84567	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|470484653\|ref\|NR_076660.1\|	984	g11838	i0	99.225	345.728682170543	258	2	100	0	1	258	2788	2531	Pedobacter heparinus strain DSM 2366 23S ribosomal RNA gene, complete sequence	blastn	89198	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter heparinus
16283359	16283359	PRJDB12134_P_NODE_12953_length_249_cov_1.460227_g12818_i0	PRJDB12134	12953	249	1.460227	3.63596523	Capnocytophaga	1016	Bacteria	Bacteria	375	1.18e-99	NTclustered	gi\|1242560045\|gb\|CP022384.1\|	327575	g12818	i0	99.517	271.028112449799	207	0	83	1	44	249	371179	370973	Capnocytophaga leadbetteri strain H6253 chromosome, complete genome	blastn	67486	375	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
17851927	17851927	PRJDB12134_P_NODE_12795_length_250_cov_0.881356_g12660_i0	PRJDB12134	12795	250	0.881356	2.20339	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	152	6.14e-42	NR	HJQ21209.1	2026741	g12660	i0	89.2	3.984	83	9	99.6	0	1	249	107	189	HJQ21209.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Gemmatimonadaceae bacterium]	diamond	996	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
17851930	17851930	PRJDB12134_P_NODE_13075_length_249_cov_0.880682_g12940_i0	PRJDB12134	13075	249	0.880682	2.19289818	Sphingobacterium thalpophilum	259	Bacteria	Bacteria	327	3.34e-85	NTclustered	gi\|2647208394\|gb\|CP141191.1\|	259	g12940	i0	91.915	374.626506024096	235	17	94	2	15	249	751793	751561	Sphingobacterium thalpophilum strain YX-3 chromosome, complete genome	blastn	93282	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
24225856	24225856	PRJDB12134_P_NODE_11300_length_269_cov_1.500000_g11165_i0	PRJDB12134	11300	269	1.5	4.035	Sphingobacterium sp. UDSM-2020	2795738	Bacteria	Bacteria	464	2.67e-126	NTclustered	gi\|1948801041\|gb\|CP066166.1\|	2795738	g11165	i0	97.77	2.23791821561338	269	6	100	0	1	269	782410	782142	Sphingobacterium sp. UDSM-2020 chromosome	blastn	602	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. UDSM-2020
25206763	25206763	PRJDB12134_P_NODE_9120_length_308_cov_1.263830_g8985_i0	PRJDB12134	9120	308	1.26383	3.8925964	Niabella	379899	Bacteria	Bacteria	412	1.1399999999999997e-110	NTclustered	gi\|2070850032\|gb\|CP079214.1\|	2849502	g8985	i0	90.939	144.636363636364	309	24	100	4	1	308	1677630	1677935	Niabella sp. I6 chromosome	blastn	44548	412	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella sp. I6
26900058	26900058	PRJDB12134_P_NODE_12401_length_252_cov_0.871508_g12266_i0	PRJDB12134	12401	252	0.871508	2.19620016	Gemmatimonadaceae	219687	Bacteria	Bacteria	110	2.0500000000000003e-27	NR	WP_025411944.1	861299	g12266	i0	75.9	1.97619047619048	83	16	98.8	1	3	251	181	259	WP_025411944.1 peptide chain release factor N(5)-glutamine methyltransferase [Gemmatirosa kalamazoonensis]	diamond	498	111	0.990990990990991	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
27126760	27126760	PRJDB12134_P_NODE_5962_length_423_cov_1.205714_g5828_i0	PRJDB12134	5962	423	1.205714	5.10017022	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	44.7	0.0403	NR	HCU11550.1	2026742	g5828	i0	35.1	0.524822695035461	74	45	50.4	1	36	248	19	92	HCU11550.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	222	44.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28643201	28643201	PRJDB12134_P_NODE_13147_length_248_cov_1.760000_g13012_i0	PRJDB12134	13147	248	1.76	4.3648	Porphyromonas sp. HMSC	1924944	Bacteria	Bacteria	147	7.81e-41	NR	WP_070466412.1	1739394	g13012	i0	96.1	0.919354838709677	76	3	91.9	0	248	21	283	358	WP_070466412.1 tetraacyldisaccharide 4'-kinase [Porphyromonas sp. HMSC065F10]	diamond	228	147	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. HMSC065F10
29148617	29148617	PRJDB12134_P_NODE_10809_length_277_cov_1.200980_g10674_i0	PRJDB12134	10809	277	1.20098	3.3267146	Flavobacterium lindanitolerans	428988	Bacteria	Bacteria	185	6.2799999999999985e-55	NR	WP_343623098.1	428988	g10674	i0	96.7	0.996389891696751	92	3	99.6	0	2	277	198	289	WP_343623098.1 adenosylmethionine--8-amino-7-oxononanoate transaminase [Flavobacterium lindanitolerans]	diamond	276	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium lindanitolerans
29937693	29937693	PRJDB12134_P_NODE_11751_length_262_cov_1.550265_g11616_i0	PRJDB12134	11751	262	1.550265	4.0616943	Cnuella takakiae	1302690	Bacteria	Bacteria	118	2e-29	NR	WP_073042344.1	1302690	g11616	i0	98.3	0.687022900763359	60	1	68.7	0	181	2	1	60	WP_073042344.1 putative DNA modification/repair radical SAM protein [Cnuella takakiae]	diamond	180	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Cnuella	Cnuella takakiae
30000946	30000946	PRJDB12134_P_NODE_11311_length_269_cov_1.260204_g11176_i0	PRJDB12134	11311	269	1.260204	3.38994876	uncultured Pedobacter sp.	246139	Bacteria	Bacteria	82.4	5.67e-16	NR	WP_294895967.1	246139	g11176	i0	48.2	1.89591078066915	85	34	94.8	1	268	14	675	749	WP_294895967.1 phenylalanine--tRNA ligase subunit beta [uncultured Pedobacter sp.]	diamond	510	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	uncultured Pedobacter sp.
30595109	30595109	PRJDB12134_P_NODE_12113_length_256_cov_1.060109_g11978_i0	PRJDB12134	12113	256	1.060109	2.71387904	Porphyromonas	836	Bacteria	Bacteria	171	2.33e-50	NR	MFC2631976.1	1583331	g11978	i0	100	5.9765625	85	0	99.6	0	255	1	72	156	MFC2631976.1 N-acetylmuramoyl-L-alanine amidase [Porphyromonas pasteri]	diamond	1530	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pasteri
30917242	30917242	PRJDB12134_P_NODE_10674_length_279_cov_1.373786_g10539_i0	PRJDB12134	10674	279	1.373786	3.83286294	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	75.9	4.73e-14	NR	HEX8384657.1	2838334	g10539	i0	62.7	0.634408602150538	59	21	63.4	1	179	3	3	60	HEX8384657.1 alpha/beta hydrolase [Rubricoccaceae bacterium]	diamond	177	75.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
31200991	31200991	PRJDB12134_P_NODE_13815_length_245_cov_0.901163_g13680_i0	PRJDB12134	13815	245	0.901163	2.20784935	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	141	3.61e-38	NR	MCA6440076.1	1869212	g13680	i0	93.8	0.991836734693878	81	5	99.2	0	3	245	199	279	MCA6440076.1 TolC family protein [Chitinophagaceae bacterium]	diamond	243	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32182144	32182144	PRJDB12134_P_NODE_14118_length_243_cov_0.917647_g13983_i0	PRJDB12134	14118	243	0.917647	2.22988221	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	170	6.57e-47	NR	MBN8850464.1	2044944	g13983	i0	100	0.987654320987654	80	0	98.8	0	2	241	739	818	MBN8850464.1 VCBS repeat-containing protein [Sphingobacteriales bacterium]	diamond	240	170	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
32271230	32271230	PRJDB12134_P_NODE_11478_length_266_cov_1.580311_g11343_i0	PRJDB12134	11478	266	1.580311	4.20362726	Prevotella	838	Bacteria	Bacteria	163	8.4e-45	NR	WP_044260099.1	340486	g11343	i0	92	2.97744360902256	88	7	99.2	0	266	3	233	320	WP_044260099.1 zinc-dependent metalloprotease, partial [Prevotella conceptionensis]	diamond	792	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella conceptionensis
32403613	32403613	PRJDB12134_P_NODE_12899_length_250_cov_0.864407_g12764_i0	PRJDB12134	12899	250	0.864407	2.1610175	Bacteroides sp. 51	2302938	Bacteria	Bacteria	51.6	1.08e-5	NR	WP_163178564.1	2302938	g12764	i0	52.8	0.636	53	24	62.4	1	3	158	112	164	WP_163178564.1 HU family DNA-binding protein [Bacteroides sp. 51]	diamond	159	51.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. 51
32403615	32403615	PRJDB12134_P_NODE_13399_length_247_cov_0.896552_g13264_i0	PRJDB12134	13399	247	0.896552	2.21448344	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	138	1.21e-37	NR	MBN8853300.1	2044944	g13264	i0	93.2	0.898785425101215	74	5	89.9	0	222	1	73	146	MBN8853300.1 DUF4974 domain-containing protein [Sphingobacteriales bacterium]	diamond	222	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
32839196	32839196	PRJDB12134_P_NODE_11780_length_261_cov_2.175532_g11645_i0	PRJDB12134	11780	261	2.175532	5.67813852	Sediminibacterium	504481	Bacteria	Bacteria	179	2.69e-53	NR	MEY3675574.1	1898104	g11645	i0	100	1.97701149425287	86	0	98.9	0	3	260	225	310	MEY3675574.1 hypothetical protein [Bacteroidota bacterium]	diamond	516	179	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);;