metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA667863" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA667863" 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
7012645	7012645	PRJNA667863_P_NODE_9686_length_259_cov_3.069892_g9652_i0	PRJNA667863	9686	259	3.069892	7.95102028	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	344	3.48e-90	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g9652	i0	91.304	149.984555984556	253	20	97	2	8	259	3096900	3097151	Pirellula sp. SH-Sr6A, complete genome	blastn	38846	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
22311334	22311334	PRJNA667863_P_NODE_2678_length_362_cov_2.342561_g2644_i0	PRJNA667863	2678	362	2.342561	8.48007082	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	592	1.6399999999999999e-164	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g2644	i0	96.133	212.176795580111	362	14	100	0	1	362	1296	935	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	76808	592	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
22311396	22311396	PRJNA667863_P_NODE_7798_length_272_cov_1.417085_g7764_i0	PRJNA667863	7798	272	1.417085	3.8544712	Symmachiella dynata	2527995	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1712609668\|gb\|CP036276.1\|	2527995	g7764	i0	100	0.227941176470588	30	0	11	0	186	215	3237577	3237606	Symmachiella dynata strain Mal52 chromosome, complete genome	blastn	62	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
23586634	23586634	PRJNA667863_P_NODE_12359_length_249_cov_0.875000_g12325_i0	PRJNA667863	12359	249	0.875	2.17875	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g12325	i0	96.8	46.6987951807229	250	6	100	2	1	249	1599923	1600171	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	11628	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
24115461	24115461	PRJNA667863_P_NODE_7039_length_278_cov_1.497561_g7005_i0	PRJNA667863	7039	278	1.497561	4.16321958	Gemmata	113	Bacteria	Bacteria	268	2.3299999999999994e-67	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g7005	i0	87.826	3.3884892086330902	230	26	82	2	1	229	2494268	2494496	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	942	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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