metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA207719" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA207719" 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
367049	367049	PRJNA207719_P_NODE_1321_length_153_cov_1.637097_g1301_i0	PRJNA207719	1321	153	1.637097	2.50475841	Bradyrhizobium sp. SK17	2057741	Bacteria	Bacteria	272	8.84e-69	NTclustered	gi\|1304130835\|gb\|CP025113.1\|	2057741	g1301	i0	98.693	60.8104575163399	153	2	100	0	1	153	5259343	5259495	Bradyrhizobium sp. SK17 chromosome, complete genome	blastn	9304	272	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. SK17
367050	367050	PRJNA207719_P_NODE_181_length_515_cov_14.670782_g161_i0	PRJNA207719	181	515	14.670782	75.5545273	Acinetobacter johnsonii	40214	Bacteria	Bacteria	813	0	NTclustered	gi\|1934492808\|gb\|CP059080.1\|	40214	g161	i0	95.174	584.320388349515	518	19	99	5	1	514	29402	29917	Acinetobacter johnsonii strain E10B chromosome, complete genome	blastn	300925	813	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
1056079	1056079	PRJNA207719_P_NODE_901_length_202_cov_1.398844_g881_i0	PRJNA207719	901	202	1.398844	2.82566488	root	1	Root_unresolved	Root_unresolved	374	3.3e-99	NTclustered	gi\|2706519156\|gb\|CP149578.1\|	287	g881	i0	100	100	202	0	100	0	1	202	6007784	6007583	Mutant Pseudomonas aeruginosa isolate FELIX_MS413, complete genome	blastn	20200	374	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
1641852	1641852	PRJNA207719_P_NODE_962_length_194_cov_2.800000_g942_i0	PRJNA207719	962	194	2.8	5.432	Sphingomonas psychrotolerans	1327635	Bacteria	Bacteria	176	9.52e-40	NTclustered	gi\|1280029430\|gb\|CP024923.1\|	1327635	g942	i0	87.5	1.35051546391753	152	19	78	0	4	155	4849227	4849076	Sphingomonas psychrotolerans strain Cra20 chromosome, complete genome	blastn	262	176	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas psychrotolerans
3606518	3606518	PRJNA207719_P_NODE_1123_length_174_cov_4.241379_g1103_i0	PRJNA207719	1123	174	4.241379	7.37999946	Enterobacteriaceae	543	Bacteria	Bacteria	305	1.02e-78	NTclustered	gi\|1853441236\|gb\|CP054457.1\|	562	g1103	i0	99.405	664.028735632184	168	1	100	0	7	174	4647268	4647101	Escherichia coli strain SCU-103 chromosome, complete genome	blastn	115541	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3606519	3606519	PRJNA207719_P_NODE_1283_length_156_cov_2.952756_g1263_i0	PRJNA207719	1283	156	2.952756	4.60629936	Brevundimonas	41275	Bacteria	Bacteria	228	1.9899999999999994e-55	NTclustered	gi\|2210243209\|gb\|CP073063.1\|	293	g1263	i0	98.45	165.429487179487	129	2	83	0	28	156	300577	300449	Brevundimonas diminuta strain KX-1 chromosome, complete genome	blastn	25807	228	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	Brevundimonas diminuta
3606520	3606520	PRJNA207719_P_NODE_283_length_402_cov_8.327078_g263_i0	PRJNA207719	283	402	8.327078	33.47485356	root	1	Root_unresolved	Root_unresolved	446	1.51e-120	NTclustered	gi\|2841922414\|gb\|CP163901.1\|	562	g263	i0	100	425.084577114428	241	0	90	0	1	241	2298506	2298266	Escherichia coli strain OXEC-129 chromosome, complete genome	blastn	170884	446	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3606523	3606523	PRJNA207719_P_NODE_663_length_245_cov_2.217593_g643_i0	PRJNA207719	663	245	2.217593	5.43310285	Escherichia	561	Bacteria	Bacteria	379	8.929999999999999e-101	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g643	i0	92.885	103.265306122449	253	10	100	1	1	245	4579853	4580105	Escherichia coli strain Case 2 chromosome, complete genome	blastn	25300	379	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4883999	4883999	PRJNA207719_P_NODE_524_length_283_cov_3.562992_g504_i0	PRJNA207719	524	283	3.562992	10.08326736	Variovorax	34072	Bacteria	Bacteria	472	1.6899999999999998e-128	NTclustered	gi\|1972901683\|gb\|CP063167.1\|	34073	g504	i0	96.842	196.466431095406	285	4	100	4	1	283	487794	488075	Variovorax paradoxus strain VAI-C plasmid unnamed, complete sequence	blastn	55600	472	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
6158748	6158748	PRJNA207719_P_NODE_105_length_679_cov_6.344615_g92_i0	PRJNA207719	105	679	6.344615	43.07993585	Escherichia	561	Bacteria	Bacteria	1079	0	NTclustered	gi\|1820521241\|emb\|LR782231.1\|	562	g92	i0	95.301	661.659793814433	681	30	100	2	1	679	3091678	3092358	Escherichia coli isolate SC457 genome assembly, chromosome: omosome1	blastn	449267	1079	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
6158751	6158751	PRJNA207719_P_NODE_525_length_283_cov_2.814961_g505_i0	PRJNA207719	525	283	2.814961	7.96633963	Comamonadaceae	80864	Bacteria	Bacteria	496	1e-135	NTclustered	gi\|2548169491\|gb\|CP129672.1\|	285	g505	i0	98.233	377.805653710247	283	5	100	0	1	283	1249057	1249339	Comamonas testosteroni strain MWF001 chromosome, complete genome	blastn	106919	496	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas testosteroni
8708725	8708725	PRJNA207719_P_NODE_1287_length_156_cov_1.212598_g1267_i0	PRJNA207719	1287	156	1.212598	1.89165288	Variovorax	34072	Bacteria	Bacteria	267	4.2199999999999997e-67	NTclustered	gi\|1370750327\|gb\|CP027773.1\|	2126319	g1267	i0	97.436	6.98717948717949	156	4	100	0	1	156	750471	750626	Variovorax sp. PMC12 chromosome 1, complete sequence	blastn	1090	267	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PMC12
9984126	9984126	PRJNA207719_P_NODE_1108_length_176_cov_3.102041_g1088_i0	PRJNA207719	1108	176	3.102041	5.45959216	root	1	Root_unresolved	Root_unresolved	326	7.92e-85	NTclustered	gi\|2703326990\|gb\|CP148752.1\|	294	g1088	i0	100	492.982954545455	176	0	100	0	1	176	113885	114060	Pseudomonas fluorescens strain AB1 chromosome, complete genome	blastn	86765	326	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
9984127	9984127	PRJNA207719_P_NODE_1228_length_162_cov_3.270677_g1208_i0	PRJNA207719	1228	162	3.270677	5.29849674	Paracoccus	265	Bacteria	Bacteria	289	9.44e-74	NTclustered	gi\|2800751226\|gb\|CP089416.1\|	59779	g1208	i0	98.765	183.327160493827	162	2	100	0	1	162	294785	294946	Paracoccus marcusii strain 3501 chromosome, complete genome	blastn	29699	289	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus marcusii
9984130	9984130	PRJNA207719_P_NODE_888_length_204_cov_2.662857_g868_i0	PRJNA207719	888	204	2.662857	5.43222828	Brevundimonas	41275	Bacteria	Bacteria	366	5.599999999999998e-97	NTclustered	gi\|2713775843\|gb\|CP150643.1\|	293	g868	i0	99.02	171.96568627451	204	2	100	0	1	204	348070	348273	Brevundimonas diminuta strain HAU429 chromosome, complete genome	blastn	35081	366	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Brevundimonas	Brevundimonas diminuta
10571132	10571132	PRJNA207719_P_NODE_1309_length_154_cov_2.200000_g1289_i0	PRJNA207719	1309	154	2.2	3.388	Burkholderia contaminans	488447	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|2031351090\|gb\|CP073665.1\|	488447	g1289	i0	100	2	154	0	100	0	1	154	1225744	1225591	Burkholderia contaminans strain toggle1 chromosome 2, complete sequence	blastn	308	285	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia contaminans
12534644	12534644	PRJNA207719_P_NODE_410_length_326_cov_2.468013_g390_i0	PRJNA207719	410	326	2.468013	8.04572238	Enterobacteriaceae	543	Bacteria	Bacteria	603	6.749999999999998e-168	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g390	i0	100	100	326	0	100	0	1	326	174916	174591	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	32600	603	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
13120878	13120878	PRJNA207719_P_NODE_471_length_304_cov_6.501818_g451_i0	PRJNA207719	471	304	6.501818	19.76552672	Novosphingobium sp. 9	2025349	Bacteria	Bacteria	274	5.55e-69	NTclustered	gi\|2306411446\|gb\|CP022707.1\|	2025349	g451	i0	98.089	56.3552631578947	157	3	52	0	9	165	676705	676861	Novosphingobium sp. 9 chromosome 1, complete sequence	blastn	17132	274	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium sp. 9
13809443	13809443	PRJNA207719_P_NODE_251_length_429_cov_10.427500_g231_i0	PRJNA207719	251	429	10.4275	44.733975	Gammaproteobacteria	1236	Bacteria	Bacteria	566	1.2e-156	NTclustered	gi\|1364849610\|gb\|CP027657.1\|	300	g231	i0	90.553	577.254079254079	434	32	100	7	1	429	1090753	1090324	Ectopseudomonas mendocina strain NEB698 chromosome, complete genome	blastn	247642	566	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas mendocina
15083602	15083602	PRJNA207719_P_NODE_792_length_220_cov_2.073298_g772_i0	PRJNA207719	792	220	2.073298	4.5612556	Enterobacteriaceae	543	Bacteria	Bacteria	224	3.9e-54	NTclustered	gi\|2161252967\|gb\|CP088071.1\|	562	g772	i0	100	95.4545454545455	121	0	95	0	100	220	175641	175521	Escherichia coli strain 427603 chromosome, complete genome	blastn	21000	224	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16944348	16944348	PRJNA207719_P_NODE_1174_length_169_cov_1.600000_g1154_i0	PRJNA207719	1174	169	1.6	2.704	Bradyrhizobium sp. SK17	2057741	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1304130835\|gb\|CP025113.1\|	2057741	g1154	i0	100	96.414201183432	169	0	100	0	1	169	1875331	1875499	Bradyrhizobium sp. SK17 chromosome, complete genome	blastn	16294	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Bradyrhizobium	Bradyrhizobium sp. SK17
17633645	17633645	PRJNA207719_P_NODE_1154_length_172_cov_2.153846_g1134_i0	PRJNA207719	1154	172	2.153846	3.70461512	Enterobacteriaceae	543	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g1134	i0	100	100	172	0	100	0	1	172	4579379	4579550	Escherichia coli strain Case 2 chromosome, complete genome	blastn	17200	318	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20768582	20768582	PRJNA207719_P_NODE_1137_length_173_cov_8.402778_g1117_i0	PRJNA207719	1137	173	8.402778	14.53680594	Aeromonas dhakensis	196024	Bacteria	Bacteria	276	7.92e-70	NTclustered	gi\|2894571655\|gb\|CP178405.1\|	196024	g1117	i0	95.376	855.173410404624	173	8	100	0	1	173	960724	960552	Aeromonas dhakensis strain BAR-OCT chromosome	blastn	147945	276	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas dhakensis
23319142	23319142	PRJNA207719_P_NODE_339_length_369_cov_8.273529_g319_i0	PRJNA207719	339	369	8.273529	30.52932201	Dyella japonica	231455	Bacteria	Bacteria	438	2.3e-118	NTclustered	gi\|664782987\|gb\|CP008884.1\|	1217721	g319	i0	88.108	180.663956639566	370	43	100	1	1	369	672925	672556	Dyella japonica A8, complete genome	blastn	66665	438	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Dyella	Dyella japonica
25282109	25282109	PRJNA207719_P_NODE_1320_length_153_cov_1.782258_g1300_i0	PRJNA207719	1320	153	1.782258	2.72685474	root	1	Root_unresolved	Root_unresolved	279	5.28e-71	NTclustered	gi\|2706519156\|gb\|CP149578.1\|	287	g1300	i0	100	99.6797385620915	151	0	99	0	3	153	6007888	6008038	Mutant Pseudomonas aeruginosa isolate FELIX_MS413, complete genome	blastn	15251	279	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
25282110	25282110	PRJNA207719_P_NODE_960_length_194_cov_3.200000_g940_i0	PRJNA207719	960	194	3.2	6.208	Klebsiella	570	Bacteria	Bacteria	278	2.54e-70	NTclustered	gi\|1927384602\|emb\|LR890312.1\|	571	g940	i0	92.5	754.345360824742	200	5	100	8	1	194	1369241	1369046	Klebsiella oxytoca isolate MSB1_10D-sc-2280340 genome assembly, chromosome: 1	blastn	146343	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella oxytoca

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