metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA1016321" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA1016321" 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
159578	159578	PRJNA1016321_P_NODE_35801_length_299_cov_1.039823_g35570_i0	PRJNA1016321	35801	299	1.039823	3.10907077	Planctomycetia bacterium	2052181	Bacteria	Bacteria	211	4.33e-50	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g35570	i0	80.427	1.17056856187291	281	51	93	4	21	299	550209	549931	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	350	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
7812624	7812624	PRJNA1016321_P_NODE_57687_length_226_cov_2.496732_g57456_i0	PRJNA1016321	57687	226	2.496732	5.64261432	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	335	1.7799999999999993e-87	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g57456	i0	95.714	97.7433628318584	210	5	91	2	21	226	2496589	2496798	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	22090	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
11638489	11638489	PRJNA1016321_P_NODE_50610_length_248_cov_0.880000_g50379_i0	PRJNA1016321	50610	248	0.88	2.1824	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	287	5.649999999999999e-73	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g50379	i0	88.841	0.939516129032258	233	26	94	0	16	248	1825337	1825105	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	233	287	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12913694	12913694	PRJNA1016321_P_NODE_57971_length_203_cov_8.069231_g57740_i0	PRJNA1016321	57971	203	8.069231	16.38053893	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	185	1.67e-42	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g57740	i0	84.946	3.89162561576355	186	24	91	3	20	203	2919803	2919620	Blastopirellula sp. J2-11 chromosome	blastn	790	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11

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