metadata: contig_metadata: 8 rows where bioproject = "PRJNA675042" and tax

8 rows where bioproject = "PRJNA675042" 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
646110	646110	PRJNA675042_P_NODE_14281_length_450_cov_2.859416_g13831_i0	PRJNA675042	14281	450	2.859416	12.867372	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	575	2.0899999999999993e-159	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g13831	i0	95.798	167.373333333333	357	13	100	2	1	355	1315863	1315507	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	75318	575	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4474315	4474315	PRJNA675042_P_NODE_158924_length_244_cov_0.900585_g158474_i0	PRJNA675042	158924	244	0.900585	2.1974274	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	335	1.9499999999999992e-87	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g158474	i0	98.93	58.3401639344262	187	2	100	0	58	244	382	568	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	14235	335	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
4475215	4475215	PRJNA675042_P_NODE_60804_length_306_cov_5.214592_g60354_i0	PRJNA675042	60804	306	5.214592	15.95665152	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	547	2.9899999999999992e-151	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g60354	i0	100	202.967320261438	296	0	97	0	8	303	5626467	5626172	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	62108	547	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
10849854	10849854	PRJNA675042_P_NODE_10889_length_489_cov_0.985577_g10441_i0	PRJNA675042	10889	489	0.985577	4.81947153	Limnoglobus roseus	2598579	Bacteria	Bacteria	84.2	1.69e-11	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g10441	i0	86.667	5.78118609406953	75	10	15	0	415	489	3146139	3146213	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	2827	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
12647635	12647635	PRJNA675042_P_NODE_63210_length_303_cov_1.060870_g62760_i0	PRJNA675042	63210	303	1.06087	3.2144361	Akkermansia	239934	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2669347435\|gb\|CP143890.1\|	3115151	g62760	i0	100	0.184818481848185	28	0	9	0	101	128	2131156	2131129	Akkermansia sp. AE01SA01 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. AE01SA01
14674928	14674928	PRJNA675042_P_NODE_110732_length_251_cov_0.865169_g110282_i0	PRJNA675042	110732	251	0.865169	2.17157419	Gimesia aquarii	2527964	Bacteria	Bacteria	60.2	1.36e-4	NTclustered	gi\|1712569666\|gb\|CP037422.1\|	2527964	g110282	i0	94.872	0.155378486055777	39	1	15	1	76	113	5062572	5062534	Gimesia aquarii strain V202 chromosome	blastn	39	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia aquarii
23600117	23600117	PRJNA675042_P_NODE_68299_length_295_cov_2.382883_g67849_i0	PRJNA675042	68299	295	2.382883	7.02950485	Neochlamydia hartmannellae	112235	Bacteria	Bacteria	420	6.52e-113	NTclustered	gi\|219857449\|ref\|NR_025037.1\|	112235	g67849	i0	93.31	102.522033898305	284	19	96	0	12	295	432	715	Neochlamydia hartmannellae strain A1Hsp 16S ribosomal RNA, partial sequence	blastn	30244	420	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
32611108	32611108	PRJNA675042_P_NODE_52500_length_320_cov_0.935223_g52050_i0	PRJNA675042	52500	320	0.935223	2.9927136	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	47.8	0.00156	NR	MBI2095101.1	2035772	g52050	i0	66.7	1.228125	30	10	28.1	0	313	224	3	32	MBI2095101.1 translational GTPase TypA [Candidatus Omnitrophota bacterium]	diamond	393	47.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota 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);;