metadata: contig_metadata: 9 rows where bioproject = "PRJNA667863" and tax

9 rows where bioproject = "PRJNA667863" 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
7012638	7012638	PRJNA667863_P_NODE_9186_length_262_cov_2.740741_g9152_i0	PRJNA667863	9186	262	2.740741	7.18074142	Opitutaceae	134623	Bacteria	Bacteria	151	1.7499999999999999e-40	NR	HWA27973.1	1961806	g9152	i0	83.1	11.6793893129771	83	14	95	0	260	12	354	436	HWA27973.1 NADP-dependent isocitrate dehydrogenase [Lacunisphaera sp.]	diamond	3060	152	0.993421052631579	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
22311334	22311334	PRJNA667863_P_NODE_2678_length_362_cov_2.342561_g2644_i0	PRJNA667863	2678	362	2.342561	8.48007082	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	592	1.6399999999999999e-164	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g2644	i0	96.133	212.176795580111	362	14	100	0	1	362	1296	935	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	76808	592	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
26903935	26903935	PRJNA667863_P_NODE_14281_length_246_cov_0.884393_g14247_i0	PRJNA667863	14281	246	0.884393	2.17560678	Opitutales	415000	Bacteria	Bacteria	117	7.06e-30	NR	MCR6655187.1	1913982	g14247	i0	71.6	9.87804878048781	81	23	98.8	0	3	245	116	196	MCR6655187.1 arsenite methyltransferase [Opitutus sp.]	diamond	2430	118	0.991525423728814	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
27662468	27662468	PRJNA667863_P_NODE_11264_length_251_cov_1.382022_g11230_i0	PRJNA667863	11264	251	1.382022	3.46887522	Pseudomonadati	3379134	Bacteria	Bacteria	108	3.87e-28	NR	WP_144228505.1	2597822	g11230	i0	67.5	6.69322709163347	80	26	95.6	0	8	247	6	85	WP_144228505.1 glycine cleavage system protein GcvH [Rariglobus hedericola]	diamond	1680	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Rariglobus	Rariglobus hedericola
27946472	27946472	PRJNA667863_P_NODE_6325_length_285_cov_1.301887_g6291_i0	PRJNA667863	6325	285	1.301887	3.71037795	Pedosphaera	1032526	Bacteria	Bacteria	80.5	9.78e-16	NR	WP_007416468.1	1032527	g6291	i0	47.5	2.71578947368421	80	42	84.2	0	7	246	43	122	WP_007416468.1 factor-independent urate hydroxylase [Pedosphaera parvula]	diamond	774	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
28483256	28483256	PRJNA667863_P_NODE_13426_length_247_cov_0.885057_g13392_i0	PRJNA667863	13426	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	58.2	1.51e-7	NR	WP_265594688.1	1396141	g13392	i0	42.9	3.20647773279352	70	38	82.6	1	23	226	1212	1281	WP_265594688.1 malectin domain-containing carbohydrate-binding protein [Haloferula sp. BvORR071]	diamond	792	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sp. BvORR071
28629252	28629252	PRJNA667863_P_NODE_2147_length_387_cov_1.770701_g2113_i0	PRJNA667863	2147	387	1.770701	6.85261287	Chthoniobacter sp.	2510640	Bacteria	Bacteria	186	3.4e-54	NR	MDR3405335.1	2510640	g2113	i0	86.1	0.782945736434108	101	14	78.3	0	3	305	364	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	303	186	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
28692406	28692406	PRJNA667863_P_NODE_12167_length_249_cov_2.414773_g12133_i0	PRJNA667863	12167	249	2.414773	6.01278477	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	84	1.27e-16	NR	WP_317831229.1	3080537	g12133	i0	53.1	1.89156626506024	81	36	95.2	2	237	1	119	199	WP_317831229.1 hypothetical protein [Rubellicoccus peritrichatus]	diamond	471	84	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
31883165	31883165	PRJNA667863_P_NODE_11897_length_250_cov_0.870056_g11863_i0	PRJNA667863	11897	250	0.870056	2.17514	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	75.1	2.49e-14	NR	MEO6740094.1	2811408	g11863	i0	52.8	2.604	72	31	86.4	1	219	4	85	153	MEO6740094.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	651	75.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae 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);;