metadata: contig_metadata: 28 rows where bioproject = "PRJEB10140" and tax

28 rows where bioproject = "PRJEB10140" and tax_phylum = "Lentisphaerota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1287664	1287664	PRJEB10140_P_NODE_84382_length_434_cov_2.428571_g67112_i0	PRJEB10140	84382	434	2.428571	10.53999814	Lentisphaera profundi	1658616	Bacteria	Bacteria	62.1	6.96e-5	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g67112	i0	97.222	0.370967741935484	36	1	8	0	147	182	2019611	2019646	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	161	62.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi
19138120	19138120	PRJEB10140_P_NODE_262596_length_166_cov_0.888889_g245287_i0	PRJEB10140	262596	166	0.888889	1.47555574	PVC group	1783257	Bacteria	Bacteria	64.7	1.22e-10	NR	OPZ29231.1	1852901	g245287	i0	58.2	2.98192771084337	55	23	99.4	0	165	1	14	68	OPZ29231.1 MAG: Bifunctional PGK [Lentisphaerae bacterium ADurb.BinA184]	diamond	495	65.1	0.993855606758833	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium ADurb.BinA184
26589123	26589123	PRJEB10140_P_NODE_245261_length_169_cov_0.866667_g227952_i0	PRJEB10140	245261	169	0.866667	1.46466723	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	47.8	2.38e-4	NR	MBQ7207116.1	2053569	g227952	i0	74.1	0.479289940828402	27	7	47.9	0	81	1	1	27	MBQ7207116.1 ferrous iron transporter B [Lentisphaeria bacterium]	diamond	81	47.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
26652507	26652507	PRJEB10140_P_NODE_291741_length_162_cov_0.911504_g274432_i0	PRJEB10140	291741	162	0.911504	1.47663648	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	82	1.46e-16	NR	MBR7138929.1	2053569	g274432	i0	83.3	1	54	6	98.1	2	160	2	322	373	MBR7138929.1 hypothetical protein [Lentisphaeria bacterium]	diamond	162	82	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
26969247	26969247	PRJEB10140_P_NODE_243322_length_169_cov_3.683333_g226013_i0	PRJEB10140	243322	169	3.683333	6.22483277	Victivallales bacterium	2212475	Bacteria	Bacteria	41.6	0.0365	NR	MBQ7650744.1	2212475	g226013	i0	48.7	0.692307692307692	39	17	69.2	1	123	7	1060	1095	MBQ7650744.1 hypothetical protein [Victivallales bacterium]	diamond	117	41.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
26969252	26969252	PRJEB10140_P_NODE_247842_length_169_cov_0.866667_g230533_i0	PRJEB10140	247842	169	0.866667	1.46466723	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	90.5	4.14e-20	NR	MBR2427415.1	2053569	g230533	i0	78.2	0.976331360946746	55	12	97.6	0	3	167	51	105	MBR2427415.1 type II secretion system F family protein [Lentisphaeria bacterium]	diamond	165	90.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27222076	27222076	PRJEB10140_P_NODE_290163_length_162_cov_0.920354_g272854_i0	PRJEB10140	290163	162	0.920354	1.49097348	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	79.3	1.53e-15	NR	MBQ7397097.1	2053569	g272854	i0	69.8	1.96296296296296	53	16	98.1	0	160	2	131	183	MBQ7397097.1 hypothetical protein [Lentisphaeria bacterium]	diamond	318	79.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27696401	27696401	PRJEB10140_P_NODE_287744_length_162_cov_1.380531_g270435_i0	PRJEB10140	287744	162	1.380531	2.23646022	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	87	1.04e-19	NR	MBE6404392.1	1932692	g270435	i0	83.7	2.72222222222222	49	8	90.7	0	1	147	133	181	MBE6404392.1 putative colanic acid biosynthesis acetyltransferase [Lentisphaerota bacterium]	diamond	441	87	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27722048	27722048	PRJEB10140_P_NODE_247604_length_169_cov_0.866667_g230295_i0	PRJEB10140	247604	169	0.866667	1.46466723	PVC group	1783257	Bacteria	Bacteria	100	6.28e-24	NR	MBR4957158.1	2053569	g230295	i0	82.1	10.8639053254438	56	10	99.4	0	168	1	135	190	MBR4957158.1 diacylglycerol kinase family lipid kinase [Lentisphaeria bacterium]	diamond	1836	100	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27759469	27759469	PRJEB10140_P_NODE_147024_length_252_cov_1.024631_g129716_i0	PRJEB10140	147024	252	1.024631	2.58207012	Lentisphaerae bacterium GWF2_57_35	1798576	Bacteria	Bacteria	97.4	2.41e-21	NR	OGV46464.1	1798576	g129716	i0	58.5	1.85714285714286	82	34	97.6	0	7	252	189	270	OGV46464.1 MAG: hypothetical protein A2X46_14655 [Lentisphaerae bacterium GWF2_57_35]	diamond	468	97.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium GWF2_57_35
27980219	27980219	PRJEB10140_P_NODE_185085_length_208_cov_0.905660_g167776_i0	PRJEB10140	185085	208	0.90566	1.8837728	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	68.6	1.88e-11	NR	NLX24877.1	1932692	g167776	i0	46.8	1.13942307692308	79	32	99.5	1	1	207	475	553	NLX24877.1 outer membrane lipoprotein-sorting protein [Lentisphaerota bacterium]	diamond	237	68.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27980282	27980282	PRJEB10140_P_NODE_272405_length_165_cov_0.879310_g255096_i0	PRJEB10140	272405	165	0.87931	1.4508615	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	41.2	0.0452	NR	MBO5766082.1	2053569	g255096	i0	64	0.909090909090909	25	9	45.5	0	80	6	1	25	MBO5766082.1 polysaccharide deacetylase family protein [Lentisphaeria bacterium]	diamond	150	41.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
28043450	28043450	PRJEB10140_P_NODE_80145_length_458_cov_1.168704_g62899_i0	PRJEB10140	80145	458	1.168704	5.35266432	Lentisphaerae bacterium RIFOXYC12_FULL_6	1932692	Bacteria	Bacteria	60.1	3.53e-7	NR	OGV67873.1	1798582	g62899	i0	36.6	0.661572052401747	101	57	63.5	3	129	419	260	357	OGV67873.1 MAG: hypothetical protein A2498_02525 [Lentisphaerae bacterium RIFOXYC12_FULL_60_16]	diamond	303	60.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium RIFOXYC12_FULL_60_16
28232590	28232590	PRJEB10140_P_NODE_281586_length_163_cov_0.912281_g264277_i0	PRJEB10140	281586	163	0.912281	1.48701803	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	79.3	1.6e-15	NR	MBE6391262.1	1932692	g264277	i0	74.1	0.993865030674847	54	14	99.4	0	162	1	394	447	MBE6391262.1 hypothetical protein [Lentisphaerota bacterium]	diamond	162	79.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28548799	28548799	PRJEB10140_P_NODE_281587_length_163_cov_0.912281_g264278_i0	PRJEB10140	281587	163	0.912281	1.48701803	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	102	3.5199999999999996e-24	NR	MBQ6352736.1	2053569	g264278	i0	98	0.901840490797546	49	1	90.2	0	15	161	109	157	MBQ6352736.1 D-alanine--D-alanine ligase [Lentisphaeria bacterium]	diamond	147	102	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
29527418	29527418	PRJEB10140_P_NODE_255650_length_167_cov_1.228814_g238341_i0	PRJEB10140	255650	167	1.228814	2.05211938	Victivallaceae bacterium	2793042	Bacteria	Bacteria	42.7	0.0135	NR	MDD4818456.1	2793042	g238341	i0	46.8	0.844311377245509	47	25	84.4	0	19	159	78	124	MDD4818456.1 ATP-binding protein [Victivallaceae bacterium]	diamond	141	42.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
29716539	29716539	PRJEB10140_P_NODE_296870_length_153_cov_7.365385_g279561_i0	PRJEB10140	296870	153	7.365385	11.26903905	Victivallales bacterium	2212475	Bacteria	Bacteria	41.2	0.0383	NR	MBT3285855.1	2212475	g279561	i0	40.9	0.862745098039216	44	25	84.3	1	24	152	847	890	MBT3285855.1 DUF4091 domain-containing protein [Victivallales bacterium]	diamond	132	41.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
30026739	30026739	PRJEB10140_P_NODE_271811_length_165_cov_0.887931_g254502_i0	PRJEB10140	271811	165	0.887931	1.46508615	Pseudomonadati	3379134	Bacteria	Bacteria	99.4	1.39e-25	NR	MBE6397083.1	1932692	g254502	i0	94.4	2.94545454545455	54	3	98.2	0	164	3	9	62	MBE6397083.1 DNA-directed RNA polymerase subunit omega [Lentisphaerota bacterium]	diamond	486	99.8	0.995991983967936	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30285810	30285810	PRJEB10140_P_NODE_264632_length_166_cov_0.888889_g247323_i0	PRJEB10140	264632	166	0.888889	1.47555574	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	65.9	5.13e-11	NR	MBE6366658.1	1932692	g247323	i0	63.6	0.993975903614458	55	18	95.8	1	1	159	188	242	MBE6366658.1 rRNA pseudouridine synthase [Lentisphaerota bacterium]	diamond	165	65.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
30311475	30311475	PRJEB10140_P_NODE_296392_length_155_cov_2.301887_g279083_i0	PRJEB10140	296392	155	2.301887	3.56792485	Pseudomonadati	3379134	Bacteria	Bacteria	44.7	0.00236	NR	MCI6288600.1	2053569	g279083	i0	48.6	3.65806451612903	35	18	67.7	0	51	155	37	71	MCI6288600.1 hypothetical protein [Lentisphaeria bacterium]	diamond	567	44.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31012080	31012080	PRJEB10140_P_NODE_277995_length_164_cov_0.895652_g260686_i0	PRJEB10140	277995	164	0.895652	1.46886928	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	67.8	1.62e-11	NR	MBR7130866.1	2053569	g260686	i0	66	1.84756097560976	50	17	91.5	0	1	150	291	340	MBR7130866.1 DNA polymerase IV [Lentisphaeria bacterium]	diamond	303	67.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31296502	31296502	PRJEB10140_P_NODE_258055_length_167_cov_0.881356_g240746_i0	PRJEB10140	258055	167	0.881356	1.47186452	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	63.5	1.37e-10	NR	MBO5681715.1	2053569	g240746	i0	84.8	0.592814371257485	33	5	59.3	0	1	99	151	183	MBO5681715.1 hypothetical protein [Lentisphaeria bacterium]	diamond	99	63.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31328114	31328114	PRJEB10140_P_NODE_253736_length_168_cov_0.865546_g236427_i0	PRJEB10140	253736	168	0.865546	1.45411728	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	110	4.99e-28	NR	MBO5307936.1	2053569	g236427	i0	92.6	2.89285714285714	54	4	96.4	0	3	164	136	189	MBO5307936.1 hypothetical protein [Lentisphaeria bacterium]	diamond	486	110	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31512135	31512135	PRJEB10140_P_NODE_284876_length_163_cov_0.894737_g267567_i0	PRJEB10140	284876	163	0.894737	1.45842131	PVC group	1783257	Bacteria	Bacteria	72.4	2.44e-14	NR	MBQ7401162.1	2053569	g267567	i0	94.4	13.9141104294479	36	2	66.3	0	56	163	1	36	MBQ7401162.1 S1 RNA-binding domain-containing protein [Lentisphaeria bacterium]	diamond	2268	72.8	0.994505494505495	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31518081	31518081	PRJEB10140_P_NODE_264476_length_166_cov_0.888889_g247167_i0	PRJEB10140	264476	166	0.888889	1.47555574	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	94	1.13e-20	NR	MBR2625409.1	2053569	g247167	i0	85.2	0.975903614457831	54	8	97.6	0	164	3	226	279	MBR2625409.1 metallophosphoesterase [Lentisphaeria bacterium]	diamond	162	94	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32214046	32214046	PRJEB10140_P_NODE_282438_length_163_cov_0.912281_g265129_i0	PRJEB10140	282438	163	0.912281	1.48701803	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	102	9.48e-26	NR	MBQ6598256.1	2053569	g265129	i0	94.2	0.957055214723926	52	3	95.7	0	161	6	115	166	MBQ6598256.1 hypothetical protein [Lentisphaeria bacterium]	diamond	156	102	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32403857	32403857	PRJEB10140_P_NODE_207399_length_190_cov_1.460993_g190090_i0	PRJEB10140	207399	190	1.460993	2.7758867	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	85.1	7.99e-18	NR	MBO4492003.1	2053569	g190090	i0	57.4	0.963157894736842	61	26	96.3	0	186	4	37	97	MBO4492003.1 LacI family DNA-binding transcriptional regulator [Lentisphaeria bacterium]	diamond	183	85.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32530573	32530573	PRJEB10140_P_NODE_253699_length_168_cov_0.865546_g236390_i0	PRJEB10140	253699	168	0.865546	1.45411728	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	74.7	6.86e-14	NR	MBR2626308.1	2053569	g236390	i0	67.3	0.982142857142857	55	18	98.2	0	2	166	8	62	MBR2626308.1 methylenetetrahydrofolate reductase C-terminal domain-containing protein [Lentisphaeria bacterium]	diamond	165	74.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria 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);;