metadata: contig_metadata: 7 rows where bioproject = "PRJNA637328", tax_phylum = "Myxococcota" and tax

7 rows where bioproject = "PRJNA637328", 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
11358562	11358562	PRJNA637328_S_NODE_3549_length_166_cov_1.263566_g3472_i0	PRJNA637328	3549	166	1.263566	2.09751956	Pseudomonadati	3379134	Bacteria	Bacteria	139	1.04e-28	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g3472	i0	86.26	159.885542168675	131	15	78	3	3	132	142570	142698	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	26541	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
24107047	24107047	PRJNA637328_P_NODE_11939_length_277_cov_2.605263_g11463_i0	PRJNA637328	11939	277	2.605263	7.21657851	Pendulispora	3375062	Bacteria	Bacteria	412	1.0099999999999997e-110	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g11463	i0	93.796	252.090252707581	274	17	99	0	3	276	7289115	7289388	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	69829	412	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
26796224	26796224	PRJNA637328_P_NODE_14061_length_263_cov_3.672897_g13584_i0	PRJNA637328	14061	263	3.672897	9.65971911	Myxococcales bacterium	2026763	Bacteria	Bacteria	100	1.86e-23	NR	HEX4385098.1	2026763	g13584	i0	87	1.04942965779468	46	6	52.5	0	261	124	257	302	HEX4385098.1 AraC family transcriptional regulator [Myxococcales bacterium]	diamond	276	100	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28072523	28072523	PRJNA637328_P_NODE_20705_length_229_cov_2.127778_g20228_i0	PRJNA637328	20705	229	2.127778	4.87261162	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	2.84e-6	NR	MBT4089300.1	2026735	g20228	i0	31.7	4.51965065502183	63	41	79.9	1	30	212	5	67	MBT4089300.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	1035	52.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28754762	28754762	PRJNA637328_P_NODE_8327_length_317_cov_2.716418_g7852_i0	PRJNA637328	8327	317	2.716418	8.61104506	Myxococcota bacterium	2818507	Bacteria	Bacteria	44.7	0.0181	NR	MBU1534565.1	2818507	g7852	i0	32.9	0.747634069400631	79	51	74.8	1	247	11	402	478	MBU1534565.1 PilZ domain-containing protein [Myxococcota bacterium]	diamond	237	44.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29417683	29417683	PRJNA637328_P_NODE_12569_length_272_cov_3.112108_g12093_i0	PRJNA637328	12569	272	3.112108	8.46493376	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	44.3	0.0106	NR	MBP6628304.1	2212474	g12093	i0	34.1	1.00367647058824	91	50	98.2	3	2	268	116	198	MBP6628304.1 C-type lectin domain-containing protein [Kofleriaceae bacterium]	diamond	273	44.3	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
31692844	31692844	PRJNA637328_P_NODE_16197_length_253_cov_1.926471_g15720_i0	PRJNA637328	16197	253	1.926471	4.87397163	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	44.3	0.0122	NR	MBI5015527.1	2026735	g15720	i0	36.8	1.03162055335968	87	36	80.6	4	225	22	400	486	MBI5015527.1 phosphatase PAP2 family protein [Deltaproteobacteria bacterium]	diamond	261	44.3	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);;