metadata: contig_metadata: 15 rows where bioproject = "PRJNA807347" and tax

15 rows where bioproject = "PRJNA807347" 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
11010150	11010150	PRJNA807347_P_NODE_15369_length_245_cov_0.906977_g15266_i0	PRJNA807347	15369	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	61.2	1.16e-8	NR	MDZ4818058.1	2026780	g15266	i0	63.3	1.48163265306122	49	18	60	0	3	149	744	792	MDZ4818058.1 ribonuclease R [Planctomycetota bacterium]	diamond	363	61.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
13976398	13976398	PRJNA807347_P_NODE_16991_length_242_cov_0.923077_g16888_i0	PRJNA807347	16991	242	0.923077	2.23384634	Planctomycetota bacterium	2026780	Bacteria	Bacteria	87.8	6.55e-20	NR	RMH30670.1	2026780	g16888	i0	60.8	1.83471074380165	74	25	91.7	1	222	1	1	70	RMH30670.1 MAG: CBS domain-containing protein [Planctomycetota bacterium]	diamond	444	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
16108746	16108746	PRJNA807347_P_NODE_17653_length_231_cov_2.246835_g17550_i0	PRJNA807347	17653	231	2.246835	5.19018885	Candidatus Brocadia pituitae	2608983	Bacteria	Bacteria	195	3.24e-45	NTclustered	gi\|1996211272\|dbj\|AP021856.1\|	2608983	g17550	i0	84.236	7.94372294372294	203	28	87	4	30	230	2794310	2794510	Candidatus Brocadia pituitae DNA, complete genome	blastn	1835	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Brocadia	Candidatus Brocadia pituitae
27568456	27568456	PRJNA807347_P_NODE_7704_length_295_cov_1.036036_g7601_i0	PRJNA807347	7704	295	1.036036	3.0563062	Pseudomonadati	3379134	Bacteria	Bacteria	101	1.9300000000000001e-22	NR	MCZ6573397.1	2026780	g7601	i0	52.6	2.96949152542373	97	46	98.6	0	1	291	363	459	MCZ6573397.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Planctomycetota bacterium]	diamond	876	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27906751	27906751	PRJNA807347_P_NODE_15865_length_244_cov_0.912281_g15762_i0	PRJNA807347	15865	244	0.912281	2.22596564	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	43.5	0.0187	NR	MBX3393132.1	2026777	g15762	i0	33.3	0.774590163934426	63	39	73.8	2	197	18	10	72	MBX3393132.1 hypothetical protein [Phycisphaeraceae bacterium]	diamond	189	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28231352	28231352	PRJNA807347_P_NODE_11826_length_252_cov_2.385475_g11723_i0	PRJNA807347	11826	252	2.385475	6.011397	Candidatus Brocadia	380240	Bacteria	Bacteria	149	1.6e-39	NR	WP_052564505.1	380240	g11723	i0	80	5.05952380952381	85	16	100	1	1	252	345	429	WP_052564505.1 MULTISPECIES: hypothetical protein [Candidatus Brocadia]	diamond	1275	150	0.993333333333333	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Brocadia
29517157	29517157	PRJNA807347_P_NODE_17290_length_241_cov_3.863095_g17187_i0	PRJNA807347	17290	241	3.863095	9.31005895	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	102	3.33e-23	NR	HMB03686.1	2691532	g17187	i0	74.3	2.75103734439834	70	16	87.1	1	30	239	413	480	HMB03686.1 cytochrome b N-terminal domain-containing protein [Isosphaeraceae bacterium]	diamond	663	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
29643251	29643251	PRJNA807347_P_NODE_13930_length_248_cov_0.885714_g13827_i0	PRJNA807347	13930	248	0.885714	2.19657072	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	87.8	5.51e-18	NR	MBL8870221.1	2026779	g13827	i0	57.3	0.991935483870968	82	35	99.2	0	246	1	692	773	MBL8870221.1 DUF1553 domain-containing protein [Planctomycetaceae bacterium]	diamond	246	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30780845	30780845	PRJNA807347_P_NODE_8634_length_282_cov_2.315789_g8531_i0	PRJNA807347	8634	282	2.315789	6.53052498	Gemmataceae bacterium	2052164	Bacteria	Bacteria	75.5	1.4e-14	NR	HEY7422863.1	2052164	g8531	i0	47.1	0.925531914893617	87	38	84	1	1	237	91	177	HEY7422863.1 serpin family protein [Gemmataceae bacterium]	diamond	261	75.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31002129	31002129	PRJNA807347_P_NODE_16314_length_243_cov_0.917647_g16211_i0	PRJNA807347	16314	243	0.917647	2.22988221	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	141	3.0699999999999997e-37	NR	MBL8874085.1	2026779	g16211	i0	81.3	0.987654320987654	80	15	98.8	0	241	2	24	103	MBL8874085.1 DEAD/DEAH box helicase family protein [Planctomycetaceae bacterium]	diamond	240	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31476392	31476392	PRJNA807347_P_NODE_12036_length_252_cov_0.871508_g11933_i0	PRJNA807347	12036	252	0.871508	2.19620016	Phycisphaera sp.	2030824	Bacteria	Bacteria	165	2.52e-45	NR	MBI1302998.1	2030824	g11933	i0	98.8	0.988095238095238	83	1	98.8	0	3	251	602	684	MBI1302998.1 hypothetical protein [Phycisphaera sp.]	diamond	249	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
31539644	31539644	PRJNA807347_P_NODE_14416_length_247_cov_0.890805_g14313_i0	PRJNA807347	14416	247	0.890805	2.20028835	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	146	7.12e-39	NR	MBL0870494.1	2052180	g14313	i0	98.6	0.862348178137652	71	1	86.2	0	247	35	613	683	MBL0870494.1 ShlB/FhaC/HecB family hemolysin secretion/activation protein [Phycisphaerales bacterium]	diamond	213	146	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31697663	31697663	PRJNA807347_P_NODE_8777_length_281_cov_0.889423_g8674_i0	PRJNA807347	8777	281	0.889423	2.49927863	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.2	0.0451	NR	MBI4614341.1	2026780	g8674	i0	33.8	0.725978647686833	68	39	69.4	2	50	244	21	85	MBI4614341.1 UPF0175 family protein [Planctomycetota bacterium]	diamond	204	41.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31887366	31887366	PRJNA807347_P_NODE_14517_length_247_cov_0.885057_g14414_i0	PRJNA807347	14517	247	0.885057	2.18609079	Gemmataceae bacterium	2052164	Bacteria	Bacteria	42.7	0.0352	NR	HKB40427.1	2052164	g14414	i0	36	1.08097165991903	89	45	93.5	3	245	15	78	166	HKB40427.1 methyltransferase domain-containing protein [Gemmataceae bacterium]	diamond	267	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32140669	32140669	PRJNA807347_P_NODE_16758_length_242_cov_1.781065_g16655_i0	PRJNA807347	16758	242	1.781065	4.3101773	Sedimentisphaera salicampi	1941349	Bacteria	Bacteria	57	3.32e-7	NR	WP_094759418.1	1941349	g16655	i0	68.4	1.88429752066116	38	12	47.1	0	145	32	318	355	WP_094759418.1 tryptophan synthase subunit beta [Sedimentisphaera salicampi]	diamond	456	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Sedimentisphaeraceae	Sedimentisphaera	Sedimentisphaera salicampi

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