metadata: contig_metadata: 18 rows where bioproject = "PRJNA804229" and tax

18 rows where bioproject = "PRJNA804229" 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
14831943	14831943	PRJNA804229_S_NODE_19632_length_400_cov_1.378151_g18678_i0	PRJNA804229	19632	400	1.378151	5.512604	Porphyromonas sp. oral taxon 275	712435	Bacteria	Bacteria	682	0	NTclustered	gi\|2028834772\|gb\|CP072333.1\|	712435	g18678	i0	98.21	424.18	391	6	98	1	10	400	442967	443356	Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome	blastn	169672	682	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas sp. oral taxon 275
14832847	14832847	PRJNA804229_S_NODE_57712_length_265_cov_2.031532_g56754_i0	PRJNA804229	57712	265	2.031532	5.3835598	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	457	4.39e-124	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g56754	i0	97.736	549.064150943396	265	6	100	0	1	265	1235020	1234756	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	145502	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
16108090	16108090	PRJNA804229_S_NODE_96553_length_207_cov_1.567073_g95595_i0	PRJNA804229	96553	207	1.567073	3.24384111	Kaistella polysaccharea	2878534	Bacteria	Bacteria	71.3	5e-8	NTclustered	gi\|2111125107\|gb\|CP084528.1\|	2878534	g95595	i0	93.617	23.3091787439614	47	3	23	0	158	204	1327894	1327848	Kaistella polysaccharea strain GW4-15 chromosome, complete genome	blastn	4825	71.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella polysaccharea
17382209	17382209	PRJNA804229_S_NODE_30254_length_345_cov_2.092715_g29296_i0	PRJNA804229	30254	345	2.092715	7.2198667500000004	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g29296	i0	100	0.0869565217391304	30	0	9	0	274	303	1161409	1161438	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
24173691	24173691	PRJNA804229_S_NODE_54799_length_271_cov_2.157895_g53841_i0	PRJNA804229	54799	271	2.157895	5.84789545	Weeksellaceae	2762318	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|1750497007\|gb\|CP043634.1\|	247	g53841	i0	99.631	422.110701107011	271	1	100	0	1	271	228962	229232	Empedobacter brevis strain SE1-3 chromosome, complete genome	blastn	114392	496	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
26769275	26769275	PRJNA804229_S_NODE_172221_length_155_cov_1.285714_g171263_i0	PRJNA804229	172221	155	1.285714	1.9928567	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	41.2	0.0398	NR	MCC7521449.1	1871037	g171263	i0	43.2	0.716129032258065	37	17	71.6	1	35	145	112	144	MCC7521449.1 PspC domain-containing protein [Flavobacteriaceae bacterium]	diamond	111	41.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
26841745	26841745	PRJNA804229_S_NODE_115221_length_190_cov_1.306122_g114263_i0	PRJNA804229	115221	190	1.306122	2.4816318	Prevotellaceae	171552	Bacteria	Bacteria	113	1.67e-27	NR	WP_036861443.1	28125	g114263	i0	98.4	53.7157894736842	63	1	99.5	0	190	2	47	109	WP_036861443.1 Na/Pi cotransporter family protein [Prevotella bivia]	diamond	10206	114	0.991228070175439	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
27623013	27623013	PRJNA804229_S_NODE_144024_length_170_cov_1.464567_g143066_i0	PRJNA804229	144024	170	1.464567	2.4897639	Dyadobacter sp. CY261	2907203	Bacteria	Bacteria	41.6	0.0365	NR	WP_234669316.1	2907203	g143066	i0	69.2	0.458823529411765	26	8	45.9	0	145	68	1000	1025	WP_234669316.1 carboxypeptidase-like regulatory domain-containing protein [Dyadobacter sp. CY261]	diamond	78	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter sp. CY261
28033465	28033465	PRJNA804229_S_NODE_66365_length_248_cov_16.102439_g65407_i0	PRJNA804229	66365	248	16.102439	39.93404872	Aureitalea sp. L	1872661	Bacteria	Bacteria	45.4	0.00445	NR	WP_265198814.1	2816962	g65407	i0	40.4	0.629032258064516	52	31	62.9	0	86	241	252	303	WP_265198814.1 hybrid sensor histidine kinase/response regulator [Aureitalea sp. L0-47]	diamond	156	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aureitalea	Aureitalea sp. L0-47
28254254	28254254	PRJNA804229_S_NODE_96646_length_207_cov_1.463415_g95688_i0	PRJNA804229	96646	207	1.463415	3.02926905	Tenacibaculum ovolyticum	104270	Bacteria	Bacteria	41.6	0.0108	NR	WP_271243210.1	104270	g95688	i0	38.6	0.63768115942029	44	27	63.8	0	29	160	7	50	WP_271243210.1 hypothetical protein [Tenacibaculum ovolyticum]	diamond	132	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum ovolyticum
28759442	28759442	PRJNA804229_S_NODE_9167_length_511_cov_22.572650_g8253_i0	PRJNA804229	9167	511	22.57265	115.3462415	Phocaeicola vulgatus	821	Bacteria	Bacteria	124	2.95e-33	NR	WP_050229787.1	821	g8253	i0	95.2	0.73972602739726	126	6	74	0	493	116	1	126	WP_050229787.1 hypothetical protein [Phocaeicola vulgatus]	diamond	378	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
29368328	29368328	PRJNA804229_S_NODE_31209_length_341_cov_2.171141_g30251_i0	PRJNA804229	31209	341	2.171141	7.40359081	root	1	Root_unresolved	Root_unresolved	46.2	0.00669	NR	MDD3108988.1	1872444	g30251	i0	52.5	1.0733137829912	40	17	35.2	1	228	109	263	300	MDD3108988.1 class I SAM-dependent DNA methyltransferase [Alistipes sp.]	diamond	366	46.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
29801327	29801327	PRJNA804229_S_NODE_151311_length_166_cov_1.170732_g150353_i0	PRJNA804229	151311	166	1.170732	1.94341512	uncultured Tenacibaculum sp.	174713	Bacteria	Bacteria	42.7	0.013	NR	WP_299683246.1	174713	g150353	i0	37.5	0.867469879518072	48	26	86.7	1	150	7	54	97	WP_299683246.1 hypothetical protein [uncultured Tenacibaculum sp.]	diamond	144	42.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	uncultured Tenacibaculum sp.
30402162	30402162	PRJNA804229_S_NODE_156433_length_163_cov_1.200000_g155475_i0	PRJNA804229	156433	163	1.2	1.956	Bacteroidota bacterium	1898104	Bacteria	Bacteria	42.4	0.0174	NR	TAE08632.1	1898104	g155475	i0	37.8	0.828220858895706	45	28	82.8	0	157	23	205	249	TAE08632.1 MAG: hypothetical protein EAZ95_16965 [Bacteroidota bacterium]	diamond	135	42.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31381510	31381510	PRJNA804229_S_NODE_145576_length_169_cov_1.523810_g144618_i0	PRJNA804229	145576	169	1.52381	2.5752389	Flavobacterium cyanobacteriorum	2022802	Bacteria	Bacteria	111	7.18e-27	NR	WP_243389534.1	2022802	g144618	i0	98.2	4.88165680473373	55	1	97.6	0	167	3	238	292	WP_243389534.1 IS1182 family transposase [Flavobacterium cyanobacteriorum]	diamond	825	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyanobacteriorum
32276253	32276253	PRJNA804229_S_NODE_191118_length_150_cov_0.897196_g190160_i0	PRJNA804229	191118	150	0.897196	1.345794	Bacteroidia	200643	Bacteria	Bacteria	102	9.75e-24	NR	WP_088654484.1	1965019	g190160	i0	100	1.96	49	0	98	0	3	149	25	73	WP_088654484.1 methionine synthase [Geofilum rhodophaeum]	diamond	294	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Geofilum	Geofilum rhodophaeum
32614973	32614973	PRJNA804229_S_NODE_119080_length_187_cov_1.333333_g118122_i0	PRJNA804229	119080	187	1.333333	2.49333271	Cecembia calidifontis	1187080	Bacteria	Bacteria	103	3.14e-25	NR	WP_130275651.1	1187080	g118122	i0	98.4	0.994652406417112	62	1	99.5	0	2	187	144	205	WP_130275651.1 TerC family protein [Cecembia calidifontis]	diamond	186	103	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae	Cecembia	Cecembia calidifontis
32772255	32772255	PRJNA804229_S_NODE_79680_length_228_cov_1.297297_g78722_i0	PRJNA804229	79680	228	1.297297	2.95783716	Bacteroidia bacterium	2044936	Bacteria	Bacteria	43.5	0.0165	NR	HKR04675.1	2044936	g78722	i0	29	1.81578947368421	69	48	90.8	1	223	17	165	232	HKR04675.1 T9SS type A sorting domain-containing protein [Bacteroidia bacterium]	diamond	414	43.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium

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