metadata: contig_metadata: 17 rows where bioproject = "PRJNA1148190", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Yanofskyibacteriota"

17 rows where bioproject = "PRJNA1148190", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Yanofskyibacteriota"

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
6672420	6672420	PRJNA1148190_P_NODE_360566_length_297_cov_0.928571_g349393_i0	PRJNA1148190	360566	297	0.928571	2.75785587	Bacteria	2	Bacteria	Bacteria	160	7.35e-44	NR	MBX4211538.1	2052154	g349393	i0	75.3	15.7474747474747	97	24	98	0	293	3	395	491	MBX4211538.1 threonine--tRNA ligase [Candidatus Yanofskybacteria bacterium]	diamond	4677	160	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium
7951412	7951412	PRJNA1148190_P_NODE_638527_length_248_cov_1.371429_g627354_i0	PRJNA1148190	638527	248	1.371429	3.40114392	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	155	5.589999999999998e-47	NR	MCC6405051.1	2052154	g627354	i0	81.7	0.991935483870968	82	15	99.2	0	246	1	33	114	MCC6405051.1 peptide-methionine (R)-S-oxide reductase MsrB [Candidatus Yanofskybacteria bacterium]	diamond	246	155	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium
26595869	26595869	PRJNA1148190_P_NODE_298561_length_320_cov_1.850202_g287388_i0	PRJNA1148190	298561	320	1.850202	5.9206464	Candidatus Yanofskybacteria bacterium GW2	2052154	Bacteria	Bacteria	84.7	1.99e-18	NR	KKR36287.1	1619032	g287388	i0	51.1	0.84375	90	40	84.4	1	47	316	1	86	KKR36287.1 MAG: hypothetical protein UT69_C0030G0006 [Candidatus Yanofskybacteria bacterium GW2011_GWE1_40_10]	diamond	270	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium GW2011_GWE1_40_10
26944142	26944142	PRJNA1148190_P_NODE_210602_length_368_cov_1.820339_g199432_i0	PRJNA1148190	210602	368	1.820339	6.69884752	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_	2052154	Bacteria	Bacteria	82.4	5.45e-17	NR	OGN01210.1	1802665	g199432	i0	53.4	1.20652173913043	73	34	59.5	0	354	136	87	159	OGN01210.1 MAG: hypothetical protein A2742_02375 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_43_32]	diamond	444	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_43_32
27196932	27196932	PRJNA1148190_P_NODE_153582_length_424_cov_1.794872_g142415_i0	PRJNA1148190	153582	424	1.794872	7.61025728	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	143	1.0299999999999999e-40	NR	MBI2063248.1	2052154	g142415	i0	57.3	0.92688679245283	131	55	92	1	393	4	17	147	MBI2063248.1 hypothetical protein [Candidatus Yanofskybacteria bacterium]	diamond	393	143	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium
27533657	27533657	PRJNA1148190_P_NODE_802103_length_230_cov_2.815287_g790930_i0	PRJNA1148190	802103	230	2.815287	6.4751601	Bacteria	2	Bacteria	Bacteria	90.9	1.29e-19	NR	OGN32435.1	1802704	g790930	i0	53.3	3.95217391304348	75	34	96.5	1	222	1	194	268	OGN32435.1 MAG: hypothetical protein A3I92_01200 [Candidatus Yanofskybacteria bacterium RIFCSPLOWO2_02_FULL_43_10b]	diamond	909	90.9	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium RIFCSPLOWO2_02_FULL_43_10b
28207962	28207962	PRJNA1148190_P_NODE_380006_length_290_cov_1.419355_g368833_i0	PRJNA1148190	380006	290	1.419355	4.1161295	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_	2052154	Bacteria	Bacteria	63.5	1.32e-9	NR	OGN07685.1	1802673	g368833	i0	33.3	0.962068965517241	93	58	96.2	1	288	10	58	146	OGN07685.1 MAG: hypothetical protein A3B86_02515 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_02_FULL_38_22b]	diamond	279	63.5	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_02_FULL_38_22b
28271082	28271082	PRJNA1148190_P_NODE_405126_length_285_cov_1.490566_g393953_i0	PRJNA1148190	405126	285	1.490566	4.2481131	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	84.7	3.55e-17	NR	MBI2063250.1	2052154	g393953	i0	54.9	0.747368421052632	71	31	73.7	1	282	73	235	305	MBI2063250.1 serine hydrolase [Candidatus Yanofskybacteria bacterium]	diamond	213	84.7	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium
28303456	28303456	PRJNA1148190_P_NODE_74426_length_640_cov_2.543210_g63320_i0	PRJNA1148190	74426	640	2.54321	16.276544	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	95.9	2e-21	NR	MBI2064896.1	2052154	g63320	i0	46.3	0.50625	108	45	47.8	2	164	469	23	123	MBI2064896.1 hypothetical protein [Candidatus Yanofskybacteria bacterium]	diamond	324	95.9	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium
29238747	29238747	PRJNA1148190_P_NODE_781269_length_241_cov_0.916667_g770096_i0	PRJNA1148190	781269	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	135	6e-36	NR	OGN03355.1	1802664	g770096	i0	75	13.7800829875519	80	20	99.6	0	241	2	293	372	OGN03355.1 MAG: hypothetical protein A2651_02640 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_42_12]	diamond	3321	135	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_42_12
29628590	29628590	PRJNA1148190_P_NODE_412950_length_284_cov_1.094787_g401777_i0	PRJNA1148190	412950	284	1.094787	3.10919508	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_	2052154	Bacteria	Bacteria	71.2	5.7e-12	NR	OGN00615.1	1802663	g401777	i0	53.8	0.549295774647887	52	24	54.9	0	1	156	585	636	OGN00615.1 MAG: hypothetical protein A2650_01685 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_41_53]	diamond	156	71.2	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_41_53
30039289	30039289	PRJNA1148190_P_NODE_267591_length_334_cov_2.076628_g256420_i0	PRJNA1148190	267591	334	2.076628	6.93593752	Candidatus Yanofskybacteria bacterium GW2	2052154	Bacteria	Bacteria	55.5	3.74e-6	NR	KKR36283.1	1619032	g256420	i0	41	0.70059880239521	78	42	70.1	1	334	101	690	763	KKR36283.1 MAG: hypothetical protein UT69_C0030G0002 [Candidatus Yanofskybacteria bacterium GW2011_GWE1_40_10]	diamond	234	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium GW2011_GWE1_40_10
30607976	30607976	PRJNA1148190_P_NODE_312413_length_315_cov_0.876033_g301240_i0	PRJNA1148190	312413	315	0.876033	2.75950395	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	63.9	5.96e-11	NR	MBI2063669.1	2052154	g301240	i0	45.3	0.60952380952381	64	34	61	1	195	4	9	71	MBI2063669.1 hypothetical protein [Candidatus Yanofskybacteria bacterium]	diamond	192	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium
30766668	30766668	PRJNA1148190_P_NODE_632694_length_249_cov_0.875000_g621521_i0	PRJNA1148190	632694	249	0.875	2.17875	Candidatus Yanofskybacteria bacterium	2052154	Bacteria	Bacteria	131	2.07e-35	NR	MBI2064410.1	2052154	g621521	i0	71.1	2	83	23	98.8	1	3	248	170	252	MBI2064410.1 deoxyribonuclease IV [Candidatus Yanofskybacteria bacterium]	diamond	498	131	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium
31304098	31304098	PRJNA1148190_P_NODE_783335_length_241_cov_0.916667_g772162_i0	PRJNA1148190	783335	241	0.916667	2.20916747	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_	2052154	Bacteria	Bacteria	157	1.33e-42	NR	OGM97918.1	1802659	g772162	i0	92.5	2.98755186721992	80	6	99.6	0	240	1	584	663	OGM97918.1 MAG: hypothetical protein A2817_01765 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_39_8b]	diamond	720	157	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_39_8b
32316741	32316741	PRJNA1148190_P_NODE_773859_length_241_cov_1.738095_g762686_i0	PRJNA1148190	773859	241	1.738095	4.18880895	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_	2052154	Bacteria	Bacteria	60.1	1.37e-8	NR	OGM97901.1	1802660	g762686	i0	57.8	0.560165975103734	45	19	56	0	237	103	180	224	OGM97901.1 MAG: hypothetical protein A2735_02990 [Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_41_21]	diamond	135	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium RIFCSPHIGHO2_01_FULL_41_21
32399279	32399279	PRJNA1148190_P_NODE_615459_length_250_cov_0.870056_g604286_i0	PRJNA1148190	615459	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	146	1.24e-38	NR	KKR40564.1	1619033	g604286	i0	85.5	1.992	83	12	99.6	0	2	250	759	841	KKR40564.1 MAG: Type III restriction protein res subunit [Candidatus Yanofskybacteria bacterium GW2011_GWE2_40_11]	diamond	498	146	1	Bacteria	Bacteria candidate phyla	Candidatus Yanofskyibacteriota	Candidatus Yanofskybacteria bacterium GW2011_GWE2_40_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);;