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

27 rows where bioproject = "PRJEB50765" 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
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
3945646	3945646	PRJEB50765_P_NODE_2584_length_174_cov_1.496350_g2560_i0	PRJEB50765	2584	174	1.49635	2.603649	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	318	1.31e-82	NTclustered	gi\|1527187866\|gb\|CP034161.1\|	2487072	g2560	i0	100	486.5	172	0	99	0	1	172	807998	808169	Epilithonimonas vandammei strain F5649 chromosome, complete genome	blastn	84651	318	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
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
9919540	9919540	PRJEB50765_P_NODE_3148_length_155_cov_1.000000_g3124_i0	PRJEB50765	3148	155	1	1.55	Chryseobacterium	59732	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g3124	i0	100	558.316129032258	155	0	100	0	1	155	1757508	1757354	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	86539	287	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
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
11597889	11597889	PRJEB50765_P_NODE_790_length_375_cov_1.452663_g766_i0	PRJEB50765	790	375	1.452663	5.44748625	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	236	2.14e-74	NR	RYZ13579.1	2484252	g766	i0	92.8	1	125	9	100	0	1	375	210	334	RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium]	diamond	375	236	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
12873051	12873051	PRJEB50765_P_NODE_2251_length_189_cov_1.513158_g2227_i0	PRJEB50765	2251	189	1.513158	2.85986862	Bacteroidota	976	Bacteria	Bacteria	126	7.840000000000001e-33	NR	MBU7570240.1	239	g2227	i0	90.3	30.5079365079365	62	6	98.4	0	3	188	369	430	MBU7570240.1 aldehyde dehydrogenase family protein [Flavobacterium sp.]	diamond	5766	126	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
17569186	17569186	PRJEB50765_P_NODE_3274_length_151_cov_2.070175_g3250_i0	PRJEB50765	3274	151	2.070175	3.12596425	Chryseobacterium	59732	Bacteria	Bacteria	278	1.87e-70	NTclustered	gi\|1276741219\|gb\|CP022986.1\|	1265445	g3250	i0	100	411.258278145695	150	0	99	0	1	150	1203151	1203002	Chryseobacterium camelliae strain Dolsongi-HT1, complete genome	blastn	62100	278	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
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.
26931905	26931905	PRJEB50765_P_NODE_3322_length_150_cov_1.362832_g3298_i0	PRJEB50765	3322	150	1.362832	2.044248	Pseudomonadati	3379134	Bacteria	Bacteria	90.1	3.44e-21	NR	MBT7377214.1	2026760	g3298	i0	85.4	9.6	48	7	96	0	146	3	115	162	MBT7377214.1 F0F1 ATP synthase subunit alpha [Fidelibacterota bacterium]	diamond	1440	90.9	0.991199119911991	Bacteria	FCB group	Pseudomonadati	Fidelibacterota					Fidelibacterota bacterium
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
27753594	27753594	PRJEB50765_P_NODE_2764_length_167_cov_1.476923_g2740_i0	PRJEB50765	2764	167	1.476923	2.46646141	Bacteroidota	976	Bacteria	Bacteria	48.5	1.2e-4	NR	WP_348053777.1	1882438	g2740	i0	51.4	4.22155688622755	37	18	66.5	0	153	43	81	117	WP_348053777.1 ammonium transporter [Mucilaginibacter sp.]	diamond	705	48.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp.
28454946	28454946	PRJEB50765_P_NODE_2266_length_188_cov_2.052980_g2242_i0	PRJEB50765	2266	188	2.05298	3.8596024	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	63.9	1.96e-10	NR	MFK7736369.1	2699754	g2242	i0	58	0.797872340425532	50	20	79.8	1	150	1	21	69	MFK7736369.1 peptidylprolyl isomerase [Pirellulaceae bacterium]	diamond	150	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae 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
29843996	29843996	PRJEB50765_P_NODE_1031_length_317_cov_1.803571_g1007_i0	PRJEB50765	1031	317	1.803571	5.71732007	Terracidiphilus sp.	1964191	Bacteria	Bacteria	48.9	5.29e-5	NR	MDR3737750.1	1964191	g1007	i0	40.3	0.634069400630915	67	39	63.4	1	41	241	6	71	MDR3737750.1 hypothetical protein [Terracidiphilus sp.]	diamond	201	48.9	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terracidiphilus	Terracidiphilus sp.
30539048	30539048	PRJEB50765_P_NODE_1573_length_239_cov_1.717822_g1549_i0	PRJEB50765	1573	239	1.717822	4.10559458	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	113	7.44e-28	NR	RYZ13579.1	2484252	g1549	i0	69.2	0.97907949790795	78	24	97.9	0	234	1	73	150	RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium]	diamond	234	113	1	Bacteria		Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
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
31170746	31170746	PRJEB50765_P_NODE_2095_length_198_cov_1.111801_g2071_i0	PRJEB50765	2095	198	1.111801	2.20136598	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	53.1	4.11e-6	NR	MDR3737318.1	2052142	g2071	i0	47.7	0.984848484848485	65	33	97	1	197	6	231	295	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	195	53.1	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae 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);;