metadata: contig_metadata: 18 rows where bioproject = "PRJEB3181", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJEB3181", 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
4816697	4816697	PRJEB3181_P_NODE_26584_length_155_cov_3.233871_g26319_i0	PRJEB3181	26584	155	3.233871	5.01250005	Pseudomonadati	3379134	Bacteria	Bacteria	111	2.07e-20	NTclustered	gi\|2080888260\|gb\|CP080649.1\|	2866311	g26319	i0	86.869	11.7935483870968	99	13	64	0	50	148	2334180	2334082	Ruficoccus sp. ZRK36 chromosome, complete genome	blastn	1828	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	Ruficoccus sp. ZRK36
5158314	5158314	PRJEB3181_P_NODE_27265_length_153_cov_2.401639_g27000_i0	PRJEB3181	27265	153	2.401639	3.67450767	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	213	5.43e-51	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g27000	i0	92.105	14.5882352941176	152	10	99	2	3	153	1316165	1316315	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	2232	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5158532	5158532	PRJEB3181_S_NODE_7025_length_235_cov_3.570000_g6732_i0	PRJEB3181	7025	235	3.57	8.3895	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	196	9.19e-46	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g6732	i0	82.667	6.69787234042553	225	35	95	4	5	227	5153513	5153735	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	1574	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10258860	10258860	PRJEB3181_S_NODE_2849_length_330_cov_11.569492_g2556_i0	PRJEB3181	2849	330	11.569492	38.1793236	Fontisphaera persica	2974023	Bacteria	Bacteria	254	7.93e-63	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g2556	i0	83.883	151.481818181818	273	36	81	7	1	267	3861306	3861036	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	49989	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
10258921	10258921	PRJEB3181_S_NODE_7569_length_227_cov_19.265625_g7276_i0	PRJEB3181	7569	227	19.265625	43.73296875	Fontisphaera persica	2974023	Bacteria	Bacteria	267	6.63e-67	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g7276	i0	87.931	196.449339207048	232	21	100	6	1	227	3861077	3861306	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	44594	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
11192165	11192165	PRJEB3181_P_NODE_15549_length_213_cov_1.593407_g15285_i0	PRJEB3181	15549	213	1.593407	3.39395691	Opitutus	178440	Bacteria	Bacteria	180	8.24e-41	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g15285	i0	85	5.69483568075117	180	24	84	3	19	196	1436	1258	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	1213	180	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
14084183	14084183	PRJEB3181_P_NODE_10632_length_260_cov_11.004367_g10368_i0	PRJEB3181	10632	260	11.004367	28.6113542	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	211	3.69e-50	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g10368	i0	84.332	246.796153846154	217	32	83	2	3	218	1729009	1729224	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	64167	211	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15016666	15016666	PRJEB3181_P_NODE_12692_length_237_cov_40.475728_g12428_i0	PRJEB3181	12692	237	40.475728	95.92747536	Opitutaceae	134623	Bacteria	Bacteria	364	2.4099999999999998e-96	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g12428	i0	95.217	111.793248945148	230	11	97	0	1	230	2556424	2556195	Lacunisphaera limnophila strain IG16b, complete genome	blastn	26495	366	0.994535519125683	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
16291509	16291509	PRJEB3181_P_NODE_21953_length_174_cov_2.146853_g21688_i0	PRJEB3181	21953	174	2.146853	3.73552422	root	1	Root_unresolved	Root_unresolved	228	2.2699999999999997e-55	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g21688	i0	92.994	266.965517241379	157	10	90	1	10	166	879	724	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	46452	230	0.991304347826087	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
16632828	16632828	PRJEB3181_P_NODE_19974_length_184_cov_1.718954_g19710_i0	PRJEB3181	19974	184	1.718954	3.16287536	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	324	3.01e-84	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g19710	i0	98.37	30.2282608695652	184	3	100	0	1	184	3557863	3558046	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	5562	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
17907524	17907524	PRJEB3181_P_NODE_14095_length_224_cov_20.564767_g13831_i0	PRJEB3181	14095	224	20.564767	46.06507808	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	254	5.08e-63	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g13831	i0	87.168	80.6830357142857	226	25	100	4	1	224	3833379	3833602	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	18073	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17907577	17907577	PRJEB3181_P_NODE_22575_length_171_cov_4.050000_g22310_i0	PRJEB3181	22575	171	4.05	6.9255	Opitutales bacterium	2026772	Bacteria	Bacteria	143	8.26e-30	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g22310	i0	88.525	17.8771929824561	122	8	70	6	1	119	1410121	1410239	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	3057	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
17907584	17907584	PRJEB3181_P_NODE_24355_length_163_cov_5.204545_g24090_i0	PRJEB3181	24355	163	5.204545	8.48340835	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	182	1.66e-41	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g24090	i0	92.248	415.337423312883	129	9	80	1	4	131	1729233	1729105	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	67700	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19181629	19181629	PRJEB3181_S_NODE_7916_length_223_cov_7.260638_g7623_i0	PRJEB3181	7916	223	7.260638	16.19122274	Opitutales bacterium	2026772	Bacteria	Bacteria	167	6.779999999999999e-37	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g7623	i0	82.412	30.7982062780269	199	27	87	8	24	218	1410112	1410306	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	6868	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
20456808	20456808	PRJEB3181_P_NODE_7697_length_303_cov_15.422794_g7435_i0	PRJEB3181	7697	303	15.422794	46.73106582	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	510	3.87e-140	NTclustered	gi\|2442650069\|gb\|OQ422736.1\|	156588	g7435	i0	99.642	90.3927392739274	279	1	92	0	25	303	907	629	Uncultured Verrucomicrobia bacterium clone KCM_4_1_112 16S ribosomal RNA gene, partial sequence	blastn	27389	510	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
23007928	23007928	PRJEB3181_P_NODE_11419_length_251_cov_4.604545_g11155_i0	PRJEB3181	11419	251	4.604545	11.55740795	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	117	7.95e-22	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g11155	i0	89.247	26.2589641434263	93	10	37	0	14	106	1904166	1904258	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	6591	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
23008178	23008178	PRJEB3181_S_NODE_4719_length_276_cov_55.253112_g4426_i0	PRJEB3181	4719	276	55.253112	152.49858912	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	268	2.3099999999999994e-67	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g4426	i0	87.879	79.1521739130435	231	24	83	4	4	232	3833597	3833369	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	21846	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
32246595	32246595	PRJEB3181_S_NODE_6178_length_248_cov_3.981221_g5885_i0	PRJEB3181	6178	248	3.981221	9.87342808	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	83.2	2.32e-16	NR	MBS0645922.1	2026799	g5885	i0	50.6	1.86290322580645	77	38	93.1	0	17	247	766	842	MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	462	83.2	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);;