metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA885753" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA885753" and tax_kingdom = "Pseudomonadati"

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_clade	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
1241317	1241317	PRJNA885753_S_NODE_3321_length_261_cov_1.659574_g3303_i0	PRJNA885753	3321	261	1.659574	4.33148814	Myxococcus	32	Bacteria	Bacteria	372	1.61e-98	NTclustered	gi\|545790938\|gb\|KF270701.1\|	33	g3303	i0	92.424	248.701149425287	264	15	100	5	1	261	237	498	Myxococcus fulvus strain Mxf2 23S ribosomal RNA gene, partial sequence	blastn	64911	372	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
2516922	2516922	PRJNA885753_S_NODE_2082_length_312_cov_1.631799_g2064_i0	PRJNA885753	2082	312	1.631799	5.09121288	Flectobacillus	101	Bacteria	Bacteria	571	1.81e-158	NTclustered	gi\|4127845\|emb\|AJ011917.1\|	50419	g2064	i0	99.679	101.580128205128	312	1	100	0	1	312	1141	1452	Flectobacillus sp. 16S rRNA gene, partial, strain MWH38	blastn	31693	571	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Flectobacillus	Flectobacillus sp.
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
3412508	3412508	PRJNA885753_S_NODE_3863_length_250_cov_0.881356_g3845_i0	PRJNA885753	3863	250	0.881356	2.20339	Petrimonas mucosa	1642646	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|1088721598\|emb\|LT608328.1\|	1642646	g3845	i0	99.2	8.04	250	2	100	0	1	250	756033	755784	Petrimonas mucosa isolate ING2-E5A genome assembly, chromosome: I	blastn	2010	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Petrimonas	Petrimonas mucosa
3412511	3412511	PRJNA885753_S_NODE_3983_length_249_cov_0.869318_g3965_i0	PRJNA885753	3983	249	0.869318	2.16460182	Xiashengella succiniciproducens	2949635	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|2250061814\|gb\|CP098400.1\|	2949635	g3965	i0	97.992	1	249	5	100	0	1	249	878971	878723	Xiashengella succiniciproducens strain Ai-910 chromosome, complete genome	blastn	249	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Xiashengella	Xiashengella succiniciproducens
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
4690119	4690119	PRJNA885753_S_NODE_1884_length_325_cov_1.777778_g1866_i0	PRJNA885753	1884	325	1.777778	5.7777785	Tellurirhabdus bombi	2907205	Bacteria	Bacteria	427	4.339999999999999e-115	NTclustered	gi\|2179090906\|gb\|CP090557.1\|	2907205	g1866	i0	92.131	243.926153846154	305	21	94	3	21	325	418468	418167	Tellurirhabdus bombi strain IE-0392 chromosome, complete genome	blastn	79276	427	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Tellurirhabdus	Tellurirhabdus bombi
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
12720872	12720872	PRJNA885753_S_NODE_3210_length_264_cov_1.732984_g3192_i0	PRJNA885753	3210	264	1.732984	4.57507776	Stigmatella	40	Bacteria	Bacteria	320	5.99e-83	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g3192	i0	91.775	224.215909090909	231	17	87	2	22	251	1306	1535	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	59193	320	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
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
16164483	16164483	PRJNA885753_S_NODE_4493_length_243_cov_0.917647_g4475_i0	PRJNA885753	4493	243	0.917647	2.22988221	Fermentimonas caenicola	1562970	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g4475	i0	100	1	243	0	100	0	1	243	990705	990463	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	243	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
17439907	17439907	PRJNA885753_S_NODE_3494_length_256_cov_1.251366_g3476_i0	PRJNA885753	3494	256	1.251366	3.20349696	Spirosoma linguale	108	Bacteria	Bacteria	272	1.64e-68	NTclustered	gi\|283814236\|gb\|CP001769.1\|	504472	g3476	i0	85.985	233.72265625	264	26	99	11	2	256	6730079	6729818	Spirosoma linguale DSM 74, complete genome	blastn	59833	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma linguale
18713126	18713126	PRJNA885753_S_NODE_3695_length_252_cov_0.871508_g3677_i0	PRJNA885753	3695	252	0.871508	2.19620016	Fermentimonas caenicola	1562970	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g3677	i0	100	1	252	0	100	0	1	252	43786	44037	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	252	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
18713128	18713128	PRJNA885753_S_NODE_3875_length_250_cov_0.881356_g3857_i0	PRJNA885753	3875	250	0.881356	2.20339	Fermentimonas caenicola	1562970	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g3857	i0	99.203	1.004	251	1	100	1	1	250	2229333	2229583	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	251	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
19988373	19988373	PRJNA885753_S_NODE_3776_length_251_cov_0.876404_g3758_i0	PRJNA885753	3776	251	0.876404	2.19977404	Petrimonas mucosa	1642646	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1088721598\|emb\|LT608328.1\|	1642646	g3758	i0	100	51.8565737051793	251	0	100	0	1	251	4830	5080	Petrimonas mucosa isolate ING2-E5A genome assembly, chromosome: I	blastn	13016	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Petrimonas	Petrimonas mucosa
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
21263697	21263697	PRJNA885753_S_NODE_3077_length_268_cov_1.994872_g3059_i0	PRJNA885753	3077	268	1.994872	5.34625696	Spirosoma montaniterrae	1178516	Bacteria	Bacteria	202	2.3e-47	NTclustered	gi\|1142450876\|gb\|CP014263.1\|	1178516	g3059	i0	82.403	157.059701492537	233	39	87	2	14	245	3065563	3065332	Spirosoma montaniterrae strain DY10 chromosome, complete genome	blastn	42092	202	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma montaniterrae
21263714	21263714	PRJNA885753_S_NODE_4377_length_244_cov_0.912281_g4359_i0	PRJNA885753	4377	244	0.912281	2.22596564	Xiashengella succiniciproducens	2949635	Bacteria	Bacteria	444	3.11e-120	NTclustered	gi\|2250061814\|gb\|CP098400.1\|	2949635	g4359	i0	99.59	1	244	0	100	1	1	244	1602607	1602365	Xiashengella succiniciproducens strain Ai-910 chromosome, complete genome	blastn	244	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Marinilabiliales	Marinilabiliaceae	Xiashengella	Xiashengella succiniciproducens
21263717	21263717	PRJNA885753_S_NODE_4477_length_243_cov_0.917647_g4459_i0	PRJNA885753	4477	243	0.917647	2.22988221	Fermentimonas caenicola	1562970	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g4459	i0	98.765	1	243	3	100	0	1	243	2493407	2493649	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	243	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
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
24192875	24192875	PRJNA885753_S_NODE_3459_length_257_cov_1.173913_g3441_i0	PRJNA885753	3459	257	1.173913	3.01695641	Porphyromonas	836	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2665661841\|gb\|CP143258.1\|	867595	g3441	i0	99.611	2	257	1	100	0	1	257	2250115	2250371	Porphyromonas pogonae strain PP01-1 chromosome, complete genome	blastn	514	470	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pogonae
25087779	25087779	PRJNA885753_S_NODE_1540_length_352_cov_0.838710_g1522_i0	PRJNA885753	1540	352	0.83871	2.9522592	Fermentimonas caenicola	1562970	Bacteria	Bacteria	645	1.2e-180	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g1522	i0	99.716	1	352	1	100	0	1	352	1818882	1819233	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	352	645	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
25087818	25087818	PRJNA885753_S_NODE_4200_length_246_cov_0.901734_g4182_i0	PRJNA885753	4200	246	0.901734	2.21826564	Fermentimonas caenicola	1562970	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|697632298\|emb\|LN515532.1\|	1562970	g4182	i0	99.187	1	246	2	100	0	1	246	268317	268072	Fermentimonas caenicola genome assembly, chromosome: chrI	blastn	246	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Dysgonomonadaceae	Fermentimonas	Fermentimonas caenicola
25087821	25087821	PRJNA885753_S_NODE_4320_length_245_cov_0.906977_g4302_i0	PRJNA885753	4320	245	0.906977	2.22209365	Candidatus Cloacimonadota bacterium	2030808	Bacteria	Bacteria	291	4.3000000000000005e-74	NTclustered	gi\|2694686128\|dbj\|AP029619.1\|	2030808	g4302	i0	88.115	0.995918367346939	244	29	99	0	1	244	1595979	1596222	MAG: Candidatus Cloacimonadota bacterium ANCL-1 DNA, complete genome	blastn	244	291	1	Bacteria	FCB group	Pseudomonadati	Candidatus Cloacimonadota					Candidatus Cloacimonadota bacterium

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