metadata: contig_metadata: 17 rows where bioproject = "PRJNA885753" and tax

17 rows where bioproject = "PRJNA885753" 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
861785	861785	PRJNA885753_S_NODE_3941_length_249_cov_0.886364_g3923_i0	PRJNA885753	3941	249	0.886364	2.20704636	Pantoea agglomerans	549	Bacteria	Bacteria	427	3.2e-115	NTclustered	gi\|2667871686\|gb\|CP143414.1\|	549	g3923	i0	97.6	256.409638554217	250	4	100	2	1	249	3667098	3666850	Pantoea agglomerans strain CFBP13593 chromosome, complete genome	blastn	63846	427	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Pantoea	Pantoea agglomerans
1241316	1241316	PRJNA885753_S_NODE_2701_length_283_cov_1.971429_g2683_i0	PRJNA885753	2701	283	1.971429	5.57914407	Sphaerotilaceae	2975441	Bacteria	Bacteria	507	4.64e-139	NTclustered	gi\|2326450780\|gb\|CP110415.1\|	215580	g2683	i0	99.286	394.703180212014	280	2	99	0	1	280	2510959	2511238	Caldimonas thermodepolymerans strain LMG 21645 chromosome, complete genome	blastn	111701	512	0.990234375	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas thermodepolymerans
3412499	3412499	PRJNA885753_S_NODE_3383_length_259_cov_2.532258_g3365_i0	PRJNA885753	3383	259	2.532258	6.55854822	Herbaspirillum robiniae	2014887	Bacteria	Bacteria	479	9.13e-131	NTclustered	gi\|1158824265\|gb\|CP018845.1\|	2014887	g3365	i0	100	293.223938223938	259	0	100	0	1	259	3707865	3708123	Herbaspirillum robiniae strain AA6 chromosome, complete genome	blastn	75945	479	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum robiniae
3793282	3793282	PRJNA885753_S_NODE_763_length_480_cov_1.931204_g745_i0	PRJNA885753	763	480	1.931204	9.2697792	Acinetobacter	469	Bacteria	Bacteria	843	0	NTclustered	gi\|1934492808\|gb\|CP059080.1\|	40214	g745	i0	98.344	666.941666666667	483	3	100	3	1	480	29964	29484	Acinetobacter johnsonii strain E10B chromosome, complete genome	blastn	320132	843	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
4690152	4690152	PRJNA885753_S_NODE_4084_length_247_cov_1.701149_g4066_i0	PRJNA885753	4084	247	1.701149	4.20183803	Kosakonia radicincitans	283686	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1735494132\|gb\|CP040392.1\|	283686	g4066	i0	99.595	711.174089068826	247	1	100	0	1	247	467951	467705	Kosakonia radicincitans strain DSM 107547 chromosome, complete genome	blastn	175660	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Kosakonia	Kosakonia radicincitans
6345346	6345346	PRJNA885753_S_NODE_2885_length_275_cov_3.311881_g2867_i0	PRJNA885753	2885	275	3.311881	9.10767275	Herbaspirillum	963	Bacteria	Bacteria	479	9.78e-131	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g2867	i0	98.182	416.701818181818	275	4	100	1	1	275	522641	522368	Herbaspirillum seropedicae strain Z69 chromosome	blastn	114593	479	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
6345352	6345352	PRJNA885753_S_NODE_4185_length_246_cov_1.346821_g4167_i0	PRJNA885753	4185	246	1.346821	3.31317966	Moraxellaceae	468	Bacteria	Bacteria	451	1.87e-122	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g4167	i0	100	360.857723577236	244	0	99	0	3	246	1497853	1497610	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	88771	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
11065249	11065249	PRJNA885753_S_NODE_1829_length_329_cov_3.046875_g1811_i0	PRJNA885753	1829	329	3.046875	10.02421875	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	531	3.26e-146	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g1811	i0	95.745	384.109422492401	329	14	100	0	1	329	1529326	1529654	Undibacterium sp. YM2 DNA, complete genome	blastn	126372	531	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
11065287	11065287	PRJNA885753_S_NODE_3949_length_249_cov_0.886364_g3931_i0	PRJNA885753	3949	249	0.886364	2.20704636	Enterobacter bugandensis	881260	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2841576973\|gb\|CP143725.1\|	881260	g3931	i0	100	80.0080321285141	249	0	100	0	1	249	2837272	2837520	Enterobacter bugandensis strain ECC-105 chromosome, complete genome	blastn	19922	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter bugandensis
11445156	11445156	PRJNA885753_S_NODE_3349_length_260_cov_14.941176_g3331_i0	PRJNA885753	3349	260	14.941176	38.8470576	Pantoea	53335	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2287586186\|gb\|CP102604.1\|	2970818	g3331	i0	100	658.761538461538	260	0	100	0	1	260	234791	235050	Pantoea sp. SOD02 chromosome, complete genome	blastn	171278	481	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Pantoea	Pantoea sp. SOD02
15269276	15269276	PRJNA885753_S_NODE_4112_length_247_cov_0.896552_g4094_i0	PRJNA885753	4112	247	0.896552	2.21448344	Klebsiella	570	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2252490935\|gb\|CP077805.1\|	244366	g4094	i0	100	100	247	0	100	0	1	247	4781356	4781110	Klebsiella variicola strain FF907 chromosome, complete genome	blastn	24700	457	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella variicola
20367724	20367724	PRJNA885753_S_NODE_4476_length_243_cov_0.917647_g4458_i0	PRJNA885753	4476	243	0.917647	2.22988221	Enterobacterales	91347	Bacteria	Bacteria	265	2.58e-66	NTclustered	gi\|2319275538\|gb\|CP099540.1\|	66269	g4458	i0	86.364	98.0534979423868	242	33	99	0	1	242	3389288	3389047	Pantoea stewartii strain HR3-48 chromosome, complete genome	blastn	23827	267	0.99250936329588	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Pantoea	Pantoea stewartii
21263672	21263672	PRJNA885753_S_NODE_1637_length_343_cov_2.644444_g1619_i0	PRJNA885753	1637	343	2.644444	9.07044292	Massilia litorea	2769491	Bacteria	Bacteria	562	1.21e-155	NTclustered	gi\|1917238871\|gb\|CP062941.1\|	2769491	g1619	i0	96.21	105.466472303207	343	13	100	0	1	343	5023553	5023211	Massilia litorea strain LPB0304 chromosome, complete genome	blastn	36175	562	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia litorea
21643538	21643538	PRJNA885753_S_NODE_4657_length_237_cov_2.091463_g4639_i0	PRJNA885753	4657	237	2.091463	4.95676731	Pseudomonas	286	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|1823467278\|emb\|LR782234.1\|	294	g4639	i0	100	100.278481012658	237	0	100	0	1	237	861645	861409	Pseudomonas fluorescens isolate PfAR1 genome assembly, chromosome: 1	blastn	23766	438	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
28286979	28286979	PRJNA885753_S_NODE_2206_length_306_cov_1.004292_g2188_i0	PRJNA885753	2206	306	1.004292	3.07313352	Candidatus Propionivibrio dominans	2954373	Bacteria	Bacteria	157	1.68e-45	NR	MBK7424581.1	2954373	g2188	i0	68.3	0.990196078431373	101	32	99	0	305	3	7	107	MBK7424581.1 bifunctional DNA primase/polymerase [Candidatus Propionivibrio dominans]	diamond	303	157	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae	Propionivibrio	Candidatus Propionivibrio dominans
30876920	30876920	PRJNA885753_S_NODE_3634_length_253_cov_0.866667_g3616_i0	PRJNA885753	3634	253	0.866667	2.19266751	[Curtobacterium] plantarum	221276	Bacteria	Bacteria	119	1.6799999999999999e-29	NR	WP_122890025.1	221276	g3616	i0	70.4	0.960474308300395	81	24	96	0	245	3	109	189	WP_122890025.1 baseplate protein [[Curtobacterium] plantarum]	diamond	243	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Pantoea	[Curtobacterium] plantarum
31857005	31857005	PRJNA885753_S_NODE_2957_length_273_cov_1.160000_g2939_i0	PRJNA885753	2957	273	1.16	3.1668	Rosenbergiella epipactidis	1544694	Bacteria	Bacteria	100	9.08e-25	NR	WP_062812236.1	1544694	g2939	i0	98	0.538461538461538	49	1	53.8	0	256	110	84	132	WP_062812236.1 Z-ring associated protein ZapG [Rosenbergiella epipactidis]	diamond	147	100	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Rosenbergiella	Rosenbergiella epipactidis

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