metadata: contig_metadata: 7 rows where bioproject = "PRJNA1145574" and tax

7 rows where bioproject = "PRJNA1145574" 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
27860093	27860093	PRJNA1145574_P_NODE_13045_length_247_cov_0.896552_g12861_i0	PRJNA1145574	13045	247	0.896552	2.21448344	Roseibacillus ishigakijimensis	454146	Bacteria	Bacteria	43.5	0.0205	NR	WP_200392719.1	454146	g12861	i0	39.7	0.825910931174089	68	36	76.5	1	244	56	74	141	WP_200392719.1 MFS transporter [Roseibacillus ishigakijimensis]	diamond	204	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus ishigakijimensis
31271297	31271297	PRJNA1145574_P_NODE_12895_length_248_cov_0.891429_g12711_i0	PRJNA1145574	12895	248	0.891429	2.21074392	Planctomycetota bacterium	2026780	Bacteria	Bacteria	107	6.92e-25	NR	HLX62955.1	2026780	g12711	i0	64.2	0.979838709677419	81	29	98	0	2	244	25	105	HLX62955.1 hypothetical protein [Planctomycetota bacterium]	diamond	243	107	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31714080	31714080	PRJNA1145574_P_NODE_12037_length_250_cov_0.881356_g11853_i0	PRJNA1145574	12037	250	0.881356	2.20339	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	105	3.08e-25	NR	NBR62895.1	2026799	g11853	i0	98.1	1.272	53	1	63.6	0	249	91	238	290	NBR62895.1 ATP phosphoribosyltransferase [Verrucomicrobiota bacterium]	diamond	318	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32378555	32378555	PRJNA1145574_P_NODE_12219_length_250_cov_0.881356_g12035_i0	PRJNA1145574	12219	250	0.881356	2.20339	Planctomycetota bacterium	2026780	Bacteria	Bacteria	134	3.5499999999999998e-34	NR	MBU6384446.1	2026780	g12035	i0	97.1	0.84	70	2	84	0	211	2	1	70	MBU6384446.1 hypothetical protein [Planctomycetota bacterium]	diamond	210	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32442042	32442042	PRJNA1145574_P_NODE_7919_length_307_cov_1.333333_g7735_i0	PRJNA1145574	7919	307	1.333333	4.09333231	Simkania sp.	34094	Bacteria	Bacteria	137	6.899999999999999e-38	NR	MCB1084310.1	34094	g7735	i0	70.8	0.938110749185668	96	28	93.8	0	19	306	81	176	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	288	137	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
32725768	32725768	PRJNA1145574_P_NODE_13920_length_245_cov_0.906977_g13736_i0	PRJNA1145574	13920	245	0.906977	2.22209365	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	150	4.04e-40	NR	MCE2884755.1	2026779	g13736	i0	97.5	1.98367346938776	81	2	99.2	0	3	245	192	272	MCE2884755.1 DUF3488 and transglutaminase-like domain-containing protein [Planctomycetaceae bacterium]	diamond	486	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32883006	32883006	PRJNA1145574_P_NODE_12720_length_248_cov_0.891429_g12536_i0	PRJNA1145574	12720	248	0.891429	2.21074392	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	86.3	1.87e-17	NR	NBT90175.1	2026799	g12536	i0	100	1.06451612903226	44	0	53.2	0	3	134	422	465	NBT90175.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	264	86.3	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);;