metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA1136957" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA1136957" 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
284617	284617	PRJNA1136957_S_NODE_5561_length_340_cov_5.604982_g5464_i0	PRJNA1136957	5561	340	5.604982	19.0569388	Flavobacterium dauae	1563479	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2557430891\|gb\|CP130821.1\|	1563479	g5464	i0	100	0.0882352941176471	30	0	9	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
1559213	1559213	PRJNA1136957_S_NODE_6442_length_323_cov_0.924242_g6345_i0	PRJNA1136957	6442	323	0.924242	2.98530166	Bacteroidetes bacterium AG-339-O17	2162548	Bacteria	Bacteria	250	1e-61	NTclustered	gi\|1391921692\|gb\|MH327378.1\|	2162548	g6345	i0	80.685	1.38390092879257	321	62	99	0	1	321	2165	2485	Bacteroidetes bacterium AG-339-O17 Ga0171680_109 genomic sequence	blastn	447	250	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium AG-339-O17
4111645	4111645	PRJNA1136957_S_NODE_5404_length_344_cov_3.666667_g5307_i0	PRJNA1136957	5404	344	3.666667	12.61333448	Candidatus Pseudobacter hemicellulosilyticus	3121375	Bacteria	Bacteria	121	8.789999999999999e-23	NTclustered	gi\|2457544586\|gb\|CP119311.1\|	3121375	g5307	i0	76.772	0.738372093023256	254	35	74	16	71	323	1631724	1631954	MAG: Candidatus Pseudobacter hemicellulosilyticus isolate MAG_7 chromosome, complete genome	blastn	254	121	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Pseudobacter	Candidatus Pseudobacter hemicellulosilyticus
6662413	6662413	PRJNA1136957_S_NODE_15706_length_220_cov_0.950311_g15609_i0	PRJNA1136957	15706	220	0.950311	2.0906842	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	189	1.42e-43	NTclustered	gi\|2874254166\|emb\|OY970398.1\|	866510	g15609	i0	84.456	1.81818181818182	193	28	87	2	1	192	3428865	3429056	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.c.2 genome assembly, chromosome: 1	blastn	400	189	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
6662461	6662461	PRJNA1136957_S_NODE_4326_length_373_cov_2.761146_g4229_i0	PRJNA1136957	4326	373	2.761146	10.29907458	Kaistella carnis	1241979	Bacteria	Bacteria	684	0	NTclustered	gi\|1527184997\|gb\|CP034159.1\|	1241979	g4229	i0	99.732	454.817694369973	373	1	100	0	1	373	1510960	1510588	Kaistella carnis strain G0081 chromosome, complete genome	blastn	169647	684	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella carnis
6662479	6662479	PRJNA1136957_S_NODE_8646_length_287_cov_1.070175_g8549_i0	PRJNA1136957	8646	287	1.070175	3.07140225	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	207	5.35e-49	NTclustered	gi\|2874253850\|emb\|OY969906.1\|	866510	g8549	i0	85.294	12.6968641114983	204	26	70	4	18	219	4834233	4834434	MAG: uncultured Chitinophagaceae bacterium isolate MFD05502.bin.c.1 genome assembly, chromosome: 1	blastn	3644	207	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
7409935	7409935	PRJNA1136957_S_NODE_18986_length_200_cov_1.297872_g18889_i0	PRJNA1136957	18986	200	1.297872	2.595744	root	1	Root_unresolved	Root_unresolved	54.7	0.005	NTclustered	gi\|1421732866\|gb\|CP030261.1\|	2249356	g18889	i0	94.286	1.33	35	2	18	0	80	114	4477775	4477741	Flavobacterium fluviale strain HYN0086 chromosome, complete genome	blastn	266	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium fluviale
9212576	9212576	PRJNA1136957_S_NODE_15528_length_221_cov_0.901235_g15431_i0	PRJNA1136957	15528	221	0.901235	1.99172935	Filimonas lacunae	477680	Bacteria	Bacteria	361	2.8699999999999998e-95	NTclustered	gi\|1031978622\|dbj\|AP017422.1\|	477680	g15431	i0	96.347	195.647058823529	219	8	99	0	1	219	310949	310731	Filimonas lacunae DNA, complete genome, strain: NBRC 104114	blastn	43238	361	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Filimonas	Filimonas lacunae
9212596	9212596	PRJNA1136957_S_NODE_19788_length_197_cov_1.297101_g19691_i0	PRJNA1136957	19788	197	1.297101	2.55528897	Flavihumibacter rivuli	2838156	Bacteria	Bacteria	337	4.21e-88	NTclustered	gi\|2198890466\|gb\|CP092334.1\|	2838156	g19691	i0	97.462	221.213197969543	197	5	100	0	1	197	90453	90257	Flavihumibacter rivuli strain IMCC34838 chromosome, complete genome	blastn	43579	337	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavihumibacter	Flavihumibacter rivuli
10488104	10488104	PRJNA1136957_S_NODE_12569_length_243_cov_0.994565_g12472_i0	PRJNA1136957	12569	243	0.994565	2.41679295	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	248	2.6e-61	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g12472	i0	88.095	4.00411522633745	210	23	86	2	1	209	312825	313033	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	973	248	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
10488116	10488116	PRJNA1136957_S_NODE_14549_length_227_cov_1.452381_g14452_i0	PRJNA1136957	14549	227	1.452381	3.29690487	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	291	3.94e-74	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g14452	i0	90.783	0.955947136563877	217	20	96	0	1	217	1536891	1536675	Lacibacter sp. MH-610 chromosome	blastn	217	291	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
11235369	11235369	PRJNA1136957_S_NODE_889_length_593_cov_2.599251_g810_i0	PRJNA1136957	889	593	2.599251	15.41355843	Kaistella	2782231	Bacteria	Bacteria	1094	0	NTclustered	gi\|1540230489\|emb\|LR134503.1\|	266749	g810	i0	100	467.399662731872	592	0	99	0	2	593	1440961	1441552	Chryseobacterium jeonii strain NCTC13459 genome assembly, chromosome: 1	blastn	277168	1094	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella jeonii
11763228	11763228	PRJNA1136957_S_NODE_20070_length_196_cov_1.072993_g19973_i0	PRJNA1136957	20070	196	1.072993	2.10306628	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	163	7.510000000000001e-36	NTclustered	gi\|2874253891\|emb\|OY970066.1\|	866510	g19973	i0	83.721	2.65816326530612	172	28	88	0	6	177	41480	41309	MAG: uncultured Chitinophagaceae bacterium isolate MFD02581.bin.c.1 genome assembly, chromosome: 1	blastn	521	163	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
11763271	11763271	PRJNA1136957_S_NODE_9650_length_274_cov_1.079070_g9553_i0	PRJNA1136957	9650	274	1.07907	2.9566518	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	457	4.5599999999999985e-124	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g9553	i0	96.715	3.0036496350365	274	9	100	0	1	274	2955438	2955165	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	823	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
11763272	11763272	PRJNA1136957_S_NODE_9790_length_272_cov_1.145540_g9693_i0	PRJNA1136957	9790	272	1.14554	3.1158688	Rhizosphaericola mali	2545455	Bacteria	Bacteria	126	1.45e-24	NTclustered	gi\|1755140936\|gb\|CP044016.1\|	2545455	g9693	i0	95	1.77941176470588	80	4	29	0	3	82	55870	55949	Rhizosphaericola mali strain B3-10 chromosome, complete genome	blastn	484	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Rhizosphaericola	Rhizosphaericola mali
13038262	13038262	PRJNA1136957_S_NODE_10811_length_260_cov_1.517413_g10714_i0	PRJNA1136957	10811	260	1.517413	3.9452738	Filimonas lacunae	477680	Bacteria	Bacteria	204	6.179999999999999e-48	NTclustered	gi\|1031978622\|dbj\|AP017422.1\|	477680	g10714	i0	85.279	2.81153846153846	197	29	76	0	62	258	2937984	2938180	Filimonas lacunae DNA, complete genome, strain: NBRC 104114	blastn	731	204	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Filimonas	Filimonas lacunae
13038283	13038283	PRJNA1136957_S_NODE_14411_length_228_cov_1.396450_g14314_i0	PRJNA1136957	14411	228	1.39645	3.183906	Lacibacter sp. MH-610	3020883	Bacteria	Bacteria	265	2.4e-66	NTclustered	gi\|2865359271\|gb\|CP116002.1\|	3020883	g14314	i0	88.889	0.947368421052632	216	23	94	1	14	228	1538618	1538403	Lacibacter sp. MH-610 chromosome	blastn	216	265	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
13038299	13038299	PRJNA1136957_S_NODE_18391_length_203_cov_1.270833_g18294_i0	PRJNA1136957	18391	203	1.270833	2.57979099	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	148	2.19e-31	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g18294	i0	79.902	1.1576354679803	204	39	100	2	1	203	1386973	1387175	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	235	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
14313496	14313496	PRJNA1136957_S_NODE_12932_length_240_cov_1.011050_g12835_i0	PRJNA1136957	12932	240	1.01105	2.42652	Niabella soli	446683	Bacteria	Bacteria	182	2.64e-41	NTclustered	gi\|570743502\|gb\|CP007035.1\|	929713	g12835	i0	81.057	4.3125	227	43	95	0	1	227	642761	642987	Niabella soli DSM 19437, complete genome	blastn	1035	182	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niabella	Niabella soli
14313515	14313515	PRJNA1136957_S_NODE_17352_length_209_cov_1.500000_g17255_i0	PRJNA1136957	17352	209	1.5	3.135	Panacibacter ginsenosidivorans	1813871	Bacteria	Bacteria	171	4.849999999999999e-38	NTclustered	gi\|1721657344\|gb\|CP042435.1\|	1813871	g17255	i0	81.643	8.11961722488038	207	37	99	1	3	209	3579211	3579006	Panacibacter ginsenosidivorans strain Gsoil1550 chromosome, complete genome	blastn	1697	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Panacibacter	Panacibacter ginsenosidivorans
15587484	15587484	PRJNA1136957_S_NODE_20253_length_195_cov_1.794118_g20156_i0	PRJNA1136957	20253	195	1.794118	3.4985301	Bacteroidetes bacterium AG-339-O17	2162548	Bacteria	Bacteria	200	5.69e-47	NTclustered	gi\|1391921692\|gb\|MH327378.1\|	2162548	g20156	i0	85.714	1.66666666666667	189	27	97	0	3	191	384	572	Bacteroidetes bacterium AG-339-O17 Ga0171680_109 genomic sequence	blastn	325	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium AG-339-O17
16861732	16861732	PRJNA1136957_S_NODE_7754_length_300_cov_1.012448_g7657_i0	PRJNA1136957	7754	300	1.012448	3.037344	Kaistella carnis	1241979	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|1527184997\|gb\|CP034159.1\|	1241979	g7657	i0	100	8.24	300	0	100	0	1	300	392324	392025	Kaistella carnis strain G0081 chromosome, complete genome	blastn	2472	555	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella carnis
18136283	18136283	PRJNA1136957_S_NODE_15655_length_220_cov_1.515528_g15558_i0	PRJNA1136957	15655	220	1.515528	3.3341616	uncultured Chitinophagaceae bacterium	866510	Bacteria	Bacteria	152	1.87e-32	NTclustered	gi\|2874254166\|emb\|OY970398.1\|	866510	g15558	i0	79.358	2.92272727272727	218	44	99	1	3	220	1877634	1877850	MAG: uncultured Chitinophagaceae bacterium isolate MFD02832.bin.c.2 genome assembly, chromosome: 1	blastn	643	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		uncultured Chitinophagaceae bacterium
18136291	18136291	PRJNA1136957_S_NODE_16515_length_214_cov_2.477419_g16418_i0	PRJNA1136957	16515	214	2.477419	5.30167666	uncultured Ferruginibacter sp.	1042239	Bacteria	Bacteria	113	8.530000000000001e-21	NTclustered	gi\|2575820297\|emb\|OY730416.1\|	1042239	g16418	i0	79.747	0.738317757009346	158	31	73	1	56	212	4726073	4726230	MAG: uncultured Ferruginibacter sp. isolate 52100660-89e0-41f3-aa4d-b5ad2bee9e90 genome assembly, chromosome: 1	blastn	158	113	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	uncultured Ferruginibacter sp.
19410463	19410463	PRJNA1136957_S_NODE_10836_length_260_cov_0.945274_g10739_i0	PRJNA1136957	10836	260	0.945274	2.4577124	Ferruginibacter lapsinanis	563172	Bacteria	Bacteria	178	3.749999999999999e-40	NTclustered	gi\|2129682579\|gb\|CP086063.1\|	563172	g10739	i0	79.297	1.44615384615385	256	51	98	2	3	257	1142790	1143044	Ferruginibacter lapsinanis strain KACC 15035 chromosome, complete genome	blastn	376	178	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter lapsinanis
21961362	21961362	PRJNA1136957_S_NODE_19278_length_199_cov_1.307143_g19181_i0	PRJNA1136957	19278	199	1.307143	2.60121457	Elizabethkingia miricola	172045	Bacteria	Bacteria	368	1.51e-97	NTclustered	gi\|2638023975\|gb\|CP140570.1\|	172045	g19181	i0	100	11	199	0	100	0	1	199	3933086	3932888	Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome	blastn	2189	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
21961387	21961387	PRJNA1136957_S_NODE_6118_length_329_cov_1.251852_g6021_i0	PRJNA1136957	6118	329	1.251852	4.11859308	Arachidicoccus sp. BS20	1850526	Bacteria	Bacteria	246	1.32e-60	NTclustered	gi\|1035428363\|gb\|CP015971.1\|	1850526	g6021	i0	80.805	16.6413373860182	323	54	97	8	9	327	1705545	1705227	Arachidicoccus sp. BS20 chromosome, complete genome	blastn	5475	246	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Arachidicoccus	Arachidicoccus sp. BS20
23236886	23236886	PRJNA1136957_S_NODE_19559_length_198_cov_0.877698_g19462_i0	PRJNA1136957	19559	198	0.877698	1.73784204	Filimonas lacunae	477680	Bacteria	Bacteria	159	9.83e-35	NTclustered	gi\|1031978622\|dbj\|AP017422.1\|	477680	g19462	i0	82.955	1.78787878787879	176	30	89	0	1	176	6446717	6446892	Filimonas lacunae DNA, complete genome, strain: NBRC 104114	blastn	354	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Filimonas	Filimonas lacunae
23236926	23236926	PRJNA1136957_S_NODE_8559_length_288_cov_1.550218_g8462_i0	PRJNA1136957	8559	288	1.550218	4.46462784	Bacteroidetes bacterium AG-339-O17	2162548	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|1391921684\|gb\|MH327370.1\|	2162548	g8462	i0	100	1	288	0	100	0	1	288	8835	8548	Bacteroidetes bacterium AG-339-O17 Ga0171680_101 genomic sequence	blastn	288	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium AG-339-O17

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