metadata: contig_metadata: 19 rows where bioproject = "PRJNA826497" and tax

19 rows where bioproject = "PRJNA826497" and tax_phylum = "Candidatus Parcubacteria"

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_phylum	tax_species
26714593	26714593	PRJNA826497_S_NODE_8061_length_199_cov_4.222892_g8021_i0	PRJNA826497	8061	199	4.222892	8.40355508	Bacteria	2	Bacteria	Bacteria	127	8.51e-33	NR	KXJ99854.1	1617425	g8021	i0	84.6	6.84422110552764	65	10	98	0	3	197	220	284	KXJ99854.1 MAG: Methionine--tRNA ligase [Parcubacteria bacterium OLB19]	diamond	1362	128	0.9921875	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
27117464	27117464	PRJNA826497_S_NODE_18962_length_153_cov_3.116667_g18922_i0	PRJNA826497	18962	153	3.116667	4.76850051	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	68.9	6.1e-12	NR	MEY2665720.1	2762014	g18922	i0	70.7	2.41176470588235	41	12	80.4	0	1	123	322	362	MEY2665720.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	369	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
27821420	27821420	PRJNA826497_S_NODE_9104_length_192_cov_13.968553_g9064_i0	PRJNA826497	9104	192	13.968553	26.81962176	Bacteria	2	Bacteria	Bacteria	82	2.68e-16	NR	KXJ97862.1	1617425	g9064	i0	61.3	1.9375	62	24	96.9	0	186	1	70	131	KXJ97862.1 MAG: Flavohemoprotein [Parcubacteria bacterium OLB19]	diamond	372	82	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
27947580	27947580	PRJNA826497_S_NODE_15345_length_164_cov_2.152672_g15305_i0	PRJNA826497	15345	164	2.152672	3.53038208	Pseudomonadati	3379134	Bacteria	Bacteria	63.5	5.76e-10	NR	KXJ98320.1	1617425	g15305	i0	70.4	2.96341463414634	54	16	98.8	0	2	163	395	448	KXJ98320.1 MAG: ComEC family competence protein [Parcubacteria bacterium OLB19]	diamond	486	63.5	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
29431272	29431272	PRJNA826497_S_NODE_15249_length_164_cov_3.656489_g15209_i0	PRJNA826497	15249	164	3.656489	5.99664196	Bacteria	2	Bacteria	Bacteria	76.3	1.91e-14	NR	KXJ98984.1	1617425	g15209	i0	67.3	3.76829268292683	52	17	95.1	0	156	1	179	230	KXJ98984.1 MAG: Competence protein ComM [Parcubacteria bacterium OLB19]	diamond	618	76.3	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
29494663	29494663	PRJNA826497_S_NODE_1450_length_307_cov_30.711679_g1410_i0	PRJNA826497	1450	307	30.711679	94.28485453	Bacteria	2	Bacteria	Bacteria	101	2.38e-24	NR	KXJ97830.1	1617425	g1410	i0	70.1	5.0228013029316	77	23	75.2	0	20	250	4	80	KXJ97830.1 MAG: Zinc metalloprotease Rip1 [Parcubacteria bacterium OLB19]	diamond	1542	102	0.990196078431373	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
29652159	29652159	PRJNA826497_S_NODE_15630_length_163_cov_2.515385_g15590_i0	PRJNA826497	15630	163	2.515385	4.10007755	Bacteria	2	Bacteria	Bacteria	112	3.69e-28	NR	KXJ99865.1	1617425	g15590	i0	90.4	5.83435582822086	52	5	95.7	0	3	158	52	103	KXJ99865.1 MAG: Thymidylate synthase [Parcubacteria bacterium OLB19]	diamond	951	113	0.991150442477876	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
29706605	29706605	PRJNA826497_S_NODE_5470_length_222_cov_2.873016_g5430_i0	PRJNA826497	5470	222	2.873016	6.37809552	Parcubacteria bacterium C7867-	2762014	Bacteria	Bacteria	94.4	1.75e-22	NR	KND47103.1	1659198	g5430	i0	66.2	3.08108108108108	74	11	91.9	4	204	1	1	66	KND47103.1 MAG: hypothetical protein AB199_01585 [Parcubacteria bacterium C7867-004]	diamond	684	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium C7867-004
30402459	30402459	PRJNA826497_S_NODE_6493_length_212_cov_1.642458_g6453_i0	PRJNA826497	6493	212	1.642458	3.48201096	Parcubacteria bacterium OLB19	1617425	Bacteria	Bacteria	109	1.1199999999999999e-28	NR	KXJ98318.1	1617425	g6453	i0	77.3	2.80188679245283	66	15	93.4	0	13	210	1	66	KXJ98318.1 MAG: 14.7 kDa ribonuclease H-like protein [Parcubacteria bacterium OLB19]	diamond	594	109	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
30749583	30749583	PRJNA826497_S_NODE_11694_length_179_cov_1.267123_g11654_i0	PRJNA826497	11694	179	1.267123	2.26815017	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	79.3	6.46e-16	NR	MCK4554452.1	2762014	g11654	i0	70.2	0.787709497206704	47	14	78.8	0	39	179	80	126	MCK4554452.1 DUF4065 domain-containing protein [Candidatus Parcubacteria bacterium]	diamond	141	79.3	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
31042945	31042945	PRJNA826497_S_NODE_6035_length_216_cov_4.349727_g5995_i0	PRJNA826497	6035	216	4.349727	9.39541032	Bacteria	2	Bacteria	Bacteria	86.7	2.74e-20	NR	KXJ99824.1	1617425	g5995	i0	56.9	3	72	31	100	0	216	1	7	78	KXJ99824.1 MAG: D-inositol-3-phosphate glycosyltransferase [Parcubacteria bacterium OLB19]	diamond	648	86.7	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
31105622	31105622	PRJNA826497_S_NODE_9615_length_189_cov_7.467949_g9575_i0	PRJNA826497	9615	189	7.467949	14.11442361	Bacteria	2	Bacteria	Bacteria	103	1.24e-24	NR	KXK00070.1	1617425	g9575	i0	76.7	2.85714285714286	60	14	95.2	0	3	182	131	190	KXK00070.1 MAG: Lipid II flippase FtsW [Parcubacteria bacterium OLB19]	diamond	540	104	0.990384615384615	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
31128366	31128366	PRJNA826497_S_NODE_6195_length_214_cov_12.602210_g6155_i0	PRJNA826497	6195	214	12.60221	26.9687294	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	122	1.61e-30	NR	MFM2423819.1	2762014	g6155	i0	80.3	1.99065420560748	71	14	99.5	0	213	1	413	483	MFM2423819.1 hypothetical protein [Candidatus Parcubacteria bacterium]	diamond	426	122	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Candidatus Parcubacteria bacterium
31326998	31326998	PRJNA826497_S_NODE_13755_length_170_cov_2.145985_g13715_i0	PRJNA826497	13755	170	2.145985	3.6481745	Bacteria	2	Bacteria	Bacteria	113	2.11e-27	NR	KXK00181.1	1617425	g13715	i0	98.2	42.4941176470588	56	1	98.8	0	1	168	75	130	KXK00181.1 MAG: UvrABC system protein B [Parcubacteria bacterium OLB19]	diamond	7224	113	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
31444944	31444944	PRJNA826497_S_NODE_2756_length_263_cov_10.482609_g2716_i0	PRJNA826497	2756	263	10.482609	27.56926167	Parcubacteria bacterium OLB19	1617425	Bacteria	Bacteria	120	2.35e-31	NR	KXK00195.1	1617425	g2716	i0	61.6	1.69961977186312	86	33	98.1	0	261	4	12	97	KXK00195.1 MAG: hypothetical protein UZ19_OD1000110 [Parcubacteria bacterium OLB19]	diamond	447	120	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
31738057	31738057	PRJNA826497_S_NODE_11097_length_181_cov_5.074324_g11057_i0	PRJNA826497	11097	181	5.074324	9.18452644	Bacteria	2	Bacteria	Bacteria	115	1.03e-28	NR	KXJ98168.1	1617425	g11057	i0	88.3	4.97237569060773	60	7	99.4	0	2	181	101	160	KXJ98168.1 MAG: UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--L-lysine ligase [Parcubacteria bacterium OLB19]	diamond	900	116	0.991379310344828	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
31959640	31959640	PRJNA826497_S_NODE_8117_length_199_cov_2.409639_g8077_i0	PRJNA826497	8117	199	2.409639	4.79518161	Bacteria	2	Bacteria	Bacteria	62.8	3.43e-11	NR	KXK00225.1	1617425	g8077	i0	78.1	0.964824120603015	32	7	48.2	0	196	101	36	67	KXK00225.1 MAG: LexA repressor [Parcubacteria bacterium OLB19]	diamond	192	62.8	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
32308042	32308042	PRJNA826497_S_NODE_14799_length_166_cov_1.812030_g14759_i0	PRJNA826497	14799	166	1.81203	3.0079698	Bacteria	2	Bacteria	Bacteria	75.9	2.76e-14	NR	KXJ99774.1	1617425	g14759	i0	70.4	2.94578313253012	54	16	97.6	0	5	166	572	625	KXJ99774.1 MAG: O-Antigen ligase [Parcubacteria bacterium OLB19]	diamond	489	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19
32466155	32466155	PRJNA826497_S_NODE_2439_length_272_cov_3.648536_g2399_i0	PRJNA826497	2439	272	3.648536	9.92401792	Bacteria	2	Bacteria	Bacteria	167	5.66e-46	NR	KXJ98183.1	1617425	g2399	i0	86.7	4.96323529411765	90	12	99.3	0	271	2	39	128	KXJ98183.1 MAG: Penicillin-binding protein 2D [Parcubacteria bacterium OLB19]	diamond	1350	167	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria	Parcubacteria bacterium OLB19

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