metadata: contig_metadata: 8 rows where bioproject = "PRJNA760976", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA760976", tax_clade = "PVC group" 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
742319	742319	PRJNA760976_P_NODE_20301_length_347_cov_1.572993_g19980_i0	PRJNA760976	20301	347	1.572993	5.45828571	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	542	1.5999999999999996e-149	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g19980	i0	95.072	229.449567723343	345	15	99	2	3	347	3095881	3096223	Pirellula sp. SH-Sr6A, complete genome	blastn	79619	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
9670843	9670843	PRJNA760976_P_NODE_52408_length_244_cov_3.111111_g52087_i0	PRJNA760976	52408	244	3.111111	7.59111084	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	363	8.949999999999999e-96	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g52087	i0	93.443	94.8483606557377	244	16	100	0	1	244	3097522	3097765	Pirellula sp. SH-Sr6A, complete genome	blastn	23143	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
22882707	22882707	PRJNA760976_P_NODE_11638_length_424_cov_2.179487_g11318_i0	PRJNA760976	11638	424	2.179487	9.24102488	Planctomycetia	203683	Bacteria	Bacteria	640	6.85e-179	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g11318	i0	94.313	120.905660377358	422	17	99	3	1	422	1444	1030	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	51264	640	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
27811474	27811474	PRJNA760976_P_NODE_34064_length_289_cov_1.027778_g33743_i0	PRJNA760976	34064	289	1.027778	2.97027842	Gemmataceae bacterium	2052164	Bacteria	Bacteria	99.4	8.34e-22	NR	HEX3148041.1	2052164	g33743	i0	54.3	1.94117647058824	94	43	97.6	0	3	284	635	728	HEX3148041.1 hypothetical protein [Gemmataceae bacterium]	diamond	561	99.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
28852974	28852974	PRJNA760976_P_NODE_56048_length_241_cov_1.351190_g55727_i0	PRJNA760976	56048	241	1.35119	3.2563679	Fuerstiella sp.	1936112	Bacteria	Bacteria	74.7	1.71e-13	NR	MEP3482112.1	1936112	g55727	i0	50	1.81742738589212	72	34	89.6	1	239	24	204	273	MEP3482112.1 NO-inducible flavohemoprotein [Fuerstiella sp.]	diamond	438	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
28979659	28979659	PRJNA760976_P_NODE_41908_length_266_cov_1.554404_g41587_i0	PRJNA760976	41908	266	1.554404	4.13471464	Gemmataceae bacterium	2052164	Bacteria	Bacteria	48.9	3.17e-4	NR	HEY8503922.1	2052164	g41587	i0	37.7	0.868421052631579	77	39	86.8	3	231	1	266	333	HEY8503922.1 hypothetical protein [Gemmataceae bacterium]	diamond	231	48.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30843120	30843120	PRJNA760976_P_NODE_12134_length_418_cov_0.849275_g11814_i0	PRJNA760976	12134	418	0.849275	3.5499695	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.2	4.75e-6	NR	NLE60524.1	2026780	g11814	i0	37.6	0.839712918660287	117	69	83.3	3	409	62	67	180	NLE60524.1 carboxypeptidase regulatory-like domain-containing protein [Planctomycetota bacterium]	diamond	351	56.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32645092	32645092	PRJNA760976_P_NODE_53460_length_244_cov_0.859649_g53139_i0	PRJNA760976	53460	244	0.859649	2.09754356	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	50.8	4.87e-5	NR	HMB95802.1	2876886	g53139	i0	82.6	0.565573770491803	23	4	28.3	0	244	176	282	304	HMB95802.1 DUF4139 domain-containing protein [Tepidisphaeraceae bacterium]	diamond	138	50.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;