metadata: contig_metadata: 12 rows where bioproject = "PRJNA1150539", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA1150539", 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
19427093	19427093	PRJNA1150539_S_NODE_12736_length_417_cov_3.011628_g12141_i0	PRJNA1150539	12736	417	3.011628	12.55848876	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	726	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g12141	i0	98.082	71.9808153477218	417	8	100	0	1	417	3556264	3556680	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	30016	726	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
21977796	21977796	PRJNA1150539_S_NODE_14198_length_408_cov_3.611940_g13603_i0	PRJNA1150539	14198	408	3.61194	14.7367152	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	673	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g13603	i0	96.552	137.720588235294	406	14	99	0	3	408	15824	15419	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	56190	673	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26787206	26787206	PRJNA1150539_S_NODE_71701_length_277_cov_2.264706_g71105_i0	PRJNA1150539	71701	277	2.264706	6.27323562	Akkermansia sp.	1872421	Bacteria	Bacteria	43.5	0.0269	NR	MBQ4593882.1	1872421	g71105	i0	37	1.08303249097473	54	34	58.5	0	55	216	40	93	MBQ4593882.1 hypothetical protein [Akkermansia sp.]	diamond	300	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
27229865	27229865	PRJNA1150539_S_NODE_107823_length_230_cov_3.025478_g107227_i0	PRJNA1150539	107823	230	3.025478	6.9585994	Pedosphaera sp.	2024890	Bacteria	Bacteria	42.4	0.0427	NR	MDB6067758.1	2024890	g107227	i0	37.3	0.665217391304348	51	29	62.6	1	148	5	64	114	MDB6067758.1 hydrogenase [Pedosphaera sp.]	diamond	153	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
28840284	28840284	PRJNA1150539_S_NODE_34388_length_342_cov_2.457249_g33792_i0	PRJNA1150539	34388	342	2.457249	8.40379158	Opitutaceae bacterium	2006848	Bacteria	Bacteria	47	0.00367	NR	MBL9211338.1	2006848	g33792	i0	32.9	0.640350877192982	73	48	63.2	1	315	100	77	149	MBL9211338.1 hypothetical protein [Opitutaceae bacterium]	diamond	219	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29061531	29061531	PRJNA1150539_S_NODE_111968_length_211_cov_5.318841_g111372_i0	PRJNA1150539	111968	211	5.318841	11.22275451	Cephaloticoccus sp.	1985742	Bacteria	Bacteria	42	0.0447	NR	MCF7687979.1	1985742	g111372	i0	39.5	0.611374407582938	43	26	61.1	0	55	183	180	222	MCF7687979.1 DMT family transporter [Cephaloticoccus sp.]	diamond	129	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Cephaloticoccus	Cephaloticoccus sp.
29977064	29977064	PRJNA1150539_S_NODE_82611_length_262_cov_3.920635_g82015_i0	PRJNA1150539	82611	262	3.920635	10.2720637	Verrucomicrobium sp.	72225	Bacteria	Bacteria	45.1	0.00737	NR	HSJ02196.1	72225	g82015	i0	30.9	0.927480916030534	81	55	91.6	1	10	249	587	667	HSJ02196.1 glycosyltransferase [Verrucomicrobium sp.]	diamond	243	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp.
29977066	29977066	PRJNA1150539_S_NODE_93451_length_250_cov_0.870056_g92855_i0	PRJNA1150539	93451	250	0.870056	2.17514	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	43.5	0.0214	NR	MBA3883302.1	2201154	g92855	i0	53.8	0.624	52	20	60	2	245	96	807	856	MBA3883302.1 FtsX-like permease family protein [Chthoniobacterales bacterium]	diamond	156	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30798490	30798490	PRJNA1150539_S_NODE_94354_length_249_cov_1.017045_g93758_i0	PRJNA1150539	94354	249	1.017045	2.5324420499999998	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0214	NR	RFC44247.1	2026799	g93758	i0	32.5	0.963855421686747	80	38	83.1	5	16	222	159	233	RFC44247.1 MAG: multidrug resistance protein, MATE family [Verrucomicrobiota bacterium]	diamond	240	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31114324	31114324	PRJNA1150539_S_NODE_104055_length_238_cov_5.151515_g103459_i0	PRJNA1150539	104055	238	5.151515	12.2606057	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42.4	0.0471	NR	HPA19819.1	2499141	g103459	i0	43.6	0.69327731092437	55	24	69.3	1	55	219	159	206	HPA19819.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	165	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31304168	31304168	PRJNA1150539_S_NODE_107815_length_230_cov_3.101911_g107219_i0	PRJNA1150539	107815	230	3.101911	7.1343953	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	41.6	0.0453	NR	MFT7473450.1	2026801	g107219	i0	37	0.704347826086957	54	34	70.4	0	189	28	5	58	MFT7473450.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	162	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31494140	31494140	PRJNA1150539_S_NODE_98616_length_245_cov_0.895349_g98020_i0	PRJNA1150539	98616	245	0.895349	2.19360505	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	42.4	0.05	NR	MEJ6778655.1	2562705	g98020	i0	43.8	0.783673469387755	32	18	39.2	0	57	152	306	337	MEJ6778655.1 substrate-binding domain-containing protein [Akkermansiaceae bacterium]	diamond	192	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae 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);;