metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA896758" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA896758" 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
872793	872793	PRJNA896758_P_NODE_14801_length_298_cov_0.973333_g14411_i0	PRJNA896758	14801	298	0.973333	2.90053234	Humisphaera borealis	2807512	Bacteria	Bacteria	377	4.02e-100	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g14411	i0	89.597	24.8221476510067	298	29	99	2	1	297	5062919	5063215	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	7397	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
3423574	3423574	PRJNA896758_P_NODE_15963_length_287_cov_2.014019_g15573_i0	PRJNA896758	15963	287	2.014019	5.78023453	Humisphaera borealis	2807512	Bacteria	Bacteria	278	4.02e-70	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g15573	i0	85.199	167.773519163763	277	33	95	6	1	272	5062759	5063032	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	48151	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
3795828	3795828	PRJNA896758_P_NODE_15983_length_287_cov_1.439252_g15593_i0	PRJNA896758	15983	287	1.439252	4.13065324	root	1	Root_unresolved	Root_unresolved	52.8	0.027	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g15593	i0	100	0.195121951219512	28	0	10	0	122	149	5067330	5067303	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
4701389	4701389	PRJNA896758_P_NODE_20424_length_256_cov_1.683060_g20034_i0	PRJNA896758	20424	256	1.68306	4.3086336	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	252	2.14e-62	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g20034	i0	88.018	68.3359375	217	20	84	5	1	214	1831549	1831336	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	17494	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
4701432	4701432	PRJNA896758_P_NODE_2584_length_719_cov_1.012384_g2222_i0	PRJNA896758	2584	719	1.012384	7.27904096	Urbifossiella limnaea	2528023	Bacteria	Bacteria	808	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g2222	i0	87.137	317.091794158554	723	80	99	8	3	719	2017949	2018664	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	227989	808	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
7250933	7250933	PRJNA896758_P_NODE_18646_length_269_cov_1.673469_g18256_i0	PRJNA896758	18646	269	1.673469	4.50163161	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	137	6.61e-28	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g18256	i0	77.154	161.401486988848	267	41	97	16	6	267	4317196	4317447	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	43417	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14900701	14900701	PRJNA896758_P_NODE_11132_length_344_cov_1.309963_g10742_i0	PRJNA896758	11132	344	1.309963	4.50627272	Chthoniobacter flavus	191863	Bacteria	Bacteria	514	3.45e-141	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g10742	i0	93.66	265.470930232558	347	16	100	6	1	344	2341	1998	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	91322	514	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
14900809	14900809	PRJNA896758_P_NODE_25632_length_243_cov_0.905882_g25242_i0	PRJNA896758	25632	243	0.905882	2.20129326	Ereboglobus luteus	1796921	Bacteria	Bacteria	130	9.84e-26	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g25242	i0	78.713	1.52263374485597	202	38	83	3	15	215	1639177	1638980	Ereboglobus luteus strain Ho45, complete genome	blastn	370	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
16175659	16175659	PRJNA896758_P_NODE_7213_length_421_cov_2.229885_g6823_i0	PRJNA896758	7213	421	2.229885	9.38781585	Urbifossiella limnaea	2528023	Bacteria	Bacteria	412	1.6099999999999993e-110	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6823	i0	84.434	54.9144893111639	424	61	100	4	1	421	2017989	2017568	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	23119	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
17451024	17451024	PRJNA896758_P_NODE_17994_length_274_cov_1.203980_g17604_i0	PRJNA896758	17994	274	1.20398	3.2989052	Pirellulimonas nuda	2528009	Bacteria	Bacteria	222	1.81e-53	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g17604	i0	82.869	1.91970802919708	251	39	91	4	1	249	405465	405217	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	526	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
21274800	21274800	PRJNA896758_P_NODE_26377_length_241_cov_0.916667_g25987_i0	PRJNA896758	26377	241	0.916667	2.20916747	Humisphaera borealis	2807512	Bacteria	Bacteria	148	2.69e-31	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g25987	i0	78.661	12.2240663900415	239	39	97	12	1	233	1161900	1162132	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	2946	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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