metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA699078" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA699078" 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
1184145	1184145	PRJNA699078_S_NODE_99221_length_168_cov_0.873950_g98272_i0	PRJNA699078	99221	168	0.87395	1.468236	Variovorax	34072	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|1913357307\|gb\|CP062121.1\|	2774875	g98272	i0	98.214	16.8392857142857	168	3	100	0	1	168	576786	576953	Variovorax sp. 38R chromosome, complete genome	blastn	2829	294	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. 38R
1958936	1958936	PRJNA699078_S_NODE_89822_length_176_cov_2.062992_g88873_i0	PRJNA699078	89822	176	2.062992	3.63086592	Methylorubrum extorquens	408	Bacteria	Bacteria	78.7	2.45e-10	NTclustered	gi\|240011718\|gb\|CP001511.1\|	272630	g88873	i0	82.796	0.528409090909091	93	10	51	6	42	131	270939	270850	Methylobacterium extorquens AM1 megaplasmid, complete sequence	blastn	93	78.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylorubrum	Methylorubrum extorquens
3232995	3232995	PRJNA699078_S_NODE_29863_length_315_cov_2.548872_g28914_i0	PRJNA699078	29863	315	2.548872	8.0289468	Delftia acidovorans	80866	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1943113412\|gb\|CP065627.1\|	80866	g28914	i0	100	0.0888888888888889	28	0	9	0	250	277	3911761	3911788	Delftia acidovorans strain FDAARGOS_939 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia acidovorans
3233091	3233091	PRJNA699078_S_NODE_36263_length_287_cov_3.289916_g35314_i0	PRJNA699078	36263	287	3.289916	9.44205892	Sphingopyxis sp. EG6	1874061	Bacteria	Bacteria	364	2.9999999999999993e-96	NTclustered	gi\|1417740650\|dbj\|AP017603.1\|	1874061	g35314	i0	91.078	0.937282229965157	269	24	94	0	19	287	1548932	1548664	Sphingopyxis sp. EG6 DNA, complete genome	blastn	269	364	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingopyxis	Sphingopyxis sp. EG6
3233769	3233769	PRJNA699078_S_NODE_79203_length_189_cov_1.057143_g78254_i0	PRJNA699078	79203	189	1.057143	1.99800027	Variovorax sp. Varisp41	3243033	Bacteria	Bacteria	150	5.59e-32	NTclustered	gi\|2897244045\|gb\|CP168540.1\|	3243033	g78254	i0	88.618	0.835978835978836	123	14	65	0	1	123	6725647	6725769	Variovorax sp. Varisp41 strain CT11-41 chromosome 1, complete sequence	blastn	158	150	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. Varisp41
5012391	5012391	PRJNA699078_S_NODE_36724_length_285_cov_4.834746_g35775_i0	PRJNA699078	36724	285	4.834746	13.7790261	Xanthomonas	338	Bacteria	Bacteria	62.1	4.37e-5	NTclustered	gi\|2786213386\|gb\|CP162490.1\|	3160839	g35775	i0	92.857	1.82456140350877	42	3	15	0	128	169	658725	658766	Xanthomonas sp. DAR 34887 chromosome, complete genome	blastn	520	62.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Xanthomonas	Xanthomonas tesorieronis
5786457	5786457	PRJNA699078_S_NODE_91205_length_175_cov_1.238095_g90256_i0	PRJNA699078	91205	175	1.238095	2.16666625	Variovorax paradoxus	34073	Bacteria	Bacteria	307	2.8500000000000004e-79	NTclustered	gi\|2921529653\|gb\|CP157635.1\|	34073	g90256	i0	98.286	1	175	3	100	0	1	175	227	401	Variovorax paradoxus strain 110B chromosome 2, complete sequence	blastn	175	307	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
5786512	5786512	PRJNA699078_S_NODE_95445_length_171_cov_1.008197_g94496_i0	PRJNA699078	95445	171	1.008197	1.72401687	Burkholderiales bacterium YL45	1834205	Bacteria	Bacteria	315	1.65e-81	NTclustered	gi\|1173528573\|gb\|CP015403.2\|	1834205	g94496	i0	100	269.315789473684	170	0	99	0	2	171	751216	751047	Burkholderiales bacterium YL45 chromosome, complete genome	blastn	46053	315	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium YL45
7061358	7061358	PRJNA699078_S_NODE_78906_length_189_cov_1.485714_g77957_i0	PRJNA699078	78906	189	1.485714	2.80799946	Stappiaceae bacterium	2952973	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2891482222\|emb\|OZ219955.1\|	2952973	g77957	i0	100	0.592592592592593	28	0	15	0	16	43	59895	59868	MAG: Stappiaceae bacterium isolate 2e4ab203-d541-464b-9f6f-4552e35f8f23 genome assembly, chromosome: 4	blastn	112	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Stappiaceae		Stappiaceae bacterium
7061637	7061637	PRJNA699078_S_NODE_97886_length_169_cov_0.866667_g96937_i0	PRJNA699078	97886	169	0.866667	1.46466723	Variovorax sp. PAMC26660	2762322	Bacteria	Bacteria	263	5.989999999999999e-66	NTclustered	gi\|1896689433\|gb\|CP060295.1\|	2762322	g96937	i0	94.675	47.6272189349112	169	9	100	0	1	169	4309482	4309314	Variovorax sp. PAMC26660 chromosome, complete genome	blastn	8049	263	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PAMC26660
9610873	9610873	PRJNA699078_S_NODE_54408_length_231_cov_1.582418_g53459_i0	PRJNA699078	54408	231	1.582418	3.65538558	Rhizobium tumorigenes	2041385	Bacteria	Bacteria	309	1.11e-79	NTclustered	gi\|2490899830\|gb\|CP117255.1\|	2041385	g53459	i0	91.189	168.935064935065	227	20	98	0	1	227	2665181	2665407	Rhizobium tumorigenes strain 1078 chromosome, complete genome	blastn	39024	309	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium tumorigenes
10887019	10887019	PRJNA699078_S_NODE_89249_length_177_cov_1.375000_g88300_i0	PRJNA699078	89249	177	1.375	2.43375	Sphingomonas aliaeris	2759526	Bacteria	Bacteria	285	1.3499999999999998e-72	NTclustered	gi\|1958866958\|gb\|CP061037.1\|	2759526	g88300	i0	96	1.92655367231638	175	7	99	0	1	175	110612	110786	Sphingomonas aliaeris strain DH-S5 plasmid punnamed2, complete sequence	blastn	341	285	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas aliaeris
11387665	11387665	PRJNA699078_S_NODE_19829_length_374_cov_11.027692_g18880_i0	PRJNA699078	19829	374	11.027692	41.24356808	Pseudomonadaceae	135621	Bacteria	Bacteria	640	5.969999999999999e-179	NTclustered	gi\|2798691846\|gb\|CP166923.2\|	301	g18880	i0	99.713	492.708556149733	349	1	93	0	1	349	1100307	1099959	Ectopseudomonas oleovorans strain ERA chromosome, complete genome	blastn	184273	645	0.992248062015504	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas oleovorans
12663585	12663585	PRJNA699078_S_NODE_107430_length_162_cov_1.504425_g106481_i0	PRJNA699078	107430	162	1.504425	2.4371685	Pseudomonadaceae	135621	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1539751175\|emb\|LR134290.1\|	300	g106481	i0	99.383	467.746913580247	162	1	100	0	1	162	4441585	4441424	Pseudomonas mendocina strain NCTC10897 genome assembly, chromosome: 1	blastn	75775	294	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas mendocina
12663607	12663607	PRJNA699078_S_NODE_3450_length_712_cov_2.457014_g2775_i0	PRJNA699078	3450	712	2.457014	17.49393968	Enterobacteriaceae	543	Bacteria	Bacteria	1315	0	NTclustered	gi\|2588984424\|gb\|CP135658.1\|	562	g2775	i0	100	687.772471910112	712	0	100	0	1	712	1525226	1525937	Escherichia coli strain TUM10008 chromosome, complete genome	blastn	489694	1315	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
12663632	12663632	PRJNA699078_S_NODE_74310_length_195_cov_1.842466_g73361_i0	PRJNA699078	74310	195	1.842466	3.5928087	root	1	Root_unresolved	Root_unresolved	361	2.46e-95	NTclustered	gi\|1370526425\|gb\|CP027376.1\|	562	g73361	i0	100	336.564102564103	195	0	100	0	1	195	2409891	2409697	Escherichia coli strain 2013C-4404 chromosome, complete genome	blastn	65630	361	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
12663643	12663643	PRJNA699078_S_NODE_90790_length_175_cov_2.000000_g89841_i0	PRJNA699078	90790	175	2	3.5	Variovorax	34072	Bacteria	Bacteria	219	1.37e-52	NTclustered	gi\|2741163780\|dbj\|AP028666.1\|	3065956	g89841	i0	90.361	2.84571428571429	166	16	95	0	8	173	6042224	6042059	Variovorax sp. V35 DNA, complete genome	blastn	498	219	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. V35
13436317	13436317	PRJNA699078_S_NODE_62951_length_213_cov_1.609756_g62002_i0	PRJNA699078	62951	213	1.609756	3.42878028	Vibrio chagasii	170679	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2271101966\|dbj\|AP025465.1\|	170679	g62002	i0	100	0.131455399061033	28	0	13	0	56	83	2357394	2357421	Vibrio chagasii LMG 21353 DNA, chromosome 1, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio chagasii
13938065	13938065	PRJNA699078_S_NODE_73811_length_196_cov_1.312925_g72862_i0	PRJNA699078	73811	196	1.312925	2.573333	Variovorax	34072	Bacteria	Bacteria	230	7.299999999999999e-56	NTclustered	gi\|2189435386\|gb\|CP091716.1\|	34073	g72862	i0	89.888	22.0612244897959	178	18	91	0	19	196	7617977	7617800	Variovorax paradoxus strain IPSP_MA_2 chromosome	blastn	4324	230	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
14711590	14711590	PRJNA699078_S_NODE_68592_length_204_cov_0.903226_g67643_i0	PRJNA699078	68592	204	0.903226	1.84258104	Variovorax sp. PAMC26660	2762322	Bacteria	Bacteria	361	2.6e-95	NTclustered	gi\|1896689433\|gb\|CP060295.1\|	2762322	g67643	i0	98.529	46.5343137254902	204	3	100	0	1	204	6755371	6755574	Variovorax sp. PAMC26660 chromosome, complete genome	blastn	9493	361	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PAMC26660
15985089	15985089	PRJNA699078_S_NODE_56253_length_227_cov_1.168539_g55304_i0	PRJNA699078	56253	227	1.168539	2.65258353	Variovorax sp. PAMC26660	2762322	Bacteria	Bacteria	169	1.92e-37	NTclustered	gi\|1896689433\|gb\|CP060295.1\|	2762322	g55304	i0	85.625	1.06607929515419	160	23	70	0	67	226	7152944	7153103	Variovorax sp. PAMC26660 chromosome, complete genome	blastn	242	169	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PAMC26660
16487075	16487075	PRJNA699078_S_NODE_97213_length_169_cov_1.250000_g96264_i0	PRJNA699078	97213	169	1.25	2.1125	Burkholderia	32008	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2090904009\|gb\|CP082808.1\|	488447	g96264	i0	100	100	169	0	100	0	1	169	889038	888870	Burkholderia contaminans strain SCAID TST1-2021 (11/270) chromosome 2, complete sequence	blastn	16900	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia contaminans
17761922	17761922	PRJNA699078_S_NODE_38514_length_278_cov_8.834061_g37565_i0	PRJNA699078	38514	278	8.834061	24.55868958	Enterobacteriaceae	543	Bacteria	Bacteria	472	1.6599999999999998e-128	NTclustered	gi\|2618357005\|gb\|CP137721.1\|	562	g37565	i0	100	628.197841726619	255	0	92	0	1	255	5149719	5149973	Escherichia coli strain HNTH2207 chromosome	blastn	174639	472	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19035893	19035893	PRJNA699078_S_NODE_33855_length_297_cov_2.096774_g32906_i0	PRJNA699078	33855	297	2.096774	6.22741878	Turicimonas	1918598	Bacteria	Bacteria	399	8.549999999999999e-107	NTclustered	gi\|1957935753\|gb\|CP065313.1\|	1796652	g32906	i0	100	147.292929292929	216	0	100	0	1	216	44040	43825	Turicimonas muris strain YL45 chromosome	blastn	43746	399	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sutterellaceae	Turicimonas	Turicimonas muris
19035910	19035910	PRJNA699078_S_NODE_82675_length_184_cov_3.125926_g81726_i0	PRJNA699078	82675	184	3.125926	5.75170384	Halomonas	2745	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1036082207\|emb\|LT593974.1\|	1666906	g81726	i0	100	0.304347826086957	28	0	15	0	33	60	2947681	2947708	Halomonas sp. HL-93 genome assembly, chromosome: I	blastn	56	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Halomonas	Halomonas sp. HL-93
20310451	20310451	PRJNA699078_S_NODE_50136_length_241_cov_9.786458_g49187_i0	PRJNA699078	50136	241	9.786458	23.58536378	Enterobacteriaceae	543	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g49187	i0	100	677.788381742739	241	0	100	0	1	241	78374	78614	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	163347	446	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21084204	21084204	PRJNA699078_S_NODE_14477_length_421_cov_2.384409_g13539_i0	PRJNA699078	14477	421	2.384409	10.03836189	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	472	2.63e-128	NTclustered	gi\|2893358410\|emb\|OZ220701.1\|	1913988	g13539	i0	89.446	177.619952494062	379	33	89	7	1	376	2702004	2702378	MAG: Alphaproteobacteria bacterium isolate a603a0a2-d098-4ec7-8fb6-76c879e39c7f genome assembly, chromosome: 1	blastn	74778	472	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
21084511	21084511	PRJNA699078_S_NODE_34497_length_294_cov_5.293878_g33548_i0	PRJNA699078	34497	294	5.293878	15.56400132	Acinetobacter calcoaceticus	471	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2591781342\|gb\|CP130683.1\|	471	g33548	i0	100	0.0952380952380952	28	0	10	0	254	281	1812081	1812108	Acinetobacter calcoaceticus strain AC001_UM chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter calcoaceticus
22359675	22359675	PRJNA699078_S_NODE_60198_length_218_cov_3.047337_g59249_i0	PRJNA699078	60198	218	3.047337	6.64319466	Acinetobacter baumannii	470	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2470454228\|gb\|CP113071.1\|	470	g59249	i0	100	0.770642201834862	28	0	13	0	158	185	2016407	2016380	Acinetobacter baumannii strain A118 DeltaH0N27_10830::kan chromosome, complete genome	blastn	168	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
23635854	23635854	PRJNA699078_S_NODE_88759_length_178_cov_0.844961_g87810_i0	PRJNA699078	88759	178	0.844961	1.50403058	Sodalis praecaptivus	1239307	Bacteria	Bacteria	65.8	1.93e-6	NTclustered	gi\|573019581\|gb\|CP006569.1\|	1239307	g87810	i0	93.182	0.921348314606742	44	3	25	0	12	55	648470	648427	Sodalis praecaptivus strain HS1 chromosome, complete genome	blastn	164	65.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Bruguierivoracaceae	Sodalis	Sodalis praecaptivus

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