metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_phylum = "Verrucomicrobiota"

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
724135	724135	PRJNA745553_S_NODE_19241_length_282_cov_1.473684_g19046_i0	PRJNA745553	19241	282	1.473684	4.15578888	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	102	8.8e-23	NR	HYY26347.1	2201154	g19046	i0	51.1	1.93617021276596	94	43	96.8	1	10	282	218	311	HYY26347.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	546	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
8377655	8377655	PRJNA745553_S_NODE_27987_length_233_cov_2.287500_g27792_i0	PRJNA745553	27987	233	2.2875	5.329875	Chthoniobacter sp.	2510640	Bacteria	Bacteria	74.7	4.02e-14	NR	WP_348542518.1	2510640	g27792	i0	64.7	1.6480686695279	68	23	87.6	1	206	3	86	152	WP_348542518.1 hypothetical protein [Chthoniobacter sp.]	diamond	384	74.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
21600796	21600796	PRJNA745553_S_NODE_15037_length_317_cov_12.877049_g14842_i0	PRJNA745553	15037	317	12.877049	40.82024533	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	71.2	2.61e-12	NR	MEY3000757.1	2026799	g14842	i0	49.5	0.899053627760252	95	48	89.9	0	22	306	88	182	MEY3000757.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	285	71.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27305777	27305777	PRJNA745553_S_NODE_8963_length_403_cov_3.045455_g8768_i0	PRJNA745553	8963	403	3.045455	12.27318365	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	221	1.16e-68	NR	MEQ1842569.1	2026801	g8768	i0	91.1	1.83126550868486	123	11	91.6	0	402	34	22	144	MEQ1842569.1 DUF1552 domain-containing protein [Verrucomicrobiales bacterium]	diamond	738	221	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27842258	27842258	PRJNA745553_S_NODE_24884_length_248_cov_10.537143_g24689_i0	PRJNA745553	24884	248	10.537143	26.13211464	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	97.1	6.04e-24	NR	NJR43130.1	2562705	g24689	i0	82.7	0.629032258064516	52	9	62.9	0	226	71	60	111	NJR43130.1 DUF3172 domain-containing protein [Akkermansiaceae bacterium]	diamond	156	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
28199524	28199524	PRJNA745553_S_NODE_2686_length_606_cov_7.123827_g2507_i0	PRJNA745553	2686	606	7.123827	43.17039162	Verrucomicrobiales	48461	Bacteria	Bacteria	129	1.68e-34	NR	NCF13526.1	2026800	g2507	i0	46.8	2.14356435643564	141	74	69.3	1	595	176	1	141	NCF13526.1 L,D-transpeptidase family protein [Verrucomicrobiaceae bacterium]	diamond	1299	130	0.992307692307692	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30432298	30432298	PRJNA745553_S_NODE_4593_length_519_cov_4.195067_g4403_i0	PRJNA745553	4593	519	4.195067	21.77239773	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	80.1	4.61e-16	NR	NJR41937.1	2562705	g4403	i0	55.8	1.01734104046243	77	33	43.9	1	181	408	24	100	NJR41937.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	528	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
31316683	31316683	PRJNA745553_S_NODE_11155_length_366_cov_2.174061_g10960_i0	PRJNA745553	11155	366	2.174061	7.95706326	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	117	2.42e-29	NR	NJR41800.1	2562705	g10960	i0	54.1	0.89344262295082	109	50	89.3	0	364	38	165	273	NJR41800.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	327	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32613515	32613515	PRJNA745553_S_NODE_19000_length_283_cov_7.700000_g18805_i0	PRJNA745553	19000	283	7.7	21.791	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	45.1	6.96e-4	NR	NJR41825.1	2562705	g18805	i0	76.9	0.826855123674912	26	6	27.6	0	275	198	33	58	NJR41825.1 hypothetical protein [Akkermansiaceae bacterium]	diamond	234	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32739632	32739632	PRJNA745553_S_NODE_20800_length_271_cov_3.661616_g20605_i0	PRJNA745553	20800	271	3.661616	9.92297936	Opitutaceae bacterium	2006848	Bacteria	Bacteria	54.7	3.21e-6	NR	MDR0902603.1	2006848	g20605	i0	39.3	0.929889298892989	84	46	87.5	2	3	239	475	558	MDR0902603.1 autotransporter outer membrane beta-barrel domain-containing protein [Opitutaceae bacterium]	diamond	252	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;