metadata: contig_metadata: 59 rows where analysis = "blastn", bioproject = "PRJNA454154" and tax

59 rows where analysis = "blastn", bioproject = "PRJNA454154" and tax_superkingdom = "Bacteria"

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
1093461	1093461	PRJNA454154_S_NODE_261_length_205_cov_14.416667_g258_i0	PRJNA454154	261	205	14.416667	29.55416735	Aeromonas	642	Bacteria	Bacteria	327	2.66e-85	NTclustered	gi\|2489122631\|gb\|CP121837.1\|	654	g258	i0	100	87.2146341463415	177	0	86	0	6	182	1187663	1187487	Aeromonas veronii strain ANYA 18263 chromosome, complete genome	blastn	17879	327	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
1093463	1093463	PRJNA454154_S_NODE_501_length_168_cov_1.625954_g498_i0	PRJNA454154	501	168	1.625954	2.73160272	Bacteria	2	Bacteria	Bacteria	82.4	1.8e-11	NTclustered	gi\|1173527474\|gb\|CP015402.2\|	1796646	g498	i0	94.34	52.9404761904762	53	3	32	0	11	63	2294310	2294362	Muribaculum intestinale strain YL27 chromosome, complete genome	blastn	8894	82.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Muribaculum	Muribaculum intestinale
1716820	1716820	PRJNA454154_S_NODE_222_length_216_cov_9.458101_g219_i0	PRJNA454154	222	216	9.458101	20.42949816	Cytophagales bacterium Alg240-R148	2305985	Bacteria	Bacteria	141	3.95e-29	NTclustered	gi\|1805798710\|emb\|LS999827.1\|	2305985	g219	i0	90.09	150.462962962963	111	7	50	4	1	109	454	562	Cytophagales bacterium Alg240-R148 genome assembly, chromosome: II	blastn	32500	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales			Cytophagales bacterium Alg240-R148
1716823	1716823	PRJNA454154_S_NODE_542_length_164_cov_2.251969_g539_i0	PRJNA454154	542	164	2.251969	3.69322916	uncultured bacterium	77133	Bacteria	Bacteria	135	1.32e-27	NTclustered	gi\|291260408\|gb\|GU925510.1\|	77133	g539	i0	89.72	37.219512195122	107	9	65	2	58	163	110	5	Uncultured bacterium clone F5K2Q4C04J3V7E 23S ribosomal RNA gene, partial sequence	blastn	6104	135	1	Bacteria								uncultured bacterium
2368828	2368828	PRJNA454154_S_NODE_102_length_282_cov_11.457143_g99_i0	PRJNA454154	102	282	11.457143	32.30914326	Herbaspirillum	963	Bacteria	Bacteria	473	4.679999999999999e-129	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g99	i0	98.162	367.021276595745	272	4	96	1	11	282	521724	521994	Herbaspirillum seropedicae strain Z69 chromosome	blastn	103500	473	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
2992592	2992592	PRJNA454154_S_NODE_163_length_242_cov_4.068293_g160_i0	PRJNA454154	163	242	4.068293	9.84526906	Tahibacter sp. UC22_41	3350178	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|2814027031\|gb\|CP170554.1\|	3350178	g160	i0	97.674	208.925619834711	215	5	89	0	25	239	830924	830710	Tahibacter sp. UC22_41 chromosome, complete genome	blastn	50560	370	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Tahibacter	Tahibacter sp. UC22_41
3644451	3644451	PRJNA454154_S_NODE_443_length_177_cov_1.600000_g440_i0	PRJNA454154	443	177	1.6	2.832	Herbaspirillum	963	Bacteria	Bacteria	305	1.04e-78	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g440	i0	98.276	214.28813559322	174	3	100	0	4	177	523493	523320	Herbaspirillum seropedicae strain Z69 chromosome	blastn	37929	305	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
3644452	3644452	PRJNA454154_S_NODE_463_length_173_cov_6.691176_g460_i0	PRJNA454154	463	173	6.691176	11.57573448	Paraclostridium	1849822	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2091226359\|gb\|CP079737.1\|	1490	g460	i0	100	916.219653179191	173	0	100	0	1	173	12670	12498	Paraclostridium bifermentans strain DSM 14991 chromosome, complete genome	blastn	158506	320	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
4268999	4268999	PRJNA454154_S_NODE_424_length_179_cov_1.028169_g421_i0	PRJNA454154	424	179	1.0281690000000001	1.84042251	Streptococcus sanguinis	1305	Bacteria	Bacteria	320	3.76e-83	NTclustered	gi\|1539215237\|emb\|LR134002.1\|	1305	g421	i0	98.889	336.424581005587	180	1	100	1	1	179	430556	430377	Streptococcus sanguinis strain NCTC10904 genome assembly, chromosome: 1	blastn	60220	320	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
6196470	6196470	PRJNA454154_S_NODE_145_length_253_cov_9.199074_g142_i0	PRJNA454154	145	253	9.199074	23.27365722	Pseudomonadaceae	135621	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2323131394\|gb\|CP109657.1\|	287	g142	i0	100	386.00395256917	253	0	100	0	1	253	716228	716480	Pseudomonas aeruginosa strain Zw26 chromosome, complete genome	blastn	97659	468	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
6196473	6196473	PRJNA454154_S_NODE_525_length_165_cov_4.039062_g522_i0	PRJNA454154	525	165	4.039062	6.6644523	Acidovorax	12916	Bacteria	Bacteria	289	9.66e-74	NTclustered	gi\|2842886548\|gb\|CP171997.1\|	47920	g522	i0	98.182	337	165	3	100	0	1	165	2999	3163	Acidovorax delafieldii strain UC81_30 chromosome, complete genome	blastn	55605	289	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax delafieldii
6819642	6819642	PRJNA454154_S_NODE_166_length_240_cov_32.763547_g163_i0	PRJNA454154	166	240	32.763547	78.6325128	Solilutibacter oculi	2698682	Bacteria	Bacteria	350	6.839999999999999e-92	NTclustered	gi\|1419369001\|gb\|CP029556.1\|	2698682	g163	i0	95.434	164.825	219	10	91	0	1	219	9182	9400	Solilutibacter oculi strain 83-4, complete genome	blastn	39558	350	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Solilutibacter	Solilutibacter oculi
6819646	6819646	PRJNA454154_S_NODE_566_length_160_cov_2.772358_g563_i0	PRJNA454154	566	160	2.772358	4.4357728	Paraclostridium sordellii	1505	Bacteria	Bacteria	202	1.2499999999999998e-47	NTclustered	gi\|2695206951\|gb\|CP124285.1\|	1505	g563	i0	91.333	598.19375	150	10	93	3	4	151	3001361	3001509	Paraclostridium sordellii strain C128 chromosome, complete genome	blastn	95711	202	1	Bacteria		Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium sordellii
7471389	7471389	PRJNA454154_S_NODE_386_length_184_cov_2.829932_g383_i0	PRJNA454154	386	184	2.829932	5.20707488	Clostridia	186801	Bacteria	Bacteria	86.1	1.55e-12	NTclustered	gi\|1899225395\|gb\|MT967859.1\|	59620	g383	i0	93.22	4.78260869565217	59	3	32	1	22	80	1903	1960	Uncultured Clostridium sp. clone asv_358_2372 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	880	86.1	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
8746423	8746423	PRJNA454154_S_NODE_187_length_234_cov_4.583756_g184_i0	PRJNA454154	187	234	4.583756	10.72598904	Hymenobacter	89966	Bacteria	Bacteria	340	3.989999999999999e-89	NTclustered	gi\|586953861\|gb\|CP007145.1\|	1227739	g184	i0	96.154	271.611111111111	208	8	90	0	5	212	504308	504515	Hymenobacter swuensis DY53, complete genome	blastn	63557	340	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter swuensis
8746424	8746424	PRJNA454154_S_NODE_87_length_293_cov_49.511719_g84_i0	PRJNA454154	87	293	49.511719	145.06933667	Herbaspirillum	963	Bacteria	Bacteria	514	2.88e-141	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g84	i0	98.299	460.552901023891	294	4	100	1	1	293	524439	524146	Herbaspirillum seropedicae strain Z69 chromosome	blastn	134942	514	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
9369793	9369793	PRJNA454154_S_NODE_288_length_198_cov_7.509317_g285_i0	PRJNA454154	288	198	7.509317	14.86844766	Lacibacter sediminis	2760713	Bacteria	Bacteria	351	1.51e-92	NTclustered	gi\|1888315716\|gb\|CP060007.1\|	2760713	g285	i0	98.98	161.373737373737	196	2	99	0	3	198	867360	867555	Lacibacter sediminis strain S13-6-22 chromosome, complete genome	blastn	31952	351	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sediminis
9369794	9369794	PRJNA454154_S_NODE_28_length_408_cov_50.690027_g25_i0	PRJNA454154	28	408	50.690027	206.81531016	Rheinheimera sp. MM224	3019969	Bacteria	Bacteria	588	2.4099999999999998e-163	NTclustered	gi\|2321869226\|emb\|OX352320.1\|	3019969	g25	i0	92.701	932.291666666667	411	24	100	6	1	408	39946	39539	Rheinheimera sp. isolate Rheinheimera MM224 assembly genome assembly, chromosome: MM224	blastn	380375	588	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. MM224
10021651	10021651	PRJNA454154_S_NODE_208_length_223_cov_2.344086_g205_i0	PRJNA454154	208	223	2.344086	5.22731178	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	263	8.4e-66	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g205	i0	89.1	45.1793721973094	211	23	95	0	13	223	211	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	10075	263	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10021653	10021653	PRJNA454154_S_NODE_588_length_158_cov_4.991736_g585_i0	PRJNA454154	588	158	4.991736	7.88694288	Limnobacter	131079	Bacteria	Bacteria	283	4.2499999999999995e-72	NTclustered	gi\|2155992114\|gb\|OL639006.1\|	77133	g585	i0	98.742	195.120253164557	159	1	100	1	1	158	2339	2497	Uncultured bacterium clone Microplastics_LRC_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30829	283	1	Bacteria								uncultured bacterium
10645824	10645824	PRJNA454154_S_NODE_29_length_407_cov_51.040541_g26_i0	PRJNA454154	29	407	51.040541	207.73500187	Rheinheimera sp. MM224	3019969	Bacteria	Bacteria	536	8.849999999999999e-148	NTclustered	gi\|2321869226\|emb\|OX352320.1\|	3019969	g26	i0	90.511	935.447174447174	411	32	100	7	1	407	39946	39539	Rheinheimera sp. isolate Rheinheimera MM224 assembly genome assembly, chromosome: MM224	blastn	380727	536	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. MM224
11296583	11296583	PRJNA454154_S_NODE_649_length_153_cov_1.206897_g646_i0	PRJNA454154	649	153	1.206897	1.84655241	Ralstonia	48736	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|532578729\|gb\|KC188318.1\|	305	g646	i0	99.346	212.065359477124	153	1	100	0	1	153	1382	1534	Ralstonia solanacearum strain CFBP 3059 23S ribosomal RNA gene, partial sequence	blastn	32446	278	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
11296584	11296584	PRJNA454154_S_NODE_69_length_318_cov_15.733096_g66_i0	PRJNA454154	69	318	15.733096	50.03124528	Flavobacterium	237	Bacteria	Bacteria	545	1.1199999999999999e-150	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g66	i0	99.013	658.160377358491	304	3	96	0	1	304	473316	473619	Flavobacterium columnare strain B185, complete genome	blastn	209295	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
11920749	11920749	PRJNA454154_S_NODE_450_length_176_cov_1.575540_g447_i0	PRJNA454154	450	176	1.57554	2.7729504	Plesiomonas shigelloides	703	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|1913912090\|gb\|CP062197.1\|	703	g447	i0	99.432	681.897727272727	176	1	100	0	1	176	143304	143129	Plesiomonas shigelloides strain P5462 plasmid p1, complete sequence	blastn	120014	320	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
12572284	12572284	PRJNA454154_S_NODE_430_length_178_cov_3.624113_g427_i0	PRJNA454154	430	178	3.624113	6.45092114	Herbaspirillum	963	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|289583762\|gb\|GU451202.1\|	77133	g427	i0	100	126.752808988764	175	0	98	0	4	178	1	175	Uncultured bacterium clone 4A1H8M9 16S ribosomal RNA gene, partial sequence	blastn	22562	326	0.993865030674847	Bacteria								uncultured bacterium
13195562	13195562	PRJNA454154_S_NODE_371_length_187_cov_7.646667_g368_i0	PRJNA454154	371	187	7.646667	14.29926729	uncultured bacterium	77133	Bacteria	Bacteria	95.3	2.62e-15	NTclustered	gi\|2259477641\|emb\|OW886493.1\|	77133	g368	i0	95	29.9679144385027	60	3	32	0	108	167	325	266	uncultured bacterium DNA containing 16S-23S intergenic spacer region, clone 43	blastn	5604	95.3	1	Bacteria								uncultured bacterium
13195565	13195565	PRJNA454154_S_NODE_51_length_357_cov_13.212500_g48_i0	PRJNA454154	51	357	13.2125	47.168625	Turicibacter sp. TJ11	2806443	Bacteria	Bacteria	394	4.87e-105	NTclustered	gi\|2179881633\|gb\|CP069349.1\|	2806443	g48	i0	88.854	473.719887955182	323	33	90	3	35	356	3906	3586	Turicibacter sp. TJ11 chromosome, complete genome	blastn	169118	394	1	Bacteria		Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sp. TJ11
13847006	13847006	PRJNA454154_S_NODE_591_length_158_cov_2.371901_g588_i0	PRJNA454154	591	158	2.371901	3.74760358	root	1	Root_unresolved	Root_unresolved	132	1.63e-26	NTclustered	gi\|161344282\|gb\|EU284318.1\|	77133	g588	i0	84.028	99.3544303797468	144	16	87	3	7	143	216	359	Uncultured bacterium clone BRA047 16S ribosomal RNA gene, partial sequence	blastn	15698	132	1	Bacteria								uncultured bacterium
14470609	14470609	PRJNA454154_S_NODE_152_length_249_cov_11.292453_g149_i0	PRJNA454154	152	249	11.292453	28.11820797	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	185	2.1299999999999994e-42	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g149	i0	81.385	360.477911646586	231	39	92	4	19	248	373699	373472	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	89759	185	1	Bacteria		Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
14470611	14470611	PRJNA454154_S_NODE_212_length_221_cov_1.891304_g209_i0	PRJNA454154	212	221	1.891304	4.17978184	Caenispirillum salinarum	859058	Bacteria	Bacteria	137	5.26e-28	NTclustered	gi\|2851215952\|gb\|CP085224.1\|	859058	g209	i0	79.167	21	216	31	93	9	1	206	3567396	3567185	Caenispirillum salinarum strain ADH2-936 chromosome, complete genome	blastn	4641	137	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Novispirillaceae	Caenispirillum	Caenispirillum salinarum
14470613	14470613	PRJNA454154_S_NODE_472_length_172_cov_3.288889_g469_i0	PRJNA454154	472	172	3.288889	5.65688908	uncultured bacterium	77133	Bacteria	Bacteria	307	2.79e-79	NTclustered	gi\|169640659\|gb\|EU491403.1\|	77133	g469	i0	99.408	97.7906976744186	169	1	98	0	3	171	435	267	Uncultured bacterium clone P0X4b3A09 16S ribosomal RNA gene, partial sequence	blastn	16820	307	1	Bacteria								uncultured bacterium
15121250	15121250	PRJNA454154_S_NODE_172_length_238_cov_18.427861_g169_i0	PRJNA454154	172	238	18.427861	43.85830918	root	1	Root_unresolved	Root_unresolved	429	8.45e-116	NTclustered	gi\|2060186473\|gb\|MZ471075.1\|	72226	g169	i0	100	97.4789915966387	232	0	97	0	7	238	730	499	Lysobacter sp. strain 2042 16S ribosomal RNA gene, partial sequence	blastn	23200	429	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Lysobacter	Lysobacter sp.
15744563	15744563	PRJNA454154_S_NODE_173_length_238_cov_8.313433_g170_i0	PRJNA454154	173	238	8.313433	19.78597054	Rheinheimera sp. F8	1763998	Bacteria	Bacteria	398	2.3799999999999995e-106	NTclustered	gi\|975021511\|gb\|CP013656.1\|	1763998	g170	i0	97.425	661.529411764706	233	6	98	0	2	234	416191	415959	Rheinheimera sp. F8 genome	blastn	157444	398	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. F8
16396026	16396026	PRJNA454154_S_NODE_433_length_178_cov_2.397163_g430_i0	PRJNA454154	433	178	2.397163	4.26695014	root	1	Root_unresolved	Root_unresolved	327	2.23e-85	NTclustered	gi\|2842886548\|gb\|CP171997.1\|	47920	g430	i0	100	264.707865168539	177	0	99	0	2	178	2969	2793	Acidovorax delafieldii strain UC81_30 chromosome, complete genome	blastn	47118	327	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax delafieldii
17019258	17019258	PRJNA454154_S_NODE_194_length_232_cov_2.646154_g191_i0	PRJNA454154	194	232	2.646154	6.13907728	Staphylococcus epidermidis	1282	Bacteria	Bacteria	377	3.01e-100	NTclustered	gi\|2505679996\|gb\|CP118820.1\|	1282	g191	i0	97.297	509.461206896552	222	6	96	0	1	222	2419972	2419751	Staphylococcus epidermidis strain 7057 chromosome, complete genome	blastn	118195	377	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17671053	17671053	PRJNA454154_S_NODE_474_length_172_cov_2.392593_g471_i0	PRJNA454154	474	172	2.392593	4.11525996	Shewanella	22	Bacteria	Bacteria	278	2.19e-70	NTclustered	gi\|1215225522\|gb\|CP022358.1\|	2018305	g471	i0	95.906	47.0232558139535	171	7	99	0	1	171	1551735	1551905	Shewanella bicestrii strain JAB-1, complete genome	blastn	8088	278	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella bicestrii
17671055	17671055	PRJNA454154_S_NODE_94_length_289_cov_4.309524_g91_i0	PRJNA454154	94	289	4.309524	12.45452436	Flavobacterium	237	Bacteria	Bacteria	444	3.78e-120	NTclustered	gi\|1003115209\|gb\|CP010992.1\|	996	g91	i0	94.444	643.647058823529	288	16	99	0	1	288	472841	472554	Flavobacterium columnare strain B185, complete genome	blastn	186014	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium columnare
18293618	18293618	PRJNA454154_S_NODE_215_length_219_cov_76.554945_g212_i0	PRJNA454154	215	219	76.554945	167.65532955	Flavobacterium sediminis	2201181	Bacteria	Bacteria	366	6.09e-97	NTclustered	gi\|1391188358\|gb\|CP029463.1\|	2201181	g212	i0	99.02	640.127853881278	204	2	93	0	2	205	2900089	2900292	Flavobacterium sediminis strain MEBiC07310 chromosome, complete genome	blastn	140188	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminis
18293619	18293619	PRJNA454154_S_NODE_235_length_213_cov_1.840909_g232_i0	PRJNA454154	235	213	1.840909	3.92113617	uncultured bacterium	77133	Bacteria	Bacteria	324	3.6e-84	NTclustered	gi\|53854766\|gb\|AY705477.1\|	77133	g232	i0	94.712	333.765258215962	208	11	98	0	2	209	663	870	Uncultured bacterium isolate ALT4 23S ribosomal RNA gene, partial sequence	blastn	71092	324	1	Bacteria								uncultured bacterium
18293621	18293621	PRJNA454154_S_NODE_295_length_197_cov_8.900000_g292_i0	PRJNA454154	295	197	8.9	17.533	Paenibacillus elgii	189691	Bacteria	Bacteria	75	3.64e-9	NTclustered	gi\|2482133391\|gb\|CP121215.1\|	189691	g292	i0	79.487	24.8274111675127	117	14	57	9	3	115	191589	191699	Paenibacillus elgii strain L146 chromosome, complete genome	blastn	4891	75	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus elgii
18293623	18293623	PRJNA454154_S_NODE_95_length_289_cov_3.928571_g92_i0	PRJNA454154	95	289	3.928571	11.35357019	Fulvivirga lutea	2810512	Bacteria	Bacteria	158	5.51e-34	NTclustered	gi\|1995470682\|gb\|CP070608.1\|	2810512	g92	i0	78.092	40.8650519031142	283	38	93	19	4	273	479519	479248	Fulvivirga lutea strain S481 chromosome, complete genome	blastn	11810	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Fulvivirga	Fulvivirga lutea
18944921	18944921	PRJNA454154_S_NODE_495_length_169_cov_2.780303_g492_i0	PRJNA454154	495	169	2.780303	4.69871207	Lysobacter	68	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|951704250\|gb\|CP011129.1\|	84531	g492	i0	97.041	233.497041420118	169	3	99	2	3	169	4801822	4801654	Lysobacter antibioticus strain 76, complete genome	blastn	39461	283	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Lysobacter	Lysobacter antibioticus
20219662	20219662	PRJNA454154_S_NODE_236_length_212_cov_26.068571_g233_i0	PRJNA454154	236	212	26.068571	55.26537052	root	1	Root_unresolved	Root_unresolved	392	9.67e-105	NTclustered	gi\|390532906\|gb\|JQ736182.1\|	77133	g233	i0	100	101.009433962264	212	0	100	0	1	212	372	161	Uncultured bacterium clone GCTh53 16S ribosomal RNA gene, partial sequence	blastn	21414	392	1	Bacteria								uncultured bacterium
20219664	20219664	PRJNA454154_S_NODE_536_length_164_cov_3.480315_g533_i0	PRJNA454154	536	164	3.480315	5.7077166	Flavobacterium	237	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|21832090\|dbj\|AB078045.1\|	994	g533	i0	100	170.993902439024	164	0	100	0	1	164	160	323	Flavobacterium johnsoniae subsp. aurantiacum gene for 16S rRNA, strain:IFO 16024	blastn	28043	303	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
20843640	20843640	PRJNA454154_S_NODE_177_length_237_cov_12.265000_g174_i0	PRJNA454154	177	237	12.265	29.06805	uncultured bacterium	77133	Bacteria	Bacteria	431	2.3399999999999995e-116	NTclustered	gi\|300800490\|emb\|FN863845.1\|	77133	g174	i0	99.578	63.3206751054852	237	0	100	1	1	237	582	347	Uncultured bacterium partial 16S rRNA gene, clone B234806A03	blastn	15007	431	1	Bacteria								uncultured bacterium
20843644	20843644	PRJNA454154_S_NODE_317_length_193_cov_5.865385_g314_i0	PRJNA454154	317	193	5.865385	11.32019305	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	267	5.4599999999999996e-67	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g314	i0	91.667	649.336787564767	192	16	99	0	2	193	1333368	1333177	Flavobacterium sp. N1719 chromosome, complete genome	blastn	125322	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
21495254	21495254	PRJNA454154_S_NODE_137_length_256_cov_11.963470_g134_i0	PRJNA454154	137	256	11.96347	30.6264832	Shewanella	22	Bacteria	Bacteria	409	1.2e-109	NTclustered	gi\|2024816785\|gb\|CP031775.3\|	256839	g134	i0	98.696	678.4453125	230	3	90	0	2	231	4703287	4703058	Shewanella decolorationis strain Ni1-3 chromosome, complete genome	blastn	173682	409	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella decolorationis
21495255	21495255	PRJNA454154_S_NODE_257_length_206_cov_7.976331_g254_i0	PRJNA454154	257	206	7.976331	16.43124186	Bacteroidota	976	Bacteria	Bacteria	202	1.6899999999999999e-47	NTclustered	gi\|1352177909\|gb\|CP027062.1\|	2094025	g254	i0	84.878	350.203883495146	205	25	99	6	2	204	2227700	2227900	Pukyongia salina strain RR4-38 chromosome, complete genome	blastn	72142	204	0.990196078431373	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pukyongia	Pukyongia salina
21495257	21495257	PRJNA454154_S_NODE_497_length_169_cov_2.219697_g494_i0	PRJNA454154	497	169	2.219697	3.75128793	Acinetobacter	469	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1797096465\|gb\|CP041970.1\|	70348	g494	i0	100	606.775147928994	169	0	100	0	1	169	2382738	2382570	Acinetobacter dispersus strain NCCP 16014 chromosome, complete genome	blastn	102545	313	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter dispersus
22118464	22118464	PRJNA454154_S_NODE_378_length_185_cov_2.695946_g375_i0	PRJNA454154	378	185	2.695946	4.9875001	uncultured bacterium	77133	Bacteria	Bacteria	329	6.52e-86	NTclustered	gi\|309953808\|gb\|HM779023.1\|	77133	g375	i0	100	132.632432432432	178	0	96	0	8	185	1111	1288	Uncultured bacterium clone JFR0502_aaa09e06 16S ribosomal RNA gene, partial sequence	blastn	24537	329	1	Bacteria								uncultured bacterium
22118465	22118465	PRJNA454154_S_NODE_38_length_379_cov_47.365497_g35_i0	PRJNA454154	38	379	47.365497	179.51523363	Aeromonas veronii	654	Bacteria	Bacteria	551	2.919999999999999e-152	NTclustered	gi\|2259758343\|gb\|CP072325.1\|	654	g35	i0	92.932	891.585751978892	382	22	100	4	1	379	4485811	4486190	Aeromonas veronii strain 183026 chromosome, complete genome	blastn	337911	551	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
22770390	22770390	PRJNA454154_S_NODE_498_length_169_cov_1.939394_g495_i0	PRJNA454154	498	169	1.939394	3.27757586	Enterobacteriaceae	543	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g495	i0	99.408	664.100591715976	169	1	100	0	1	169	186373	186541	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	112233	307	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23394151	23394151	PRJNA454154_S_NODE_19_length_450_cov_11.326877_g16_i0	PRJNA454154	19	450	11.326877	50.9709465	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	726	0	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g16	i0	95.973	561.606666666667	447	18	99	0	1	447	1334339	1333893	Flavobacterium sp. N1719 chromosome, complete genome	blastn	252723	726	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
23394155	23394155	PRJNA454154_S_NODE_619_length_155_cov_1.050847_g616_i0	PRJNA454154	619	155	1.050847	1.62881285	Runella rosea	2259595	Bacteria	Bacteria	156	9.44e-34	NTclustered	gi\|1430388288\|gb\|CP030850.1\|	2259595	g616	i0	87.407	59.8	135	17	87	0	1	135	4137684	4137550	Runella rosea strain HYN0085 chromosome, complete genome	blastn	9269	156	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella rosea
24045308	24045308	PRJNA454154_S_NODE_119_length_267_cov_7.595652_g116_i0	PRJNA454154	119	267	7.595652	20.28039084	Aeromonas	642	Bacteria	Bacteria	470	5.689999999999999e-128	NTclustered	gi\|2214134399\|gb\|CP094267.1\|	644	g116	i0	98.496	833.951310861423	266	4	99	0	2	267	87876	88141	Aeromonas hydrophila strain A008N2 chromosome, complete genome	blastn	222665	470	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
24668134	24668134	PRJNA454154_S_NODE_220_length_218_cov_6.397790_g217_i0	PRJNA454154	220	218	6.39779	13.9471822	uncultured bacterium	77133	Bacteria	Bacteria	346	7.89e-91	NTclustered	gi\|291260851\|gb\|GU925953.1\|	77133	g217	i0	97.073	100.522935779817	205	6	94	0	14	218	361	157	Uncultured bacterium clone F5K2Q4C04JCGXH 23S ribosomal RNA gene, partial sequence	blastn	21914	346	1	Bacteria								uncultured bacterium
24668135	24668135	PRJNA454154_S_NODE_260_length_205_cov_17.898810_g257_i0	PRJNA454154	260	205	17.89881	36.6925605	Plesiomonas shigelloides	703	Bacteria	Bacteria	377	2.6e-100	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g257	i0	100	774.234146341463	204	0	99	0	1	204	334432	334229	Plesiomonas shigelloides strain Colony13 chromosome	blastn	158718	377	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
25319656	25319656	PRJNA454154_S_NODE_100_length_283_cov_3.930894_g97_i0	PRJNA454154	100	283	3.930894	11.12443002	Aeromonas	642	Bacteria	Bacteria	433	7.98e-117	NTclustered	gi\|1841685728\|gb\|CP038443.1\|	651	g97	i0	94.138	855.381625441696	290	8	99	3	3	283	2108487	2108776	Aeromonas media strain R1-18 chromosome, complete genome	blastn	242073	433	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas media
25319659	25319659	PRJNA454154_S_NODE_360_length_189_cov_2.769737_g357_i0	PRJNA454154	360	189	2.769737	5.23480293	Thermomonas	141948	Bacteria	Bacteria	298	1.89e-76	NTclustered	gi\|1898499561\|gb\|CP060711.1\|	215691	g357	i0	95.699	215.222222222222	186	6	98	2	5	189	2220032	2220216	Thermomonas brevis strain KACC 16975 chromosome, complete genome	blastn	40677	298	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Thermomonas	Thermomonas brevis

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