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

5 rows where bioproject = "PRJNA764222", 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_species
10948875	10948875	PRJNA764222_S_NODE_28449_length_175_cov_1.226562_g28291_i0	PRJNA764222	28449	175	1.226562	2.1464835	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	104	3.0499999999999998e-24	NR	HSN13013.1	2510643	g28291	i0	85.7	4.74857142857143	56	8	96	0	8	175	120	175	HSN13013.1 NADP-dependent malic enzyme [Anaeromyxobacteraceae bacterium]	diamond	831	104	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacteraceae bacterium
27590516	27590516	PRJNA764222_S_NODE_11044_length_256_cov_1.583732_g10886_i0	PRJNA764222	11044	256	1.583732	4.05435392	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	50.1	1.15e-4	NR	MDR2893224.1	2026735	g10886	i0	58.8	2.19140625	34	14	39.8	0	104	3	1709	1742	MDR2893224.1 translocation/assembly module TamB domain-containing protein [Deltaproteobacteria bacterium]	diamond	561	50.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
27653639	27653639	PRJNA764222_S_NODE_23224_length_195_cov_2.844595_g23066_i0	PRJNA764222	23224	195	2.844595	5.54696025	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	72.8	4.97e-13	NR	GHV53272.1	2026735	g23066	i0	58.1	0.953846153846154	62	26	95.4	0	191	6	1017	1078	GHV53272.1 hypothetical protein FACS1894206_03630 [Deltaproteobacteria bacterium]	diamond	186	72.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
30969656	30969656	PRJNA764222_S_NODE_26234_length_183_cov_2.823529_g26076_i0	PRJNA764222	26234	183	2.823529	5.16705807	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42.4	0.0229	NR	MBW2732640.1	2026735	g26076	i0	41.3	0.754098360655738	46	26	73.8	1	142	8	489	534	MBW2732640.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	138	42.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia			Deltaproteobacteria bacterium
32139694	32139694	PRJNA764222_S_NODE_3018_length_353_cov_1.313725_g2860_i0	PRJNA764222	3018	353	1.313725	4.63744925	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	144	1.3e-39	NR	MBW1645232.1	2026735	g2860	i0	63	2.57507082152974	108	40	91.8	0	325	2	8	115	MBW1645232.1 tripartite tricarboxylate transporter substrate binding protein [Deltaproteobacteria bacterium]	diamond	909	144	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);;