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

5 rows where bioproject = "PRJNA826497", 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_family	tax_genus	tax_species
25046946	25046946	PRJNA826497_S_NODE_17060_length_158_cov_10.176000_g17020_i0	PRJNA826497	17060	158	10.176	16.07808	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	63.9	6.03e-6	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g17020	i0	95.122	0.259493670886076	41	1	26	1	106	146	910986	910947	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	41	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
30117536	30117536	PRJNA826497_S_NODE_11792_length_178_cov_4.206897_g11752_i0	PRJNA826497	11792	178	4.206897	7.48827666	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	84.7	1.59e-19	NR	MCB1087017.1	2499141	g11752	i0	64.8	1.80337078651685	54	19	91	0	2	163	55	108	MCB1087017.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	321	84.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30117543	30117543	PRJNA826497_S_NODE_9372_length_191_cov_2.708861_g9332_i0	PRJNA826497	9372	191	2.708861	5.17392451	Opitutus sp.	1913982	Bacteria	Bacteria	60.5	1.05e-8	NR	HVU25758.1	1913982	g9332	i0	54.2	0.926701570680628	59	26	92.7	1	191	15	525	582	HVU25758.1 hypothetical protein [Opitutus sp.]	diamond	177	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
30844453	30844453	PRJNA826497_S_NODE_8954_length_193_cov_7.925000_g8914_i0	PRJNA826497	8954	193	7.925	15.29525	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	40.4	0.0489	NR	HEY2342399.1	2811408	g8914	i0	51.6	0.481865284974093	31	15	48.2	0	189	97	41	71	HEY2342399.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	93	40.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
32394087	32394087	PRJNA826497_S_NODE_1879_length_289_cov_4.539062_g1839_i0	PRJNA826497	1879	289	4.539062	13.11788918	Akkermansia sp.	1872421	Bacteria	Bacteria	53.5	1.03e-5	NR	MBR5876151.1	1872421	g1839	i0	50	0.685121107266436	66	28	63.3	2	284	102	1042	1107	MBR5876151.1 ankyrin repeat domain-containing protein [Akkermansia sp.]	diamond	198	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.

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