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

5 rows where analysis = "blastn", bioproject = "PRJNA680334" 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
12129263	12129263	PRJNA680334_S_NODE_49150_length_193_cov_2.043750_g48664_i0	PRJNA680334	49150	193	2.04375	3.9444375	Myxococcus stipitatus	83455	Bacteria	Bacteria	119	1.62e-22	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g48664	i0	82.143	0.725388601036269	140	23	72	2	55	193	5023671	5023533	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	140	119	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
15953333	15953333	PRJNA680334_S_NODE_90753_length_158_cov_5.248000_g90267_i0	PRJNA680334	90753	158	5.248	8.29184	Myxococcales bacterium UTMC 4097	1826750	Bacteria	Bacteria	261	1.99e-65	NTclustered	gi\|1015860418\|gb\|KU923380.1\|	1826750	g90267	i0	96.795	99.7721518987342	156	5	99	0	3	158	1148	1303	Myxobacteria bacterium UTMC 4097 16S ribosomal RNA gene, partial sequence	blastn	15764	261	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium UTMC 4097
22326868	22326868	PRJNA680334_S_NODE_27498_length_230_cov_32.035533_g27012_i0	PRJNA680334	27498	230	32.035533	73.6817259	uncultured Haliangium sp.	373538	Bacteria	Bacteria	220	5.32e-53	NTclustered	gi\|310755276\|gb\|HQ213166.1\|	373538	g27012	i0	93.333	6.2695652173913	150	8	65	2	61	209	930	1078	Uncultured Haliangium sp. clone 3_E01 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	1442	220	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	uncultured Haliangium sp.
24121254	24121254	PRJNA680334_S_NODE_56099_length_185_cov_2.394737_g55613_i0	PRJNA680334	56099	185	2.394737	4.43026345	root	1	Root_unresolved	Root_unresolved	259	8.67e-65	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g55613	i0	93.22	85.5945945945946	177	10	95	2	11	185	1622	1798	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	15835	261	0.992337164750958	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
24121331	24121331	PRJNA680334_S_NODE_82859_length_163_cov_2.900000_g82373_i0	PRJNA680334	82859	163	2.9	4.727	Sorangium	39643	Bacteria	Bacteria	263	5.77e-66	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g82373	i0	95.706	105.969325153374	163	7	100	0	1	163	3449509	3449671	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	17273	263	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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