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

6 rows where bioproject = "PRJNA741997", 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
7100155	7100155	PRJNA741997_P_NODE_42606_length_333_cov_1.050000_g41486_i0	PRJNA741997	42606	333	1.05	3.4965	uncultured delta proteobacterium	34034	Bacteria	Bacteria	337	7.739999999999998e-88	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g41486	i0	85.455	156.258258258258	330	41	98	5	6	331	82564	82238	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	52034	337	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26841365	26841365	PRJNA741997_P_NODE_37561_length_354_cov_1.729537_g36441_i0	PRJNA741997	37561	354	1.729537	6.12256098	Microvenator	2946507	Bacteria	Bacteria	103	3.1599999999999996e-23	NR	WP_146961474.1	2600177	g36441	i0	47	2.97457627118644	117	60	99.2	1	2	352	245	359	WP_146961474.1 acetylglutamate kinase [Microvenator marinus]	diamond	1053	104	0.990384615384615	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
27084242	27084242	PRJNA741997_P_NODE_74542_length_250_cov_0.870056_g73422_i0	PRJNA741997	74542	250	0.870056	2.17514	Deltaproteobacteria bacterium RBG_13_6	2026735	Bacteria	Bacteria	70.1	9.2e-12	NR	OGP71350.1	1797833	g73422	i0	61.2	4.26	49	19	58.8	0	167	21	598	646	OGP71350.1 MAG: hypothetical protein A2Z73_00615 [Deltaproteobacteria bacterium RBG_13_60_28]	diamond	1065	70.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_13_60_28
27883898	27883898	PRJNA741997_P_NODE_88805_length_241_cov_1.363095_g87685_i0	PRJNA741997	88805	241	1.363095	3.28505895	Thermodesulfobacteriota	200940	Bacteria	Bacteria	72.8	5.52e-14	NR	MBF0352595.1	2024889	g87685	i0	47	4.60580912863071	66	33	79.7	1	1	192	88	153	MBF0352595.1 cupin domain-containing protein [SAR324 cluster bacterium]	diamond	1110	72.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
29651686	29651686	PRJNA741997_P_NODE_58670_length_281_cov_1.129808_g57550_i0	PRJNA741997	58670	281	1.129808	3.17476048	Lujinxingia	2653226	Bacteria	Bacteria	43.5	0.0269	NR	WP_115602440.1	2480984	g57550	i0	33.7	2.34875444839858	83	39	86.5	2	37	279	112	180	WP_115602440.1 ABC transporter ATP-binding protein [Lujinxingia sediminis]	diamond	660	43.9	0.990888382687927	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingia	Lujinxingia sediminis
32749332	32749332	PRJNA741997_P_NODE_9420_length_845_cov_1.725389_g8460_i0	PRJNA741997	9420	845	1.725389	14.57953705	Myxococcota	2818505	Bacteria	Bacteria	139	3.3499999999999993e-34	NR	PKN55183.1	2013741	g8460	i0	45.1	1.87810650887574	175	87	58.9	3	745	248	258	432	PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	1587	139	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14

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