metadata: contig_metadata: 20 rows where bioproject = "PRJNA1174207", tax_clade = "PVC group" and tax

20 rows where bioproject = "PRJNA1174207", 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
315906	315906	PRJNA1174207_P_NODE_38461_length_245_cov_0.895349_g37932_i0	PRJNA1174207	38461	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	124	1.06e-30	NR	HXJ58072.1	2499141	g37932	i0	76.6	1.93469387755102	77	17	93.1	1	17	244	748	824	HXJ58072.1 response regulator [Verrucomicrobiia bacterium]	diamond	474	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
4142779	4142779	PRJNA1174207_P_NODE_3924_length_896_cov_2.331713_g3475_i0	PRJNA1174207	3924	896	2.331713	20.89214848	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	412	3.6e-110	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g3475	i0	82.626	58.6082589285714	495	58	78	15	422	893	914538	915027	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	52513	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6693741	6693741	PRJNA1174207_P_NODE_3866_length_905_cov_3.895433_g3418_i0	PRJNA1174207	3866	905	3.895433	35.25366865	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	691	0	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g3418	i0	80.773	246.667403314917	931	139	99	31	8	905	3049055	3048132	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	223234	691	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
7968673	7968673	PRJNA1174207_P_NODE_15287_length_369_cov_2.391892_g14758_i0	PRJNA1174207	15287	369	2.391892	8.82608148	Pedosphaera parvula	1032527	Bacteria	Bacteria	549	1.0199999999999994e-151	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g14758	i0	94.183	135.634146341463	361	19	98	1	9	369	2251	1893	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	50049	549	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
9243793	9243793	PRJNA1174207_P_NODE_40328_length_242_cov_1.822485_g39799_i0	PRJNA1174207	40328	242	1.822485	4.4104137	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|511202471\|gb\|KC994702.1\|	156588	g39799	i0	94.239	95.7231404958678	243	12	100	2	1	242	16	257	Uncultured Verrucomicrobia bacterium clone BF 022 16S ribosomal RNA gene, partial sequence	blastn	23165	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10519119	10519119	PRJNA1174207_P_NODE_20289_length_314_cov_3.647303_g19760_i0	PRJNA1174207	20289	314	3.647303	11.45253142	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	392	1.52e-104	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g19760	i0	89.164	88.0350318471338	323	23	99	7	1	312	3832284	3832605	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	27643	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11794217	11794217	PRJNA1174207_P_NODE_26370_length_280_cov_1.193237_g25841_i0	PRJNA1174207	26370	280	1.193237	3.3410636	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	83.6	1.05e-18	NR	HEY6169472.1	2499141	g25841	i0	87	0.492857142857143	46	6	49.3	0	279	142	44	89	HEY6169472.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	138	83.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
14344571	14344571	PRJNA1174207_P_NODE_25772_length_282_cov_2.181818_g25243_i0	PRJNA1174207	25772	282	2.181818	6.15272676	Opitutales bacterium	2026772	Bacteria	Bacteria	255	1.85e-63	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g25243	i0	83.333	55.2836879432624	288	37	100	11	1	282	1410404	1410122	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	15590	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
19441951	19441951	PRJNA1174207_P_NODE_42956_length_229_cov_2.416667_g42427_i0	PRJNA1174207	42956	229	2.416667	5.53416743	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	353	5e-93	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g42427	i0	94.737	40.4148471615721	228	11	99	1	2	229	1315574	1315800	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	9255	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24541783	24541783	PRJNA1174207_P_NODE_37000_length_247_cov_0.879310_g36471_i0	PRJNA1174207	37000	247	0.87931	2.1718957	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	429	8.83e-116	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g36471	i0	97.976	124.279352226721	247	5	100	0	1	247	2834000	2833754	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	30697	429	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
27230099	27230099	PRJNA1174207_P_NODE_30023_length_264_cov_2.649215_g29494_i0	PRJNA1174207	30023	264	2.649215	6.9939276	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.4	0.00558	NR	MCX6922885.1	2026799	g29494	i0	34.1	0.965909090909091	85	53	94.3	2	261	13	674	757	MCX6922885.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	255	45.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27281094	27281094	PRJNA1174207_P_NODE_34803_length_249_cov_1.590909_g34274_i0	PRJNA1174207	34803	249	1.590909	3.96136341	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0209	NR	MBQ8480518.1	1872421	g34274	i0	64.7	0.867469879518072	34	12	41	0	229	128	326	359	MBQ8480518.1 ankyrin repeat domain-containing protein [Akkermansia sp.]	diamond	216	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
27439275	27439275	PRJNA1174207_P_NODE_34063_length_250_cov_1.378531_g33534_i0	PRJNA1174207	34063	250	1.378531	3.4463275	Pseudomonadati	3379134	Bacteria	Bacteria	81.6	8.44e-16	NR	PAW85177.1	1982324	g33534	i0	49.4	2.844	79	36	93.6	2	249	16	1173	1248	PAW85177.1 MAG: hypothetical protein B9S33_10250 [Pedosphaera sp. Tous-C6FEB]	diamond	711	81.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp. Tous-C6FEB
27577648	27577648	PRJNA1174207_P_NODE_34184_length_250_cov_0.870056_g33655_i0	PRJNA1174207	34184	250	0.870056	2.17514	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	103	1.33e-26	NR	MBL9176239.1	2026801	g33655	i0	91.2	0.684	57	5	68.4	0	248	78	37	93	MBL9176239.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	171	103	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28872102	28872102	PRJNA1174207_P_NODE_32768_length_253_cov_1.544444_g32239_i0	PRJNA1174207	32768	253	1.544444	3.90744332	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	58.2	1.49e-7	NR	RYD24165.1	2026800	g32239	i0	45.9	5.58498023715415	61	32	71.1	1	30	209	371	431	RYD24165.1 MAG: hypothetical protein EOP88_01315 [Verrucomicrobiaceae bacterium]	diamond	1413	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29711960	29711960	PRJNA1174207_P_NODE_30570_length_262_cov_1.650794_g30041_i0	PRJNA1174207	30570	262	1.650794	4.32508028	Bacteria	2	Bacteria	Bacteria	110	9.78e-26	NR	WP_107835717.1	2161864	g30041	i0	67.1	2.88549618320611	82	27	93.9	0	16	261	234	315	WP_107835717.1 immunoglobulin domain-containing protein [Opitutus sp. ER46]	diamond	756	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. ER46
30134978	30134978	PRJNA1174207_P_NODE_25592_length_283_cov_1.466667_g25063_i0	PRJNA1174207	25592	283	1.466667	4.15066761	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00331	NR	MEI6395524.1	2026799	g25063	i0	32.3	1.35689045936396	65	44	68.9	0	271	77	208	272	MEI6395524.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	384	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32221874	32221874	PRJNA1174207_P_NODE_34498_length_250_cov_0.870056_g33969_i0	PRJNA1174207	34498	250	0.870056	2.17514	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	137	4.11e-36	NR	KAB2643361.1	2026799	g33969	i0	85.4	0.984	82	12	98.4	0	2	247	444	525	KAB2643361.1 MAG: phosphoglycerate dehydrogenase [Verrucomicrobiota bacterium]	diamond	246	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32695717	32695717	PRJNA1174207_P_NODE_33460_length_251_cov_0.865169_g32931_i0	PRJNA1174207	33460	251	0.865169	2.17157419	Candidatus Methylacidithermus pantelleriae	2744239	Bacteria	Bacteria	122	1.2699999999999998e-31	NR	WP_174581898.1	2744239	g32931	i0	66.3	2.92828685258964	83	28	99.2	0	1	249	132	214	WP_174581898.1 ABC transporter ATP-binding protein [Candidatus Methylacidithermus pantelleriae]	diamond	735	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Candidatus Methylacidithermus	Candidatus Methylacidithermus pantelleriae
32884608	32884608	PRJNA1174207_P_NODE_26340_length_280_cov_1.386473_g25811_i0	PRJNA1174207	26340	280	1.386473	3.8821244	Pedosphaera sp.	2024890	Bacteria	Bacteria	70.1	1.29e-11	NR	MSU62111.1	2024890	g25811	i0	85.7	0.9	42	6	45	0	154	279	1	42	MSU62111.1 cation:proton antiporter [Pedosphaera sp.]	diamond	252	70.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera 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);;