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

10 rows where analysis = "blastn", bioproject = "PRJNA533114" 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
1780799	1780799	PRJNA533114_P_NODE_70642_length_286_cov_1.169014_g70390_i0	PRJNA533114	70642	286	1.169014	3.34338004	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	302	2.3800000000000002e-77	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g70390	i0	85.714	1.0034965034965	287	39	100	2	1	286	1988649	1988934	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	287	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
1781026	1781026	PRJNA533114_P_NODE_91342_length_254_cov_1.270718_g91090_i0	PRJNA533114	91342	254	1.270718	3.22762372	Polystyrenella longa	2528007	Bacteria	Bacteria	89.8	1.76e-13	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g91090	i0	100	0.87007874015748	48	0	19	0	198	245	2410405	2410452	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	221	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
2393024	2393024	PRJNA533114_P_NODE_23962_length_463_cov_2.848718_g23712_i0	PRJNA533114	23962	463	2.848718	13.18956434	PVC group	1783257	Bacteria	Bacteria	52.8	0.045	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g23712	i0	100	0.181425485961123	28	0	6	0	227	254	2816742	2816769	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	84	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5608560	5608560	PRJNA533114_P_NODE_2245_length_1337_cov_5.015823_g2134_i0	PRJNA533114	2245	1337	5.015823	67.06155351	Poriferisphaera corsica	2528020	Bacteria	Bacteria	67.6	4.89e-6	NTclustered	gi\|1712598971\|gb\|CP036425.1\|	2528020	g2134	i0	93.333	0.0575916230366492	45	3	3	0	1054	1098	1032769	1032725	Poriferisphaera corsica strain KS4 chromosome, complete genome	blastn	77	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Poriferisphaera	Poriferisphaera corsica
14534176	14534176	PRJNA533114_P_NODE_6152_length_891_cov_5.048900_g5971_i0	PRJNA533114	6152	891	5.0489	44.985699	Bremerella sp. P1	3026424	Bacteria	Bacteria	54.7	0.025	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g5971	i0	100	0.0325476992143659	29	0	3	0	391	419	4051794	4051822	Bremerella sp. P1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1
17082748	17082748	PRJNA533114_P_NODE_61454_length_304_cov_1.333333_g61202_i0	PRJNA533114	61454	304	1.333333	4.05333232	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g61202	i0	100	0.217105263157895	29	0	10	0	51	79	1652077	1652105	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	66	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
22181658	22181658	PRJNA533114_P_NODE_32298_length_403_cov_1.572727_g32046_i0	PRJNA533114	32298	403	1.572727	6.33808981	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g32046	i0	100	0.0719602977667494	29	0	7	0	297	325	5299867	5299895	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
23457106	23457106	PRJNA533114_P_NODE_29479_length_420_cov_2.723343_g29227_i0	PRJNA533114	29479	420	2.723343	11.4380406	Poriferisphaera corsica	2528020	Bacteria	Bacteria	67.6	1.44e-6	NTclustered	gi\|1712598971\|gb\|CP036425.1\|	2528020	g29227	i0	93.333	0.107142857142857	45	3	11	0	97	141	1032769	1032725	Poriferisphaera corsica strain KS4 chromosome, complete genome	blastn	45	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Poriferisphaera	Poriferisphaera corsica
24731626	24731626	PRJNA533114_P_NODE_93700_length_251_cov_0.865169_g93448_i0	PRJNA533114	93700	251	0.865169	2.17157419	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	135	2.2e-27	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g93448	i0	80.412	31.4422310756972	194	24	76	10	1	190	383317	383500	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	7892	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25343944	25343944	PRJNA533114_P_NODE_64700_length_296_cov_2.932735_g64448_i0	PRJNA533114	64700	296	2.932735	8.6808956	Gemmata	113	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g64448	i0	96.97	0.358108108108108	33	1	11	0	186	218	955182	955150	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	106	56.5	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);;