metadata: contig_metadata: 21 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Roizmaniibacteriota"

21 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Roizmaniibacteriota"

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
6769729	6769729	PRJNA340009_P_NODE_35166_length_212_cov_3.674847_g34859_i0	PRJNA340009	35166	212	3.674847	7.79067564	Bacteria	2	Bacteria	Bacteria	122	1.44e-31	NR	PIP63687.1	1974860	g34859	i0	96.7	2.58962264150943	61	2	86.3	0	6	188	320	380	PIP63687.1 MAG: F0F1 ATP synthase subunit beta, partial [Candidatus Roizmanbacteria bacterium CG22_combo_CG10-13_8_21_14_all_34_12]	diamond	549	122	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium CG22_combo_CG10-13_8_21_14_all_34_12
27611911	27611911	PRJNA340009_P_NODE_30124_length_226_cov_25.039548_g29817_i0	PRJNA340009	30124	226	25.039548	56.58937848	Candidatus Roizmanbacteria bacterium CG1	2282149	Bacteria	Bacteria	78.6	1.82e-15	NR	PJE63161.1	1974853	g29817	i0	57.4	0.902654867256637	68	29	90.3	0	215	12	88	155	PJE63161.1 MAG: hypothetical protein COU88_00995, partial [Candidatus Roizmanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_39_6]	diamond	204	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_39_6
28386742	28386742	PRJNA340009_P_NODE_25746_length_242_cov_8.875648_g25439_i0	PRJNA340009	25746	242	8.875648	21.47906816	Bacillati	1783272	Bacteria	Bacteria	62.8	3.65e-10	NR	KKP87225.1	1618479	g25439	i0	54.2	1.7603305785124	48	22	59.5	0	99	242	65	112	KKP87225.1 MAG: hypothetical protein UR89_C0004G0014 [Candidatus Roizmanbacteria bacterium GW2011_GWA2_35_8]	diamond	426	63.2	0.993670886075949	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium GW2011_GWA2_35_8
28386746	28386746	PRJNA340009_P_NODE_49366_length_184_cov_3.659259_g49059_i0	PRJNA340009	49366	184	3.659259	6.73303656	Bacteria	2	Bacteria	Bacteria	102	1.2099999999999999e-23	NR	QQS43302.1	2282149	g49059	i0	81.7	2.93478260869565	60	11	97.8	0	4	183	399	458	QQS43302.1 MAG: efflux RND transporter permease subunit [Candidatus Roizmanbacteria bacterium]	diamond	540	102	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
28653811	28653811	PRJNA340009_P_NODE_77227_length_161_cov_0.910714_g76920_i0	PRJNA340009	77227	161	0.910714	1.46624954	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	42.7	0.0105	NR	MBI4136940.1	2282149	g76920	i0	43.9	1.06211180124224	57	28	98.8	1	159	1	84	140	MBI4136940.1 FkbM family methyltransferase [Candidatus Roizmanbacteria bacterium]	diamond	171	42.7	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
28779912	28779912	PRJNA340009_P_NODE_58287_length_171_cov_4.090164_g57980_i0	PRJNA340009	58287	171	4.090164	6.99418044	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	92	5.3700000000000006e-21	NR	MCR4313300.1	2282149	g57980	i0	81.8	0.964912280701754	55	10	96.5	0	3	167	163	217	MCR4313300.1 pilus assembly PilX N-terminal domain-containing protein [Candidatus Roizmanbacteria bacterium]	diamond	165	92	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
28843015	28843015	PRJNA340009_P_NODE_38428_length_205_cov_1.108974_g38121_i0	PRJNA340009	38428	205	1.108974	2.2733967	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	67	6.24e-11	NR	MBI5122954.1	2282149	g38121	i0	53.7	0.980487804878049	67	31	98	0	4	204	243	309	MBI5122954.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	201	67	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
29032896	29032896	PRJNA340009_P_NODE_80488_length_152_cov_20.310680_g80181_i0	PRJNA340009	80488	152	20.31068	30.8722336	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	45.1	0.00151	NR	MBI4008659.1	2282149	g80181	i0	56.3	0.631578947368421	32	14	63.2	0	143	48	16	47	MBI4008659.1 lamin tail domain-containing protein [Candidatus Roizmanbacteria bacterium]	diamond	96	45.1	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
29222283	29222283	PRJNA340009_P_NODE_71509_length_163_cov_0.894737_g71202_i0	PRJNA340009	71509	163	0.894737	1.45842131	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	90.9	5.37e-20	NR	MEI6532437.1	2282149	g71202	i0	79.6	0.993865030674847	54	11	99.4	0	1	162	278	331	MEI6532437.1 ketol-acid reductoisomerase [Candidatus Roizmanbacteria bacterium]	diamond	162	90.9	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
29348500	29348500	PRJNA340009_P_NODE_67729_length_165_cov_0.879310_g67422_i0	PRJNA340009	67729	165	0.87931	1.4508615	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	68.9	7.3e-12	NR	MBI4137000.1	2282149	g67422	i0	75	2.58181818181818	44	11	80	0	30	161	1	44	MBI4137000.1 LysM peptidoglycan-binding domain-containing protein [Candidatus Roizmanbacteria bacterium]	diamond	426	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
29821710	29821710	PRJNA340009_P_NODE_27791_length_234_cov_5.281081_g27484_i0	PRJNA340009	27791	234	5.281081	12.35772954	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_	2282149	Bacteria	Bacteria	118	5.63e-30	NR	OGK24089.1	1802039	g27484	i0	73.3	1.94871794871795	75	20	96.2	0	232	8	55	129	OGK24089.1 MAG: hypothetical protein A3C25_05250 [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_02_FULL_38_11]	diamond	456	118	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_02_FULL_38_11
30011673	30011673	PRJNA340009_P_NODE_58431_length_171_cov_2.393443_g58124_i0	PRJNA340009	58431	171	2.393443	4.09278753	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	57	1.29e-7	NR	MBI3620163.1	2282149	g58124	i0	60.4	0.929824561403509	53	21	93	0	163	5	881	933	MBI3620163.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	159	57	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
30137530	30137530	PRJNA340009_P_NODE_53152_length_178_cov_10.891473_g52845_i0	PRJNA340009	53152	178	10.891473	19.38682194	Candidatus Roizmanbacteria bacterium CG23_combo_of_CG	2282149	Bacteria	Bacteria	55.8	1.83e-7	NR	PIP15340.1	1974863	g52845	i0	63.2	0.640449438202247	38	14	64	0	9	122	139	176	PIP15340.1 MAG: phosphoribosyltransferase [Candidatus Roizmanbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_35_49]	diamond	114	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium CG23_combo_of_CG06-09_8_20_14_all_35_49
30611672	30611672	PRJNA340009_P_NODE_37093_length_207_cov_17.158228_g36786_i0	PRJNA340009	37093	207	17.158228	35.51753196	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	98.6	2.4e-22	NR	NMB83829.1	2282149	g36786	i0	70.6	0.985507246376812	68	18	98.6	1	3	206	10	75	NMB83829.1 S41 family peptidase [Candidatus Roizmanbacteria bacterium]	diamond	204	98.6	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
31085784	31085784	PRJNA340009_P_NODE_26355_length_240_cov_2.209424_g26048_i0	PRJNA340009	26355	240	2.209424	5.3026176	Candidatus Roizmanbacteria bacterium CG_4_1	2282149	Bacteria	Bacteria	105	4.77e-25	NR	PIZ61681.1	1974825	g26048	i0	63.3	1.9625	79	28	97.5	1	240	7	74	152	PIZ61681.1 MAG: hypothetical protein COY16_06255 [Candidatus Roizmanbacteria bacterium CG_4_10_14_0_2_um_filter_39_13]	diamond	471	105	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium CG_4_10_14_0_2_um_filter_39_13
31102864	31102864	PRJNA340009_P_NODE_80915_length_151_cov_7.843137_g80608_i0	PRJNA340009	80915	151	7.843137	11.84313687	Bacteria	2	Bacteria	Bacteria	72.8	5.75e-14	NR	OGK42629.1	1802055	g80608	i0	73.2	1.66887417218543	41	11	81.5	0	128	6	63	103	OGK42629.1 MAG: hypothetical protein A3A74_06360 [Candidatus Roizmanbacteria bacterium RIFCSPLOWO2_01_FULL_35_13]	diamond	252	73.2	0.994535519125683	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium RIFCSPLOWO2_01_FULL_35_13
31165885	31165885	PRJNA340009_P_NODE_59635_length_169_cov_28.450000_g59328_i0	PRJNA340009	59635	169	28.45	48.0805	Bacteria	2	Bacteria	Bacteria	65.1	1.8e-10	NR	PIZ65546.1	1974824	g59328	i0	65.4	1.82840236686391	52	18	92.3	0	168	13	200	251	PIZ65546.1 MAG: hypothetical protein COY15_03030 [Candidatus Roizmanbacteria bacterium CG_4_10_14_0_2_um_filter_39_12]	diamond	309	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium CG_4_10_14_0_2_um_filter_39_12
31324208	31324208	PRJNA340009_P_NODE_36255_length_209_cov_18.506250_g35948_i0	PRJNA340009	36255	209	18.50625	38.6780625	Bacteria	2	Bacteria	Bacteria	75.9	2.22e-14	NR	OGK13082.1	1802027	g35948	i0	60.7	3.90430622009569	56	22	80.4	0	5	172	101	156	OGK13082.1 MAG: hypothetical protein A2859_01215 [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_37_16b]	diamond	816	76.6	0.990861618798956	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_37_16b
31925206	31925206	PRJNA340009_P_NODE_72717_length_162_cov_6.787611_g72410_i0	PRJNA340009	72717	162	6.787611	10.99592982	Bacteria	2	Bacteria	Bacteria	67.8	1.37e-11	NR	MBI2640987.1	2282149	g72410	i0	68	1.7962962962963	50	15	92.6	1	12	161	17	65	MBI2640987.1 diphosphomevalonate decarboxylase [Candidatus Roizmanbacteria bacterium]	diamond	291	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
31988466	31988466	PRJNA340009_P_NODE_60398_length_168_cov_11.899160_g60091_i0	PRJNA340009	60398	168	11.89916	19.9905888	Pseudomonadati	3379134	Bacteria	Bacteria	62.4	1.48e-9	NR	OGK18149.1	1802034	g60091	i0	70.7	3.5	41	12	73.2	0	39	161	130	170	OGK18149.1 MAG: 5-(carboxyamino)imidazole ribonucleotide synthase [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_40_98]	diamond	588	62.4	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_40_98
32761314	32761314	PRJNA340009_P_NODE_27760_length_234_cov_18.778378_g27453_i0	PRJNA340009	27760	234	18.778378	43.94140452	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	72	1.56e-12	NR	MBI5123701.1	2282149	g27453	i0	60.3	0.743589743589744	58	23	74.4	0	185	12	249	306	MBI5123701.1 DNA mismatch repair endonuclease MutL [Candidatus Roizmanbacteria bacterium]	diamond	174	72	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria 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);;