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

5 rows where bioproject = "PRJNA658591", 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_species
29146588	29146588	PRJNA658591_S_NODE_10329_length_162_cov_0.920354_g10266_i0	PRJNA658591	10329	162	0.920354	1.49097348	Bacteria	2	Bacteria	Bacteria	61.6	6.39e-11	NR	GBL24036.1	2026771	g10266	i0	59.6	7.55555555555556	47	19	87	0	2	142	18	64	GBL24036.1 secretory immunoglobulin A-binding protein EsiB [Opitutia bacterium]	diamond	1224	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia			Opitutia bacterium
30144204	30144204	PRJNA658591_S_NODE_11252_length_154_cov_3.504762_g11189_i0	PRJNA658591	11252	154	3.504762	5.39733348	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	67.8	5.22e-13	NR	RYD73501.1	2026800	g11189	i0	78.6	0.818181818181818	42	9	81.8	0	128	3	3	44	RYD73501.1 MAG: fructose-bisphosphate aldolase class I [Verrucomicrobiaceae bacterium]	diamond	126	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
30902916	30902916	PRJNA658591_S_NODE_1994_length_298_cov_2.927711_g1931_i0	PRJNA658591	1994	298	2.927711	8.72457878	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	144	1.07e-39	NR	RYD65414.1	2026800	g1931	i0	82	0.895973154362416	89	16	89.6	0	294	28	73	161	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	267	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
31218430	31218430	PRJNA658591_S_NODE_3755_length_231_cov_1.510989_g3692_i0	PRJNA658591	3755	231	1.510989	3.49038459	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	98.2	2.0900000000000002e-22	NR	RYD65414.1	2026800	g3692	i0	64.5	0.987012987012987	76	27	98.7	0	229	2	177	252	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	228	98.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
31693220	31693220	PRJNA658591_S_NODE_57_length_1122_cov_5.536813_g42_i0	PRJNA658591	57	1122	5.536813	62.12304186	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	251	5.65e-77	NR	RYD71398.1	2026800	g42	i0	45.7	0.802139037433155	300	150	78.6	6	9	890	69	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	900	251	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae 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);;