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

9 rows where bioproject = "PRJNA884104", 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_species
27687645	27687645	PRJNA884104_S_NODE_56344_length_279_cov_0.859223_g55601_i0	PRJNA884104	56344	279	0.859223	2.39723217	Olavius algarvensis Delta 1 endosymbiont	334747	Bacteria	Bacteria	40	0.04	NR	CAB1085163.1	334747	g55601	i0	41.7	0.387096774193548	36	21	38.7	0	57	164	1	36	CAB1085163.1 hypothetical protein D1AOALGA4SA_12656 [Olavius algarvensis Delta 1 endosymbiont]	diamond	108	40	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Olavius algarvensis Delta 1 endosymbiont
28066100	28066100	PRJNA884104_S_NODE_49965_length_296_cov_1.174888_g49222_i0	PRJNA884104	49965	296	1.174888	3.47766848	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	98.2	2.1e-21	NR	PKN56436.1	2013741	g49222	i0	51.2	0.871621621621622	86	38	87.2	2	21	278	461	542	PKN56436.1 MAG: hypothetical protein CVU56_16230, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	258	98.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
29076629	29076629	PRJNA884104_S_NODE_13248_length_553_cov_2.179167_g12516_i0	PRJNA884104	13248	553	2.179167	12.05079351	Olavius algarvensis associated proteobacterium Delta 3	426688	Bacteria	Bacteria	54.7	2.47e-5	NR	CAB5080511.1	426688	g12516	i0	28.6	1.49186256781193	168	106	90.1	6	515	18	48	203	CAB5080511.1 hypothetical protein D3OALGB2SA_522 [Olavius algarvensis associated proteobacterium Delta 3]	diamond	825	54.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Olavius algarvensis associated proteobacterium Delta 3
29234458	29234458	PRJNA884104_S_NODE_3549_length_1068_cov_2.787940_g3104_i0	PRJNA884104	3549	1068	2.78794	29.7751992	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	142	1.6399999999999999e-34	NR	PKN55183.1	2013741	g3104	i0	32.8	1.64325842696629	329	173	84	11	165	1061	122	432	PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	1755	142	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
29305350	29305350	PRJNA884104_S_NODE_51109_length_293_cov_1.050000_g50366_i0	PRJNA884104	51109	293	1.05	3.0765	Bacteria	2	Bacteria	Bacteria	77.4	4.59e-14	NR	OGQ89419.1	1797895	g50366	i0	39.5	1.76109215017065	86	52	88.1	0	285	28	1179	1264	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	516	77.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
29486739	29486739	PRJNA884104_S_NODE_53510_length_286_cov_1.319249_g52767_i0	PRJNA884104	53510	286	1.319249	3.77305214	Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12	1973967	Bacteria	Bacteria	96.3	9.49e-21	NR	PJB48295.1	1973967	g52767	i0	52.9	2.84265734265734	85	34	89.2	4	284	30	638	716	PJB48295.1 MAG: hypothetical protein CO108_02605 [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12]	diamond	813	96.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12
31129303	31129303	PRJNA884104_S_NODE_37215_length_338_cov_1.075472_g36472_i0	PRJNA884104	37215	338	1.075472	3.63509536	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	45.8	0.00924	NR	MCH9044750.1	2024889	g36472	i0	40.3	1.21597633136095	62	35	55	1	334	149	793	852	MCH9044750.1 type I DNA topoisomerase [SAR324 cluster bacterium]	diamond	411	45.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster bacterium
31382722	31382722	PRJNA884104_S_NODE_34736_length_348_cov_1.680000_g33993_i0	PRJNA884104	34736	348	1.68	5.8464	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	48.1	0.00148	NR	MEC8593242.1	2024889	g33993	i0	62.1	1.1551724137931	29	11	25	0	292	206	311	339	MEC8593242.1 caspase family protein [SAR324 cluster bacterium]	diamond	402	48.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster bacterium
31643404	31643404	PRJNA884104_S_NODE_76956_length_246_cov_1.144509_g76213_i0	PRJNA884104	76956	246	1.144509	2.81549214	Bacteria	2	Bacteria	Bacteria	52.8	1.2e-5	NR	OGQ89419.1	1797895	g76213	i0	42.9	1.53658536585366	63	34	76.8	2	4	192	1209	1269	OGQ89419.1 MAG: hypothetical protein A2289_07420 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	378	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15

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