metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA600413" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA600413" 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
1141964	1141964	PRJNA600413_P_NODE_155801_length_153_cov_2.865385_g155100_i0	PRJNA600413	155801	153	2.865385	4.38403905	Gemmata	113	Bacteria	Bacteria	219	1.1699999999999999e-52	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g155100	i0	93.793	2.84313725490196	145	9	95	0	1	145	5343564	5343420	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	435	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
6953686	6953686	PRJNA600413_P_NODE_97846_length_169_cov_1.700000_g97145_i0	PRJNA600413	97846	169	1.7	2.873	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	134	4.9000000000000005e-27	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g97145	i0	88.288	3.70414201183432	111	13	66	0	59	169	4949001	4949111	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	626	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
7519475	7519475	PRJNA600413_P_NODE_103206_length_167_cov_0.864407_g102505_i0	PRJNA600413	103206	167	0.864407	1.44355969	Gemmata	113	Bacteria	Bacteria	128	2.26e-25	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g102505	i0	81.935	3.78443113772455	155	24	92	4	12	164	3801861	3802013	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	632	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9502710	9502710	PRJNA600413_P_NODE_41928_length_224_cov_1.165714_g41227_i0	PRJNA600413	41928	224	1.165714	2.61119936	Urbifossiella limnaea	2528023	Bacteria	Bacteria	303	4.98e-78	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g41227	i0	91.781	4.25446428571429	219	17	98	1	2	220	2018259	2018476	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	953	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9503569	9503569	PRJNA600413_P_NODE_84268_length_177_cov_1.593750_g83567_i0	PRJNA600413	84268	177	1.59375	2.8209375	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	228	2.3099999999999997e-55	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g83567	i0	89.831	1.3728813559322	177	18	100	0	1	177	2619048	2619224	Tautonia plasticadhaerens strain ElP chromosome	blastn	243	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
15170716	15170716	PRJNA600413_P_NODE_66292_length_189_cov_1.278571_g65591_i0	PRJNA600413	66292	189	1.278571	2.41649919	Pseudomonadati	3379134	Bacteria	Bacteria	65.8	2.08e-6	NTclustered	gi\|1712502609\|gb\|CP036270.1\|	2527995	g65591	i0	90.196	1.3015873015873	51	3	29	2	28	77	756224	756273	Symmachiella dynata strain Pan258 chromosome	blastn	246	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Symmachiella	Symmachiella dynata
15876211	15876211	PRJNA600413_P_NODE_145993_length_161_cov_0.910714_g145292_i0	PRJNA600413	145993	161	0.910714	1.46624954	Paludisphaera borealis	1387353	Bacteria	Bacteria	143	7.72e-30	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g145292	i0	87.2	48.6086956521739	125	16	78	0	7	131	811691	811815	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	7826	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
15877548	15877548	PRJNA600413_P_NODE_61393_length_193_cov_1.062500_g60692_i0	PRJNA600413	61393	193	1.0625	2.050625	Bythopirellula goksoeyrii	1400387	Bacteria	Bacteria	335	1.48e-87	NTclustered	gi\|1727544988\|gb\|CP042913.1\|	1400387	g60692	i0	97.927	153.538860103627	193	4	100	0	1	193	5091483	5091291	Bythopirellula goksoeyrii strain Pr1d chromosome	blastn	29633	335	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
15877949	15877949	PRJNA600413_P_NODE_81713_length_179_cov_0.953846_g81012_i0	PRJNA600413	81713	179	0.953846	1.70738434	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	134	5.2600000000000005e-27	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g81012	i0	80.814	0.960893854748603	172	31	96	2	3	173	3310474	3310644	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	172	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21544603	21544603	PRJNA600413_P_NODE_88797_length_174_cov_1.880000_g88096_i0	PRJNA600413	88797	174	1.88	3.2712	Verrucomicrobiota	74201	Bacteria	Bacteria	311	2.19e-80	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g88096	i0	98.851	60.683908045977	174	2	100	0	1	174	3174	3347	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	10559	311	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2

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