metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Roizmaniibacteriota"

15 rows where analysis = "blastn", bioproject = "PRJNA630162" 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
601483	601483	PRJNA630162_P_NODE_117101_length_176_cov_1.385827_g115578_i0	PRJNA630162	117101	176	1.385827	2.43905552	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	104	4.04e-18	NTclustered	gi\|1950818454\|gb\|CP066689.1\|	2282149	g115578	i0	85.294	0.579545454545455	102	14	58	1	67	168	632714	632614	MAG: Candidatus Roizmanbacteria bacterium isolate NC_groundwater_538_Ag_S-0.1um_35_236 chromosome	blastn	102	104	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
602622	602622	PRJNA630162_P_NODE_78681_length_203_cov_1.285714_g77158_i0	PRJNA630162	78681	203	1.285714	2.60999942	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	263	7.51e-66	NTclustered	gi\|1950818454\|gb\|CP066689.1\|	2282149	g77158	i0	93.296	0.881773399014778	179	11	88	1	12	190	633715	633538	MAG: Candidatus Roizmanbacteria bacterium isolate NC_groundwater_538_Ag_S-0.1um_35_236 chromosome	blastn	179	263	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
602693	602693	PRJNA630162_P_NODE_85821_length_195_cov_2.232877_g84298_i0	PRJNA630162	85821	195	2.232877	4.35411015	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	130	7.57e-26	NTclustered	gi\|1958097300\|gb\|CP065004.1\|	2282149	g84298	i0	91.489	0.769230769230769	94	8	48	0	70	163	1104192	1104099	MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome	blastn	150	130	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
1878282	1878282	PRJNA630162_P_NODE_28642_length_339_cov_3.362069_g27120_i0	PRJNA630162	28642	339	3.362069	11.39741391	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	588	1.97e-163	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g27120	i0	98.792	49.4601769911504	331	3	98	1	1	331	409608	409937	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	16767	588	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
5705540	5705540	PRJNA630162_P_NODE_165545_length_158_cov_4.137615_g164022_i0	PRJNA630162	165545	158	4.137615	6.5374317	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	100	4.6e-17	NTclustered	gi\|1958097300\|gb\|CP065004.1\|	2282149	g164022	i0	81.538	0.822784810126582	130	16	80	7	1	126	1104148	1104273	MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome	blastn	130	100	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
6979938	6979938	PRJNA630162_P_NODE_113806_length_177_cov_5.523438_g112283_i0	PRJNA630162	113806	177	5.523438	9.77648526	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	100	5.27e-17	NTclustered	gi\|1950818454\|gb\|CP066689.1\|	2282149	g112283	i0	78.71	0.875706214689266	155	29	86	4	21	173	631519	631671	MAG: Candidatus Roizmanbacteria bacterium isolate NC_groundwater_538_Ag_S-0.1um_35_236 chromosome	blastn	155	100	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
8255380	8255380	PRJNA630162_P_NODE_36647_length_295_cov_3.410569_g35124_i0	PRJNA630162	36647	295	3.410569	10.06117855	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	326	1.46e-84	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g35124	i0	90.119	32.6440677966102	253	21	85	4	33	283	408042	407792	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	9630	326	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
15904531	15904531	PRJNA630162_P_NODE_133593_length_168_cov_2.630252_g132070_i0	PRJNA630162	133593	168	2.630252	4.41882336	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	296	5.91e-76	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g132070	i0	99.387	13.5654761904762	163	1	97	0	1	163	409422	409584	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	2279	296	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
15905416	15905416	PRJNA630162_P_NODE_67213_length_216_cov_1.215569_g65690_i0	PRJNA630162	67213	216	1.215569	2.62562904	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	388	1.28e-103	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g65690	i0	100	1.92592592592593	210	0	97	0	2	211	408245	408454	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	416	388	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
21004568	21004568	PRJNA630162_P_NODE_29237_length_335_cov_2.367133_g27715_i0	PRJNA630162	29237	335	2.367133	7.92989555	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	289	2.2099999999999996e-73	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g27715	i0	84.244	81.4776119402985	311	33	91	13	19	323	409054	409354	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	27295	289	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
22279399	22279399	PRJNA630162_P_NODE_40038_length_281_cov_2.349138_g38515_i0	PRJNA630162	40038	281	2.349138	6.60107778	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	121	7.000000000000001e-23	NTclustered	gi\|1958097300\|gb\|CP065004.1\|	2282149	g38515	i0	75.984	167.370106761566	254	50	87	7	32	276	1105665	1105916	MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome	blastn	47031	121	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
22279734	22279734	PRJNA630162_P_NODE_73618_length_209_cov_4.368750_g72095_i0	PRJNA630162	73618	209	4.36875	9.1306875	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	381	2.0599999999999996e-101	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g72095	i0	99.522	59.4401913875598	209	1	100	0	1	209	408875	408667	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	12423	381	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
23554472	23554472	PRJNA630162_P_NODE_160399_length_162_cov_0.920354_g158876_i0	PRJNA630162	160399	162	0.920354	1.49097348	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	167	4.609999999999999e-37	NTclustered	gi\|1958097300\|gb\|CP065004.1\|	2282149	g158876	i0	86.364	1.90123456790123	154	20	94	1	1	153	1103539	1103692	MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome	blastn	308	167	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
24827521	24827521	PRJNA630162_P_NODE_100420_length_185_cov_2.257353_g98897_i0	PRJNA630162	100420	185	2.257353	4.17610305	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	167	5.41e-37	NTclustered	gi\|1958097300\|gb\|CP065004.1\|	2282149	g98897	i0	83.333	195.410810810811	186	26	99	5	3	185	1105498	1105681	MAG: Candidatus Roizmanbacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.194_uni chromosome, complete genome	blastn	36151	167	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
24827829	24827829	PRJNA630162_P_NODE_130180_length_169_cov_2.116667_g128657_i0	PRJNA630162	130180	169	2.116667	3.57716723	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	195	2.22e-45	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g128657	i0	89.172	2.76331360946746	157	16	93	1	2	158	408156	408311	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	467	195	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);;