metadata: contig_metadata: 7 rows where bioproject = "PRJNA874604", tax_clade = "delta/epsilon subdivisions" and tax

7 rows where bioproject = "PRJNA874604", tax_clade = "delta/epsilon subdivisions" 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_clade	tax_class	tax_order	tax_family	tax_genus	tax_species
3403501	3403501	PRJNA874604_P_NODE_87003_length_245_cov_0.895349_g86651_i0	PRJNA874604	87003	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	144	2.07e-38	NR	OGQ08065.1	1797859	g86651	i0	80.2	49.5551020408163	81	16	99.2	0	245	3	370	450	OGQ08065.1 MAG: methylcrotonoyl-CoA carboxylase [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28]	diamond	12141	145	0.993103448275862	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_28
28160841	28160841	PRJNA874604_P_NODE_39025_length_312_cov_1.288703_g38673_i0	PRJNA874604	39025	312	1.288703	4.02075336	Deltaproteobacteria bacterium CG2_3	2026735	Bacteria	Bacteria	78.6	2.19e-14	NR	OIP32185.1	1805126	g38673	i0	47	1.81730769230769	100	43	91.3	4	9	293	271	365	OIP32185.1 MAG: hypothetical protein AUK47_20995, partial [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	567	78.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_63_29
30474182	30474182	PRJNA874604_P_NODE_47933_length_288_cov_1.432558_g47581_i0	PRJNA874604	47933	288	1.432558	4.12576704	Bacteria	2	Bacteria	Bacteria	66.2	3.56e-10	NR	OGQ89419.1	1797895	g47581	i0	41.9	1.9375	93	44	96.9	3	2	280	1177	1259	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	558	66.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30560501	30560501	PRJNA874604_P_NODE_27693_length_355_cov_1.365248_g27341_i0	PRJNA874604	27693	355	1.365248	4.8466304	Microvenator marinus	2600177	Bacteria	Bacteria	55.5	4.39e-6	NR	WP_146962556.1	2600177	g27341	i0	56.3	0.405633802816901	48	19	40.6	1	192	335	356	401	WP_146962556.1 hypothetical protein [Microvenator marinus]	diamond	144	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
30655442	30655442	PRJNA874604_P_NODE_51673_length_281_cov_1.350962_g51321_i0	PRJNA874604	51673	281	1.350962	3.79620322	Lujinxingia vulgaris	2600176	Bacteria	Bacteria	84	2.36e-17	NR	WP_146973764.1	2600176	g51321	i0	50	0.918149466192171	86	43	91.8	0	24	281	3	88	WP_146973764.1 SDR family oxidoreductase [Lujinxingia vulgaris]	diamond	258	84	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingia	Lujinxingia vulgaris
30884766	30884766	PRJNA874604_P_NODE_57454_length_270_cov_2.142132_g57102_i0	PRJNA874604	57454	270	2.142132	5.7837564	Bacteria	2	Bacteria	Bacteria	98.6	4.5400000000000005e-22	NR	OQB11333.1	1852869	g57102	i0	60.5	5.38888888888889	76	29	84.4	1	229	2	301	375	OQB11333.1 MAG: Formylglycine-generating sulfatase enzyme [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	1455	99	0.995959595959596	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin207
32553262	32553262	PRJNA874604_P_NODE_67819_length_252_cov_1.525140_g67467_i0	PRJNA874604	67819	252	1.52514	3.8433528	Bradymonadales bacterium	2099667	Bacteria	Bacteria	56.2	5e-8	NR	MFA5624936.1	2099667	g67467	i0	44.6	1.54761904761905	65	32	77.4	1	230	36	1	61	MFA5624936.1 HU family DNA-binding protein [Bradymonadales bacterium]	diamond	390	56.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales			Bradymonadales 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);;