metadata: contig_metadata: 6 rows where bioproject = "PRJNA784979" and tax

6 rows where bioproject = "PRJNA784979" 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
6317397	6317397	PRJNA784979_S_NODE_4725_length_219_cov_7.682353_g4683_i0	PRJNA784979	4725	219	7.682353	16.82435307	Rhodoluna	529883	Bacteria	Bacteria	379	7.829999999999998e-101	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g4683	i0	99.522	154.474885844749	209	0	95	1	3	211	478981	478774	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	33830	379	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
10141972	10141972	PRJNA784979_S_NODE_1768_length_356_cov_6.931596_g1726_i0	PRJNA784979	1768	356	6.931596	24.67648176	Rhodoluna	529883	Bacteria	Bacteria	523	5.939999999999999e-144	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g1726	i0	96.519	209.466292134831	316	11	89	0	37	352	477742	478057	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	74570	523	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
14794158	14794158	PRJNA784979_S_NODE_7132_length_189_cov_3.100000_g7090_i0	PRJNA784979	7132	189	3.1	5.859	Rhodoluna lacicola	529884	Bacteria	Bacteria	287	4.08e-73	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g7090	i0	96.045	148.936507936508	177	6	94	1	3	179	520059	520234	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	28149	287	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
15241798	15241798	PRJNA784979_S_NODE_3032_length_265_cov_8.310185_g2990_i0	PRJNA784979	3032	265	8.310185	22.02199025	Microbacteriaceae	85023	Bacteria	Bacteria	457	4.39e-124	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g2990	i0	98.456	195.471698113208	259	4	98	0	1	259	518101	518359	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	51800	457	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
17791113	17791113	PRJNA784979_S_NODE_894_length_595_cov_169.146520_g854_i0	PRJNA784979	894	595	169.14652	1006.421794	Rhodoluna	529883	Bacteria	Bacteria	800	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g854	i0	95.6	154.709243697479	500	21	84	1	7	506	477544	477046	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	92052	800	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
19065074	19065074	PRJNA784979_S_NODE_4215_length_229_cov_1.511111_g4173_i0	PRJNA784979	4215	229	1.511111	3.46044419	Rhodoluna	529883	Bacteria	Bacteria	366	6.42e-97	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g4173	i0	96	162.995633187773	225	9	98	0	1	225	476822	477046	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	37326	366	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila

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