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

16 rows where analysis = "diamond", 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
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.
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);;