metadata: contig_metadata: 15 rows where bioproject = "PRJNA909412" and tax

15 rows where bioproject = "PRJNA909412" 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
4719252	4719252	PRJNA909412_P_NODE_9964_length_172_cov_3.488722_g9823_i0	PRJNA909412	9964	172	3.488722	6.00060184	Nannocystis punicea	2995304	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g9823	i0	96.875	0.186046511627907	32	1	19	0	8	39	4602685	4602716	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
13644353	13644353	PRJNA909412_P_NODE_71_length_1725_cov_21.790629_g53_i0	PRJNA909412	71	1725	21.790629	375.88835025	Pendulispora rubella	2741070	Bacteria	Bacteria	2211	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g53	i0	89.844	158.736811594203	1733	160	100	14	1	1725	9852410	9854134	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	273821	2211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
13644358	13644358	PRJNA909412_P_NODE_791_length_631_cov_2.939189_g681_i0	PRJNA909412	791	631	2.939189	18.54628259	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	262	1.5e-84	NR	MFO0588720.1	2268199	g681	i0	60.9	3.93660855784469	207	68	92.2	2	2	583	81	287	MFO0588720.1 thaumatin family protein [Polyangiaceae bacterium]	diamond	2484	262	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
20017260	20017260	PRJNA909412_P_NODE_2296_length_351_cov_332.086538_g2156_i0	PRJNA909412	2296	351	332.086538	1165.62374838	Pendulispora albinea	2741071	Bacteria	Bacteria	545	1.25e-150	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g2156	i0	94.618	279.22792022792	353	17	100	2	1	351	3590643	3590291	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	98009	545	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
27506048	27506048	PRJNA909412_P_NODE_8483_length_183_cov_1.659722_g8342_i0	PRJNA909412	8483	183	1.659722	3.03729126	Archangium	47	Bacteria	Bacteria	58.9	3.17e-8	NR	WP_375773176.1	48	g8342	i0	46.6	1.90163934426229	58	31	95.1	0	182	9	238	295	WP_375773176.1 DUF4476 domain-containing protein [Archangium gephyra]	diamond	348	59.3	0.993254637436762	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
27688266	27688266	PRJNA909412_P_NODE_14724_length_156_cov_2.837607_g14583_i0	PRJNA909412	14724	156	2.837607	4.42666692	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	44.3	0.00321	NR	MCL2779035.1	2268199	g14583	i0	52.4	1.21153846153846	42	20	80.8	0	11	136	42	83	MCL2779035.1 hypothetical protein [Polyangiaceae bacterium]	diamond	189	44.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
28421710	28421710	PRJNA909412_P_NODE_7746_length_190_cov_2.476821_g7605_i0	PRJNA909412	7746	190	2.476821	4.7059599	Myxococcia	32015	Bacteria	Bacteria	47	4.94e-4	NR	MCA9619831.1	2026763	g7605	i0	46.3	1.70526315789474	54	26	83.7	2	190	32	2	53	MCA9619831.1 endonuclease/exonuclease/phosphatase family protein [Myxococcales bacterium]	diamond	324	47	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28603592	28603592	PRJNA909412_P_NODE_12947_length_161_cov_2.393443_g12806_i0	PRJNA909412	12947	161	2.393443	3.85344323	Myxococcales bacterium	2026763	Bacteria	Bacteria	44.3	0.0035	NR	MCA9669861.1	2026763	g12806	i0	79.2	1.41614906832298	24	5	44.7	0	143	72	376	399	MCA9669861.1 hypothetical protein [Myxococcales bacterium]	diamond	228	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29620867	29620867	PRJNA909412_P_NODE_1610_length_433_cov_3.743655_g1470_i0	PRJNA909412	1610	433	3.743655	16.21002615	Minicystis	1649470	Bacteria	Bacteria	91.3	2.86e-19	NR	APR78274.1	888845	g1470	i0	36	7.33718244803695	136	75	94.2	4	3	410	31	154	APR78274.1 Hypothetical protein A7982_03621 [Minicystis rosea]	diamond	3177	91.7	0.995637949836423	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
30055888	30055888	PRJNA909412_P_NODE_14271_length_158_cov_2.109244_g14130_i0	PRJNA909412	14271	158	2.109244	3.33260552	Myxococcota bacterium	2818507	Bacteria	Bacteria	48.5	1.05e-4	NR	MEM9073086.1	2818507	g14130	i0	48.9	0.892405063291139	47	23	89.2	1	148	8	95	140	MEM9073086.1 thrombospondin type-1 domain-containing protein [Myxococcota bacterium]	diamond	141	48.5	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30150587	30150587	PRJNA909412_P_NODE_13552_length_160_cov_2.041322_g13411_i0	PRJNA909412	13552	160	2.041322	3.2661152	Myxococcota bacterium	2818507	Bacteria	Bacteria	46.2	7.01e-4	NR	MFO0751290.1	2818507	g13411	i0	36.5	1.95	52	30	97.5	1	3	158	440	488	MFO0751290.1 thrombospondin type-1 domain-containing protein [Myxococcota bacterium]	diamond	312	46.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30404046	30404046	PRJNA909412_P_NODE_5913_length_215_cov_2.125000_g5772_i0	PRJNA909412	5913	215	2.125	4.56875	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	57	2.35e-7	NR	MBN2342233.1	2026735	g5772	i0	47.6	0.87906976744186	63	32	86.5	1	2	187	339	401	MBN2342233.1 glycoside hydrolase family protein [Deltaproteobacteria bacterium]	diamond	189	57	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
30529888	30529888	PRJNA909412_P_NODE_7313_length_195_cov_2.557692_g7172_i0	PRJNA909412	7313	195	2.557692	4.9874994	Minicystis rosea	888845	Bacteria	Bacteria	89	5.19e-19	NR	APR81495.1	888845	g7172	i0	55.2	1.03076923076923	67	25	98.5	2	194	3	99	163	APR81495.1 Ornithine carbamoyltransferase [Minicystis rosea]	diamond	201	89	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
31706980	31706980	PRJNA909412_P_NODE_817_length_618_cov_2.872193_g702_i0	PRJNA909412	817	618	2.872193	17.75015274	Pseudomonadati	3379134	Bacteria	Bacteria	170	1.58e-50	NR	MBI3247915.1	2026735	g702	i0	57.8	4.08252427184466	135	57	65.5	0	48	452	4	138	MBI3247915.1 DUF1772 domain-containing protein [Deltaproteobacteria bacterium]	diamond	2523	171	0.994152046783626	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32647976	32647976	PRJNA909412_P_NODE_14020_length_159_cov_1.275000_g13879_i0	PRJNA909412	14020	159	1.275	2.02725	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	61.6	1.81e-9	NR	MBU52516.1	2026735	g13879	i0	60	0.943396226415094	50	20	94.3	0	2	151	18	67	MBU52516.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	150	61.6	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);;