metadata: contig_metadata: 13 rows where bioproject = "PRJNA575566", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJNA575566", tax_clade = "PVC group" and tax_kingdom = "Pseudomonadati"

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
3110794	3110794	PRJNA575566_P_NODE_11403_length_310_cov_1.582329_g11206_i0	PRJNA575566	11403	310	1.582329	4.9052199	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	499	8.6e-137	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g11206	i0	95.806	156.21935483871	310	12	100	1	1	310	629327	629019	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	48428	499	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
3110911	3110911	PRJNA575566_P_NODE_18323_length_246_cov_1.037838_g18126_i0	PRJNA575566	18323	246	1.037838	2.55308148	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	361	3.25e-95	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g18126	i0	93.117	21.8048780487805	247	15	100	2	1	246	627471	627716	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	5364	361	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
19686727	19686727	PRJNA575566_P_NODE_5456_length_449_cov_1.154639_g5259_i0	PRJNA575566	5456	449	1.154639	5.18432911	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	697	0	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g5259	i0	94.678	169.080178173719	451	21	100	3	1	449	626941	627390	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	75917	697	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
20962433	20962433	PRJNA575566_P_NODE_6097_length_423_cov_3.303867_g5900_i0	PRJNA575566	6097	423	3.303867	13.97535741	Candidatus Fritschea bemisiae	206681	Bacteria	Bacteria	75	8.7e-9	NTclustered	gi\|31747861\|gb\|AY140910.1\|	206681	g5900	i0	79.091	2.725768321513	110	21	26	2	73	180	6821	6712	Candidatus Fritschea bemisiae strain Falk YaeL (yaeL) gene, partial cds; putative glycosylhydrolase and putative transposase genes, complete cds; 16S ribosomal RNA and 23S ribosomal RNA genes, complete sequence; putative endonuclease gene, complete cds; 5S ribosomal RNA gene, complete sequence; argynyl tRNA synthetase (argS), YjeE (yjeE), probable GTP-binding protein, DNA polymerase III epsilon subunit, and phosphoglycerate kinase (pgk) genes, complete cds; and unknown gene	blastn	1153	75	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Fritschea	Candidatus Fritschea bemisiae
22237111	22237111	PRJNA575566_P_NODE_21878_length_223_cov_0.876543_g21681_i0	PRJNA575566	21878	223	0.876543	1.95469089	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	340	3.77e-89	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g21681	i0	94.17	9.47085201793722	223	13	100	0	1	223	2190895	2190673	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	2112	340	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
23512437	23512437	PRJNA575566_P_NODE_23839_length_210_cov_1.718121_g23642_i0	PRJNA575566	23839	210	1.718121	3.6080541	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	261	2.81e-65	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g23642	i0	89.756	11.9714285714286	205	20	98	1	1	205	2191187	2191390	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	2514	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
28609016	28609016	PRJNA575566_P_NODE_7887_length_374_cov_1.191693_g7690_i0	PRJNA575566	7887	374	1.191693	4.45693182	Bacteria	2	Bacteria	Bacteria	105	1.69e-23	NR	MEI8213485.1	2026780	g7690	i0	49.6	2.00534759358289	121	57	96.3	2	374	15	132	249	MEI8213485.1 peroxidase family protein [Planctomycetota bacterium]	diamond	750	106	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29069202	29069202	PRJNA575566_P_NODE_24548_length_209_cov_0.864865_g24351_i0	PRJNA575566	24548	209	0.864865	1.80756785	Simkania sp.	34094	Bacteria	Bacteria	48.1	2.98e-4	NR	MBS3903878.1	34094	g24351	i0	43.5	0.990430622009569	69	38	99	1	1	207	257	324	MBS3903878.1 PDZ domain-containing protein [Simkania sp.]	diamond	207	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29745415	29745415	PRJNA575566_P_NODE_28430_length_203_cov_0.901408_g28233_i0	PRJNA575566	28430	203	0.901408	1.82985824	Bacteria	2	Bacteria	Bacteria	43.5	0.0121	NR	WP_096894051.1	1284222	g28233	i0	52.8	6.65024630541872	36	17	53.2	0	96	203	1356	1391	WP_096894051.1 tetratricopeptide repeat protein [Candidatus Scalindua japonica]	diamond	1350	43.9	0.990888382687927	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua japonica
30174255	30174255	PRJNA575566_P_NODE_1892_length_746_cov_2.769343_g1713_i0	PRJNA575566	1892	746	2.769343	20.65929878	Paludisphaera sp.	2017432	Bacteria	Bacteria	53.5	1.95e-4	NR	WP_337176277.1	2017432	g1713	i0	29.9	1.60053619302949	197	117	74	9	684	133	26	214	WP_337176277.1 hypothetical protein [Paludisphaera sp.]	diamond	1194	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera sp.
31185100	31185100	PRJNA575566_P_NODE_22075_length_221_cov_1.600000_g21878_i0	PRJNA575566	22075	221	1.6	3.536	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	67.4	3.41e-12	NR	MCB1068935.1	2212473	g21878	i0	55.7	0.950226244343891	70	28	91	1	10	210	55	124	MCB1068935.1 30S ribosomal protein S13 [Kiritimatiellia bacterium]	diamond	210	67.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31280164	31280164	PRJNA575566_P_NODE_19975_length_235_cov_0.850575_g19778_i0	PRJNA575566	19975	235	0.850575	1.99885125	Luteolibacter sp.	1962973	Bacteria	Bacteria	42.4	0.0459	NR	MEO7098011.1	1962973	g19778	i0	40.8	0.625531914893617	49	25	58.7	2	17	154	313	360	MEO7098011.1 MBOAT family O-acyltransferase [Luteolibacter sp.]	diamond	147	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
32860608	32860608	PRJNA575566_P_NODE_27240_length_205_cov_0.888889_g27043_i0	PRJNA575566	27240	205	0.888889	1.82222245	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0322	NR	HCF96245.1	2026799	g27043	i0	63	0.395121951219512	27	10	39.5	0	174	94	674	700	HCF96245.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	81	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;