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

10 rows where bioproject = "PRJNA1008624", 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
7806753	7806753	PRJNA1008624_P_NODE_21767_length_186_cov_1.138686_g21579_i0	PRJNA1008624	21767	186	1.138686	2.11795596	Myxococcota bacterium	2818507	Bacteria	Bacteria	206	1.15e-48	NTclustered	gi\|2907625649\|emb\|OZ223209.1\|	2818507	g21579	i0	89.571	456.376344086022	163	16	87	1	21	182	5219126	5218964	MAG: Myxococcota bacterium isolate 6e5ad1d4-156e-4916-952c-8a0b14857fe9 genome assembly, chromosome: 1	blastn	84886	206	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
16730961	16730961	PRJNA1008624_P_NODE_17394_length_204_cov_1.632258_g17206_i0	PRJNA1008624	17394	204	1.632258	3.32980632	Labilithrix luteola	1391654	Bacteria	Bacteria	355	1.21e-93	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g17206	i0	98.039	179.583333333333	204	4	100	0	1	204	3944282	3944079	Labilithrix luteola strain DSM 27648, complete genome	blastn	36635	355	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18006333	18006333	PRJNA1008624_P_NODE_4635_length_394_cov_2.973913_g4448_i0	PRJNA1008624	4635	394	2.973913	11.71721722	Labilithrix luteola	1391654	Bacteria	Bacteria	641	1.7599999999999998e-179	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4448	i0	96.867	157.187817258883	383	12	97	0	1	383	3942854	3942472	Labilithrix luteola strain DSM 27648, complete genome	blastn	61932	641	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
27002650	27002650	PRJNA1008624_P_NODE_6902_length_319_cov_2.085185_g6714_i0	PRJNA1008624	6902	319	2.085185	6.65174015	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	199	7.459999999999999e-61	NR	HKD38656.1	2484252	g6714	i0	92.4	2.96238244514107	105	8	98.7	0	317	3	92	196	HKD38656.1 plasmid partitioning protein RepA [Myxococcaceae bacterium]	diamond	945	199	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
27824391	27824391	PRJNA1008624_P_NODE_32564_length_165_cov_0.896552_g32376_i0	PRJNA1008624	32564	165	0.896552	1.4793108	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	42.4	0.0176	NR	HVK87281.1	2212474	g32376	i0	40.9	0.8	44	24	76.4	1	21	146	317	360	HVK87281.1 hypothetical protein [Kofleriaceae bacterium]	diamond	132	42.4	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28676841	28676841	PRJNA1008624_P_NODE_28147_length_168_cov_1.369748_g27959_i0	PRJNA1008624	28147	168	1.369748	2.30117664	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	70.5	4.69e-13	NR	HHH30778.1	2268199	g27959	i0	68.9	2.41071428571429	45	14	80.4	0	6	140	137	181	HHH30778.1 HNH endonuclease [Polyangiaceae bacterium]	diamond	405	70.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30034609	30034609	PRJNA1008624_P_NODE_22271_length_184_cov_1.362963_g22083_i0	PRJNA1008624	22271	184	1.362963	2.50785192	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	50.8	1.98e-5	NR	HSN30000.1	2212474	g22083	i0	58.1	0.701086956521739	43	16	70.1	1	182	54	142	182	HSN30000.1 hypothetical protein [Kofleriaceae bacterium]	diamond	129	50.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
30634650	30634650	PRJNA1008624_P_NODE_18253_length_200_cov_0.927152_g18065_i0	PRJNA1008624	18253	200	0.927152	1.854304	Anaeromyxobacteraceae bacterium	2510643	Bacteria	Bacteria	63.5	1.11e-10	NR	HSM93365.1	2510643	g18065	i0	66.7	0.72	48	13	69	2	61	198	27	73	HSM93365.1 SLOG family protein [Anaeromyxobacteraceae bacterium]	diamond	144	63.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae		Anaeromyxobacteraceae bacterium
31077316	31077316	PRJNA1008624_P_NODE_35755_length_163_cov_0.912281_g35567_i0	PRJNA1008624	35755	163	0.912281	1.48701803	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	93.2	1.76e-22	NR	MEI6806910.1	2484252	g35567	i0	84.6	2.87116564417178	52	8	95.7	0	159	4	83	134	MEI6806910.1 hypothetical protein [Myxococcaceae bacterium]	diamond	468	93.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
31298372	31298372	PRJNA1008624_P_NODE_13115_length_232_cov_0.814208_g12927_i0	PRJNA1008624	13115	232	0.814208	1.88896256	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	152	1.58e-45	NR	HPH68572.1	2212474	g12927	i0	96.1	0.982758620689655	76	3	98.3	0	231	4	11	86	HPH68572.1 hypothetical protein [Kofleriaceae bacterium]	diamond	228	152	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae 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);;