metadata: contig_metadata: 5 rows where bioproject = "PRJNA599208" and tax

5 rows where bioproject = "PRJNA599208" and tax_phylum = "Myxococcota"

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
4969534	4969534	PRJNA599208_P_NODE_11584_length_193_cov_2.935897_g11388_i0	PRJNA599208	11584	193	2.935897	5.66628121	Pendulispora	3375062	Bacteria	Bacteria	309	8.94e-80	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g11388	i0	95.812	164.523316062176	191	8	99	0	3	193	7287685	7287495	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	31753	309	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
10776560	10776560	PRJNA599208_P_NODE_5529_length_335_cov_1.818792_g5333_i0	PRJNA599208	5529	335	1.818792	6.0929532	Chondromyces crocatus	52	Bacteria	Bacteria	412	1.2599999999999998e-110	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g5333	i0	88.856	138.588059701493	341	30	100	7	1	335	1431240	1430902	Chondromyces crocatus strain Cm c5, complete genome	blastn	46427	412	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
13326147	13326147	PRJNA599208_P_NODE_14011_length_169_cov_1.757576_g13815_i0	PRJNA599208	14011	169	1.757576	2.97030344	Pendulispora rubella	2741070	Bacteria	Bacteria	99	1.79e-16	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g13815	i0	79.592	13.3727810650888	147	22	85	6	16	158	7289689	7289547	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	2260	99	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
26649853	26649853	PRJNA599208_P_NODE_16521_length_151_cov_2.377193_g16325_i0	PRJNA599208	16521	151	2.377193	3.58956143	Pseudomonadati	3379134	Bacteria	Bacteria	78.6	9.14e-16	NR	MDL2122647.1	2026735	g16325	i0	70.8	2.86092715231788	48	14	95.4	0	146	3	172	219	MDL2122647.1 toll/interleukin-1 receptor domain-containing protein [Deltaproteobacteria bacterium]	diamond	432	79.3	0.991172761664565	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32198000	32198000	PRJNA599208_P_NODE_15198_length_160_cov_1.544715_g15002_i0	PRJNA599208	15198	160	1.544715	2.471544	Myxococcota bacterium	2818507	Bacteria	Bacteria	40.8	0.0397	NR	MDG1479774.1	2818507	g15002	i0	36.2	0.88125	47	30	88.1	0	159	19	55	101	MDG1479774.1 hypothetical protein [Myxococcota bacterium]	diamond	141	40.8	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota 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);;