metadata: contig_metadata: 7 rows where bioproject = "PRJNA993416", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA993416", tax_kingdom = "Pseudomonadati" and tax_phylum = "Elusimicrobiota"

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_species
2548599	2548599	PRJNA993416_P_NODE_14402_length_246_cov_0.890173_g14297_i0	PRJNA993416	14402	246	0.890173	2.18982558	Bacteria	2	Bacteria	Bacteria	162	8.359999999999998e-47	NR	OGS39435.1	1797972	g14297	i0	97.5	4.9390243902439	81	2	98.8	0	1	243	263	343	OGS39435.1 MAG: phosphate acetyltransferase [Elusimicrobia bacterium RIFOXYD12_FULL_66_9]	diamond	1215	163	0.993865030674847	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobia bacterium RIFOXYD12_FULL_66_9
10201545	10201545	PRJNA993416_P_NODE_10468_length_269_cov_2.984694_g10363_i0	PRJNA993416	10468	269	2.984694	8.02882686	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	169	2.6199999999999998e-52	NR	MFI5363942.1	2030800	g10363	i0	89.9	2.97769516728625	89	9	99.3	0	269	3	20	108	MFI5363942.1 metal-sulfur cluster assembly factor [Elusimicrobiota bacterium]	diamond	801	169	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
16278695	16278695	PRJNA993416_P_NODE_16213_length_241_cov_0.916667_g16108_i0	PRJNA993416	16213	241	0.916667	2.20916747	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	70.9	1.25e-13	NR	MBI3566542.1	2030800	g16108	i0	92.3	0.485477178423237	39	3	48.5	0	1	117	75	113	MBI3566542.1 winged helix-turn-helix transcriptional regulator [Elusimicrobiota bacterium]	diamond	117	70.9	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
20102317	20102317	PRJNA993416_P_NODE_14356_length_246_cov_0.890173_g14251_i0	PRJNA993416	14356	246	0.890173	2.18982558	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	81.3	1.04e-15	NR	MFI5347851.1	2030800	g14251	i0	70.9	1.04878048780488	86	20	98.8	1	245	3	541	626	MFI5347851.1 OmpA family protein [Elusimicrobiota bacterium]	diamond	258	81.3	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
27405969	27405969	PRJNA993416_P_NODE_12463_length_251_cov_0.865169_g12358_i0	PRJNA993416	12463	251	0.865169	2.17157419	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	97.8	1.0100000000000002e-21	NR	NNN05905.1	2030800	g12358	i0	68.5	0.872509960159363	73	23	87.3	0	219	1	17	89	NNN05905.1 TonB-dependent receptor plug domain-containing protein [Elusimicrobiota bacterium]	diamond	219	97.8	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
28068760	28068760	PRJNA993416_P_NODE_15425_length_243_cov_0.905882_g15320_i0	PRJNA993416	15425	243	0.905882	2.20129326	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	118	1.84e-30	NR	MDE2510523.1	2030800	g15320	i0	76.7	3.60493827160494	73	17	90.1	0	239	21	204	276	MDE2510523.1 hypothetical protein [Elusimicrobiota bacterium]	diamond	876	118	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota bacterium
31069341	31069341	PRJNA993416_P_NODE_10295_length_271_cov_2.005051_g10190_i0	PRJNA993416	10295	271	2.005051	5.43368821	Elusimicrobiota bacterium	2030800	Bacteria	Bacteria	79.7	1.57e-17	NR	MCM2303719.1	2030800	g10190	i0	83.7	0.476014760147601	43	7	47.6	0	129	1	1	43	MCM2303719.1 hypothetical protein [Elusimicrobiota bacterium]	diamond	129	79.7	1	Bacteria	Pseudomonadati	Elusimicrobiota	Elusimicrobiota 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);;