metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA937226" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA937226" 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_species
26930090	26930090	PRJNA937226_S_NODE_25822_length_167_cov_6.669492_g25695_i0	PRJNA937226	25822	167	6.669492	11.13805164	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0183	NR	MFM7051384.1	2026780	g25695	i0	38	0.898203592814371	50	29	88	2	4	150	202	250	MFM7051384.1 tetratricopeptide repeat protein [Planctomycetota bacterium]	diamond	150	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota		Planctomycetota bacterium
27348274	27348274	PRJNA937226_S_NODE_15203_length_207_cov_2.341772_g15076_i0	PRJNA937226	15203	207	2.341772	4.84746804	PVC group	1783257	Bacteria	Bacteria	42.4	0.00473	NR	MEI8342926.1	2026799	g15076	i0	50	1.59420289855072	36	18	52.2	0	135	28	12	47	MEI8342926.1 helix-turn-helix domain-containing protein [Verrucomicrobiota bacterium]	diamond	330	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota		Verrucomicrobiota bacterium
29558163	29558163	PRJNA937226_S_NODE_6390_length_283_cov_3.611111_g6263_i0	PRJNA937226	6390	283	3.611111	10.21944413	Bacteria	2	Bacteria	Bacteria	183	4.3899999999999985e-55	NR	MFA5555298.1	2026778	g6263	i0	86.2	4.98233215547703	94	13	99.6	0	283	2	197	290	MFA5555298.1 glycosyl hydrolase 53 family protein [Phycisphaerae bacterium]	diamond	1410	184	0.994565217391304	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerae bacterium
30214402	30214402	PRJNA937226_S_NODE_29572_length_158_cov_3.339450_g29445_i0	PRJNA937226	29572	158	3.33945	5.276331	Planctomycetota bacterium	2026780	Bacteria	Bacteria	39.3	0.0335	NR	MBK8099513.1	2026780	g29445	i0	57.1	0.531645569620253	28	12	53.2	0	43	126	35	62	MBK8099513.1 ATP-dependent helicase HrpA [Planctomycetota bacterium]	diamond	84	39.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota		Planctomycetota bacterium
30341478	30341478	PRJNA937226_S_NODE_19512_length_187_cov_4.340580_g19385_i0	PRJNA937226	19512	187	4.34058	8.1168846	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0295	NR	MCZ6834265.1	2026780	g19385	i0	43.2	0.705882352941177	44	25	70.6	0	54	185	112	155	MCZ6834265.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex dimerization subunit type 1 TsaB [Planctomycetota bacterium]	diamond	132	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota		Planctomycetota 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);;