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

7 rows where bioproject = "PRJNA489308", 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
10653946	10653946	PRJNA489308_P_NODE_37849_length_242_cov_0.911243_g37773_i0	PRJNA489308	37849	242	0.911243	2.20520806	uncultured delta proteobacterium	34034	Bacteria	Bacteria	315	2.52e-81	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g37773	i0	90.456	144.954545454545	241	20	99	3	3	242	82842	83080	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	35079	315	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
20224504	20224504	PRJNA489308_P_NODE_33476_length_247_cov_2.339080_g33400_i0	PRJNA489308	33476	247	2.33908	5.7775276	root	1	Root_unresolved	Root_unresolved	446	8.759999999999998e-121	NTclustered	gi\|2442650072\|gb\|OQ422739.1\|	34034	g33400	i0	99.19	99.9230769230769	247	2	100	0	1	247	1166	1412	Uncultured delta proteobacterium clone KCM_5_1_6 16S ribosomal RNA gene, partial sequence	blastn	24681	446	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26601265	26601265	PRJNA489308_P_NODE_7941_length_388_cov_2.577778_g7865_i0	PRJNA489308	7941	388	2.577778	10.00177864	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	92.4	9.43e-21	NR	MCH7478086.1	2024889	g7865	i0	41.4	1.80927835051546	116	60	89.7	2	388	41	22	129	MCH7478086.1 glutathione S-transferase family protein [SAR324 cluster bacterium]	diamond	702	92.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
27897467	27897467	PRJNA489308_P_NODE_15345_length_311_cov_1.655462_g15269_i0	PRJNA489308	15345	311	1.655462	5.14848682	Deltaproteobacteria bacterium ADurb.Bin51	2026735	Bacteria	Bacteria	43.5	0.0331	NR	OPZ60350.1	1852870	g15269	i0	53.2	0.453376205787781	47	21	44.4	1	104	241	66	112	OPZ60350.1 MAG: hypothetical protein BWY87_00520 [Deltaproteobacteria bacterium ADurb.Bin510]	diamond	141	43.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin510
29286755	29286755	PRJNA489308_P_NODE_27029_length_261_cov_1.978723_g26953_i0	PRJNA489308	27029	261	1.978723	5.16446703	Deltaproteobacteria bacterium ADurb.Bin2	2026735	Bacteria	Bacteria	174	1.61e-53	NR	OQB15429.1	1852869	g26953	i0	94.1	3.94252873563218	85	5	97.7	0	3	257	42	126	OQB15429.1 MAG: Peptidyl-prolyl cis-trans isomerase A [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	1029	174	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin207
31340328	31340328	PRJNA489308_P_NODE_9036_length_369_cov_1.557432_g8960_i0	PRJNA489308	9036	369	1.557432	5.74692408	Deltaproteobacteria bacterium CG2_3	2026735	Bacteria	Bacteria	89	1e-17	NR	OIP32185.1	1805126	g8960	i0	45	1.04878048780488	129	57	97.6	5	9	368	248	371	OIP32185.1 MAG: hypothetical protein AUK47_20995, partial [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	387	89	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG2_30_63_29
32099467	32099467	PRJNA489308_P_NODE_24518_length_269_cov_4.714286_g24442_i0	PRJNA489308	24518	269	4.714286	12.68142934	Microvenator marinus	2600177	Bacteria	Bacteria	55.5	1.67e-6	NR	WP_146962556.1	2600177	g24442	i0	56.3	0.535315985130111	48	19	53.5	1	204	61	356	401	WP_146962556.1 hypothetical protein [Microvenator marinus]	diamond	144	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus

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