metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1188114" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1188114" and tax_clade = "PVC group"

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
1594687	1594687	PRJNA1188114_P_NODE_18402_length_162_cov_0.902655_g18350_i0	PRJNA1188114	18402	162	0.902655	1.4623011	Paludisphaera borealis	1387353	Bacteria	Bacteria	150	4.65e-32	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g18350	i0	83.436	21.5555555555556	163	25	100	2	1	162	2034338	2034177	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	3492	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
4146943	4146943	PRJNA1188114_P_NODE_3084_length_248_cov_1.437186_g3032_i0	PRJNA1188114	3084	248	1.437186	3.56422128	Luteolibacter sp.	1962973	Bacteria	Bacteria	375	1.1699999999999999e-99	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g3032	i0	94.286	95.5524193548387	245	14	100	0	1	245	1010097	1010341	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	23697	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
6697902	6697902	PRJNA1188114_P_NODE_4046_length_221_cov_1.546512_g3994_i0	PRJNA1188114	4046	221	1.546512	3.41779152	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	283	6.379999999999999e-72	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g3994	i0	90.61	289.588235294118	213	20	96	0	9	221	1320575	1320363	Luteolibacter sp. Populi chromosome, complete genome	blastn	63999	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
7973243	7973243	PRJNA1188114_P_NODE_13807_length_166_cov_0.871795_g13755_i0	PRJNA1188114	13807	166	0.871795	1.4471797	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	124	2.9e-24	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g13755	i0	94.937	2.9578313253012	79	4	48	0	88	166	1970632	1970554	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	491	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7973299	7973299	PRJNA1188114_P_NODE_2027_length_301_cov_1.214286_g1975_i0	PRJNA1188114	2027	301	1.214286	3.65500086	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	488	1.7999999999999998e-133	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g1975	i0	96.013	286.116279069767	301	10	100	2	1	301	3411428	3411726	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	86121	488	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
14348996	14348996	PRJNA1188114_P_NODE_1332_length_371_cov_1.835404_g1280_i0	PRJNA1188114	1332	371	1.835404	6.80934884	Chthoniobacter flavus	191863	Bacteria	Bacteria	518	2.89e-142	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g1280	i0	92.758	249.525606469003	359	24	96	2	1	358	2465	2108	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	92574	518	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
14349032	14349032	PRJNA1188114_P_NODE_17632_length_162_cov_2.530973_g17580_i0	PRJNA1188114	17632	162	2.530973	4.10017626	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	113	6.1e-21	NTclustered	gi\|1712720622\|gb\|CP036427.1\|	2527974	g17580	i0	85.849	1.64814814814815	106	15	65	0	9	114	122633	122738	Tautonia plasticadhaerens strain ElP plasmid pElP_1, complete sequence	blastn	267	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
15622758	15622758	PRJNA1188114_P_NODE_17933_length_162_cov_0.902655_g17881_i0	PRJNA1188114	17933	162	0.902655	1.4623011	Urbifossiella limnaea	2528023	Bacteria	Bacteria	220	3.49e-53	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g17881	i0	91.304	7.37037037037037	161	14	99	0	1	161	6656581	6656741	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1194	220	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
15622788	15622788	PRJNA1188114_P_NODE_2333_length_280_cov_1.324675_g2281_i0	PRJNA1188114	2333	280	1.324675	3.70909	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	335	2.2899999999999993e-87	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g2281	i0	89.219	118.971428571429	269	27	96	2	12	280	3894741	3894475	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	33312	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21996659	21996659	PRJNA1188114_P_NODE_10778_length_172_cov_1.601626_g10726_i0	PRJNA1188114	10778	172	1.601626	2.75479672	Urbifossiella limnaea	2528023	Bacteria	Bacteria	115	1.81e-21	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g10726	i0	90	0.523255813953488	90	8	52	1	56	145	1120352	1120440	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	90	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24546114	24546114	PRJNA1188114_P_NODE_9960_length_175_cov_1.619048_g9908_i0	PRJNA1188114	9960	175	1.619048	2.833334	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	281	1.73e-71	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g9908	i0	97.006	44.0571428571429	167	5	95	0	1	167	4317534	4317368	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	7710	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae 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);;