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

8 rows where bioproject = "PRJNA550047", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

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
6894159	6894159	PRJNA550047_P_NODE_430386_length_253_cov_16.427778_g428414_i0	PRJNA550047	430386	253	16.427778	41.56227834	Lentisphaera araneosa	256847	Bacteria	Bacteria	126	1.15e-31	NR	WP_007280412.1	256847	g428414	i0	71.1	1.93280632411067	83	24	98.4	0	251	3	495	577	WP_007280412.1 3'-5' exonuclease [Lentisphaera araneosa]	diamond	489	126	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera araneosa
14545765	14545765	PRJNA550047_P_NODE_467712_length_241_cov_10.720238_g465739_i0	PRJNA550047	467712	241	10.720238	25.83577358	Victivallales bacterium CCUG 44730	2094242	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1359122976\|gb\|CP027227.1\|	2094242	g465739	i0	100	0.116182572614108	28	0	12	0	186	213	2434413	2434440	Victivallales bacterium CCUG 44730 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium CCUG 44730
27029509	27029509	PRJNA550047_P_NODE_299802_length_297_cov_8.799107_g297833_i0	PRJNA550047	299802	297	8.799107	26.13334779	Pseudomonadati	3379134	Bacteria	Bacteria	50.1	1.83e-4	NR	OGV64412.1	1798577	g297833	i0	52.1	1.14141414141414	48	23	48.5	0	146	3	429	476	OGV64412.1 MAG: hypothetical protein A3K18_03655 [Lentisphaerae bacterium RIFOXYA12_64_32]	diamond	339	50.4	0.994047619047619	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium RIFOXYA12_64_32
27867676	27867676	PRJNA550047_P_NODE_472305_length_240_cov_2.898204_g470332_i0	PRJNA550047	472305	240	2.898204	6.9556896	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	137	1.41e-35	NR	MBM4163442.1	1932692	g470332	i0	77.2	0.9875	79	18	98.8	0	2	238	310	388	MBM4163442.1 asparagine synthase (glutamine-hydrolyzing) [Lentisphaerota bacterium]	diamond	237	137	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28531026	28531026	PRJNA550047_P_NODE_483547_length_236_cov_5.208589_g481574_i0	PRJNA550047	483547	236	5.208589	12.29227004	Victivallales bacterium	2212475	Bacteria	Bacteria	55.1	1.54e-6	NR	MEI3038328.1	2212475	g481574	i0	59.1	0.559322033898305	44	17	55.9	1	146	15	1	43	MEI3038328.1 sugar-binding protein [Victivallales bacterium]	diamond	132	55.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
29681873	29681873	PRJNA550047_P_NODE_70790_length_345_cov_12.224265_g68830_i0	PRJNA550047	70790	345	12.224265	42.17371425	Lentisphaerota	256845	Bacteria	Bacteria	59.7	3.58e-8	NR	WP_307260376.1	760260	g68830	i0	56	1.30434782608696	50	22	43.5	0	196	345	38	87	WP_307260376.1 D-glycero-alpha-D-manno-heptose-1,7-bisphosphate 7-phosphatase [Oligosphaera ethanolica]	diamond	450	60.1	0.993344425956739	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Oligosphaeria	Oligosphaerales	Oligosphaeraceae	Oligosphaera	Oligosphaera ethanolica
30882616	30882616	PRJNA550047_P_NODE_354934_length_283_cov_6.119048_g352963_i0	PRJNA550047	354934	283	6.119048	17.31690584	Pseudomonadati	3379134	Bacteria	Bacteria	44.3	0.0175	NR	MBE6371967.1	1932692	g352963	i0	59	2.89399293286219	39	16	41.3	0	280	164	544	582	MBE6371967.1 hypothetical protein [Lentisphaerota bacterium]	diamond	819	44.7	0.991051454138702	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
32590628	32590628	PRJNA550047_P_NODE_430579_length_253_cov_14.483333_g428607_i0	PRJNA550047	430579	253	14.483333	36.64283249	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	7.77e-14	NR	NLB55125.1	1932692	g428607	i0	66	5.09881422924901	50	17	59.3	0	103	252	25	74	NLB55125.1 translesion error-prone DNA polymerase V autoproteolytic subunit [Lentisphaerota bacterium]	diamond	1290	72.8	0.994505494505495	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota 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);;