metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
746917	746917	PRJNA770826_P_NODE_38761_length_163_cov_1.780702_g38590_i0	PRJNA770826	38761	163	1.780702	2.90254426	Aquisphaera giovannonii	406548	Bacteria	Bacteria	111	2.21e-20	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g38590	i0	89.011	2.48466257668712	91	8	55	2	15	104	4832536	4832447	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	405	111	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
3298199	3298199	PRJNA770826_P_NODE_9403_length_264_cov_1.176744_g9232_i0	PRJNA770826	9403	264	1.176744	3.10660416	Roseimaritima multifibrata	1930274	Bacteria	Bacteria	329	9.95e-86	NTclustered	gi\|1712444166\|gb\|CP036262.1\|	1930274	g9232	i0	89.474	113.170454545455	266	21	99	4	2	264	5116475	5116214	Roseimaritima multifibrata strain FF011L chromosome, complete genome	blastn	29877	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima multifibrata
4575118	4575118	PRJNA770826_P_NODE_14424_length_212_cov_1.276074_g14253_i0	PRJNA770826	14424	212	1.276074	2.70527688	planctomycete str. 449	79870	Bacteria	Bacteria	315	2.15e-81	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g14253	i0	93.427	230.283018867925	213	12	100	2	1	212	747	536	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	48820	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
7125708	7125708	PRJNA770826_P_NODE_7446_length_301_cov_5.904762_g7275_i0	PRJNA770826	7446	301	5.904762	17.77333362	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	263	1.19e-65	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g7275	i0	83.39	99.734219269103	295	37	95	9	15	301	5364779	5364489	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	30020	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
8400135	8400135	PRJNA770826_P_NODE_36347_length_164_cov_0.904348_g36176_i0	PRJNA770826	36347	164	0.904348	1.48313072	Gimesia maris	122	Bacteria	Bacteria	58.4	2.94e-4	NTclustered	gi\|1712536321\|gb\|CP036341.1\|	122	g36176	i0	94.595	0.621951219512195	37	2	23	0	88	124	6786129	6786165	Gimesia maris strain Mal35 chromosome	blastn	102	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia maris
8859877	8859877	PRJNA770826_P_NODE_20127_length_180_cov_1.977099_g19956_i0	PRJNA770826	20127	180	1.977099	3.5587782	Schlesneria	656899	Bacteria	Bacteria	303	3.82e-78	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g19956	i0	97.207	106.844444444444	179	5	99	0	1	179	1837	1659	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	19232	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
10950959	10950959	PRJNA770826_P_NODE_20289_length_180_cov_1.015267_g20118_i0	PRJNA770826	20289	180	1.015267	1.8274806	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	267	5.009999999999999e-67	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g20118	i0	93.333	11.3055555555556	180	12	100	0	1	180	3095537	3095716	Pirellula sp. SH-Sr6A, complete genome	blastn	2035	267	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
12226515	12226515	PRJNA770826_P_NODE_10330_length_251_cov_1.029703_g10159_i0	PRJNA770826	10330	251	1.029703	2.58455453	Aureliella helgolandensis	2527968	Bacteria	Bacteria	281	2.66e-71	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g10159	i0	88.462	115.346613545817	234	25	93	2	1	233	6998871	6999103	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	28952	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
12686319	12686319	PRJNA770826_P_NODE_15430_length_206_cov_0.993631_g15259_i0	PRJNA770826	15430	206	0.993631	2.04687986	Schlesneria	656899	Bacteria	Bacteria	348	2.05e-91	NTclustered	gi\|2806767875\|gb\|CP124747.2\|	3044399	g15259	i0	97.087	100.179611650485	206	6	100	0	1	206	2140053	2140258	Schlesneria sp. DSM 10557 chromosome, complete genome	blastn	20637	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria sp. DSM 10557
14775771	14775771	PRJNA770826_P_NODE_21452_length_174_cov_2.080000_g21281_i0	PRJNA770826	21452	174	2.08	3.6192	Lignipirellula cremea	2528010	Bacteria	Bacteria	156	1.08e-33	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g21281	i0	82.857	169.045977011494	175	29	100	1	1	174	1143526	1143352	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	29414	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
17325208	17325208	PRJNA770826_P_NODE_19694_length_183_cov_1.022388_g19523_i0	PRJNA770826	19694	183	1.022388	1.87097004	Stieleria bergensis	2528025	Bacteria	Bacteria	237	4.01e-58	NTclustered	gi\|1712514661\|gb\|CP036272.1\|	2528025	g19523	i0	90.217	146.79781420765	184	14	100	4	1	183	5539785	5539965	Planctomycetes bacterium SV_7m_r chromosome	blastn	26864	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria bergensis
20333140	20333140	PRJNA770826_P_NODE_32216_length_166_cov_0.888889_g32045_i0	PRJNA770826	32216	166	0.888889	1.47555574	Schlesneria	656899	Bacteria	Bacteria	207	2.8e-49	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g32045	i0	89.634	64.2048192771084	164	16	99	1	3	166	1053	891	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	10658	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
22884436	22884436	PRJNA770826_P_NODE_5638_length_355_cov_2.232026_g5467_i0	PRJNA770826	5638	355	2.232026	7.9236923	Schlesneria	656899	Bacteria	Bacteria	483	1.0099999999999998e-131	NTclustered	gi\|12583970\|gb\|AF245374.1\|AF245374	149589	g5467	i0	91.738	44.5549295774648	351	23	99	3	5	355	252	596	Planctomycete str. 639 23S ribosomal RNA gene, partial sequence	blastn	15817	483	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 639
23699828	23699828	PRJNA770826_P_NODE_18399_length_189_cov_1.114286_g18228_i0	PRJNA770826	18399	189	1.114286	2.10600054	Lacipirellula parvula	2650471	Bacteria	Bacteria	209	9.09e-50	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g18228	i0	91.447	86	152	13	80	0	1	152	5162892	5162741	Lacipirellula parvula PX69 DNA, complete genome	blastn	16254	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula

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