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

5 rows where analysis = "blastn", bioproject = "PRJNA635397" 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
605924	605924	PRJNA635397_P_NODE_42861_length_247_cov_0.890805_g42407_i0	PRJNA635397	42861	247	0.890805	2.20028835	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	272	1.5699999999999999e-68	NTclustered	gi\|1702190059\|gb\|CP030884.1\|	2026779	g42407	i0	86.694	116.951417004049	248	29	99	4	1	245	438505	438751	Planctomycetaceae bacterium isolate ECT2AJA-110-A chromosome	blastn	28887	272	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
2428982	2428982	PRJNA635397_P_NODE_7762_length_651_cov_2.598616_g7320_i0	PRJNA635397	7762	651	2.598616	16.91699016	Planctomycetia	203683	Bacteria	Bacteria	974	0	NTclustered	gi\|219903967\|emb\|AM935706.1\|	100371	g7320	i0	94.21	103.668202764977	639	35	98	2	1	638	638	1	Uncultured Planctomycetales bacterium partial 16S rRNA gene, clone AMCA8	blastn	67488	981	0.992864424057085	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
6984504	6984504	PRJNA635397_P_NODE_46706_length_242_cov_0.911243_g46252_i0	PRJNA635397	46706	242	0.911243	2.20520806	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	313	9.06e-81	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g46252	i0	90.041	30.6404958677686	241	24	99	0	1	241	2503158	2502918	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	7415	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
17183987	17183987	PRJNA635397_P_NODE_48374_length_208_cov_4.192593_g47920_i0	PRJNA635397	48374	208	4.192593	8.72059344	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	318	1.63e-82	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g47920	i0	94.313	134.024038461538	211	6	100	5	1	208	267249	267456	Tautonia plasticadhaerens strain ElP chromosome	blastn	27877	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
23558406	23558406	PRJNA635397_P_NODE_32239_length_279_cov_2.611650_g31785_i0	PRJNA635397	32239	279	2.61165	7.2865035	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	455	1.68e-123	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g31785	i0	96.057	196.10394265233	279	11	100	0	1	279	267668	267946	Tautonia plasticadhaerens strain ElP chromosome	blastn	54713	455	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens

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