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

15 rows where bioproject = "PRJNA168635", tax_clade = "Luna-1 subcluster" and tax_phylum = "Actinomycetota"

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
7432326	7432326	PRJNA168635_P_NODE_806_length_838_cov_52.975919_g583_i0	PRJNA168635	806	838	52.975919	443.93820122	Rhodoluna	529883	Bacteria	Bacteria	1319	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g583	i0	95.131	167.027446300716	842	32	99	7	2	838	477597	478434	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	139969	1319	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
10568625	10568625	PRJNA168635_P_NODE_28289_length_166_cov_0.888889_g27873_i0	PRJNA168635	28289	166	0.888889	1.47555574	Aquiluna borgnonia	2499157	Bacteria	Bacteria	248	1.65e-61	NTclustered	gi\|1850312474\|gb\|CP054056.1\|	2499157	g27873	i0	93.491	11.5963855421687	169	7	100	4	1	166	1197190	1197357	Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome	blastn	1925	248	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna borgnonia
13118126	13118126	PRJNA168635_P_NODE_15131_length_206_cov_10.375796_g14715_i0	PRJNA168635	15131	206	10.375796	21.37413976	Aquiluna borgnonia	2499157	Bacteria	Bacteria	342	9.539999999999999e-90	NTclustered	gi\|1850312474\|gb\|CP054056.1\|	2499157	g14715	i0	96.602	188.31067961165	206	7	100	0	1	206	854036	854241	Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome	blastn	38792	342	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna borgnonia
13807714	13807714	PRJNA168635_P_NODE_3291_length_459_cov_449.597561_g2894_i0	PRJNA168635	3291	459	449.597561	2063.65280499	Rhodoluna	529883	Bacteria	Bacteria	832	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g2894	i0	99.346	175.050108932462	459	3	100	0	1	459	478777	479235	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	80348	832	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
15667234	15667234	PRJNA168635_P_NODE_17953_length_189_cov_13.300000_g17537_i0	PRJNA168635	17953	189	13.3	25.137	Rhodoluna lacicola	529884	Bacteria	Bacteria	278	2.46e-70	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g17537	i0	93.122	166.899470899471	189	13	100	0	1	189	520223	520035	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	31544	278	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
15667363	15667363	PRJNA168635_P_NODE_25893_length_168_cov_2.025210_g25477_i0	PRJNA168635	25893	168	2.02521	3.4023528	Rhodoluna lacicola	529884	Bacteria	Bacteria	161	2.25e-35	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g25477	i0	92.793	55.4047619047619	111	8	66	0	1	111	669259	669149	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	9308	161	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
16941577	16941577	PRJNA168635_P_NODE_15374_length_204_cov_9.490323_g14958_i0	PRJNA168635	15374	204	9.490323	19.36025892	Aquiluna borgnonia	2499157	Bacteria	Bacteria	344	2.62e-90	NTclustered	gi\|1850312474\|gb\|CP054056.1\|	2499157	g14958	i0	97.525	242.509803921569	202	4	99	1	4	204	855929	855728	Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome	blastn	49472	344	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna borgnonia
16942026	16942026	PRJNA168635_P_NODE_854_length_821_cov_59.136010_g621_i0	PRJNA168635	854	821	59.13601	485.5066421	Rhodoluna lacicola	529884	Bacteria	Bacteria	726	0	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g621	i0	99.254	408.543239951279	402	3	96	0	5	406	517302	517703	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	335414	726	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
18216363	18216363	PRJNA168635_P_NODE_3475_length_447_cov_8.577889_g3075_i0	PRJNA168635	3475	447	8.577889	38.34316383	Aquiluna sp. KACHI24	2968831	Bacteria	Bacteria	732	0	NTclustered	gi\|2283401075\|dbj\|AP026677.1\|	2968831	g3075	i0	96.197	189.876957494407	447	17	100	0	1	447	475577	476023	Aquiluna sp. KACHI24 DNA, complete genome	blastn	84875	732	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna sp. KACHI24
18216515	18216515	PRJNA168635_P_NODE_9975_length_262_cov_373.037559_g9560_i0	PRJNA168635	9975	262	373.037559	977.35840458	Rhodoluna lacicola	529884	Bacteria	Bacteria	449	7.26e-122	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g9560	i0	97.71	256.759541984733	262	5	100	1	1	262	517792	518052	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	67271	449	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
19490445	19490445	PRJNA168635_P_NODE_23156_length_173_cov_3.330645_g22740_i0	PRJNA168635	23156	173	3.330645	5.76201585	Candidatus Aquiluna sp. UB-MaderosW2red	1855377	Bacteria	Bacteria	110	8.5e-20	NTclustered	gi\|1081426101\|emb\|LT627734.1\|	1855377	g22740	i0	83.471	2.69364161849711	121	16	69	4	3	121	160112	160230	Candidatus Aquiluna sp. UB-MaderosW2red genome assembly, chromosome: I	blastn	466	110	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Candidatus Aquiluna sp. UB-MaderosW2red
19490707	19490707	PRJNA168635_P_NODE_7336_length_312_cov_65.676806_g6924_i0	PRJNA168635	7336	312	65.676806	204.91163472	Rhodoluna lacicola	529884	Bacteria	Bacteria	507	5.18e-139	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g6924	i0	95.886	115.032051282051	316	7	100	6	1	312	517066	517379	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	35890	507	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
24006375	24006375	PRJNA168635_P_NODE_959_length_782_cov_71.836289_g583_i1	PRJNA168635	959	782	71.836289	561.75977998	Rhodoluna	529883	Bacteria	Bacteria	1310	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g583	i1	96.943	159.523017902813	785	16	99	6	2	782	477597	478377	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	124747	1310	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
24590955	24590955	PRJNA168635_P_NODE_4560_length_394_cov_13.594203_g4156_i0	PRJNA168635	4560	394	13.594203	53.56115982	Aquiluna borgnonia	2499157	Bacteria	Bacteria	684	0	NTclustered	gi\|1850312474\|gb\|CP054056.1\|	2499157	g4156	i0	97.97	180.048223350254	394	8	100	0	1	394	855979	856372	Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome	blastn	70939	684	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna borgnonia
31464620	31464620	PRJNA168635_P_NODE_31436_length_162_cov_3.610619_g31020_i0	PRJNA168635	31436	162	3.610619	5.84920278	Rhodoluna sp.	1969481	Bacteria	Bacteria	110	1.51e-27	NR	MBP7835741.1	1969481	g31020	i0	96.2	0.981481481481482	53	2	98.1	0	3	161	274	326	MBP7835741.1 hypothetical protein [Rhodoluna sp.]	diamond	159	110	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);;