metadata: contig_metadata: 12 rows where bioproject = "PRJNA608660", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA608660", tax_kingdom = "Pseudomonadati" and tax_phylum = "Myxococcota"

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
5688276	5688276	PRJNA608660_P_NODE_1785_length_937_cov_7.718468_g974_i1	PRJNA608660	1785	937	7.718468	72.32204516	Myxococcales bacterium	2026763	Bacteria	Bacteria	612	3.47e-170	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g974	i1	78.942	121.385272145144	945	165	99	20	1	926	1312523	1313452	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	113738	612	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
6250649	6250649	PRJNA608660_P_NODE_41625_length_182_cov_1.563910_g41268_i0	PRJNA608660	41625	182	1.56391	2.8463162	Pendulispora	3375062	Bacteria	Bacteria	178	2.45e-40	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g41268	i0	94.737	151.989010989011	114	6	63	0	57	170	7287256	7287143	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	27662	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
13338921	13338921	PRJNA608660_P_NODE_42311_length_179_cov_3.815385_g41954_i0	PRJNA608660	42311	179	3.815385	6.82953915	Myxococcales bacterium	2026763	Bacteria	Bacteria	189	1.1099999999999999e-43	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g41954	i0	88.05	161.184357541899	159	19	89	0	6	164	1311862	1312020	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	28852	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
15175220	15175220	PRJNA608660_P_NODE_3672_length_732_cov_19.862372_g3413_i0	PRJNA608660	3672	732	19.862372	145.39256304	Stigmatella	40	Bacteria	Bacteria	907	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g3413	i0	94.836	250.821038251366	581	30	99	0	152	732	575	1155	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	183601	907	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
15887420	15887420	PRJNA608660_P_NODE_10353_length_463_cov_13.934783_g10008_i0	PRJNA608660	10353	463	13.934783	64.51804529	Pseudomonadati	3379134	Bacteria	Bacteria	95.1	8.17e-20	NR	MBN2123032.1	2026735	g10008	i0	48.5	4.5939524838013	99	51	64.1	0	447	151	159	257	MBN2123032.1 ABC transporter permease [Deltaproteobacteria bacterium]	diamond	2127	95.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
15887759	15887759	PRJNA608660_P_NODE_4953_length_651_cov_5.626246_g4657_i0	PRJNA608660	4953	651	5.626246	36.62686146	Archangium violaceum	83451	Bacteria	Bacteria	588	3.989999999999999e-163	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g4657	i0	83.308	266.282642089094	659	88	99	18	6	651	5179723	5180372	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	173350	588	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
19711124	19711124	PRJNA608660_P_NODE_14856_length_380_cov_2.981873_g14503_i0	PRJNA608660	14856	380	2.981873	11.3311174	Myxococcales bacterium	2026763	Bacteria	Bacteria	272	2.55e-68	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g14503	i0	82.803	68.8710526315789	314	44	81	10	67	375	1312453	1312761	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	26171	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26872101	26872101	PRJNA608660_P_NODE_5061_length_645_cov_4.981544_g4763_i0	PRJNA608660	5061	645	4.981544	32.1309588	root	1	Root_unresolved	Root_unresolved	47.8	0.0125	NR	MEO8551975.1	2212474	g4763	i0	33.8	1.95348837209302	74	49	34.4	0	47	268	90	163	MEO8551975.1 hypothetical protein [Kofleriaceae bacterium]	diamond	1260	47.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28406633	28406633	PRJNA608660_P_NODE_34286_length_212_cov_3.073620_g33930_i0	PRJNA608660	34286	212	3.07362	6.5160744	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	65.1	3.27e-10	NR	RLC27457.1	2026735	g33930	i0	53.6	1.95283018867925	69	32	97.6	0	2	208	694	762	RLC27457.1 MAG: CRISPR-associated endonuclease Cas1 [Deltaproteobacteria bacterium]	diamond	414	65.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28501360	28501360	PRJNA608660_P_NODE_21587_length_299_cov_3.632000_g21231_i0	PRJNA608660	21587	299	3.632	10.859680000000001	Myxococcota bacterium	2818507	Bacteria	Bacteria	44.7	0.00247	NR	HNC97725.1	2818507	g21231	i0	40.3	0.622073578595318	62	26	51.2	1	245	93	17	78	HNC97725.1 hypothetical protein [Myxococcota bacterium]	diamond	186	44.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
28501362	28501362	PRJNA608660_P_NODE_29087_length_241_cov_1.604167_g28731_i0	PRJNA608660	29087	241	1.604167	3.86604247	Nannocystis sp.	1962667	Bacteria	Bacteria	99.4	3.88e-22	NR	WP_293259433.1	1962667	g28731	i0	78.5	0.983402489626556	79	16	98.3	1	4	240	201	278	WP_293259433.1 tetratricopeptide repeat protein [Nannocystis sp.]	diamond	237	99.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
28911425	28911425	PRJNA608660_P_NODE_27188_length_253_cov_2.318627_g26832_i0	PRJNA608660	27188	253	2.318627	5.86612631	Polyangiaceae bacterium LLY-WYZ-14_1	3034331	Bacteria	Bacteria	42.4	0.0412	NR	HJK99605.1	3034331	g26832	i0	36.8	0.806324110671937	68	40	80.6	2	239	36	53	117	HJK99605.1 GNAT family N-acetyltransferase [Polyangiaceae bacterium LLY-WYZ-14_1]	diamond	204	42.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium LLY-WYZ-14_1

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