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

10 rows where bioproject = "PRJNA534016", 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
27394018	27394018	PRJNA534016_P_NODE_10403_length_276_cov_1.394089_g10313_i0	PRJNA534016	10403	276	1.394089	3.84768564	Labilithrix sp.	1971228	Bacteria	Bacteria	54.3	4.72e-6	NR	HEY8079268.1	1971228	g10313	i0	49	0.532608695652174	49	25	53.3	0	130	276	196	244	HEY8079268.1 HD domain-containing phosphohydrolase [Labilithrix sp.]	diamond	147	54.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix sp.
28277776	28277776	PRJNA534016_P_NODE_1386_length_698_cov_3.259200_g1301_i0	PRJNA534016	1386	698	3.2592	22.749216	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	68.9	2.2e-9	NR	MBX7099288.1	2484252	g1301	i0	49.4	0.339541547277937	79	37	32.7	1	689	462	942	1020	MBX7099288.1 HYR domain-containing protein [Myxococcaceae bacterium]	diamond	237	68.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
28530694	28530694	PRJNA534016_P_NODE_15747_length_247_cov_0.885057_g15657_i0	PRJNA534016	15747	247	0.885057	2.18609079	Myxococcales bacterium	2026763	Bacteria	Bacteria	79.7	2.84e-16	NR	MCA9584694.1	2026763	g15657	i0	66.1	2.04048582995951	56	19	68	0	12	179	140	195	MCA9584694.1 TlpA family protein disulfide reductase [Myxococcales bacterium]	diamond	504	79.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
30250963	30250963	PRJNA534016_P_NODE_1772_length_615_cov_2.428044_g1685_i0	PRJNA534016	1772	615	2.428044	14.9324706	Pseudomonadati	3379134	Bacteria	Bacteria	46.6	0.0122	NR	MEO0460890.1	2818507	g1685	i0	43.3	0.565853658536585	60	32	29.3	2	401	580	4	61	MEO0460890.1 hypothetical protein [Myxococcota bacterium]	diamond	348	46.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30457341	30457341	PRJNA534016_P_NODE_12253_length_261_cov_1.984043_g12163_i0	PRJNA534016	12253	261	1.984043	5.17835223	Sandaracinaceae bacterium	2510337	Bacteria	Bacteria	48.5	4.16e-4	NR	HEY8428729.1	2510337	g12163	i0	38	0.574712643678161	50	24	57.5	1	200	51	451	493	HEY8428729.1 nidogen-like domain-containing protein [Sandaracinaceae bacterium]	diamond	150	48.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae		Sandaracinaceae bacterium
30583120	30583120	PRJNA534016_P_NODE_14753_length_249_cov_0.875000_g14663_i0	PRJNA534016	14753	249	0.875	2.17875	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	50.8	5.42e-5	NR	MCB9740053.1	2026735	g14663	i0	41.7	1.50602409638554	60	35	72.3	0	193	14	5	64	MCB9740053.1 DUF3336 domain-containing protein [Deltaproteobacteria bacterium]	diamond	375	50.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31816145	31816145	PRJNA534016_P_NODE_12377_length_260_cov_2.096257_g12287_i0	PRJNA534016	12377	260	2.096257	5.4502682	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	55.5	1.47e-6	NR	MBI2372665.1	2026735	g12287	i0	49.1	0.611538461538462	53	27	61.2	0	161	3	167	219	MBI2372665.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	159	55.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32037695	32037695	PRJNA534016_P_NODE_12658_length_258_cov_2.081081_g12568_i0	PRJNA534016	12658	258	2.081081	5.36918898	Corallococcus exiguus	83462	Bacteria	Bacteria	100	7.81e-25	NR	WP_172815382.1	83462	g12568	i0	67.1	0.918604651162791	79	25	91.9	1	19	255	60	137	WP_172815382.1 hypothetical protein, partial [Corallococcus exiguus]	diamond	237	100	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exiguus
32100940	32100940	PRJNA534016_P_NODE_3438_length_440_cov_3.343324_g3348_i0	PRJNA534016	3438	440	3.343324	14.7106256	Myxococcales bacterium	2026763	Bacteria	Bacteria	47	0.00861	NR	MFN7131271.1	2026763	g3348	i0	29.4	0.695454545454545	102	58	69.5	3	127	432	225	312	MFN7131271.1 hypothetical protein [Myxococcales bacterium]	diamond	306	47	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32322782	32322782	PRJNA534016_P_NODE_6779_length_324_cov_1.131474_g6689_i0	PRJNA534016	6779	324	1.131474	3.66597576	Myxococcales bacterium	2026763	Bacteria	Bacteria	44.3	0.0271	NR	MBT9557299.1	2026763	g6689	i0	35.1	0.527777777777778	57	32	52.8	2	174	4	234	285	MBT9557299.1 hypothetical protein [Myxococcales bacterium]	diamond	171	44.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;