metadata: contig_metadata: 6 rows where bioproject = "PRJNA902848", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA902848", tax_clade = "PVC group" 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_species
26802601	26802601	PRJNA902848_P_NODE_9581_length_290_cov_1.115207_g9531_i0	PRJNA902848	9581	290	1.115207	3.2341003	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	120	1.09e-29	NR	MBM4148977.1	1932692	g9531	i0	57.3	0.993103448275862	96	41	99.3	0	2	289	307	402	MBM4148977.1 hypothetical protein [Lentisphaerota bacterium]	diamond	288	120	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
27814218	27814218	PRJNA902848_P_NODE_14324_length_251_cov_0.876404_g14274_i0	PRJNA902848	14324	251	0.876404	2.19977404	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	78.6	8.6e-15	NR	NLF86514.1	1932692	g14274	i0	70.4	1.29083665338645	54	16	64.5	0	162	1	1	54	NLF86514.1 Gfo/Idh/MocA family oxidoreductase [Lentisphaerota bacterium]	diamond	324	78.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
29077098	29077098	PRJNA902848_P_NODE_16908_length_247_cov_0.896552_g16858_i0	PRJNA902848	16908	247	0.896552	2.21448344	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	119	4.37e-29	NR	NLF18417.1	1932692	g16858	i0	65.9	0.995951417004049	82	26	97.2	1	6	245	576	657	NLF18417.1 hypothetical protein [Lentisphaerota bacterium]	diamond	246	119	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
30087376	30087376	PRJNA902848_P_NODE_17352_length_246_cov_1.190751_g17302_i0	PRJNA902848	17352	246	1.190751	2.92924746	Lentisphaerae bacterium RIFOXYC12_FULL_6	1932692	Bacteria	Bacteria	142	9.98e-39	NR	OGV64145.1	1798582	g17302	i0	76.5	0.98780487804878	81	19	98.8	0	245	3	134	214	OGV64145.1 MAG: glycoside hydrolase [Lentisphaerae bacterium RIFOXYC12_FULL_60_16]	diamond	243	142	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerae bacterium RIFOXYC12_FULL_60_16
30182151	30182151	PRJNA902848_P_NODE_13972_length_252_cov_0.871508_g13922_i0	PRJNA902848	13972	252	0.871508	2.19620016	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	96.3	6.0100000000000005e-21	NR	NLF17846.1	1932692	g13922	i0	61.7	0.964285714285714	81	31	96.4	0	251	9	438	518	NLF17846.1 hypothetical protein [Lentisphaerota bacterium]	diamond	243	96.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
32395495	32395495	PRJNA902848_P_NODE_16139_length_248_cov_0.891429_g16089_i0	PRJNA902848	16139	248	0.891429	2.21074392	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	130	5.19e-35	NR	MBN2450456.1	2053569	g16089	i0	80.5	0.931451612903226	77	15	93.1	0	18	248	88	164	MBN2450456.1 prephenate dehydrogenase [Lentisphaeria bacterium]	diamond	231	130	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria 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);;