metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA407368" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA407368" 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
25307873	25307873	PRJNA407368_S_NODE_7640_length_187_cov_1.822785_g7538_i0	PRJNA407368	7640	187	1.822785	3.40860795	Verrucomicrobiaceae	203557	Bacteria	Bacteria	88.6	1.31e-20	NR	WP_146853805.1	748831	g7538	i0	97.7	2.06951871657754	43	1	69	0	129	1	1	43	WP_146853805.1 50S ribosomal protein L11 [Brevifollis gellanilyticus]	diamond	387	88.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Brevifollis	Brevifollis gellanilyticus
26758823	26758823	PRJNA407368_S_NODE_8601_length_173_cov_3.256944_g8499_i0	PRJNA407368	8601	173	3.256944	5.63451312	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	112	4.81e-29	NR	MCX8494651.1	2562705	g8499	i0	89.5	2.96531791907514	57	6	98.8	0	172	2	117	173	MCX8494651.1 WYL domain-containing protein [Akkermansiaceae bacterium]	diamond	513	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
27991567	27991567	PRJNA407368_S_NODE_945_length_659_cov_5.171429_g872_i0	PRJNA407368	945	659	5.171429	34.07971711	Limisphaerales bacterium	2052186	Bacteria	Bacteria	116	7.24e-26	NR	MFN7140247.1	2052186	g872	i0	39	0.723823975720789	159	96	71.9	1	161	634	83	241	MFN7140247.1 phage tail tape measure C-terminal domain-containing protein [Limisphaerales bacterium]	diamond	477	116	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
28117609	28117609	PRJNA407368_S_NODE_5085_length_246_cov_4.055300_g4983_i0	PRJNA407368	5085	246	4.0553	9.976038	Prosthecobacter sp.	1965333	Bacteria	Bacteria	43.9	0.0143	NR	WP_395741070.1	1965333	g4983	i0	39.3	0.74390243902439	61	37	74.4	0	20	202	261	321	WP_395741070.1 hypothetical protein [Prosthecobacter sp.]	diamond	183	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
29412171	29412171	PRJNA407368_S_NODE_6069_length_218_cov_3.444444_g5967_i0	PRJNA407368	6069	218	3.444444	7.50888792	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	61.6	4.33e-9	NR	HCN76532.1	2026801	g5967	i0	62.2	1.41743119266055	45	16	60.6	1	207	76	114	158	HCN76532.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	309	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29601394	29601394	PRJNA407368_S_NODE_1370_length_541_cov_8.160156_g1280_i0	PRJNA407368	1370	541	8.160156	44.14644396	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	122	1.54e-28	NR	MBL9132061.1	2026800	g1280	i0	89.2	0.360443622920518	65	7	36	0	237	431	619	683	MBL9132061.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	195	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30233424	30233424	PRJNA407368_S_NODE_7692_length_186_cov_2.694268_g7590_i0	PRJNA407368	7692	186	2.694268	5.01133848	Prosthecobacter sp.	1965333	Bacteria	Bacteria	104	2.95e-25	NR	MCW0219802.1	1965333	g7590	i0	80.6	2	62	12	100	0	186	1	52	113	MCW0219802.1 hypothetical protein [Prosthecobacter sp.]	diamond	372	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30960197	30960197	PRJNA407368_S_NODE_9314_length_164_cov_2.607407_g9212_i0	PRJNA407368	9314	164	2.607407	4.27614748	Opitutaceae bacterium	2006848	Bacteria	Bacteria	62.4	1.17e-9	NR	MBK8857386.1	2006848	g9212	i0	44.4	0.98780487804878	54	30	98.8	0	2	163	8	61	MBK8857386.1 methyltransferase domain-containing protein [Opitutaceae bacterium]	diamond	162	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31134473	31134473	PRJNA407368_S_NODE_4595_length_264_cov_9.234043_g4493_i0	PRJNA407368	4595	264	9.234043	24.37787352	Pseudomonadati	3379134	Bacteria	Bacteria	93.2	8.84e-20	NR	MFU8893939.1	1962973	g4493	i0	59.8	1.875	82	33	93.2	0	251	6	1257	1338	MFU8893939.1 InlB B-repeat-containing protein [Luteolibacter sp.]	diamond	495	93.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
31339340	31339340	PRJNA407368_S_NODE_4156_length_282_cov_9.505929_g4054_i0	PRJNA407368	4156	282	9.505929	26.80671978	Lacunisphaera sp.	1961806	Bacteria	Bacteria	99	4.52e-23	NR	HEY8994270.1	1961806	g4054	i0	53.1	0.861702127659574	81	37	85.1	1	281	42	117	197	HEY8994270.1 hypothetical protein [Lacunisphaera sp.]	diamond	243	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
31482878	31482878	PRJNA407368_S_NODE_6776_length_203_cov_2.522989_g6674_i0	PRJNA407368	6776	203	2.522989	5.12166767	PVC group	1783257	Bacteria	Bacteria	70.5	1.11e-12	NR	PYJ66209.1	2026799	g6674	i0	59	3.54679802955665	61	25	90.1	0	21	203	165	225	PYJ66209.1 MAG: hypothetical protein DME76_17385 [Verrucomicrobiota bacterium]	diamond	720	71.2	0.990168539325843	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32225266	32225266	PRJNA407368_S_NODE_9278_length_164_cov_8.822222_g9176_i0	PRJNA407368	9278	164	8.822222	14.46844408	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	104	2.4199999999999998e-24	NR	MEY4385138.1	2026799	g9176	i0	87	0.98780487804878	54	7	98.8	0	1	162	286	339	MEY4385138.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	162	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;