metadata: contig_metadata: 32 rows where bioproject = "PRJNA609258" and tax

32 rows where bioproject = "PRJNA609258" and tax_phylum = "Bacteroidota"

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
587960	587960	PRJNA609258_P_NODE_57561_length_245_cov_0.906977_g57176_i0	PRJNA609258	57561	245	0.906977	2.22209365	Cloacibacterium caeni	2004710	Bacteria	Bacteria	387	5.34e-103	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g57176	i0	95.122	5.95510204081633	246	11	100	1	1	245	582942	583187	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	1459	387	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
588022	588022	PRJNA609258_P_NODE_59241_length_243_cov_0.917647_g58856_i0	PRJNA609258	59241	243	0.917647	2.22988221	Kaistella pullorum	2763074	Bacteria	Bacteria	93.6	4.22e-21	NR	WP_251832140.1	2763074	g58856	i0	78.2	5.66666666666667	55	12	67.9	0	76	240	5	59	WP_251832140.1 glycosyltransferase family 2 protein [Kaistella pullorum]	diamond	1377	93.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella pullorum
2422572	2422572	PRJNA609258_P_NODE_55042_length_247_cov_0.896552_g54657_i0	PRJNA609258	55042	247	0.896552	2.21448344	Cloacibacterium	501783	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g54657	i0	95.142	5.88663967611336	247	12	100	0	1	247	412946	412700	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1454	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
5691084	5691084	PRJNA609258_P_NODE_42405_length_280_cov_1.468599_g42020_i0	PRJNA609258	42405	280	1.468599	4.1120772	Aureibaculum algae	2584122	Bacteria	Bacteria	291	5.02e-74	NTclustered	gi\|1678494258\|gb\|CP040749.1\|	2584122	g42020	i0	85.357	1	280	41	100	0	1	280	557509	557788	Aureibaculum algae strain 10Alg 115 chromosome, complete genome	blastn	280	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureibaculum	Aureibaculum algae
6966279	6966279	PRJNA609258_P_NODE_57366_length_245_cov_0.906977_g56981_i0	PRJNA609258	57366	245	0.906977	2.22209365	Cloacibacterium normanense	237258	Bacteria	Bacteria	414	2.45e-111	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g56981	i0	97.143	4.73877551020408	245	7	100	0	1	245	575626	575870	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1161	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
8241046	8241046	PRJNA609258_P_NODE_58527_length_244_cov_0.859649_g58142_i0	PRJNA609258	58527	244	0.859649	2.09754356	Hymenobacter canadensis	2999067	Bacteria	Bacteria	122	1.6499999999999995e-23	NTclustered	gi\|2417460668\|gb\|CP114767.1\|	2999067	g58142	i0	79.661	7.2172131147541	177	30	71	6	46	219	252028	251855	Hymenobacter canadensis strain PAMC 29467 chromosome, complete genome	blastn	1761	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter canadensis
10792184	10792184	PRJNA609258_P_NODE_57889_length_244_cov_0.912281_g57504_i0	PRJNA609258	57889	244	0.912281	2.22596564	Chryseobacterium carnipullorum	1124835	Bacteria	Bacteria	285	1.99e-72	NTclustered	gi\|1519519019\|gb\|CP033920.1\|	1124835	g57504	i0	88.285	18.0532786885246	239	27	98	1	1	238	1485109	1485347	Chryseobacterium carnipullorum strain G0188 chromosome, complete genome	blastn	4405	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium carnipullorum
12067226	12067226	PRJNA609258_P_NODE_53250_length_249_cov_0.886364_g52865_i0	PRJNA609258	53250	249	0.886364	2.20704636	Elizabethkingia anophelis	1117645	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2269436631\|gb\|CP071542.1\|	1117645	g52865	i0	100	23	249	0	100	0	1	249	1681177	1681425	Elizabethkingia anophelis strain 347-10 chromosome, complete genome	blastn	5727	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia anophelis
13341777	13341777	PRJNA609258_P_NODE_49971_length_253_cov_0.866667_g49586_i0	PRJNA609258	49971	253	0.866667	2.19266751	Chryseobacterium shandongense	1493872	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|1519510996\|gb\|CP033915.1\|	1493872	g49586	i0	98.419	3	253	4	100	0	1	253	1876921	1877173	Chryseobacterium shandongense strain G0207 chromosome, complete genome	blastn	759	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium shandongense
14616718	14616718	PRJNA609258_P_NODE_50652_length_252_cov_0.871508_g50267_i0	PRJNA609258	50652	252	0.871508	2.19620016	Bacteroides graminisolvens	477666	Bacteria	Bacteria	394	3.3e-105	NTclustered	gi\|2621703509\|emb\|OY762556.1\|	477666	g50267	i0	94.841	5.99206349206349	252	13	100	0	1	252	1293903	1293652	MAG: Bacteroides graminisolvens isolate c2c85108-0b76-4fb4-8ed9-98fc9390ecb6 genome assembly, chromosome: 1	blastn	1510	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides graminisolvens
17165149	17165149	PRJNA609258_P_NODE_38794_length_295_cov_1.405405_g38409_i0	PRJNA609258	38794	295	1.405405	4.14594475	Bacteroidota	976	Bacteria	Bacteria	171	2.77e-49	NR	WP_111294315.1	1004304	g38409	i0	84	33.7423728813559	94	15	95.6	0	285	4	4	97	WP_111294315.1 NADP-dependent isocitrate dehydrogenase [Hydrotalea sandarakina]	diamond	9954	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrotalea	Hydrotalea sandarakina
17165678	17165678	PRJNA609258_P_NODE_54174_length_248_cov_0.891429_g53789_i0	PRJNA609258	54174	248	0.891429	2.21074392	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	346	9.19e-91	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g53789	i0	93.534	0.935483870967742	232	15	94	0	17	248	868039	867808	Pedobacter sp. SL55 chromosome	blastn	232	346	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
17725264	17725264	PRJNA609258_P_NODE_56994_length_245_cov_0.906977_g56609_i0	PRJNA609258	56994	245	0.906977	2.22209365	Bacteroidota	976	Bacteria	Bacteria	331	2.5400000000000002e-86	NTclustered	gi\|2126046227\|gb\|CP085529.1\|	253	g56609	i0	91.02	24.1183673469388	245	22	100	0	1	245	2368756	2368512	Chryseobacterium indologenes strain 742 chromosome, complete genome	blastn	5909	331	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
20990212	20990212	PRJNA609258_P_NODE_53437_length_249_cov_0.886364_g53052_i0	PRJNA609258	53437	249	0.886364	2.20704636	Hoylesella enoeca	76123	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|953017979\|gb\|CP013195.1\|	76123	g53052	i0	98.394	1	249	4	100	0	1	249	1326451	1326203	Hoylesella enoeca strain F0113 chromosome, complete genome	blastn	249	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella enoeca
20990433	20990433	PRJNA609258_P_NODE_60137_length_242_cov_0.923077_g59752_i0	PRJNA609258	60137	242	0.923077	2.23384634	Chryseobacterium daecheongense	192389	Bacteria	Bacteria	176	1.24e-39	NTclustered	gi\|2222664923\|gb\|CP095185.1\|	192389	g59752	i0	82.126	5.78925619834711	207	35	85	2	4	209	993479	993274	Chryseobacterium daecheongense strain F23 chromosome, complete genome	blastn	1401	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
22265048	22265048	PRJNA609258_P_NODE_56298_length_246_cov_0.901734_g55913_i0	PRJNA609258	56298	246	0.901734	2.21826564	Chryseobacterium cucumeris	1813611	Bacteria	Bacteria	278	3.37e-70	NTclustered	gi\|1969464399\|gb\|CP068760.1\|	1813611	g55913	i0	86.992	14.0406504065041	246	32	100	0	1	246	58720	58965	Chryseobacterium cucumeris strain MW-6 chromosome	blastn	3454	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium cucumeris
27048581	27048581	PRJNA609258_P_NODE_50922_length_252_cov_0.871508_g50537_i0	PRJNA609258	50922	252	0.871508	2.19620016	Chryseobacterium sp.	1871047	Bacteria	Bacteria	72.8	8.14e-13	NR	TXI86969.1	1871047	g50537	i0	50.7	0.821428571428571	69	33	81	1	214	11	280	348	TXI86969.1 MAG: hypothetical protein E6Q36_08295 [Chryseobacterium sp.]	diamond	207	72.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
27333178	27333178	PRJNA609258_P_NODE_56483_length_246_cov_0.901734_g56098_i0	PRJNA609258	56483	246	0.901734	2.21826564	Pedobacter ureilyticus	1393051	Bacteria	Bacteria	166	7.29e-48	NR	WP_138724024.1	1393051	g56098	i0	100	1	82	0	100	0	1	246	17	98	WP_138724024.1 prolyl oligopeptidase family serine peptidase [Pedobacter ureilyticus]	diamond	246	166	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ureilyticus
27756905	27756905	PRJNA609258_P_NODE_52604_length_250_cov_0.881356_g52219_i0	PRJNA609258	52604	250	0.881356	2.20339	Porphyromonadaceae	171551	Bacteria	Bacteria	117	3.07e-28	NR	WP_007365865.1	281920	g52219	i0	69.9	8.964	83	25	99.6	0	249	1	13	95	WP_007365865.1 calcium-translocating P-type ATPase, PMCA-type [Porphyromonas uenonis]	diamond	2241	117	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas uenonis
28198494	28198494	PRJNA609258_P_NODE_55426_length_247_cov_0.896552_g55041_i0	PRJNA609258	55426	247	0.896552	2.21448344	Chryseobacterium	59732	Bacteria	Bacteria	145	5.9e-40	NR	WP_072953088.1	1416778	g55041	i0	85.4	21.9109311740891	82	12	99.6	0	1	246	265	346	WP_072953088.1 HlyD family secretion protein [Chryseobacterium arachidis]	diamond	5412	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium arachidis
28672427	28672427	PRJNA609258_P_NODE_51607_length_251_cov_0.876404_g51222_i0	PRJNA609258	51607	251	0.876404	2.19977404	Bacteroidota	976	Bacteria	Bacteria	118	1.2e-28	NR	WP_088467854.1	2010998	g51222	i0	61.4	9.9203187250996	83	32	99.2	0	251	3	310	392	WP_088467854.1 cation-translocating P-type ATPase [Chryseobacterium sp. VAUSW3]	diamond	2490	119	0.991596638655462	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. VAUSW3
28722427	28722427	PRJNA609258_P_NODE_45087_length_269_cov_1.591837_g44702_i0	PRJNA609258	45087	269	1.591837	4.28204153	Pedobacter ureilyticus	1393051	Bacteria	Bacteria	173	7.33e-48	NR	WP_138721359.1	1393051	g44702	i0	100	0.992565055762082	89	0	99.3	0	2	268	250	338	WP_138721359.1 DEAD/DEAH box helicase [Pedobacter ureilyticus]	diamond	267	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter ureilyticus
29209204	29209204	PRJNA609258_P_NODE_55789_length_246_cov_1.578035_g55404_i0	PRJNA609258	55789	246	1.578035	3.8819661	Mucilaginibacter	423349	Bacteria	Bacteria	113	5.490000000000001e-27	NR	WP_147032620.1	398053	g55404	i0	59.8	2	82	33	100	0	246	1	51	132	WP_147032620.1 NRDE family protein [Mucilaginibacter ginsenosidivorans]	diamond	492	114	0.991228070175439	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter ginsenosidivorans
29385487	29385487	PRJNA609258_P_NODE_59229_length_243_cov_0.917647_g58844_i0	PRJNA609258	59229	243	0.917647	2.22988221	Kaistella anthropi	520603	Bacteria	Bacteria	74.3	1.37e-15	NR	MCB4235523.1	520603	g58844	i0	86.5	0.45679012345679	37	5	45.7	0	109	219	23	59	MCB4235523.1 hypothetical protein [Kaistella anthropi]	diamond	111	74.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella anthropi
30428122	30428122	PRJNA609258_P_NODE_58033_length_244_cov_0.912281_g57648_i0	PRJNA609258	58033	244	0.912281	2.22596564	uncultured Porphyromonas sp.	159274	Bacteria	Bacteria	170	6.44e-48	NR	WP_295020799.1	159274	g57648	i0	100	1.99180327868852	81	0	99.6	0	244	2	268	348	WP_295020799.1 right-handed parallel beta-helix repeat-containing protein [uncultured Porphyromonas sp.]	diamond	486	170	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	uncultured Porphyromonas sp.
30756782	30756782	PRJNA609258_P_NODE_49574_length_253_cov_0.866667_g49189_i0	PRJNA609258	49574	253	0.866667	2.19266751	Alloprevotella	1283313	Bacteria	Bacteria	173	2.4499999999999994e-52	NR	WP_009348600.1	671218	g49189	i0	98.8	7.96837944664032	84	1	99.6	0	252	1	159	242	WP_009348600.1 IS982 family transposase, partial [Alloprevotella rava]	diamond	2016	173	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Alloprevotella	Alloprevotella rava
30869990	30869990	PRJNA609258_P_NODE_54394_length_248_cov_0.891429_g54009_i0	PRJNA609258	54394	248	0.891429	2.21074392	Bacteroidia bacterium	2044936	Bacteria	Bacteria	55.5	1.29e-6	NR	GHT23346.1	2044936	g54009	i0	42.1	0.919354838709677	76	37	83.5	2	3	209	46	121	GHT23346.1 hypothetical protein AGMMS4957_14770 [Bacteroidia bacterium]	diamond	228	55.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30978088	30978088	PRJNA609258_P_NODE_57494_length_245_cov_0.906977_g57109_i0	PRJNA609258	57494	245	0.906977	2.22209365	Bacteroidota	976	Bacteria	Bacteria	168	1.9699999999999998e-47	NR	WP_348335225.1	1872435	g57109	i0	97.5	4.95918367346939	81	2	99.2	0	3	245	285	365	WP_348335225.1 ATP-dependent helicase, partial [Algoriphagus sp.]	diamond	1215	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Algoriphagus	Algoriphagus sp.
31122423	31122423	PRJNA609258_P_NODE_59275_length_243_cov_0.917647_g58890_i0	PRJNA609258	59275	243	0.917647	2.22988221	Pedobacter sp. Leaf176	1736286	Bacteria	Bacteria	157	2.61e-42	NR	WP_056094292.1	1736286	g58890	i0	93.8	1	81	5	100	0	243	1	312	392	WP_056094292.1 SusC/RagA family TonB-linked outer membrane protein [Pedobacter sp. Leaf176]	diamond	243	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. Leaf176
32103260	32103260	PRJNA609258_P_NODE_54438_length_248_cov_0.891429_g54053_i0	PRJNA609258	54438	248	0.891429	2.21074392	Weeksellaceae bacterium A-14	3143028	Bacteria	Bacteria	151	1.4999999999999999e-40	NR	MEN2433933.1	3143028	g54053	i0	85.4	0.991935483870968	82	12	99.2	0	2	247	501	582	MEN2433933.1 S9 family peptidase [Weeksellaceae bacterium A-14]	diamond	246	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium A-14
32653601	32653601	PRJNA609258_P_NODE_50920_length_252_cov_0.871508_g50535_i0	PRJNA609258	50920	252	0.871508	2.19620016	Weeksellaceae	2762318	Bacteria	Bacteria	56.2	7.19e-7	NR	WP_336686720.1	1241978	g50535	i0	72.7	3.5	33	9	39.3	0	152	250	221	253	WP_336686720.1 transcription termination factor Rho [Chryseobacterium bernardetii]	diamond	882	56.6	0.992932862190813	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium bernardetii
32653602	32653602	PRJNA609258_P_NODE_51400_length_251_cov_0.876404_g51015_i0	PRJNA609258	51400	251	0.876404	2.19977404	Pedobacter	84567	Bacteria	Bacteria	112	7.47e-29	NR	WP_131539730.1	2488994	g51015	i0	96.3	1.29083665338645	54	2	64.5	0	249	88	169	222	WP_131539730.1 cytochrome b/b6 domain-containing protein [Pedobacter nototheniae]	diamond	324	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter nototheniae

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