metadata: contig_metadata: 10 rows where bioproject = "PRJEB41113", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJEB41113", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
1333507	1333507	PRJEB41113_S_NODE_8662_length_165_cov_2.515625_g8653_i0	PRJEB41113	8662	165	2.515625	4.15078125	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	154	3.68e-33	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8653	i0	86.014	0.866666666666667	143	20	87	0	1	143	67308	67450	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	143	154	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10261994	10261994	PRJEB41113_S_NODE_8209_length_167_cov_4.200000_g8200_i0	PRJEB41113	8209	167	4.2	7.014	Aureliella helgolandensis	2527968	Bacteria	Bacteria	230	6.029999999999999e-56	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g8200	i0	91.566	15.5508982035928	166	14	99	0	2	167	6998995	6998830	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	2597	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
17910658	17910658	PRJEB41113_S_NODE_1135_length_255_cov_6.577982_g1126_i0	PRJEB41113	1135	255	6.577982	16.7738541	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	153	2.4899999999999998e-42	NR	MBX6312370.1	2691532	g1126	i0	91.3	5.64705882352941	80	7	94.1	0	14	253	341	420	MBX6312370.1 preprotein translocase subunit SecY [Isosphaeraceae bacterium]	diamond	1440	153	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
18841521	18841521	PRJEB41113_S_NODE_14595_length_151_cov_2.482456_g14586_i0	PRJEB41113	14595	151	2.482456	3.74850856	Gemmataceae	1914233	Bacteria	Bacteria	148	1.5299999999999999e-31	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g14586	i0	100	104.933774834437	80	0	53	0	72	151	2356	2277	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	15845	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
20460031	20460031	PRJEB41113_S_NODE_9317_length_162_cov_4.088000_g9308_i0	PRJEB41113	9317	162	4.088	6.62256	planctomycete str. 449	79870	Bacteria	Bacteria	193	7.61e-45	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g9308	i0	88.415	9.61111111111111	164	14	100	4	1	162	15	175	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	1557	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
27854708	27854708	PRJEB41113_S_NODE_3045_length_207_cov_2.670588_g3036_i0	PRJEB41113	3045	207	2.670588	5.52811716	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	76.6	4.93e-16	NR	MBN1554494.1	2026778	g3036	i0	46.4	1	69	37	100	0	207	1	12	80	MBN1554494.1 STAS/SEC14 domain-containing protein [Phycisphaerae bacterium]	diamond	207	76.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
31328985	31328985	PRJEB41113_S_NODE_13756_length_152_cov_2.869565_g13747_i0	PRJEB41113	13756	152	2.869565	4.3617388	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	41.2	0.0377	NR	MEO6808277.1	2691532	g13747	i0	57.4	0.927631578947368	47	20	92.8	0	152	12	42	88	MEO6808277.1 MotA/TolQ/ExbB proton channel family protein [Isosphaeraceae bacterium]	diamond	141	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
31360791	31360791	PRJEB41113_S_NODE_6496_length_177_cov_4.750000_g6487_i0	PRJEB41113	6496	177	4.75	8.4075	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0287	NR	MCU0918686.1	2026780	g6487	i0	59.3	0.457627118644068	27	11	45.8	0	87	167	486	512	MCU0918686.1 hypothetical protein [Planctomycetota bacterium]	diamond	81	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32563064	32563064	PRJEB41113_S_NODE_9639_length_161_cov_2.274194_g9630_i0	PRJEB41113	9639	161	2.274194	3.66145234	Tautonia sociabilis	2080755	Bacteria	Bacteria	56.2	2.12e-7	NR	WP_126726178.1	2080755	g9630	i0	44.2	0.968944099378882	52	29	96.9	0	6	161	793	844	WP_126726178.1 ATP-binding protein [Tautonia sociabilis]	diamond	156	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia sociabilis
32783055	32783055	PRJEB41113_S_NODE_9700_length_161_cov_1.564516_g9691_i0	PRJEB41113	9700	161	1.564516	2.51887076	Planctomycetota bacterium	2026780	Bacteria	Bacteria	75.1	4.73e-14	NR	MDB5348763.1	2026780	g9691	i0	84.6	0.726708074534162	39	6	72.7	0	161	45	768	806	MDB5348763.1 hypothetical protein [Planctomycetota bacterium]	diamond	117	75.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;