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

26 rows where analysis = "blastn", bioproject = "PRJNA929940" 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
909143	909143	PRJNA929940_S_NODE_42881_length_170_cov_1.864662_g42646_i0	PRJNA929940	42881	170	1.864662	3.1699254	Sphingomonas aerolata	185951	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|2800730394\|gb\|CP128316.1\|	185951	g42646	i0	100	7.86470588235294	170	0	100	0	1	170	231373	231542	Sphingomonas aerolata strain 22L1PE-1 chromosome, complete genome	blastn	1337	315	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas aerolata
909144	909144	PRJNA929940_S_NODE_49621_length_161_cov_1.290323_g49386_i0	PRJNA929940	49621	161	1.290323	2.07742003	Sphingomonadaceae bacterium OTU29MARTA1	2952888	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2261004442\|gb\|CP099618.1\|	2952888	g49386	i0	100	16	161	0	100	0	1	161	58977	58817	Sphingomonadaceae bacterium OTU29MARTA1 plasmid unnamed1, complete sequence	blastn	2576	298	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae		Sphingomonadaceae bacterium OTU29MARTA1
3460014	3460014	PRJNA929940_S_NODE_5983_length_358_cov_2.205607_g5748_i0	PRJNA929940	5983	358	2.205607	7.89607306	Escherichia coli	562	Bacteria	Bacteria	638	2.0499999999999997e-178	NTclustered	gi\|2186140904\|gb\|CP091391.1\|	562	g5748	i0	98.88	715.170391061453	357	4	99	0	2	358	352665	352309	Escherichia coli strain 788309 chromosome, complete genome	blastn	256031	638	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7632918	7632918	PRJNA929940_S_NODE_13226_length_268_cov_3.666667_g12991_i0	PRJNA929940	13226	268	3.666667	9.82666756	Enterobacteriaceae	543	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g12991	i0	100	686.522388059701	268	0	100	0	1	268	277280	277013	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	183988	496	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7632919	7632919	PRJNA929940_S_NODE_38406_length_178_cov_1.134752_g38171_i0	PRJNA929940	38406	178	1.134752	2.01985856	Alphaproteobacteria	28211	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1882670233\|dbj\|AP023328.1\|	435	g38171	i0	100	31.9606741573034	178	0	100	0	1	178	78806	78983	Acetobacter aceti JCM20276 plasmid pAAJCM20276_2 DNA, complete sequence	blastn	5689	329	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Acetobacter	Acetobacter aceti
8907585	8907585	PRJNA929940_S_NODE_40167_length_175_cov_1.021739_g39932_i0	PRJNA929940	40167	175	1.021739	1.78804325	Alphaproteobacteria	28211	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|1024846298\|dbj\|AP014813.1\|	223967	g39932	i0	100	18.4228571428571	175	0	100	0	1	175	34283	34109	Methylobacterium populi plasmid pMPPM04 DNA, complete genome	blastn	3224	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylorubrum	Methylorubrum populi
8907586	8907586	PRJNA929940_S_NODE_4847_length_386_cov_1.785100_g4612_i0	PRJNA929940	4847	386	1.7851	6.890486	Enterobacteriaceae	543	Bacteria	Bacteria	558	1.78e-154	NTclustered	gi\|2913125668\|gb\|CP180624.1\|	562	g4612	i0	92.545	684.30310880829	389	23	100	6	1	386	2727031	2727416	Escherichia coli strain UPMP2439 chromosome	blastn	264141	562	0.99288256227758	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
9837107	9837107	PRJNA929940_S_NODE_29608_length_197_cov_0.975000_g29373_i0	PRJNA929940	29608	197	0.975	1.92075	Sphingomonas aerolata	185951	Bacteria	Bacteria	291	3.32e-74	NTclustered	gi\|2800730394\|gb\|CP128316.1\|	185951	g29373	i0	96.067	0.903553299492386	178	7	90	0	10	187	756676	756853	Sphingomonas aerolata strain 22L1PE-1 chromosome, complete genome	blastn	178	291	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas aerolata
10183463	10183463	PRJNA929940_S_NODE_43568_length_169_cov_1.969697_g43333_i0	PRJNA929940	43568	169	1.969697	3.32878793	Alphaproteobacteria	28211	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1882670233\|dbj\|AP023328.1\|	435	g43333	i0	100	34.810650887574	169	0	100	0	1	169	80112	80280	Acetobacter aceti JCM20276 plasmid pAAJCM20276_2 DNA, complete sequence	blastn	5883	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Acetobacter	Acetobacter aceti
11458520	11458520	PRJNA929940_S_NODE_42069_length_171_cov_2.716418_g41834_i0	PRJNA929940	42069	171	2.716418	4.64507478	root	1	Root_unresolved	Root_unresolved	316	4.6e-82	NTclustered	gi\|1004607049\|gb\|KT865757.1\|	12917	g41834	i0	100	331.005847953216	171	0	100	0	1	171	1131	1301	Acidovorax facilis strain DSM 649 23S ribosomal RNA gene, partial sequence	blastn	56602	316	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax facilis
12388287	12388287	PRJNA929940_S_NODE_55850_length_154_cov_0.991453_g55615_i0	PRJNA929940	55850	154	0.991453	1.52683762	Sphingobium sp. JS3065	2970925	Bacteria	Bacteria	268	1.15e-67	NTclustered	gi\|2359238760\|gb\|CP102667.1\|	2970925	g55615	i0	98.052	7	154	3	100	0	1	154	43240	43393	Sphingobium sp. JS3065 plasmid pNIN2, complete sequence	blastn	1078	268	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingobium	Sphingobium sp. JS3065
13662762	13662762	PRJNA929940_S_NODE_33531_length_187_cov_3.880000_g33296_i0	PRJNA929940	33531	187	3.88	7.2556	Acinetobacter baumannii	470	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2470454228\|gb\|CP113071.1\|	470	g33296	i0	100	0.898395721925134	28	0	15	0	30	57	2016380	2016407	Acinetobacter baumannii strain A118 DeltaH0N27_10830::kan chromosome, complete genome	blastn	168	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
13662764	13662764	PRJNA929940_S_NODE_40111_length_175_cov_1.311594_g39876_i0	PRJNA929940	40111	175	1.311594	2.2952895	Sphingomonas aerolata	185951	Bacteria	Bacteria	307	2.8500000000000004e-79	NTclustered	gi\|2800730394\|gb\|CP128316.1\|	185951	g39876	i0	98.286	2	175	3	100	0	1	175	15395	15221	Sphingomonas aerolata strain 22L1PE-1 chromosome, complete genome	blastn	350	307	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas aerolata
14008777	14008777	PRJNA929940_S_NODE_16571_length_246_cov_4.315789_g16336_i0	PRJNA929940	16571	246	4.315789	10.61684094	root	1	Root_unresolved	Root_unresolved	409	1.1399999999999998e-109	NTclustered	gi\|2842886548\|gb\|CP171997.1\|	47920	g16336	i0	96.748	383.617886178862	246	7	100	1	1	246	2316	2560	Acidovorax delafieldii strain UC81_30 chromosome, complete genome	blastn	94370	409	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax delafieldii
14937090	14937090	PRJNA929940_S_NODE_55592_length_154_cov_1.504274_g55357_i0	PRJNA929940	55592	154	1.5042739999999999	2.31658196	Comamonadaceae bacterium OTU4NAUVB1	2952996	Bacteria	Bacteria	219	1.1799999999999996e-52	NTclustered	gi\|2274984360\|gb\|CP099604.1\|	2952996	g55357	i0	92.208	1.36363636363636	154	12	100	0	1	154	266632	266785	Comamonadaceae bacterium OTU4NAUVB1 plasmid unnamed3, complete sequence	blastn	210	219	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae		Comamonadaceae bacterium OTU4NAUVB1
15282712	15282712	PRJNA929940_S_NODE_33092_length_188_cov_4.218543_g32857_i0	PRJNA929940	33092	188	4.218543	7.93086084	root	1	Root_unresolved	Root_unresolved	348	1.84e-91	NTclustered	gi\|2639837005\|gb\|PP033483.1\|	562	g32857	i0	100	202.303191489362	188	0	100	0	1	188	556	743	Escherichia coli strain k5 16S ribosomal RNA gene, partial sequence	blastn	38033	348	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20035741	20035741	PRJNA929940_S_NODE_59156_length_150_cov_2.061947_g58921_i0	PRJNA929940	59156	150	2.061947	3.0929205	Sphingomonas sp. HMP9	1517554	Bacteria	Bacteria	193	6.9e-45	NTclustered	gi\|1850108108\|dbj\|AP022673.1\|	1517554	g58921	i0	90	3.51333333333333	150	14	100	1	1	150	2952788	2952936	Sphingomonas sp. HMP9 DNA, complete genome	blastn	527	193	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. HMP9
20381130	20381130	PRJNA929940_S_NODE_18096_length_238_cov_2.960199_g17861_i0	PRJNA929940	18096	238	2.960199	7.04527362	Escherichia	561	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|2842754841\|gb\|CP163857.1\|	562	g17861	i0	100	250.004201680672	238	0	100	0	1	238	44894	44657	Escherichia coli strain OXEC-541 chromosome, complete genome	blastn	59501	440	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21311214	21311214	PRJNA929940_S_NODE_35297_length_184_cov_1.217687_g35062_i0	PRJNA929940	35297	184	1.217687	2.24054408	Sphingomonas sp. R1	399176	Bacteria	Bacteria	243	8.67e-60	NTclustered	gi\|2324437096\|gb\|CP110113.1\|	399176	g35062	i0	91.477	55.2391304347826	176	15	96	0	1	176	44496	44671	Sphingomonas sp. R1 plasmid pR1b, complete sequence	blastn	10164	243	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. R1
21311218	21311218	PRJNA929940_S_NODE_53957_length_156_cov_0.974790_g53722_i0	PRJNA929940	53957	156	0.97479	1.5206724	Sphingomonas aliaeris	2759526	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|1958866756\|gb\|CP061036.1\|	2759526	g53722	i0	100	1	156	0	100	0	1	156	11687	11842	Sphingomonas aliaeris strain DH-S5 plasmid punnamed1, complete sequence	blastn	156	289	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas aliaeris
21657062	21657062	PRJNA929940_S_NODE_30897_length_193_cov_3.512821_g30662_i0	PRJNA929940	30897	193	3.512821	6.77974453	root	1	Root_unresolved	Root_unresolved	357	3.1499999999999996e-94	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g30662	i0	100	568.025906735751	193	0	100	0	1	193	1571443	1571635	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	109629	357	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22932608	22932608	PRJNA929940_S_NODE_19138_length_233_cov_2.443878_g18903_i0	PRJNA929940	19138	233	2.443878	5.69423574	Acidovorax	12916	Bacteria	Bacteria	431	2.2899999999999996e-116	NTclustered	gi\|2842886548\|gb\|CP171997.1\|	47920	g18903	i0	100	280.364806866953	233	0	100	0	1	233	3141	2909	Acidovorax delafieldii strain UC81_30 chromosome, complete genome	blastn	65325	431	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax delafieldii
22932609	22932609	PRJNA929940_S_NODE_38838_length_177_cov_1.642857_g38603_i0	PRJNA929940	38838	177	1.642857	2.90785689	Sphingomonas	13687	Bacteria	Bacteria	327	2.2199999999999996e-85	NTclustered	gi\|1876947387\|dbj\|AP023325.1\|	13689	g38603	i0	100	8	177	0	100	0	1	177	13407	13583	Sphingomonas paucimobilis plasmid pKira_2 DNA, complete genome	blastn	1416	327	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas paucimobilis
22932610	22932610	PRJNA929940_S_NODE_41758_length_172_cov_1.474074_g41523_i0	PRJNA929940	41758	172	1.474074	2.53540728	Enterobacteriaceae	543	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|2208429280\|dbj\|AP025653.1\|	545	g41523	i0	100	668.982558139535	172	0	100	0	1	172	3663235	3663406	Citrobacter koseri TUM20903 DNA, complete genome	blastn	115065	318	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter koseri
22932611	22932611	PRJNA929940_S_NODE_43418_length_169_cov_2.446970_g43183_i0	PRJNA929940	43418	169	2.44697	4.1353793	Escherichia	561	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g43183	i0	100	688.059171597633	169	0	100	0	1	169	76774	76606	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	116282	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23861439	23861439	PRJNA929940_S_NODE_23319_length_216_cov_1.223464_g23084_i0	PRJNA929940	23319	216	1.223464	2.64268224	Sphingomonas aerolata	185951	Bacteria	Bacteria	272	1.34e-68	NTclustered	gi\|2259957152\|gb\|CP098762.1\|	185951	g23084	i0	89.401	1.00462962962963	217	21	100	2	1	216	3783194	3783409	Sphingomonas aerolata strain PDD-32b-11 chromosome, complete genome	blastn	217	272	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas aerolata

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