metadata: contig_metadata: 5 rows where bioproject = "PRJNA478247" and tax

5 rows where bioproject = "PRJNA478247" 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
29633699	29633699	PRJNA478247_P_NODE_3150_length_170_cov_1.638298_g3044_i0	PRJNA478247	3150	170	1.638298	2.7851066	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	81.6	2.55e-16	NR	GIW97490.1	2699754	g3044	i0	70.6	1.8	51	14	88.2	1	3	152	77	127	GIW97490.1 MAG: ATP synthase subunit beta [Pirellulaceae bacterium]	diamond	306	81.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
31308524	31308524	PRJNA478247_P_NODE_3315_length_162_cov_1.894737_g3209_i0	PRJNA478247	3315	162	1.894737	3.06947394	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	57	1.1e-7	NR	HTV47845.1	2026778	g3209	i0	47.1	0.944444444444444	51	27	94.4	0	154	2	31	81	HTV47845.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerae bacterium]	diamond	153	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31561799	31561799	PRJNA478247_P_NODE_2136_length_234_cov_1.814634_g2030_i0	PRJNA478247	2136	234	1.814634	4.24624356	Phycisphaerae bacterium RAS1	2528034	Bacteria	Bacteria	58.5	4.03e-8	NR	TWT45993.1	2528034	g2030	i0	47.5	1.02564102564103	80	40	100	1	234	1	58	137	TWT45993.1 Aquaporin Z 2 [Phycisphaerae bacterium RAS1]	diamond	240	58.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium RAS1
31846200	31846200	PRJNA478247_P_NODE_177_length_1143_cov_2.417415_g130_i0	PRJNA478247	177	1143	2.417415	27.63105345	Limisphaera sp.	2838792	Bacteria	Bacteria	224	6.28e-65	NR	MCX7866146.1	2838792	g130	i0	38.1	1.94488188976378	365	179	84	12	1045	86	43	405	MCX7866146.1 hypothetical protein [Limisphaera sp.]	diamond	2223	224	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Limisphaeraceae	Limisphaera	Limisphaera sp.
32194412	32194412	PRJNA478247_P_NODE_3418_length_158_cov_1.961240_g3312_i0	PRJNA478247	3418	158	1.96124	3.0987592	Chlamydiales bacterium	2047757	Bacteria	Bacteria	43.5	0.00478	NR	MDB2614325.1	2047757	g3312	i0	38	0.949367088607595	50	31	94.9	0	6	155	110	159	MDB2614325.1 hypothetical protein [Chlamydiales bacterium]	diamond	150	43.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;