metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB48872" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB48872" 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
1365587	1365587	PRJEB48872_P_NODE_76762_length_783_cov_2.345430_g62671_i0	PRJEB48872	76762	783	2.34543	18.3647169	Humisphaera borealis	2807512	Bacteria	Bacteria	965	0	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g62671	i0	89.059	127.501915708812	786	75	99	11	1	782	5063786	5063008	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	99834	965	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
2631413	2631413	PRJEB48872_P_NODE_503903_length_192_cov_3.111111_g488091_i0	PRJEB48872	503903	192	3.111111	5.97333312	Humisphaera borealis	2807512	Bacteria	Bacteria	268	1.5099999999999998e-67	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g488091	i0	96.894	108.713541666667	161	3	84	2	32	192	5064245	5064403	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	20873	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
2638362	2638362	PRJEB48872_P_NODE_646123_length_159_cov_1.425000_g630311_i0	PRJEB48872	646123	159	1.425	2.26575	Aquisphaera giovannonii	406548	Bacteria	Bacteria	254	3.36e-63	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g630311	i0	95.597	77.937106918239	159	5	99	2	2	159	5178964	5179121	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	12392	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
15018576	15018576	PRJEB48872_P_NODE_564972_length_176_cov_1.854015_g549160_i0	PRJEB48872	564972	176	1.854015	3.2630664	Gemmataceae	1914233	Bacteria	Bacteria	265	1.7499999999999998e-66	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g549160	i0	93.785	69.5227272727273	177	9	100	2	1	176	3634047	3634222	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	12236	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
19214762	19214762	PRJEB48872_P_NODE_663756_length_156_cov_1.247863_g647944_i0	PRJEB48872	663756	156	1.247863	1.94666628	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	268	1.1699999999999997e-67	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g647944	i0	98.052	279.192307692308	154	3	99	0	2	155	4319681	4319834	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	43554	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23036313	23036313	PRJEB48872_P_NODE_560999_length_177_cov_1.782609_g545187_i0	PRJEB48872	560999	177	1.782609	3.15521793	Humisphaera borealis	2807512	Bacteria	Bacteria	145	2.4e-30	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g545187	i0	86.364	8.05084745762712	132	18	75	0	1	132	5064014	5063883	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	1425	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
23943056	23943056	PRJEB48872_P_NODE_548719_length_180_cov_2.000000_g532907_i0	PRJEB48872	548719	180	2	3.6	Verrucomicrobiota	74201	Bacteria	Bacteria	250	5.04e-62	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g532907	i0	91.713	18.9833333333333	181	14	100	1	1	180	3894162	3893982	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	3417	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;