metadata: contig_metadata: 5 rows where bioproject = "PRJEB6054", tax_phylum = "Myxococcota" and tax

5 rows where bioproject = "PRJEB6054", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26067133	26067133	PRJEB6054_S_NODE_10549_length_173_cov_11.949275_g10460_i0	PRJEB6054	10549	173	11.949275	20.67224575	Pendulispora rubella	2741070	Bacteria	Bacteria	219	1.3499999999999999e-52	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g10460	i0	89.595	138.878612716763	173	16	99	2	1	171	7289876	7290048	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	24026	219	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
26160020	26160020	PRJEB6054_S_NODE_10557_length_173_cov_8.601449_g10468_i0	PRJEB6054	10557	173	8.601449	14.88050677	root	1	Root_unresolved	Root_unresolved	209	8.15e-50	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g10468	i0	88.439	106.35838150289	173	20	100	0	1	173	7289843	7290015	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	18400	211	0.990521327014218	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
26160079	26160079	PRJEB6054_S_NODE_4149_length_235_cov_21.105000_g4060_i0	PRJEB6054	4149	235	21.105	49.59675	Corallococcus	83461	Bacteria	Bacteria	222	1.52e-53	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g4060	i0	84.821	203.042553191489	224	31	96	3	9	230	142638	142416	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	47715	222	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
26475694	26475694	PRJEB6054_S_NODE_3168_length_261_cov_2.123894_g3079_i0	PRJEB6054	3168	261	2.123894	5.54336334	Pendulispora albinea	2741071	Bacteria	Bacteria	267	7.81e-67	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g3079	i0	87.137	147.60153256705	241	24	91	7	1	238	3589094	3589330	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	38524	267	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
32945949	32945949	PRJEB6054_S_NODE_10106_length_176_cov_6.893617_g10017_i0	PRJEB6054	10106	176	6.893617	12.13276592	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42	0.0283	NR	NOS35136.1	2026735	g10017	i0	43.8	0.818181818181818	48	26	81.8	1	23	166	260	306	NOS35136.1 DNA/RNA nuclease SfsA [Deltaproteobacteria bacterium]	diamond	144	42	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium

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