metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA846110" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA846110" 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
2108525	2108525	PRJNA846110_P_NODE_2442_length_663_cov_1.964407_g2212_i0	PRJNA846110	2442	663	1.964407	13.02401841	Chlamydiales bacterium QZY	2803004	Bacteria	Bacteria	795	0	NTclustered	gi\|1955632013\|gb\|MW471098.1\|	2803004	g2212	i0	91.552	176.419306184012	580	43	87	4	86	663	37	612	Chlamydiales bacterium QZY 16S ribosomal RNA gene, partial sequence	blastn	116966	795	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium QZY
2506879	2506879	PRJNA846110_P_NODE_5122_length_460_cov_1.981912_g4878_i0	PRJNA846110	5122	460	1.981912	9.1167952	Waddlia	71666	Bacteria	Bacteria	326	2.38e-84	NTclustered	gi\|470485904\|ref\|NR_076723.1\|	71667	g4878	i0	80.499	182.713043478261	441	72	95	10	1	436	1326	1757	Waddlia chondrophila strain WSU 86-1044 23S ribosomal RNA gene, complete sequence	blastn	84048	326	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
3783216	3783216	PRJNA846110_P_NODE_28483_length_243_cov_0.905882_g28238_i0	PRJNA846110	28483	243	0.905882	2.20129326	Gemmata	113	Bacteria	Bacteria	448	2.39e-121	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g28238	i0	100	114.555555555556	242	0	99	0	2	243	1038325	1038084	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	27837	448	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
4661561	4661561	PRJNA846110_P_NODE_30544_length_237_cov_2.542683_g30299_i0	PRJNA846110	30544	237	2.542683	6.02615871	Phycisphaera mikurensis	547188	Bacteria	Bacteria	174	4.3499999999999997e-39	NTclustered	gi\|381385343\|dbj\|AP012338.1\|	1142394	g30299	i0	80.258	16.4092827004219	233	44	98	2	4	235	2591861	2592092	Phycisphaera mikurensis NBRC 102666 DNA, complete genome	blastn	3889	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera mikurensis
11435137	11435137	PRJNA846110_P_NODE_27729_length_244_cov_0.900585_g27484_i0	PRJNA846110	27729	244	0.900585	2.1974274	Gemmata	113	Bacteria	Bacteria	276	1.1999999999999998e-69	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g27484	i0	87.008	6.68852459016393	254	22	100	9	1	244	1130589	1130841	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1632	278	0.992805755395683	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
12312346	12312346	PRJNA846110_P_NODE_8750_length_358_cov_1.877193_g8506_i0	PRJNA846110	8750	358	1.877193	6.72035094	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	252	3.11e-62	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g8506	i0	79.614	147.237430167598	363	64	100	10	1	358	835896	836253	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	52711	252	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
13586783	13586783	PRJNA846110_P_NODE_30751_length_232_cov_2.465409_g30506_i0	PRJNA846110	30751	232	2.465409	5.71974888	Urbifossiella limnaea	2528023	Bacteria	Bacteria	213	8.99e-51	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g30506	i0	84.163	0.952586206896552	221	33	95	2	13	232	5942494	5942275	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	221	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13586810	13586810	PRJNA846110_P_NODE_711_length_1185_cov_2.313849_g573_i0	PRJNA846110	711	1185	2.313849	27.41911065	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	1009	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g573	i0	82.794	195.95864978903	1174	159	97	38	38	1185	2059748	2058592	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	232211	1009	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae 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);;