metadata: contig_metadata: 17 rows where bioproject = "PRJNA930380" and tax

17 rows where bioproject = "PRJNA930380" 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
909312	909312	PRJNA930380_P_NODE_1061_length_583_cov_2.670588_g1008_i0	PRJNA930380	1061	583	2.670588	15.56952804	Cloacibacterium caeni	2004710	Bacteria	Bacteria	1066	0	NTclustered	gi\|2040340746\|emb\|OU015319.1\|	2004710	g1008	i0	99.657	466.93653516295	583	2	100	0	1	583	1986355	1986937	Cloacibacterium caeni isolate Isolate1 genome assembly, chromosome: 000000F_arrow	blastn	272224	1066	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
4737714	4737714	PRJNA930380_P_NODE_13864_length_243_cov_0.905882_g13811_i0	PRJNA930380	13864	243	0.905882	2.20129326	Niabella ginsenosidivorans	1176587	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1033838715\|gb\|CP015772.1\|	1176587	g13811	i0	100	0.11522633744856	28	0	12	0	96	123	2659477	2659450	Niabella ginsenosidivorans strain BS26 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella ginsenosidivorans
4737737	4737737	PRJNA930380_P_NODE_1464_length_502_cov_1.668998_g1411_i0	PRJNA930380	1464	502	1.668998	8.37836996	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	784	0	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g1411	i0	94.821	446.56374501992	502	26	100	0	1	502	1236161	1236662	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	224175	784	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
9837244	9837244	PRJNA930380_P_NODE_10088_length_270_cov_1.467005_g10035_i0	PRJNA930380	10088	270	1.467005	3.9609135	Chryseobacterium endophyticum	1854762	Bacteria	Bacteria	481	2.66e-131	NTclustered	gi\|2731632474\|gb\|CP154834.1\|	1854762	g10035	i0	99.248	12.9481481481481	266	2	99	0	3	268	650063	649798	Chryseobacterium endophyticum strain OsEnb-ALM-A6 chromosome, complete genome	blastn	3496	481	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium endophyticum
13662924	13662924	PRJNA930380_P_NODE_1151_length_563_cov_3.132653_g1098_i0	PRJNA930380	1151	563	3.132653	17.63683639	Cloacibacterium caeni	2004710	Bacteria	Bacteria	1027	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g1098	i0	99.644	101.312611012433	562	2	99	0	1	562	1875928	1875367	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	57039	1027	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
13663078	13663078	PRJNA930380_P_NODE_4571_length_306_cov_1.982833_g4518_i0	PRJNA930380	4571	306	1.982833	6.06746898	Prevotella sp.	59823	Bacteria	Bacteria	451	2.41e-122	NTclustered	gi\|2580284204\|gb\|OR338521.1\|	59823	g4518	i0	93.464	536.591503267974	306	17	99	3	1	305	2303	2606	Prevotella sp. strain k141_12813 hypothetical protein gene, complete cds	blastn	164197	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
17832416	17832416	PRJNA930380_P_NODE_11314_length_251_cov_0.882022_g11261_i0	PRJNA930380	11314	251	0.882022	2.21387522	Porphyromonas	836	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g11261	i0	90.157	473.155378486056	254	20	100	5	1	251	1546700	1546951	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	118762	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
17832423	17832423	PRJNA930380_P_NODE_1214_length_547_cov_1.829114_g1161_i0	PRJNA930380	1214	547	1.829114	10.00525358	Parabacteroides	375288	Bacteria	Bacteria	577	7.179999999999998e-160	NTclustered	gi\|2784334720\|gb\|CP165599.1\|	328812	g1161	i0	86.106	543.345521023766	547	63	99	11	1	539	4658937	4658396	Parabacteroides goldsteinii strain WXC08 chromosome, complete genome	blastn	297210	577	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides goldsteinii
17832479	17832479	PRJNA930380_P_NODE_8474_length_280_cov_1.487923_g8421_i0	PRJNA930380	8474	280	1.487923	4.1661844	Bacteroides	816	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2759676791\|gb\|CP131538.1\|	338188	g8421	i0	100	0.2	28	0	10	0	119	146	120315	120288	Bacteroides finegoldii strain CL09T03C10 chromosome, complete genome	blastn	56	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides finegoldii
26613235	26613235	PRJNA930380_P_NODE_11461_length_251_cov_0.865169_g11408_i0	PRJNA930380	11461	251	0.865169	2.17157419	Bacteroidota bacterium	1898104	Bacteria	Bacteria	96.3	6.2e-21	NR	MEM7104478.1	1898104	g11408	i0	62.5	0.860557768924303	72	27	86.1	0	11	226	4	75	MEM7104478.1 Ig-like domain-containing protein [Bacteroidota bacterium]	diamond	216	96.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
26810465	26810465	PRJNA930380_P_NODE_5261_length_295_cov_3.490991_g5208_i0	PRJNA930380	5261	295	3.490991	10.29842345	Bacteria	2	Bacteria	Bacteria	50.4	1.39e-4	NR	MCH1596527.1	1871037	g5208	i0	41.9	5.47118644067797	62	34	61	1	25	204	897	958	MCH1596527.1 endonuclease/exonuclease/phosphatase family protein [Flavobacteriaceae bacterium]	diamond	1614	50.8	0.992125984251969	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
27214418	27214418	PRJNA930380_P_NODE_9122_length_276_cov_2.492611_g9069_i0	PRJNA930380	9122	276	2.492611	6.87960636	Bacteroidota bacterium	1898104	Bacteria	Bacteria	72.4	2.03e-12	NR	MEL7062654.1	1898104	g9069	i0	42.9	10.1739130434783	91	48	94.6	3	271	11	96	186	MEL7062654.1 reverse transcriptase family protein [Bacteroidota bacterium]	diamond	2808	72.8	0.994505494505495	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27372921	27372921	PRJNA930380_P_NODE_13423_length_244_cov_0.900585_g13370_i0	PRJNA930380	13423	244	0.900585	2.1974274	Phocaeicola vulgatus	821	Bacteria	Bacteria	40	0.0439	NR	WP_227238842.1	821	g13370	i0	40	0.491803278688525	40	22	46.7	1	99	212	11	50	WP_227238842.1 hypothetical protein, partial [Phocaeicola vulgatus]	diamond	120	40	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
29330197	29330197	PRJNA930380_P_NODE_9849_length_272_cov_1.175879_g9796_i0	PRJNA930380	9849	272	1.175879	3.19839088	Bacteroidales bacterium	2030927	Bacteria	Bacteria	57.4	3.37e-7	NR	MCD8313594.1	2030927	g9796	i0	40.5	0.871323529411765	79	42	83.8	3	269	42	196	272	MCD8313594.1 hypothetical protein [Bacteroidales bacterium]	diamond	237	57.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
31036296	31036296	PRJNA930380_P_NODE_5635_length_293_cov_1.400000_g5582_i0	PRJNA930380	5635	293	1.4	4.102	Bacteroidota bacterium	1898104	Bacteria	Bacteria	43.1	0.0433	NR	MEM8486685.1	1898104	g5582	i0	30.8	0.931740614334471	91	56	86	2	10	261	84	174	MEM8486685.1 TerB family tellurite resistance protein [Bacteroidota bacterium]	diamond	273	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31067792	31067792	PRJNA930380_P_NODE_8355_length_281_cov_1.033654_g8302_i0	PRJNA930380	8355	281	1.033654	2.90456774	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	55.8	1.43e-6	NR	MCH1595862.1	1871037	g8302	i0	37.5	5.3914590747331	72	45	76.9	0	54	269	130	201	MCH1595862.1 reverse transcriptase family protein [Flavobacteriaceae bacterium]	diamond	1515	56.2	0.99288256227758	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
32396180	32396180	PRJNA930380_P_NODE_10679_length_263_cov_1.594737_g10626_i0	PRJNA930380	10679	263	1.594737	4.19415831	Cloacibacterium sp.	1913682	Bacteria	Bacteria	156	6.04e-42	NR	WP_414985015.1	1913682	g10626	i0	94.3	0.992395437262357	87	5	99.2	0	2	262	45	131	WP_414985015.1 TonB-dependent receptor domain-containing protein [Cloacibacterium sp.]	diamond	261	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium 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);;