metadata: contig_metadata: 11 rows where bioproject = "PRJNA340009", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Joergenseniibacteriota"

11 rows where bioproject = "PRJNA340009", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Joergenseniibacteriota"

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
26758055	26758055	PRJNA340009_P_NODE_21581_length_261_cov_3.122642_g21274_i0	PRJNA340009	21581	261	3.122642	8.15009562	Candidatus Jorgensenbacteria bacterium CG1	2268185	Bacteria	Bacteria	93.2	5.08e-22	NR	PIT91643.1	1974593	g21274	i0	81.1	1.75862068965517	53	10	60.9	0	1	159	86	138	PIT91643.1 MAG: hypothetical protein COU12_01995 [Candidatus Jorgensenbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_54_38]	diamond	459	93.2	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_54_38
27359337	27359337	PRJNA340009_P_NODE_28603_length_231_cov_49.747253_g28296_i0	PRJNA340009	28603	231	49.747253	114.91615443	Candidatus Jorgensenbacteria bacterium GW2	2268185	Bacteria	Bacteria	60.1	7.04e-9	NR	KKU91728.1	1618660	g28296	i0	46	1.55844155844156	63	31	81.8	1	38	226	38	97	KKU91728.1 MAG: PaaX family transcriptional regulator [Candidatus Jorgensenbacteria bacterium GW2011_GWA1_48_11]	diamond	360	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium GW2011_GWA1_48_11
27359341	27359341	PRJNA340009_P_NODE_33663_length_216_cov_3.467066_g33356_i0	PRJNA340009	33663	216	3.467066	7.48886256	Candidatus Jorgensenbacteria bacterium GW2	2268185	Bacteria	Bacteria	55.1	1.18e-7	NR	KKU91440.1	1618660	g33356	i0	56.6	0.736111111111111	53	21	73.6	1	1	159	43	93	KKU91440.1 MAG: hypothetical protein UY23_C0001G0046 [Candidatus Jorgensenbacteria bacterium GW2011_GWA1_48_11]	diamond	159	55.1	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium GW2011_GWA1_48_11
28937987	28937987	PRJNA340009_P_NODE_29288_length_229_cov_3.394444_g28981_i0	PRJNA340009	29288	229	3.394444	7.77327676	Candidatus Jorgensenbacteria bacterium	2268185	Bacteria	Bacteria	79	5.1e-16	NR	MCX6788625.1	2268185	g28981	i0	51.4	0.943231441048035	72	35	94.3	0	12	227	21	92	MCX6788625.1 dTMP kinase [Candidatus Jorgensenbacteria bacterium]	diamond	216	79	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium
29285070	29285070	PRJNA340009_P_NODE_56869_length_173_cov_2.709677_g56562_i0	PRJNA340009	56869	173	2.709677	4.68774121	Candidatus Jorgensenbacteria bacterium	2268185	Bacteria	Bacteria	48.5	6.52e-5	NR	MDP3974994.1	2268185	g56562	i0	44.7	0.815028901734104	47	26	81.5	0	2	142	112	158	MDP3974994.1 dihydrofolate reductase family protein [Candidatus Jorgensenbacteria bacterium]	diamond	141	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium
30060190	30060190	PRJNA340009_P_NODE_62531_length_167_cov_0.864407_g62224_i0	PRJNA340009	62531	167	0.864407	1.44355969	Bacteria	2	Bacteria	Bacteria	91.3	6.79e-20	NR	OGG42953.1	1798473	g62224	i0	81.8	4.8502994011976	55	10	98.8	0	2	166	7	61	OGG42953.1 MAG: hypothetical protein A3G50_00235 [Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_12_FULL_42_11]	diamond	810	91.3	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_12_FULL_42_11
30485526	30485526	PRJNA340009_P_NODE_77393_length_161_cov_0.910714_g77086_i0	PRJNA340009	77393	161	0.910714	1.46624954	Candidatus Jorgensenbacteria bacterium	2268185	Bacteria	Bacteria	63.5	5.45e-10	NR	MDP3975226.1	2268185	g77086	i0	86.1	1.3416149068323	36	5	67.1	0	2	109	380	415	MDP3975226.1 serine--tRNA ligase [Candidatus Jorgensenbacteria bacterium]	diamond	216	63.5	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium
30643269	30643269	PRJNA340009_P_NODE_51233_length_181_cov_6.075758_g50926_i0	PRJNA340009	51233	181	6.075758	10.99712198	Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_	2268185	Bacteria	Bacteria	74.7	8.41e-14	NR	OGG41713.1	1798471	g50926	i0	54.2	0.977900552486188	59	27	97.8	0	3	179	123	181	OGG41713.1 MAG: ribonucleoside-diphosphate reductase subunit alpha [Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_01_FULL_45_25b]	diamond	177	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_01_FULL_45_25b
31117117	31117117	PRJNA340009_P_NODE_72575_length_163_cov_0.894737_g72268_i0	PRJNA340009	72575	163	0.894737	1.45842131	Candidatus Jorgensenbacteria bacterium	2268185	Bacteria	Bacteria	96.3	7.500000000000001e-22	NR	MDP3974934.1	2268185	g72268	i0	90.7	0.993865030674847	54	5	99.4	0	1	162	174	227	MDP3974934.1 PAS domain-containing sensor histidine kinase [Candidatus Jorgensenbacteria bacterium]	diamond	162	96.3	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium
31749695	31749695	PRJNA340009_P_NODE_37557_length_206_cov_25.000000_g37250_i0	PRJNA340009	37557	206	25	51.5	Candidatus Jorgensenbacteria bacterium	2268185	Bacteria	Bacteria	74.7	1.8e-15	NR	MDO8557339.1	2268185	g37250	i0	73.9	0.669902912621359	46	12	67	0	140	3	2	47	MDO8557339.1 GIY-YIG nuclease family protein [Candidatus Jorgensenbacteria bacterium]	diamond	138	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium
32288070	32288070	PRJNA340009_P_NODE_66979_length_165_cov_0.879310_g66672_i0	PRJNA340009	66979	165	0.87931	1.4508615	Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_12_FULL_42_11	1798473	Bacteria	Bacteria	99	4.439999999999999e-23	NR	OGG43736.1	1798473	g66672	i0	95.8	0.872727272727273	48	2	87.3	0	19	162	1	48	OGG43736.1 MAG: hypothetical protein A3G50_00995 [Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_12_FULL_42_11]	diamond	144	99	1	Bacteria	Bacteria candidate phyla	Candidatus Joergenseniibacteriota	Candidatus Jorgensenbacteria bacterium RIFCSPLOWO2_12_FULL_42_11

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