metadata: contig_metadata: 6 rows where bioproject = "PRJNA964500" and tax

6 rows where bioproject = "PRJNA964500" 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
3817498	3817498	PRJNA964500_S_NODE_5263_length_242_cov_10.971831_g5171_i0	PRJNA964500	5263	242	10.971831	26.55183102	Sorangium	39643	Bacteria	Bacteria	213	9.45e-51	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g5171	i0	84.722	351.53305785124	216	30	88	3	2	214	13	228	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	85071	213	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5093810	5093810	PRJNA964500_S_NODE_5304_length_241_cov_77.382075_g5212_i0	PRJNA964500	5304	241	77.382075	186.49080075	Pseudomonadati	3379134	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|28395338\|gb\|AY190663.1\|	56	g5212	i0	100	610.979253112033	241	0	100	0	1	241	911	671	Polyangium cellulosum strain So9881 clone 2 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	147246	446	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7319954	7319954	PRJNA964500_S_NODE_8706_length_198_cov_2.751479_g8614_i0	PRJNA964500	8706	198	2.751479	5.44792842	Corallococcus coralloides	184914	Bacteria	Bacteria	209	9.63e-50	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g8614	i0	86.458	53.2575757575758	192	24	96	2	8	198	4201616	4201806	Corallococcus coralloides DSM 2259, complete genome	blastn	10545	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
11145477	11145477	PRJNA964500_S_NODE_2509_length_320_cov_5.718213_g2417_i0	PRJNA964500	2509	320	5.718213	18.2982816	Labilithrix luteola	1391654	Bacteria	Bacteria	483	8.979999999999997e-132	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2417	i0	95.098	134.853125	306	15	96	0	1	306	3942456	3942151	Labilithrix luteola strain DSM 27648, complete genome	blastn	43153	483	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11469358	11469358	PRJNA964500_S_NODE_8189_length_203_cov_2.287356_g8097_i0	PRJNA964500	8189	203	2.287356	4.64333268	Myxococcales	29	Bacteria	Bacteria	261	2.7000000000000007e-65	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g8097	i0	90.452	236.167487684729	199	18	98	1	1	198	1137	939	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	47942	261	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
14969785	14969785	PRJNA964500_S_NODE_4012_length_270_cov_3.970954_g3920_i0	PRJNA964500	4012	270	3.970954	10.7215758	Pendulispora brunnea	2905690	Bacteria	Bacteria	355	1.6799999999999996e-93	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g3920	i0	90.37	141.740740740741	270	26	100	0	1	270	7408374	7408105	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	38270	355	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea

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