metadata: contig_metadata: 14 rows where bioproject = "PRJNA1041773", tax_clade = "PVC group" and tax

14 rows where bioproject = "PRJNA1041773", tax_clade = "PVC group" 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
2721499	2721499	PRJNA1041773_P_NODE_92403_length_245_cov_0.883721_g92070_i0	PRJNA1041773	92403	245	0.883721	2.16511645	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	119	2.15e-22	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g92070	i0	80.519	5.77959183673469	154	30	63	0	8	161	3347427	3347580	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	1416	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10374154	10374154	PRJNA1041773_P_NODE_85349_length_248_cov_0.880000_g85016_i0	PRJNA1041773	85349	248	0.88	2.1824	Akkermansia muciniphila	239935	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2051370031\|gb\|CP072028.1\|	239935	g85016	i0	100	0.225806451612903	28	0	11	0	75	102	432415	432442	Akkermansia muciniphila strain Akk1756 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
10374356	10374356	PRJNA1041773_P_NODE_98569_length_242_cov_0.911243_g98236_i0	PRJNA1041773	98569	242	0.911243	2.20520806	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	207	4.4e-49	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g98236	i0	82.591	4.98760330578512	247	31	99	8	2	242	2602674	2602434	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1207	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
16310970	16310970	PRJNA1041773_P_NODE_62893_length_274_cov_2.059701_g62560_i0	PRJNA1041773	62893	274	2.059701	5.64358074	Prosthecobacter sp.	1965333	Bacteria	Bacteria	155	7.399999999999998e-44	NR	WP_409217702.1	1965333	g62560	i0	88.9	3.94160583941606	90	10	98.5	0	272	3	83	172	WP_409217702.1 dihydrodipicolinate synthase family protein [Prosthecobacter sp.]	diamond	1080	155	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
18022849	18022849	PRJNA1041773_P_NODE_89055_length_246_cov_0.890173_g88722_i0	PRJNA1041773	89055	246	0.890173	2.18982558	uncultured Opitutaceae bacterium	333967	Bacteria	Bacteria	135	2.14e-27	NTclustered	gi\|2518551946\|emb\|OX638348.1\|	333967	g88722	i0	92.632	30.2764227642276	95	6	38	1	151	244	427402	427308	MAG: uncultured Opitutaceae bacterium isolate b1b57f99-08c0-43d1-969e-fd0ef39b1292 genome assembly, chromosome: 1	blastn	7448	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		uncultured Opitutaceae bacterium
24396921	24396921	PRJNA1041773_P_NODE_80160_length_250_cov_0.870056_g79827_i0	PRJNA1041773	80160	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	170	1.8099999999999994e-48	NR	KAB2674814.1	2026799	g79827	i0	98.8	0.996	83	1	99.6	0	2	250	196	278	KAB2674814.1 MAG: citramalate synthase [Verrucomicrobiota bacterium]	diamond	249	170	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26718261	26718261	PRJNA1041773_P_NODE_79901_length_250_cov_0.870056_g79568_i0	PRJNA1041773	79901	250	0.870056	2.17514	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	86.7	1.42e-17	NR	MBX7208200.1	2026800	g79568	i0	71.9	3.312	64	18	76.8	0	57	248	1503	1566	MBX7208200.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiaceae bacterium]	diamond	828	86.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27003393	27003393	PRJNA1041773_P_NODE_72802_length_257_cov_2.945652_g72469_i0	PRJNA1041773	72802	257	2.945652	7.57032564	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.00213	NR	MEC7236316.1	2026799	g72469	i0	46.9	0.571984435797665	49	26	57.2	0	19	165	25	73	MEC7236316.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	147	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28677555	28677555	PRJNA1041773_P_NODE_80427_length_250_cov_0.870056_g80094_i0	PRJNA1041773	80427	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	156	3.18e-42	NR	MEM7144846.1	2026799	g80094	i0	88	1.992	83	10	99.6	0	249	1	373	455	MEM7144846.1 PBP1A family penicillin-binding protein [Verrucomicrobiota bacterium]	diamond	498	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29025111	29025111	PRJNA1041773_P_NODE_83348_length_249_cov_0.869318_g83015_i0	PRJNA1041773	83348	249	0.869318	2.16460182	Rubritalea squalenifaciens	407226	Bacteria	Bacteria	86.3	1.98e-17	NR	WP_143185317.1	407226	g83015	i0	50.6	1.87951807228916	81	39	97.6	1	7	249	302	381	WP_143185317.1 YbcC family protein [Rubritalea squalenifaciens]	diamond	468	86.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea squalenifaciens
29237861	29237861	PRJNA1041773_P_NODE_62529_length_275_cov_1.475248_g62196_i0	PRJNA1041773	62529	275	1.475248	4.056932	Pseudomonadati	3379134	Bacteria	Bacteria	99.4	2.05e-22	NR	MDA0577526.1	2026799	g62196	i0	52.7	5.86909090909091	91	43	99.3	0	2	274	255	345	MDA0577526.1 glycosyltransferase family 4 protein [Verrucomicrobiota bacterium]	diamond	1614	99.8	0.995991983967936	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29403657	29403657	PRJNA1041773_P_NODE_69509_length_263_cov_1.315789_g69176_i0	PRJNA1041773	69509	263	1.315789	3.46052507	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	112	8.020000000000001e-27	NR	MEQ1854657.1	2811408	g69176	i0	71.6	0.844106463878327	74	21	84.4	0	223	2	1	74	MEQ1854657.1 diguanylate cyclase [Chthoniobacteraceae bacterium]	diamond	222	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
30027317	30027317	PRJNA1041773_P_NODE_52291_length_296_cov_2.116592_g51958_i0	PRJNA1041773	52291	296	2.116592	6.26511232	Pseudomonadati	3379134	Bacteria	Bacteria	66.2	3.71e-10	NR	OHE72203.1	1802430	g51958	i0	38.6	2.61486486486486	83	51	84.1	0	294	46	113	195	OHE72203.1 MAG: hypothetical protein A2007_06005 [Verrucomicrobia bacterium GWC2_42_7]	diamond	774	66.6	0.993993993993994	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium GWC2_42_7
30920091	30920091	PRJNA1041773_P_NODE_57854_length_284_cov_1.459716_g57521_i0	PRJNA1041773	57854	284	1.459716	4.14559344	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	105	1.24e-24	NR	MBM3831123.1	2026799	g57521	i0	75.4	2.87323943661972	69	14	72.9	1	209	3	17	82	MBM3831123.1 zinc ABC transporter substrate-binding protein [Verrucomicrobiota bacterium]	diamond	816	105	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);;