metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA509429" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA509429" 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
3036277	3036277	PRJNA509429_P_NODE_21443_length_286_cov_137.410359_g20615_i0	PRJNA509429	21443	286	137.410359	392.99362674	Candidatus Aquiluna sp. UB-MaderosW2red	1855377	Bacteria	Bacteria	494	3.65e-135	NTclustered	gi\|1081426101\|emb\|LT627734.1\|	1855377	g20615	i0	97.895	181.321678321678	285	6	99	0	2	286	1309288	1309004	Candidatus Aquiluna sp. UB-MaderosW2red genome assembly, chromosome: I	blastn	51858	494	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Candidatus Aquiluna sp. UB-MaderosW2red
5589087	5589087	PRJNA509429_P_NODE_5645_length_610_cov_38.878261_g4945_i0	PRJNA509429	5645	610	38.878261	237.1573921	Rhodoluna lacicola	529884	Bacteria	Bacteria	843	0	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g4945	i0	92.712	193.091803278689	590	34	96	8	23	610	517126	517708	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	117786	843	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
13864543	13864543	PRJNA509429_P_NODE_2971_length_820_cov_155.415287_g2452_i0	PRJNA509429	2971	820	155.415287	1274.4053534	Rhodoluna	529883	Bacteria	Bacteria	1142	0	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g2452	i0	96.657	181.936585365854	688	22	88	1	1	688	477359	478045	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	149188	1142	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna limnophila
18336861	18336861	PRJNA509429_P_NODE_18015_length_323_cov_11.805556_g17187_i0	PRJNA509429	18015	323	11.805556	38.13194588	Rhodoluna lacicola	529884	Bacteria	Bacteria	512	1.16e-140	NTclustered	gi\|649018083\|gb\|CP007490.1\|	529884	g17187	i0	95.342	153.473684210526	322	15	99	0	1	322	519920	520241	Rhodoluna lacicola strain MWH-Ta8 chromosome, complete genome	blastn	49572	512	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Rhodoluna	Rhodoluna lacicola
24062668	24062668	PRJNA509429_P_NODE_17639_length_327_cov_69.308219_g16811_i0	PRJNA509429	17639	327	69.308219	226.63787613	Rhodoluna	529883	Bacteria	Bacteria	518	2.5199999999999998e-142	NTclustered	gi\|1666461687\|gb\|CP040509.1\|	232537	g16811	i0	95.399	170.553516819572	326	13	99	2	1	325	476523	476847	Rhodoluna limnophila strain 27D-LEPI chromosome, complete genome	blastn	55771	523	0.990439770554493	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);;