metadata: contig_metadata: 55 rows where analysis = "blastn", bioproject = "PRJNA287283" and tax

55 rows where analysis = "blastn", bioproject = "PRJNA287283" and tax_phylum = "Pseudomonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
372204	372204	PRJNA287283_P_NODE_10121_length_176_cov_0.910569_g9897_i0	PRJNA287283	10121	176	0.910569	1.60260144	Hyphomicrobium sp. ghe19	2682968	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|1800674788\|emb\|LR743509.1\|	2682968	g9897	i0	99.432	195.522727272727	176	1	100	0	1	176	1751259	1751434	Hyphomicrobium sp. ghe19 isolate hypp genome assembly, chromosome: 1	blastn	34412	320	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Hyphomicrobiaceae	Hyphomicrobium	Hyphomicrobium sp. ghe19
372216	372216	PRJNA287283_P_NODE_9261_length_180_cov_0.874016_g9037_i0	PRJNA287283	9261	180	0.874016	1.5732288	Sphingomonas psychrotolerans	1327635	Bacteria	Bacteria	113	6.910000000000001e-21	NTclustered	gi\|1280029430\|gb\|CP024923.1\|	1327635	g9037	i0	87.879	2.78333333333333	99	8	54	4	3	99	2716874	2716970	Sphingomonas psychrotolerans strain Cra20 chromosome, complete genome	blastn	501	113	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas psychrotolerans
1059231	1059231	PRJNA287283_P_NODE_7381_length_200_cov_2.285714_g7157_i0	PRJNA287283	7381	200	2.285714	4.571428	Enterobacteriaceae	543	Bacteria	Bacteria	364	1.96e-96	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g7157	i0	99.5	100	200	1	100	0	1	200	33757	33558	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	20000	364	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
1646952	1646952	PRJNA287283_P_NODE_7902_length_190_cov_2.364964_g7678_i0	PRJNA287283	7902	190	2.364964	4.4934316	Sphaerotilus sulfidivorans	639200	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|1735504366\|gb\|CP035708.1\|	639200	g7678	i0	100	376.705263157895	190	0	100	0	1	190	3972487	3972676	Sphaerotilus sulfidivorans strain D-507 chromosome, complete genome	blastn	71574	351	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Sphaerotilus	Sphaerotilus sulfidivorans
2334433	2334433	PRJNA287283_P_NODE_3562_length_337_cov_1.644366_g3338_i0	PRJNA287283	3562	337	1.644366	5.54151342	Pasteurellaceae	712	Bacteria	Bacteria	298	3.7e-76	NTclustered	gi\|1438629556\|gb\|CP031240.1\|	726	g3338	i0	100	449.896142433234	161	0	82	0	177	337	113628	113788	Haemophilus haemolyticus strain M19345 chromosome, complete genome	blastn	151615	298	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus haemolyticus
2334434	2334434	PRJNA287283_P_NODE_4842_length_276_cov_4.713004_g4618_i0	PRJNA287283	4842	276	4.713004	13.00789104	Acidovorax	12916	Bacteria	Bacteria	505	1.62e-138	NTclustered	gi\|1004607049\|gb\|KT865757.1\|	12917	g4618	i0	99.638	300.282608695652	276	1	100	0	1	276	439	164	Acidovorax facilis strain DSM 649 23S ribosomal RNA gene, partial sequence	blastn	82878	510	0.990196078431373	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax facilis
2334436	2334436	PRJNA287283_P_NODE_7622_length_195_cov_2.161972_g7398_i0	PRJNA287283	7622	195	2.161972	4.2158454	Lysobacteraceae	32033	Bacteria	Bacteria	339	1.15e-88	NTclustered	gi\|2020029385\|dbj\|AP024546.1\|	2675059	g7398	i0	97.949	192	195	4	100	0	1	195	1475004	1474810	Lysobacter helvus D10 DNA, complete genome	blastn	37440	339	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Lysobacter	Lysobacter helvus
2334439	2334439	PRJNA287283_P_NODE_9902_length_177_cov_0.903226_g9678_i0	PRJNA287283	9902	177	0.903226	1.59871002	Escherichia	561	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g9678	i0	100	100	177	0	100	0	1	177	3896894	3896718	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	17700	327	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
2922848	2922848	PRJNA287283_P_NODE_10463_length_175_cov_0.918033_g10239_i0	PRJNA287283	10463	175	0.918033	1.60655775	Acinetobacter johnsonii	40214	Bacteria	Bacteria	226	8.209999999999999e-55	NTclustered	gi\|2179571758\|gb\|CP045051.1\|	40214	g10239	i0	100	18.2914285714286	122	0	70	0	1	122	1538559	1538438	Acinetobacter johnsonii strain AJ312 chromosome, complete genome	blastn	3201	226	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
3609725	3609725	PRJNA287283_P_NODE_3323_length_350_cov_11.488215_g3099_i0	PRJNA287283	3323	350	11.488215	40.2087525	Enterobacteriaceae	543	Bacteria	Bacteria	647	0	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g3099	i0	100	100.088571428571	350	0	100	0	1	350	985053	984704	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	35031	647	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3609726	3609726	PRJNA287283_P_NODE_4483_length_293_cov_1.987500_g4259_i0	PRJNA287283	4483	293	1.9875	5.823375	Enterobacteriaceae	543	Bacteria	Bacteria	542	1.32e-149	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g4259	i0	100	100	293	0	100	0	1	293	1517921	1518213	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	29300	542	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3609727	3609727	PRJNA287283_P_NODE_4963_length_271_cov_1.532110_g4739_i0	PRJNA287283	4963	271	1.53211	4.1520181	Neisseria	482	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|1633799129\|gb\|CP039886.1\|	484	g4739	i0	100	351.0036900369	271	0	100	0	1	271	126772	127042	Neisseria flavescens strain ATCC 13120 chromosome, complete genome	blastn	95122	501	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria flavescens
4887134	4887134	PRJNA287283_P_NODE_10044_length_176_cov_1.585366_g9820_i0	PRJNA287283	10044	176	1.585366	2.79024416	Enterobacteriaceae	543	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g9820	i0	100	100	176	0	100	0	1	176	809735	809910	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	17600	326	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4887137	4887137	PRJNA287283_P_NODE_7584_length_196_cov_1.538462_g7360_i0	PRJNA287283	7584	196	1.538462	3.01538552	Methylotenera	359407	Bacteria	Bacteria	355	1.15e-93	NTclustered	gi\|507148291\|ref\|NR_103094.1\|	359408	g7360	i0	99.487	123.418367346939	195	1	99	0	1	195	2083	2277	Methylotenera mobilis strain JLW8 23S ribosomal RNA gene, complete sequence	blastn	24190	355	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylotenera	Methylotenera mobilis
4887139	4887139	PRJNA287283_P_NODE_8764_length_182_cov_0.868217_g8540_i0	PRJNA287283	8764	182	0.868217	1.58015494	Enterobacteriaceae	543	Bacteria	Bacteria	84.2	5.49e-12	NTclustered	gi\|1243045118\|gb\|MF589339.1\|	562	g8540	i0	97.917	64.7967032967033	48	1	26	0	133	180	61886	61933	Escherichia coli strain 2271 plasmid pCTXM-2271, complete sequence	blastn	11793	84.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
5475615	5475615	PRJNA287283_P_NODE_9925_length_177_cov_0.903226_g9701_i0	PRJNA287283	9925	177	0.903226	1.59871002	Dyella sp. BiH032	3075430	Bacteria	Bacteria	126	8.69e-25	NTclustered	gi\|2581889107\|gb\|CP134867.1\|	3075430	g9701	i0	82.432	8.26553672316384	148	22	82	4	24	169	2272070	2272215	Dyella sp. BiH032 chromosome, complete genome	blastn	1463	126	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Dyella	Dyella sp. BiH032
6161988	6161988	PRJNA287283_P_NODE_9105_length_180_cov_1.015748_g8881_i0	PRJNA287283	9105	180	1.015748	1.8283464	Rheinheimera	67575	Bacteria	Bacteria	311	2.28e-80	NTclustered	gi\|975021511\|gb\|CP013656.1\|	1763998	g8881	i0	97.778	793.344444444444	180	4	100	0	1	180	417948	417769	Rheinheimera sp. F8 genome	blastn	142802	311	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. F8
6749881	6749881	PRJNA287283_P_NODE_2526_length_412_cov_2.640669_g2302_i0	PRJNA287283	2526	412	2.640669	10.87955628	Comamonas sp. GB3 AK4-5	3231487	Bacteria	Bacteria	640	6.64e-179	NTclustered	gi\|2788732997\|gb\|CP166730.1\|	3231487	g2302	i0	94.699	535.199029126214	415	16	100	6	1	412	600211	600622	Comamonas sp. GB3 AK4-5 chromosome, complete genome	blastn	220502	640	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas sp. GB3 AK4-5
6749887	6749887	PRJNA287283_P_NODE_7266_length_203_cov_1.120000_g7042_i0	PRJNA287283	7266	203	1.12	2.2736	Brachymonas wangyanguii	3130163	Bacteria	Bacteria	309	9.51e-80	NTclustered	gi\|2858558014\|gb\|CP173677.1\|	3130163	g7042	i0	94.118	185.285714285714	204	10	100	2	1	203	395245	395447	Brachymonas sp. G13 chromosome, complete genome	blastn	37613	309	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Brachymonas	Brachymonas wangyanguii
8711876	8711876	PRJNA287283_P_NODE_7367_length_201_cov_0.763514_g7143_i0	PRJNA287283	7367	201	0.763514	1.53466314	Paracoccus	265	Bacteria	Bacteria	313	7.2599999999999985e-81	NTclustered	gi\|1317217976\|gb\|CP025430.1\|	1077935	g7143	i0	96.316	158.562189054726	190	7	95	0	12	201	3023679	3023868	Paracoccus zhejiangensis strain J6 chromosome, complete genome	blastn	31871	315	0.993650793650794	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus zhejiangensis
9987317	9987317	PRJNA287283_P_NODE_7248_length_203_cov_1.433333_g7024_i0	PRJNA287283	7248	203	1.433333	2.90966599	Neisseriaceae	481	Bacteria	Bacteria	370	4.3e-98	NTclustered	gi\|1633799129\|gb\|CP039886.1\|	484	g7024	i0	99.507	369.019704433498	203	1	100	0	1	203	126192	125990	Neisseria flavescens strain ATCC 13120 chromosome, complete genome	blastn	74911	370	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria flavescens
9987318	9987318	PRJNA287283_P_NODE_9648_length_178_cov_0.896000_g9424_i0	PRJNA287283	9648	178	0.896	1.59488	Escherichia	561	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g9424	i0	99.438	100	178	1	100	0	1	178	497147	497324	Escherichia coli strain Case 2 chromosome, complete genome	blastn	17800	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
10576122	10576122	PRJNA287283_P_NODE_2269_length_439_cov_0.909326_g2046_i0	PRJNA287283	2269	439	0.909326	3.9919411400000002	Luteimonas sp. JM171	1896164	Bacteria	Bacteria	634	3.3099999999999995e-177	NTclustered	gi\|1060916168\|gb\|CP017074.1\|	1896164	g2046	i0	92.711	233.289293849658	439	32	100	0	1	439	1598672	1599110	Luteimonas sp. JM171 genome	blastn	102414	634	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Luteimonas	Luteimonas sp. JM171
11262372	11262372	PRJNA287283_P_NODE_3909_length_320_cov_1.722846_g3685_i0	PRJNA287283	3909	320	1.722846	5.5131072	Ralstonia	48736	Bacteria	Bacteria	553	6.749999999999998e-153	NTclustered	gi\|2828818\|gb\|AF012421.1\|AF012421	329	g3685	i0	97.812	210.9375	320	7	100	0	1	320	1152	833	Ralstonia pickettii strain PD1515 23S ribosomal RNA gene, partial sequence	blastn	67500	553	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia pickettii
11850839	11850839	PRJNA287283_P_NODE_9930_length_177_cov_0.903226_g9706_i0	PRJNA287283	9930	177	0.903226	1.59871002	Cupriavidus neocaledonicus	1040979	Bacteria	Bacteria	191	3.04e-44	NTclustered	gi\|1442883352\|emb\|LT984807.1\|	1040979	g9706	i0	87.73	75.2598870056497	163	20	92	0	1	163	381964	381802	Cupriavidus neocaledonicus isolate Cupriavidus taiwanensis STM 6160 genome assembly, plasmid: II	blastn	13321	191	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus	Cupriavidus neocaledonicus
12537696	12537696	PRJNA287283_P_NODE_5470_length_252_cov_1.211055_g5246_i0	PRJNA287283	5470	252	1.211055	3.0518586	Gammaproteobacteria	1236	Bacteria	Bacteria	449	6.94e-122	NTclustered	gi\|2699374251\|gb\|CP147487.1\|	550	g5246	i0	98.81	329.079365079365	252	3	100	0	1	252	5415138	5414887	Enterobacter cloacae strain FACU chromosome	blastn	82928	449	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter cloacae
13126018	13126018	PRJNA287283_P_NODE_1271_length_631_cov_2.956747_g1062_i0	PRJNA287283	1271	631	2.956747	18.65707357	Massilia sp. WG5	1707785	Bacteria	Bacteria	545	2.36e-150	NTclustered	gi\|1384998881\|gb\|CP012640.2\|	1707785	g1062	i0	99.664	434.535657686212	298	1	92	0	1	298	4181081	4180784	Massilia sp. WG5, complete sequence	blastn	274192	545	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. WG5
13812572	13812572	PRJNA287283_P_NODE_4631_length_286_cov_1.721030_g4407_i0	PRJNA287283	4631	286	1.72103	4.9221458	Vibrio	662	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1830435238\|gb\|CP051109.1\|	663	g4407	i0	100	682.090909090909	286	0	100	0	1	286	1422744	1423029	Vibrio alginolyticus strain 2015AW-0011 chromosome 1	blastn	195078	529	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio alginolyticus
14401177	14401177	PRJNA287283_P_NODE_9612_length_178_cov_0.896000_g9388_i0	PRJNA287283	9612	178	0.896	1.59488	Sphingomonas hankookensis	563996	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|2441333361\|gb\|CP117025.1\|	563996	g9388	i0	99.438	3.8876404494382	178	1	100	0	1	178	2175734	2175911	Sphingomonas hankookensis strain SZ.B2R2 chromosome, complete genome	blastn	692	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas hankookensis
15674914	15674914	PRJNA287283_P_NODE_6473_length_223_cov_0.900000_g6249_i0	PRJNA287283	6473	223	0.9	2.007	Thalassococcus sp. S3	2017482	Bacteria	Bacteria	305	1.38e-78	NTclustered	gi\|1577031754\|gb\|CP022303.1\|	2017482	g6249	i0	92.523	182.77130044843	214	14	96	2	1	213	4268540	4268752	Thalassococcus sp. S3 chromosome, complete genome	blastn	40758	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Thalassococcus	Thalassococcus sp. S3
16361655	16361655	PRJNA287283_P_NODE_3413_length_345_cov_2.205479_g3189_i0	PRJNA287283	3413	345	2.205479	7.60890255	Aeromonas	642	Bacteria	Bacteria	62.1	5.42e-5	NTclustered	gi\|2830880323\|gb\|CP170761.1\|	196024	g3189	i0	97.222	0.388405797101449	36	1	12	0	194	229	1308365	1308400	Aeromonas dhakensis strain CWH5 chromosome, complete genome	blastn	134	62.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas dhakensis
16949582	16949582	PRJNA287283_P_NODE_9954_length_177_cov_0.903226_g9730_i0	PRJNA287283	9954	177	0.903226	1.59871002	Agrilutibacter terrestris	2865112	Bacteria	Bacteria	183	5.0799999999999996e-42	NTclustered	gi\|1899444021\|gb\|CP060820.1\|	2865112	g9730	i0	85.393	10.090395480226	178	24	100	2	1	177	1792351	1792527	Agrilutibacter terrestris strain II4 chromosome, complete genome	blastn	1786	183	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Agrilutibacter	Agrilutibacter terrestris
17636809	17636809	PRJNA287283_P_NODE_4114_length_309_cov_2.195312_g3890_i0	PRJNA287283	4114	309	2.195312	6.78351408	root	1	Root_unresolved	Root_unresolved	78.7	4.76e-10	NTclustered	gi\|1315519809\|gb\|MF918372.1\|	573	g3890	i0	100	38.1294498381877	42	0	14	0	268	309	79032	78991	Klebsiella pneumoniae plasmid p1512-KPC, complete sequence	blastn	11782	78.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
17636814	17636814	PRJNA287283_P_NODE_9414_length_179_cov_0.888889_g9190_i0	PRJNA287283	9414	179	0.888889	1.59111131	Comamonadaceae	80864	Bacteria	Bacteria	171	4.01e-38	NTclustered	gi\|2288988666\|gb\|CP102931.1\|	34073	g9190	i0	84.393	5.49720670391061	173	27	97	0	7	179	5276248	5276420	Variovorax paradoxus strain JBCE486 chromosome, complete genome	blastn	984	171	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
18223841	18223841	PRJNA287283_P_NODE_4555_length_289_cov_4.932203_g4331_i0	PRJNA287283	4555	289	4.932203	14.25406667	Pseudomonas protegens	380021	Bacteria	Bacteria	453	6.28e-123	NTclustered	gi\|1149544984\|gb\|CP013184.1\|	380021	g4331	i0	94.613	559.681660899654	297	8	100	4	1	289	126828	127124	Pseudomonas protegens strain H78, complete genome	blastn	161748	453	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas protegens
18910616	18910616	PRJNA287283_P_NODE_10415_length_175_cov_0.918033_g10191_i0	PRJNA287283	10415	175	0.918033	1.60655775	Pseudomonadota	1224	Bacteria	Bacteria	278	2.23e-70	NTclustered	gi\|2788821993\|gb\|CP166817.1\|	287	g10191	i0	95.402	104.411428571429	174	8	99	0	1	174	1317149	1316976	Pseudomonas aeruginosa strain M7242404 chromosome, complete genome	blastn	18272	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
18910619	18910619	PRJNA287283_P_NODE_6135_length_232_cov_2.709497_g5911_i0	PRJNA287283	6135	232	2.709497	6.28603304	Acinetobacter	469	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|1723902757\|gb\|CP028800.2\|	40215	g5911	i0	100	601.862068965517	232	0	100	0	1	232	23718	23949	Acinetobacter junii strain WCHAJ59 chromosome, complete genome	blastn	139632	429	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter junii
19498110	19498110	PRJNA287283_P_NODE_3256_length_354_cov_2.335548_g3032_i0	PRJNA287283	3256	354	2.335548	8.26783992	Methylophilus sp. DW102	3095607	Bacteria	Bacteria	654	0	NTclustered	gi\|2631712142\|dbj\|AP029023.1\|	3095607	g3032	i0	100	225.251412429379	354	0	100	0	1	354	175167	174814	Methylophilus sp. DW102 DNA, complete genome	blastn	79739	654	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylophilus	Methylophilus sp. DW102
20185230	20185230	PRJNA287283_P_NODE_2956_length_375_cov_1.850932_g2732_i0	PRJNA287283	2956	375	1.850932	6.940995	Psychrobacter	497	Bacteria	Bacteria	676	0	NTclustered	gi\|1092191903\|gb\|CP012969.1\|	1720344	g2732	i0	99.2	357.968	375	3	100	0	1	375	2108435	2108809	Psychrobacter sp. AntiMn-1 chromosome, complete genome	blastn	134238	682	0.991202346041056	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter	Psychrobacter sp. AntiMn-1
21460933	21460933	PRJNA287283_P_NODE_2337_length_431_cov_12.354497_g2114_i0	PRJNA287283	2337	431	12.354497	53.24788207	Comamonadaceae	80864	Bacteria	Bacteria	793	0	NTclustered	gi\|2700484197\|gb\|CP147774.1\|	80878	g2114	i0	100	317.287703016241	429	0	99	0	3	431	2503758	2503330	Acidovorax temperans strain AA22 chromosome	blastn	136751	793	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax temperans
21460936	21460936	PRJNA287283_P_NODE_3977_length_317_cov_0.806818_g3753_i0	PRJNA287283	3977	317	0.806818	2.55761306	Methylophilus	16	Bacteria	Bacteria	569	6.629999999999998e-158	NTclustered	gi\|1525772245\|gb\|CP033953.1\|	17	g3753	i0	99.054	111.296529968454	317	3	100	0	1	317	2984310	2983994	Methylophilus methylotrophus strain D22 chromosome	blastn	35281	569	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylophilus	Methylophilus methylotrophus
21460941	21460941	PRJNA287283_P_NODE_8017_length_188_cov_3.081481_g7793_i0	PRJNA287283	8017	188	3.081481	5.79318428	Pseudomonas	286	Bacteria	Bacteria	346	6.6e-91	NTclustered	gi\|1403366562\|emb\|LS483372.1\|	294	g7793	i0	100	567.398936170213	187	0	99	0	1	187	9844	10030	Pseudomonas fluorescens strain NCTC10038 genome assembly, chromosome: 1	blastn	106671	348	0.994252873563218	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
21460943	21460943	PRJNA287283_P_NODE_9597_length_178_cov_0.896000_g9373_i0	PRJNA287283	9597	178	0.896	1.59488	root	1	Root_unresolved	Root_unresolved	329	6.21e-86	NTclustered	gi\|1384665603\|gb\|MH053445.1\|	287	g9373	i0	100	101	178	0	100	0	1	178	19556	19379	Pseudomonas aeruginosa strain PA1280 plasmid pICP-4GES, complete sequence	blastn	17978	329	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
22048649	22048649	PRJNA287283_P_NODE_9398_length_179_cov_0.888889_g9174_i0	PRJNA287283	9398	179	0.888889	1.59111131	Haemophilus parainfluenzae	729	Bacteria	Bacteria	281	1.78e-71	NTclustered	gi\|2512930414\|gb\|CP125087.1\|	729	g9174	i0	94.972	37.7597765363128	179	9	100	0	1	179	379336	379158	Haemophilus parainfluenzae strain EL1 chromosome, complete genome	blastn	6759	281	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
22736012	22736012	PRJNA287283_P_NODE_8458_length_183_cov_0.861538_g8234_i0	PRJNA287283	8458	183	0.861538	1.57661454	Acidovorax	12916	Bacteria	Bacteria	281	1.83e-71	NTclustered	gi\|2442619374\|gb\|CP117193.1\|	80878	g8234	i0	94.972	42.5245901639344	179	9	98	0	1	179	828961	829139	Acidovorax temperans strain LMJ chromosome, complete genome	blastn	7782	283	0.992932862190813	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax temperans
22736013	22736013	PRJNA287283_P_NODE_9318_length_179_cov_1.333333_g9094_i0	PRJNA287283	9318	179	1.333333	2.38666607	Escherichia	561	Bacteria	Bacteria	320	3.76e-83	NTclustered	gi\|2023981091\|gb\|CP072662.1\|	562	g9094	i0	98.883	100	179	2	100	0	1	179	4416341	4416519	Escherichia coli strain BW25113 frmA KO chromosome	blastn	17900	320	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22736015	22736015	PRJNA287283_P_NODE_9878_length_177_cov_0.903226_g9654_i0	PRJNA287283	9878	177	0.903226	1.59871002	Pseudomonadota	1224	Bacteria	Bacteria	99	1.89e-16	NTclustered	gi\|1972895586\|gb\|CP063166.1\|	34073	g9654	i0	93.846	41.9209039548023	65	4	37	0	113	177	1112246	1112182	Variovorax paradoxus strain VAI-C chromosome, complete genome	blastn	7420	99	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
23324218	23324218	PRJNA287283_P_NODE_1999_length_475_cov_4.135071_g1777_i0	PRJNA287283	1999	475	4.135071	19.64158725	Massilia sp. UMI-21	1337838	Bacteria	Bacteria	822	0	NTclustered	gi\|1929479555\|gb\|CP063848.1\|	1337838	g1777	i0	97.895	535.938947368421	475	10	100	0	1	475	5259067	5259541	Massilia sp. UMI-21 chromosome, complete genome	blastn	254571	822	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. UMI-21
23324230	23324230	PRJNA287283_P_NODE_9599_length_178_cov_0.896000_g9375_i0	PRJNA287283	9599	178	0.896	1.59488	Sinimarinibacterium sp. NLF-5-8	2698684	Bacteria	Bacteria	274	2.95e-69	NTclustered	gi\|1804087121\|gb\|CP048030.1\|	2698684	g9375	i0	94.444	187.342696629213	180	6	100	4	1	178	1433345	1433168	Sinimarinibacterium sp. NLF-5-8 chromosome, complete genome	blastn	33347	274	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Nevskiales	Nevskiaceae	Sinimarinibacterium	Sinimarinibacterium sp. NLF-5-8
24011105	24011105	PRJNA287283_P_NODE_10639_length_170_cov_8.376068_g10415_i0	PRJNA287283	10639	170	8.376068	14.2393156	root	1	Root_unresolved	Root_unresolved	309	7.64e-80	NTclustered	gi\|2706519156\|gb\|CP149578.1\|	287	g10415	i0	99.412	101	170	1	100	0	1	170	6007870	6008039	Mutant Pseudomonas aeruginosa isolate FELIX_MS413, complete genome	blastn	17170	309	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
24598302	24598302	PRJNA287283_P_NODE_10260_length_176_cov_0.910569_g10036_i0	PRJNA287283	10260	176	0.910569	1.60260144	Sphingomonas panni	237612	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|2808875156\|gb\|PQ201171.1\|	237612	g10036	i0	99.432	1	176	1	100	0	1	176	15880	15705	Sphingomonas panni strain E13 plasmid pSHE13.2, complete sequence	blastn	176	320	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas panni
25285254	25285254	PRJNA287283_P_NODE_10640_length_170_cov_6.529915_g10416_i0	PRJNA287283	10640	170	6.529915	11.1008555	root	1	Root_unresolved	Root_unresolved	315	1.64e-81	NTclustered	gi\|754557523\|emb\|LN794200.1\|	34071	g10416	i0	100	100	170	0	100	0	1	170	178	9	Telluria mixta partial 16S rRNA gene, type strain DSM 29330T, clone 1	blastn	17000	315	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Telluria	Telluria mixta
25285255	25285255	PRJNA287283_P_NODE_10740_length_165_cov_2.250000_g10516_i0	PRJNA287283	10740	165	2.25	3.7125	Neisseria	482	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|647544798\|dbj\|AB904066.1\|	33053	g10516	i0	100	100	165	0	100	0	1	165	683	519	Neisseria perflava gene for 16S ribosomal RNA, partial sequence, strain: NSU-per_31	blastn	16500	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria perflava
25285261	25285261	PRJNA287283_P_NODE_6320_length_227_cov_1.339080_g6096_i0	PRJNA287283	6320	227	1.33908	3.0397116	Gammaproteobacteria	1236	Bacteria	Bacteria	265	2.3899999999999997e-66	NTclustered	gi\|1573910300\|gb\|CP033381.1\|	107637	g6096	i0	87.946	292.885462555066	224	27	100	0	4	227	1651967	1651744	Methylomonas sp. LW13 chromosome, complete genome	blastn	66485	265	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Methylococcales	Methylococcaceae	Methylomonas	Methylomonas sp. LW13
25285264	25285264	PRJNA287283_P_NODE_9660_length_178_cov_0.896000_g9436_i0	PRJNA287283	9660	178	0.896	1.59488	Enterobacteriaceae	543	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|2737310786\|gb\|CP157132.1\|	562	g9436	i0	99.438	100	178	1	100	0	1	178	3842446	3842623	Escherichia coli strain UTAK-18 chromosome, complete genome	blastn	17800	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli

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