metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA784298" 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
6317254	6317254	PRJNA784298_P_NODE_24305_length_249_cov_0.875000_g24104_i0	PRJNA784298	24305	249	0.875	2.17875	Pseudomonadati	3379134	Bacteria	Bacteria	138	2.11e-40	NR	MEW6156793.1	2026799	g24104	i0	87.7	5.27710843373494	73	9	88	0	219	1	1	73	MEW6156793.1 co-chaperone GroES [Verrucomicrobiota bacterium]	diamond	1314	138	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
17343608	17343608	PRJNA784298_P_NODE_23774_length_251_cov_0.865169_g23573_i0	PRJNA784298	23774	251	0.865169	2.17157419	Opitutia bacterium	2026771	Bacteria	Bacteria	87.4	7.81e-18	NR	MBI3884161.1	2026771	g23573	i0	59	0.99203187250996006	83	29	99.2	2	249	1	146	223	MBI3884161.1 U32 family peptidase [Opitutia bacterium]	diamond	249	87.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
27274923	27274923	PRJNA784298_P_NODE_12923_length_347_cov_1.854015_g12722_i0	PRJNA784298	12923	347	1.854015	6.43343205	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	132	1.96e-35	NR	RYD62014.1	2026800	g12722	i0	55.3	1.96253602305476	114	48	98.6	1	4	345	5	115	RYD62014.1 MAG: hypothetical protein EOP83_15680 [Verrucomicrobiaceae bacterium]	diamond	681	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27306634	27306634	PRJNA784298_P_NODE_27923_length_228_cov_2.896774_g27722_i0	PRJNA784298	27923	228	2.896774	6.60464472	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	86.3	7.58e-18	NR	HKP04302.1	2201154	g27722	i0	54.7	2.96052631578947	75	34	98.7	0	2	226	155	229	HKP04302.1 DUF2971 domain-containing protein [Chthoniobacterales bacterium]	diamond	675	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28294593	28294593	PRJNA784298_P_NODE_16646_length_304_cov_1.744589_g16445_i0	PRJNA784298	16646	304	1.744589	5.30355056	PVC group	1783257	Bacteria	Bacteria	66.6	3.14e-10	NR	OGN56317.1	1797598	g16445	i0	47.5	2.40789473684211	61	32	60.2	0	189	7	100	160	OGN56317.1 MAG: recombinase RecD [Chlamydiae bacterium RIFCSPHIGHO2_01_FULL_44_39]	diamond	732	67	0.994029850746269	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiae bacterium RIFCSPHIGHO2_01_FULL_44_39
29011912	29011912	PRJNA784298_P_NODE_23788_length_251_cov_0.865169_g23587_i0	PRJNA784298	23788	251	0.865169	2.17157419	Planctomycetota bacterium	2026780	Bacteria	Bacteria	146	6.319999999999998e-42	NR	RIK83425.1	2026780	g23587	i0	81.5	0.968127490039841	81	15	96.8	0	2	244	138	218	RIK83425.1 MAG: lysine decarboxylase [Planctomycetota bacterium]	diamond	243	146	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29021195	29021195	PRJNA784298_P_NODE_24088_length_250_cov_0.870056_g23887_i0	PRJNA784298	24088	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	156	8.02e-45	NR	MBC8117164.1	2026779	g23887	i0	97.6	5.964	83	2	99.6	0	250	2	115	197	MBC8117164.1 3-oxoacyl-ACP synthase III [Planctomycetaceae bacterium]	diamond	1491	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29043309	29043309	PRJNA784298_P_NODE_16628_length_304_cov_2.359307_g16427_i0	PRJNA784298	16628	304	2.359307	7.17229328	Fuerstiella sp.	1936112	Bacteria	Bacteria	45.8	0.00123	NR	MDG1896833.1	1936112	g16427	i0	40.5	1.44078947368421	74	41	70.1	1	281	69	12	85	MDG1896833.1 hypothetical protein [Fuerstiella sp.]	diamond	438	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella sp.
29453259	29453259	PRJNA784298_P_NODE_13030_length_346_cov_1.128205_g12829_i0	PRJNA784298	13030	346	1.128205	3.9035893	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.4	0.0139	NR	MEY3172301.1	2026780	g12829	i0	54.3	0.303468208092486	35	16	30.3	0	37	141	838	872	MEY3172301.1 hypothetical protein [Planctomycetota bacterium]	diamond	105	45.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29579666	29579666	PRJNA784298_P_NODE_3110_length_723_cov_3.227692_g2921_i0	PRJNA784298	3110	723	3.227692	23.33621316	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	277	3.73e-88	NR	MEN6384997.1	2052180	g2921	i0	58.4	0.908713692946058	219	88	89.6	1	711	64	195	413	MEN6384997.1 DUF2828 family protein [Phycisphaerales bacterium]	diamond	657	277	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30717019	30717019	PRJNA784298_P_NODE_24014_length_250_cov_0.870056_g23813_i0	PRJNA784298	24014	250	0.870056	2.17514	Opitutaceae bacterium	2006848	Bacteria	Bacteria	78.6	4.32e-15	NR	MBX7120636.1	2006848	g23813	i0	47.7	1.032	86	40	99.6	2	2	250	43	126	MBX7120636.1 alpha/beta hydrolase [Opitutaceae bacterium]	diamond	258	78.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31263644	31263644	PRJNA784298_P_NODE_18515_length_287_cov_4.056075_g18314_i0	PRJNA784298	18515	287	4.056075	11.64093525	Bacteria	2	Bacteria	Bacteria	71.6	4.43e-12	NR	MBN8644055.1	2026780	g18314	i0	46.2	2.91637630662021	78	42	81.5	0	253	20	11	88	MBN8644055.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Planctomycetota bacterium]	diamond	837	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31791812	31791812	PRJNA784298_P_NODE_23297_length_253_cov_1.711111_g23096_i0	PRJNA784298	23297	253	1.711111	4.32911083	Pedosphaera parvula	1032527	Bacteria	Bacteria	64.3	3.29e-10	NR	WP_150107388.1	1032527	g23096	i0	53	0.782608695652174	66	30	78.3	1	199	2	71	135	WP_150107388.1 hypothetical protein [Pedosphaera parvula]	diamond	198	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
32013485	32013485	PRJNA784298_P_NODE_22038_length_261_cov_4.563830_g21837_i0	PRJNA784298	22038	261	4.56383	11.9115963	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	79.3	4e-17	NR	NBB80421.1	2026799	g21837	i0	50	0.850574712643678	74	37	85.1	0	226	5	1	74	NBB80421.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	222	79.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32677173	32677173	PRJNA784298_P_NODE_16800_length_302_cov_2.816594_g16599_i0	PRJNA784298	16800	302	2.816594	8.50611388	Rubritalea sp.	2109375	Bacteria	Bacteria	62.8	6.24e-9	NR	MEZ7957371.1	2109375	g16599	i0	42.5	1.70860927152318	73	34	69.5	2	210	1	106	173	MEZ7957371.1 DUF2971 domain-containing protein [Rubritalea sp.]	diamond	516	62.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea sp.

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