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

5 rows where analysis = "diamond", bioproject = "PRJNA640350" 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_species
26669232	26669232	PRJNA640350_P_NODE_18381_length_242_cov_3.408451_g18220_i0	PRJNA640350	18381	242	3.408451	8.24845142	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	139	4.82e-41	NR	MBQ3098118.1	2212473	g18220	i0	100	0.793388429752066	64	0	79.3	0	194	3	1	64	MBQ3098118.1 MbtH family protein [Kiritimatiellia bacterium]	diamond	192	139	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
26764491	26764491	PRJNA640350_P_NODE_40701_length_151_cov_1.450820_g40540_i0	PRJNA640350	40701	151	1.45082	2.1907382	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	62.8	8.62e-10	NR	HKI17904.1	2691532	g40540	i0	71.8	2.58278145695364	39	11	77.5	0	119	3	222	260	HKI17904.1 ATP-binding protein [Isosphaeraceae bacterium]	diamond	390	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaeraceae bacterium
27965350	27965350	PRJNA640350_P_NODE_28185_length_178_cov_1.765101_g28024_i0	PRJNA640350	28185	178	1.765101	3.14187978	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	53.9	5.97e-7	NR	RPJ31327.1	2026800	g28024	i0	95.8	0.404494382022472	24	1	40.4	0	172	101	131	154	RPJ31327.1 MAG: hypothetical protein EHM17_15585 [Verrucomicrobiaceae bacterium]	diamond	72	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
31439810	31439810	PRJNA640350_P_NODE_29076_length_175_cov_2.184932_g28915_i0	PRJNA640350	29076	175	2.184932	3.823631	Gemmataceae bacterium	2052164	Bacteria	Bacteria	63.5	6.95e-10	NR	MBX7105905.1	2052164	g28915	i0	62.7	3.6	51	17	87.4	1	1	153	1381	1429	MBX7105905.1 hypothetical protein [Gemmataceae bacterium]	diamond	630	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmataceae bacterium
32199174	32199174	PRJNA640350_P_NODE_31438_length_169_cov_1.307143_g31277_i0	PRJNA640350	31438	169	1.307143	2.20907167	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	63.5	6.05e-10	NR	MDB6061048.1	2026800	g31277	i0	54.5	3	55	25	97.6	0	3	167	389	443	MDB6061048.1 TonB-dependent receptor [Verrucomicrobiaceae bacterium]	diamond	507	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae 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);;