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

8 rows where bioproject = "PRJNA529224" 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
498018	498018	PRJNA529224_S_NODE_761_length_229_cov_6.725000_g754_i0	PRJNA529224	761	229	6.725	15.40025	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g754	i0	100	86.3144104803494	229	0	100	0	1	229	3097108	3096880	Pirellula sp. SH-Sr6A, complete genome	blastn	19766	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
4324919	4324919	PRJNA529224_S_NODE_1804_length_156_cov_5.480315_g1797_i0	PRJNA529224	1804	156	5.480315	8.5492914	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	233	4.2799999999999995e-57	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g1797	i0	93.631	206.916666666667	157	9	100	1	1	156	1868738	1868582	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	32279	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9426220	9426220	PRJNA529224_S_NODE_1808_length_156_cov_4.527559_g1801_i0	PRJNA529224	1808	156	4.527559	7.06299204	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g1801	i0	100	20.4230769230769	156	0	100	0	1	156	3096609	3096454	Pirellula sp. SH-Sr6A, complete genome	blastn	3186	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
10702008	10702008	PRJNA529224_S_NODE_49_length_540_cov_49.870841_g44_i0	PRJNA529224	49	540	49.870841	269.3025414	Saltatorellus ferox	2528018	Bacteria	Bacteria	414	5.88e-111	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g44	i0	80.776	395.037037037037	541	95	99	8	4	540	2930713	2931248	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	213320	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
13868266	13868266	PRJNA529224_S_NODE_1131_length_196_cov_5.173653_g1124_i0	PRJNA529224	1131	196	5.173653	10.14035988	Planctomycetia	203683	Bacteria	Bacteria	305	1.18e-78	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g1124	i0	96.237	90.3571428571429	186	7	95	0	8	193	122783	122968	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	17710	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
15142603	15142603	PRJNA529224_S_NODE_912_length_214_cov_8.081081_g905_i0	PRJNA529224	912	214	8.081081	17.29351334	Isosphaera	127	Bacteria	Bacteria	263	8.000000000000002e-66	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g905	i0	88.837	36.9626168224299	215	23	100	1	1	214	1320	1106	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	7910	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
19624006	19624006	PRJNA529224_S_NODE_416_length_295_cov_14.150376_g409_i0	PRJNA529224	416	295	14.150376	41.7436092	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	163	1.21e-35	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g409	i0	84.706	39.0610169491525	170	18	56	7	1	165	1867830	1867664	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	11523	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21516432	21516432	PRJNA529224_S_NODE_1157_length_194_cov_6.642424_g1150_i0	PRJNA529224	1157	194	6.642424	12.88630256	Isosphaera	127	Bacteria	Bacteria	246	7.159999999999999e-61	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g1150	i0	90.811	118.840206185567	185	16	95	1	2	185	567	383	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	23055	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida

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