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

13 rows where analysis = "blastn", bioproject = "PRJNA560932" 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
1820298	1820298	PRJNA560932_P_NODE_28482_length_336_cov_3.163498_g28126_i0	PRJNA560932	28482	336	3.163498	10.62935328	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	429	1.2499999999999996e-115	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g28126	i0	91.693	101.889880952381	313	20	91	6	1	307	7051352	7051664	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	34235	429	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1820432	1820432	PRJNA560932_P_NODE_45722_length_270_cov_1.563452_g45366_i0	PRJNA560932	45722	270	1.563452	4.2213204	Limnoglobus roseus	2598579	Bacteria	Bacteria	464	2.6799999999999994e-126	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g45366	i0	97.77	120.1	269	6	99	0	2	270	2957388	2957120	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	32427	464	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
3095788	3095788	PRJNA560932_P_NODE_58803_length_247_cov_0.885057_g58447_i0	PRJNA560932	58803	247	0.885057	2.18609079	Urbifossiella limnaea	2528023	Bacteria	Bacteria	333	7.119999999999999e-87	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g58447	i0	91.463	184.064777327935	246	15	99	4	2	247	2019352	2019113	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	45464	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
6922734	6922734	PRJNA560932_P_NODE_46906_length_267_cov_1.051546_g46550_i0	PRJNA560932	46906	267	1.051546	2.80762782	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	377	3.55e-100	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g46550	i0	92.453	147.101123595506	265	18	99	2	4	267	2002000	2002263	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	39276	377	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7508535	7508535	PRJNA560932_P_NODE_56166_length_248_cov_1.360000_g55810_i0	PRJNA560932	56166	248	1.36	3.3728	Schlesneria	656899	Bacteria	Bacteria	342	1.1899999999999999e-89	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g55810	i0	93.833	74.1290322580645	227	14	92	0	22	248	6998680	6998906	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	18384	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
8197764	8197764	PRJNA560932_P_NODE_60147_length_246_cov_0.890173_g59791_i0	PRJNA560932	60147	246	0.890173	2.18982558	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	174	4.55e-39	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g59791	i0	81.448	75.8211382113821	221	33	88	8	2	218	7914640	7914856	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	18652	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15847364	15847364	PRJNA560932_P_NODE_20193_length_392_cov_1.282132_g19837_i0	PRJNA560932	20193	392	1.282132	5.02595744	Limnoglobus roseus	2598579	Bacteria	Bacteria	597	3.8399999999999987e-166	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g19837	i0	94.148	82.0663265306122	393	21	100	2	1	392	2957430	2957821	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	32170	597	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
15847611	15847611	PRJNA560932_P_NODE_47213_length_266_cov_1.015544_g46857_i0	PRJNA560932	47213	266	1.015544	2.70134704	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	263	1.03e-65	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g46857	i0	85.075	248.755639097744	268	28	98	9	3	264	4469542	4469281	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	66169	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
15847722	15847722	PRJNA560932_P_NODE_64033_length_243_cov_0.905882_g63677_i0	PRJNA560932	64033	243	0.905882	2.20129326	Caulifigura coniformis	2527983	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g63677	i0	100	0.123456790123457	30	0	12	0	97	126	1885941	1885970	Caulifigura coniformis strain Pan44 chromosome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
19671249	19671249	PRJNA560932_P_NODE_4896_length_772_cov_5.300429_g4570_i0	PRJNA560932	4896	772	5.300429	40.91931188	Poriferisphaera corsica	2528020	Bacteria	Bacteria	67.6	2.76e-6	NTclustered	gi\|1712598971\|gb\|CP036425.1\|	2528020	g4570	i0	93.333	0.0582901554404145	45	3	6	0	277	321	1032725	1032769	Poriferisphaera corsica strain KS4 chromosome, complete genome	blastn	45	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Poriferisphaera	Poriferisphaera corsica
22807705	22807705	PRJNA560932_P_NODE_52678_length_251_cov_0.865169_g52322_i0	PRJNA560932	52678	251	0.865169	2.17157419	Schlesneria	656899	Bacteria	Bacteria	370	5.53e-98	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g52322	i0	93.227	112.262948207171	251	17	100	0	1	251	2295	2045	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	28178	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
23497002	23497002	PRJNA560932_P_NODE_33299_length_314_cov_1.514523_g32943_i0	PRJNA560932	33299	314	1.514523	4.75560222	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	438	1.9299999999999998e-118	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g32943	i0	92.063	67.3757961783439	315	20	99	5	1	313	3722504	3722193	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	21156	438	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
24082515	24082515	PRJNA560932_P_NODE_6439_length_679_cov_4.054455_g6093_i0	PRJNA560932	6439	679	4.054455	27.52974945	Gemmata	113	Bacteria	Bacteria	1216	0	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g6093	i0	98.969	117.496318114875	679	7	100	0	1	679	1038039	1038717	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	79780	1216	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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