metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA638724" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA638724" 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
609555	609555	PRJNA638724_P_NODE_5881_length_264_cov_2.712042_g5795_i0	PRJNA638724	5881	264	2.712042	7.15979088	Spirosoma taeanense	2735870	Bacteria	Bacteria	254	6.16e-63	NTclustered	gi\|1843765704\|gb\|CP053435.1\|	2735870	g5795	i0	86.307	184.458333333333	241	24	90	9	28	264	5430770	5430535	Spirosoma taeanense strain TS118 chromosome, complete genome	blastn	48697	254	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma taeanense
609560	609560	PRJNA638724_P_NODE_7581_length_240_cov_2.191617_g7495_i0	PRJNA638724	7581	240	2.191617	5.2598808	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	409	1.11e-109	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g7495	i0	98.701	384.6375	231	2	96	1	1	230	787173	786943	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	92313	409	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
1155360	1155360	PRJNA638724_P_NODE_8221_length_220_cov_5.013605_g8135_i0	PRJNA638724	8221	220	5.013605	11.029931	Capnocytophaga	1016	Bacteria	Bacteria	383	6.08e-102	NTclustered	gi\|2797268018\|gb\|CP162011.1\|	327575	g8135	i0	99.526	585.086363636364	211	0	95	1	11	220	419385	419175	Capnocytophaga leadbetteri strain F0087 isolate D204 chromosome, complete genome	blastn	128719	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
1155361	1155361	PRJNA638724_P_NODE_921_length_579_cov_8.059289_g837_i0	PRJNA638724	921	579	8.059289	46.66328331	Weeksellaceae	2762318	Bacteria	Bacteria	996	0	NTclustered	gi\|2429074367\|gb\|CP115858.1\|	192389	g837	i0	98.243	407.312607944732	569	10	98	0	11	579	2628382	2627814	Chryseobacterium daecheongense strain PL22-22A chromosome, complete genome	blastn	235834	1000	0.996	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium daecheongense
1885770	1885770	PRJNA638724_P_NODE_6942_length_247_cov_1.770115_g6856_i0	PRJNA638724	6942	247	1.770115	4.37218405	Empedobacter stercoris	1628248	Bacteria	Bacteria	422	1.48e-113	NTclustered	gi\|2304450266\|gb\|CP104209.1\|	1628248	g6856	i0	98.734	496.882591093117	237	3	96	0	11	247	85279	85515	Empedobacter stercoris strain SCVM0123 chromosome, complete genome	blastn	122730	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Empedobacter	Empedobacter stercoris
4437305	4437305	PRJNA638724_P_NODE_4164_length_307_cov_1.752137_g4078_i0	PRJNA638724	4164	307	1.752137	5.37906059	Flavisolibacter tropicus	1492898	Bacteria	Bacteria	405	1.91e-108	NTclustered	gi\|1028466201\|gb\|CP011390.1\|	1492898	g4078	i0	91.333	272.387622149837	300	21	97	4	1	298	1744402	1744698	Flavisolibacter tropicus strain LCS9 chromosome, complete genome	blastn	83623	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter tropicus
6258972	6258972	PRJNA638724_P_NODE_3105_length_348_cov_3.607273_g3019_i0	PRJNA638724	3105	348	3.607273	12.55331004	Bacteroidota	976	Bacteria	Bacteria	320	8.18e-83	NTclustered	gi\|982202715\|gb\|CP013992.1\|	2906076	g3019	i0	88.636	251.968390804598	264	29	76	1	85	348	565698	565436	Flavobacterium covae strain 94-081 chromosome, complete genome	blastn	87685	320	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium covae
6258975	6258975	PRJNA638724_P_NODE_5925_length_263_cov_2.615789_g5839_i0	PRJNA638724	5925	263	2.615789	6.87952507	Fluviicola	332102	Bacteria	Bacteria	451	2.03e-122	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g5839	i0	98.814	247.330798479087	253	3	96	0	11	263	1215	1467	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	65048	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
6258976	6258976	PRJNA638724_P_NODE_6725_length_250_cov_0.870056_g6639_i0	PRJNA638724	6725	250	0.870056	2.17514	Cloacibacterium	501783	Bacteria	Bacteria	388	1.5199999999999998e-103	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g6639	i0	95.833	456.8	240	10	96	0	1	240	1872427	1872666	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	114200	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
6988112	6988112	PRJNA638724_P_NODE_8246_length_218_cov_6.172414_g8160_i0	PRJNA638724	8246	218	6.172414	13.45586252	Capnocytophaga sputigena	1019	Bacteria	Bacteria	379	7.779999999999999e-101	NTclustered	gi\|1242562181\|gb\|CP022385.1\|	1019	g8160	i0	99.519	375.532110091743	208	1	95	0	1	208	807776	807983	Capnocytophaga sputigena strain KC1668 chromosome, complete genome	blastn	81866	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
7533170	7533170	PRJNA638724_P_NODE_6846_length_248_cov_2.674286_g6760_i0	PRJNA638724	6846	248	2.674286	6.63222928	Flavobacterium	237	Bacteria	Bacteria	431	2.47e-116	NTclustered	gi\|2575681008\|gb\|CP133721.1\|	3073563	g6760	i0	99.163	493.612903225806	239	2	96	0	10	248	829516	829754	Flavobacterium nakdongensis strain 20NA77.7 chromosome, complete genome	blastn	122416	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium nakdongensis
8808263	8808263	PRJNA638724_P_NODE_8067_length_228_cov_2.845161_g7981_i0	PRJNA638724	8067	228	2.845161	6.48696708	Aquirufa	2676247	Bacteria	Bacteria	359	1.07e-94	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g7981	i0	96.33	384.464912280702	218	8	96	0	1	218	361046	360829	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	87658	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
8808264	8808264	PRJNA638724_P_NODE_8347_length_212_cov_4.007194_g8261_i0	PRJNA638724	8347	212	4.007194	8.49525128	Capnocytophaga	1016	Bacteria	Bacteria	374	3.5e-99	NTclustered	gi\|2093907539\|gb\|CP082870.1\|	1018	g8261	i0	100	293.650943396226	202	0	95	0	1	202	544149	543948	Capnocytophaga ochracea strain FDAARGOS_1468 chromosome, complete genome	blastn	62254	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga ochracea
9538131	9538131	PRJNA638724_P_NODE_5508_length_273_cov_1.490000_g5422_i0	PRJNA638724	5508	273	1.49	4.0677	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	479	9.699999999999996e-131	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g5422	i0	98.524	258.095238095238	271	4	99	0	1	271	4834264	4833994	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	70460	479	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
10813779	10813779	PRJNA638724_P_NODE_4089_length_309_cov_1.622881_g4003_i0	PRJNA638724	4089	309	1.622881	5.01470229	Capnocytophaga gingivalis	1017	Bacteria	Bacteria	547	3.0199999999999986e-151	NTclustered	gi\|1242564872\|gb\|CP022386.1\|	1017	g4003	i0	99.666	310.605177993527	299	1	97	0	11	309	1436559	1436261	Capnocytophaga gingivalis strain H1496 chromosome, complete genome	blastn	95977	547	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga gingivalis
12634368	12634368	PRJNA638724_P_NODE_2250_length_398_cov_2.627692_g2164_i0	PRJNA638724	2250	398	2.627692	10.45821416	Flavobacterium	237	Bacteria	Bacteria	601	3.0199999999999996e-167	NTclustered	gi\|1384925755\|gb\|CP020919.1\|	1678728	g2164	i0	94.643	441.909547738693	392	13	97	8	11	398	1294761	1295148	Flavobacterium kingsejongi strain WV39 chromosome, complete genome	blastn	175880	606	0.991749174917492	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium kingsejongi
12634370	12634370	PRJNA638724_P_NODE_4210_length_306_cov_1.257511_g4124_i0	PRJNA638724	4210	306	1.257511	3.84798366	Capnocytophaga	1016	Bacteria	Bacteria	460	4e-125	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g4124	i0	95.27	296.137254901961	296	5	97	6	1	296	1523932	1523646	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	90618	462	0.995670995670996	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
12634374	12634374	PRJNA638724_P_NODE_6830_length_248_cov_4.897143_g6744_i0	PRJNA638724	6830	248	4.897143	12.14491464	Capnocytophaga	1016	Bacteria	Bacteria	440	4.0999999999999997e-119	NTclustered	gi\|2797268018\|gb\|CP162011.1\|	327575	g6744	i0	100	137.217741935484	238	0	96	0	1	238	420285	420522	Capnocytophaga leadbetteri strain F0087 isolate D204 chromosome, complete genome	blastn	34030	440	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga leadbetteri
13363753	13363753	PRJNA638724_P_NODE_5371_length_276_cov_2.201970_g5285_i0	PRJNA638724	5371	276	2.20197	6.0774372	Flavobacterium psychrophilum	96345	Bacteria	Bacteria	403	6.08e-108	NTclustered	gi\|1057916935\|gb\|CP012388.1\|	96345	g5285	i0	94.007	630.56884057971	267	15	96	1	1	266	2973175	2972909	Flavobacterium psychrophilum strain Z1, complete genome	blastn	174037	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium psychrophilum
13363755	13363755	PRJNA638724_P_NODE_7351_length_243_cov_0.905882_g7265_i0	PRJNA638724	7351	243	0.905882	2.20129326	Capnocytophaga endodontalis	2708117	Bacteria	Bacteria	403	5.25e-108	NTclustered	gi\|1211193516\|gb\|CP022022.1\|	2708117	g7265	i0	97.854	7.35390946502058	233	5	96	0	1	233	3053388	3053620	Capnocytophaga endodontalis strain ChDC OS43 chromosome, complete genome	blastn	1787	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga endodontalis
13909280	13909280	PRJNA638724_P_NODE_6011_length_261_cov_7.739362_g5925_i0	PRJNA638724	6011	261	7.739362	20.19973482	Chryseobacterium	59732	Bacteria	Bacteria	477	3.3099999999999986e-130	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g5925	i0	100	537.034482758621	258	0	99	0	1	258	2942431	2942688	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	140166	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
15912459	15912459	PRJNA638724_P_NODE_1393_length_488_cov_2.759036_g1307_i0	PRJNA638724	1393	488	2.759036	13.46409568	Fulvivirga ulvae	2904245	Bacteria	Bacteria	545	1.7899999999999995e-150	NTclustered	gi\|2174454039\|gb\|CP089981.1\|	2904245	g1307	i0	89.013	269.883196721311	446	42	90	7	48	488	448117	447674	Fulvivirga ulvae strain SS9-22 chromosome, complete genome	blastn	131703	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga ulvae
15912467	15912467	PRJNA638724_P_NODE_5913_length_263_cov_4.557895_g5827_i0	PRJNA638724	5913	263	4.557895	11.98726385	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	396	9.629999999999996e-106	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g5827	i0	94.862	492.828897338403	253	13	96	0	1	253	217351	217099	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	129614	396	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
15912471	15912471	PRJNA638724_P_NODE_7253_length_244_cov_0.900585_g7167_i0	PRJNA638724	7253	244	0.900585	2.1974274	uncultured Prevotellamassilia sp.	1926676	Bacteria	Bacteria	309	1.1800000000000002e-79	NTclustered	gi\|1997760563\|emb\|LR994473.1\|	1926676	g7167	i0	90.598	376.991803278689	234	21	96	1	1	234	1235880	1236112	uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1	blastn	91986	309	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotellamassilia	uncultured Prevotellamassilia sp.
16458086	16458086	PRJNA638724_P_NODE_6973_length_247_cov_0.885057_g6887_i0	PRJNA638724	6973	247	0.885057	2.18609079	Capnocytophaga	1016	Bacteria	Bacteria	379	9.02e-101	NTclustered	gi\|1242562181\|gb\|CP022385.1\|	1019	g6887	i0	95.745	4.78947368421053	235	10	95	0	3	237	1489066	1488832	Capnocytophaga sputigena strain KC1668 chromosome, complete genome	blastn	1183	379	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga sputigena
19736327	19736327	PRJNA638724_P_NODE_7236_length_244_cov_0.900585_g7150_i0	PRJNA638724	7236	244	0.900585	2.1974274	Flavobacterium limnophilum	3003262	Bacteria	Bacteria	200	7.4299999999999985e-47	NTclustered	gi\|2477668611\|gb\|CP114289.2\|	3003262	g7150	i0	82.449	3.90163934426229	245	28	96	9	1	234	1956070	1956310	Flavobacterium limnophilum strain IMCC36791 chromosome, complete genome	blastn	952	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium limnophilum
22286670	22286670	PRJNA638724_P_NODE_2378_length_389_cov_3.734177_g2292_i0	PRJNA638724	2378	389	3.734177	14.52594853	Chryseobacterium sp.	1871047	Bacteria	Bacteria	702	0	NTclustered	gi\|2664258514\|gb\|PP230830.1\|	1871047	g2292	i0	100	101.974293059126	380	0	98	0	1	380	492	113	Chryseobacterium sp. strain LYH-49 16S ribosomal RNA gene, partial sequence	blastn	39668	702	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp.
22286675	22286675	PRJNA638724_P_NODE_6818_length_249_cov_0.875000_g6732_i0	PRJNA638724	6818	249	0.875	2.17875	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	388	1.51e-103	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g6732	i0	96.203	3.78714859437751	237	9	95	0	1	237	1573885	1574121	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	943	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
22286676	22286676	PRJNA638724_P_NODE_7058_length_246_cov_0.890173_g6972_i0	PRJNA638724	7058	246	0.890173	2.18982558	Capnocytophaga endodontalis	2708117	Bacteria	Bacteria	436	5.25e-118	NTclustered	gi\|1211193516\|gb\|CP022022.1\|	2708117	g6972	i0	100	4.84552845528455	236	0	96	0	1	236	1064741	1064976	Capnocytophaga endodontalis strain ChDC OS43 chromosome, complete genome	blastn	1192	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga endodontalis
24835899	24835899	PRJNA638724_P_NODE_3940_length_314_cov_4.585062_g3854_i0	PRJNA638724	3940	314	4.585062	14.39709468	Tellurirhabdus rosea	2674997	Bacteria	Bacteria	281	3.44e-71	NTclustered	gi\|2336996033\|gb\|CP111085.1\|	2674997	g3854	i0	93.194	213.770700636943	191	13	61	0	1	191	2795419	2795229	Tellurirhabdus rosea strain U15T chromosome, complete genome	blastn	67124	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus rosea
24835902	24835902	PRJNA638724_P_NODE_5900_length_264_cov_0.984293_g5814_i0	PRJNA638724	5900	264	0.984293	2.59853352	Segatella copri	165179	Bacteria	Bacteria	464	2.6099999999999998e-126	NTclustered	gi\|2733781693\|gb\|CP152350.1\|	165179	g5814	i0	99.606	251.181818181818	254	1	96	0	11	264	2802913	2802660	Segatella copri strain HDA03 chromosome, complete genome	blastn	66312	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
25381694	25381694	PRJNA638724_P_NODE_3500_length_331_cov_2.019380_g3414_i0	PRJNA638724	3500	331	2.01938	6.6841478	Flectobacillus	101	Bacteria	Bacteria	588	1.92e-163	NTclustered	gi\|124013490\|gb\|EF028104.1\|	420522	g3414	i0	99.689	97.2870090634441	322	0	97	1	1	322	455	135	Flectobacillus sp. 18P 16S ribosomal RNA gene, partial sequence	blastn	32202	588	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp. 18P

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