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

14 rows where bioproject = "PRJEB20058", 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
25652640	25652640	PRJEB20058_P_NODE_191762_length_263_cov_4.509901_g188938_i0	PRJEB20058	191762	263	4.509901	11.86103963	uncultured delta proteobacterium DeepAnt-32C6	357895	Bacteria	Bacteria	86.1	2.37e-12	NTclustered	gi\|82617838\|gb\|DQ267496.1\|	357895	g188938	i0	76.829	12.212927756654	164	30	61	8	4	164	3163	3005	Uncultured delta proteobacterium DeepAnt-32C6 fosmid, complete sequence	blastn	3212	86.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-32C6
25655450	25655450	PRJEB20058_P_NODE_35610_length_705_cov_2.349379_g33028_i0	PRJEB20058	35610	705	2.349379	16.56312195	Bradymonadaceae bacterium	2740543	Bacteria	Bacteria	295	1.0399999999999999e-95	NR	MFU8802832.1	2740543	g33028	i0	72.2	0.825531914893617	194	54	82.6	0	23	604	63	256	MFU8802832.1 phosphopentomutase [Bradymonadaceae bacterium]	diamond	582	295	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae		Bradymonadaceae bacterium
25748809	25748809	PRJEB20058_P_NODE_144698_length_321_cov_18.830769_g141877_i0	PRJEB20058	144698	321	18.830769	60.44676849	Thermodesulfobacteriota	200940	Bacteria	Bacteria	424	5.54e-114	NTclustered	gi\|2874253888\|emb\|OY970063.1\|	34034	g141877	i0	92.079	171.031152647975	303	20	93	4	1	300	628182	628483	MAG: uncultured delta proteobacterium isolate MFD10007.bin.1.119 genome assembly, chromosome: 1	blastn	54901	424	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
25794793	25794793	PRJEB20058_P_NODE_98555_length_411_cov_1.097143_g95749_i0	PRJEB20058	98555	411	1.097143	4.50925773	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	120	6.26e-29	NR	MBA2660728.1	2946527	g95749	i0	84.1	0.503649635036496	69	11	50.4	0	188	394	5	73	MBA2660728.1 asparagine--tRNA ligase [Lujinxingiaceae bacterium]	diamond	207	120	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
25886744	25886744	PRJEB20058_P_NODE_55795_length_562_cov_6.972056_g53046_i0	PRJEB20058	55795	562	6.972056	39.18295472	Bacteria	2	Bacteria	Bacteria	776	0	NTclustered	gi\|296171887\|emb\|FN668062.2\|	34034	g53046	i0	93.11	90.7224199288256	537	26	95	6	1	532	531	1	Uncultured delta proteobacterium partial 16S rRNA gene, clone ZS-4-53	blastn	50986	776	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
25924437	25924437	PRJEB20058_P_NODE_178644_length_277_cov_10.662037_g175821_i0	PRJEB20058	178644	277	10.662037	29.53384249	uncultured delta proteobacterium	34034	Bacteria	Bacteria	134	8.850000000000001e-27	NTclustered	gi\|1356668420\|gb\|MG520377.1\|	34034	g175821	i0	79.781	7.014440433213	183	37	66	0	82	264	175	357	Uncultured delta proteobacterium clone CS110 16S ribosomal RNA gene, partial sequence	blastn	1943	134	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26058262	26058262	PRJEB20058_P_NODE_129581_length_346_cov_25.522807_g126762_i0	PRJEB20058	129581	346	25.522807	88.30891222	uncultured delta proteobacterium	34034	Bacteria	Bacteria	278	4.96e-70	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g126762	i0	82.371	243.696531791908	329	48	94	10	23	346	83740	83417	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	84319	278	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26195957	26195957	PRJEB20058_P_NODE_159358_length_300_cov_25.000000_g156535_i0	PRJEB20058	159358	300	25	75	Microvenator marinus	2600177	Bacteria	Bacteria	276	1.52e-69	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g156535	i0	84.838	110.133333333333	277	39	92	3	6	281	701552	701826	Microvenator marinus strain V1718 chromosome, complete genome	blastn	33040	276	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
26332176	26332176	PRJEB20058_P_NODE_170767_length_286_cov_10.484444_g167944_i0	PRJEB20058	170767	286	10.484444	29.98550984	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	377	3.84e-100	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g167944	i0	93.05	131.520979020979	259	17	90	1	7	264	4040	3782	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	37615	377	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
26333251	26333251	PRJEB20058_P_NODE_196463_length_259_cov_1.055556_g193639_i0	PRJEB20058	196463	259	1.055556	2.73389004	Bradymonas sediminis	1548548	Bacteria	Bacteria	124	4.9299999999999996e-24	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g193639	i0	81.457	10.1814671814672	151	28	58	0	1	151	3786474	3786624	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	2637	124	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
26428945	26428945	PRJEB20058_P_NODE_156791_length_304_cov_2.773663_g153968_i0	PRJEB20058	156791	304	2.773663	8.43193552	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	95.1	1.36e-20	NR	PKN57304.1	2013741	g153968	i0	60.8	1.56907894736842	79	30	78	1	43	279	2	79	PKN57304.1 MAG: hypothetical protein CVU56_11720 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	477	95.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
32944951	32944951	PRJEB20058_P_NODE_154730_length_307_cov_2.048780_g151907_i0	PRJEB20058	154730	307	2.04878	6.2897546	Persicimonas caeni	2292766	Bacteria	Bacteria	65.1	3.51e-10	NR	WP_141197294.1	2292766	g151907	i0	82.8	0.283387622149837	29	5	28.3	0	219	305	168	196	WP_141197294.1 hypothetical protein [Persicimonas caeni]	diamond	87	65.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
33008294	33008294	PRJEB20058_P_NODE_173259_length_283_cov_13.513514_g170436_i0	PRJEB20058	173259	283	13.513514	38.24324462	Bdellovibrionota	3018035	Bacteria	Bacteria	48.9	2.49e-4	NR	PIR23413.1	1973974	g170436	i0	55.3	0.985865724381625	47	19	49.8	1	281	141	160	204	PIR23413.1 MAG: hypothetical protein COV44_02920 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16]	diamond	279	48.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16
33042368	33042368	PRJEB20058_P_NODE_112212_length_380_cov_2.965517_g109399_i0	PRJEB20058	112212	380	2.965517	11.2689646	Myxococcota	2818505	Bacteria	Bacteria	45.4	0.0171	NR	KPJ58989.1	1703397	g109399	i0	37.1	4.05789473684211	62	38	48.9	1	20	205	320	380	KPJ58989.1 MAG: hypothetical protein AMJ42_02355 [Deltaproteobacteria bacterium DG_8]	diamond	1542	45.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium DG_8

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