metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1248471" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1248471" 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
22030365	22030365	PRJNA1248471_S_NODE_21638_length_162_cov_1.495575_g21538_i0	PRJNA1248471	21638	162	1.495575	2.4228315	Afipia sp.	1871052	Bacteria	Bacteria	91.3	7.51e-20	NR	HEY0235440.1	1871052	g21538	i0	86.8	0.981481481481482	53	7	98.1	0	2	160	13	65	HEY0235440.1 lytic murein transglycosylase [Afipia sp.]	diamond	159	91.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Afipia	Afipia sp.
27705825	27705825	PRJNA1248471_S_NODE_12384_length_193_cov_1.770833_g12284_i0	PRJNA1248471	12384	193	1.770833	3.41770769	Shigella sonnei	624	Bacteria	Bacteria	42	0.00535	NR	MDD0469303.1	624	g12284	i0	44	0.77720207253886	50	28	77.7	0	181	32	12	61	MDD0469303.1 hypothetical protein [Shigella sonnei]	diamond	150	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Shigella	Shigella sonnei
29189573	29189573	PRJNA1248471_S_NODE_18409_length_167_cov_1.677966_g18309_i0	PRJNA1248471	18409	167	1.677966	2.80220322	Microvirga antarctica	2819233	Bacteria	Bacteria	89.4	2.09e-20	NR	WP_210485609.1	2819233	g18309	i0	82.7	2.80239520958084	52	9	93.4	0	1	156	62	113	WP_210485609.1 NAD(P)-dependent oxidoreductase [Microvirga antarctica]	diamond	468	89.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Microvirga	Microvirga antarctica
30800174	30800174	PRJNA1248471_S_NODE_8254_length_213_cov_2.085366_g8154_i0	PRJNA1248471	8254	213	2.085366	4.44182958	Aquipseudomonas alcaligenes	43263	Bacteria	Bacteria	45.1	0.00312	NR	WP_373388768.1	43263	g8154	i0	36.5	0.732394366197183	52	33	73.2	0	175	20	124	175	WP_373388768.1 lysoplasmalogenase family protein [Aquipseudomonas alcaligenes]	diamond	156	45.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Aquipseudomonas	Aquipseudomonas alcaligenes
31274275	31274275	PRJNA1248471_S_NODE_15615_length_177_cov_1.195312_g15515_i0	PRJNA1248471	15615	177	1.195312	2.11570224	Rhodocyclaceae bacterium	1898103	Bacteria	Bacteria	40	0.0317	NR	HMX15607.1	1898103	g15515	i0	54.8	0.525423728813559	31	14	52.5	0	116	24	8	38	HMX15607.1 hypothetical protein [Rhodocyclaceae bacterium]	diamond	93	40	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae		Rhodocyclaceae bacterium
31432432	31432432	PRJNA1248471_S_NODE_11796_length_196_cov_1.217687_g11696_i0	PRJNA1248471	11796	196	1.217687	2.38666652	Afipia sp.	1871052	Bacteria	Bacteria	79.7	1.85e-17	NR	HEY0236965.1	1871052	g11696	i0	84.8	1.4234693877551	46	7	70.4	0	191	54	63	108	HEY0236965.1 DUF559 domain-containing protein [Afipia sp.]	diamond	279	79.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Afipia	Afipia sp.
32589530	32589530	PRJNA1248471_S_NODE_12159_length_194_cov_2.331034_g12059_i0	PRJNA1248471	12159	194	2.331034	4.52220596	Hyphomicrobiales	356	Bacteria	Bacteria	105	3.1699999999999997e-25	NR	MBY0382260.1	2021379	g12059	i0	92	1.53092783505155	50	4	77.3	0	32	181	282	331	MBY0382260.1 ABC transporter substrate-binding protein [Xanthobacteraceae bacterium]	diamond	297	106	0.990566037735849	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Xanthobacteraceae		Xanthobacteraceae bacterium
32728846	32728846	PRJNA1248471_S_NODE_21840_length_162_cov_0.902655_g21740_i0	PRJNA1248471	21840	162	0.902655	1.4623011	Escherichia coli	562	Bacteria	Bacteria	39.7	0.024	NR	WP_309049012.1	562	g21740	i0	50	0.814814814814815	44	19	81.5	1	148	17	1	41	WP_309049012.1 hypothetical protein, partial [Escherichia coli]	diamond	132	39.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32823261	32823261	PRJNA1248471_S_NODE_21160_length_163_cov_0.885965_g21060_i0	PRJNA1248471	21160	163	0.885965	1.44412295	Escherichia coli	562	Bacteria	Bacteria	49.7	3.48e-6	NR	KJG94335.1	562	g21060	i0	63.6	2.94478527607362	33	12	60.7	0	162	64	35	67	KJG94335.1 hypothetical protein UC40_25285, partial [Escherichia coli]	diamond	480	49.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
32854657	32854657	PRJNA1248471_S_NODE_21920_length_162_cov_0.876106_g21820_i0	PRJNA1248471	21920	162	0.876106	1.41929172	Vibrio vulnificus	672	Bacteria	Bacteria	71.2	8.72e-15	NR	MCA0772538.1	672	g21820	i0	89.2	9.59259259259259	37	4	68.5	0	3	113	30	66	MCA0772538.1 type I glyceraldehyde-3-phosphate dehydrogenase [Vibrio vulnificus]	diamond	1554	71.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio vulnificus

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);;