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

7 rows where analysis = "blastn", bioproject = "PRJNA876641" 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
8506117	8506117	PRJNA876641_P_NODE_19467_length_246_cov_0.890173_g19393_i0	PRJNA876641	19467	246	0.890173	2.18982558	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	176	1.26e-39	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g19393	i0	84.831	0.723577235772358	178	24	72	3	1	176	5709979	5710155	Pirellula sp. SH-Sr6A, complete genome	blastn	178	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
12332435	12332435	PRJNA876641_P_NODE_8630_length_290_cov_1.207373_g8556_i0	PRJNA876641	8630	290	1.207373	3.5013817	Stieleria varia	2528005	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2720418917\|gb\|CP151726.1\|	2528005	g8556	i0	100	0.103448275862069	30	0	10	0	47	76	4770120	4770091	Stieleria varia strain Pla52n chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria varia
14881239	14881239	PRJNA876641_P_NODE_22952_length_241_cov_2.125000_g22878_i0	PRJNA876641	22952	241	2.125	5.12125	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	93.5	1.28e-14	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g22878	i0	91.176	8.09128630705394	68	6	28	0	174	241	2845710	2845643	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	1950	93.5	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
14881330	14881330	PRJNA876641_P_NODE_7112_length_312_cov_1.288703_g7038_i0	PRJNA876641	7112	312	1.288703	4.02075336	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	466	8.79e-127	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g7038	i0	99.225	236.663461538462	258	2	83	0	55	312	3094985	3095242	Pirellula sp. SH-Sr6A, complete genome	blastn	73839	466	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
19089919	19089919	PRJNA876641_P_NODE_11795_length_272_cov_1.160804_g11721_i0	PRJNA876641	11795	272	1.160804	3.15738688	Botrimarina	2795782	Bacteria	Bacteria	470	5.81e-128	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g11721	i0	97.794	223.503676470588	272	6	100	0	1	272	4246084	4245813	Planctomycetes bacterium K2D chromosome, complete genome	blastn	60793	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
19979973	19979973	PRJNA876641_P_NODE_5336_length_344_cov_0.852399_g5262_i0	PRJNA876641	5336	344	0.852399	2.93225256	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	619	7.109999999999999e-173	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g5262	i0	99.128	189.209302325581	344	3	100	0	1	344	3095848	3096191	Pirellula sp. SH-Sr6A, complete genome	blastn	65088	619	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
22916138	22916138	PRJNA876641_P_NODE_18398_length_248_cov_0.880000_g18324_i0	PRJNA876641	18398	248	0.88	2.1824	Coraliomargarita	442430	Bacteria	Bacteria	244	3.45e-60	NTclustered	gi\|470486190\|ref\|NR_076741.1\|	395922	g18324	i0	85.714	229.112903225806	238	26	95	6	3	237	1776	1544	Coraliomargarita akajimensis strain 04OKA010-24 23S ribosomal RNA gene, complete sequence	blastn	56820	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita akajimensis

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