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

9 rows where bioproject = "PRJNA193544", 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	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
6743581	6743581	PRJNA193544_S_NODE_3386_length_152_cov_34.081301_g3371_i0	PRJNA193544	3386	152	34.081301	51.80357752	Rhodoluna lacicola	529884	Bacteria	Bacteria	254	3.17e-63	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g3371	i0	96.711	191.934210526316	152	5	100	1	152	518146	518297	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	29174	254	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
8707964	8707964	PRJNA193544_S_NODE_1527_length_212_cov_21.590164_g1512_i0	PRJNA193544	1527	212	21.590164	45.77114768	Rhodoluna	529883	Bacteria	Bacteria	368	1.63e-97	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g1512	i0	98.558	145.165094339623	208	3	98	5	212	476737	476530	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	30775	368	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
11844484	11844484	PRJNA193544_S_NODE_870_length_264_cov_13.953191_g855_i0	PRJNA193544	870	264	13.953191	36.83642424	Rhodoluna sp. KAS3	942880	Bacteria	Bacteria	392	1.25e-104	NTclustered	gi\|2318877619\|dbj\|AP026910.1\|	942880	g855	i0	95.161	156.825757575758	248	12	94	1	248	453976	454223	Rhodoluna sp. KAS3 DNA, complete genome	blastn	41402	392	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna sp. KAS3
13808654	13808654	PRJNA193544_S_NODE_2411_length_177_cov_10.148649_g2396_i0	PRJNA193544	2411	177	10.148649	17.96310873	Rhodoluna	529883	Bacteria	Bacteria	294	2.25e-75	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g2396	i0	96.61	158.598870056497	177	6	100	1	177	477061	477237	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	28072	294	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
20181298	20181298	PRJNA193544_S_NODE_3196_length_156_cov_3.527559_g3181_i0	PRJNA193544	3196	156	3.527559	5.50299204	Rhodoluna	529883	Bacteria	Bacteria	248	1.5299999999999998e-61	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g3181	i0	96.644	173.339743589744	149	5	96	8	156	477857	477709	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	27041	248	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
20181305	20181305	PRJNA193544_S_NODE_716_length_284_cov_414.011765_g701_i0	PRJNA193544	716	284	414.011765	1175.7934126	Rhodoluna	529883	Bacteria	Bacteria	348	2.99e-91	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g701	i0	96.226	140.612676056338	212	8	75	73	284	479049	478838	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	39934	348	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
22042511	22042511	PRJNA193544_S_NODE_1858_length_197_cov_20866.738095_g1843_i0	PRJNA193544	1858	197	20866.738095	41107.47404715	Rhodoluna lacicola	529884	Bacteria	Bacteria	270	4.33e-68	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g1843	i0	96.341	139.553299492386	164	6	83	34	197	520223	520060	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	27492	270	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
22042550	22042550	PRJNA193544_S_NODE_838_length_267_cov_17.382353_g823_i0	PRJNA193544	838	267	17.382353	46.41088251	Rhodoluna limnophila	232537	Bacteria	Bacteria	425	1.25e-114	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g823	i0	97.211	148.310861423221	251	7	94	17	267	477029	476779	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	39599	425	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
24007224	24007224	PRJNA193544_S_NODE_299_length_360_cov_32.429003_g284_i0	PRJNA193544	299	360	32.429003	116.7444108	Rhodoluna	529883	Bacteria	Bacteria	560	4.58e-155	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g284	i0	94.722	181.377777777778	360	19	100	1	360	478838	479197	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	65296	560	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);;