metadata: contig_metadata: 11 rows where bioproject = "PRJNA784298" and tax

11 rows where bioproject = "PRJNA784298" 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
765288	765288	PRJNA784298_P_NODE_14361_length_329_cov_1.703125_g14160_i0	PRJNA784298	14361	329	1.703125	5.60328125	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	551	2.499999999999999e-152	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g14160	i0	96.951	271.109422492401	328	10	99	0	2	329	737	410	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	89195	551	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
6317254	6317254	PRJNA784298_P_NODE_24305_length_249_cov_0.875000_g24104_i0	PRJNA784298	24305	249	0.875	2.17875	Pseudomonadati	3379134	Bacteria	Bacteria	138	2.11e-40	NR	MEW6156793.1	2026799	g24104	i0	87.7	5.27710843373494	73	9	88	0	219	1	1	73	MEW6156793.1 co-chaperone GroES [Verrucomicrobiota bacterium]	diamond	1314	138	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
10141926	10141926	PRJNA784298_P_NODE_8008_length_445_cov_1.870968_g7807_i0	PRJNA784298	8008	445	1.870968	8.3258076	Fontisphaera	3050007	Bacteria	Bacteria	403	1.0299999999999996e-107	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g7807	i0	87.052	82.8179775280899	363	39	80	6	1	357	3990513	3990873	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	36854	403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
17343608	17343608	PRJNA784298_P_NODE_23774_length_251_cov_0.865169_g23573_i0	PRJNA784298	23774	251	0.865169	2.17157419	Opitutia bacterium	2026771	Bacteria	Bacteria	87.4	7.81e-18	NR	MBI3884161.1	2026771	g23573	i0	59	0.99203187250996006	83	29	99.2	2	249	1	146	223	MBI3884161.1 U32 family peptidase [Opitutia bacterium]	diamond	249	87.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
24991818	24991818	PRJNA784298_P_NODE_24100_length_250_cov_0.870056_g23899_i0	PRJNA784298	24100	250	0.870056	2.17514	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	324	4.35e-84	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g23899	i0	90	98.896	250	25	100	0	1	250	914745	914994	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	24724	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27274923	27274923	PRJNA784298_P_NODE_12923_length_347_cov_1.854015_g12722_i0	PRJNA784298	12923	347	1.854015	6.43343205	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	132	1.96e-35	NR	RYD62014.1	2026800	g12722	i0	55.3	1.96253602305476	114	48	98.6	1	4	345	5	115	RYD62014.1 MAG: hypothetical protein EOP83_15680 [Verrucomicrobiaceae bacterium]	diamond	681	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27306634	27306634	PRJNA784298_P_NODE_27923_length_228_cov_2.896774_g27722_i0	PRJNA784298	27923	228	2.896774	6.60464472	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	86.3	7.58e-18	NR	HKP04302.1	2201154	g27722	i0	54.7	2.96052631578947	75	34	98.7	0	2	226	155	229	HKP04302.1 DUF2971 domain-containing protein [Chthoniobacterales bacterium]	diamond	675	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30717019	30717019	PRJNA784298_P_NODE_24014_length_250_cov_0.870056_g23813_i0	PRJNA784298	24014	250	0.870056	2.17514	Opitutaceae bacterium	2006848	Bacteria	Bacteria	78.6	4.32e-15	NR	MBX7120636.1	2006848	g23813	i0	47.7	1.032	86	40	99.6	2	2	250	43	126	MBX7120636.1 alpha/beta hydrolase [Opitutaceae bacterium]	diamond	258	78.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31791812	31791812	PRJNA784298_P_NODE_23297_length_253_cov_1.711111_g23096_i0	PRJNA784298	23297	253	1.711111	4.32911083	Pedosphaera parvula	1032527	Bacteria	Bacteria	64.3	3.29e-10	NR	WP_150107388.1	1032527	g23096	i0	53	0.782608695652174	66	30	78.3	1	199	2	71	135	WP_150107388.1 hypothetical protein [Pedosphaera parvula]	diamond	198	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
32013485	32013485	PRJNA784298_P_NODE_22038_length_261_cov_4.563830_g21837_i0	PRJNA784298	22038	261	4.56383	11.9115963	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	79.3	4e-17	NR	NBB80421.1	2026799	g21837	i0	50	0.850574712643678	74	37	85.1	0	226	5	1	74	NBB80421.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	222	79.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32677173	32677173	PRJNA784298_P_NODE_16800_length_302_cov_2.816594_g16599_i0	PRJNA784298	16800	302	2.816594	8.50611388	Rubritalea sp.	2109375	Bacteria	Bacteria	62.8	6.24e-9	NR	MEZ7957371.1	2109375	g16599	i0	42.5	1.70860927152318	73	34	69.5	2	210	1	106	173	MEZ7957371.1 DUF2971 domain-containing protein [Rubritalea sp.]	diamond	516	62.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea 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);;