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

18 rows where bioproject = "PRJNA1245487", 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
2901999	2901999	PRJNA1245487_P_NODE_23163_length_220_cov_5.897959_g22825_i0	PRJNA1245487	23163	220	5.897959	12.9755098	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	368	1.6999999999999997e-97	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g22825	i0	96.818	258.727272727273	220	7	100	0	1	220	4513	4294	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	56920	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2902020	2902020	PRJNA1245487_P_NODE_4423_length_596_cov_1.741874_g4093_i0	PRJNA1245487	4423	596	1.741874	10.38156904	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	870	0	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g4093	i0	93.132	281.511744966443	597	36	99	4	1	595	2905	3498	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	167781	870	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4178359	4178359	PRJNA1245487_P_NODE_20444_length_248_cov_0.891429_g20106_i0	PRJNA1245487	20444	248	0.891429	2.21074392	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	154	5.98e-33	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g20106	i0	80.383	7.19354838709677	209	35	83	6	43	248	3019067	3019272	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1784	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
4178362	4178362	PRJNA1245487_P_NODE_20584_length_247_cov_1.683908_g20246_i0	PRJNA1245487	20584	247	1.683908	4.15925276	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	248	2.65e-61	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g20246	i0	84.706	31.9595141700405	255	31	100	2	1	247	3047988	3047734	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	7894	248	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
4178369	4178369	PRJNA1245487_P_NODE_21324_length_244_cov_1.906433_g20986_i0	PRJNA1245487	21324	244	1.906433	4.65169652	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	414	2.44e-111	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g20986	i0	97.908	48.1967213114754	239	5	98	0	3	241	1224	1462	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	11760	414	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
4178386	4178386	PRJNA1245487_P_NODE_22664_length_233_cov_2.087500_g22326_i0	PRJNA1245487	22664	233	2.0875	4.863875	Chthoniobacter flavus	191863	Bacteria	Bacteria	329	8.6e-86	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g22326	i0	92.308	248.652360515021	234	14	99	4	1	232	1938	2169	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	57936	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
11829658	11829658	PRJNA1245487_P_NODE_13690_length_310_cov_1.185654_g13352_i0	PRJNA1245487	13690	310	1.185654	3.6755274	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	422	1.92e-113	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g13352	i0	91.29	59.7096774193548	310	25	99	2	1	309	1322	1630	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	18510	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
11829679	11829679	PRJNA1245487_P_NODE_15350_length_288_cov_2.316279_g15012_i0	PRJNA1245487	15350	288	2.316279	6.67088352	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	342	1.4099999999999996e-89	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g15012	i0	97.5	240.940972222222	200	5	69	0	89	288	1143	944	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	69391	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
14380172	14380172	PRJNA1245487_P_NODE_12772_length_324_cov_2.494024_g12434_i0	PRJNA1245487	12772	324	2.494024	8.08063776	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	372	2.06e-98	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g12434	i0	94.65	157.296296296296	243	7	74	5	1	240	4502	4741	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	50964	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
14380226	14380226	PRJNA1245487_P_NODE_17052_length_270_cov_2.472081_g16714_i0	PRJNA1245487	17052	270	2.472081	6.6746187	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	370	6.02e-98	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g16714	i0	94.561	305.02962962963	239	13	89	0	12	250	2749863	2749625	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	82358	370	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15654083	15654083	PRJNA1245487_P_NODE_16433_length_276_cov_2.034483_g16095_i0	PRJNA1245487	16433	276	2.034483	5.61517308	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	340	4.84e-89	NTclustered	gi\|1966854496\|gb\|CP068475.1\|	1903058	g16095	i0	88.889	128.445652173913	279	27	100	4	1	276	915004	915281	MAG: Candidatus Xiphinematobacter sp. isolate P21 chromosome, complete genome	blastn	35451	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
16928422	16928422	PRJNA1245487_P_NODE_6854_length_473_cov_1.915000_g6518_i0	PRJNA1245487	6854	473	1.915	9.05795	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	697	0	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g6518	i0	93.249	225.517970401691	474	30	100	2	1	473	2301	2773	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	106670	697	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18202876	18202876	PRJNA1245487_P_NODE_23575_length_199_cov_5.404762_g23237_i0	PRJNA1245487	23575	199	5.404762	10.75547638	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	281	2.02e-71	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g23237	i0	92.965	113.412060301508	199	5	100	5	1	199	2749170	2749359	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	22569	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19477176	19477176	PRJNA1245487_P_NODE_17216_length_269_cov_1.020408_g16878_i0	PRJNA1245487	17216	269	1.020408	2.74489752	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	455	1.6100000000000002e-123	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g16878	i0	97.048	123.795539033457	271	6	100	2	1	269	915652	915922	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	33301	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19477284	19477284	PRJNA1245487_P_NODE_5256_length_547_cov_2.194093_g4921_i0	PRJNA1245487	5256	547	2.194093	12.00168871	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	905	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g4921	i0	96.533	251.563071297989	548	18	100	1	1	547	740	193	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	137605	905	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22027777	22027777	PRJNA1245487_P_NODE_12918_length_322_cov_1.184739_g12580_i0	PRJNA1245487	12918	322	1.184739	3.81485958	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	466	9.11e-127	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g12580	i0	94.966	140.66149068323	298	13	92	2	27	322	1903479	1903776	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	45293	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
22027862	22027862	PRJNA1245487_P_NODE_19758_length_250_cov_2.163842_g19420_i0	PRJNA1245487	19758	250	2.163842	5.409605	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	339	1.55e-88	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g19420	i0	91.27	19.1	252	17	100	4	1	250	3894779	3894531	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	4775	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22027876	22027876	PRJNA1245487_P_NODE_21038_length_245_cov_3.168605_g20700_i0	PRJNA1245487	21038	245	3.168605	7.76308225	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	348	2.5200000000000005e-91	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g20700	i0	92.245	222.379591836735	245	19	100	0	1	245	3894728	3894484	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	54483	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;