metadata: contig_metadata: 10 rows where bioproject = "PRJEB14664", tax_phylum = "Myxococcota" and tax

10 rows where bioproject = "PRJEB14664", 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_genus	tax_species
26621473	26621473	PRJEB14664_P_NODE_10781_length_229_cov_1.845361_g10651_i0	PRJEB14664	10781	229	1.845361	4.22587669	Myxococcales bacterium	2026763	Bacteria	Bacteria	49.7	1.1e-4	NR	MDP1916818.1	2026763	g10651	i0	41.3	0.982532751091703	75	33	85.2	4	24	218	418	491	MDP1916818.1 carboxypeptidase-like regulatory domain-containing protein [Myxococcales bacterium]	diamond	225	49.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27469262	27469262	PRJEB14664_P_NODE_16943_length_168_cov_1.804511_g16813_i0	PRJEB14664	16943	168	1.804511	3.03157848	Pseudomonadati	3379134	Bacteria	Bacteria	68.9	1.44e-12	NR	MEM6730372.1	2818507	g16813	i0	57.4	3.32142857142857	54	23	96.4	0	165	4	74	127	MEM6730372.1 heme-binding protein [Myxococcota bacterium]	diamond	558	68.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
27696837	27696837	PRJEB14664_P_NODE_19324_length_155_cov_0.983333_g19194_i0	PRJEB14664	19324	155	0.983333	1.52416615	Myxococcales bacterium	2026763	Bacteria	Bacteria	74.3	7.53e-14	NR	MDD9935209.1	2026763	g19194	i0	68	0.967741935483871	50	16	96.8	0	153	4	329	378	MDD9935209.1 thrombospondin type-1 domain-containing protein [Myxococcales bacterium]	diamond	150	74.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28959684	28959684	PRJEB14664_P_NODE_17248_length_166_cov_1.526718_g17118_i0	PRJEB14664	17248	166	1.526718	2.53435188	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	73.9	6.17e-14	NR	MBM4358966.1	2026735	g17118	i0	64.2	5.87349397590361	53	18	95.8	1	8	166	162	213	MBM4358966.1 fibro-slime domain-containing protein [Deltaproteobacteria bacterium]	diamond	975	73.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29338406	29338406	PRJEB14664_P_NODE_17469_length_165_cov_0.915385_g17339_i0	PRJEB14664	17469	165	0.915385	1.51038525	Nannocystaceae bacterium	2545255	Bacteria	Bacteria	82	1.8e-16	NR	MBC8069874.1	2545255	g17339	i0	59.3	1.96363636363636	54	22	98.2	0	2	163	60	113	MBC8069874.1 phosphoenolpyruvate carboxykinase (GTP) [Nannocystaceae bacterium]	diamond	324	82	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae		Nannocystaceae bacterium
30127587	30127587	PRJEB14664_P_NODE_9692_length_247_cov_1.698113_g9562_i0	PRJEB14664	9692	247	1.698113	4.19433911	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	87.4	7.16e-18	NR	MBW2399580.1	2026735	g9562	i0	48.1	1.8582995951417	81	42	98.4	0	3	245	128	208	MBW2399580.1 response regulator [Deltaproteobacteria bacterium]	diamond	459	87.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31170231	31170231	PRJEB14664_P_NODE_15555_length_178_cov_2.622378_g15425_i0	PRJEB14664	15555	178	2.622378	4.66783284	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	66.2	7.61e-11	NR	MET0410598.1	2268199	g15425	i0	63.6	0.926966292134832	55	19	91	1	164	3	307	361	MET0410598.1 lactonase family protein [Polyangiaceae bacterium]	diamond	165	66.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31613267	31613267	PRJEB14664_P_NODE_13836_length_193_cov_1.518987_g13706_i0	PRJEB14664	13836	193	1.518987	2.93164491	Bradymonadia bacterium	3121696	Bacteria	Bacteria	55.8	4.62e-7	NR	MFN3202708.1	3121696	g13706	i0	52.8	0.823834196891192	53	22	82.4	2	1	159	414	463	MFN3202708.1 hypothetical protein [Bradymonadia bacterium]	diamond	159	55.8	1	Bacteria	Pseudomonadati	Myxococcota	Bradymonadia				Bradymonadia bacterium
31676425	31676425	PRJEB14664_P_NODE_19197_length_155_cov_1.416667_g19067_i0	PRJEB14664	19197	155	1.416667	2.19583385	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	56.2	1.9e-7	NR	HEY4058753.1	2212474	g19067	i0	45.1	0.987096774193548	51	28	98.7	0	154	2	142	192	HEY4058753.1 lactonase family protein [Kofleriaceae bacterium]	diamond	153	56.2	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
31929530	31929530	PRJEB14664_P_NODE_14897_length_184_cov_1.073826_g14767_i0	PRJEB14664	14897	184	1.073826	1.97583984	Pyxidicoccus sp. 3LG	3383247	Bacteria	Bacteria	81.6	3.35e-16	NR	MFP2933217.1	3383247	g14767	i0	65.6	6.96195652173913	61	21	99.5	0	1	183	459	519	MFP2933217.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [Pyxidicoccus sp. 3LG]	diamond	1281	81.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus sp. 3LG

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