metadata: contig_metadata: 4 rows where bioproject = "PRJNA853194" and tax

4 rows where bioproject = "PRJNA853194" and tax_clade = "PVC group"

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
21243168	21243168	PRJNA853194_S_NODE_79837_length_247_cov_1.396552_g78746_i0	PRJNA853194	79837	247	1.396552	3.44948344	Bacteria	2	Bacteria	Bacteria	70.1	9.12e-12	NR	HBI30633.1	2026801	g78746	i0	51.9	5.73279352226721	77	34	89.9	1	225	4	485	561	HBI30633.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	1416	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27939553	27939553	PRJNA853194_S_NODE_43105_length_328_cov_1.870588_g42014_i0	PRJNA853194	43105	328	1.870588	6.13552864	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	56.2	1.68e-6	NR	MFC1593786.1	2035772	g42014	i0	52.8	0.969512195121951	53	24	48.5	1	125	283	142	193	MFC1593786.1 GDP-L-fucose synthase family protein [Candidatus Omnitrophota bacterium]	diamond	318	56.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32678491	32678491	PRJNA853194_S_NODE_78860_length_248_cov_1.817143_g77769_i0	PRJNA853194	78860	248	1.817143	4.50651464	Posidoniimonas polymericola	2528002	Bacteria	Bacteria	44.7	0.00814	NR	WP_146587297.1	2528002	g77769	i0	48.8	0.520161290322581	43	22	52	0	98	226	1	43	WP_146587297.1 DUF1501 domain-containing protein [Posidoniimonas polymericola]	diamond	129	44.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Posidoniimonas	Posidoniimonas polymericola
32899008	32899008	PRJNA853194_S_NODE_41120_length_335_cov_1.339695_g40029_i0	PRJNA853194	41120	335	1.339695	4.48797825	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	43.9	0.0319	NR	HUB27357.1	2876886	g40029	i0	32.8	0.546268656716418	61	41	54.6	0	36	218	101	161	HUB27357.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	183	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;