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

16 rows where bioproject = "PRJEB65329" 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
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
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
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.
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
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
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
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
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);;