metadata: contig_metadata: 43 rows where analysis = "blastn", bioproject = "PRJNA1215813" and tax

43 rows where analysis = "blastn", bioproject = "PRJNA1215813" 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
1045808	1045808	PRJNA1215813_P_NODE_6701_length_303_cov_1.017391_g6621_i0	PRJNA1215813	6701	303	1.017391	3.08269473	Methylophilus	16	Bacteria	Bacteria	527	3.8499999999999985e-145	NTclustered	gi\|1525772245\|gb\|CP033953.1\|	17	g6621	i0	98.02	121.874587458746	303	6	100	0	1	303	2986529	2986831	Methylophilus methylotrophus strain D22 chromosome	blastn	36928	527	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylophilus	Methylophilus methylotrophus
1606450	1606450	PRJNA1215813_P_NODE_11002_length_247_cov_0.896552_g10922_i0	PRJNA1215813	11002	247	0.896552	2.21448344	Phreatobacter cathodiphilus	1868589	Bacteria	Bacteria	84.2	7.92e-12	NTclustered	gi\|1364845349\|gb\|CP027668.1\|	1868589	g10922	i0	82.653	32.9028340080972	98	13	39	4	137	232	4352805	4352900	Phreatobacter cathodiphilus strain S-12 chromosome, complete genome	blastn	8127	84.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phreatobacteraceae	Phreatobacter	Phreatobacter cathodiphilus
2882615	2882615	PRJNA1215813_P_NODE_10023_length_251_cov_0.876404_g9943_i0	PRJNA1215813	10023	251	0.876404	2.19977404	Brucella anthropi	529	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|1929917788\|gb\|CP064062.1\|	529	g9943	i0	97.211	3	251	7	100	0	1	251	1053740	1053490	Brucella anthropi strain PBO chromosome 1, complete sequence	blastn	753	425	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
4873931	4873931	PRJNA1215813_P_NODE_10304_length_250_cov_0.881356_g10224_i0	PRJNA1215813	10304	250	0.881356	2.20339	root	1	Root_unresolved	Root_unresolved	462	8.83e-126	NTclustered	gi\|2706519156\|gb\|CP149578.1\|	287	g10224	i0	100	100	250	0	100	0	1	250	6007349	6007598	Mutant Pseudomonas aeruginosa isolate FELIX_MS413, complete genome	blastn	25000	462	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
4873951	4873951	PRJNA1215813_P_NODE_6924_length_297_cov_1.750000_g6844_i0	PRJNA1215813	6924	297	1.75	5.1975	Pseudomonadota	1224	Bacteria	Bacteria	549	8.029999999999997e-152	NTclustered	gi\|2103567975\|gb\|OK326642.1\|	479	g6844	i0	100	106	297	0	100	0	1	297	713	417	Moraxella sp. strain Y2-U-1 16S ribosomal RNA gene, partial sequence	blastn	31482	549	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Moraxella	Moraxella sp.
5434913	5434913	PRJNA1215813_P_NODE_10025_length_251_cov_0.876404_g9945_i0	PRJNA1215813	10025	251	0.876404	2.19977404	Tahibacter amnicola	2976241	Bacteria	Bacteria	69.4	2.26e-7	NTclustered	gi\|2308858809\|gb\|CP104694.1\|	2976241	g9945	i0	89.091	0.585657370517928	55	6	22	0	109	163	6240653	6240707	Tahibacter amnicola strain W38 chromosome	blastn	147	69.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Tahibacter	Tahibacter amnicola
5434945	5434945	PRJNA1215813_P_NODE_12305_length_243_cov_0.917647_g12225_i0	PRJNA1215813	12305	243	0.917647	2.22988221	Massilia varians	457921	Bacteria	Bacteria	278	3.3200000000000004e-70	NTclustered	gi\|2327757735\|dbj\|AP026966.1\|	457921	g12225	i0	88.646	7.05761316872428	229	24	94	2	1	228	506327	506100	Massilia varians N-3 DNA, complete genome	blastn	1715	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia varians
5435077	5435077	PRJNA1215813_P_NODE_7925_length_279_cov_1.422330_g7845_i0	PRJNA1215813	7925	279	1.42233	3.9683007	Methylophilus methylotrophus	17	Bacteria	Bacteria	505	1.6399999999999995e-138	NTclustered	gi\|1525772245\|gb\|CP033953.1\|	17	g7845	i0	99.283	124.73835125448	279	2	100	0	1	279	2985404	2985682	Methylophilus methylotrophus strain D22 chromosome	blastn	34802	505	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Methylophilaceae	Methylophilus	Methylophilus methylotrophus
5435095	5435095	PRJNA1215813_P_NODE_8805_length_262_cov_1.238095_g8725_i0	PRJNA1215813	8805	262	1.238095	3.2438089	uncultured Rickettsiales bacterium	219660	Bacteria	Bacteria	451	2.02e-122	NTclustered	gi\|339645770\|gb\|JN032387.1\|	219660	g8725	i0	97.71	98.381679389313	262	6	100	0	1	262	263	2	Uncultured Rickettsiales bacterium clone WeeA_E07 16S ribosomal RNA gene, partial sequence	blastn	25776	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales			uncultured Rickettsiales bacterium
6148640	6148640	PRJNA1215813_P_NODE_11845_length_244_cov_0.912281_g11765_i0	PRJNA1215813	11845	244	0.912281	2.22596564	Brucella	234	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1761803076\|gb\|CP044970.1\|	529	g11765	i0	100	16.9918032786885	244	0	100	0	1	244	2584709	2584952	Brucella anthropi strain T16R-87 chromosome 1, complete sequence	blastn	4146	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
6709652	6709652	PRJNA1215813_P_NODE_8266_length_272_cov_1.567839_g8186_i0	PRJNA1215813	8266	272	1.567839	4.26452208	Vibrio metoecus	1481663	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|2556688018\|gb\|CP129421.1\|	1481663	g8186	i0	100	898.165441176471	272	0	100	0	1	272	146276	146005	Vibrio metoecus strain ZF102 chromosome 1, complete sequence	blastn	244301	503	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio metoecus
7985249	7985249	PRJNA1215813_P_NODE_9427_length_253_cov_0.866667_g9347_i0	PRJNA1215813	9427	253	0.866667	2.19266751	Leptothrix cholodnii	34029	Bacteria	Bacteria	202	2.15e-47	NTclustered	gi\|170774137\|gb\|CP001013.1\|	395495	g9347	i0	81.933	7.56916996047431	238	43	94	0	1	238	4438053	4437816	Leptothrix cholodnii SP-6 chromosome, complete genome	blastn	1915	202	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Leptothrix	Leptothrix cholodnii
8698799	8698799	PRJNA1215813_P_NODE_11807_length_244_cov_0.912281_g11727_i0	PRJNA1215813	11807	244	0.912281	2.22596564	Brucella	234	Bacteria	Bacteria	444	3.11e-120	NTclustered	gi\|2293240145\|gb\|CP103345.1\|	529	g11727	i0	99.588	20.844262295082	243	1	99	0	1	243	876676	876918	Brucella anthropi strain CGMCC 1.17299 chromosome 1, complete sequence	blastn	5086	444	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
10535532	10535532	PRJNA1215813_P_NODE_10229_length_250_cov_0.881356_g10149_i0	PRJNA1215813	10229	250	0.881356	2.20339	Brucella anthropi	529	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1115993426\|emb\|LT671862.1\|	529	g10149	i0	100	8.016	250	0	100	0	1	250	1822396	1822147	Ochrobactrum anthropi genome assembly, chromosome: II	blastn	2004	462	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
10535614	10535614	PRJNA1215813_P_NODE_4589_length_358_cov_1.094737_g4509_i0	PRJNA1215813	4589	358	1.094737	3.91915846	Wolbachia endosymbiont of Howardula sp.	2916816	Bacteria	Bacteria	246	1.45e-60	NTclustered	gi\|2295614120\|gb\|CP092368.1\|	2916816	g4509	i0	80.818	13.5027932960894	318	57	88	4	43	358	184711	185026	Wolbachia endosymbiont of Howardula sp. isolate HA_SPA chromosome, complete genome	blastn	4834	246	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Wolbachia	Wolbachia endosymbiont of Howardula sp.
11249152	11249152	PRJNA1215813_P_NODE_11869_length_244_cov_0.912281_g11789_i0	PRJNA1215813	11869	244	0.912281	2.22596564	Limnobacter	131079	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2591690181\|dbj\|AP028947.1\|	131080	g11789	i0	100	196.733606557377	244	0	100	0	1	244	509864	510107	Limnobacter thiooxidans CS-K2 DNA, complete genome	blastn	48003	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter thiooxidans
11249155	11249155	PRJNA1215813_P_NODE_12189_length_243_cov_0.917647_g12109_i0	PRJNA1215813	12189	243	0.917647	2.22988221	Methylobacterium	407	Bacteria	Bacteria	95.3	3.59e-15	NTclustered	gi\|2731885816\|gb\|CP155000.1\|	107400	g12109	i0	100	2.50205761316872	51	0	21	0	193	243	2499244	2499294	Methylobacterium fujisawaense strain C14 chromosome, complete genome	blastn	608	95.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium fujisawaense
11810372	11810372	PRJNA1215813_P_NODE_11430_length_246_cov_0.901734_g11350_i0	PRJNA1215813	11430	246	0.901734	2.21826564	Acinetobacter bereziniae	106648	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2301648672\|gb\|CP092085.1\|	106648	g11350	i0	100	12	246	0	100	0	1	246	2508516	2508761	Acinetobacter bereziniae strain GD03393 chromosome	blastn	2952	455	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter bereziniae
12524510	12524510	PRJNA1215813_P_NODE_7450_length_287_cov_1.757009_g7370_i0	PRJNA1215813	7450	287	1.757009	5.04261583	Alcaligenes	507	Bacteria	Bacteria	483	7.94e-132	NTclustered	gi\|2422072251\|gb\|CP096916.1\|	511	g7370	i0	99.621	7.33797909407665	264	1	92	0	1	264	3764729	3764466	Alcaligenes faecalis strain NY11312 chromosome, complete genome	blastn	2106	483	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Alcaligenes	Alcaligenes faecalis
13085360	13085360	PRJNA1215813_P_NODE_11871_length_244_cov_0.912281_g11791_i0	PRJNA1215813	11871	244	0.912281	2.22596564	Hydrogenophaga sp. BPS33	2651974	Bacteria	Bacteria	292	1.19e-74	NTclustered	gi\|1796319018\|gb\|CP044549.1\|	2651974	g11791	i0	96.591	71.5	176	6	72	0	66	241	1788450	1788625	Hydrogenophaga sp. BPS33 chromosome, complete genome	blastn	17446	292	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Hydrogenophaga	Hydrogenophaga sp. BPS33
13085457	13085457	PRJNA1215813_P_NODE_6251_length_312_cov_1.305439_g6171_i0	PRJNA1215813	6251	312	1.305439	4.07296968	Limnohabitans sp. INBF002	2986280	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2378372671\|dbj\|AP027055.1\|	2986280	g6171	i0	100	0.0897435897435897	28	0	9	0	222	249	1117124	1117151	Limnohabitans sp. INBF002 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Limnohabitans	Limnohabitans sp. INBF002
13799182	13799182	PRJNA1215813_P_NODE_10251_length_250_cov_0.881356_g10171_i0	PRJNA1215813	10251	250	0.881356	2.20339	Enterobacteriaceae	543	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g10171	i0	100	157.876	250	0	100	0	1	250	3293964	3294213	Escherichia coli strain Case 2 chromosome, complete genome	blastn	39469	462	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
14360719	14360719	PRJNA1215813_P_NODE_1672_length_576_cov_1.693837_g1594_i0	PRJNA1215813	1672	576	1.693837	9.75650112	Halomonas huangheensis	1178482	Bacteria	Bacteria	54.7	0.016	NTclustered	gi\|947268313\|gb\|CP013106.1\|	1178482	g1594	i0	100	0.0503472222222222	29	0	5	0	334	362	2328521	2328493	Halomonas huangheensis strain BJGMM-B45 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Halomonas	Halomonas huangheensis
14360843	14360843	PRJNA1215813_P_NODE_9292_length_253_cov_0.866667_g9212_i0	PRJNA1215813	9292	253	0.866667	2.19266751	Piscinibacter gummiphilus	946333	Bacteria	Bacteria	278	3.48e-70	NTclustered	gi\|2592591388\|gb\|CP136336.1\|	946333	g9212	i0	89.498	87.399209486166	219	23	87	0	35	253	2922722	2922504	Piscinibacter gummiphilus strain SBD 7-3 chromosome, complete genome	blastn	22112	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Piscinibacter	Piscinibacter gummiphilus
15073407	15073407	PRJNA1215813_P_NODE_10572_length_249_cov_0.886364_g10492_i0	PRJNA1215813	10572	249	0.886364	2.20704636	Brucella	234	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1929917788\|gb\|CP064062.1\|	529	g10492	i0	100	11	249	0	100	0	1	249	477141	476893	Brucella anthropi strain PBO chromosome 1, complete sequence	blastn	2739	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
15634651	15634651	PRJNA1215813_P_NODE_12473_length_242_cov_0.923077_g12393_i0	PRJNA1215813	12473	242	0.923077	2.23384634	Hypericibacter adhaerens	2602016	Bacteria	Bacteria	165	2.68e-36	NTclustered	gi\|1752962642\|gb\|CP042582.1\|	2602016	g12393	i0	80.751	81.7231404958678	213	39	88	2	31	242	2086493	2086282	Hypericibacter adhaerens strain R5959 chromosome, complete genome	blastn	19777	165	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Dongiaceae	Hypericibacter	Hypericibacter adhaerens
16348310	16348310	PRJNA1215813_P_NODE_8173_length_274_cov_1.920398_g8093_i0	PRJNA1215813	8173	274	1.920398	5.26189052	Oxalobacteraceae	75682	Bacteria	Bacteria	161	4.01e-35	NTclustered	gi\|1638105436\|gb\|CP040017.1\|	864828	g8093	i0	77.737	6.36496350364964	274	53	99	7	5	274	4717663	4717394	Pseudoduganella umbonata strain DSMZ 26121 chromosome, complete genome	blastn	1744	161	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Pseudoduganella	Pseudoduganella umbonata
17623558	17623558	PRJNA1215813_P_NODE_10434_length_249_cov_0.886364_g10354_i0	PRJNA1215813	10434	249	0.886364	2.20704636	Acinetobacter	469	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2216409579\|gb\|CP065052.1\|	470	g10354	i0	100	79.4698795180723	249	0	100	0	1	249	64752	64504	Acinetobacter baumannii strain 2016GDAB1 plasmid p5637, complete sequence	blastn	19788	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
17623566	17623566	PRJNA1215813_P_NODE_1234_length_656_cov_17.084048_g1157_i0	PRJNA1215813	1234	656	17.084048	112.07135488	Aeromonas	642	Bacteria	Bacteria	1088	0	NTclustered	gi\|2489111879\|gb\|CP121794.1\|	648	g1157	i0	98.852	760.234756097561	610	7	93	0	1	610	2021	1412	Aeromonas caviae strain FIONA 16800 chromosome, complete genome	blastn	498714	1088	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas caviae
17623584	17623584	PRJNA1215813_P_NODE_9014_length_258_cov_1.264865_g8934_i0	PRJNA1215813	9014	258	1.264865	3.2633517	Vibrio	662	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|1858855023\|gb\|CP053808.1\|	666	g8934	i0	100	892.019379844961	258	0	100	0	1	258	48382	48639	Vibrio cholerae strain SP7G chromosome 1, complete sequence	blastn	230141	477	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio cholerae
18897330	18897330	PRJNA1215813_P_NODE_475_length_971_cov_5.488864_g425_i0	PRJNA1215813	475	971	5.488864	53.29686944	Herbaspirillum	963	Bacteria	Bacteria	1722	0	NTclustered	gi\|1510310152\|gb\|CP024996.1\|	80842	g425	i0	98.661	446.044284243048	971	13	100	0	1	971	549887	550857	Herbaspirillum rubrisubalbicans strain DSM 11543 chromosome, complete genome	blastn	433109	1733	0.993652625504905	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum rubrisubalbicans
20733271	20733271	PRJNA1215813_P_NODE_8797_length_262_cov_1.328042_g8717_i0	PRJNA1215813	8797	262	1.328042	3.47947004	Bosea sp. PAMC 26642	1792307	Bacteria	Bacteria	279	1.01e-70	NTclustered	gi\|996001510\|gb\|CP014301.1\|	1792307	g8717	i0	95.455	7.46564885496183	176	7	67	1	88	262	1824806	1824981	Bosea sp. PAMC 26642 chromosome, complete genome	blastn	1956	279	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Boseaceae	Bosea	Bosea sp. PAMC 26642
21447695	21447695	PRJNA1215813_P_NODE_12397_length_242_cov_0.923077_g12317_i0	PRJNA1215813	12397	242	0.923077	2.23384634	Brucella	234	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2293240145\|gb\|CP103345.1\|	529	g12317	i0	99.587	45.9090909090909	242	1	100	0	1	242	2622357	2622598	Brucella anthropi strain CGMCC 1.17299 chromosome 1, complete sequence	blastn	11110	442	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
22008386	22008386	PRJNA1215813_P_NODE_11058_length_247_cov_0.896552_g10978_i0	PRJNA1215813	11058	247	0.896552	2.21448344	Cupriavidus pauculus	82633	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|2221603161\|gb\|CP084279.1\|	82633	g10978	i0	99.219	6.61133603238866	128	1	52	0	120	247	2019031	2019158	Cupriavidus pauculus strain BHJ32i chromosome 1, complete sequence	blastn	1633	231	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus	Cupriavidus pauculus
22722729	22722729	PRJNA1215813_P_NODE_10718_length_248_cov_0.891429_g10638_i0	PRJNA1215813	10718	248	0.891429	2.21074392	Methylobacterium	407	Bacteria	Bacteria	457	4.07e-124	NTclustered	gi\|170652972\|gb\|CP001001.1\|	426355	g10638	i0	100	10.875	247	0	99	0	2	248	38144	37898	Methylobacterium radiotolerans JCM 2831, complete genome	blastn	2697	457	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium radiotolerans
24557950	24557950	PRJNA1215813_P_NODE_5120_length_340_cov_2.337079_g5040_i0	PRJNA1215813	5120	340	2.337079	7.9460686	Haemophilus influenzae	727	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2891654656\|gb\|CP095981.1\|	727	g5040	i0	100	0.176470588235294	30	0	9	0	230	259	317808	317779	Haemophilus influenzae strain 26.3-27 chromosome, complete genome	blastn	60	56.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus influenzae
24557963	24557963	PRJNA1215813_P_NODE_6140_length_315_cov_1.289256_g6060_i0	PRJNA1215813	6140	315	1.289256	4.0611564	Halomonas sp. Y3	2956797	Bacteria	Bacteria	58.4	6.34e-4	NTclustered	gi\|2263912048\|gb\|CP099975.1\|	2956797	g6060	i0	97.059	0.107936507936508	34	1	11	0	208	241	2737021	2736988	Halomonas sp. Y3 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Halomonas	Halomonas sp. Y3
24557992	24557992	PRJNA1215813_P_NODE_7780_length_282_cov_0.784689_g7700_i0	PRJNA1215813	7780	282	0.784689	2.21282298	Rheinheimera sp. F8	1763998	Bacteria	Bacteria	494	3.6e-135	NTclustered	gi\|975021511\|gb\|CP013656.1\|	1763998	g7700	i0	98.227	800.386524822695	282	5	100	0	1	282	418015	417734	Rheinheimera sp. F8 genome	blastn	225709	494	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. F8
24558004	24558004	PRJNA1215813_P_NODE_8660_length_265_cov_0.838542_g8580_i0	PRJNA1215813	8660	265	0.838542	2.2221363	Sphingomonas donggukensis	2949093	Bacteria	Bacteria	457	4.39e-124	NTclustered	gi\|2250064321\|gb\|CP098401.1\|	2949093	g8580	i0	97.736	191.041509433962	265	6	100	0	1	265	2271984	2271720	Sphingomonas donggukensis strain RMG20 chromosome, complete genome	blastn	50626	457	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas donggukensis
25271976	25271976	PRJNA1215813_P_NODE_10260_length_250_cov_0.881356_g10180_i0	PRJNA1215813	10260	250	0.881356	2.20339	Brucella	234	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1761803076\|gb\|CP044970.1\|	529	g10180	i0	100	18.988	250	0	100	0	1	250	1399986	1400235	Brucella anthropi strain T16R-87 chromosome 1, complete sequence	blastn	4747	462	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
25271977	25271977	PRJNA1215813_P_NODE_10540_length_249_cov_0.886364_g10460_i0	PRJNA1215813	10540	249	0.886364	2.20704636	root	1	Root_unresolved	Root_unresolved	387	5.439999999999998e-103	NTclustered	gi\|1287461093\|dbj\|LC318058.1\|	562	g10460	i0	100	84.6787148594377	209	0	84	0	41	249	2881	2673	Escherichia coli plasmid p41-3 DNA, strain: QD1-5-9, contig: p41-3_contig_009	blastn	21085	390	0.992307692307692	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25271980	25271980	PRJNA1215813_P_NODE_11020_length_247_cov_0.896552_g10940_i0	PRJNA1215813	11020	247	0.896552	2.21448344	Ralstonia	48736	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2209821455\|gb\|CP093303.1\|	190721	g10940	i0	99.595	97.0161943319838	247	1	100	0	1	247	475247	475493	Ralstonia insidiosa strain 15-1563-3 chromosome 1, complete sequence	blastn	23963	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia insidiosa
25272000	25272000	PRJNA1215813_P_NODE_8540_length_267_cov_1.340206_g8460_i0	PRJNA1215813	8540	267	1.340206	3.57835002	Brucella	234	Bacteria	Bacteria	477	3.3999999999999993e-130	NTclustered	gi\|2293240145\|gb\|CP103345.1\|	529	g8460	i0	98.876	13	267	3	100	0	1	267	970020	969754	Brucella anthropi strain CGMCC 1.17299 chromosome 1, complete sequence	blastn	3471	477	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi

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