metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA782551" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA782551" 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
763566	763566	PRJNA782551_P_NODE_12481_length_275_cov_1.500000_g12359_i0	PRJNA782551	12481	275	1.5	4.125	Bacteria	2	Bacteria	Bacteria	135	1.3599999999999999e-34	NR	MFN0198200.1	2026779	g12359	i0	63.7	4.93090909090909	91	33	99.3	0	2	274	32	122	MFN0198200.1 asparagine synthase (glutamine-hydrolyzing) [Planctomycetaceae bacterium]	diamond	1356	136	0.992647058823529	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26673414	26673414	PRJNA782551_P_NODE_24601_length_241_cov_0.916667_g24479_i0	PRJNA782551	24601	241	0.916667	2.20916747	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	152	1.13e-42	NR	WP_317832796.1	3080537	g24479	i0	85.9	0.970954356846473	78	11	97.1	0	240	7	292	369	WP_317832796.1 PfkB family carbohydrate kinase [Rubellicoccus peritrichatus]	diamond	234	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
26800370	26800370	PRJNA782551_P_NODE_16401_length_250_cov_1.740113_g16279_i0	PRJNA782551	16401	250	1.740113	4.3502825	Planctomyces sp.	37635	Bacteria	Bacteria	111	6.96e-27	NR	MBL8816714.1	37635	g16279	i0	61.4	0.996	83	32	99.6	0	2	250	83	165	MBL8816714.1 DUF790 family protein [Planctomyces sp.]	diamond	249	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
27022031	27022031	PRJNA782551_P_NODE_18302_length_248_cov_0.880000_g18180_i0	PRJNA782551	18302	248	0.88	2.1824	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	92.4	1.29e-20	NR	HEY8750737.1	2876886	g18180	i0	52.4	0.991935483870968	82	39	99.2	0	2	247	156	237	HEY8750737.1 biotin--[acetyl-CoA-carboxylase] ligase [Tepidisphaeraceae bacterium]	diamond	246	92.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27947378	27947378	PRJNA782551_P_NODE_23545_length_242_cov_0.911243_g23423_i0	PRJNA782551	23545	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	112	1.08e-26	NR	MFT5325939.1	2026779	g23423	i0	70.5	2.90082644628099	78	23	96.7	0	2	235	547	624	MFT5325939.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	702	112	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28980156	28980156	PRJNA782551_P_NODE_18308_length_248_cov_0.880000_g18186_i0	PRJNA782551	18308	248	0.88	2.1824	Opitutus sp.	1913982	Bacteria	Bacteria	163	6.829999999999999e-46	NR	HTO05400.1	1913982	g18186	i0	92.7	4.95967741935484	82	6	99.2	0	1	246	91	172	HTO05400.1 DUF1501 domain-containing protein [Opitutus sp.]	diamond	1230	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29327192	29327192	PRJNA782551_P_NODE_24109_length_242_cov_0.911243_g23987_i0	PRJNA782551	24109	242	0.911243	2.20520806	Planctomycetota bacterium	2026780	Bacteria	Bacteria	52.4	1.46e-5	NR	NOT31890.1	2026780	g23987	i0	52.3	0.545454545454545	44	21	54.5	0	5	136	79	122	NOT31890.1 hypothetical protein [Planctomycetota bacterium]	diamond	132	52.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29548108	29548108	PRJNA782551_P_NODE_16810_length_250_cov_0.870056_g16688_i0	PRJNA782551	16810	250	0.870056	2.17514	Planctomycetota bacterium	2026780	Bacteria	Bacteria	71.6	2.64e-12	NR	HYE07888.1	2026780	g16688	i0	72.9	1.44	48	13	57.6	0	146	3	30	77	HYE07888.1 NHL repeat-containing protein [Planctomycetota bacterium]	diamond	360	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31064912	31064912	PRJNA782551_P_NODE_14915_length_256_cov_1.672131_g14793_i0	PRJNA782551	14915	256	1.672131	4.28065536	Prosthecobacter sp.	1965333	Bacteria	Bacteria	107	2.11e-25	NR	MBV6500771.1	1965333	g14793	i0	70.8	0.84375	72	21	84.4	0	254	39	164	235	MBV6500771.1 Protein TolB [Prosthecobacter sp.]	diamond	216	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
31064913	31064913	PRJNA782551_P_NODE_15295_length_253_cov_1.866667_g15173_i0	PRJNA782551	15295	253	1.866667	4.72266751	Haloferula sargassicola	490096	Bacteria	Bacteria	135	9.13e-39	NR	WP_353566805.1	490096	g15173	i0	84.2	3.6403162055336	76	12	90.1	0	251	24	73	148	WP_353566805.1 CopG family ribbon-helix-helix protein [Haloferula sargassicola]	diamond	921	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sargassicola
32677150	32677150	PRJNA782551_P_NODE_24920_length_241_cov_0.916667_g24798_i0	PRJNA782551	24920	241	0.916667	2.20916747	Tepidisphaerales bacterium	2795155	Bacteria	Bacteria	75.5	3.15e-14	NR	MFI5381230.1	2795155	g24798	i0	50.7	0.933609958506224	75	36	92.1	1	17	238	177	251	MFI5381230.1 hypothetical protein [Tepidisphaerales bacterium]	diamond	225	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales			Tepidisphaerales 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);;