metadata: contig_metadata: 14 rows where bioproject = "PRJNA784979" and tax

14 rows where bioproject = "PRJNA784979" 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
2488860	2488860	PRJNA784979_S_NODE_12282_length_163_cov_0.894737_g12240_i0	PRJNA784979	12282	163	0.894737	1.45842131	Sorangium	39643	Bacteria	Bacteria	152	1.3e-32	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g12240	i0	91.071	3.31288343558282	112	10	69	0	42	153	1962734	1962623	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	540	152	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9693948	9693948	PRJNA784979_S_NODE_9608_length_170_cov_2.165289_g9566_i0	PRJNA784979	9608	170	2.165289	3.6809913	Minicystis rosea	888845	Bacteria	Bacteria	189	1.04e-43	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g9566	i0	95.763	122.088235294118	118	4	69	1	5	121	770755	770638	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	20755	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17343778	17343778	PRJNA784979_S_NODE_2054_length_323_cov_5.164234_g2012_i0	PRJNA784979	2054	323	5.164234	16.68047582	Sorangium cellulosum	56	Bacteria	Bacteria	372	2.05e-98	NTclustered	gi\|28395339\|gb\|AY190664.1\|	56	g2012	i0	87.975	165.006191950464	316	37	98	1	1	315	602	917	Polyangium cellulosum strain So9881 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	53297	372	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19065057	19065057	PRJNA784979_S_NODE_1795_length_353_cov_3.207237_g1753_i0	PRJNA784979	1795	353	3.207237	11.32154661	Sorangium	39643	Bacteria	Bacteria	494	4.61e-135	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g1753	i0	92.464	135.373937677054	345	26	98	0	9	353	3690186	3690530	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	47787	494	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21615582	21615582	PRJNA784979_S_NODE_2497_length_290_cov_5.195021_g2455_i0	PRJNA784979	2497	290	5.195021	15.0655609	Sorangium	39643	Bacteria	Bacteria	316	8.62e-82	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g2455	i0	87.279	125.251724137931	283	29	96	7	9	286	2994552	2994272	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	36323	318	0.993710691823899	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
27085316	27085316	PRJNA784979_S_NODE_10942_length_166_cov_0.871795_g10900_i0	PRJNA784979	10942	166	0.871795	1.4471797	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	57.8	6.56e-8	NR	MET0790993.1	2268199	g10900	i0	47.3	0.993975903614458	55	29	99.4	0	2	166	344	398	MET0790993.1 hypothetical protein [Polyangiaceae bacterium]	diamond	165	57.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27622483	27622483	PRJNA784979_S_NODE_10944_length_166_cov_0.871795_g10902_i0	PRJNA784979	10944	166	0.871795	1.4471797	Archangium sp.	1872627	Bacteria	Bacteria	68.6	7.67e-12	NR	MDP1827653.1	1872627	g10902	i0	65.4	3.68674698795181	52	18	94	0	6	161	4	55	MDP1827653.1 hypothetical protein [Archangium sp.]	diamond	612	68.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.
27748895	27748895	PRJNA784979_S_NODE_13284_length_161_cov_0.910714_g13242_i0	PRJNA784979	13284	161	0.910714	1.46624954	Archangiaceae bacterium	2684409	Bacteria	Bacteria	49.7	4.35e-5	NR	MBK7860774.1	2684409	g13242	i0	50	1.00621118012422	54	26	98.8	1	159	1	754	807	MBK7860774.1 zinc-ribbon domain-containing protein [Archangiaceae bacterium]	diamond	162	49.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae		Archangiaceae bacterium
29358976	29358976	PRJNA784979_S_NODE_12649_length_162_cov_1.433628_g12607_i0	PRJNA784979	12649	162	1.433628	2.32247736	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	79.7	6.89e-16	NR	MCC6809955.1	2026735	g12607	i0	72.3	0.87037037037037	47	13	87	0	159	19	226	272	MCC6809955.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	141	79.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30401675	30401675	PRJNA784979_S_NODE_7013_length_191_cov_0.894366_g6971_i0	PRJNA784979	7013	191	0.894366	1.70823906	Myxococcota bacterium	2818507	Bacteria	Bacteria	41.2	0.0488	NR	MEN0065938.1	2818507	g6971	i0	45.7	0.722513089005236	46	25	72.3	0	145	8	80	125	MEN0065938.1 hypothetical protein [Myxococcota bacterium]	diamond	138	41.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
31769625	31769625	PRJNA784979_S_NODE_11477_length_165_cov_0.879310_g11435_i0	PRJNA784979	11477	165	0.87931	1.4508615	Myxococcia	32015	Bacteria	Bacteria	110	1.7700000000000002e-26	NR	MES1188455.1	2026763	g11435	i0	86.8	2.89090909090909	53	7	96.4	0	164	6	91	143	MES1188455.1 M20/M25/M40 family metallo-hydrolase [Myxococcales bacterium]	diamond	477	110	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31918599	31918599	PRJNA784979_S_NODE_7517_length_186_cov_1.145985_g7475_i0	PRJNA784979	7517	186	1.145985	2.1315321	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	54.7	9.31e-7	NR	RLB63939.1	2026735	g7475	i0	54.4	1.82258064516129	57	24	91.9	2	173	3	13	67	RLB63939.1 MAG: hypothetical protein DRH08_10395 [Deltaproteobacteria bacterium]	diamond	339	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31981768	31981768	PRJNA784979_S_NODE_10298_length_167_cov_0.864407_g10256_i0	PRJNA784979	10298	167	0.864407	1.44355969	Myxococcales bacterium	2026763	Bacteria	Bacteria	90.5	1.18e-21	NR	MDO9018539.1	2026763	g10256	i0	82.1	1.0059880239521	56	9	98.8	1	3	167	57	112	MDO9018539.1 cupredoxin domain-containing protein [Myxococcales bacterium]	diamond	168	90.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32393238	32393238	PRJNA784979_S_NODE_12959_length_162_cov_0.902655_g12917_i0	PRJNA784979	12959	162	0.902655	1.4623011	Polyangiales bacterium	3034171	Bacteria	Bacteria	48.5	1.07e-4	NR	HET8940098.1	3034171	g12917	i0	52.9	2.81481481481481	51	24	94.4	0	161	9	154	204	HET8940098.1 hypothetical protein [Polyangiales bacterium]	diamond	456	48.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales 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);;