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

32 rows where bioproject = "PRJNA1008049" 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
153783	153783	PRJNA1008049_S_NODE_2041_length_180_cov_8.629139_g2023_i0	PRJNA1008049	2041	180	8.629139	15.5324502	Prevotella bivia	28125	Bacteria	Bacteria	326	8.15e-85	NTclustered	gi\|2679196903\|dbj\|AP029375.1\|	28125	g2023	i0	99.441	2.98333333333333	179	1	99	0	2	180	929557	929379	Prevotella bivia TOH-2715 DNA, chromosome 1, complete sequence	blastn	537	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
2276445	2276445	PRJNA1008049_S_NODE_3842_length_160_cov_3.839695_g3824_i0	PRJNA1008049	3842	160	3.839695	6.143512	Flavobacterium	237	Bacteria	Bacteria	257	2.62e-64	NTclustered	gi\|2513399288\|emb\|OX638201.1\|	165435	g3824	i0	95.625	17.5625	160	7	100	0	1	160	5438117	5437958	MAG: uncultured Flavobacterium sp. isolate ccd45242-ab75-41bb-baf2-9ba9f1fd70fe genome assembly, chromosome: 1	blastn	2810	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
3551858	3551858	PRJNA1008049_S_NODE_143_length_352_cov_6.018576_g125_i0	PRJNA1008049	143	352	6.018576	21.18538752	Flavobacterium	237	Bacteria	Bacteria	617	2.62e-172	NTclustered	gi\|2801935888\|gb\|CP166110.1\|	1114873	g125	i0	98.295	505.667613636364	352	6	100	0	1	352	25019	24668	Flavobacterium tructae strain CF-01 chromosome, complete genome	blastn	177995	617	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium tructae
3980236	3980236	PRJNA1008049_S_NODE_4924_length_152_cov_3.268293_g4906_i0	PRJNA1008049	4924	152	3.268293	4.96780536	Chryseobacterium sp. MEBOG06	2879938	Bacteria	Bacteria	84.2	4.41e-12	NTclustered	gi\|2186956161\|gb\|CP084580.1\|	2879938	g4906	i0	96.078	7.73026315789474	51	2	34	0	102	152	3646599	3646549	Chryseobacterium sp. MEBOG06 chromosome	blastn	1175	84.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. MEBOG06
5256713	5256713	PRJNA1008049_S_NODE_405_length_260_cov_3.627706_g387_i0	PRJNA1008049	405	260	3.627706	9.4320356	Flavobacterium sp. N2038	2986829	Bacteria	Bacteria	462	9.24e-126	NTclustered	gi\|2324023810\|gb\|CP110001.1\|	2986829	g387	i0	98.842	432.446153846154	259	3	99	0	2	260	1153089	1153347	Flavobacterium sp. N2038 chromosome, complete genome	blastn	112436	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2038
5256718	5256718	PRJNA1008049_S_NODE_4345_length_156_cov_2.842520_g4327_i0	PRJNA1008049	4345	156	2.84252	4.4343312	Flavobacterium sp. KACC 22761	3092665	Bacteria	Bacteria	132	1.6e-26	NTclustered	gi\|2625491670\|gb\|CP139148.1\|	3092665	g4327	i0	83.007	9.37820512820513	153	19	97	3	4	155	1993080	1992934	Flavobacterium sp. KACC 22761 chromosome, complete genome	blastn	1463	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. KACC 22761
7806338	7806338	PRJNA1008049_S_NODE_3127_length_167_cov_4.963768_g3109_i0	PRJNA1008049	3127	167	4.963768	8.28949256	Cloacibacterium normanense	237258	Bacteria	Bacteria	296	5.86e-76	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3109	i0	98.795	0.994011976047904	166	2	99	0	2	167	724959	724794	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	166	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
8654431	8654431	PRJNA1008049_S_NODE_307_length_279_cov_22.172000_g289_i0	PRJNA1008049	307	279	22.172	61.85988	Flavobacterium	237	Bacteria	Bacteria	464	2.7899999999999998e-126	NTclustered	gi\|2284918182\|gb\|CP100442.1\|	1114867	g289	i0	98.846	478.666666666667	260	3	93	0	17	276	23782	24041	Flavobacterium plurextorum strain RSG-18 chromosome, complete genome	blastn	133548	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium plurextorum
10356960	10356960	PRJNA1008049_S_NODE_5189_length_150_cov_6.330579_g5171_i0	PRJNA1008049	5189	150	6.330579	9.4958685	Flavobacterium sp. KACC 22763	3025668	Bacteria	Bacteria	143	7.049999999999998e-30	NTclustered	gi\|2446130210\|gb\|CP117879.1\|	3025668	g5171	i0	86.26	4.39333333333333	131	18	87	0	2	132	4771006	4771136	Flavobacterium sp. KACC 22763 chromosome, complete genome	blastn	659	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. KACC 22763
12480117	12480117	PRJNA1008049_S_NODE_3330_length_165_cov_5.595588_g3312_i0	PRJNA1008049	3330	165	5.595588	9.2327202	Flavobacterium sp. 27	239	Bacteria	Bacteria	108	2.9e-28	NR	WP_134146805.1	2512114	g3312	i0	100	0.981818181818182	54	0	98.2	0	163	2	36	89	WP_134146805.1 hypothetical protein [Flavobacterium sp. 270]	diamond	162	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. 270
14182483	14182483	PRJNA1008049_S_NODE_652_length_230_cov_37.711443_g634_i0	PRJNA1008049	652	230	37.711443	86.7363189	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	259	1.13e-64	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g634	i0	88.372	326.413043478261	215	25	95	0	1	215	1237113	1237327	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	75075	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
15456432	15456432	PRJNA1008049_S_NODE_4653_length_154_cov_1.712000_g4635_i0	PRJNA1008049	4653	154	1.712	2.63648	Flavobacterium cupriresistens	2893885	Bacteria	Bacteria	113	5.72e-21	NTclustered	gi\|2153985502\|gb\|CP087134.1\|	2893885	g4635	i0	89.011	0.590909090909091	91	10	59	0	1	91	2779586	2779676	Flavobacterium cupriresistens strain F-323 chromosome, complete genome	blastn	91	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cupriresistens
15456438	15456438	PRJNA1008049_S_NODE_5113_length_151_cov_1.942623_g5095_i0	PRJNA1008049	5113	151	1.942623	2.93336073	Flavobacterium sp. N2038	2986829	Bacteria	Bacteria	150	4.2499999999999996e-32	NTclustered	gi\|2324023810\|gb\|CP110001.1\|	2986829	g5095	i0	84.768	9.96026490066225	151	21	99	2	1	150	633158	633009	Flavobacterium sp. N2038 chromosome, complete genome	blastn	1504	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2038
16730680	16730680	PRJNA1008049_S_NODE_3554_length_163_cov_3.082090_g3536_i0	PRJNA1008049	3554	163	3.08209	5.0238067	Flavobacterium sp. N2038	2986829	Bacteria	Bacteria	200	4.589999999999999e-47	NTclustered	gi\|2324023810\|gb\|CP110001.1\|	2986829	g3536	i0	89.744	18.079754601227	156	16	96	0	6	161	4266403	4266248	Flavobacterium sp. N2038 chromosome, complete genome	blastn	2947	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N2038
19279333	19279333	PRJNA1008049_S_NODE_2436_length_176_cov_17.367347_g2418_i0	PRJNA1008049	2436	176	17.367347	30.56653072	Flavobacterium bizetiae	2704140	Bacteria	Bacteria	224	2.9699999999999996e-54	NTclustered	gi\|2272511619\|gb\|CP091861.1\|	2704140	g2418	i0	90.533	10.2784090909091	169	16	96	0	3	171	2308022	2307854	Flavobacterium bizetiae strain HJ-32-4 chromosome, complete genome	blastn	1809	224	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium bizetiae
20554976	20554976	PRJNA1008049_S_NODE_1957_length_182_cov_7.764706_g1939_i0	PRJNA1008049	1957	182	7.764706	14.13176492	Flavobacterium soyae	2903098	Bacteria	Bacteria	215	1.87e-51	NTclustered	gi\|2714450175\|gb\|CP150845.1\|	2903098	g1939	i0	88.268	5.53846153846154	179	21	98	0	1	179	4640396	4640574	Flavobacterium soyae strain 55 chromosome, complete genome	blastn	1008	215	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium soyae
20554992	20554992	PRJNA1008049_S_NODE_4057_length_158_cov_6.038760_g4039_i0	PRJNA1008049	4057	158	6.03876	9.5412408	Flavobacterium sp. MDT1-60	1979344	Bacteria	Bacteria	206	9.47e-49	NTclustered	gi\|1913467924\|gb\|CP062159.1\|	1979344	g4039	i0	90.385	15.6329113924051	156	15	99	0	1	156	1024625	1024470	Flavobacterium sp. MDT1-60 chromosome, complete genome	blastn	2470	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. MDT1-60
20555003	20555003	PRJNA1008049_S_NODE_5297_length_150_cov_1.661157_g5279_i0	PRJNA1008049	5297	150	1.661157	2.4917355	Flavobacterium johnsoniae	986	Bacteria	Bacteria	222	8.8e-54	NTclustered	gi\|1735479352\|gb\|CP031763.1\|	986	g5279	i0	93.333	12.4866666666667	150	10	100	0	1	150	4827879	4827730	Flavobacterium johnsoniae strain FJ001 chromosome	blastn	1873	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
21403377	21403377	PRJNA1008049_S_NODE_597_length_236_cov_3.719807_g579_i0	PRJNA1008049	597	236	3.719807	8.77874452	Cloacibacterium	501783	Bacteria	Bacteria	381	2.379999999999999e-101	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g579	i0	95.763	506.805084745763	236	10	100	0	1	236	130367	130602	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	119606	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
21830602	21830602	PRJNA1008049_S_NODE_858_length_216_cov_30.208556_g840_i0	PRJNA1008049	858	216	30.208556	65.25048096	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	285	1.73e-72	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g840	i0	93.264	183.976851851852	193	13	89	0	2	194	442483	442291	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	39739	285	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
23106027	23106027	PRJNA1008049_S_NODE_1159_length_203_cov_7.373563_g1141_i0	PRJNA1008049	1159	203	7.373563	14.96833289	Bergeyella cardium	1585976	Bacteria	Bacteria	124	3.7e-24	NTclustered	gi\|2504455906\|gb\|CP121693.1\|	1585976	g1141	i0	83.459	3.8128078817734	133	22	66	0	44	176	882268	882400	Bergeyella cardium strain BC chromosome, complete genome	blastn	774	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Bergeyella	Bergeyella cardium
23106052	23106052	PRJNA1008049_S_NODE_3339_length_165_cov_3.845588_g3321_i0	PRJNA1008049	3339	165	3.845588	6.3452202	uncultured Flavobacterium sp.	165435	Bacteria	Bacteria	189	1.01e-43	NTclustered	gi\|2513399288\|emb\|OX638201.1\|	165435	g3321	i0	90.78	5.39393939393939	141	13	85	0	2	142	108319	108459	MAG: uncultured Flavobacterium sp. isolate ccd45242-ab75-41bb-baf2-9ba9f1fd70fe genome assembly, chromosome: 1	blastn	890	189	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
23106058	23106058	PRJNA1008049_S_NODE_3859_length_160_cov_2.862595_g3841_i0	PRJNA1008049	3859	160	2.862595	4.580152	Flavobacterium pectinovorum	29533	Bacteria	Bacteria	193	7.489999999999999e-45	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g3841	i0	89.677	39.0625	155	11	96	4	8	160	4214688	4214839	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	6250	193	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
23106062	23106062	PRJNA1008049_S_NODE_4359_length_156_cov_2.322835_g4341_i0	PRJNA1008049	4359	156	2.322835	3.6236226	uncultured Flavobacterium sp.	165435	Bacteria	Bacteria	119	1.2500000000000001e-22	NTclustered	gi\|2513399288\|emb\|OX638201.1\|	165435	g4341	i0	83.465	2.45512820512821	127	21	81	0	8	134	5353051	5353177	MAG: uncultured Flavobacterium sp. isolate ccd45242-ab75-41bb-baf2-9ba9f1fd70fe genome assembly, chromosome: 1	blastn	383	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	uncultured Flavobacterium sp.
26686189	26686189	PRJNA1008049_S_NODE_2981_length_169_cov_2.900000_g2963_i0	PRJNA1008049	2981	169	2.9	4.901	Xanthocytophaga agilis	3048010	Bacteria	Bacteria	95.9	2.64e-21	NR	WP_314513102.1	3048010	g2963	i0	75	0.994082840236686	56	14	99.4	0	1	168	180	235	WP_314513102.1 TonB-dependent receptor [Xanthocytophaga agilis]	diamond	168	95.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Rhodocytophagaceae	Xanthocytophaga	Xanthocytophaga agilis
26844857	26844857	PRJNA1008049_S_NODE_721_length_226_cov_5.060914_g703_i0	PRJNA1008049	721	226	5.060914	11.43766564	Ferruginibacter sp.	1940288	Bacteria	Bacteria	107	2.97e-28	NR	HSN60774.1	1940288	g703	i0	65.3	0.995575221238938	75	26	99.6	0	226	2	29	103	HSN60774.1 hypothetical protein [Ferruginibacter sp.]	diamond	225	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
27121520	27121520	PRJNA1008049_S_NODE_2082_length_180_cov_2.721854_g2064_i0	PRJNA1008049	2082	180	2.721854	4.8993372	Chitinophagaceae	563835	Bacteria	Bacteria	104	9.44e-28	NR	MEI8280745.1	1898104	g2064	i0	87.7	7.6	57	7	95	0	9	179	1	57	MEI8280745.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase [Bacteroidota bacterium]	diamond	1368	105	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28543173	28543173	PRJNA1008049_S_NODE_5147_length_150_cov_12.438017_g5129_i0	PRJNA1008049	5147	150	12.438017	18.6570255	Bacteroidota	976	Bacteria	Bacteria	60.8	2.9e-9	NR	HTE12334.1	1869212	g5129	i0	58.1	5.54	43	18	86	0	130	2	4	46	HTE12334.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Chitinophagaceae bacterium]	diamond	831	60.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29024415	29024415	PRJNA1008049_S_NODE_1468_length_192_cov_17.239264_g1450_i0	PRJNA1008049	1468	192	17.239264	33.09938688	Flavobacterium sp. 27	239	Bacteria	Bacteria	54.7	2.91e-8	NR	WP_134148188.1	2512114	g1450	i0	100	0.828125	27	0	42.2	0	190	110	19	45	WP_134148188.1 rSAM-modified peptide [Flavobacterium sp. 270]	diamond	159	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. 270
29781768	29781768	PRJNA1008049_S_NODE_2111_length_179_cov_6.220000_g2093_i0	PRJNA1008049	2111	179	6.22	11.1338	Lutibacter sp.	1925666	Bacteria	Bacteria	70.9	4.97e-13	NR	MFA5300317.1	1925666	g2093	i0	55.7	3.03351955307263	61	25	98.9	1	179	3	132	192	MFA5300317.1 hypothetical protein [Lutibacter sp.]	diamond	543	70.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Lutibacter	Lutibacter sp.
29781769	29781769	PRJNA1008049_S_NODE_3211_length_166_cov_6.167883_g3193_i0	PRJNA1008049	3211	166	6.167883	10.23868578	Flavobacterium sp. 27	239	Bacteria	Bacteria	112	1.01e-29	NR	WP_134145436.1	2512114	g3193	i0	98.2	0.993975903614458	55	1	99.4	0	1	165	119	173	WP_134145436.1 Crp/Fnr family transcriptional regulator [Flavobacterium sp. 270]	diamond	165	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. 270
30382473	30382473	PRJNA1008049_S_NODE_3693_length_161_cov_7.810606_g3675_i0	PRJNA1008049	3693	161	7.810606	12.57507566	Flavobacterium sp. 27	239	Bacteria	Bacteria	103	4.15e-27	NR	TDW46491.1	2512114	g3675	i0	100	1.97515527950311	53	0	98.8	0	161	3	15	67	TDW46491.1 four helix bundle protein [Flavobacterium sp. 270]	diamond	318	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. 270

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