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

14 rows where bioproject = "PRJEB11748" and tax_phylum = "Candidatus Levyibacteriota"

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
6393161	6393161	PRJEB11748_P_NODE_156586_length_327_cov_6.657895_g154404_i0	PRJEB11748	156586	327	6.657895	21.77131665	Bacteria	2	Bacteria	Bacteria	69.7	3.5e-11	NR	OGH11600.1	1798587	g154404	i0	61.8	3.53211009174312	55	21	50.5	0	327	163	160	214	OGH11600.1 MAG: hypothetical protein A2684_03435 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_36_15b]	diamond	1155	69.7	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_36_15b
27190798	27190798	PRJEB11748_P_NODE_270702_length_234_cov_20.855491_g268519_i0	PRJEB11748	270702	234	20.855491	48.80184894	Candidatus Levybacteria bacterium CG2_3	2052151	Bacteria	Bacteria	124	8.65e-31	NR	OIP58181.1	1805237	g268519	i0	74	0.935897435897436	73	19	93.6	0	5	223	20	92	OIP58181.1 MAG: hypothetical protein AUK12_00500 [Candidatus Levybacteria bacterium CG2_30_37_29]	diamond	219	124	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium CG2_30_37_29
27285714	27285714	PRJEB11748_P_NODE_272123_length_234_cov_1.502890_g269940_i0	PRJEB11748	272123	234	1.50289	3.5167626	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	68.9	1.95e-11	NR	MBA3723701.1	2052151	g269940	i0	42.9	0.987179487179487	77	44	98.7	0	4	234	238	314	MBA3723701.1 sulfatase [Candidatus Levyibacteriota bacterium]	diamond	231	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
28422831	28422831	PRJEB11748_P_NODE_86466_length_450_cov_33.115681_g84301_i0	PRJEB11748	86466	450	33.115681	149.0205645	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	215	1.5399999999999998e-66	NR	MDO8269587.1	2052151	g84301	i0	83.9	0.786666666666667	118	19	78.7	0	357	4	97	214	MDO8269587.1 FAD-dependent oxidoreductase [Candidatus Levyibacteriota bacterium]	diamond	354	215	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
28991190	28991190	PRJEB11748_P_NODE_310868_length_214_cov_6.294118_g308685_i0	PRJEB11748	310868	214	6.294118	13.46941252	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	72.8	3.55e-13	NR	MBI2033289.1	2052151	g308685	i0	61.3	3.46261682242991	62	24	86.9	0	3	188	78	139	MBI2033289.1 DMT family transporter [Candidatus Levyibacteriota bacterium]	diamond	741	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
29117392	29117392	PRJEB11748_P_NODE_379109_length_180_cov_6.168067_g376926_i0	PRJEB11748	379109	180	6.168067	11.1025206	Candidatus Levybacteria bacterium RIFCSPHIGHO2_	2052151	Bacteria	Bacteria	75.5	3.9e-14	NR	OGH02555.1	1798588	g376926	i0	64.8	0.9	54	19	90	0	3	164	235	288	OGH02555.1 MAG: hypothetical protein A2798_02860 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_37_17]	diamond	162	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_37_17
29180530	29180530	PRJEB11748_P_NODE_326769_length_207_cov_14.479452_g324586_i0	PRJEB11748	326769	207	14.479452	29.97246564	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	60.5	1.33e-8	NR	MBI2621147.1	2052151	g324586	i0	72.2	0.521739130434783	36	10	52.2	0	22	129	580	615	MBI2621147.1 UvrD-helicase domain-containing protein [Candidatus Levyibacteriota bacterium]	diamond	108	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
29432510	29432510	PRJEB11748_P_NODE_178330_length_303_cov_11.338843_g176147_i0	PRJEB11748	178330	303	11.338843	34.35669429	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	107	7.1e-27	NR	MBI2026085.1	2052151	g176147	i0	53.8	0.920792079207921	93	43	92.1	0	23	301	40	132	MBI2026085.1 50S ribosomal protein L11 methyltransferase [Candidatus Levyibacteriota bacterium]	diamond	279	107	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
29527751	29527751	PRJEB11748_P_NODE_371130_length_186_cov_12.624000_g368947_i0	PRJEB11748	371130	186	12.624	23.48064	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	42.4	0.012	NR	MBP6098419.1	2052151	g368947	i0	45	0.645161290322581	40	22	64.5	0	162	43	100	139	MBP6098419.1 NUDIX domain-containing protein [Candidatus Levyibacteriota bacterium]	diamond	120	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
30569701	30569701	PRJEB11748_P_NODE_207673_length_277_cov_5.875000_g205490_i0	PRJEB11748	207673	277	5.875	16.27375	Candidatus Levybacteria bacterium RIFCSPHIGHO2_	2052151	Bacteria	Bacteria	152	7.4e-42	NR	OGH14163.1	1798589	g205490	i0	81.4	0.931407942238267	86	16	93.1	0	19	276	122	207	OGH14163.1 MAG: hypothetical protein A2860_02280 [Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_37_33]	diamond	258	152	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium RIFCSPHIGHO2_01_FULL_37_33
30633076	30633076	PRJEB11748_P_NODE_377973_length_181_cov_5.200000_g375790_i0	PRJEB11748	377973	181	5.2	9.412	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	100	7.3e-23	NR	MBP6913102.1	2052151	g375790	i0	87	1.79005524861878	54	7	89.5	0	2	163	144	197	MBP6913102.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Levyibacteriota bacterium]	diamond	324	100	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
30753402	30753402	PRJEB11748_P_NODE_354154_length_195_cov_16.992537_g351971_i0	PRJEB11748	354154	195	16.992537	33.13544715	Bacteria	2	Bacteria	Bacteria	112	1.1300000000000002e-27	NR	KKQ41361.1	1618463	g351971	i0	93	3.50769230769231	57	4	87.7	0	172	2	214	270	KKQ41361.1 MAG: DegT/DnrJ/EryC1/StrS aminotransferase [Candidatus Levybacteria bacterium GW2011_GWB1_37_8]	diamond	684	113	0.991150442477876	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levybacteria bacterium GW2011_GWB1_37_8
31328367	31328367	PRJEB11748_P_NODE_256856_length_242_cov_26.640884_g254673_i0	PRJEB11748	256856	242	26.640884	64.47093928	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	67	5.83e-11	NR	MBP6098739.1	2052151	g254673	i0	76.1	1.71074380165289	46	11	57	0	103	240	1	46	MBP6098739.1 ATP synthase F1 subunit gamma [Candidatus Levyibacteriota bacterium]	diamond	414	67	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota bacterium
31733246	31733246	PRJEB11748_P_NODE_258577_length_241_cov_21.122222_g256394_i0	PRJEB11748	258577	241	21.122222	50.90455502	Bacteria	2	Bacteria	Bacteria	77.8	1.54e-15	NR	MBI2074982.1	2052151	g256394	i0	50	4.55601659751037	78	38	95.9	1	7	237	15	92	MBI2074982.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Candidatus Levyibacteriota bacterium]	diamond	1098	78.2	0.994884910485933	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota	Candidatus Levyibacteriota 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);;