metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1078753" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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
1467071	1467071	PRJNA1078753_P_NODE_17622_length_288_cov_2.548837_g17426_i0	PRJNA1078753	17622	288	2.548837	7.34065056	Tuwongella immobilis	692036	Bacteria	Bacteria	387	6.43e-103	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g17426	i0	90.941	142.006944444444	287	26	99	0	2	288	2738014	2737728	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	40898	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
3567657	3567657	PRJNA1078753_P_NODE_6143_length_430_cov_2.140056_g5947_i0	PRJNA1078753	6143	430	2.140056	9.2022408	Limnoglobus	2731450	Bacteria	Bacteria	291	8.08e-74	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5947	i0	79.505	16.7953488372093	444	63	100	24	1	430	2002113	2001684	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	7222	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4019165	4019165	PRJNA1078753_P_NODE_3584_length_537_cov_2.607759_g3390_i0	PRJNA1078753	3584	537	2.607759	14.00366583	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	745	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3390	i0	91.963	136.942271880819	535	37	99	5	7	537	7051359	7050827	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	73538	745	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5295305	5295305	PRJNA1078753_P_NODE_21025_length_274_cov_1.457711_g20829_i0	PRJNA1078753	21025	274	1.457711	3.99412814	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	374	4.7299999999999984e-99	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g20829	i0	91.273	225.828467153285	275	22	100	2	1	274	7051083	7050810	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	61877	374	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5295338	5295338	PRJNA1078753_P_NODE_25825_length_255_cov_1.390110_g25629_i0	PRJNA1078753	25825	255	1.39011	3.5447805	Limnoglobus roseus	2598579	Bacteria	Bacteria	159	1.33e-34	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g25629	i0	78.682	1.33333333333333	258	42	99	12	2	253	2337305	2337055	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	340	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
6570555	6570555	PRJNA1078753_P_NODE_38406_length_244_cov_0.900585_g38210_i0	PRJNA1078753	38406	244	0.900585	2.1974274	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	267	7.219999999999999e-67	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g38210	i0	89.573	19.0614754098361	211	20	86	2	1	210	6431224	6431433	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	4651	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
9120312	9120312	PRJNA1078753_P_NODE_44028_length_235_cov_4.617284_g43832_i0	PRJNA1078753	44028	235	4.617284	10.8506174	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	333	6.719999999999999e-87	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g43832	i0	92.373	205.782978723404	236	15	100	3	1	235	7053205	7053438	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	48359	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11671203	11671203	PRJNA1078753_P_NODE_2370_length_645_cov_3.246503_g2181_i0	PRJNA1078753	2370	645	3.246503	20.93994435	Tuwongella immobilis	692036	Bacteria	Bacteria	769	0	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g2181	i0	88.415	88.2961240310077	656	52	100	21	1	645	2736328	2736970	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	56951	769	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
12946208	12946208	PRJNA1078753_P_NODE_13331_length_320_cov_2.408907_g13135_i0	PRJNA1078753	13331	320	2.408907	7.7085024	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	440	5.479999999999999e-119	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g13135	i0	91.385	175.0875	325	23	100	3	1	320	2004393	2004069	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	56028	440	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16769393	16769393	PRJNA1078753_P_NODE_10914_length_345_cov_1.110294_g10718_i0	PRJNA1078753	10914	345	1.110294	3.8305143	Anaerohalosphaeraceae bacterium	2873829	Bacteria	Bacteria	63.9	1.51e-5	NTclustered	gi\|2621717560\|emb\|OY775912.1\|	2873829	g10718	i0	88.462	0.695652173913043	52	6	15	0	132	183	1661263	1661212	MAG: Anaerohalosphaeraceae bacterium isolate 978f9c3d-91dc-4e11-95ec-8fa255ba7f00 genome assembly, chromosome: 1	blastn	240	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae		Anaerohalosphaeraceae bacterium
20143313	20143313	PRJNA1078753_P_NODE_2996_length_580_cov_4.992110_g2804_i0	PRJNA1078753	2996	580	4.99211	28.954238	Gemmata	113	Bacteria	Bacteria	652	0	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g2804	i0	87.329	157.363793103448	584	57	100	14	1	580	2941787	2942357	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	91271	654	0.996941896024465	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
21869387	21869387	PRJNA1078753_P_NODE_3278_length_557_cov_4.634298_g3085_i0	PRJNA1078753	3278	557	4.634298	25.81303986	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	627	7.169999999999999e-175	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g3085	i0	86.972	221.526032315978	568	61	100	11	1	557	7050256	7050821	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	123390	627	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24418388	24418388	PRJNA1078753_P_NODE_19740_length_279_cov_2.004854_g19544_i0	PRJNA1078753	19740	279	2.004854	5.59354266	uncultured Planctomycetia bacterium	411917	Bacteria	Bacteria	499	7.63e-137	NTclustered	gi\|162137840\|gb\|EU298668.1\|	411917	g19544	i0	98.925	100.010752688172	279	3	100	0	1	279	565	287	Uncultured Planctomycetacia bacterium clone GASP-KB3S2_G09 16S ribosomal RNA gene, partial sequence	blastn	27903	499	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				uncultured Planctomycetia 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);;