metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA798905" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA798905" 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
792201	792201	PRJNA798905_S_NODE_35321_length_252_cov_4.240223_g34872_i0	PRJNA798905	35321	252	4.240223	10.68536196	Kaistella haifensis	421525	Bacteria	Bacteria	374	4.2899999999999985e-99	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g34872	i0	99.512	1.02777777777778	205	1	100	0	1	205	1853766	1853562	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	259	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
1218185	1218185	PRJNA798905_S_NODE_38121_length_245_cov_2.238372_g37672_i0	PRJNA798905	38121	245	2.238372	5.4840114	Weeksella	1013	Bacteria	Bacteria	394	3.189999999999999e-105	NTclustered	gi\|1540103113\|emb\|LR134404.1\|	1014	g37672	i0	96.624	97.0571428571429	237	8	97	0	7	243	1213195	1213431	Weeksella virosa strain NCTC11634 genome assembly, chromosome: 1	blastn	23779	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Weeksella	Weeksella virosa
2068266	2068266	PRJNA798905_S_NODE_5182_length_585_cov_6.189453_g4736_i0	PRJNA798905	5182	585	6.189453	36.20830005	Bacteroides faecis	674529	Bacteria	Bacteria	719	0	NTclustered	gi\|2290667015\|gb\|CP103141.1\|	674529	g4736	i0	97.842	7.98632478632479	417	7	99	2	171	585	2911206	2911622	Bacteroides faecis strain BFG-527 chromosome, complete genome	blastn	4672	719	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides faecis
3343163	3343163	PRJNA798905_S_NODE_31143_length_271_cov_1.176768_g30694_i0	PRJNA798905	31143	271	1.176768	3.18904128	Flavobacterium dauae	1563479	Bacteria	Bacteria	300	8.04e-77	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g30694	i0	86.891	1.91143911439114	267	35	99	0	5	271	1713237	1712971	Flavobacterium dauae strain TCH3-2 chromosome, complete genome	blastn	518	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium dauae
4620567	4620567	PRJNA798905_S_NODE_34544_length_255_cov_5.692308_g34095_i0	PRJNA798905	34544	255	5.692308	14.5153854	Chryseobacterium sp. POL2	2713414	Bacteria	Bacteria	455	1.51e-123	NTclustered	gi\|1817959117\|gb\|CP049298.1\|	2713414	g34095	i0	98.824	1	255	3	100	0	1	255	2459614	2459360	Chryseobacterium sp. POL2 chromosome, complete genome	blastn	255	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. POL2
7170388	7170388	PRJNA798905_S_NODE_286_length_2551_cov_18.600888_g142_i0	PRJNA798905	286	2551	18.600888	474.50865288	Polaribacter sp. ALD11	2058137	Bacteria	Bacteria	222	1.91e-52	NTclustered	gi\|1304117238\|gb\|CP025119.1\|	2058137	g142	i0	78.994	4.25597804782438	338	61	13	9	728	1060	1781577	1781245	Polaribacter sp. ALD11 chromosome, complete genome	blastn	10857	222	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter sp. ALD11
8445026	8445026	PRJNA798905_S_NODE_24667_length_303_cov_4.700000_g24218_i0	PRJNA798905	24667	303	4.7	14.241	Chryseobacterium sp. 3008163	2478663	Bacteria	Bacteria	420	6.72e-113	NTclustered	gi\|1494289966\|gb\|CP033070.1\|	2478663	g24218	i0	93.594	3.45874587458746	281	18	93	0	1	281	2649175	2649455	Chryseobacterium sp. 3008163 chromosome, complete genome	blastn	1048	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 3008163
9720203	9720203	PRJNA798905_S_NODE_28428_length_283_cov_5.876190_g27979_i0	PRJNA798905	28428	283	5.87619	16.6296177	Empedobacter falsenii	343874	Bacteria	Bacteria	361	3.82e-95	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g27979	i0	93.75	0.848056537102474	240	15	85	0	1	240	2332063	2331824	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	240	361	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
10146568	10146568	PRJNA798905_S_NODE_15228_length_372_cov_2.060201_g14779_i0	PRJNA798905	15228	372	2.060201	7.66394772	Weeksellaceae	2762318	Bacteria	Bacteria	682	0	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g14779	i0	99.731	22.0887096774194	372	1	100	0	1	372	236403	236032	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	8217	682	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
12697833	12697833	PRJNA798905_S_NODE_35990_length_250_cov_3.615819_g35541_i0	PRJNA798905	35990	250	3.615819	9.0395475	Bacteroides	816	Bacteria	Bacteria	209	1.27e-49	NTclustered	gi\|2290705483\|gb\|CP103188.1\|	817	g35541	i0	95.455	306	132	5	52	1	76	206	901936	902067	Bacteroides fragilis strain BFG-57 chromosome, complete genome	blastn	76500	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
13546018	13546018	PRJNA798905_S_NODE_4851_length_604_cov_6.120527_g4407_i0	PRJNA798905	4851	604	6.120527	36.96798308	Sphingobacterium hotanense	649196	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1735047830\|gb\|CP030848.1\|	649196	g4407	i0	94.737	0.0629139072847682	38	1	6	1	473	510	2973851	2973887	Sphingobacterium hotanense strain AMCC101218 chromosome, complete genome	blastn	38	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium hotanense
14820374	14820374	PRJNA798905_S_NODE_26512_length_293_cov_5.740909_g26063_i0	PRJNA798905	26512	293	5.740909	16.82086337	Kaistella haifensis	421525	Bacteria	Bacteria	433	8.3e-117	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g26063	i0	93.471	4.89761092150171	291	19	99	0	1	291	230041	229751	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	1435	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
16094613	16094613	PRJNA798905_S_NODE_27793_length_287_cov_1.079439_g27344_i0	PRJNA798905	27793	287	1.079439	3.09798993	Paraflavitalea speifideaquila	3076558	Bacteria	Bacteria	350	8.400000000000001e-92	NTclustered	gi\|2589062546\|gb\|CP135920.1\|	3076558	g27344	i0	89.007	231.491289198606	282	31	98	0	1	282	7251967	7251686	Paraflavitalea speifideaquila strain BL16E chromosome, complete genome	blastn	66438	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Paraflavitalea	Paraflavitalea speifideaquila
17370360	17370360	PRJNA798905_S_NODE_23634_length_309_cov_4.012712_g23185_i0	PRJNA798905	23634	309	4.012712	12.39928008	Chryseobacterium sp. 3008163	2478663	Bacteria	Bacteria	449	8.76e-122	NTclustered	gi\|1494289966\|gb\|CP033070.1\|	2478663	g23185	i0	92.88	5.00970873786408	309	22	100	0	1	309	2648659	2648967	Chryseobacterium sp. 3008163 chromosome, complete genome	blastn	1548	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 3008163
18643574	18643574	PRJNA798905_S_NODE_28375_length_284_cov_1.459716_g27926_i0	PRJNA798905	28375	284	1.459716	4.14559344	Bacteroides sp. KFT8	2025659	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|2896030223\|gb\|CP178209.1\|	2025659	g27926	i0	100	59.6901408450704	284	0	100	0	1	284	3928518	3928801	Bacteroides sp. KFT8 chromosome, complete genome	blastn	16952	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. KFT8
19918496	19918496	PRJNA798905_S_NODE_12356_length_402_cov_3.227964_g11907_i0	PRJNA798905	12356	402	3.227964	12.97641528	Kaistella faecalis	2852098	Bacteria	Bacteria	418	3.3e-112	NTclustered	gi\|2155709714\|gb\|CP087583.1\|	2852098	g11907	i0	88.286	3.37810945273632	350	39	87	2	12	360	405334	404986	Kaistella faecalis strain F4 chromosome, complete genome	blastn	1358	418	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella faecalis
21194197	21194197	PRJNA798905_S_NODE_15517_length_369_cov_3.317568_g15068_i0	PRJNA798905	15517	369	3.317568	12.24182592	Kaistella faecalis	2852098	Bacteria	Bacteria	368	3.07e-97	NTclustered	gi\|2155709714\|gb\|CP087583.1\|	2852098	g15068	i0	85.352	12.970189701897	355	52	96	0	15	369	406075	405721	Kaistella faecalis strain F4 chromosome, complete genome	blastn	4786	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella faecalis
21194458	21194458	PRJNA798905_S_NODE_26577_length_293_cov_2.800000_g26128_i0	PRJNA798905	26577	293	2.8	8.204	Chryseobacterium daecheongense	192389	Bacteria	Bacteria	156	2.01e-33	NTclustered	gi\|2222664923\|gb\|CP095185.1\|	192389	g26128	i0	81.481	2.28327645051195	189	35	65	0	65	253	2508582	2508394	Chryseobacterium daecheongense strain F23 chromosome, complete genome	blastn	669	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
21620270	21620270	PRJNA798905_S_NODE_24977_length_301_cov_7.000000_g24528_i0	PRJNA798905	24977	301	7	21.07	root	1	Root_unresolved	Root_unresolved	183	9.519999999999997e-42	NTclustered	gi\|2574691227\|dbj\|AP028867.1\|	45254	g24528	i0	91.667	52.4617940199336	132	11	44	0	170	301	879278	879147	Dysgonomonas capnocytophagoides SMU001 DNA, complete genome	blastn	15791	183	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas capnocytophagoides
21620392	21620392	PRJNA798905_S_NODE_38377_length_244_cov_4.976608_g37928_i0	PRJNA798905	38377	244	4.976608	12.14292352	Chryseobacterium	59732	Bacteria	Bacteria	279	9.27e-71	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g37928	i0	87.347	43.6885245901639	245	29	100	2	1	244	1199954	1199711	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	10660	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
23744377	23744377	PRJNA798905_S_NODE_10219_length_433_cov_1.933333_g9770_i0	PRJNA798905	10219	433	1.933333	8.37133189	Empedobacter falsenii	343874	Bacteria	Bacteria	547	4.369999999999998e-151	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g9770	i0	95.614	1.27713625866051	342	13	79	1	92	433	1453142	1453481	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	553	547	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
23744728	23744728	PRJNA798905_S_NODE_25239_length_300_cov_2.986784_g24790_i0	PRJNA798905	25239	300	2.986784	8.960352	Chryseobacterium balustinum	246	Bacteria	Bacteria	425	1.43e-114	NTclustered	gi\|1519576354\|gb\|CP033934.1\|	246	g24790	i0	92.308	0.996666666666667	299	23	99	0	2	300	4626981	4627279	Chryseobacterium balustinum strain KC_1863 chromosome, complete genome	blastn	299	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium balustinum
23745063	23745063	PRJNA798905_S_NODE_40219_length_239_cov_9.548193_g39770_i0	PRJNA798905	40219	239	9.548193	22.82018127	Bacteroides sp. KFT8	2025659	Bacteria	Bacteria	405	1.43e-108	NTclustered	gi\|2896030223\|gb\|CP178209.1\|	2025659	g39770	i0	99.111	0.941422594142259	225	2	94	0	1	225	1791455	1791679	Bacteroides sp. KFT8 chromosome, complete genome	blastn	225	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. KFT8
24169997	24169997	PRJNA798905_S_NODE_43239_length_223_cov_6.660000_g42790_i0	PRJNA798905	43239	223	6.66	14.8518	root	1	Root_unresolved	Root_unresolved	209	1.11e-49	NTclustered	gi\|2093932526\|gb\|CP082886.1\|	291645	g42790	i0	83.945	1.95515695067265	218	35	98	0	1	218	3028492	3028709	Bacteroides nordii strain FDAARGOS_1461 chromosome, complete genome	blastn	436	209	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides nordii
25018850	25018850	PRJNA798905_S_NODE_41820_length_231_cov_3.898734_g41371_i0	PRJNA798905	41820	231	3.898734	9.00607554	Petrimonas mucosa	1642646	Bacteria	Bacteria	198	2.51e-46	NTclustered	gi\|1088721598\|emb\|LT608328.1\|	1642646	g41371	i0	83.796	0.935064935064935	216	27	92	8	2	213	1414502	1414713	Petrimonas mucosa isolate ING2-E5A genome assembly, chromosome: I	blastn	216	198	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Petrimonas	Petrimonas mucosa
25018895	25018895	PRJNA798905_S_NODE_43900_length_214_cov_4.184397_g43451_i0	PRJNA798905	43900	214	4.184397	8.95460958	Kaistella haifensis	421525	Bacteria	Bacteria	296	7.89e-76	NTclustered	gi\|1519569220\|gb\|CP033933.1\|	421525	g43451	i0	99.387	1.77570093457944	163	1	100	0	1	163	92345	92183	Kaistella haifensis strain G0079 chromosome, complete genome	blastn	380	296	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis

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