metadata: contig_metadata: 5 rows where bioproject = "PRJNA798511", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA798511", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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_species
26927371	26927371	PRJNA798511_P_NODE_47302_length_371_cov_1.419463_g43036_i0	PRJNA798511	47302	371	1.419463	5.26620773	Opitutales bacterium	2026772	Bacteria	Bacteria	44.3	0.0403	NR	MEL0005672.1	2026772	g43036	i0	44.1	0.549865229110512	68	32	51.8	4	300	109	111	176	MEL0005672.1 substrate-binding domain-containing protein [Opitutales bacterium]	diamond	204	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutales bacterium
28980475	28980475	PRJNA798511_P_NODE_10888_length_1432_cov_35.709345_g8254_i0	PRJNA798511	10888	1432	35.709345	511.3578204	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.4	5.62e-20	NR	MFH0952965.1	2026799	g8254	i0	44.4	0.207402234636872	99	54	20.7	1	783	487	104	201	MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium]	diamond	297	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			Verrucomicrobiota bacterium
30338759	30338759	PRJNA798511_P_NODE_82892_length_261_cov_0.819149_g78626_i0	PRJNA798511	82892	261	0.819149	2.13797889	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.9	4.24e-12	NR	MBT3191068.1	2026799	g78626	i0	38.4	8.45977011494253	86	52	98.9	1	259	2	101	185	MBT3191068.1 ATP-dependent Clp protease proteolytic subunit [Verrucomicrobiota bacterium]	diamond	2208	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			Verrucomicrobiota bacterium
30812150	30812150	PRJNA798511_P_NODE_14574_length_1103_cov_32.100971_g8254_i2	PRJNA798511	14574	1103	32.100971	354.07371013	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	81.3	6.59e-14	NR	MFH0952965.1	2026799	g8254	i2	42.4	0.677243880326383	85	48	23.1	1	741	487	118	201	MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium]	diamond	747	81.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			Verrucomicrobiota bacterium
32835075	32835075	PRJNA798511_P_NODE_49180_length_361_cov_1.829861_g44914_i0	PRJNA798511	49180	361	1.829861	6.60579821	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	48.5	0.00133	NR	HEU5068864.1	2499141	g44914	i0	37.7	0.506925207756233	61	29	44	3	229	71	517	576	HEU5068864.1 MFS transporter [Verrucomicrobiia bacterium]	diamond	183	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia		Verrucomicrobiia 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);;