metadata: contig_metadata: 27 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax

27 rows where analysis = "diamond", bioproject = "PRJNA773247" and tax_clade = "Luna-1 subcluster"

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
2024976	2024976	PRJNA773247_P_NODE_37482_length_196_cov_4.601626_g37398_i0	PRJNA773247	37482	196	4.601626	9.01918696	Rhodoluna	529883	Bacteria	Bacteria	126	3.37e-33	NR	MFM6939586.1	1969481	g37398	i0	100	5.69387755102041	62	0	94.9	0	11	196	212	273	MFM6939586.1 dihydroorotase [Rhodoluna sp.]	diamond	1116	126	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
5852514	5852514	PRJNA773247_P_NODE_30505_length_250_cov_5.694915_g30421_i0	PRJNA773247	30505	250	5.694915	14.2372875	Rhodoluna	529883	Bacteria	Bacteria	144	5.62e-39	NR	WP_038502009.1	529884	g30421	i0	90.4	1.992	83	8	99.6	0	1	249	34	116	WP_038502009.1 homoserine dehydrogenase [Rhodoluna lacicola]	diamond	498	144	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
10953007	10953007	PRJNA773247_P_NODE_26829_length_269_cov_1.734694_g26745_i0	PRJNA773247	26829	269	1.734694	4.66632686	Rhodoluna	529883	Bacteria	Bacteria	162	1.21e-45	NR	MCX8530725.1	1969481	g26745	i0	98.8	5.35315985130112	80	1	89.2	0	268	29	121	200	MCX8530725.1 DNA polymerase III subunit gamma and tau [Rhodoluna sp.]	diamond	1440	162	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
14777588	14777588	PRJNA773247_P_NODE_18052_length_342_cov_1.687732_g17968_i0	PRJNA773247	18052	342	1.687732	5.77204344	Rhodoluna sp.	1969481	Bacteria	Bacteria	218	1.45e-67	NR	MBP6087808.1	1969481	g17968	i0	95.6	1	114	5	100	0	342	1	219	332	MBP6087808.1 glycogen synthase [Rhodoluna sp.]	diamond	342	218	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
18600515	18600515	PRJNA773247_P_NODE_16555_length_360_cov_3.094077_g16471_i0	PRJNA773247	16555	360	3.094077	11.1386772	Rhodoluna sp.	1969481	Bacteria	Bacteria	231	2.36e-74	NR	MBP7818982.1	1969481	g16471	i0	98.3	0.991666666666667	119	2	99.2	0	358	2	60	178	MBP7818982.1 demethylmenaquinone methyltransferase [Rhodoluna sp.]	diamond	357	231	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
26736371	26736371	PRJNA773247_P_NODE_20381_length_317_cov_2.877049_g20297_i0	PRJNA773247	20381	317	2.877049	9.12024533	Rhodoluna sp.	1969481	Bacteria	Bacteria	95.1	9.18e-22	NR	MBP6087235.1	1969481	g20297	i0	84.3	0.482649842271293	51	8	48.3	0	17	169	142	192	MBP6087235.1 DUF998 domain-containing protein [Rhodoluna sp.]	diamond	153	95.1	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
26831889	26831889	PRJNA773247_P_NODE_9641_length_509_cov_11.905963_g9558_i0	PRJNA773247	9641	509	11.905963	60.60135167	Rhodoluna sp.	1969481	Bacteria	Bacteria	294	2.3999999999999998e-96	NR	MFM6940108.1	1969481	g9558	i0	92.2	0.9783889980353628	166	13	97.8	0	12	509	232	397	MFM6940108.1 MFS transporter [Rhodoluna sp.]	diamond	498	294	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
27085005	27085005	PRJNA773247_P_NODE_6082_length_697_cov_54.522436_g6001_i0	PRJNA773247	6082	697	54.522436	380.02137892	Candidatus Rhodoluna planktonica	535712	Bacteria	Bacteria	169	4.74e-44	NR	WP_070955045.1	535712	g6001	i0	43	0.989956958393113	230	122	97.3	3	690	13	9257	9481	WP_070955045.1 GLEYA domain-containing protein [Candidatus Rhodoluna planktonica]	diamond	690	169	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Candidatus Rhodoluna planktonica
27116300	27116300	PRJNA773247_P_NODE_10642_length_478_cov_24.123457_g10559_i0	PRJNA773247	10642	478	24.123457	115.31012446	Rhodoluna sp.	1969481	Bacteria	Bacteria	209	1.04e-64	NR	MBP7835641.1	1969481	g10559	i0	90.7	0.740585774058577	118	11	74.1	0	124	477	1	118	MBP7835641.1 metal ABC transporter ATP-binding protein [Rhodoluna sp.]	diamond	354	209	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
27306294	27306294	PRJNA773247_P_NODE_12343_length_434_cov_9.451524_g12260_i0	PRJNA773247	12343	434	9.451524	41.01961416	Rhodoluna sp.	1969481	Bacteria	Bacteria	151	2.849999999999999e-43	NR	MBP7835567.1	1969481	g12260	i0	96.2	0.546082949308756	79	3	54.6	0	1	237	126	204	MBP7835567.1 CDP-diacylglycerol--glycerol-3-phosphate 3-phosphatidyltransferase [Rhodoluna sp.]	diamond	237	151	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
27717141	27717141	PRJNA773247_P_NODE_25784_length_275_cov_2.995050_g25700_i0	PRJNA773247	25784	275	2.99505	8.2363875	Rhodoluna sp.	1969481	Bacteria	Bacteria	139	1.64e-38	NR	MBP6087438.1	1969481	g25700	i0	100	0.818181818181818	75	0	81.8	0	3	227	201	275	MBP6087438.1 undecaprenyl-diphosphate phosphatase [Rhodoluna sp.]	diamond	225	139	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
27969267	27969267	PRJNA773247_P_NODE_12125_length_439_cov_11.887978_g12042_i0	PRJNA773247	12125	439	11.887978	52.18822342	Rhodoluna sp.	1969481	Bacteria	Bacteria	222	7.59e-69	NR	MBP7835302.1	1969481	g12042	i0	99.1	0.772209567198178	113	1	77.2	0	426	88	268	380	MBP7835302.1 5-(carboxyamino)imidazole ribonucleotide synthase [Rhodoluna sp.]	diamond	339	222	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
28673543	28673543	PRJNA773247_P_NODE_30607_length_250_cov_1.740113_g30523_i0	PRJNA773247	30607	250	1.740113	4.3502825	Rhodoluna	529883	Bacteria	Bacteria	123	2.8999999999999996e-31	NR	WP_138275126.1	529883	g30523	i0	98.5	9.36	65	1	78	0	55	249	62	126	WP_138275126.1 MULTISPECIES: homoserine dehydrogenase [Rhodoluna]	diamond	2340	124	0.991935483870968	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna
28916299	28916299	PRJNA773247_P_NODE_16748_length_357_cov_10.278169_g16664_i0	PRJNA773247	16748	357	10.278169	36.69306333	Rhodoluna sp.	1969481	Bacteria	Bacteria	229	2.99e-72	NR	MBP6087889.1	1969481	g16664	i0	99.2	0.991596638655462	118	1	99.2	0	2	355	30	147	MBP6087889.1 undecaprenyl/decaprenyl-phosphate alpha-N-acetylglucosaminyl 1-phosphate transferase [Rhodoluna sp.]	diamond	354	229	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
29043038	29043038	PRJNA773247_P_NODE_34588_length_241_cov_5.702381_g34504_i0	PRJNA773247	34588	241	5.702381	13.74273821	Rhodoluna sp.	1969481	Bacteria	Bacteria	139	3.67e-36	NR	MBP6087585.1	1969481	g34504	i0	100	0.983402489626556	79	0	98.3	0	1	237	413	491	MBP6087585.1 ATP-binding cassette domain-containing protein [Rhodoluna sp.]	diamond	237	139	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
29074626	29074626	PRJNA773247_P_NODE_36048_length_231_cov_3.189873_g35964_i0	PRJNA773247	36048	231	3.189873	7.36860663	Rhodoluna sp.	1969481	Bacteria	Bacteria	151	4.01e-42	NR	MBP7818676.1	1969481	g35964	i0	97.3	0.974025974025974	75	2	97.4	0	7	231	28	102	MBP7818676.1 acetyl-CoA hydrolase [Rhodoluna sp.]	diamond	225	151	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
29137841	29137841	PRJNA773247_P_NODE_36909_length_216_cov_5.538462_g36825_i0	PRJNA773247	36909	216	5.538462	11.96307792	Rhodoluna sp.	1969481	Bacteria	Bacteria	144	3.759999999999999e-42	NR	MBP7818677.1	1969481	g36825	i0	100	0.986111111111111	71	0	98.6	0	3	215	81	151	MBP7818677.1 TrkA family potassium uptake protein [Rhodoluna sp.]	diamond	213	144	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
29421523	29421523	PRJNA773247_P_NODE_20589_length_315_cov_2.830579_g20505_i0	PRJNA773247	20589	315	2.830579	8.91632385	Rhodoluna sp.	1969481	Bacteria	Bacteria	150	2.41e-40	NR	MBP7818985.1	1969481	g20505	i0	93.6	0.742857142857143	78	5	74.3	0	315	82	450	527	MBP7818985.1 2-succinyl-5-enolpyruvyl-6-hydroxy-3-cyclohexene-1-carboxylic-acid synthase [Rhodoluna sp.]	diamond	234	150	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
29768939	29768939	PRJNA773247_P_NODE_27831_length_263_cov_3.678947_g27747_i0	PRJNA773247	27831	263	3.678947	9.67563061	Rhodoluna sp.	1969481	Bacteria	Bacteria	162	7.299999999999999e-46	NR	MBP7835274.1	1969481	g27747	i0	98.9	0.992395437262357	87	1	99.2	0	263	3	74	160	MBP7835274.1 zinc-dependent metalloprotease [Rhodoluna sp.]	diamond	261	162	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
29990184	29990184	PRJNA773247_P_NODE_4711_length_836_cov_17.293578_g4638_i0	PRJNA773247	4711	836	17.293578	144.57431208	Rhodoluna sp.	1969481	Bacteria	Bacteria	351	4.01e-120	NR	MBP7835606.1	1969481	g4638	i0	99.5	0.674641148325359	188	1	67.5	0	272	835	1	188	MBP7835606.1 16S rRNA (guanine(966)-N(2))-methyltransferase RsmD [Rhodoluna sp.]	diamond	564	351	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
30274765	30274765	PRJNA773247_P_NODE_35972_length_232_cov_2.452830_g35888_i0	PRJNA773247	35972	232	2.45283	5.6905656	Rhodoluna sp.	1969481	Bacteria	Bacteria	139	3.29e-40	NR	MFM6939040.1	1969481	g35888	i0	96	1.93965517241379	75	3	97	0	231	7	68	142	MFM6939040.1 HisA/HisF-related TIM barrel protein [Rhodoluna sp.]	diamond	450	139	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
30685110	30685110	PRJNA773247_P_NODE_24373_length_285_cov_1.400943_g24289_i0	PRJNA773247	24373	285	1.400943	3.99268755	Rhodoluna sp.	1969481	Bacteria	Bacteria	176	6.13e-53	NR	MBP6087346.1	1969481	g24289	i0	96.8	0.989473684210526	94	3	98.9	0	2	283	119	212	MBP6087346.1 tryptophan synthase subunit alpha [Rhodoluna sp.]	diamond	282	176	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
30884333	30884333	PRJNA773247_P_NODE_17274_length_351_cov_2.586331_g17190_i0	PRJNA773247	17274	351	2.586331	9.07802181	Rhodoluna	529883	Bacteria	Bacteria	179	5.349999999999998e-54	NR	MBP6087698.1	1969481	g17190	i0	91.8	1.65811965811966	97	8	82.9	0	349	59	159	255	MBP6087698.1 biotin--[acetyl-CoA-carboxylase] ligase [Rhodoluna sp.]	diamond	582	179	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
31390236	31390236	PRJNA773247_P_NODE_27376_length_266_cov_1.445596_g27292_i0	PRJNA773247	27376	266	1.445596	3.84528536	Rhodoluna	529883	Bacteria	Bacteria	181	3.8399999999999986e-55	NR	MCX8530535.1	1969481	g27292	i0	97.7	1.98496240601504	88	2	99.2	0	3	266	156	243	MCX8530535.1 fumarylacetoacetate hydrolase family protein [Rhodoluna sp.]	diamond	528	182	0.994505494505495	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
31791514	31791514	PRJNA773247_P_NODE_25037_length_280_cov_2.352657_g24953_i0	PRJNA773247	25037	280	2.352657	6.5874396	Rhodoluna sp.	1969481	Bacteria	Bacteria	111	1.4e-27	NR	MBP7818679.1	1969481	g24953	i0	98.2	1.83214285714286	57	1	61.1	0	110	280	1	57	MBP7818679.1 DMT family transporter [Rhodoluna sp.]	diamond	513	111	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
31823218	31823218	PRJNA773247_P_NODE_36977_length_214_cov_4.241135_g36893_i0	PRJNA773247	36977	214	4.241135	9.0760289	Rhodoluna sp.	1969481	Bacteria	Bacteria	132	5.33e-36	NR	MCX8528507.1	1969481	g36893	i0	92.9	1.96261682242991	70	5	98.1	0	3	212	178	247	MCX8528507.1 DMT family transporter [Rhodoluna sp.]	diamond	420	132	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
32676859	32676859	PRJNA773247_P_NODE_19000_length_331_cov_4.015504_g18916_i0	PRJNA773247	19000	331	4.015504	13.29131824	Rhodoluna sp.	1969481	Bacteria	Bacteria	130	1.61e-32	NR	MCX8528466.1	1969481	g18916	i0	73.4	0.987915407854985	109	29	98.8	0	3	329	44	152	MCX8528466.1 hypothetical protein [Rhodoluna sp.]	diamond	327	130	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.

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