metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA575566" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA575566" 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
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

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