metadata: contig_metadata: 24 rows where bioproject = "PRJNA532380" and tax

24 rows where bioproject = "PRJNA532380" 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
1117320	1117320	PRJNA532380_P_NODE_12061_length_263_cov_1.565421_g11736_i0	PRJNA532380	12061	263	1.565421	4.11705723	Weeksellaceae	2762318	Bacteria	Bacteria	475	1.2e-129	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g11736	i0	99.24	481.026615969582	263	2	100	0	1	263	129923	129661	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	126510	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
3668752	3668752	PRJNA532380_P_NODE_18903_length_207_cov_1.379747_g18578_i0	PRJNA532380	18903	207	1.379747	2.85607629	Dyadobacter	120831	Bacteria	Bacteria	377	2.63e-100	NTclustered	gi\|2257605683\|gb\|CP098806.1\|	2906443	g18578	i0	99.519	291.454106280193	208	0	100	1	1	207	4700999	4701206	Dyadobacter fanqingshengii strain CY399 chromosome, complete genome	blastn	60331	377	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fanqingshengii
3668778	3668778	PRJNA532380_P_NODE_31783_length_164_cov_0.904348_g31458_i0	PRJNA532380	31783	164	0.904348	1.48313072	Chryseobacterium	59732	Bacteria	Bacteria	246	5.8499999999999995e-61	NTclustered	gi\|2463166018\|gb\|CP119767.1\|	651561	g31458	i0	94.904	433.09756097561	157	8	96	0	8	164	3157867	3157711	Chryseobacterium arthrosphaerae strain FS91703 chromosome, complete genome	blastn	71028	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium arthrosphaerae
4330616	4330616	PRJNA532380_P_NODE_18364_length_210_cov_1.366460_g18039_i0	PRJNA532380	18364	210	1.36646	2.869566	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	355	1.25e-93	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g18039	i0	97.143	171.395238095238	210	6	100	0	1	210	4833272	4833063	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	35993	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
4330855	4330855	PRJNA532380_P_NODE_25504_length_176_cov_1.228346_g25179_i0	PRJNA532380	25504	176	1.228346	2.16188896	Emticicia sp. 21SJ11W-3	2916755	Bacteria	Bacteria	219	1.3799999999999999e-52	NTclustered	gi\|2264098040\|gb\|CP092074.1\|	2916755	g25179	i0	89.595	221.653409090909	173	16	98	2	5	176	113033	113204	Emticicia sp. 21SJ11W-3 chromosome, complete genome	blastn	39011	219	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia sp. 21SJ11W-3
6881997	6881997	PRJNA532380_P_NODE_9226_length_309_cov_1.200000_g8901_i0	PRJNA532380	9226	309	1.2	3.708	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2621786417\|emb\|OY782875.1\|	2053594	g8901	i0	92.5	0.129449838187702	40	2	13	1	229	268	2869209	2869247	MAG: Prolixibacteraceae bacterium isolate 03360cef-1fb4-4bdc-8d3a-9e0c45a661a4 genome assembly, chromosome: 1	blastn	40	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
8156654	8156654	PRJNA532380_P_NODE_20907_length_196_cov_2.122449_g20582_i0	PRJNA532380	20907	196	2.122449	4.16000004	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	309	9.11e-80	NTclustered	gi\|2621780210\|emb\|OY776497.1\|	2212467	g20582	i0	95.385	555.75	195	7	99	2	1	195	1067091	1066899	MAG: Bacteroidaceae bacterium isolate 33854f8d-f901-4bce-8b2d-65fb297ee460 genome assembly, chromosome: 1	blastn	108927	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
8770513	8770513	PRJNA532380_P_NODE_7907_length_338_cov_2.325260_g7582_i0	PRJNA532380	7907	338	2.32526	7.8593788	Bacteroides	816	Bacteria	Bacteria	520	7.279999999999998e-143	NTclustered	gi\|2907625630\|emb\|OZ223190.1\|	162156	g7582	i0	94.379	482.502958579882	338	19	100	0	1	338	1137665	1138002	MAG: uncultured Bacteroides sp. isolate 83517295-f76d-485f-aefc-f1c63b392a70 genome assembly, chromosome: 2	blastn	163086	525	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	uncultured Bacteroides sp.
12596450	12596450	PRJNA532380_P_NODE_30710_length_165_cov_0.896552_g30385_i0	PRJNA532380	30710	165	0.896552	1.4793108	Sphingobacterium	28453	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2719408992\|gb\|CP151087.1\|	259	g30385	i0	100	399.042424242424	165	0	100	0	1	165	4423287	4423451	Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome	blastn	65842	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium thalpophilum
15145569	15145569	PRJNA532380_P_NODE_9932_length_295_cov_1.983740_g9607_i0	PRJNA532380	9932	295	1.98374	5.852033	Bacteroides	816	Bacteria	Bacteria	313	1.14e-80	NTclustered	gi\|2907625731\|emb\|OZ223291.1\|	162156	g9607	i0	86.254	476.905084745763	291	37	98	2	1	288	71284	71574	MAG: uncultured Bacteroides sp. isolate 957ffbb5-8ec4-4b3e-b4c0-d4f05084aee6 genome assembly, chromosome: 3	blastn	140687	315	0.993650793650794	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	uncultured Bacteroides sp.
17081414	17081414	PRJNA532380_P_NODE_31434_length_164_cov_0.904348_g31109_i0	PRJNA532380	31434	164	0.904348	1.48313072	Dyadobacter chenhuakuii	2909339	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2257600705\|gb\|CP098805.1\|	2909339	g31109	i0	100	239.237804878049	164	0	100	0	1	164	4455606	4455443	Dyadobacter chenhuakuii strain CY22 chromosome, complete genome	blastn	39235	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter chenhuakuii
18355314	18355314	PRJNA532380_P_NODE_25235_length_177_cov_1.601562_g24910_i0	PRJNA532380	25235	177	1.601562	2.83476474	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	292	8.09e-75	NTclustered	gi\|1231736207\|emb\|LT906465.1\|	536441	g24910	i0	97.647	457.107344632768	170	4	96	0	1	170	1407332	1407163	Chryseobacterium taklimakanense strain NCTC13490 genome assembly, chromosome: 1	blastn	80908	292	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
18968962	18968962	PRJNA532380_P_NODE_13295_length_249_cov_1.100000_g12970_i0	PRJNA532380	13295	249	1.1	2.739	Flavisolibacter	398041	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g12970	i0	97.992	237.212851405623	249	5	100	0	1	249	4832662	4832414	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	59066	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
19629477	19629477	PRJNA532380_P_NODE_11916_length_265_cov_1.439815_g11591_i0	PRJNA532380	11916	265	1.439815	3.81550975	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	198	2.94e-46	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g11591	i0	83.258	14.7622641509434	221	31	82	6	48	265	360093	359876	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	3912	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
20243956	20243956	PRJNA532380_P_NODE_7396_length_351_cov_1.625828_g7071_i0	PRJNA532380	7396	351	1.625828	5.70665628	Dyadobacter	120831	Bacteria	Bacteria	573	5.719999999999998e-159	NTclustered	gi\|1768674615\|emb\|LR735258.1\|	538966	g7071	i0	96.045	242.259259259259	354	11	100	2	1	351	3565657	3565304	Dyadobacter sp. 32 isolate Dyadobacter sp. 32 sample 2 genome assembly, chromosome: 1	blastn	85033	573	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. 32
22180387	22180387	PRJNA532380_P_NODE_17778_length_213_cov_3.158537_g17453_i0	PRJNA532380	17778	213	3.158537	6.72768381	Paludibacteraceae bacterium	2748031	Bacteria	Bacteria	279	7.9e-71	NTclustered	gi\|2621702112\|emb\|OY760143.1\|	2748031	g17453	i0	90.909	519.417840375587	209	18	98	1	5	213	1474236	1474443	MAG: Paludibacteraceae bacterium isolate 01c8064d-6cbe-49cb-b462-9ef0373b1e27 genome assembly, chromosome: 1	blastn	110636	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae		Paludibacteraceae bacterium
23456145	23456145	PRJNA532380_P_NODE_27219_length_169_cov_1.300000_g26894_i0	PRJNA532380	27219	169	1.3	2.197	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	226	7.859999999999997e-55	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g26894	i0	93.464	363.899408284024	153	9	90	1	16	167	443663	443511	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	61499	226	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
27092654	27092654	PRJNA532380_P_NODE_27262_length_169_cov_1.275000_g26937_i0	PRJNA532380	27262	169	1.275	2.15475	Parabacteroides	375288	Bacteria	Bacteria	41.6	0.0144	NR	WP_347145407.1	823	g26937	i0	66.7	1.06508875739645	30	10	53.3	0	141	52	42	71	WP_347145407.1 hypothetical protein [Parabacteroides distasonis]	diamond	180	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
27583025	27583025	PRJNA532380_P_NODE_27564_length_169_cov_0.866667_g27239_i0	PRJNA532380	27564	169	0.866667	1.46466723	Cytophagaceae bacterium	2026729	Bacteria	Bacteria	74.7	5.52e-14	NR	MFN6944692.1	2026729	g27239	i0	58.9	0.994082840236686	56	23	99.4	0	2	169	92	147	MFN6944692.1 branched-chain amino acid aminotransferase [Cytophagaceae bacterium]	diamond	168	74.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium
29587042	29587042	PRJNA532380_P_NODE_33350_length_162_cov_0.920354_g33025_i0	PRJNA532380	33350	162	0.920354	1.49097348	Bacteroidota	976	Bacteria	Bacteria	47	3.54e-4	NR	MDE0916928.1	2021391	g33025	i0	50	4.16666666666667	38	19	70.4	0	48	161	14	51	MDE0916928.1 BPTI/Kunitz domain-containing protein [Flavobacteriales bacterium]	diamond	675	47.4	0.991561181434599	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
30172291	30172291	PRJNA532380_P_NODE_30192_length_166_cov_0.888889_g29867_i0	PRJNA532380	30192	166	0.888889	1.47555574	Haliscomenobacter hydrossis	2350	Bacteria	Bacteria	127	3.45e-33	NR	WP_013768666.1	2350	g29867	i0	98.2	0.993975903614458	55	1	99.4	0	165	1	167	221	WP_013768666.1 saccharopine dehydrogenase C-terminal domain-containing protein [Haliscomenobacter hydrossis]	diamond	165	127	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Haliscomenobacteraceae	Haliscomenobacter	Haliscomenobacter hydrossis
31278173	31278173	PRJNA532380_P_NODE_14975_length_233_cov_2.260870_g14650_i0	PRJNA532380	14975	233	2.26087	5.2678271	Prolixibacteraceae bacterium	2053594	Bacteria	Bacteria	114	1.18e-27	NR	MBP6968496.1	2053594	g14650	i0	78.4	11.5107296137339	74	16	95.3	0	10	231	4	77	MBP6968496.1 adenosylhomocysteinase [Prolixibacteraceae bacterium]	diamond	2682	114	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Prolixibacteraceae		Prolixibacteraceae bacterium
32637991	32637991	PRJNA532380_P_NODE_33240_length_162_cov_0.920354_g32915_i0	PRJNA532380	33240	162	0.920354	1.49097348	Bacteroidales bacterium	2030927	Bacteria	Bacteria	42.4	0.0174	NR	NOQ25841.1	2030927	g32915	i0	45	0.740740740740741	40	22	74.1	0	16	135	8	47	NOQ25841.1 quinone-dependent dihydroorotate dehydrogenase [Bacteroidales bacterium]	diamond	120	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32701134	32701134	PRJNA532380_P_NODE_33520_length_162_cov_0.920354_g33195_i0	PRJNA532380	33520	162	0.920354	1.49097348	Hymenobacter	89966	Bacteria	Bacteria	41.2	0.0434	NR	WP_183403953.1	89966	g33195	i0	52.8	0.666666666666667	36	14	66.7	1	142	35	387	419	WP_183403953.1 MULTISPECIES: ArnT family glycosyltransferase [Hymenobacter]	diamond	108	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter

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