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

4 rows where bioproject = "PRJNA690124", 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
22346719	22346719	PRJNA690124_P_NODE_38538_length_268_cov_1.174359_g38172_i0	PRJNA690124	38538	268	1.174359	3.14728212	Microvenator marinus	2600177	Bacteria	Bacteria	165	3.02e-36	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g38172	i0	86.364	60.0223880597015	154	18	57	3	14	166	703080	703231	Microvenator marinus strain V1718 chromosome, complete genome	blastn	16086	165	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
30694145	30694145	PRJNA690124_P_NODE_44573_length_252_cov_0.871508_g44207_i0	PRJNA690124	44573	252	0.871508	2.19620016	delta/epsilon subdivisions	68525	Bacteria	Bacteria	88.2	3.14e-20	NR	OIP29402.1	1805125	g44207	i0	56.8	6.16666666666667	74	32	88.1	0	1	222	54	127	OIP29402.1 MAG: hypothetical protein AUK23_11010 [Deltaproteobacteria bacterium CG2_30_43_15]	diamond	1554	89	0.991011235955056	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_43_15
30872212	30872212	PRJNA690124_P_NODE_37654_length_271_cov_1.393939_g37288_i0	PRJNA690124	37654	271	1.393939	3.77757469	Deltaproteobacteria bacterium GWA2_47_9	1797806	Bacteria	Bacteria	48.5	4.52e-4	NR	OGP12290.1	1797806	g37288	i0	79.3	0.321033210332103	29	6	32.1	0	43	129	2	30	OGP12290.1 MAG: hypothetical protein A2055_00240 [Deltaproteobacteria bacterium GWA2_47_9]	diamond	87	48.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium GWA2_47_9
32768900	32768900	PRJNA690124_P_NODE_55740_length_242_cov_0.923077_g55374_i0	PRJNA690124	55740	242	0.923077	2.23384634	Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_6	2026735	Bacteria	Bacteria	162	1.07e-46	NR	OGQ80741.1	1797894	g55374	i0	88.8	0.991735537190083	80	9	99.2	0	1	240	189	268	OGQ80741.1 MAG: hypothetical protein A3F90_01580 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19]	diamond	240	162	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19

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);;