metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1102048" 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
1486474	1486474	PRJNA1102048_P_NODE_9262_length_287_cov_1.271028_g9158_i0	PRJNA1102048	9262	287	1.271028	3.64785036	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	418	2.2699999999999993e-112	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g9158	i0	93.286	99.1951219512195	283	19	99	0	1	283	2622374	2622092	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	28469	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
3570510	3570510	PRJNA1102048_P_NODE_13383_length_250_cov_0.870056_g13279_i0	PRJNA1102048	13383	250	0.870056	2.17514	Verrucomicrobiota	74201	Bacteria	Bacteria	228	3.4999999999999995e-55	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g13279	i0	83.2	80.976	250	41	100	1	1	250	451	203	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	20244	230	0.991304347826087	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
16788856	16788856	PRJNA1102048_P_NODE_17154_length_242_cov_0.911243_g17050_i0	PRJNA1102048	17154	242	0.911243	2.20520806	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	303	5.45e-78	NTclustered	gi\|2621780281\|emb\|OY776568.1\|	2026778	g17050	i0	89.256	194.363636363636	242	26	100	0	1	242	4346581	4346822	MAG: Phycisphaerae bacterium isolate 383648cc-b706-4f19-8acf-b8ba9176e0b9 genome assembly, chromosome: 1	blastn	47036	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
18063437	18063437	PRJNA1102048_P_NODE_15835_length_245_cov_0.895349_g15731_i0	PRJNA1102048	15835	245	0.895349	2.19360505	Aquisphaera giovannonii	406548	Bacteria	Bacteria	207	4.46e-49	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g15731	i0	82.305	17.2204081632653	243	39	98	4	3	243	6164177	6163937	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	4219	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
18063441	18063441	PRJNA1102048_P_NODE_16055_length_244_cov_0.900585_g15951_i0	PRJNA1102048	16055	244	0.900585	2.1974274	Rohdeia mirabilis	2528008	Bacteria	Bacteria	187	5.7799999999999984e-43	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g15951	i0	80.658	151.385245901639	243	45	99	2	1	242	3894478	3894719	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	36938	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
21888508	21888508	PRJNA1102048_P_NODE_12518_length_252_cov_1.039106_g12414_i0	PRJNA1102048	12518	252	1.039106	2.61854712	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	246	9.77e-61	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g12414	i0	85.366	141.007936507937	246	27	96	7	2	242	627242	627001	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	35534	246	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
21888612	21888612	PRJNA1102048_P_NODE_6158_length_348_cov_0.905455_g6054_i0	PRJNA1102048	6158	348	0.905455	3.1509834	Lignipirellula cremea	2528010	Bacteria	Bacteria	514	3.4999999999999997e-141	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g6054	i0	93.41	168.462643678161	349	20	100	3	1	348	1144448	1144794	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	58625	514	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea

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);;