metadata: contig_metadata: 7 rows where bioproject = "PRJNA558770" and tax

7 rows where bioproject = "PRJNA558770" 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
539923	539923	PRJNA558770_P_NODE_245461_length_234_cov_2.412060_g243456_i0	PRJNA558770	245461	234	2.41206	5.6442204	Aquiluna sp. KACHI24	2968831	Bacteria	Bacteria	78.7	3.46e-10	NTclustered	gi\|2283401075\|dbj\|AP026677.1\|	2968831	g243456	i0	91.228	1.6709401709401701	57	5	24	0	3	59	405725	405781	Aquiluna sp. KACHI24 DNA, complete genome	blastn	391	78.7	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna sp. KACHI24
3091077	3091077	PRJNA558770_P_NODE_257323_length_234_cov_2.150754_g255318_i0	PRJNA558770	257323	234	2.150754	5.03276436	Aquiluna	529881	Bacteria	Bacteria	82.4	7.22e-17	NR	WP_173493657.1	2499157	g255318	i0	61	3.94871794871795	77	20	98.7	1	233	3	59	125	WP_173493657.1 cytochrome c [Aquiluna borgnonia]	diamond	924	82.4	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna borgnonia
10744103	10744103	PRJNA558770_P_NODE_239469_length_234_cov_2.552764_g237464_i0	PRJNA558770	239469	234	2.552764	5.97346776	Candidatus Rhodoluna planktonica	535712	Bacteria	Bacteria	121	5.66e-23	NTclustered	gi\|1092201385\|gb\|CP015208.1\|	535712	g237464	i0	95.946	2.31196581196581	74	3	32	0	2	75	1178578	1178505	Candidatus Rhodoluna planktonica strain MWH-Dar1 chromosome, complete genome	blastn	541	121	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Candidatus Rhodoluna planktonica
10745359	10745359	PRJNA558770_P_NODE_324709_length_233_cov_7.595960_g322704_i0	PRJNA558770	324709	233	7.59596	17.6985868	Aquiluna borgnonia	2499157	Bacteria	Bacteria	401	1.7999999999999993e-107	NTclustered	gi\|1850312474\|gb\|CP054056.1\|	2499157	g322704	i0	97.845	152.532188841202	232	5	99	0	1	232	856112	856343	Aquiluna borgnonia strain 15G-AUS-rot chromosome, complete genome	blastn	35540	401	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna borgnonia
24765047	24765047	PRJNA558770_P_NODE_181340_length_234_cov_4.582915_g179335_i0	PRJNA558770	181340	234	4.582915	10.7240211	Rhodoluna lacicola	529884	Bacteria	Bacteria	111	3.41e-20	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g179335	i0	95.652	0.58974358974359	69	3	29	0	162	230	47101	47169	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	138	111	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
27268487	27268487	PRJNA558770_P_NODE_152163_length_234_cov_6.266332_g150158_i0	PRJNA558770	152163	234	6.266332	14.66321688	Aquiluna sp.	2053504	Bacteria	Bacteria	48.1	3.61e-4	NR	MCF8524480.1	2053504	g150158	i0	88	0.320512820512821	25	3	32.1	0	160	234	69	93	MCF8524480.1 SURF1 family protein [Aquiluna sp.]	diamond	75	48.1	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna sp.
30078793	30078793	PRJNA558770_P_NODE_293852_length_234_cov_1.452261_g291847_i0	PRJNA558770	293852	234	1.452261	3.39829074	Aquiluna sp.	2053504	Bacteria	Bacteria	69.3	3.08e-13	NR	MCF8524465.1	2053504	g291847	i0	54.4	0.871794871794872	68	10	87.2	1	232	29	53	99	MCF8524465.1 tRNA (adenosine(37)-N6)-threonylcarbamoyltransferase complex ATPase subunit type 1 TsaE [Aquiluna sp.]	diamond	204	69.3	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna 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);;