metadata: contig_metadata: 25 rows where bioproject = "PRJEB65329" and tax

25 rows where bioproject = "PRJEB65329" 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
5232645	5232645	PRJEB65329_S_NODE_2405_length_640_cov_37.464812_g2287_i0	PRJEB65329	2405	640	37.464812	239.7747968	Phenylobacterium hankyongense	1813876	Bacteria	Bacteria	129	6.519999999999998e-35	NR	WP_207801906.1	1813876	g2287	i0	80.6	0.61875	67	13	31.4	0	581	381	15	81	WP_207801906.1 hypothetical protein, partial [Phenylobacterium hankyongense]	diamond	396	129	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Phenylobacterium	Phenylobacterium hankyongense
5232763	5232763	PRJEB65329_S_NODE_6325_length_302_cov_3.087912_g6163_i0	PRJEB65329	6325	302	3.087912	9.32549424	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g6163	i0	96.97	0.109271523178808	33	1	11	0	3	35	1389605	1389637	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7371412	7371412	PRJEB65329_S_NODE_17866_length_153_cov_2.822581_g17704_i0	PRJEB65329	17866	153	2.822581	4.31854893	root	1	Root_unresolved	Root_unresolved	182	1.53e-41	NTclustered	gi\|2622025017\|gb\|CP138515.1\|	34073	g17704	i0	99.01	126.02614379085	101	1	66	0	1	101	5059574	5059474	Variovorax paradoxus strain 2u118 chromosome, complete genome	blastn	19282	182	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
7782381	7782381	PRJEB65329_S_NODE_12327_length_191_cov_2.339506_g12165_i0	PRJEB65329	12327	191	2.339506	4.46845646	Pseudolabrys sp. FHR47	2562284	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1633220606\|gb\|CP039740.1\|	2562284	g12165	i0	100	0.151832460732984	29	0	15	0	13	41	535520	535492	Pseudolabrys sp. FHR47 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Xanthobacteraceae	Pseudolabrys	Pseudolabrys sp. FHR47
10333115	10333115	PRJEB65329_S_NODE_18149_length_152_cov_2.292683_g17987_i0	PRJEB65329	18149	152	2.292683	3.48487816	Bdellovibrio sp. KM01	2748865	Bacteria	Bacteria	62.1	2.06e-5	NTclustered	gi\|1880307726\|gb\|CP058348.1\|	2748865	g17987	i0	97.297	6.65789473684211	37	0	24	1	3	38	248784	248748	Bdellovibrio sp. KM01 chromosome, complete genome	blastn	1012	62.1	1	Bacteria		Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. KM01
11197232	11197232	PRJEB65329_S_NODE_13209_length_182_cov_4.666667_g13047_i0	PRJEB65329	13209	182	4.666667	8.49333394	Methylibium	316612	Bacteria	Bacteria	337	3.82e-88	NTclustered	gi\|124257968\|gb\|CP000555.1\|	420662	g13047	i0	100	242.087912087912	182	0	100	0	1	182	355010	355191	Methylibium petroleiphilum PM1, complete genome	blastn	44060	337	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Methylibium	Methylibium petroleiphilum
11608522	11608522	PRJEB65329_S_NODE_12270_length_191_cov_3.351852_g12108_i0	PRJEB65329	12270	191	3.351852	6.40203732	Undibacterium sp. CCC3.4	3048609	Bacteria	Bacteria	342	8.699999999999999e-90	NTclustered	gi\|2634174434\|gb\|CP133779.1\|	3048609	g12108	i0	98.953	489.523560209424	191	2	100	0	1	191	1461634	1461444	Undibacterium sp. CCC3.4 chromosome, complete genome	blastn	93499	342	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. CCC3.4
12472852	12472852	PRJEB65329_S_NODE_12730_length_187_cov_2.322785_g12568_i0	PRJEB65329	12730	187	2.322785	4.34360795	Pseudomonas	286	Bacteria	Bacteria	344	2.36e-90	NTclustered	gi\|1190795207\|gb\|KX456245.1\|	114707	g12568	i0	100	135.96256684492	186	0	99	0	1	186	47	232	Uncultured Pseudomonas sp. clone F52 16S ribosomal RNA gene, partial sequence	blastn	25425	344	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	uncultured Pseudomonas sp.
13747362	13747362	PRJEB65329_S_NODE_5991_length_315_cov_13.821678_g5829_i0	PRJEB65329	5991	315	13.821678	43.5382857	Flavobacterium	237	Bacteria	Bacteria	566	8.519999999999997e-157	NTclustered	gi\|1205803233\|gb\|KX550334.1\|	239	g5829	i0	99.048	109.142857142857	315	3	100	0	1	315	298	612	Flavobacterium sp. strain FLA_E38 16S ribosomal RNA gene, partial sequence	blastn	34380	566	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
15021811	15021811	PRJEB65329_S_NODE_6232_length_305_cov_3.539855_g6070_i0	PRJEB65329	6232	305	3.539855	10.79655775	Roseateles	93681	Bacteria	Bacteria	470	6.62e-128	NTclustered	gi\|121281912\|gb\|EF157669.1\|	417305	g6070	i0	96.797	307.832786885246	281	9	92	0	25	305	12280	12560	Uncultured beta proteobacterium CBNPD1 BAC clone 578 genomic sequence	blastn	93889	470	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria				uncultured beta proteobacterium CBNPD1 BAC clone 578
15021821	15021821	PRJEB65329_S_NODE_9112_length_232_cov_20.719212_g8950_i0	PRJEB65329	9112	232	20.719212	48.06857184	Enterobacteriaceae	543	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g8950	i0	100	669.629310344828	232	0	100	0	1	232	186550	186319	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	155354	429	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
17571781	17571781	PRJEB65329_S_NODE_16874_length_158_cov_2.434109_g16712_i0	PRJEB65329	16874	158	2.434109	3.84589222	Oceanospirillales	135619	Bacteria	Bacteria	254	3.3400000000000003e-63	NTclustered	gi\|470474812\|ref\|NR_076239.1\|	59754	g16712	i0	95.57	474.924050632911	158	7	100	0	1	158	723	880	Alcanivorax borkumensis strain SK2 23S ribosomal RNA gene, complete sequence	blastn	75038	254	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Alcanivoracaceae	Alcanivorax	Alcanivorax borkumensis
20531114	20531114	PRJEB65329_S_NODE_3697_length_469_cov_13.227273_g3538_i0	PRJEB65329	3697	469	13.227273	62.03591037	type II methanotrophic bacterium	36494	Bacteria	Bacteria	54.7	0.013	NTclustered	gi\|2890168929\|dbj\|AP038939.1\|	36494	g3538	i0	100	0.123667377398721	29	0	6	0	233	261	2369312	2369340	Type II methanotrophic bacterium NpR20-75 DNA, complete genome	blastn	58	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylocystaceae		type II methanotrophic bacterium
23946352	23946352	PRJEB65329_S_NODE_4699_length_388_cov_14.016713_g4537_i0	PRJEB65329	4699	388	14.016713	54.38484644	Enterobacteriaceae	543	Bacteria	Bacteria	713	0	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g4537	i0	100	684.345360824742	386	0	99	0	3	388	188191	188576	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	265526	713	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25220031	25220031	PRJEB65329_S_NODE_4780_length_382_cov_4.881020_g4618_i0	PRJEB65329	4780	382	4.88102	18.6454964	Flavobacterium	237	Bacteria	Bacteria	628	1.3199999999999998e-175	NTclustered	gi\|1391188358\|gb\|CP029463.1\|	2201181	g4618	i0	96.335	716.717277486911	382	14	100	0	1	382	2900484	2900103	Flavobacterium sediminis strain MEBiC07310 chromosome, complete genome	blastn	273786	628	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sediminis
26685610	26685610	PRJEB65329_S_NODE_12841_length_186_cov_2.089172_g12679_i0	PRJEB65329	12841	186	2.089172	3.88585992	Shigella flexneri	623	Bacteria	Bacteria	73.6	2.3e-15	NR	MDD0148654.1	623	g12679	i0	54.1	1.96774193548387	61	28	98.4	0	184	2	19	79	MDD0148654.1 hypothetical protein [Shigella flexneri]	diamond	366	73.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella flexneri
26970540	26970540	PRJEB65329_S_NODE_7862_length_258_cov_2.633188_g7700_i0	PRJEB65329	7862	258	2.633188	6.79362504	Polyangia bacterium	3058050	Bacteria	Bacteria	40.4	0.0376	NR	HJX65230.1	3058050	g7700	i0	45	0.465116279069767	40	22	46.5	0	249	130	17	56	HJX65230.1 hypothetical protein [Polyangia bacterium]	diamond	120	40.4	1	Bacteria		Pseudomonadati	Myxococcota					Polyangia bacterium
27792176	27792176	PRJEB65329_S_NODE_3624_length_475_cov_8.668161_g3468_i0	PRJEB65329	3624	475	8.668161	41.17376475	Phenylobacterium hankyongense	1813876	Bacteria	Bacteria	110	2.5599999999999998e-28	NR	WP_133255066.1	1813876	g3468	i0	65.5	1.22526315789474	87	30	54.9	0	67	327	13	99	WP_133255066.1 hypothetical protein, partial [Phenylobacterium hankyongense]	diamond	582	110	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Caulobacterales	Caulobacteraceae	Phenylobacterium	Phenylobacterium hankyongense
28518373	28518373	PRJEB65329_S_NODE_13187_length_183_cov_2.045455_g13025_i0	PRJEB65329	13187	183	2.045455	3.74318265	Helicobacter pylori	210	Bacteria	Bacteria	67.8	1.95e-13	NR	GAA6795254.1	210	g13025	i0	62.2	0.737704918032787	45	17	73.8	0	165	31	2	46	GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori]	diamond	135	67.8	1	Bacteria		Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
29118408	29118408	PRJEB65329_S_NODE_12389_length_190_cov_3.055901_g12227_i0	PRJEB65329	12389	190	3.055901	5.8062119	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	43.1	0.0134	NR	MAC74229.1	2026778	g12227	i0	41.3	0.726315789473684	46	25	72.6	1	50	187	3	46	MAC74229.1 hypothetical protein [Phycisphaerae bacterium]	diamond	138	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29497055	29497055	PRJEB65329_S_NODE_15970_length_163_cov_2.343284_g15808_i0	PRJEB65329	15970	163	2.343284	3.81955292	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0238	NR	MBA4685306.1	2026780	g15808	i0	48.8	0.791411042944785	43	22	79.1	0	22	150	182	224	MBA4685306.1 glycosyltransferase family 2 protein [Planctomycetota bacterium]	diamond	129	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30027032	30027032	PRJEB65329_S_NODE_7351_length_270_cov_4.763485_g7189_i0	PRJEB65329	7351	270	4.763485	12.8614095	root	1	Root_unresolved	Root_unresolved	62	2.24e-10	NR	WP_337453918.1	562	g7189	i0	93.9	28.2333333333333	33	2	36.7	0	1	99	46	78	WP_337453918.1 MC/SLC25 family protein, partial [Escherichia coli]	diamond	7623	62.4	0.993589743589744	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
30507879	30507879	PRJEB65329_S_NODE_10353_length_214_cov_2.535135_g10191_i0	PRJEB65329	10353	214	2.535135	5.4251889	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	40.8	0.0247	NR	HKM54239.1	2691532	g10191	i0	46.3	0.574766355140187	41	17	57.5	2	54	176	37	72	HKM54239.1 hypothetical protein [Isosphaeraceae bacterium]	diamond	123	40.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
31891751	31891751	PRJEB65329_S_NODE_14637_length_171_cov_6.105634_g14475_i0	PRJEB65329	14637	171	6.105634	10.44063414	root	1	Root_unresolved	Root_unresolved	49.3	2.74e-5	NR	MAO08131.1	232	g14475	i0	100	621.789473684211	22	0	38.6	0	3	68	136	157	MAO08131.1 hypothetical protein [Alteromonas sp.]	diamond	106326	49.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Alteromonas	Alteromonas sp.
32745302	32745302	PRJEB65329_S_NODE_6540_length_294_cov_8.901887_g6378_i0	PRJEB65329	6540	294	8.901887	26.17154778	root	1	Root_unresolved	Root_unresolved	101	8.5e-26	NR	WP_336505983.1	573	g6378	i0	89.2	5.22448979591837	65	6	65.3	1	69	260	24	88	WP_336505983.1 translation machinery-associated protein 7, partial [Klebsiella pneumoniae]	diamond	1536	101	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);;