metadata: contig_metadata: 20 rows where bioproject = "PRJEB1404" and tax

20 rows where bioproject = "PRJEB1404" 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
21110	21110	PRJEB1404_S_NODE_161_length_437_cov_406.843284_g141_i0	PRJEB1404	161	437	406.843284	1777.90515108	Pseudomonas aeruginosa	287	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|2792427225\|gb\|CP167888.1\|	287	g141	i0	94.444	0.153318077803204	36	1	8	1	9	43	4558687	4558722	Pseudomonas aeruginosa strain 33008169 chromosome	blastn	67	54.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
2570974	2570974	PRJEB1404_S_NODE_2203_length_215_cov_2.433333_g2183_i0	PRJEB1404	2203	215	2.433333	5.23166595	Pseudomonas tolaasii	29442	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|1168987590\|gb\|CP020369.1\|	29442	g2183	i0	100	0.130232558139535	28	0	13	0	1	28	4965988	4966015	Pseudomonas tolaasii strain 2192T chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas tolaasii
3847303	3847303	PRJEB1404_P_NODE_2904_length_209_cov_2.415730_g2878_i0	PRJEB1404	2904	209	2.41573	5.0488757	Undibacterium piscinae	2495591	Bacteria	Bacteria	311	2.74e-80	NTclustered	gi\|1837894924\|gb\|CP051152.1\|	2495591	g2878	i0	95.385	390.287081339713	195	9	93	0	15	209	144697	144503	Undibacterium piscinae strain S11R28 chromosome, complete genome	blastn	81570	311	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium piscinae
5123483	5123483	PRJEB1404_P_NODE_1605_length_272_cov_2.697095_g1579_i0	PRJEB1404	1605	272	2.697095	7.3360984	Vogesella sp. LIG4	1192162	Bacteria	Bacteria	344	3.68e-90	NTclustered	gi\|1052698745\|emb\|LT607802.1\|	1192162	g1579	i0	91.016	349.488970588235	256	21	94	2	2	256	281953	281699	Vogesella sp. LIG4 genome assembly, chromosome: I	blastn	95061	344	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella sp. LIG4
5123484	5123484	PRJEB1404_P_NODE_2265_length_233_cov_12.341584_g2239_i0	PRJEB1404	2265	233	12.341584	28.75589072	Legionella lytica	96232	Bacteria	Bacteria	359	1.1e-94	NTclustered	gi\|2259844599\|gb\|CP071527.1\|	96232	g2239	i0	94.783	296.699570815451	230	12	99	0	1	230	322137	322366	Legionella lytica strain PCM 2298 chromosome, complete genome	blastn	69131	359	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Legionellaceae	Legionella	Legionella lytica
5123487	5123487	PRJEB1404_P_NODE_3625_length_187_cov_2.339744_g3599_i0	PRJEB1404	3625	187	2.339744	4.37532128	Candidatus Trichorickettsia mobilis	1346319	Bacteria	Bacteria	215	1.93e-51	NTclustered	gi\|2634279065\|gb\|CP112932.1\|	1346319	g3599	i0	87.368	3.88235294117647	190	20	100	3	1	187	1214903	1215091	Candidatus Trichorickettsia mobilis strain Kr 154-4 chromosome	blastn	726	215	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Candidatus Trichorickettsia	Candidatus Trichorickettsia mobilis
5123497	5123497	PRJEB1404_S_NODE_4685_length_151_cov_3.379310_g4665_i0	PRJEB1404	4685	151	3.37931	5.1027581	Undibacterium cyanobacteriorum	3073561	Bacteria	Bacteria	235	1.14e-57	NTclustered	gi\|2575695762\|gb\|CP133720.1\|	3073561	g4665	i0	97.122	401.649006622517	139	4	92	0	13	151	741742	741604	Undibacterium cyanobacteriorum strain 20NA77.5 chromosome, complete genome	blastn	60649	235	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium cyanobacteriorum
6088828	6088828	PRJEB1404_S_NODE_2385_length_208_cov_4.439306_g2365_i0	PRJEB1404	2385	208	4.439306	9.23375648	Gammaproteobacteria	1236	Bacteria	Bacteria	357	3.4499999999999996e-94	NTclustered	gi\|2890464394\|gb\|CP177216.1\|	562	g2365	i0	97.596	826.956730769231	208	5	100	0	1	208	226020	226227	Escherichia coli strain ECDA0423 chromosome, complete genome	blastn	172007	357	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
6399242	6399242	PRJEB1404_S_NODE_3966_length_163_cov_4.164062_g3946_i0	PRJEB1404	3966	163	4.164062	6.78742106	Aquincola tertiaricarbonis	391953	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2246256535\|gb\|CP097636.1\|	391953	g3946	i0	100	184.036809815951	163	0	100	0	1	163	501713	501551	Aquincola tertiaricarbonis strain RN12 chromosome 2, complete sequence	blastn	29998	302	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Aquincola	Aquincola tertiaricarbonis
7363401	7363401	PRJEB1404_S_NODE_2046_length_223_cov_4.643617_g2026_i0	PRJEB1404	2046	223	4.643617	10.35526591	Oxalobacteraceae	75682	Bacteria	Bacteria	401	1.7099999999999992e-107	NTclustered	gi\|1888715052\|gb\|CP049139.1\|	92645	g2026	i0	99.103	389.121076233184	223	2	100	0	1	223	517051	516829	Herbaspirillum frisingense strain IAC152 chromosome, complete genome	blastn	86774	401	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum frisingense
7363402	7363402	PRJEB1404_S_NODE_2286_length_211_cov_373.232955_g2266_i0	PRJEB1404	2286	211	373.232955	787.52153505	Oxalobacteraceae	75682	Bacteria	Bacteria	235	1.71e-57	NTclustered	gi\|1798093821\|dbj\|AP018439.1\|	2058624	g2266	i0	94.156	185.962085308057	154	9	80	0	58	211	1553843	1553690	Undibacterium sp. KW1 DNA, complete genome	blastn	39238	235	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. KW1
9913874	9913874	PRJEB1404_P_NODE_1148_length_307_cov_2.728261_g1123_i0	PRJEB1404	1148	307	2.728261	8.37576127	Betaproteobacteria	28216	Bacteria	Bacteria	521	1.8199999999999993e-143	NTclustered	gi\|1798187748\|dbj\|AP021884.1\|	171865	g1123	i0	98.316	456.511400651466	297	5	97	0	11	307	529275	528979	Sulfuriferula plumbiphila Gro7 DNA, complete genome	blastn	140149	521	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Sulfuricellaceae	Sulfuriferula	Sulfuriferula plumbiphila
9913884	9913884	PRJEB1404_S_NODE_2968_length_187_cov_1.381579_g2948_i0	PRJEB1404	2968	187	1.381579	2.58355273	Acinetobacter	469	Bacteria	Bacteria	324	3.07e-84	NTclustered	gi\|2013091420\|gb\|CP071766.1\|	202956	g2948	i0	98.37	655.44385026738	184	3	100	0	1	184	698220	698403	Acinetobacter towneri strain GX3 chromosome, complete genome	blastn	122568	324	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter towneri
15013560	15013560	PRJEB1404_P_NODE_4152_length_170_cov_8.920863_g4126_i0	PRJEB1404	4152	170	8.920863	15.1654671	Moraxellaceae	468	Bacteria	Bacteria	169	1.35e-37	NTclustered	gi\|2324910687\|gb\|CP087817.1\|	476	g4126	i0	98.936	306.029411764706	94	1	99	0	75	168	79279	79372	Moraxella bovis strain SAM109237 chromosome, complete genome	blastn	52025	169	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Moraxella	Moraxella bovis
16288405	16288405	PRJEB1404_P_NODE_1593_length_272_cov_6.539419_g1567_i0	PRJEB1404	1593	272	6.539419	17.78721968	Herbaspirillum	963	Bacteria	Bacteria	244	3.8399999999999996e-60	NTclustered	gi\|1510310152\|gb\|CP024996.1\|	80842	g1567	i0	96.622	370.330882352941	148	4	92	1	14	161	550560	550414	Herbaspirillum rubrisubalbicans strain DSM 11543 chromosome, complete genome	blastn	100730	244	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum rubrisubalbicans
16597919	16597919	PRJEB1404_S_NODE_14_length_927_cov_4.821749_g5_i0	PRJEB1404	14	927	4.821749	44.69761323	Roseateles sp. So40a	3400226	Bacteria	Bacteria	1570	0	NTclustered	gi\|2917352602\|gb\|CP182288.1\|	3400226	g5	i0	97.201	306.463861920173	929	24	100	1	1	927	3161	4089	Roseateles sp. So40a chromosome, complete genome	blastn	284092	1570	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles sp. So40a
18837515	18837515	PRJEB1404_P_NODE_2115_length_240_cov_3.531100_g2089_i0	PRJEB1404	2115	240	3.5311	8.47464	Roseateles	93681	Bacteria	Bacteria	270	5.47e-68	NTclustered	gi\|1033652334\|gb\|CP011514.1\|	1658665	g2089	i0	95.808	196.641666666667	167	7	70	0	1	167	5819503	5819337	Mitsuaria sp. 7, complete genome	blastn	47194	270	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Mitsuaria sp. 7
19146603	19146603	PRJEB1404_S_NODE_1536_length_246_cov_3.938389_g1516_i0	PRJEB1404	1536	246	3.938389	9.68843694	Aquabacterium sp. J223	2898431	Bacteria	Bacteria	399	6.889999999999999e-107	NTclustered	gi\|2285501637\|gb\|CP088297.1\|	2898431	g1516	i0	100	264.365853658537	216	0	88	0	1	216	848553	848768	Aquabacterium sp. J223 chromosome	blastn	65034	399	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp. J223
19146604	19146604	PRJEB1404_S_NODE_1696_length_238_cov_2.167488_g1676_i0	PRJEB1404	1696	238	2.167488	5.15862144	Legionella sp. MW5194	2662448	Bacteria	Bacteria	305	1.49e-78	NTclustered	gi\|1982780986\|gb\|CP045732.1\|	2662448	g1676	i0	91.518	258.697478991597	224	15	93	4	1	222	2805523	2805302	Legionella sp. MW5194 chromosome, complete genome	blastn	61570	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Legionellaceae	Legionella	Legionella sp. MW5194
30822944	30822944	PRJEB1404_P_NODE_2834_length_211_cov_12.366667_g2808_i0	PRJEB1404	2834	211	12.366667	26.09366737	Klebsiella pneumoniae	573	Bacteria	Bacteria	92.8	2.71e-22	NR	WP_416501348.1	573	g2808	i0	100	1.22274881516588	43	0	61.1	0	2	130	85	127	WP_416501348.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	258	92.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae

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