metadata: contig_metadata: 15 rows where bioproject = "PRJNA1129273", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA1129273", 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
1557875	1557875	PRJNA1129273_P_NODE_7922_length_259_cov_3.715054_g7642_i0	PRJNA1129273	7922	259	3.715054	9.62198986	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	326	1.26e-84	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g7642	i0	91.057	82.5057915057915	246	15	93	7	19	259	3893546	3893303	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	21369	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4110253	4110253	PRJNA1129273_P_NODE_2224_length_529_cov_2.907895_g1948_i0	PRJNA1129273	2224	529	2.907895	15.38276455	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	143	2.99e-29	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g1948	i0	83.125	28.9243856332703	160	23	30	4	360	517	2577507	2577350	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	15301	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
6661106	6661106	PRJNA1129273_P_NODE_2186_length_534_cov_3.689805_g1910_i0	PRJNA1129273	2186	534	3.689805	19.7035587	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	741	0	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g1910	i0	91.745	136.947565543071	533	44	99	0	1	533	2556925	2556393	Lacunisphaera limnophila strain IG16b, complete genome	blastn	73130	741	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
6661145	6661145	PRJNA1129273_P_NODE_7506_length_265_cov_1.713542_g7226_i0	PRJNA1129273	7506	265	1.713542	4.5408863	Pedosphaera parvula	1032527	Bacteria	Bacteria	285	2.19e-72	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g7226	i0	86.466	45.777358490566	266	29	98	7	4	264	1631	1368	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	12131	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
7936258	7936258	PRJNA1129273_P_NODE_11007_length_231_cov_2.468354_g10727_i0	PRJNA1129273	11007	231	2.468354	5.70189774	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	425	1.0599999999999999e-114	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g10727	i0	100	160.580086580087	230	0	99	0	2	231	2557847	2558076	Lacunisphaera limnophila strain IG16b, complete genome	blastn	37094	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
9211237	9211237	PRJNA1129273_P_NODE_11008_length_231_cov_2.449367_g10728_i0	PRJNA1129273	11008	231	2.449367	5.65803777	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	388	1.39e-103	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g10728	i0	97.778	173.65367965368	225	5	97	0	1	225	3894484	3894708	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	40114	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11761856	11761856	PRJNA1129273_P_NODE_3690_length_380_cov_2.097720_g3410_i0	PRJNA1129273	3690	380	2.09772	7.971336	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	623	6.119999999999999e-174	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g3410	i0	96.552	227.952631578947	377	12	99	1	5	380	3892529	3892905	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	86622	623	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13036958	13036958	PRJNA1129273_P_NODE_3451_length_395_cov_1.509317_g3171_i0	PRJNA1129273	3451	395	1.509317	5.96180215	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	647	0	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g3171	i0	96.203	136.921518987342	395	15	100	0	1	395	914882	915276	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	54084	647	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15586160	15586160	PRJNA1129273_P_NODE_10693_length_241_cov_2.071429_g10413_i0	PRJNA1129273	10693	241	2.071429	4.99214389	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	398	2.4199999999999995e-106	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g10413	i0	96.667	285.622406639004	240	6	99	2	2	240	869	631	Luteolibacter sp. SL250 chromosome	blastn	68835	398	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
15586185	15586185	PRJNA1129273_P_NODE_4773_length_326_cov_2.494071_g4493_i0	PRJNA1129273	4773	326	2.494071	8.13067146	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	553	6.889999999999998e-153	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g4493	i0	97.239	415.01226993865	326	9	100	0	1	326	3893614	3893939	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	135294	553	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16860421	16860421	PRJNA1129273_P_NODE_1814_length_600_cov_2.370019_g1545_i0	PRJNA1129273	1814	600	2.370019	14.220114	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	987	0	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g1545	i0	96.494	113.153333333333	599	18	99	3	1	598	2834017	2834613	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	67892	987	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
21960003	21960003	PRJNA1129273_P_NODE_10078_length_244_cov_0.912281_g9798_i0	PRJNA1129273	10078	244	0.912281	2.22596564	Pedosphaera parvula	1032527	Bacteria	Bacteria	268	2.01e-67	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g9798	i0	90.64	14.1516393442623	203	17	83	2	2	203	1433	1232	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	3453	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
21960011	21960011	PRJNA1129273_P_NODE_11058_length_229_cov_4.455128_g10778_i0	PRJNA1129273	11058	229	4.455128	10.20224312	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	409	1.0500000000000001e-109	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g10778	i0	99.119	108.938864628821	227	2	99	0	2	228	2558827	2559053	Lacunisphaera limnophila strain IG16b, complete genome	blastn	24947	409	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
23235599	23235599	PRJNA1129273_P_NODE_6479_length_280_cov_4.782609_g6199_i0	PRJNA1129273	6479	280	4.782609	13.3913052	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	470	6.01e-128	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g6199	i0	97.122	133.871428571429	278	8	99	0	2	279	2833781	2834058	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	37484	470	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
27734045	27734045	PRJNA1129273_P_NODE_7784_length_261_cov_2.218085_g7504_i0	PRJNA1129273	7784	261	2.218085	5.78920185	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	77	4.04e-14	NR	HYG84357.1	2499141	g7504	i0	55.1	0.896551724137931	78	33	89.7	1	258	25	204	279	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	234	77	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;