metadata: contig_metadata: 45 rows where analysis = "blastn", bioproject = "PRJEB27957" and tax

45 rows where analysis = "blastn", bioproject = "PRJEB27957" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
23389	23389	PRJEB27957_P_NODE_21761_length_319_cov_1.792593_g21651_i0	PRJEB27957	21761	319	1.792593	5.71837167	Buchnera aphidicola	9	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|1631841601\|gb\|CP034864.1\|	1241865	g21651	i0	100	0.0877742946708464	28	0	9	0	277	304	477312	477285	Buchnera aphidicola (Macrosiphoniella sanborni) strain Msa chromosome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
23410	23410	PRJEB27957_P_NODE_48281_length_235_cov_1.118280_g48171_i0	PRJEB27957	48281	235	1.11828	2.627958	Psychrobacter sp. WY6	2708350	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2043521576\|gb\|CP049902.1\|	2708350	g48171	i0	96.875	0.136170212765957	32	0	14	1	11	42	1347493	1347523	Psychrobacter sp. WY6 chromosome, complete genome	blastn	32	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter	Psychrobacter sp. WY6
23416	23416	PRJEB27957_P_NODE_65801_length_208_cov_1.308176_g65691_i0	PRJEB27957	65801	208	1.308176	2.72100608	Photobacterium sp. CCB-ST2H9	2912855	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2271415029\|gb\|CP100425.1\|	2912855	g65691	i0	96.875	0.153846153846154	32	1	15	0	86	117	3317674	3317705	Photobacterium sp. CCB-ST2H9 chromosome 1, complete sequence	blastn	32	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Photobacterium	Photobacterium sp. CCB-ST2H9
23419	23419	PRJEB27957_P_NODE_74561_length_197_cov_2.108108_g74451_i0	PRJEB27957	74561	197	2.108108	4.15297276	Arsenophonus sp.	1872640	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2576864534\|gb\|CP132907.1\|	1872640	g74451	i0	96.774	0.157360406091371	31	1	16	0	148	178	376302	376272	MAG: Arsenophonus sp. isolate K15 chromosome, complete genome	blastn	31	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Arsenophonus	Arsenophonus sp.
986771	986771	PRJEB27957_P_NODE_117161_length_164_cov_1.808696_g117051_i0	PRJEB27957	117161	164	1.808696	2.96626144	Moraxellaceae	468	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2593446548\|gb\|OR699078.1\|	479	g117051	i0	100	287.689024390244	164	0	100	0	1	164	689	852	Moraxella sp. strain Hz 62-2 23S ribosomal RNA gene, partial sequence	blastn	47181	303	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Moraxella	Moraxella sp.
986814	986814	PRJEB27957_P_NODE_62721_length_212_cov_1.521472_g62611_i0	PRJEB27957	62721	212	1.521472	3.22552064	Acinetobacter	469	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2308809033\|gb\|CP104651.1\|	70346	g62611	i0	100	1.33490566037736	28	0	13	0	46	73	1239958	1239985	Acinetobacter variabilis strain 2021CK-01005 chromosome, complete genome	blastn	283	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter variabilis
1297630	1297630	PRJEB27957_P_NODE_118202_length_164_cov_0.904348_g118092_i0	PRJEB27957	118202	164	0.904348	1.48313072	Coxiella endosymbiont of Amblyomma nuttalli	2749996	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2028309919\|gb\|CP064834.1\|	2749996	g118092	i0	100	0.176829268292683	29	0	18	0	81	109	751452	751424	Coxiella endosymbiont of Amblyomma nuttalli isolate Craf2019 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Coxiellaceae	Coxiella	Coxiella endosymbiont of Amblyomma nuttalli
1297637	1297637	PRJEB27957_P_NODE_13782_length_376_cov_2.700306_g13672_i0	PRJEB27957	13782	376	2.700306	10.15315056	Legionella sainthelensi	28087	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|1539471345\|emb\|LR134178.1\|	28087	g13672	i0	100	0.074468085106383	28	0	7	0	53	80	1808112	1808139	Legionella sainthelensi strain NCTC12450 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Legionellaceae	Legionella	Legionella sainthelensi
3537364	3537364	PRJEB27957_P_NODE_117063_length_164_cov_2.060870_g116953_i0	PRJEB27957	117063	164	2.06087	3.3798268	Pseudomonas	286	Bacteria	Bacteria	279	5.77e-71	NTclustered	gi\|2703320555\|gb\|CP148126.1\|	303	g116953	i0	97.546	684.841463414634	163	4	99	0	1	163	164799	164961	Mutant Pseudomonas putida isolate FELIX_MS547, complete genome	blastn	112314	279	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas putida
3849559	3849559	PRJEB27957_P_NODE_112104_length_166_cov_0.888889_g111994_i0	PRJEB27957	112104	166	0.888889	1.47555574	Candidatus Profftia sp. (ex Adelges kitamiensis)	2864218	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2107703733\|gb\|CP080506.1\|	2864218	g111994	i0	100	0.168674698795181	28	0	17	0	33	60	1017316	1017343	Candidatus Profftia sp. (ex Adelges kitamiensis) isolate Adelges kitamiensis 18-608 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Profftia	Candidatus Profftia sp. (ex Adelges kitamiensis)
3849571	3849571	PRJEB27957_P_NODE_121384_length_163_cov_0.912281_g121274_i0	PRJEB27957	121384	163	0.912281	1.48701803	Acinetobacter sp. WCHA45	2004644	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|1378772958\|gb\|CP028561.1\|	2004644	g121274	i0	98.773	98.7116564417178	163	2	100	0	1	163	1797010	1797172	Acinetobacter sp. WCHA45 chromosome, complete genome	blastn	16090	291	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter sp. WCHA45
5125803	5125803	PRJEB27957_P_NODE_116545_length_165_cov_0.896552_g116435_i0	PRJEB27957	116545	165	0.896552	1.4793108	Denitratisoma oestradiolicum	311182	Bacteria	Bacteria	171	3.65e-38	NTclustered	gi\|1885927991\|emb\|LR778301.1\|	311182	g116435	i0	85.802	57.6727272727273	162	22	98	1	4	165	3253719	3253559	Denitratisoma oestradiolicum strain DSM16959 genome assembly, chromosome: I	blastn	9516	171	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Sterolibacteriaceae	Denitratisoma	Denitratisoma oestradiolicum
5125810	5125810	PRJEB27957_P_NODE_119505_length_164_cov_0.904348_g119395_i0	PRJEB27957	119505	164	0.904348	1.48313072	Methylorubrum sp. B1-46	2897334	Bacteria	Bacteria	220	3.55e-53	NTclustered	gi\|2161694424\|gb\|CP088247.1\|	2897334	g119395	i0	90.854	3.03658536585366	164	15	100	0	1	164	1360370	1360533	Methylorubrum sp. B1-46 chromosome, complete genome	blastn	498	220	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylorubrum	Methylorubrum sp. B1-46
6401553	6401553	PRJEB27957_P_NODE_79246_length_192_cov_1.517483_g79136_i0	PRJEB27957	79246	192	1.517483	2.91356736	Escherichia albertii	208962	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2444280885\|gb\|CP117659.1\|	208962	g79136	i0	96.875	1	32	0	16	1	11	41	4005289	4005320	Escherichia albertii strain BIA_13 chromosome, complete genome	blastn	192	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia albertii
7364548	7364548	PRJEB27957_P_NODE_95366_length_176_cov_1.228346_g95256_i0	PRJEB27957	95366	176	1.228346	2.16188896	Acinetobacter	469	Bacteria	Bacteria	326	7.92e-85	NTclustered	gi\|1958425625\|gb\|CP068206.1\|	40214	g95256	i0	100	689.823863636364	176	0	100	0	1	176	3045239	3045414	Acinetobacter johnsonii strain FDAARGOS_1092 chromosome, complete genome	blastn	121409	326	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
7675665	7675665	PRJEB27957_P_NODE_32867_length_273_cov_1.080357_g32757_i0	PRJEB27957	32867	273	1.080357	2.94937461	Candidatus Profftia lariciata	1987921	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2119947790\|gb\|CP045925.1\|	1987921	g32757	i0	100	0.102564102564103	28	0	10	0	12	39	234541	234568	Candidatus Profftia lariciata isolate Ad13-081 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Profftia	Candidatus Profftia lariciata
8950455	8950455	PRJEB27957_P_NODE_67108_length_206_cov_1.987261_g66998_i0	PRJEB27957	67108	206	1.987261	4.09375766	Acinetobacter guillouiae	106649	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2103607268\|gb\|CP083989.1\|	106649	g66998	i0	100	0.271844660194175	28	0	14	0	59	86	2497555	2497582	Acinetobacter guillouiae strain PgBE136 chromosome	blastn	56	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter guillouiae
8950480	8950480	PRJEB27957_P_NODE_98928_length_172_cov_2.487805_g98818_i0	PRJEB27957	98928	172	2.487805	4.2790246	Endozoicomonas gorgoniicola	1234144	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2313433258\|gb\|CP103298.1\|	1234144	g98818	i0	94.444	0.209302325581395	36	2	21	0	7	42	4210479	4210514	Endozoicomonas gorgoniicola strain PS125 chromosome, complete genome	blastn	36	56.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Endozoicomonadaceae	Endozoicomonas	Endozoicomonas gorgoniicola
9914999	9914999	PRJEB27957_P_NODE_84348_length_187_cov_1.507246_g84238_i0	PRJEB27957	84348	187	1.507246	2.81855002	Leptothrix	88	Bacteria	Bacteria	302	1.44e-77	NTclustered	gi\|470483061\|ref\|NR_076570.1\|	34029	g84238	i0	95.722	242.748663101604	187	8	100	0	1	187	379	193	Leptothrix cholodnii strain SP-6 23S ribosomal RNA gene, complete sequence	blastn	45394	302	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Leptothrix	Leptothrix cholodnii
9915008	9915008	PRJEB27957_P_NODE_95788_length_175_cov_2.246032_g95678_i0	PRJEB27957	95788	175	2.246032	3.930556	Noviherbaspirillum	1344552	Bacteria	Bacteria	307	2.8500000000000004e-79	NTclustered	gi\|1720090765\|gb\|CP040128.1\|	2601898	g95678	i0	98.844	230.045714285714	173	1	98	1	3	174	758057	758229	Noviherbaspirillum sp. UKPF54 chromosome, complete genome	blastn	40258	307	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Noviherbaspirillum	Noviherbaspirillum sp. UKPF54
10226169	10226169	PRJEB27957_P_NODE_41349_length_249_cov_2.585000_g41239_i0	PRJEB27957	41349	249	2.585	6.43665	Serratia bockelmannii	2703793	Bacteria	Bacteria	405	1.5e-108	NTclustered	gi\|2216536986\|gb\|CP064182.1\|	2703793	g41239	i0	96	271.044176706827	250	8	100	2	1	249	4308073	4308321	Serratia bockelmannii strain Rip1 chromosome, complete genome	blastn	67490	405	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Serratia	Serratia bockelmannii
10226175	10226175	PRJEB27957_P_NODE_51869_length_228_cov_1.743017_g51759_i0	PRJEB27957	51869	228	1.743017	3.97407876	Neisseria mucosa	488	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|1373029274\|gb\|CP028150.1\|	488	g51759	i0	100	0.12280701754386	28	0	12	0	169	196	2257764	2257737	Neisseria mucosa strain ATCC 19696 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria mucosa
12465943	12465943	PRJEB27957_P_NODE_67930_length_205_cov_1.967949_g67820_i0	PRJEB27957	67930	205	1.967949	4.03429545	Comamonadaceae	80864	Bacteria	Bacteria	363	7.279999999999998e-96	NTclustered	gi\|1373249612\|gb\|CP028292.1\|	80867	g67820	i0	98.544	257.160975609756	206	2	100	1	1	205	5229762	5229967	Paracidovorax avenae strain INDB2 chromosome	blastn	52718	364	0.997252747252747	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Paracidovorax	Paracidovorax avenae
12776938	12776938	PRJEB27957_P_NODE_104251_length_169_cov_0.866667_g104141_i0	PRJEB27957	104251	169	0.866667	1.46466723	Vibrio aphrogenes	1891186	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1396658551\|dbj\|AP018690.1\|	1891186	g104141	i0	100	0.165680473372781	28	0	17	0	3	30	577885	577858	Vibrio aphrogenes CA-1004 DNA, chromosome 2, complete geome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio aphrogenes
12776983	12776983	PRJEB27957_P_NODE_48091_length_235_cov_1.559140_g47981_i0	PRJEB27957	48091	235	1.55914	3.663979	Acinetobacter bereziniae	106648	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2429879843\|gb\|CP115962.1\|	106648	g47981	i0	100	0.119148936170213	28	0	12	0	172	199	1257303	1257330	Acinetobacter bereziniae strain mNGS2101_15 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter bereziniae
12776998	12776998	PRJEB27957_P_NODE_72191_length_200_cov_1.682119_g72081_i0	PRJEB27957	72191	200	1.682119	3.364238	Sphingomonas rhizophila	2071607	Bacteria	Bacteria	353	4.25e-93	NTclustered	gi\|1898509264\|gb\|CP060717.1\|	2071607	g72081	i0	98.5	208.82	200	3	100	0	1	200	2394621	2394820	Sphingomonas rhizophila strain KACC 19189 chromosome, complete genome	blastn	41764	353	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas rhizophila
13740255	13740255	PRJEB27957_P_NODE_106071_length_168_cov_0.932773_g105961_i0	PRJEB27957	106071	168	0.932773	1.56705864	Janthinobacterium	29580	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|1861348618\|gb\|CP049828.1\|	29581	g105961	i0	100	492.785714285714	168	0	100	0	1	168	214607	214440	Janthinobacterium lividum strain EIF2 chromosome, complete genome	blastn	82788	311	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium	Janthinobacterium lividum
15014708	15014708	PRJEB27957_P_NODE_110332_length_167_cov_0.881356_g110222_i0	PRJEB27957	110332	167	0.881356	1.47186452	Enterobacteriaceae	543	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g110222	i0	100	101	167	0	100	0	1	167	275158	274992	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16867	309	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15014729	15014729	PRJEB27957_P_NODE_17772_length_344_cov_1.179661_g17662_i0	PRJEB27957	17772	344	1.179661	4.05803384	Gammaproteobacteria	1236	Bacteria	Bacteria	625	1.5299999999999996e-174	NTclustered	gi\|2643672927\|gb\|CP133209.1\|	294	g17662	i0	99.419	536.877906976744	344	2	100	0	1	344	2957	2614	Pseudomonas fluorescens strain CFBP2392 chromosome, complete genome	blastn	184686	625	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
15325608	15325608	PRJEB27957_P_NODE_91513_length_180_cov_1.190840_g91403_i0	PRJEB27957	91513	180	1.19084	2.143512	Salinimonas lutimaris	914153	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1634056557\|gb\|CP036536.1\|	914153	g91403	i0	100	0.155555555555556	28	0	16	0	73	100	3105144	3105117	Salinimonas lutimaris strain DPSR-4 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Salinimonas	Salinimonas lutimaris
17564671	17564671	PRJEB27957_P_NODE_12414_length_391_cov_1.412281_g12305_i0	PRJEB27957	12414	391	1.412281	5.52201871	root	1	Root_unresolved	Root_unresolved	52.8	0.037	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g12305	i0	92.105	0.797953964194373	38	2	10	1	251	288	579134	579170	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	312	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
17874984	17874984	PRJEB27957_P_NODE_110335_length_167_cov_0.881356_g110225_i0	PRJEB27957	110335	167	0.881356	1.47186452	Pseudomonas yamanorum	515393	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|1374529460\|gb\|CP012400.2\|	515393	g110225	i0	100	3	167	0	100	0	1	167	3777884	3778050	Pseudomonas yamanorum strain LBUM636 chromosome, complete genome	blastn	501	309	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas yamanorum
17874995	17874995	PRJEB27957_P_NODE_13515_length_379_cov_1.557576_g13405_i0	PRJEB27957	13515	379	1.557576	5.90321304	Spartinivicinus ruber	2683272	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1812397443\|gb\|CP048878.1\|	2683272	g13405	i0	100	0.0765171503957784	29	0	8	0	350	378	1851795	1851767	Spartinivicinus ruber strain S2-4-1H chromosome, complete genome	blastn	29	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Zooshikellaceae	Spartinivicinus	Spartinivicinus ruber
17874996	17874996	PRJEB27957_P_NODE_14255_length_372_cov_1.606811_g14145_i0	PRJEB27957	14255	372	1.606811	5.97733692	endosymbiont of Pachyrhynchus infernalis	1971488	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2801980978\|dbj\|AP036057.1\|	1971488	g14145	i0	100	0.150537634408602	28	0	8	0	174	201	217873	217846	Endosymbiont of Pachyrhynchus infernalis NARPIN1 DNA, complete genome	blastn	56	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria			Candidatus Nardonella	endosymbiont of Pachyrhynchus infernalis
17875000	17875000	PRJEB27957_P_NODE_23875_length_308_cov_2.208494_g23765_i0	PRJEB27957	23875	308	2.208494	6.80216152	Serratia entomophila	42906	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2177962288\|gb\|CP082787.1\|	42906	g23765	i0	100	0.272727272727273	28	0	9	0	16	43	56935	56962	Serratia entomophila strain A1 chromosome, complete genome	blastn	84	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Serratia	Serratia entomophila
17875021	17875021	PRJEB27957_P_NODE_58295_length_218_cov_1.834320_g58185_i0	PRJEB27957	58295	218	1.83432	3.9988176	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|1269271234\|gb\|CP024013.1\|	2608262	g58185	i0	100	0.128440366972477	28	0	13	0	176	203	216513	216540	MAG: Candidatus Stammera capleta isolate NZ1215 chromosome, complete genome	blastn	28	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
18838549	18838549	PRJEB27957_P_NODE_112095_length_166_cov_0.888889_g111985_i0	PRJEB27957	112095	166	0.888889	1.47555574	Pseudomonas	286	Bacteria	Bacteria	285	1.26e-72	NTclustered	gi\|2636526585\|gb\|CP140009.1\|	298	g111985	i0	100	8.34939759036145	154	0	93	0	13	166	2067871	2067718	Pseudomonas marginalis strain SBW25 chromosome, complete genome	blastn	1386	285	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas marginalis
19148906	19148906	PRJEB27957_P_NODE_36596_length_262_cov_0.840376_g36486_i0	PRJEB27957	36596	262	0.840376	2.20178512	Massilia endophytica	2899220	Bacteria	Bacteria	425	1.22e-114	NTclustered	gi\|2164166189\|gb\|CP088952.1\|	2899220	g36486	i0	97.211	430.473282442748	251	7	96	0	12	262	4387609	4387859	Massilia endophytica strain DM-R-R2A-13 chromosome, complete genome	blastn	112784	425	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia endophytica
20113309	20113309	PRJEB27957_P_NODE_102876_length_169_cov_1.300000_g102766_i0	PRJEB27957	102876	169	1.3	2.197	Buchnera	32199	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2739932301\|emb\|OZ060386.1\|	1265378	g102766	i0	100	0.331360946745562	28	0	17	0	19	46	364669	364696	Buchnera aphidicola (Neophyllaphis podocarpi) strain Nepodocarpi-3733 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
20424087	20424087	PRJEB27957_P_NODE_122917_length_163_cov_0.912281_g122807_i0	PRJEB27957	122917	163	0.912281	1.48701803	Janthinobacterium sp. J1-1	3065910	Bacteria	Bacteria	252	1.25e-62	NTclustered	gi\|2571189747\|gb\|CP132339.1\|	3065910	g122807	i0	95	51.7975460122699	160	8	98	0	1	160	3768478	3768637	Janthinobacterium sp. J1-1 chromosome, complete genome	blastn	8443	252	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium	Janthinobacterium sp. J1-1
20424104	20424104	PRJEB27957_P_NODE_30797_length_280_cov_1.025974_g30687_i0	PRJEB27957	30797	280	1.025974	2.8727272	Faucicola osloensis	34062	Bacteria	Bacteria	412	1.0299999999999997e-110	NTclustered	gi\|1958308771\|gb\|CP068109.1\|	34062	g30687	i0	93.571	506.903571428571	280	12	99	4	5	280	853765	854042	Moraxella osloensis strain FDAARGOS_1130 chromosome, complete genome	blastn	141933	412	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
22975363	22975363	PRJEB27957_P_NODE_29379_length_285_cov_1.250000_g29269_i0	PRJEB27957	29379	285	1.25	3.5625	Pseudoalteromonas luteoviolacea	43657	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1072037183\|gb\|CP015411.1\|	43657	g29269	i0	96.774	0.326315789473684	31	1	11	0	78	108	3835327	3835297	Pseudoalteromonas luteoviolacea strain S4054249 chromosome 1, complete sequence	blastn	93	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Pseudoalteromonadaceae	Pseudoalteromonas	Pseudoalteromonas luteoviolacea
22975391	22975391	PRJEB27957_P_NODE_72759_length_199_cov_6.780000_g72649_i0	PRJEB27957	72759	199	6.78	13.4922	Providencia stuartii	588	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2635608015\|emb\|OY979223.1\|	588	g72649	i0	100	0.844221105527638	28	0	14	0	11	38	4486038	4486011	Providencia stuartii strain PS9952019BGR genome assembly, chromosome: PS9952019	blastn	168	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Providencia	Providencia stuartii
22975392	22975392	PRJEB27957_P_NODE_73119_length_199_cov_1.386667_g73009_i0	PRJEB27957	73119	199	1.386667	2.75946733	Wigglesworthia glossinidia	51229	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|375157796\|gb\|CP003315.1\|	1142511	g73009	i0	100	0.14070351758794	28	0	14	0	116	143	140530	140503	Wigglesworthia glossinidia endosymbiont of Glossina morsitans morsitans (Yale colony) isolate WGM chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Wigglesworthia	Wigglesworthia glossinidia
25212895	25212895	PRJEB27957_P_NODE_102240_length_169_cov_2.600000_g102130_i0	PRJEB27957	102240	169	2.6	4.394	Candidatus Methylopumilus	1679002	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2663341414\|emb\|OX095767.1\|	1581557	g102130	i0	100	8.61538461538461	28	0	17	0	109	136	235852	235825	Candidatus Methylopumilus planktonicus isolate MMS-80-8 genome assembly, chromosome: MMS-80-8	blastn	1456	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Candidatus Methylopumilus	Candidatus Methylopumilus planktonicus

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