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

5 rows where bioproject = "PRJNA1120586" 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
14305305	14305305	PRJNA1120586_P_NODE_54772_length_212_cov_2.552448_g54581_i0	PRJNA1120586	54772	212	2.552448	5.41118976	Pendulispora rubella	2741070	Bacteria	Bacteria	230	8.02e-56	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g54581	i0	86.256	278.830188679245	211	29	99	0	1	211	7287286	7287076	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	59112	230	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
14305308	14305308	PRJNA1120586_P_NODE_55212_length_194_cov_5.760000_g55021_i0	PRJNA1120586	55212	194	5.76	11.1744	Pendulispora albinea	2741071	Bacteria	Bacteria	147	7.469999999999999e-31	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g55021	i0	84.314	145.494845360825	153	21	78	2	1	152	3588205	3588055	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	28226	147	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
23228772	23228772	PRJNA1120586_P_NODE_7179_length_434_cov_7.745205_g6988_i0	PRJNA1120586	7179	434	7.745205	33.6141897	Chondromyces crocatus	52	Bacteria	Bacteria	431	4.61e-116	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g6988	i0	85.442	130.520737327189	419	55	95	6	3	416	1431233	1430816	Chondromyces crocatus strain Cm c5, complete genome	blastn	56646	431	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
27418008	27418008	PRJNA1120586_P_NODE_39063_length_236_cov_1.724551_g38872_i0	PRJNA1120586	39063	236	1.724551	4.06994036	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	95.5	9.04e-21	NR	MCA2978934.1	2484252	g38872	i0	53.8	1.01694915254237	80	34	97.9	1	4	234	338	417	MCA2978934.1 hypothetical protein [Myxococcaceae bacterium]	diamond	240	95.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28101536	28101536	PRJNA1120586_P_NODE_20125_length_299_cov_1.082609_g19934_i0	PRJNA1120586	20125	299	1.082609	3.23700091	Pseudomonadati	3379134	Bacteria	Bacteria	119	6.95e-29	NR	WP_136967725.1	889274	g19934	i0	60.6	4.93645484949833	99	39	99.3	0	1	297	1992	2090	WP_136967725.1 non-ribosomal peptide synthetase/type I polyketide synthase [Polyangium sorediatum]	diamond	1476	119	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium sorediatum

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