metadata: contig_metadata: 14 rows where bioproject = "PRJNA881257" and tax

14 rows where bioproject = "PRJNA881257" 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
6344636	6344636	PRJNA881257_P_NODE_6785_length_278_cov_0.951965_g6540_i0	PRJNA881257	6785	278	0.951965	2.6464627	Opitutaceae	134623	Bacteria	Bacteria	303	6.4e-78	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g6540	i0	87.984	215.046762589928	258	29	92	2	9	265	631	375	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	59783	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
8511510	8511510	PRJNA881257_P_NODE_16227_length_165_cov_1.568966_g15982_i0	PRJNA881257	16227	165	1.568966	2.5887939	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	220	3.57e-53	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g15982	i0	91.772	105.957575757576	158	13	96	0	8	165	1831080	1831237	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	17483	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9786456	9786456	PRJNA881257_P_NODE_14628_length_168_cov_1.310924_g14383_i0	PRJNA881257	14628	168	1.310924	2.20235232	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	267	4.63e-67	NTclustered	gi\|22203534\|gb\|AY124344.1\|	120965	g14383	i0	95.238	116.541666666667	168	8	100	0	1	168	956	789	Uncultured planctomycete small subunit ribosomal RNA gene, partial sequence	blastn	19579	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
13612248	13612248	PRJNA881257_P_NODE_6191_length_294_cov_1.485714_g5946_i0	PRJNA881257	6191	294	1.485714	4.36799916	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	527	3.719999999999999e-145	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g5946	i0	99.313	46.0102040816327	291	2	99	0	1	291	1405740	1406030	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	13527	527	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
16543205	16543205	PRJNA881257_P_NODE_13093_length_177_cov_1.398438_g12848_i0	PRJNA881257	13093	177	1.398438	2.47523526	Prosthecobacter	48463	Bacteria	Bacteria	283	4.87e-72	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g12848	i0	95.48	71.1977401129944	177	8	100	0	1	177	1000	824	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	12602	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
22535305	22535305	PRJNA881257_P_NODE_17718_length_163_cov_0.912281_g17473_i0	PRJNA881257	17718	163	0.912281	1.48701803	Phycisphaerae	666505	Bacteria	Bacteria	107	2.81e-25	NR	MDB5323872.1	2052180	g17473	i0	98.1	1.98773006134969	54	1	99.4	0	1	162	512	565	MDB5323872.1 pilB [Phycisphaerales bacterium]	diamond	324	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23810738	23810738	PRJNA881257_P_NODE_10039_length_209_cov_2.275000_g9794_i0	PRJNA881257	10039	209	2.275	4.75475	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	353	4.489999999999999e-93	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g9794	i0	97.129	180.693779904306	209	6	100	0	1	209	1404252	1404460	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	37765	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
27719168	27719168	PRJNA881257_P_NODE_6804_length_277_cov_2.267544_g6559_i0	PRJNA881257	6804	277	2.267544	6.28109688	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	43.9	0.0214	NR	MBR4666996.1	2053569	g6559	i0	36	0.541516245487365	50	32	54.2	0	150	1	301	350	MBR4666996.1 hypothetical protein [Lentisphaeria bacterium]	diamond	150	43.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27907876	27907876	PRJNA881257_P_NODE_16085_length_166_cov_0.888889_g15840_i0	PRJNA881257	16085	166	0.888889	1.47555574	Pirellula sp.	117	Bacteria	Bacteria	61.6	2.75e-9	NR	MBA4017182.1	117	g15840	i0	51.9	1.95180722891566	54	26	97.6	0	3	164	48	101	MBA4017182.1 hypothetical protein [Pirellula sp.]	diamond	324	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
28168758	28168758	PRJNA881257_P_NODE_17385_length_163_cov_0.912281_g17140_i0	PRJNA881257	17385	163	0.912281	1.48701803	Humisphaera	2807511	Bacteria	Bacteria	89	6.4e-19	NR	HEX8911235.1	2807514	g17140	i0	77.8	2.98159509202454	54	12	99.4	0	162	1	468	521	HEX8911235.1 hypothetical protein [Humisphaera sp.]	diamond	486	89	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera sp.
28729141	28729141	PRJNA881257_P_NODE_15987_length_166_cov_0.888889_g15742_i0	PRJNA881257	15987	166	0.888889	1.47555574	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	112	5.3200000000000006e-27	NR	WP_075092220.1	1632864	g15742	i0	89.1	0.993975903614458	55	6	99.4	0	1	165	606	660	WP_075092220.1 zinc-dependent metalloprotease [Planctomyces sp. SH-PL14]	diamond	165	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
30718752	30718752	PRJNA881257_P_NODE_15814_length_166_cov_0.888889_g15569_i0	PRJNA881257	15814	166	0.888889	1.47555574	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	59.3	1.87e-8	NR	HET6249302.1	2876886	g15569	i0	64.9	0.668674698795181	37	13	66.9	0	1	111	405	441	HET6249302.1 glycosyltransferase [Tepidisphaeraceae bacterium]	diamond	111	59.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
31224198	31224198	PRJNA881257_P_NODE_15595_length_167_cov_0.881356_g15350_i0	PRJNA881257	15595	167	0.881356	1.47186452	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.2	6.65e-10	NR	MEL7089934.1	2026780	g15350	i0	68.2	2.49700598802395	44	14	79	0	32	163	90	133	MEL7089934.1 anthranilate synthase component I family protein [Planctomycetota bacterium]	diamond	417	63.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31382634	31382634	PRJNA881257_P_NODE_16596_length_165_cov_0.896552_g16351_i0	PRJNA881257	16596	165	0.896552	1.4793108	Planctomycetia bacterium	2052181	Bacteria	Bacteria	103	4.78e-24	NR	GDY07179.1	2052181	g16351	i0	92.6	0.981818181818182	54	4	98.2	0	163	2	127	180	GDY07179.1 DNA topoisomerase [Planctomycetia bacterium]	diamond	162	103	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia 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);;