metadata: contig_metadata: 29 rows where bioproject = "PRJNA1151638" and tax

29 rows where bioproject = "PRJNA1151638" 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
301865	301865	PRJNA1151638_P_NODE_2401_length_318_cov_1.330612_g2334_i0	PRJNA1151638	2401	318	1.330612	4.23134616	Spirosoma foliorum	2710596	Bacteria	Bacteria	477	4.149999999999998e-130	NTclustered	gi\|1886902300\|gb\|CP059732.1\|	2710596	g2334	i0	94.025	239.465408805031	318	14	99	5	1	316	2246014	2245700	Spirosoma foliorum strain KCTC 72228 chromosome, complete genome	blastn	76150	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma foliorum
1576665	1576665	PRJNA1151638_P_NODE_782_length_498_cov_3.214118_g715_i0	PRJNA1151638	782	498	3.214118	16.00630764	Spirosoma sp. KUDC1026	2745947	Bacteria	Bacteria	826	0	NTclustered	gi\|1863088467\|gb\|CP056032.1\|	2745947	g715	i0	96.586	275.748995983936	498	17	100	0	1	498	445869	446366	Spirosoma sp. KUDC1026 chromosome, complete genome	blastn	137323	826	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KUDC1026
2312247	2312247	PRJNA1151638_P_NODE_3922_length_269_cov_2.117347_g3855_i0	PRJNA1151638	3922	269	2.117347	5.69566343	Weeksellaceae	2762318	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3855	i0	100	495.100371747212	269	0	100	0	1	269	129950	129682	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	133182	497	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
2852975	2852975	PRJNA1151638_P_NODE_6703_length_242_cov_0.923077_g6636_i0	PRJNA1151638	6703	242	0.923077	2.23384634	Spirosoma oryzicola	2898794	Bacteria	Bacteria	182	2.66e-41	NTclustered	gi\|2168315906\|gb\|CP089538.1\|	2898794	g6636	i0	80.87	2.52479338842975	230	44	95	0	13	242	5524712	5524483	Spirosoma oryzicola strain RHs26 chromosome, complete genome	blastn	611	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma oryzicola
5405018	5405018	PRJNA1151638_P_NODE_3105_length_290_cov_3.013825_g3038_i0	PRJNA1151638	3105	290	3.013825	8.7400925	Spirosoma sp. KCTC 42546	2520506	Bacteria	Bacteria	364	3.0399999999999992e-96	NTclustered	gi\|1702113944\|gb\|CP041360.1\|	2520506	g3038	i0	89.347	202.565517241379	291	29	100	2	1	290	677880	678169	Spirosoma sp. KCTC 42546 chromosome, complete genome	blastn	58744	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. KCTC 42546
6139781	6139781	PRJNA1151638_P_NODE_265_length_855_cov_2.650895_g208_i0	PRJNA1151638	265	855	2.650895	22.66515225	Weeksellaceae	2762318	Bacteria	Bacteria	1474	0	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g208	i0	97.78	459.293567251462	856	17	100	2	1	855	2628997	2628143	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	392696	1487	0.991257565568258	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
6139788	6139788	PRJNA1151638_P_NODE_3765_length_272_cov_5.839196_g3698_i0	PRJNA1151638	3765	272	5.839196	15.88261312	Spirosoma	107	Bacteria	Bacteria	316	8.019999999999998e-82	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g3698	i0	88.192	112.963235294118	271	25	99	7	2	272	6728966	6728703	Spirosoma linguale DSM 74, complete genome	blastn	30726	316	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
10505731	10505731	PRJNA1151638_P_NODE_1829_length_350_cov_1.350181_g1762_i0	PRJNA1151638	1829	350	1.350181	4.7256335	Spirosoma aureum	2692134	Bacteria	Bacteria	340	6.3e-89	NTclustered	gi\|1823150813\|gb\|CP050063.1\|	2692134	g1762	i0	84.551	201.862857142857	356	41	100	13	1	350	445001	445348	Spirosoma aureum strain BT328 chromosome, complete genome	blastn	70652	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma aureum
11240220	11240220	PRJNA1151638_P_NODE_1389_length_388_cov_3.692063_g1322_i0	PRJNA1151638	1389	388	3.692063	14.32520444	Spirosoma	107	Bacteria	Bacteria	628	1.3499999999999994e-175	NTclustered	gi\|1864207079\|ref\|NR_169373.1\|	1806202	g1322	i0	95.897	101.886597938144	390	12	100	4	1	388	800	413	Spirosoma areae strain Arct 1-12 16S ribosomal RNA, partial sequence	blastn	39532	628	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma areae
11780515	11780515	PRJNA1151638_P_NODE_1890_length_345_cov_2.411765_g1823_i0	PRJNA1151638	1890	345	2.411765	8.32058925	Fibrella aestuarina	651143	Bacteria	Bacteria	499	9.7e-137	NTclustered	gi\|384064804\|emb\|HE796683.1\|	1166018	g1823	i0	92.795	542.220289855072	347	22	100	3	1	345	610997	610652	Fibrella aestuarina BUZ 2 drat genome	blastn	187066	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Fibrella	Fibrella aestuarina
13790311	13790311	PRJNA1151638_P_NODE_7211_length_213_cov_9.864286_g7144_i0	PRJNA1151638	7211	213	9.864286	21.01092918	Flavobacteriales	200644	Bacteria	Bacteria	390	3.499999999999999e-104	NTclustered	gi\|2428403098\|gb\|CP115636.1\|	238	g7144	i0	100	443.821596244131	211	0	99	0	1	211	168266	168056	Elizabethkingia meningoseptica strain 2022CK-00380 chromosome, complete genome	blastn	94534	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
15064628	15064628	PRJNA1151638_P_NODE_1112_length_430_cov_2.523810_g1045_i0	PRJNA1151638	1112	430	2.52381	10.852383	Sphingobacteriaceae	84566	Bacteria	Bacteria	623	7.009999999999999e-174	NTclustered	gi\|1062635033\|gb\|CP017141.1\|	430522	g1045	i0	92.824	438.909302325581	432	27	100	4	1	430	1129666	1130095	Pedobacter steynii strain DX4 chromosome, complete genome	blastn	188731	628	0.99203821656051006	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter steynii
17614695	17614695	PRJNA1151638_P_NODE_4734_length_253_cov_1.211111_g4667_i0	PRJNA1151638	4734	253	1.211111	3.06411083	Hymenobacter	89966	Bacteria	Bacteria	315	2.65e-81	NTclustered	gi\|1899473058\|gb\|CP060784.1\|	1385715	g4667	i0	89.837	245.426877470356	246	23	97	2	1	246	935946	936189	Hymenobacter qilianensis strain JCM 19763 chromosome, complete genome	blastn	62093	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter qilianensis
21978831	21978831	PRJNA1151638_P_NODE_5798_length_247_cov_0.896552_g5731_i0	PRJNA1151638	5798	247	0.896552	2.21448344	Bacteroidales bacterium	2030927	Bacteria	Bacteria	193	1.26e-44	NTclustered	gi\|2907625724\|emb\|OZ223284.1\|	2030927	g5731	i0	92.029	138.748987854251	138	9	55	2	20	156	225427	225291	MAG: Bacteroidales bacterium isolate 96dce958-db9f-4d15-8e2e-9d99d82f70a0 genome assembly, chromosome: 2	blastn	34271	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
23989195	23989195	PRJNA1151638_P_NODE_2079_length_334_cov_2.628352_g2012_i0	PRJNA1151638	2079	334	2.628352	8.77869568	Spirosoma	107	Bacteria	Bacteria	484	2.6199999999999996e-132	NTclustered	gi\|470485150\|ref\|NR_076687.1\|	108	g2012	i0	93.051	369.997005988024	331	23	99	0	1	331	727	1057	Spirosoma linguale strain DSM 74 23S ribosomal RNA gene, complete sequence	blastn	123579	484	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
24527977	24527977	PRJNA1151638_P_NODE_680_length_535_cov_1.638528_g613_i0	PRJNA1151638	680	535	1.638528	8.7661248	Hymenobacter baengnokdamensis	2615203	Bacteria	Bacteria	773	0	NTclustered	gi\|1752950296\|gb\|CP044285.1\|	2615203	g613	i0	92.764	309.41308411215	539	31	100	8	1	535	1424025	1424559	Hymenobacter baengnokdamensis strain BRD72 chromosome, complete genome	blastn	165536	773	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter baengnokdamensis
27261637	27261637	PRJNA1151638_P_NODE_6483_length_243_cov_0.917647_g6416_i0	PRJNA1151638	6483	243	0.917647	2.22988221	Hanamia sp.	2930256	Bacteria	Bacteria	137	7.12e-39	NR	HET7115091.1	2930256	g6416	i0	72.8	1	81	22	100	0	243	1	99	179	HET7115091.1 hypothetical protein [Hanamia sp.]	diamond	243	137	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hanamia	Hanamia sp.
27924749	27924749	PRJNA1151638_P_NODE_5645_length_248_cov_0.891429_g5578_i0	PRJNA1151638	5645	248	0.891429	2.21074392	uncultured Porphyromonas sp.	159274	Bacteria	Bacteria	172	3.25e-49	NR	WP_296119579.1	159274	g5578	i0	97.6	0.991935483870968	82	2	99.2	0	248	3	353	434	WP_296119579.1 sialidase family protein [uncultured Porphyromonas sp.]	diamond	246	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	uncultured Porphyromonas sp.
27956352	27956352	PRJNA1151638_P_NODE_6185_length_245_cov_0.906977_g6118_i0	PRJNA1151638	6185	245	0.906977	2.22209365	Spirosoma sp. SC4-14	3128900	Bacteria	Bacteria	118	8.22e-29	NR	WP_338875046.1	3128900	g6118	i0	73.4	0.96734693877551	79	21	96.7	0	245	9	361	439	WP_338875046.1 histidine kinase dimerization/phosphoacceptor domain -containing protein [Spirosoma sp. SC4-14]	diamond	237	118	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma sp. SC4-14
29901857	29901857	PRJNA1151638_P_NODE_5551_length_248_cov_0.891429_g5484_i0	PRJNA1151638	5551	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	135	2.2e-35	NR	HAO98541.1	2052160	g5484	i0	82.5	1.93548387096774	80	14	96.8	0	2	241	101	180	HAO98541.1 hypothetical protein [Fibrobacterota bacterium]	diamond	480	135	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30893511	30893511	PRJNA1151638_P_NODE_6174_length_245_cov_0.906977_g6107_i0	PRJNA1151638	6174	245	0.906977	2.22209365	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	149	3.2799999999999993e-40	NR	HEX3233915.1	2448054	g6107	i0	88.9	1.98367346938776	81	9	99.2	0	243	1	269	349	HEX3233915.1 D-aminoacylase [Gemmatimonadales bacterium]	diamond	486	149	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
31082959	31082959	PRJNA1151638_P_NODE_1275_length_403_cov_1.624242_g1208_i0	PRJNA1151638	1275	403	1.624242	6.54569526	Ancylomarina euxinus	2283627	Bacteria	Bacteria	68.9	8.63e-11	NR	WP_125029224.1	2283627	g1208	i0	46.6	0.655086848635236	88	46	65.5	1	274	11	3	89	WP_125029224.1 hypothetical protein [Ancylomarina euxinus]	diamond	264	68.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinifilaceae	Ancylomarina	Ancylomarina euxinus
31177467	31177467	PRJNA1151638_P_NODE_6355_length_244_cov_0.912281_g6288_i0	PRJNA1151638	6355	244	0.912281	2.22596564	Candidatus Pseudobacter hemicellulosilyticus	3121375	Bacteria	Bacteria	141	7.16e-39	NR	WEK34143.1	3121375	g6288	i0	77.8	1.99180327868852	81	18	99.6	0	243	1	103	183	WEK34143.1 MAG: glycosyltransferase [Candidatus Pseudobacter hemicellulosilyticus]	diamond	486	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Candidatus Pseudobacter hemicellulosilyticus
31208888	31208888	PRJNA1151638_P_NODE_5895_length_246_cov_0.901734_g5828_i0	PRJNA1151638	5895	246	0.901734	2.21826564	Panacibacter sp.	1874622	Bacteria	Bacteria	64.7	5.09e-10	NR	HRI20735.1	1874622	g5828	i0	48.8	0.975609756097561	80	37	95.1	2	13	246	181	258	HRI20735.1 hypothetical protein [Panacibacter sp.]	diamond	240	64.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter sp.
31545167	31545167	PRJNA1151638_P_NODE_5256_length_250_cov_0.881356_g5189_i0	PRJNA1151638	5256	250	0.881356	2.20339	Porphyromonas	836	Bacteria	Bacteria	160	3.2e-48	NR	WP_287362643.1	1924944	g5189	i0	100	4.872	81	0	97.2	0	247	5	79	159	WP_287362643.1 hypothetical protein [Porphyromonas sp.]	diamond	1218	160	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp.
32190024	32190024	PRJNA1151638_P_NODE_6138_length_245_cov_0.906977_g6071_i0	PRJNA1151638	6138	245	0.906977	2.22209365	Larkinella terrae	2025311	Bacteria	Bacteria	159	2.96e-44	NR	WP_154178953.1	2025311	g6071	i0	98.8	2.97551020408163	81	1	99.2	0	3	245	246	326	WP_154178953.1 amidase [Larkinella terrae]	diamond	729	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Larkinella	Larkinella terrae
32253556	32253556	PRJNA1151638_P_NODE_5078_length_251_cov_0.876404_g5011_i0	PRJNA1151638	5078	251	0.876404	2.19977404	Ferruginibacter sp.	1940288	Bacteria	Bacteria	77.8	1.18e-15	NR	MBC7886364.1	1940288	g5011	i0	69.2	0.621513944223108	52	16	62.2	0	3	158	114	165	MBC7886364.1 hypothetical protein [Ferruginibacter sp.]	diamond	156	77.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
32399352	32399352	PRJNA1151638_P_NODE_1139_length_424_cov_2.227920_g1072_i0	PRJNA1151638	1139	424	2.22792	9.4463808	Bacteroidales	171549	Bacteria	Bacteria	91.7	2.27e-18	NR	WP_286151340.1	85831	g1072	i0	40.3	2.63207547169811	124	66	87.7	2	380	9	181	296	WP_286151340.1 Eco57I restriction-modification methylase domain-containing protein [Bacteroides acidifaciens]	diamond	1116	91.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides acidifaciens
32651671	32651671	PRJNA1151638_P_NODE_4780_length_253_cov_0.866667_g4713_i0	PRJNA1151638	4780	253	0.866667	2.19266751	Chitinophagaceae	563835	Bacteria	Bacteria	120	4.49e-30	NR	MEO6542090.1	1940288	g4713	i0	84.4	2.27667984189723	64	10	75.9	0	253	62	409	472	MEO6542090.1 glycoside hydrolase family 125 protein [Ferruginibacter sp.]	diamond	576	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.

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