metadata: contig_metadata: 22 rows where bioproject = "PRJNA630162", tax_clade = "Luna-1 subcluster" and tax

22 rows where bioproject = "PRJNA630162", tax_clade = "Luna-1 subcluster" and tax_kingdom = "Bacillati"

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
1877623	1877623	PRJNA630162_P_NODE_118162_length_175_cov_2.158730_g116639_i0	PRJNA630162	118162	175	2.15873	3.7777775	Rhodoluna lacicola	529884	Bacteria	Bacteria	252	1.3499999999999999e-62	NTclustered	gi\|2318878936\|dbj\|AP026911.1\|	529884	g116639	i0	93.529	1.94285714285714	170	10	97	1	7	175	502246	502415	Rhodoluna lacicola KACHI23 DNA, complete genome	blastn	340	252	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
3153675	3153675	PRJNA630162_P_NODE_9043_length_638_cov_75.410866_g7680_i0	PRJNA630162	9043	638	75.410866	481.12132508	Rhodoluna lacicola	529884	Bacteria	Bacteria	872	0	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g7680	i0	91.64	157.485893416928	634	48	99	5	1	632	517684	517054	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	100476	872	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
4429400	4429400	PRJNA630162_P_NODE_144664_length_166_cov_0.888889_g143141_i0	PRJNA630162	144664	166	0.888889	1.47555574	Rhodoluna limnophila	232537	Bacteria	Bacteria	111	2.26e-20	NTclustered	gi\|1666461686\|gb\|CP040508.1\|	232537	g143141	i0	80.986	0.855421686746988	142	25	85	2	20	160	948572	948712	Rhodoluna limnophila strain 1B-Mac chromosome, complete genome	blastn	142	111	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
6980459	6980459	PRJNA630162_P_NODE_168686_length_155_cov_4.462264_g167163_i0	PRJNA630162	168686	155	4.462264	6.9165092	Rhodoluna limnophila	232537	Bacteria	Bacteria	135	1.23e-27	NTclustered	gi\|1666461688\|gb\|CP040510.1\|	232537	g167163	i0	82.895	3.92258064516129	152	25	97	1	5	155	459944	460095	Rhodoluna limnophila strain 36A-HELLB chromosome, complete genome	blastn	608	135	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
7529338	7529338	PRJNA630162_P_NODE_46286_length_259_cov_51.933333_g44763_i0	PRJNA630162	46286	259	51.933333	134.50733247	Rhodoluna	529883	Bacteria	Bacteria	462	9.2e-126	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g44763	i0	98.842	184.911196911197	259	3	100	0	1	259	478646	478388	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	47892	462	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
8255788	8255788	PRJNA630162_P_NODE_74567_length_208_cov_2.345912_g73044_i0	PRJNA630162	74567	208	2.345912	4.87949696	Rhodoluna lacicola	529884	Bacteria	Bacteria	285	1.6499999999999998e-72	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g73044	i0	92.195	199.701923076923	205	10	97	6	5	206	517452	517653	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	41538	285	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
9531158	9531158	PRJNA630162_P_NODE_78848_length_202_cov_8.104575_g77325_i0	PRJNA630162	78848	202	8.104575	16.3712415	Rhodoluna lacicola	529884	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g77325	i0	99.505	154.846534653465	202	1	100	0	1	202	517468	517669	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	31279	368	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
9531264	9531264	PRJNA630162_P_NODE_88688_length_192_cov_69.314685_g87165_i0	PRJNA630162	88688	192	69.314685	133.0841952	Candidatus Rhodoluna planktonica	535712	Bacteria	Bacteria	333	5.269999999999999e-87	NTclustered	gi\|1092201385\|gb\|CP015208.1\|	535712	g87165	i0	97.917	160.322916666667	192	4	100	0	1	192	876080	876271	Candidatus Rhodoluna planktonica strain MWH-Dar1 chromosome, complete genome	blastn	30782	333	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Candidatus Rhodoluna planktonica
10806826	10806826	PRJNA630162_P_NODE_7529_length_698_cov_84.137134_g6255_i0	PRJNA630162	7529	698	84.137134	587.27719532	Rhodoluna lacicola	529884	Bacteria	Bacteria	1050	0	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g6255	i0	94.323	172.786532951289	687	36	98	3	8	693	518434	519118	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	120605	1050	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
13905133	13905133	PRJNA630162_P_NODE_128611_length_170_cov_1.619835_g127088_i0	PRJNA630162	128611	170	1.619835	2.7537195	Rhodoluna	529883	Bacteria	Bacteria	207	2.87e-49	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g127088	i0	89.634	7.78823529411765	164	15	96	2	4	166	1364069	1364231	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	1324	207	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
14631651	14631651	PRJNA630162_P_NODE_83512_length_197_cov_45.364865_g81989_i0	PRJNA630162	83512	197	45.364865	89.36878405	Rhodoluna lacicola	529884	Bacteria	Bacteria	340	3.2499999999999995e-89	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g81989	i0	98.947	153.766497461929	190	2	96	0	8	197	517656	517845	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	30292	340	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
15904568	15904568	PRJNA630162_P_NODE_137313_length_167_cov_3.500000_g135790_i0	PRJNA630162	137313	167	3.5	5.845	Rhodoluna lacicola	529884	Bacteria	Bacteria	99	1.77e-16	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g135790	i0	89.024	1.52694610778443	82	5	48	4	30	109	515078	515157	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	255	99	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
16454130	16454130	PRJNA630162_P_NODE_2553_length_1144_cov_80.291324_g318_i4	PRJNA630162	2553	1144	80.291324	918.53274656	Rhodoluna	529883	Bacteria	Bacteria	1805	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g318	i4	95.431	155.431818181818	1138	43	99	6	1	1138	477594	476466	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	177814	1814	0.995038588754135	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
19002630	19002630	PRJNA630162_P_NODE_1255_length_1517_cov_137.960490_g318_i1	PRJNA630162	1255	1517	137.96049	2092.8606333	Rhodoluna	529883	Bacteria	Bacteria	1917	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g318	i1	89.687	210.58602504944	1532	119	99	24	4	1511	477982	476466	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	319459	1923	0.996879875195008	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
19002838	19002838	PRJNA630162_P_NODE_26735_length_352_cov_89.531353_g25213_i0	PRJNA630162	26735	352	89.531353	315.15036256	Rhodoluna	529883	Bacteria	Bacteria	573	5.739999999999999e-159	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g25213	i0	96.023	176.954545454545	352	14	100	0	1	352	477647	477296	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	62288	573	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
20277799	20277799	PRJNA630162_P_NODE_2296_length_1197_cov_88.147213_g318_i3	PRJNA630162	2296	1197	88.147213	1055.12213961	Rhodoluna	529883	Bacteria	Bacteria	1908	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g318	i3	95.718	159.93149540518	1191	42	99	6	7	1197	476466	477647	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	191438	1917	0.995305164319249	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
22828942	22828942	PRJNA630162_P_NODE_5878_length_788_cov_229.492558_g4748_i0	PRJNA630162	5878	788	229.492558	1808.40135704	Rhodoluna	529883	Bacteria	Bacteria	1339	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g4748	i0	97.348	174.27538071066	792	13	100	6	1	788	477650	478437	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	137329	1339	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
23554095	23554095	PRJNA630162_P_NODE_122539_length_173_cov_1.588710_g121016_i0	PRJNA630162	122539	173	1.58871	2.7484683	Aquiluna sp. KACHI24	2968831	Bacteria	Bacteria	156	1.08e-33	NTclustered	gi\|2283401075\|dbj\|AP026677.1\|	2968831	g121016	i0	93.333	113.508670520231	105	7	61	0	57	161	478315	478419	Aquiluna sp. KACHI24 DNA, complete genome	blastn	19637	156	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna sp. KACHI24
24102956	24102956	PRJNA630162_P_NODE_101699_length_184_cov_4.281481_g100176_i0	PRJNA630162	101699	184	4.281481	7.87792504	Microbacteriaceae	85023	Bacteria	Bacteria	259	8.61e-65	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g100176	i0	93.182	161.902173913043	176	12	96	0	4	179	520035	520210	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	29790	259	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
27567220	27567220	PRJNA630162_P_NODE_109844_length_180_cov_1.229008_g108321_i0	PRJNA630162	109844	180	1.229008	2.2122144	Rhodoluna	529883	Bacteria	Bacteria	113	2.97e-29	NR	MBP6087339.1	1969481	g108321	i0	98.2	5.7	57	1	95	0	171	1	1	57	MBP6087339.1 imidazole glycerol phosphate synthase subunit HisF [Rhodoluna sp.]	diamond	1026	113	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
30965538	30965538	PRJNA630162_P_NODE_153994_length_163_cov_2.456140_g152471_i0	PRJNA630162	153994	163	2.45614	4.0035082	Rhodoluna sp.	1969481	Bacteria	Bacteria	91.7	3.35e-21	NR	MBP6087730.1	1969481	g152471	i0	98.1	2.98159509202454	54	1	99.4	0	2	163	93	146	MBP6087730.1 ABC transporter substrate-binding protein [Rhodoluna sp.]	diamond	486	91.7	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp.
31831603	31831603	PRJNA630162_P_NODE_116757_length_176_cov_1.590551_g115234_i0	PRJNA630162	116757	176	1.590551	2.79936976	Rhodoluna	529883	Bacteria	Bacteria	99.4	1.7999999999999997e-24	NR	MCX8529268.1	1969481	g115234	i0	91.2	2.91477272727273	57	5	97.2	0	6	176	1	57	MCX8529268.1 bacteriorhodopsin [Rhodoluna sp.]	diamond	513	100	0.994	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);;