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

5 rows where bioproject = "PRJNA380660", 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
4902196	4902196	PRJNA380660_P_NODE_9984_length_207_cov_30.842697_g9584_i0	PRJNA380660	9984	207	30.842697	63.84438279	Rhodoluna	529883	Bacteria	Bacteria	322	1.25e-83	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g9584	i0	98.361	222.777777777778	183	3	88	0	25	207	477217	477399	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	46115	322	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
5505900	5505900	PRJNA380660_P_NODE_12145_length_166_cov_1.124088_g11745_i0	PRJNA380660	12145	166	1.124088	1.86598608	Aquiluna sp. KACHI24	2968831	Bacteria	Bacteria	159	7.959999999999998e-35	NTclustered	gi\|2283401075\|dbj\|AP026677.1\|	2968831	g11745	i0	84.337	1.46987951807229	166	22	99	4	2	165	1383963	1384126	Aquiluna sp. KACHI24 DNA, complete genome	blastn	244	159	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna sp. KACHI24
6177175	6177175	PRJNA380660_P_NODE_7685_length_256_cov_6.052863_g7285_i0	PRJNA380660	7685	256	6.052863	15.49532928	Rhodoluna	529883	Bacteria	Bacteria	390	4.3399999999999997e-104	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g7285	i0	94.141	192.06640625	256	15	100	0	1	256	478160	478415	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	49169	390	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
7452206	7452206	PRJNA380660_P_NODE_7686_length_256_cov_5.594714_g7286_i0	PRJNA380660	7686	256	5.594714	14.32246784	Rhodoluna	529883	Bacteria	Bacteria	407	4.31e-109	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g7286	i0	97.095	135.5703125	241	7	94	0	16	256	476846	477086	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	34706	407	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
21475931	21475931	PRJNA380660_P_NODE_4197_length_396_cov_25.643052_g3802_i0	PRJNA380660	4197	396	25.643052	101.54648592	Rhodoluna	529883	Bacteria	Bacteria	387	9.15e-103	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g3802	i0	84.729	275.378787878788	406	41	100	18	1	396	477900	478294	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	109050	387	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);;