metadata: contig_metadata: 13 rows where bioproject = "PRJNA591000" and tax

13 rows where bioproject = "PRJNA591000" 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
22242052	22242052	PRJNA591000_P_NODE_3758_length_738_cov_5.322990_g2936_i0	PRJNA591000	3758	738	5.32299	39.2836662	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	240	1.06e-68	NR	MBX7207638.1	2026800	g2936	i0	63.8	0.886178861788618	218	22	88.6	4	725	72	1102	1262	MBX7207638.1 DUF4011 domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	654	240	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27680249	27680249	PRJNA591000_P_NODE_12324_length_414_cov_0.805195_g10738_i0	PRJNA591000	12324	414	0.805195	3.3335073	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	48.9	0.00143	NR	MEK0448308.1	2026799	g10738	i0	64.7	0.246376811594203	34	12	24.6	0	395	294	335	368	MEK0448308.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	102	48.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27680251	27680251	PRJNA591000_P_NODE_7784_length_499_cov_2.546809_g6294_i0	PRJNA591000	7784	499	2.546809	12.70857691	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	92	8.56e-21	NR	HEY4417590.1	2499141	g6294	i0	46.1	0.535070140280561	89	47	52.9	1	461	198	1	89	HEY4417590.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	267	92	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27711947	27711947	PRJNA591000_P_NODE_13924_length_395_cov_4.062842_g12329_i0	PRJNA591000	13924	395	4.062842	16.0482259	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	91.7	3.9900000000000005e-21	NR	HEY4417590.1	2499141	g12329	i0	46.1	0.675949367088608	89	47	66.8	1	357	94	1	89	HEY4417590.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	267	91.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29605598	29605598	PRJNA591000_P_NODE_370_length_1474_cov_20.310727_g258_i0	PRJNA591000	370	1474	20.310727	299.38011598	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	143	1.13e-33	NR	MEI6676827.1	2026799	g258	i0	51.4	0.293080054274084	144	69	29.1	1	767	339	41	184	MEI6676827.1 ParB/RepB/Spo0J family partition protein [Verrucomicrobiota bacterium]	diamond	432	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29605599	29605599	PRJNA591000_P_NODE_7110_length_525_cov_95.171371_g5688_i0	PRJNA591000	7110	525	95.171371	499.64969775	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	184	2.6699999999999992e-55	NR	MBK8037706.1	2026800	g5688	i0	73.9	0.68	119	31	68	0	1	357	100	218	MBK8037706.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	357	184	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
30016611	30016611	PRJNA591000_P_NODE_14091_length_393_cov_2.939560_g12495_i0	PRJNA591000	14091	393	2.93956	11.5524708	Prosthecobacter sp.	1965333	Bacteria	Bacteria	105	5.229999999999999e-24	NR	WP_395739316.1	1965333	g12495	i0	47.9	1.06870229007634	140	28	99.2	5	3	392	109	213	WP_395739316.1 CHC2 zinc finger domain-containing protein [Prosthecobacter sp.]	diamond	420	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30205799	30205799	PRJNA591000_P_NODE_5532_length_620_cov_4.978003_g4362_i0	PRJNA591000	5532	620	4.978003	30.8636186	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	263	7.27e-86	NR	MEY4244055.1	2026799	g4362	i0	62.5	0.890322580645161	184	69	89	0	613	62	16	199	MEY4244055.1 adenine-specific DNA-methyltransferase [Verrucomicrobiota bacterium]	diamond	552	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30364472	30364472	PRJNA591000_P_NODE_8192_length_486_cov_1.599562_g6680_i0	PRJNA591000	8192	486	1.599562	7.77387132	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	56.6	1.79e-6	NR	HOC56633.1	2026799	g6680	i0	47.3	0.339506172839506	55	29	34	0	481	317	44	98	HOC56633.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	165	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32102811	32102811	PRJNA591000_P_NODE_8618_length_474_cov_1.622472_g7090_i0	PRJNA591000	8618	474	1.622472	7.69051728	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.5	1.59e-12	NR	MBS0604045.1	2026799	g7090	i0	53.6	0.436708860759494	69	29	41.8	1	203	6	489	557	MBS0604045.1 2-succinyl-5-enolpyruvyl-6-hydroxy-3-cyclohexene-1-carboxylic-acid synthase [Verrucomicrobiota bacterium]	diamond	207	75.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32356246	32356246	PRJNA591000_P_NODE_15839_length_202_cov_3.260116_g14233_i0	PRJNA591000	15839	202	3.260116	6.58543432	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	92.8	3.3e-22	NR	MEI6872177.1	2026799	g14233	i0	64.1	0.95049504950495	64	23	95	0	11	202	61	124	MEI6872177.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	192	92.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32514469	32514469	PRJNA591000_P_NODE_15459_length_318_cov_10.792388_g13853_i0	PRJNA591000	15459	318	10.792388	34.31979384	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	130	4.96e-35	NR	MDH4474878.1	2026800	g13853	i0	77.5	0.754716981132076	80	16	73.6	1	72	305	1	80	MDH4474878.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	240	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32735013	32735013	PRJNA591000_P_NODE_14740_length_385_cov_0.941011_g13138_i0	PRJNA591000	14740	385	0.941011	3.62289235	Prosthecobacter sp.	1965333	Bacteria	Bacteria	58.9	3.77e-7	NR	WP_395739310.1	1965333	g13138	i0	74.3	0.272727272727273	35	9	27.3	0	383	279	15	49	WP_395739310.1 terminase gpA endonuclease subunit [Prosthecobacter sp.]	diamond	105	58.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter 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);;