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

6 rows where bioproject = "PRJNA715462", 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_species
26935853	26935853	PRJNA715462_P_NODE_54222_length_249_cov_0.875000_g53426_i0	PRJNA715462	54222	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	47.8	5.53e-4	NR	MBF0276939.1	2024889	g53426	i0	53.7	1.96385542168675	41	19	49.4	0	3	125	190	230	MBF0276939.1 hypothetical protein [SAR324 cluster bacterium]	diamond	489	47.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		SAR324 cluster bacterium
29073229	29073229	PRJNA715462_P_NODE_59048_length_246_cov_2.393064_g58252_i0	PRJNA715462	59048	246	2.393064	5.88693744	Bradymonadales bacterium	2099667	Bacteria	Bacteria	53.9	3.74e-7	NR	MFA5624936.1	2099667	g58252	i0	44.4	0.768292682926829	63	31	76.8	1	190	2	1	59	MFA5624936.1 HU family DNA-binding protein [Bradymonadales bacterium]	diamond	189	53.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadales bacterium
29799101	29799101	PRJNA715462_P_NODE_14851_length_508_cov_1.032184_g14056_i0	PRJNA715462	14851	508	1.032184	5.24349472	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	90.5	9.96e-18	NR	PKN55183.1	2013741	g14056	i0	33.9	2.03740157480315	192	100	97.4	6	502	8	181	372	PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	1035	90.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
31094561	31094561	PRJNA715462_P_NODE_69775_length_240_cov_2.185629_g68979_i0	PRJNA715462	69775	240	2.185629	5.2455096	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-13	2013740	Bacteria	Bacteria	47.8	6.03e-4	NR	PKN53087.1	2013740	g68979	i0	35.9	2.6	64	41	80	0	227	36	519	582	PKN53087.1 MAG: hypothetical protein CVU55_03870 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-13]	diamond	624	47.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium HGW-Deltaproteobacteria-13
31199494	31199494	PRJNA715462_P_NODE_42615_length_273_cov_1.345000_g41819_i0	PRJNA715462	42615	273	1.345	3.67185	Myxococcota	2818505	Bacteria	Bacteria	125	3.36e-31	NR	OLC77861.1	1805121	g41819	i0	64.4	9.85714285714286	90	32	98.9	0	272	3	470	559	OLC77861.1 MAG: propionyl-CoA synthetase [Deltaproteobacteria bacterium 13_1_40CM_4_68_19]	diamond	2691	125	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium 13_1_40CM_4_68_19
31410831	31410831	PRJNA715462_P_NODE_3316_length_1438_cov_5.600733_g2872_i0	PRJNA715462	3316	1438	5.600733	80.53854054	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	151	1.19e-36	NR	PKN55183.1	2013741	g2872	i0	36.9	1.12656467315716	271	135	50.7	7	1050	322	170	432	PKN55183.1 MAG: hypothetical protein CVU56_22585 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	1620	151	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);;