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

16 rows where bioproject = "PRJEB50765" 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
119554	119554	PRJEB50765_P_NODE_1601_length_236_cov_1.733668_g1577_i0	PRJEB50765	1601	236	1.733668	4.09145648	Aquabacterium sp. J223	2898431	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|2285501637\|gb\|CP088297.1\|	2898431	g1577	i0	100	322.483050847458	236	0	100	0	1	236	848538	848773	Aquabacterium sp. J223 chromosome	blastn	76106	436	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp. J223
1393953	1393953	PRJEB50765_P_NODE_1862_length_214_cov_1.858757_g1838_i0	PRJEB50765	1862	214	1.858757	3.97773998	Rheinheimera sp. D18	2545632	Bacteria	Bacteria	294	2.8400000000000003e-75	NTclustered	gi\|1590159087\|gb\|CP037745.1\|	2545632	g1838	i0	91.943	872.275700934579	211	16	99	1	5	214	44822	44612	Rheinheimera sp. D18 chromosome, complete genome	blastn	186667	294	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. D18
1393958	1393958	PRJEB50765_P_NODE_2702_length_169_cov_2.295455_g2678_i0	PRJEB50765	2702	169	2.295455	3.87931895	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	300	4.56e-77	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g2678	i0	98.81	276.159763313609	168	2	99	0	1	168	1530806	1530973	Undibacterium sp. YM2 DNA, complete genome	blastn	46671	300	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
2266599	2266599	PRJEB50765_P_NODE_322_length_584_cov_3.914077_g303_i0	PRJEB50765	322	584	3.914077	22.85820968	Oxalobacteraceae	75682	Bacteria	Bacteria	826	0	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g303	i0	92.295	489.030821917808	584	41	99	4	2	584	522875	522295	Herbaspirillum seropedicae strain Z69 chromosome	blastn	285594	832	0.992788461538462	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
6497789	6497789	PRJEB50765_P_NODE_1306_length_268_cov_1.727273_g1282_i0	PRJEB50765	1306	268	1.727273	4.62909164	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	401	2.1099999999999995e-107	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g1282	i0	93.704	347.876865671642	270	13	100	3	1	268	1529466	1529733	Undibacterium sp. YM2 DNA, complete genome	blastn	93231	401	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
9919539	9919539	PRJEB50765_P_NODE_2828_length_165_cov_1.203125_g2804_i0	PRJEB50765	2828	165	1.203125	1.98515625	Enterobacteriaceae	543	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g2804	i0	100	664.157575757576	165	0	100	0	1	165	186384	186548	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	109586	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11597885	11597885	PRJEB50765_P_NODE_450_length_509_cov_2.093220_g427_i0	PRJEB50765	450	509	2.09322	10.6544898	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	234	3.66e-76	NR	MEL6702562.1	1977087	g427	i0	68.2	5.54027504911591	157	50	92.5	0	7	477	1	157	MEL6702562.1 30S ribosomal protein S17 [Pseudomonadota bacterium]	diamond	2820	234	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
17971114	17971114	PRJEB50765_P_NODE_3215_length_153_cov_1.310345_g3191_i0	PRJEB50765	3215	153	1.310345	2.00482785	Aquabacterium sp. J223	2898431	Bacteria	Bacteria	267	4.1099999999999994e-67	NTclustered	gi\|2285501637\|gb\|CP088297.1\|	2898431	g3191	i0	98.039	170.888888888889	153	3	100	0	1	153	847785	847633	Aquabacterium sp. J223 chromosome	blastn	26146	267	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp. J223
18842921	18842921	PRJEB50765_P_NODE_3075_length_157_cov_1.116667_g3051_i0	PRJEB50765	3075	157	1.116667	1.75316719	Gammaproteobacteria	1236	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|2321448847\|gb\|CP107616.1\|	470	g3051	i0	100	583.006369426752	157	0	100	0	1	157	23208	23052	Acinetobacter baumannii strain 1326932 chromosome, complete genome	blastn	91532	291	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
26590058	26590058	PRJEB50765_P_NODE_1661_length_230_cov_1.393782_g1637_i0	PRJEB50765	1661	230	1.393782	3.2056986	Colwellia sp.	56799	Bacteria	Bacteria	42.7	0.0318	NR	MCP4989313.1	56799	g1637	i0	53.8	0.508695652173913	39	18	50.9	0	1	117	325	363	MCP4989313.1 hypothetical protein [Colwellia sp.]	diamond	117	42.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Colwelliaceae	Colwellia	Colwellia sp.
27381383	27381383	PRJEB50765_P_NODE_1263_length_275_cov_1.302521_g1239_i0	PRJEB50765	1263	275	1.302521	3.58193275	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	144	2.9599999999999995e-42	NR	MEL6702651.1	1977087	g1239	i0	75.8	0.992727272727273	91	22	99.3	0	274	2	27	117	MEL6702651.1 30S ribosomal protein S11 [Pseudomonadota bacterium]	diamond	273	144	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
28517981	28517981	PRJEB50765_P_NODE_2787_length_166_cov_1.496124_g2763_i0	PRJEB50765	2787	166	1.496124	2.48356584	Candidatus Zinderia endosymbiont of Aphrophora alni	3077951	Bacteria	Bacteria	90.9	8.4e-20	NR	WP_339045084.1	3077951	g2763	i0	74.5	3.97590361445783	55	14	99.4	0	166	2	276	330	WP_339045084.1 elongation factor Tu [Candidatus Zinderia endosymbiont of Aphrophora alni]	diamond	660	90.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Candidatus Zinderia	Candidatus Zinderia endosymbiont of Aphrophora alni
28612648	28612648	PRJEB50765_P_NODE_2427_length_181_cov_1.354167_g2403_i0	PRJEB50765	2427	181	1.354167	2.45104227	Nitrosomonas sp.	42353	Bacteria	Bacteria	84.3	3.61e-17	NR	HNJ38565.1	42353	g2403	i0	68.3	0.994475138121547	60	19	99.4	0	181	2	1099	1158	HNJ38565.1 reverse transcriptase domain-containing protein [Nitrosomonas sp.]	diamond	180	84.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Nitrosomonadaceae	Nitrosomonas	Nitrosomonas sp.
29464717	29464717	PRJEB50765_P_NODE_950_length_336_cov_0.899666_g926_i0	PRJEB50765	950	336	0.899666	3.02287776	Rhodocyclaceae bacterium	1898103	Bacteria	Bacteria	44.3	0.0315	NR	MCB1955432.1	1898103	g926	i0	43.5	0.616071428571429	69	36	60.7	3	88	291	207	273	MCB1955432.1 SWIM zinc finger family protein [Rhodocyclaceae bacterium]	diamond	207	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae		Rhodocyclaceae bacterium
29780818	29780818	PRJEB50765_P_NODE_1631_length_233_cov_1.142857_g1607_i0	PRJEB50765	1631	233	1.142857	2.66285681	Caenispirillum salinarum	859058	Bacteria	Bacteria	67	1.12e-12	NR	WP_009542739.1	859058	g1607	i0	66	2.02145922746781	53	18	68.2	0	216	58	15	67	WP_009542739.1 YqaE/Pmp3 family membrane protein [Caenispirillum salinarum]	diamond	471	67	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Novispirillaceae	Caenispirillum	Caenispirillum salinarum
31012983	31012983	PRJEB50765_P_NODE_2335_length_185_cov_1.567568_g2311_i0	PRJEB50765	2335	185	1.567568	2.9000008	Paracoccaceae bacterium	1904441	Bacteria	Bacteria	73.9	1.7e-13	NR	GIS52924.1	1904441	g2311	i0	95	0.648648648648649	40	2	64.9	0	120	1	1	40	GIS52924.1 MAG: chaperone protein HtpG [Paracoccaceae bacterium]	diamond	120	73.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae		Paracoccaceae 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);;