metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJEB12982" and tax

12 rows where analysis = "blastn", bioproject = "PRJEB12982" 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
20950	20950	PRJEB12982_P_NODE_16821_length_167_cov_0.864407_g16658_i0	PRJEB12982	16821	167	0.864407	1.44355969	Rohdeia mirabilis	2528008	Bacteria	Bacteria	259	7.69e-65	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g16658	i0	94.611	111.443113772455	167	9	100	0	1	167	3893050	3892884	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	18611	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
2570826	2570826	PRJEB12982_P_NODE_17983_length_166_cov_0.871795_g17820_i0	PRJEB12982	17983	166	0.871795	1.4471797	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	252	1.28e-62	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g17820	i0	93.976	346.765060240964	166	10	100	0	1	166	2190678	2190513	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	57563	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
3847093	3847093	PRJEB12982_P_NODE_13624_length_189_cov_1.457143_g13461_i0	PRJEB12982	13624	189	1.457143	2.75400027	Kolteria novifilia	2527975	Bacteria	Bacteria	289	1.14e-73	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g13461	i0	94.18	232.534391534392	189	11	100	0	1	189	1831496	1831684	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	43949	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
3847159	3847159	PRJEB12982_P_NODE_17884_length_166_cov_0.871795_g17721_i0	PRJEB12982	17884	166	0.871795	1.4471797	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	200	4.69e-47	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g17721	i0	88.554	4.85542168674699	166	18	100	1	1	166	3991817	3991981	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	806	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
6398993	6398993	PRJEB12982_P_NODE_12846_length_195_cov_4.150685_g12683_i0	PRJEB12982	12846	195	4.150685	8.09383575	Gemmataceae bacterium	2052164	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g12683	i0	94.872	118.035897435897	195	10	100	0	1	195	319164	319358	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	23017	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
6399184	6399184	PRJEB12982_P_NODE_5866_length_306_cov_1.175097_g5703_i0	PRJEB12982	5866	306	1.175097	3.59579682	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	388	1.92e-103	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g5703	i0	89.577	125.790849673203	307	31	100	1	1	306	1868629	1868935	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	38492	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
7673144	7673144	PRJEB12982_P_NODE_17427_length_166_cov_1.299145_g17264_i0	PRJEB12982	17427	166	1.299145	2.1565807	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	165	1.7100000000000002e-36	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g17264	i0	87.413	199.759036144578	143	18	86	0	5	147	3046308	3046450	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	33160	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
10223775	10223775	PRJEB12982_P_NODE_3949_length_383_cov_2.571856_g3786_i0	PRJEB12982	3949	383	2.571856	9.85020848	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	357	6.91e-94	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g3786	i0	83.721	226.480417754569	387	54	100	9	1	383	2163060	2163441	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	86742	357	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
12464821	12464821	PRJEB12982_P_NODE_17250_length_167_cov_0.864407_g17087_i0	PRJEB12982	17250	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	287	3.53e-73	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g17087	i0	97.605	219.904191616766	167	4	100	0	1	167	1868452	1868618	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	36724	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
16597694	16597694	PRJEB12982_P_NODE_14654_length_181_cov_1.916667_g14491_i0	PRJEB12982	14654	181	1.916667	3.46916727	Urbifossiella limnaea	2528023	Bacteria	Bacteria	274	3.0099999999999997e-69	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g14491	i0	93.923	74.2265193370166	181	11	100	0	1	181	2020229	2020049	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	13435	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19146563	19146563	PRJEB12982_P_NODE_7156_length_271_cov_2.067568_g6993_i0	PRJEB12982	7156	271	2.067568	5.60310928	Urbifossiella limnaea	2528023	Bacteria	Bacteria	451	2.0999999999999997e-122	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g6993	i0	96.679	100.656826568266	271	9	100	0	1	271	2019855	2019585	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	27278	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
21697586	21697586	PRJEB12982_P_NODE_13038_length_194_cov_1.213793_g12875_i0	PRJEB12982	13038	194	1.213793	2.35475842	Kolteria novifilia	2527975	Bacteria	Bacteria	244	2.57e-60	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g12875	i0	89.947	5.9639175257732	189	19	97	0	6	194	1830484	1830672	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	1157	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia

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);;