metadata: contig_metadata: 14 rows where bioproject = "PRJNA340009" and tax

14 rows where bioproject = "PRJNA340009" and tax_phylum = "Candidatus Liptoniibacteriota"

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
11871292	11871292	PRJNA340009_P_NODE_9770_length_365_cov_6.142405_g9463_i0	PRJNA340009	9770	365	6.142405	22.41977825	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	186	3.1999999999999995e-57	NR	MBI4085935.1	2528273	g9463	i0	78.5	0.994520547945206	121	18	99.5	1	365	3	101	213	MBI4085935.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Candidatus Liptonbacteria bacterium]	diamond	363	186	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
26726122	26726122	PRJNA340009_P_NODE_28041_length_233_cov_9.961957_g27734_i0	PRJNA340009	28041	233	9.961957	23.21135981	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	78.2	7.8e-15	NR	MBI4087265.1	2528273	g27734	i0	52.2	0.862660944206009	67	32	86.3	0	232	32	216	282	MBI4087265.1 hypothetical protein [Candidatus Liptonbacteria bacterium]	diamond	201	78.2	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
26902280	26902280	PRJNA340009_P_NODE_71861_length_163_cov_0.894737_g71554_i0	PRJNA340009	71861	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	100	8.66e-24	NR	MBI4085277.1	2528273	g71554	i0	79.2	2.94478527607362	53	11	97.5	0	162	4	233	285	MBI4085277.1 GDP-mannose 4,6-dehydratase [Candidatus Liptonbacteria bacterium]	diamond	480	101	0.99009900990099	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
26948044	26948044	PRJNA340009_P_NODE_56282_length_174_cov_1.632000_g55975_i0	PRJNA340009	56282	174	1.632	2.83968	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	97.8	2.0899999999999994e-23	NR	MBI3589302.1	2528273	g55975	i0	75.9	0.931034482758621	54	13	93.1	0	171	10	17	70	MBI3589302.1 helix-turn-helix domain-containing protein [Candidatus Liptonbacteria bacterium]	diamond	162	97.8	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
27611923	27611923	PRJNA340009_P_NODE_40784_length_199_cov_7.240000_g40477_i0	PRJNA340009	40784	199	7.24	14.4076	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	89.4	8e-19	NR	MDO8504499.1	2528273	g40477	i0	67.2	3.85929648241206	64	21	96.5	0	198	7	534	597	MDO8504499.1 threonine--tRNA ligase [Candidatus Liptonbacteria bacterium]	diamond	768	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
27675200	27675200	PRJNA340009_P_NODE_52804_length_179_cov_1.569231_g52497_i0	PRJNA340009	52804	179	1.569231	2.80892349	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	100	8.18e-24	NR	MBI2037153.1	2528273	g52497	i0	81.4	0.988826815642458	59	11	98.9	0	2	178	191	249	MBI2037153.1 NUDIX domain-containing protein [Candidatus Liptonbacteria bacterium]	diamond	177	100	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
29821727	29821727	PRJNA340009_P_NODE_42731_length_195_cov_44.301370_g42424_i0	PRJNA340009	42731	195	44.30137	86.3876715	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	92	7.12e-21	NR	MBM3256828.1	2528273	g42424	i0	85.1	0.723076923076923	47	7	72.3	0	184	44	200	246	MBM3256828.1 hypothetical protein [Candidatus Liptonbacteria bacterium]	diamond	141	92	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
30106207	30106207	PRJNA340009_P_NODE_49232_length_184_cov_18.844444_g48925_i0	PRJNA340009	49232	184	18.844444	34.67377696	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	47.8	2.43e-4	NR	MBI4085751.1	2528273	g48925	i0	48	2.0054347826087	50	19	81.5	1	172	23	29	71	MBI4085751.1 hypothetical protein [Candidatus Liptonbacteria bacterium]	diamond	369	47.8	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
30454120	30454120	PRJNA340009_P_NODE_69813_length_164_cov_0.886957_g69506_i0	PRJNA340009	69813	164	0.886957	1.45460948	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	75.1	7.12e-16	NR	MBM3257392.1	2528273	g69506	i0	71.7	3.8780487804878	53	15	97	0	6	164	24	76	MBM3257392.1 50S ribosomal protein L21 [Candidatus Liptonbacteria bacterium]	diamond	636	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
30643285	30643285	PRJNA340009_P_NODE_71053_length_163_cov_0.982456_g70746_i0	PRJNA340009	71053	163	0.982456	1.60140328	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	88.2	1.23e-18	NR	MBI2033665.1	2528273	g70746	i0	84.6	0.957055214723926	52	8	95.7	0	162	7	175	226	MBI2033665.1 ATP-dependent DNA helicase RecG [Candidatus Liptonbacteria bacterium]	diamond	156	88.2	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
31591866	31591866	PRJNA340009_P_NODE_11196_length_345_cov_4.902027_g10889_i0	PRJNA340009	11196	345	4.902027	16.91199315	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	135	1.42e-35	NR	MBI2035580.1	2528273	g10889	i0	60	1.8695652173913	105	42	91.3	0	334	20	262	366	MBI2035580.1 DNA polymerase III subunit gamma/tau [Candidatus Liptonbacteria bacterium]	diamond	645	135	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
31686489	31686489	PRJNA340009_P_NODE_65497_length_165_cov_87.965517_g65190_i0	PRJNA340009	65497	165	87.965517	145.14310305	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	72.8	2.78e-14	NR	MBI4094368.1	2528273	g65190	i0	70.2	1.70909090909091	47	14	85.5	0	2	142	119	165	MBI4094368.1 nucleotide exchange factor GrpE [Candidatus Liptonbacteria bacterium]	diamond	282	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
32066158	32066158	PRJNA340009_P_NODE_81298_length_150_cov_5.702970_g80991_i0	PRJNA340009	81298	150	5.70297	8.554455	Candidatus Liptonbacteria bacterium	2528273	Bacteria	Bacteria	45.4	1.66e-4	NR	MBI3588935.1	2528273	g80991	i0	84.6	0.52	26	4	52	0	79	2	1	26	MBI3588935.1 hypothetical protein [Candidatus Liptonbacteria bacterium]	diamond	78	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium
32887141	32887141	PRJNA340009_P_NODE_45640_length_190_cov_1.964539_g45333_i0	PRJNA340009	45640	190	1.964539	3.7326240999999998	Candidatus Liptonbacteria bacterium RIFCSPLOWO2_	2528273	Bacteria	Bacteria	92	3.11e-22	NR	OGY99253.1	1798650	g45333	i0	82	0.963157894736842	61	11	96.3	0	184	2	28	88	OGY99253.1 MAG: 50S ribosomal protein L18 [Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25]	diamond	183	92	1	Bacteria	Bacteria candidate phyla	Candidatus Liptoniibacteriota	Candidatus Liptonbacteria bacterium RIFCSPLOWO2_01_FULL_52_25

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