metadata: contig_metadata: 10 rows where bioproject = "PRJNA688352" and tax

10 rows where bioproject = "PRJNA688352" and tax_phylum = "Lentisphaerota"

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
24893068	24893068	PRJNA688352_P_NODE_9780_length_246_cov_0.890173_g9677_i0	PRJNA688352	9780	246	0.890173	2.18982558	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	149	1.25e-41	NR	MBQ9500544.1	2053569	g9677	i0	82.3	0.963414634146341	79	14	96.3	0	245	9	294	372	MBQ9500544.1 glycoside hydrolase family 99-like domain-containing protein [Lentisphaeria bacterium]	diamond	237	149	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
26713712	26713712	PRJNA688352_P_NODE_11981_length_242_cov_0.905325_g11878_i0	PRJNA688352	11981	242	0.905325	2.1908865	Bacteria	2	Bacteria	Bacteria	135	7.379999999999998e-35	NR	MBO4649053.1	2053569	g11878	i0	81.3	2.97520661157025	80	15	99.2	0	1	240	337	416	MBO4649053.1 hypothetical protein [Lentisphaeria bacterium]	diamond	720	135	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27871866	27871866	PRJNA688352_P_NODE_10825_length_244_cov_0.900585_g10722_i0	PRJNA688352	10825	244	0.900585	2.1974274	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	84.3	8.33e-17	NR	MCP3965606.1	1932692	g10722	i0	63.2	1.61065573770492	68	25	83.6	0	243	40	462	529	MCP3965606.1 IS1634 family transposase [Lentisphaerota bacterium]	diamond	393	84.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27883412	27883412	PRJNA688352_P_NODE_11665_length_242_cov_0.911243_g11562_i0	PRJNA688352	11665	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	64.7	6.72e-10	NR	MBE6397167.1	1932692	g11562	i0	43.5	4.12809917355372	85	36	94.2	3	4	231	31	112	MBE6397167.1 hypothetical protein [Lentisphaerota bacterium]	diamond	999	64.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28009991	28009991	PRJNA688352_P_NODE_7945_length_250_cov_0.870056_g7842_i0	PRJNA688352	7945	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	2.02e-20	NR	MBN2302576.1	1932692	g7842	i0	53.7	3.72	82	38	98.4	0	250	5	482	563	MBN2302576.1 VWA domain-containing protein [Lentisphaerota bacterium]	diamond	930	95.5	0.991623036649215	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28282147	28282147	PRJNA688352_P_NODE_8826_length_248_cov_0.880000_g8723_i0	PRJNA688352	8826	248	0.88	2.1824	Lentisphaerae bacterium RIFOXYA12_FULL_48_11	1798578	Bacteria	Bacteria	86.3	2.71e-19	NR	OGV57349.1	1798578	g8723	i0	90.5	0.508064516129032	42	4	50.8	0	123	248	1	42	OGV57349.1 MAG: hypothetical protein A2283_18375 [Lentisphaerae bacterium RIFOXYA12_FULL_48_11]	diamond	126	86.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium RIFOXYA12_FULL_48_11
29335922	29335922	PRJNA688352_P_NODE_11729_length_242_cov_0.911243_g11626_i0	PRJNA688352	11729	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	117	6.139999999999999e-31	NR	MBN1557766.1	1932692	g11626	i0	70.5	2.93801652892562	78	23	96.7	0	236	3	9	86	MBN1557766.1 sugar kinase [Lentisphaerota bacterium]	diamond	711	117	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30062063	30062063	PRJNA688352_P_NODE_11891_length_242_cov_0.911243_g11788_i0	PRJNA688352	11891	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	127	6.199999999999999e-32	NR	WP_007277623.1	256847	g11788	i0	68.8	4.95867768595041	80	16	97.9	2	1	237	653	724	WP_007277623.1 LamG-like jellyroll fold domain-containing protein [Lentisphaera araneosa]	diamond	1200	128	0.9921875	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera araneosa
30808944	30808944	PRJNA688352_P_NODE_7794_length_250_cov_0.870056_g7691_i0	PRJNA688352	7794	250	0.870056	2.17514	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	148	7.99e-42	NR	MBE6376597.1	1932692	g7691	i0	92.8	0.996	83	6	99.6	0	2	250	176	258	MBE6376597.1 magnesium transporter CorA family protein [Lentisphaerota bacterium]	diamond	249	148	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
31630809	31630809	PRJNA688352_P_NODE_7076_length_251_cov_0.865169_g6973_i0	PRJNA688352	7076	251	0.865169	2.17157419	Victivallaceae bacterium	2793042	Bacteria	Bacteria	100	2.75e-22	NR	MCQ2378208.1	2793042	g6973	i0	55.4	0.99203187250996006	83	36	99.2	1	250	2	222	303	MCQ2378208.1 amino acid adenylation domain-containing protein [Victivallaceae bacterium]	diamond	249	100	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae 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);;