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

10 rows where bioproject = "PRJNA1032461", 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_order	tax_family	tax_genus	tax_species
7819700	7819700	PRJNA1032461_S_NODE_15467_length_168_cov_0.873950_g15369_i0	PRJNA1032461	15467	168	0.87395	1.468236	Sorangium cellulosum	56	Bacteria	Bacteria	99	1.79e-16	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g15369	i0	88.095	27.1547619047619	84	8	49	2	1	83	842366	842284	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	4562	99	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10370266	10370266	PRJNA1032461_S_NODE_129_length_1113_cov_10.936090_g80_i0	PRJNA1032461	129	1113	10.93609	121.7186817	Labilithrix luteola	1391654	Bacteria	Bacteria	1628	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g80	i0	93.042	166.339622641509	1121	67	100	9	1	1113	3941786	3942903	Labilithrix luteola strain DSM 27648, complete genome	blastn	185136	1628	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10370269	10370269	PRJNA1032461_S_NODE_13329_length_172_cov_2.536585_g13231_i0	PRJNA1032461	13329	172	2.536585	4.3629262	Labilithrix luteola	1391654	Bacteria	Bacteria	279	6.08e-71	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g13231	i0	95.93	266.354651162791	172	7	100	0	1	172	3942261	3942090	Labilithrix luteola strain DSM 27648, complete genome	blastn	45813	279	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
23959624	23959624	PRJNA1032461_S_NODE_6759_length_228_cov_1.972067_g6661_i0	PRJNA1032461	6759	228	1.972067	4.49631276	Myxococcia	32015	Bacteria	Bacteria	279	8.56e-71	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g6661	i0	88.696	142.34649122807	230	24	100	1	1	228	3943120	3943349	Labilithrix luteola strain DSM 27648, complete genome	blastn	32455	279	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
29805922	29805922	PRJNA1032461_S_NODE_18111_length_165_cov_0.896552_g18013_i0	PRJNA1032461	18111	165	0.896552	1.4793108	Myxococcia	32015	Bacteria	Bacteria	65.9	8.63e-11	NR	MDB4945668.1	1971228	g18013	i0	64.8	2.94545454545455	54	19	98.2	0	2	163	272	325	MDB4945668.1 hypothetical protein [Labilithrix sp.]	diamond	486	65.9	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
29900933	29900933	PRJNA1032461_S_NODE_15051_length_168_cov_1.184874_g14953_i0	PRJNA1032461	15051	168	1.184874	1.99058832	Myxococcia	32015	Bacteria	Bacteria	77	1.05e-14	NR	MBX3191304.1	1971228	g14953	i0	64.8	2.92857142857143	54	19	96.4	0	2	163	102	155	MBX3191304.1 nickel pincer cofactor biosynthesis protein LarC [Labilithrix sp.]	diamond	492	77	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30193015	30193015	PRJNA1032461_S_NODE_19192_length_164_cov_0.904348_g19094_i0	PRJNA1032461	19192	164	0.904348	1.48313072	Labilithrix sp.	1971228	Bacteria	Bacteria	89	6.5e-19	NR	MBX3204713.1	1971228	g19094	i0	68.5	1.97560975609756	54	17	98.8	0	164	3	111	164	MBX3204713.1 DnaJ domain-containing protein [Labilithrix sp.]	diamond	324	89	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
30983170	30983170	PRJNA1032461_S_NODE_17714_length_166_cov_0.888889_g17616_i0	PRJNA1032461	17714	166	0.888889	1.47555574	Polyangia bacterium	3058050	Bacteria	Bacteria	79	2.05e-15	NR	MEO6954370.1	3058050	g17616	i0	76.1	0.831325301204819	46	11	83.1	0	3	140	411	456	MEO6954370.1 outer membrane protein transport protein [Polyangia bacterium]	diamond	138	79	1	Bacteria	Pseudomonadati	Myxococcota				Polyangia bacterium
31109234	31109234	PRJNA1032461_S_NODE_19695_length_164_cov_0.904348_g19597_i0	PRJNA1032461	19695	164	0.904348	1.48313072	Myxococcota bacterium	2818507	Bacteria	Bacteria	41.6	0.0334	NR	MEM6925389.1	2818507	g19597	i0	42.3	0.951219512195122	52	25	86	1	17	157	436	487	MEM6925389.1 putative metal-binding motif-containing protein [Myxococcota bacterium]	diamond	156	41.6	1	Bacteria	Pseudomonadati	Myxococcota				Myxococcota bacterium
32343279	32343279	PRJNA1032461_S_NODE_21079_length_162_cov_1.150442_g20981_i0	PRJNA1032461	21079	162	1.150442	1.86371604	Labilithrix sp.	1971228	Bacteria	Bacteria	101	2.4099999999999994e-23	NR	MDB4940636.1	1971228	g20981	i0	98.1	1	54	1	100	0	162	1	57	110	MDB4940636.1 polymerase sigma-54 factor RpoN [Labilithrix sp.]	diamond	162	101	1	Bacteria	Pseudomonadati	Myxococcota	Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.

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