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

11 rows where analysis = "blastn", bioproject = "PRJNA982106" and tax_phylum = "Planctomycetota"

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
963903	963903	PRJNA982106_P_NODE_26901_length_246_cov_0.890173_g26661_i0	PRJNA982106	26901	246	0.890173	2.18982558	Urbifossiella limnaea	2528023	Bacteria	Bacteria	281	2.6000000000000007e-71	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g26661	i0	87.449	1.00406504065041	247	27	99	4	2	246	324211	324455	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	247	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
2239160	2239160	PRJNA982106_P_NODE_23782_length_248_cov_1.320000_g23542_i0	PRJNA982106	23782	248	1.32	3.2736	Urbifossiella limnaea	2528023	Bacteria	Bacteria	215	2.7e-51	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g23542	i0	82.52	33.6290322580645	246	41	99	2	3	247	3318445	3318689	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	8340	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
8616699	8616699	PRJNA982106_P_NODE_16887_length_272_cov_1.371859_g16647_i0	PRJNA982106	16887	272	1.371859	3.73145648	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g16647	i0	100	1	272	0	100	0	1	272	53800	54071	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	272	503	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
8617021	8617021	PRJNA982106_P_NODE_32767_length_241_cov_0.916667_g32527_i0	PRJNA982106	32767	241	0.916667	2.20916747	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	156	1.6100000000000002e-33	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g32527	i0	80.808	25.8630705394191	198	38	82	0	3	200	6860752	6860555	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	6233	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11167036	11167036	PRJNA982106_P_NODE_14129_length_290_cov_1.239631_g13889_i0	PRJNA982106	14129	290	1.239631	3.5949299	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	315	3.1e-81	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g13889	i0	87.455	25.6103448275862	279	28	95	6	5	280	2271838	2271564	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	7427	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
11167202	11167202	PRJNA982106_P_NODE_23209_length_249_cov_0.875000_g22969_i0	PRJNA982106	23209	249	0.875	2.17875	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	278	3.42e-70	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g22969	i0	86.747	1	249	33	100	0	1	249	9667881	9668129	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	249	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
14991604	14991604	PRJNA982106_P_NODE_15032_length_284_cov_1.843602_g14792_i0	PRJNA982106	15032	284	1.843602	5.23582968	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	100	9.23e-17	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g14792	i0	88.889	0.669014084507042	81	9	29	0	15	95	1245404	1245484	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	190	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
15298755	15298755	PRJNA982106_P_NODE_14572_length_287_cov_1.439252_g14332_i0	PRJNA982106	14572	287	1.439252	4.13065324	Urbifossiella	2807415	Bacteria	Bacteria	231	3.1799999999999997e-56	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g14332	i0	82.642	5.12891986062718	265	42	92	4	9	271	6628017	6627755	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1472	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22641003	22641003	PRJNA982106_P_NODE_27438_length_245_cov_0.895349_g27198_i0	PRJNA982106	27438	245	0.895349	2.19360505	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	69.4	2.2e-7	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g27198	i0	95.349	0.175510204081633	43	2	18	0	1	43	2885041	2884999	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	43	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23916388	23916388	PRJNA982106_P_NODE_18679_length_261_cov_1.281915_g18439_i0	PRJNA982106	18679	261	1.281915	3.34579815	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	113	1.08e-20	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g18439	i0	91.463	8.51724137931035	82	7	31	0	1	82	2001688	2001607	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	2223	113	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
25189987	25189987	PRJNA982106_P_NODE_20840_length_251_cov_0.865169_g20600_i0	PRJNA982106	20840	251	0.865169	2.17157419	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	171	6.02e-38	NTclustered	gi\|2258877542\|gb\|CP060234.1\|	2026777	g20600	i0	86.538	0.621513944223108	156	20	62	1	22	177	662664	662510	MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome	blastn	156	171	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;