metadata: contig_metadata: 12 rows where bioproject = "PRJNA1164198" and tax

12 rows where bioproject = "PRJNA1164198" 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
2862779	2862779	PRJNA1164198_P_NODE_16203_length_307_cov_2.632479_g15934_i0	PRJNA1164198	16203	307	2.632479	8.08171053	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	239	2.05e-58	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g15934	i0	82.394	189.296416938111	284	40	91	10	1	279	3047224	3047502	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	58114	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
6689890	6689890	PRJNA1164198_P_NODE_21146_length_270_cov_1.517766_g20877_i0	PRJNA1164198	21146	270	1.517766	4.0979682	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	342	1.31e-89	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g20877	i0	89.63	133.048148148148	270	27	100	1	1	270	3992068	3991800	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	35923	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
7965180	7965180	PRJNA1164198_P_NODE_16167_length_308_cov_1.174468_g15898_i0	PRJNA1164198	16167	308	1.174468	3.61736144	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	525	1.4099999999999995e-144	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g15898	i0	97.403	244.857142857143	308	8	100	0	1	308	2488	2795	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	75416	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
13065601	13065601	PRJNA1164198_P_NODE_2991_length_725_cov_3.254601_g2770_i0	PRJNA1164198	2991	725	3.254601	23.59585725	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	1201	0	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g2770	i0	96.556	128.51724137931	726	24	100	1	1	725	1070	1795	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	93175	1201	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
16889127	16889127	PRJNA1164198_P_NODE_5994_length_513_cov_3.020455_g5739_i0	PRJNA1164198	5994	513	3.020455	15.49493415	Prosthecobacter debontii	48467	Bacteria	Bacteria	898	0	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g5739	i0	98.252	274.009746588694	515	5	100	3	1	513	4544	4032	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	140567	898	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
23264192	23264192	PRJNA1164198_P_NODE_2079_length_859_cov_2.913486_g1894_i0	PRJNA1164198	2079	859	2.913486	25.02684474	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	1459	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g1894	i0	97.322	272.527357392317	859	23	100	0	1	859	1052	194	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	234101	1459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
27439255	27439255	PRJNA1164198_P_NODE_28563_length_246_cov_0.901734_g28294_i0	PRJNA1164198	28563	246	0.901734	2.21826564	Luteolibacter	518753	Bacteria	Bacteria	95.5	1.04e-20	NR	WP_200266655.1	454153	g28294	i0	63	1.8780487804878	81	29	97.6	1	5	244	30	110	WP_200266655.1 TonB-dependent hemoglobin/transferrin/lactoferrin family receptor [Luteolibacter pohnpeiensis]	diamond	462	95.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
28777285	28777285	PRJNA1164198_P_NODE_6287_length_502_cov_1.247086_g6029_i0	PRJNA1164198	6287	502	1.247086	6.26037172	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	223	2.3999999999999996e-69	NR	RYD65414.1	2026800	g6029	i0	71.7	0.99203187250996006	166	44	98.6	2	500	6	89	252	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	498	223	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29377291	29377291	PRJNA1164198_P_NODE_20169_length_276_cov_1.522167_g19900_i0	PRJNA1164198	20169	276	1.522167	4.20118092	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	45.1	0.00454	NR	HEU5395808.1	2499141	g19900	i0	44.7	0.41304347826087	38	21	41.3	0	153	266	110	147	HEU5395808.1 DUF6600 domain-containing protein [Verrucomicrobiia bacterium]	diamond	114	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30893699	30893699	PRJNA1164198_P_NODE_27754_length_247_cov_0.896552_g27485_i0	PRJNA1164198	27754	247	0.896552	2.21448344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	116	3.71e-28	NR	MBN9693850.1	2026799	g27485	i0	86.4	0.801619433198381	66	9	80.2	0	3	200	279	344	MBN9693850.1 CHASE3 domain-containing protein [Verrucomicrobiota bacterium]	diamond	198	116	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31272787	31272787	PRJNA1164198_P_NODE_25295_length_251_cov_0.876404_g25026_i0	PRJNA1164198	25295	251	0.876404	2.19977404	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	63.9	1.45e-9	NR	MBI3878789.1	2026799	g25026	i0	46.9	2.54581673306773	81	43	96.8	0	7	249	2229	2309	MBI3878789.1 tandem-95 repeat protein [Verrucomicrobiota bacterium]	diamond	639	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32127039	32127039	PRJNA1164198_P_NODE_25858_length_250_cov_0.881356_g25589_i0	PRJNA1164198	25858	250	0.881356	2.20339	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	106	3.96e-25	NR	MBI5800971.1	2026799	g25589	i0	71.2	3.96	66	19	79.2	0	199	2	1	66	MBI5800971.1 glutathionylspermidine synthase family protein [Verrucomicrobiota bacterium]	diamond	990	106	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);;