metadata: contig_metadata: 31 rows where analysis = "blastn", bioproject = "PRJNA1200128" and tax

31 rows where analysis = "blastn", bioproject = "PRJNA1200128" 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
327013	327013	PRJNA1200128_S_NODE_23541_length_194_cov_0.933775_g23432_i0	PRJNA1200128	23541	194	0.933775	1.8115235	Spirosoma taeanense	2735870	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g23432	i0	100	0.144329896907216	28	0	14	0	45	72	1009088	1009115	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
1601692	1601692	PRJNA1200128_S_NODE_12682_length_234_cov_2.136126_g12573_i0	PRJNA1200128	12682	234	2.136126	4.99853484	Prevotella intermedia	28131	Bacteria	Bacteria	394	3.02e-105	NTclustered	gi\|965692493\|dbj\|AP014597.1\|	28131	g12573	i0	97.009	226.213675213675	234	7	100	0	1	234	1259916	1259683	Prevotella intermedia DNA, complete genome, strain: OMA14, chromosome: I	blastn	52934	394	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
1601721	1601721	PRJNA1200128_S_NODE_17602_length_212_cov_0.958580_g17493_i0	PRJNA1200128	17602	212	0.95858	2.0321896	Flexibacter flexilis	998	Bacteria	Bacteria	130	8.37e-26	NTclustered	gi\|38374131\|gb\|M62806.2\|FBCRRL	927664	g17493	i0	78.866	38.2783018867925	194	37	90	4	23	212	203	396	Flexibacter flexilis large subunit ribosomal RNA gene, partial sequence	blastn	8115	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flexibacteraceae	Flexibacter	Flexibacter flexilis
1601858	1601858	PRJNA1200128_S_NODE_5082_length_314_cov_2.228782_g4973_i0	PRJNA1200128	5082	314	2.228782	6.99837548	Prevotella denticola	28129	Bacteria	Bacteria	279	1.24e-70	NTclustered	gi\|2028884821\|gb\|CP072374.1\|	28129	g4973	i0	83.224	10.2515923566879	304	51	97	0	11	314	1595964	1596267	Prevotella denticola strain F0115 chromosome 1, complete sequence	blastn	3219	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
1601870	1601870	PRJNA1200128_S_NODE_6582_length_288_cov_1.726531_g6473_i0	PRJNA1200128	6582	288	1.726531	4.97240928	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	449	8.090000000000001e-122	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g6473	i0	94.792	235.475694444444	288	15	100	0	1	288	2977867	2978154	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	67817	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
2320060	2320060	PRJNA1200128_S_NODE_31182_length_176_cov_2.503759_g31073_i0	PRJNA1200128	31182	176	2.503759	4.40661584	Flavobacterium	237	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|470481948\|ref\|NR_076504.1\|	986	g31073	i0	100	547.011363636364	176	0	100	0	1	176	2000	2175	Flavobacterium johnsoniae strain UW101 23S ribosomal RNA gene, complete sequence	blastn	96274	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
2877875	2877875	PRJNA1200128_S_NODE_13043_length_232_cov_2.238095_g12934_i0	PRJNA1200128	13043	232	2.238095	5.1923804	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g12934	i0	100	92.9827586206897	232	0	100	0	1	232	269875	270106	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	21572	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
2877908	2877908	PRJNA1200128_S_NODE_19923_length_204_cov_1.459627_g19814_i0	PRJNA1200128	19923	204	1.459627	2.97763908	Pedobacter sp. FW305-3-2-15-E-R2A2	3140251	Bacteria	Bacteria	316	5.72e-82	NTclustered	gi\|2720698973\|gb\|CP151803.1\|	3140251	g19814	i0	94.608	233.617647058824	204	11	100	0	1	204	402730	402933	Pedobacter sp. FW305-3-2-15-E-R2A2 chromosome, complete genome	blastn	47658	316	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. FW305-3-2-15-E-R2A2
2877918	2877918	PRJNA1200128_S_NODE_21463_length_199_cov_3.192308_g21354_i0	PRJNA1200128	21463	199	3.192308	6.35269292	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	274	3.3899999999999997e-69	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g21354	i0	91.5	52.7386934673367	200	16	100	1	1	199	2979013	2979212	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	10495	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
3595240	3595240	PRJNA1200128_S_NODE_34563_length_170_cov_2.133858_g34454_i0	PRJNA1200128	34563	170	2.133858	3.6275586	Mucilaginibacter	423349	Bacteria	Bacteria	281	1.67e-71	NTclustered	gi\|1804505538\|gb\|CP048115.1\|	2703789	g34454	i0	96.471	221.729411764706	170	6	100	0	1	170	722005	721836	Mucilaginibacter sp. 14171R-50 chromosome, complete genome	blastn	37694	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp. 14171R-50
4872807	4872807	PRJNA1200128_S_NODE_20504_length_202_cov_1.792453_g20395_i0	PRJNA1200128	20504	202	1.792453	3.62075506	Pedobacter	84567	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|1005371200\|gb\|CP014504.1\|	188932	g20395	i0	99.505	362.767326732673	202	1	100	0	1	202	19279	19078	Pedobacter cryoconitis strain PAMC 27485 chromosome, complete genome	blastn	73279	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter cryoconitis
6704867	6704867	PRJNA1200128_S_NODE_3386_length_366_cov_10.269350_g3277_i0	PRJNA1200128	3386	366	10.26935	37.585821	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g3277	i0	100	0.0819672131147541	30	0	8	0	279	308	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
9972793	9972793	PRJNA1200128_S_NODE_2328_length_431_cov_4.829897_g2220_i0	PRJNA1200128	2328	431	4.829897	20.81685607	Empedobacter	59734	Bacteria	Bacteria	750	0	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g2220	i0	98.144	507.08120649652	431	6	100	2	1	431	522151	522579	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	218552	756	0.992063492063492	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
9972804	9972804	PRJNA1200128_S_NODE_30688_length_177_cov_2.104478_g30579_i0	PRJNA1200128	30688	177	2.104478	3.72492606	root	1	Root_unresolved	Root_unresolved	327	2.2199999999999996e-85	NTclustered	gi\|523928634\|gb\|KF372433.1\|	28125	g30579	i0	100	105.983050847458	177	0	100	0	1	177	177	1	Prevotella bivia strain NF11586 16S ribosomal RNA gene, partial sequence	blastn	18759	327	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella bivia
11805593	11805593	PRJNA1200128_S_NODE_22230_length_197_cov_2.441558_g22121_i0	PRJNA1200128	22230	197	2.441558	4.80986926	Dysgonomonas sp. HDW5B	2714927	Bacteria	Bacteria	259	9.37e-65	NTclustered	gi\|1821111738\|gb\|CP049858.1\|	2714927	g22121	i0	98.63	372.421319796954	146	2	100	0	1	146	441659	441514	Dysgonomonas sp. HDW5B chromosome, complete genome	blastn	73367	259	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Dysgonomonas	Dysgonomonas sp. HDW5B
12523440	12523440	PRJNA1200128_S_NODE_44490_length_156_cov_1.247788_g44381_i0	PRJNA1200128	44490	156	1.247788	1.94654928	Flavobacterium	237	Bacteria	Bacteria	283	4.1899999999999994e-72	NTclustered	gi\|2447257787\|gb\|CP092822.1\|	1454066	g44381	i0	100	485.147435897436	153	0	98	0	4	156	1451139	1451291	Flavobacterium sp. WW92 chromosome, complete genome	blastn	75683	283	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WW92
14356015	14356015	PRJNA1200128_S_NODE_23152_length_195_cov_0.927632_g23043_i0	PRJNA1200128	23152	195	0.927632	1.8088824	Hymenobacter sp. 5317J-9	2932250	Bacteria	Bacteria	350	5.34e-92	NTclustered	gi\|2221939013\|gb\|CP095050.1\|	2932250	g23043	i0	98.974	99.6051282051282	195	2	100	0	1	195	1208429	1208623	Hymenobacter sp. 5317J-9 chromosome, complete genome	blastn	19423	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. 5317J-9
15072430	15072430	PRJNA1200128_S_NODE_7652_length_275_cov_2.103448_g7543_i0	PRJNA1200128	7652	275	2.103448	5.784482	Sphingobacterium	28453	Bacteria	Bacteria	390	4.72e-104	NTclustered	gi\|1772529904\|gb\|CP045652.1\|	2662364	g7543	i0	92.446	274.563636363636	278	14	100	7	1	275	899026	898753	Sphingobacterium zhuxiongii strain dk4302 chromosome, complete genome	blastn	75505	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium zhuxiongii
16347270	16347270	PRJNA1200128_S_NODE_6793_length_285_cov_9.305785_g6684_i0	PRJNA1200128	6793	285	9.305785	26.52148725	Flavobacteriales	200644	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|162280791\|gb\|EU293154.1\|	247	g6684	i0	100	105.635087719298	284	0	99	0	2	285	735	452	Empedobacter brevis strain Y7D 16S ribosomal RNA gene, partial sequence	blastn	30106	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter brevis
18178688	18178688	PRJNA1200128_S_NODE_23815_length_193_cov_1.253333_g23706_i0	PRJNA1200128	23815	193	1.253333	2.41893269	Segatella copri	165179	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|2299476153\|gb\|CP102288.1\|	537011	g23706	i0	100	12.9740932642487	193	0	100	0	1	193	1852684	1852492	Segatella copri DSM 18205 chromosome, complete genome	blastn	2504	357	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
18896274	18896274	PRJNA1200128_S_NODE_915_length_811_cov_3.916667_g851_i0	PRJNA1200128	915	811	3.916667	31.76416937	Empedobacter	59734	Bacteria	Bacteria	1415	0	NTclustered	gi\|1878091573\|gb\|CP040908.1\|	343874	g851	i0	98.387	491.484586929716	806	12	99	1	1	805	523626	522821	Empedobacter falsenii strain 1681-1 chromosome, complete genome	blastn	398594	1426	0.992286115007013	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter falsenii
19453060	19453060	PRJNA1200128_S_NODE_11456_length_242_cov_1.597990_g11347_i0	PRJNA1200128	11456	242	1.59799	3.8671358	uncultured Flavobacteriales bacterium	213322	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2308952793\|emb\|OX044365.1\|	213322	g11347	i0	100	0.115702479338843	28	0	12	0	177	204	2272858	2272885	MAG: uncultured Flavobacteriales bacterium isolate K_MB5 genome assembly, chromosome: K_MB5_contig-1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			uncultured Flavobacteriales bacterium
19453105	19453105	PRJNA1200128_S_NODE_22316_length_197_cov_1.525974_g22207_i0	PRJNA1200128	22316	197	1.525974	3.00616878	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	268	1.5599999999999998e-67	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g22207	i0	94.767	22.7208121827411	172	9	87	0	26	197	993927	994098	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	4476	268	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
20728396	20728396	PRJNA1200128_S_NODE_1057_length_693_cov_3.004615_g974_i0	PRJNA1200128	1057	693	3.004615	20.82198195	Niabella ginsenosidivorans	1176587	Bacteria	Bacteria	963	0	NTclustered	gi\|1033838715\|gb\|CP015772.1\|	1176587	g974	i0	92.825	244.096681096681	669	40	96	5	10	671	995085	994418	Niabella ginsenosidivorans strain BS26 chromosome, complete genome	blastn	169159	963	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella ginsenosidivorans
20728496	20728496	PRJNA1200128_S_NODE_31937_length_175_cov_1.424242_g31828_i0	PRJNA1200128	31937	175	1.424242	2.4924235	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g31828	i0	98.857	60.462857142857096	175	2	100	0	1	175	2828721	2828895	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	10581	313	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
20728521	20728521	PRJNA1200128_S_NODE_40177_length_161_cov_6.322034_g40068_i0	PRJNA1200128	40177	161	6.322034	10.17847474	Psychroserpens sp. NJDZ02	2570561	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1624181815\|gb\|CP039451.1\|	2570561	g40068	i0	96.774	0.192546583850932	31	1	19	0	102	132	1794929	1794899	Psychroserpens sp. NJDZ02 chromosome, complete genome	blastn	31	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Psychroserpens	Psychroserpens sp. NJDZ02
21446588	21446588	PRJNA1200128_S_NODE_15277_length_221_cov_1.320225_g15168_i0	PRJNA1200128	15277	221	1.320225	2.91769725	Hymenobacter	89966	Bacteria	Bacteria	252	1.8e-62	NTclustered	gi\|926465561\|gb\|CP012623.1\|	1385663	g15168	i0	87.727	215.628959276018	220	21	99	6	1	219	763422	763636	Hymenobacter sp. DG25A, complete genome	blastn	47654	252	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. DG25A
22003756	22003756	PRJNA1200128_S_NODE_20858_length_201_cov_1.784810_g20749_i0	PRJNA1200128	20858	201	1.78481	3.5874681	Chryseobacterium sp. JJR-5R	3093923	Bacteria	Bacteria	355	1.19e-93	NTclustered	gi\|2625464360\|gb\|CP139137.1\|	3093923	g20749	i0	98.507	344.517412935323	201	3	100	0	1	201	342468	342268	Chryseobacterium sp. JJR-5R chromosome, complete genome	blastn	69248	355	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. JJR-5R
22003771	22003771	PRJNA1200128_S_NODE_24878_length_190_cov_1.612245_g24769_i0	PRJNA1200128	24878	190	1.612245	3.0632655	Candidatus Pedobacter colombiensis	3121371	Bacteria	Bacteria	324	3.13e-84	NTclustered	gi\|2457514890\|gb\|CP119313.1\|	3121371	g24769	i0	98.37	321.826315789474	184	3	100	0	1	184	4308141	4308324	MAG: Candidatus Pedobacter colombiensis isolate MAG_3858 chromosome, complete genome	blastn	61147	324	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Candidatus Pedobacter colombiensis
23279135	23279135	PRJNA1200128_S_NODE_1379_length_577_cov_3.290262_g974_i1	PRJNA1200128	1379	577	3.290262	18.98481174	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	643	7.389999999999998e-180	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g974	i1	87.478	542.528596187175	567	60	97	10	10	570	2979035	2978474	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	313039	643	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
23279285	23279285	PRJNA1200128_S_NODE_8319_length_268_cov_1.462222_g8210_i0	PRJNA1200128	8319	268	1.462222	3.91875496	uncultured Flavobacteriales bacterium	213322	Bacteria	Bacteria	318	2.189999999999999e-82	NTclustered	gi\|2308952759\|emb\|OX044359.1\|	213322	g8210	i0	88.06	450.30223880597	268	32	100	0	1	268	217312	217579	MAG: uncultured Flavobacteriales bacterium isolate C_MB391 genome assembly, chromosome: C_MB391_contig-1	blastn	120681	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			uncultured Flavobacteriales 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);;