metadata: contig_metadata: 28 rows where bioproject = "PRJNA454154" and tax

28 rows where bioproject = "PRJNA454154" 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
1093461	1093461	PRJNA454154_S_NODE_261_length_205_cov_14.416667_g258_i0	PRJNA454154	261	205	14.416667	29.55416735	Aeromonas	642	Bacteria	Bacteria	327	2.66e-85	NTclustered	gi\|2489122631\|gb\|CP121837.1\|	654	g258	i0	100	87.2146341463415	177	0	86	0	6	182	1187663	1187487	Aeromonas veronii strain ANYA 18263 chromosome, complete genome	blastn	17879	327	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
2368828	2368828	PRJNA454154_S_NODE_102_length_282_cov_11.457143_g99_i0	PRJNA454154	102	282	11.457143	32.30914326	Herbaspirillum	963	Bacteria	Bacteria	473	4.679999999999999e-129	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g99	i0	98.162	367.021276595745	272	4	96	1	11	282	521724	521994	Herbaspirillum seropedicae strain Z69 chromosome	blastn	103500	473	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
2992592	2992592	PRJNA454154_S_NODE_163_length_242_cov_4.068293_g160_i0	PRJNA454154	163	242	4.068293	9.84526906	Tahibacter sp. UC22_41	3350178	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|2814027031\|gb\|CP170554.1\|	3350178	g160	i0	97.674	208.925619834711	215	5	89	0	25	239	830924	830710	Tahibacter sp. UC22_41 chromosome, complete genome	blastn	50560	370	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Tahibacter	Tahibacter sp. UC22_41
3644451	3644451	PRJNA454154_S_NODE_443_length_177_cov_1.600000_g440_i0	PRJNA454154	443	177	1.6	2.832	Herbaspirillum	963	Bacteria	Bacteria	305	1.04e-78	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g440	i0	98.276	214.28813559322	174	3	100	0	4	177	523493	523320	Herbaspirillum seropedicae strain Z69 chromosome	blastn	37929	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
6196470	6196470	PRJNA454154_S_NODE_145_length_253_cov_9.199074_g142_i0	PRJNA454154	145	253	9.199074	23.27365722	Pseudomonadaceae	135621	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2323131394\|gb\|CP109657.1\|	287	g142	i0	100	386.00395256917	253	0	100	0	1	253	716228	716480	Pseudomonas aeruginosa strain Zw26 chromosome, complete genome	blastn	97659	468	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
6196473	6196473	PRJNA454154_S_NODE_525_length_165_cov_4.039062_g522_i0	PRJNA454154	525	165	4.039062	6.6644523	Acidovorax	12916	Bacteria	Bacteria	289	9.66e-74	NTclustered	gi\|2842886548\|gb\|CP171997.1\|	47920	g522	i0	98.182	337	165	3	100	0	1	165	2999	3163	Acidovorax delafieldii strain UC81_30 chromosome, complete genome	blastn	55605	289	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax delafieldii
6819642	6819642	PRJNA454154_S_NODE_166_length_240_cov_32.763547_g163_i0	PRJNA454154	166	240	32.763547	78.6325128	Solilutibacter oculi	2698682	Bacteria	Bacteria	350	6.839999999999999e-92	NTclustered	gi\|1419369001\|gb\|CP029556.1\|	2698682	g163	i0	95.434	164.825	219	10	91	0	1	219	9182	9400	Solilutibacter oculi strain 83-4, complete genome	blastn	39558	350	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Solilutibacter	Solilutibacter oculi
8746424	8746424	PRJNA454154_S_NODE_87_length_293_cov_49.511719_g84_i0	PRJNA454154	87	293	49.511719	145.06933667	Herbaspirillum	963	Bacteria	Bacteria	514	2.88e-141	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g84	i0	98.299	460.552901023891	294	4	100	1	1	293	524439	524146	Herbaspirillum seropedicae strain Z69 chromosome	blastn	134942	514	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
9369794	9369794	PRJNA454154_S_NODE_28_length_408_cov_50.690027_g25_i0	PRJNA454154	28	408	50.690027	206.81531016	Rheinheimera sp. MM224	3019969	Bacteria	Bacteria	588	2.4099999999999998e-163	NTclustered	gi\|2321869226\|emb\|OX352320.1\|	3019969	g25	i0	92.701	932.291666666667	411	24	100	6	1	408	39946	39539	Rheinheimera sp. isolate Rheinheimera MM224 assembly genome assembly, chromosome: MM224	blastn	380375	588	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. MM224
10645824	10645824	PRJNA454154_S_NODE_29_length_407_cov_51.040541_g26_i0	PRJNA454154	29	407	51.040541	207.73500187	Rheinheimera sp. MM224	3019969	Bacteria	Bacteria	536	8.849999999999999e-148	NTclustered	gi\|2321869226\|emb\|OX352320.1\|	3019969	g26	i0	90.511	935.447174447174	411	32	100	7	1	407	39946	39539	Rheinheimera sp. isolate Rheinheimera MM224 assembly genome assembly, chromosome: MM224	blastn	380727	536	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. MM224
11296583	11296583	PRJNA454154_S_NODE_649_length_153_cov_1.206897_g646_i0	PRJNA454154	649	153	1.206897	1.84655241	Ralstonia	48736	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|532578729\|gb\|KC188318.1\|	305	g646	i0	99.346	212.065359477124	153	1	100	0	1	153	1382	1534	Ralstonia solanacearum strain CFBP 3059 23S ribosomal RNA gene, partial sequence	blastn	32446	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
11920749	11920749	PRJNA454154_S_NODE_450_length_176_cov_1.575540_g447_i0	PRJNA454154	450	176	1.57554	2.7729504	Plesiomonas shigelloides	703	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|1913912090\|gb\|CP062197.1\|	703	g447	i0	99.432	681.897727272727	176	1	100	0	1	176	143304	143129	Plesiomonas shigelloides strain P5462 plasmid p1, complete sequence	blastn	120014	320	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
14470611	14470611	PRJNA454154_S_NODE_212_length_221_cov_1.891304_g209_i0	PRJNA454154	212	221	1.891304	4.17978184	Caenispirillum salinarum	859058	Bacteria	Bacteria	137	5.26e-28	NTclustered	gi\|2851215952\|gb\|CP085224.1\|	859058	g209	i0	79.167	21	216	31	93	9	1	206	3567396	3567185	Caenispirillum salinarum strain ADH2-936 chromosome, complete genome	blastn	4641	137	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Novispirillaceae	Caenispirillum	Caenispirillum salinarum
15121250	15121250	PRJNA454154_S_NODE_172_length_238_cov_18.427861_g169_i0	PRJNA454154	172	238	18.427861	43.85830918	root	1	Root_unresolved	Root_unresolved	429	8.45e-116	NTclustered	gi\|2060186473\|gb\|MZ471075.1\|	72226	g169	i0	100	97.4789915966387	232	0	97	0	7	238	730	499	Lysobacter sp. strain 2042 16S ribosomal RNA gene, partial sequence	blastn	23200	429	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Lysobacter	Lysobacter sp.
15744563	15744563	PRJNA454154_S_NODE_173_length_238_cov_8.313433_g170_i0	PRJNA454154	173	238	8.313433	19.78597054	Rheinheimera sp. F8	1763998	Bacteria	Bacteria	398	2.3799999999999995e-106	NTclustered	gi\|975021511\|gb\|CP013656.1\|	1763998	g170	i0	97.425	661.529411764706	233	6	98	0	2	234	416191	415959	Rheinheimera sp. F8 genome	blastn	157444	398	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. F8
16396026	16396026	PRJNA454154_S_NODE_433_length_178_cov_2.397163_g430_i0	PRJNA454154	433	178	2.397163	4.26695014	root	1	Root_unresolved	Root_unresolved	327	2.23e-85	NTclustered	gi\|2842886548\|gb\|CP171997.1\|	47920	g430	i0	100	264.707865168539	177	0	99	0	2	178	2969	2793	Acidovorax delafieldii strain UC81_30 chromosome, complete genome	blastn	47118	327	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Acidovorax	Acidovorax delafieldii
17671053	17671053	PRJNA454154_S_NODE_474_length_172_cov_2.392593_g471_i0	PRJNA454154	474	172	2.392593	4.11525996	Shewanella	22	Bacteria	Bacteria	278	2.19e-70	NTclustered	gi\|1215225522\|gb\|CP022358.1\|	2018305	g471	i0	95.906	47.0232558139535	171	7	99	0	1	171	1551735	1551905	Shewanella bicestrii strain JAB-1, complete genome	blastn	8088	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella bicestrii
18944921	18944921	PRJNA454154_S_NODE_495_length_169_cov_2.780303_g492_i0	PRJNA454154	495	169	2.780303	4.69871207	Lysobacter	68	Bacteria	Bacteria	283	4.6e-72	NTclustered	gi\|951704250\|gb\|CP011129.1\|	84531	g492	i0	97.041	233.497041420118	169	3	99	2	3	169	4801822	4801654	Lysobacter antibioticus strain 76, complete genome	blastn	39461	283	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Lysobacter	Lysobacter antibioticus
21495254	21495254	PRJNA454154_S_NODE_137_length_256_cov_11.963470_g134_i0	PRJNA454154	137	256	11.96347	30.6264832	Shewanella	22	Bacteria	Bacteria	409	1.2e-109	NTclustered	gi\|2024816785\|gb\|CP031775.3\|	256839	g134	i0	98.696	678.4453125	230	3	90	0	2	231	4703287	4703058	Shewanella decolorationis strain Ni1-3 chromosome, complete genome	blastn	173682	409	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Shewanellaceae	Shewanella	Shewanella decolorationis
21495257	21495257	PRJNA454154_S_NODE_497_length_169_cov_2.219697_g494_i0	PRJNA454154	497	169	2.219697	3.75128793	Acinetobacter	469	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1797096465\|gb\|CP041970.1\|	70348	g494	i0	100	606.775147928994	169	0	100	0	1	169	2382738	2382570	Acinetobacter dispersus strain NCCP 16014 chromosome, complete genome	blastn	102545	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter dispersus
22118465	22118465	PRJNA454154_S_NODE_38_length_379_cov_47.365497_g35_i0	PRJNA454154	38	379	47.365497	179.51523363	Aeromonas veronii	654	Bacteria	Bacteria	551	2.919999999999999e-152	NTclustered	gi\|2259758343\|gb\|CP072325.1\|	654	g35	i0	92.932	891.585751978892	382	22	100	4	1	379	4485811	4486190	Aeromonas veronii strain 183026 chromosome, complete genome	blastn	337911	551	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas veronii
22770390	22770390	PRJNA454154_S_NODE_498_length_169_cov_1.939394_g495_i0	PRJNA454154	498	169	1.939394	3.27757586	Enterobacteriaceae	543	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g495	i0	99.408	664.100591715976	169	1	100	0	1	169	186373	186541	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	112233	307	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
24045308	24045308	PRJNA454154_S_NODE_119_length_267_cov_7.595652_g116_i0	PRJNA454154	119	267	7.595652	20.28039084	Aeromonas	642	Bacteria	Bacteria	470	5.689999999999999e-128	NTclustered	gi\|2214134399\|gb\|CP094267.1\|	644	g116	i0	98.496	833.951310861423	266	4	99	0	2	267	87876	88141	Aeromonas hydrophila strain A008N2 chromosome, complete genome	blastn	222665	470	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
24668135	24668135	PRJNA454154_S_NODE_260_length_205_cov_17.898810_g257_i0	PRJNA454154	260	205	17.89881	36.6925605	Plesiomonas shigelloides	703	Bacteria	Bacteria	377	2.6e-100	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g257	i0	100	774.234146341463	204	0	99	0	1	204	334432	334229	Plesiomonas shigelloides strain Colony13 chromosome	blastn	158718	377	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
25319656	25319656	PRJNA454154_S_NODE_100_length_283_cov_3.930894_g97_i0	PRJNA454154	100	283	3.930894	11.12443002	Aeromonas	642	Bacteria	Bacteria	433	7.98e-117	NTclustered	gi\|1841685728\|gb\|CP038443.1\|	651	g97	i0	94.138	855.381625441696	290	8	99	3	3	283	2108487	2108776	Aeromonas media strain R1-18 chromosome, complete genome	blastn	242073	433	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas media
25319659	25319659	PRJNA454154_S_NODE_360_length_189_cov_2.769737_g357_i0	PRJNA454154	360	189	2.769737	5.23480293	Thermomonas	141948	Bacteria	Bacteria	298	1.89e-76	NTclustered	gi\|1898499561\|gb\|CP060711.1\|	215691	g357	i0	95.699	215.222222222222	186	6	98	2	5	189	2220032	2220216	Thermomonas brevis strain KACC 16975 chromosome, complete genome	blastn	40677	298	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Thermomonas	Thermomonas brevis
26727523	26727523	PRJNA454154_S_NODE_181_length_236_cov_11.512563_g178_i0	PRJNA454154	181	236	11.512563	27.16964868	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	43.5	0.00627	NR	WP_395587273.1	251699	g178	i0	41.2	0.648305084745763	51	27	62.3	2	62	208	2	51	WP_395587273.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7]	diamond	153	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7
30771400	30771400	PRJNA454154_S_NODE_654_length_152_cov_4.573913_g651_i0	PRJNA454154	654	152	4.573913	6.95234776	Magnetococcus sp. YQC-3	2763146	Bacteria	Bacteria	47.8	1.72e-4	NR	MEO5350766.1	2763146	g651	i0	59.5	3.23684210526316	37	15	73	0	152	42	238	274	MEO5350766.1 leishmanolysin [Magnetococcus sp. YQC-3]	diamond	492	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Magnetococcia	Magnetococcales	Magnetococcaceae	Magnetococcus	Magnetococcus sp. YQC-3

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