metadata: contig_metadata: 46 rows where analysis = "blastn", bioproject = "PRJEB43370" and tax

46 rows where analysis = "blastn", bioproject = "PRJEB43370" 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
60239	60239	PRJEB43370_P_NODE_641_length_539_cov_3.924490_g599_i0	PRJEB43370	641	539	3.92449	21.1530011	Vogesella sp. XCS3	2877939	Bacteria	Bacteria	974	0	NTclustered	gi\|2124242701\|gb\|CP085530.1\|	2877939	g599	i0	99.258	513.979591836735	539	4	100	0	1	539	78526	77988	Vogesella sp. XCS3 chromosome, complete genome	blastn	277035	974	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella sp. XCS3
989947	989947	PRJEB43370_P_NODE_6241_length_183_cov_2.432836_g6198_i0	PRJEB43370	6241	183	2.432836	4.45208988	Aeromonas	642	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|2209819103\|gb\|CP093309.1\|	644	g6198	i0	100	212.726775956284	183	0	100	0	1	183	4258025	4258207	Aeromonas hydrophila strain AC133 chromosome, complete genome	blastn	38929	339	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
2265174	2265174	PRJEB43370_P_NODE_10982_length_162_cov_0.920354_g10939_i0	PRJEB43370	10982	162	0.920354	1.49097348	Undibacterium	401469	Bacteria	Bacteria	228	2.0899999999999995e-55	NTclustered	gi\|1798093821\|dbj\|AP018439.1\|	2058624	g10939	i0	91.975	79.0308641975309	162	13	100	0	1	162	371285	371446	Undibacterium sp. KW1 DNA, complete genome	blastn	12803	228	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. KW1
2265175	2265175	PRJEB43370_P_NODE_2162_length_295_cov_1.430894_g2119_i0	PRJEB43370	2162	295	1.430894	4.2211373	Bradyrhizobium	374	Bacteria	Bacteria	252	2.52e-62	NTclustered	gi\|146189981\|emb\|CU234118.1\|	114615	g2119	i0	82.594	95.6440677966102	293	43	98	8	4	292	177449	177737	Bradyrhizobium sp. ORS278,complete sequence	blastn	28215	254	0.992125984251969	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. ORS 278
2265185	2265185	PRJEB43370_P_NODE_9282_length_165_cov_0.896552_g9239_i0	PRJEB43370	9282	165	0.896552	1.4793108	root	1	Root_unresolved	Root_unresolved	58.4	2.97e-4	NTclustered	gi\|1151160134\|gb\|CP018970.1\|	562	g9239	i0	100	11.9636363636364	31	0	19	0	68	98	380315	380285	Escherichia coli strain Ecol_542, complete genome	blastn	1974	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3886278	3886278	PRJEB43370_P_NODE_10504_length_163_cov_0.912281_g10461_i0	PRJEB43370	10504	163	0.912281	1.48701803	Ottowia sp. SB7-C50	3081231	Bacteria	Bacteria	183	4.62e-42	NTclustered	gi\|2606722230\|gb\|CP136995.1\|	3081231	g10461	i0	88.387	68.760736196319	155	15	93	2	9	160	215033	215187	Ottowia sp. SB7-C50 chromosome, complete genome	blastn	11208	183	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Ottowia	Ottowia sp. SB7-C50
3886336	3886336	PRJEB43370_P_NODE_6124_length_185_cov_1.485294_g6081_i0	PRJEB43370	6124	185	1.485294	2.7477939	Acidovorax delafieldii	47920	Bacteria	Bacteria	111	2.57e-20	NTclustered	gi\|2842886548\|gb\|CP171997.1\|	47920	g6081	i0	84.483	3.81081081081081	116	14	62	4	16	129	3996394	3996507	Acidovorax delafieldii strain UC81_30 chromosome, complete genome	blastn	705	111	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax delafieldii
3886344	3886344	PRJEB43370_P_NODE_6824_length_175_cov_3.611111_g6781_i0	PRJEB43370	6824	175	3.611111	6.31944425	Hylemonella gracilis	80880	Bacteria	Bacteria	316	4.74e-82	NTclustered	gi\|1586158954\|gb\|CP031395.1\|	80880	g6781	i0	99.425	265.497142857143	174	1	99	0	1	174	391769	391942	Hylemonella gracilis strain NS1 chromosome	blastn	46462	316	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Hylemonella	Hylemonella gracilis
3886362	3886362	PRJEB43370_P_NODE_9504_length_165_cov_0.896552_g9461_i0	PRJEB43370	9504	165	0.896552	1.4793108	Plesiomonas shigelloides	703	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g9461	i0	99.394	8	165	1	100	0	1	165	1176963	1177127	Plesiomonas shigelloides strain Colony13 chromosome	blastn	1320	300	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
3886367	3886367	PRJEB43370_P_NODE_9984_length_164_cov_0.904348_g9941_i0	PRJEB43370	9984	164	0.904348	1.48313072	Hydrogenophaga crassostreae	1763535	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|1078664375\|gb\|CP017476.1\|	1763535	g9941	i0	98.171	1	164	3	100	0	1	164	3362978	3362815	Hydrogenophaga crassostreae strain LPB0072 chromosome, complete genome	blastn	164	287	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Hydrogenophaga	Hydrogenophaga crassostreae
5162512	5162512	PRJEB43370_P_NODE_3205_length_243_cov_3.149485_g3162_i0	PRJEB43370	3205	243	3.149485	7.65324855	Piscinibacter gummiphilus	946333	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|1275594026\|gb\|CP024645.1\|	946333	g3162	i0	97.942	343.559670781893	243	5	100	0	1	243	5691294	5691536	Piscinibacter gummiphilus strain NBRC 109400 chromosome, complete genome	blastn	83485	422	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Piscinibacter	Piscinibacter gummiphilus
6093065	6093065	PRJEB43370_P_NODE_6605_length_178_cov_2.418605_g6562_i0	PRJEB43370	6605	178	2.418605	4.3051169	Pseudomonadota	1224	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2070639042\|gb\|CP079203.1\|	33051	g6562	i0	94.444	0.561797752808989	36	1	20	1	60	94	3246328	3246363	Sphingomonas sanguinis strain NP2-R2 chromosome, complete genome	blastn	100	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sanguinis
6438379	6438379	PRJEB43370_P_NODE_6966_length_174_cov_1.224000_g6923_i0	PRJEB43370	6966	174	1.224	2.12976	Solimonas sp. K1W22B-7	2303331	Bacteria	Bacteria	272	1.03e-68	NTclustered	gi\|1464353590\|gb\|CP031704.1\|	2303331	g6923	i0	94.857	188.747126436782	175	8	100	1	1	174	309979	309805	Solimonas sp. K1W22B-7 chromosome, complete genome	blastn	32842	272	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Nevskiales	Nevskiaceae	Solimonas	Solimonas sp. K1W22B-7
6438397	6438397	PRJEB43370_P_NODE_9566_length_165_cov_0.896552_g9523_i0	PRJEB43370	9566	165	0.896552	1.4793108	Pseudomonas knackmussii	65741	Bacteria	Bacteria	108	2.9e-19	NTclustered	gi\|631776901\|emb\|HG322950.1\|	1301098	g9523	i0	93.243	39.0848484848485	74	3	44	2	89	161	2377329	2377401	Pseudomonas knackmussii B13 complete genome	blastn	6449	108	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas knackmussii
7712551	7712551	PRJEB43370_P_NODE_10927_length_162_cov_0.920354_g10884_i0	PRJEB43370	10927	162	0.920354	1.49097348	Candidatus Thioglobus sp. NP1	2508687	Bacteria	Bacteria	104	3.67e-18	NTclustered	gi\|1430660017\|gb\|CP023860.1\|	2508687	g10884	i0	79.195	0.919753086419753	149	31	92	0	3	151	447808	447956	Candidatus Thioglobus sp. NP1 chromosome, complete genome	blastn	149	104	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria		Candidatus Pseudothioglobaceae	Candidatus Thioglobus	Candidatus Thioglobus sp. NP1
7712626	7712626	PRJEB43370_P_NODE_7607_length_169_cov_0.866667_g7564_i0	PRJEB43370	7607	169	0.866667	1.46466723	Idiomarina abyssalis	86102	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2087425684\|gb\|CP081832.1\|	86102	g7564	i0	100	0.165680473372781	28	0	17	0	50	77	773141	773114	Idiomarina abyssalis strain MSP-CT chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Idiomarinaceae	Idiomarina	Idiomarina abyssalis
8643085	8643085	PRJEB43370_P_NODE_2647_length_266_cov_1.447005_g2604_i0	PRJEB43370	2647	266	1.447005	3.8490333	Gammaproteobacteria	1236	Bacteria	Bacteria	492	1.2099999999999999e-134	NTclustered	gi\|2890447952\|gb\|CP177213.1\|	562	g2604	i0	100	932.43984962406	266	0	100	0	1	266	228490	228755	Escherichia coli strain ECGI0223 chromosome, complete genome	blastn	248029	492	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8643086	8643086	PRJEB43370_P_NODE_4807_length_205_cov_1.974359_g4764_i0	PRJEB43370	4807	205	1.974359	4.04743595	Aeromonas	642	Bacteria	Bacteria	374	3.3599999999999997e-99	NTclustered	gi\|1891095175\|gb\|CP043323.1\|	644	g4764	i0	99.515	864.439024390244	206	0	100	1	1	205	2205596	2205391	Aeromonas hydrophila strain 3206 chromosome, complete genome	blastn	177210	374	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
8987370	8987370	PRJEB43370_P_NODE_9268_length_165_cov_0.896552_g9225_i0	PRJEB43370	9268	165	0.896552	1.4793108	Halopseudomonas sabulinigri	472181	Bacteria	Bacteria	95.3	2.26e-15	NTclustered	gi\|1085892452\|emb\|LT629763.1\|	472181	g9225	i0	81.356	23.2424242424242	118	20	71	2	4	120	1415059	1415175	Pseudomonas sabulinigri strain JCM 14963 genome assembly, chromosome: I	blastn	3835	95.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Halopseudomonas	Halopseudomonas sabulinigri
9918119	9918119	PRJEB43370_P_NODE_4188_length_217_cov_3.095238_g4145_i0	PRJEB43370	4188	217	3.095238	6.71666646	Acinetobacter	469	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|1797096465\|gb\|CP041970.1\|	70348	g4145	i0	100	595.138248847926	217	0	100	0	1	217	2381414	2381630	Acinetobacter dispersus strain NCCP 16014 chromosome, complete genome	blastn	129145	401	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter dispersus
11538430	11538430	PRJEB43370_P_NODE_6430_length_181_cov_1.386364_g6387_i0	PRJEB43370	6430	181	1.386364	2.50931884	Variovorax sp. V116	3065953	Bacteria	Bacteria	167	5.259999999999999e-37	NTclustered	gi\|2741144593\|dbj\|AP028661.1\|	3065953	g6387	i0	85.03	5.84530386740331	167	21	91	4	16	180	88362	88198	Variovorax sp. V116 DNA, complete genome	blastn	1058	167	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. V116
13743417	13743417	PRJEB43370_P_NODE_4591_length_209_cov_2.581250_g4548_i0	PRJEB43370	4591	209	2.58125	5.3948125	Vibrionaceae	641	Bacteria	Bacteria	91.6	3.88e-14	NTclustered	gi\|2778329021\|dbj\|AP031614.1\|	669	g4548	i0	79.231	25.2870813397129	130	27	62	0	22	151	3151391	3151262	Vibrio harveyi TUMSAT-2019 DNA, chromosome 1, complete sequence	blastn	5285	91.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio harveyi
13743418	13743418	PRJEB43370_P_NODE_6751_length_177_cov_1.195312_g6708_i0	PRJEB43370	6751	177	1.195312	2.11570224	Aeromonas	642	Bacteria	Bacteria	95.3	2.45e-15	NTclustered	gi\|2489122791\|gb\|CP121835.1\|	654	g6708	i0	96.491	20.6271186440678	57	2	32	0	121	177	2641753	2641809	Aeromonas veronii strain ANYA 18462 chromosome, complete genome	blastn	3651	95.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
15362401	15362401	PRJEB43370_P_NODE_3693_length_229_cov_1.155556_g3650_i0	PRJEB43370	3693	229	1.155556	2.64622324	Chitinimonas koreensis	356302	Bacteria	Bacteria	307	3.95e-79	NTclustered	gi\|1898132335\|gb\|CP060704.1\|	356302	g3650	i0	90.87	317.615720524017	230	19	100	2	1	229	5229031	5228803	Chitinimonas koreensis strain R2A43-10 chromosome, complete genome	blastn	72734	307	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chitinibacteraceae	Chitinimonas	Chitinimonas koreensis
15362416	15362416	PRJEB43370_P_NODE_5353_length_196_cov_1.258503_g5310_i0	PRJEB43370	5353	196	1.258503	2.46666588	Burkholderiales bacterium GJ-E10	1469502	Bacteria	Bacteria	305	1.18e-78	NTclustered	gi\|723001977\|dbj\|AP014683.1\|	1469502	g5310	i0	94.898	245.40306122449	196	8	100	2	1	196	369520	369713	Burkholderiales bacterium GJ-E10 DNA, complete genome	blastn	48099	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium GJ-E10
15362417	15362417	PRJEB43370_P_NODE_5653_length_191_cov_1.830986_g5610_i0	PRJEB43370	5653	191	1.830986	3.49718326	Vibrio misgurnus	2993714	Bacteria	Bacteria	353	4.02e-93	NTclustered	gi\|2482491403\|gb\|CP113241.1\|	2993714	g5610	i0	100	914.685863874346	191	0	100	0	1	191	45105	45295	Vibrio sp. gvc chromosome 1, complete sequence	blastn	174705	353	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio misgurnus
16292661	16292661	PRJEB43370_P_NODE_10413_length_163_cov_0.912281_g10370_i0	PRJEB43370	10413	163	0.912281	1.48701803	Escherichia	561	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g10370	i0	100	100	163	0	100	0	1	163	312621	312783	Escherichia coli strain Case 2 chromosome, complete genome	blastn	16300	302	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16292668	16292668	PRJEB43370_P_NODE_6113_length_185_cov_1.529412_g6070_i0	PRJEB43370	6113	185	1.529412	2.8294122	Enterobacteriaceae	543	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|2208429280\|dbj\|AP025653.1\|	545	g6070	i0	100	679.2	185	0	100	0	1	185	3663235	3663419	Citrobacter koseri TUM20903 DNA, complete genome	blastn	125652	342	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter koseri
16292670	16292670	PRJEB43370_P_NODE_7073_length_172_cov_2.000000_g7030_i0	PRJEB43370	7073	172	2	3.44	Comamonadaceae	80864	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|1799006380\|gb\|CP047650.1\|	2697032	g7030	i0	100	358.017441860465	172	0	100	0	1	172	681090	681261	Xylophilus rhododendri strain KACC 21265 chromosome, complete genome	blastn	61579	318	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Xylophilus	Xylophilus rhododendri
17911751	17911751	PRJEB43370_P_NODE_2575_length_270_cov_0.936652_g2532_i0	PRJEB43370	2575	270	0.936652	2.5289604	Ahrensia marina	1514904	Bacteria	Bacteria	239	1.7700000000000002e-58	NTclustered	gi\|2808402090\|gb\|CP159483.1\|	1514904	g2532	i0	83.65	186.859259259259	263	34	96	9	12	270	1227020	1226763	Ahrensia marina strain ac1 chromosome, complete genome	blastn	50452	239	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Ahrensiaceae	Ahrensia	Ahrensia marina
17911805	17911805	PRJEB43370_P_NODE_8495_length_167_cov_0.881356_g8452_i0	PRJEB43370	8495	167	0.881356	1.47186452	Roseateles sp. DAIF2	2714952	Bacteria	Bacteria	224	2.81e-54	NTclustered	gi\|1934957904\|gb\|CP049919.1\|	2714952	g8452	i0	92.994	23.9820359281437	157	6	93	5	12	167	820975	821127	Roseateles sp. DAIF2 chromosome, complete genome	blastn	4005	224	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles sp. DAIF2
19185748	19185748	PRJEB43370_P_NODE_9016_length_166_cov_0.888889_g8973_i0	PRJEB43370	9016	166	0.888889	1.47555574	Metapseudomonas otitidis	319939	Bacteria	Bacteria	132	1.74e-26	NTclustered	gi\|2573316986\|gb\|CP133395.1\|	319939	g8973	i0	81.437	6.03614457831325	167	26	100	4	1	166	3015810	3015972	Metapseudomonas otitidis strain 149 chromosome	blastn	1002	132	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Metapseudomonas	Metapseudomonas otitidis
20116473	20116473	PRJEB43370_P_NODE_10876_length_162_cov_0.920354_g10833_i0	PRJEB43370	10876	162	0.920354	1.49097348	Burkholderiales	80840	Bacteria	Bacteria	115	1.7e-21	NTclustered	gi\|2916315737\|gb\|CP181387.1\|	28068	g10833	i0	82.09	76.4074074074074	134	24	83	0	1	134	1563619	1563752	Mutant Rubrivivax gelatinosus isolate AJ1, complete genome	blastn	12378	115	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Rubrivivax	Rubrivivax gelatinosus
20116486	20116486	PRJEB43370_P_NODE_8696_length_166_cov_1.777778_g8653_i0	PRJEB43370	8696	166	1.777778	2.95111148	Enterobacteriaceae	543	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g8653	i0	100	664.174698795181	166	0	100	0	1	166	186540	186375	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	110253	307	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20461003	20461003	PRJEB43370_P_NODE_10237_length_163_cov_0.912281_g10194_i0	PRJEB43370	10237	163	0.912281	1.48701803	Caulobacter sp. UC70_42	3374551	Bacteria	Bacteria	255	9.65e-64	NTclustered	gi\|2842900254\|gb\|CP171994.1\|	3374551	g10194	i0	95.062	14.9325153374233	162	8	99	0	1	162	2393361	2393522	Caulobacter sp. UC70_42 chromosome, complete genome	blastn	2434	255	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Caulobacter	Caulobacter sp. UC70_42
20461049	20461049	PRJEB43370_P_NODE_5277_length_197_cov_1.405405_g5234_i0	PRJEB43370	5277	197	1.405405	2.76864785	Pseudomonas sp. ABC1	2748080	Bacteria	Bacteria	257	3.3700000000000004e-64	NTclustered	gi\|1867220348\|gb\|CP058349.1\|	2748080	g5234	i0	94.643	261.802030456853	168	6	84	3	33	197	1035020	1034853	Pseudomonas sp. ABC1 chromosome, complete genome	blastn	51575	257	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. ABC1
21392019	21392019	PRJEB43370_P_NODE_3237_length_242_cov_1.813472_g3194_i0	PRJEB43370	3237	242	1.813472	4.38860224	Comamonas	283	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|507148303\|ref\|NR_103106.1\|	285	g3194	i0	98.347	442.421487603306	242	4	100	0	1	242	1388	1629	Comamonas testosteroni strain CNB-1 23S ribosomal RNA gene, complete sequence	blastn	107066	425	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas testosteroni
21736884	21736884	PRJEB43370_P_NODE_2758_length_261_cov_0.981132_g2715_i0	PRJEB43370	2758	261	0.981132	2.56075452	Aquipseudomonas alcaligenes	43263	Bacteria	Bacteria	470	5.539999999999998e-128	NTclustered	gi\|1009291925\|gb\|CP014784.1\|	43263	g2715	i0	99.231	97.7854406130268	260	2	99	0	1	260	2989897	2989638	Aquipseudomonas alcaligenes strain NEB 585, complete genome	blastn	25522	470	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas alcaligenes
22666817	22666817	PRJEB43370_P_NODE_10638_length_162_cov_0.920354_g10595_i0	PRJEB43370	10638	162	0.920354	1.49097348	Alicycliphilus	201096	Bacteria	Bacteria	159	7.72e-35	NTclustered	gi\|1832644504\|gb\|CP051298.1\|	179636	g10595	i0	85.093	6.51851851851852	161	18	98	6	1	158	2047613	2047770	Alicycliphilus denitrificans strain DP3 chromosome, complete genome	blastn	1056	159	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Alicycliphilus	Alicycliphilus denitrificans
23012134	23012134	PRJEB43370_P_NODE_11079_length_159_cov_2.054545_g11036_i0	PRJEB43370	11079	159	2.054545	3.26672655	Melaminivora suipulveris	2109913	Bacteria	Bacteria	95.3	2.16e-15	NTclustered	gi\|1364841887\|gb\|CP027667.1\|	2109913	g11036	i0	78.065	10.9496855345912	155	30	96	3	1	153	622277	622125	Melaminivora suipulveris strain SC2-9 chromosome, complete genome	blastn	1741	95.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Melaminivora	Melaminivora suipulveris
23942250	23942250	PRJEB43370_P_NODE_399_length_669_cov_7.611290_g359_i0	PRJEB43370	399	669	7.61129	50.9195301	Aeromonas	642	Bacteria	Bacteria	1042	0	NTclustered	gi\|2489112687\|gb\|CP121833.1\|	654	g359	i0	94.784	834.116591928251	671	32	100	3	1	669	3834774	3834105	Aeromonas veronii strain ANYA 18644 chromosome, complete genome	blastn	558024	1042	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
23942257	23942257	PRJEB43370_P_NODE_7619_length_169_cov_0.866667_g7576_i0	PRJEB43370	7619	169	0.866667	1.46466723	Sutterella	40544	Bacteria	Bacteria	278	2.14e-70	NTclustered	gi\|1997760568\|emb\|LR994475.1\|	286133	g7576	i0	96.429	244.414201183432	168	6	99	0	2	169	734663	734830	uncultured Sutterella sp. isolate Sutterella canine HQ MAG genome assembly, chromosome: 1	blastn	41306	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sutterellaceae	Sutterella	uncultured Sutterella sp.
24286055	24286055	PRJEB43370_P_NODE_9560_length_165_cov_0.896552_g9517_i0	PRJEB43370	9560	165	0.896552	1.4793108	Herbaspirillum huttiense	863372	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2735198065\|gb\|CP156025.1\|	863372	g9517	i0	100	69.4424242424242	165	0	100	0	1	165	3018721	3018885	Herbaspirillum huttiense strain CLJ01 chromosome, complete genome	blastn	11458	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum huttiense
25216041	25216041	PRJEB43370_P_NODE_1140_length_408_cov_5.058496_g1097_i0	PRJEB43370	1140	408	5.058496	20.63866368	Pseudomonadati	3379134	Bacteria	Bacteria	60.2	2.34e-4	NTclustered	gi\|1551772302\|gb\|CP025069.1\|	518	g1097	i0	92.683	1.73039215686275	41	3	10	0	146	186	4416915	4416875	Bordetella bronchiseptica strain I124 chromosome, complete genome	blastn	706	60.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Bordetella	Bordetella bronchiseptica
25216042	25216042	PRJEB43370_P_NODE_3060_length_248_cov_2.814070_g3017_i0	PRJEB43370	3060	248	2.81407	6.9788936	Aeromonas	642	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2212808653\|gb\|CP045501.1\|	644	g3017	i0	99.597	910.923387096774	248	1	100	0	1	248	88783	89030	Aeromonas hydrophila strain Aer_Pi25.1HTAS chromosome, complete genome	blastn	225909	453	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
25216048	25216048	PRJEB43370_P_NODE_5040_length_201_cov_1.664474_g4997_i0	PRJEB43370	5040	201	1.664474	3.34559274	Acinetobacter	469	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|1537789200\|gb\|CP032135.1\|	29430	g4997	i0	100	616.009950248756	201	0	100	0	1	201	354218	354018	Acinetobacter haemolyticus strain sz1652 chromosome, complete genome	blastn	123818	372	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter haemolyticus

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