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

7 rows where bioproject = "PRJNA543299", 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
15812379	15812379	PRJNA543299_P_NODE_20873_length_167_cov_0.830508_g20716_i0	PRJNA543299	20873	167	0.830508	1.38694836	Candidatus Aquiluna sp. UB-MaderosW2red	1855377	Bacteria	Bacteria	265	1.65e-66	NTclustered	gi\|1081426101\|emb\|LT627734.1\|	1855377	g20716	i0	96.835	162.604790419162	158	5	95	0	10	167	1309766	1309923	Candidatus Aquiluna sp. UB-MaderosW2red genome assembly, chromosome: I	blastn	27155	265	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Candidatus Aquiluna sp. UB-MaderosW2red
15812412	15812412	PRJNA543299_P_NODE_22393_length_165_cov_0.879310_g22236_i0	PRJNA543299	22393	165	0.87931	1.4508615	Rhodoluna lacicola	529884	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g22236	i0	92.771	2.01212121212121	166	11	100	1	1	165	1411076	1411241	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	332	239	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
20911597	20911597	PRJNA543299_P_NODE_18437_length_175_cov_1.214286_g18280_i0	PRJNA543299	18437	175	1.214286	2.1250005	Aquiluna borgnonia	2499157	Bacteria	Bacteria	311	2.2e-80	NTclustered	gi\|1850312474\|gb\|CP054056.1\|	2499157	g18280	i0	98.851	17.7371428571429	174	2	99	0	2	175	855922	856095	Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome	blastn	3104	311	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna borgnonia
28292763	28292763	PRJNA543299_P_NODE_20346_length_167_cov_0.864407_g20189_i0	PRJNA543299	20346	167	0.864407	1.44355969	Actinomycetes	1760	Bacteria	Bacteria	103	3.66e-24	NR	WP_138316302.1	232537	g20189	i0	100	39.5209580838323	55	0	98.8	0	166	2	1000	1054	WP_138316302.1 glutamate synthase large subunit [Rhodoluna limnophila]	diamond	6600	103	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
28545731	28545731	PRJNA543299_P_NODE_20567_length_167_cov_0.864407_g20410_i0	PRJNA543299	20567	167	0.864407	1.44355969	Rhodoluna	529883	Bacteria	Bacteria	108	7.98e-26	NR	WP_038502617.1	529884	g20410	i0	98.2	3.95209580838323	55	1	98.8	0	166	2	330	384	WP_038502617.1 AMP-dependent synthetase/ligase [Rhodoluna lacicola]	diamond	660	109	0.990825688073395	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
29177154	29177154	PRJNA543299_P_NODE_26169_length_161_cov_0.910714_g26012_i0	PRJNA543299	26169	161	0.910714	1.46624954	Rhodoluna	529883	Bacteria	Bacteria	114	3.14e-28	NR	WP_144239031.1	529884	g26012	i0	98.1	8.88819875776398	53	1	98.8	0	2	160	344	396	WP_144239031.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex transferase subunit TsaD [Rhodoluna lacicola]	diamond	1431	115	0.991304347826087	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
32069357	32069357	PRJNA543299_P_NODE_20838_length_167_cov_0.864407_g20681_i0	PRJNA543299	20838	167	0.864407	1.44355969	Rhodoluna lacicola	529884	Bacteria	Bacteria	72	4.26e-13	NR	WP_038502101.1	529884	g20681	i0	91.9	0.664670658682635	37	3	66.5	0	57	167	1	37	WP_038502101.1 4-hydroxy-tetrahydrodipicolinate synthase [Rhodoluna lacicola]	diamond	111	72	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola

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