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

5 rows where bioproject = "PRJNA975724", 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
18798109	18798109	PRJNA975724_S_NODE_4655_length_531_cov_2.124454_g4476_i0	PRJNA975724	4655	531	2.124454	11.28085074	uncultured delta proteobacterium	34034	Bacteria	Bacteria	641	2.4299999999999993e-179	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g4476	i0	88.555	129.195856873823	533	56	100	4	1	531	12910	13439	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	68603	641	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
22944560	22944560	PRJNA975724_S_NODE_82518_length_248_cov_0.880000_g82337_i0	PRJNA975724	82518	248	0.88	2.1824	Bdellovibrionota	3018035	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|343206979\|gb\|JN371756.1\|	34034	g82337	i0	100	96.9758064516129	248	0	100	0	1	248	389	142	Uncultured delta proteobacterium clone B12-54 16S ribosomal RNA gene, partial sequence	blastn	24050	459	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
28485067	28485067	PRJNA975724_S_NODE_24806_length_366_cov_3.627986_g24625_i0	PRJNA975724	24806	366	3.627986	13.27842876	Lujinxingia	2653226	Bacteria	Bacteria	86.7	6.81e-17	NR	WP_111730078.1	2211119	g24625	i0	56.9	7.98360655737705	72	31	59	0	366	151	1914	1985	WP_111730078.1 alpha-2-macroglobulin family protein [Lujinxingia litoralis]	diamond	2922	87	0.996551724137931	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingia	Lujinxingia litoralis
31131576	31131576	PRJNA975724_S_NODE_91855_length_240_cov_3.574850_g91674_i0	PRJNA975724	91855	240	3.57485	8.57964	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	47	6.81e-4	NR	PKN46214.1	2013748	g91674	i0	47.9	1.125	48	23	60	1	217	74	140	185	PKN46214.1 MAG: macrodomain protein [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	270	47	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
32781842	32781842	PRJNA975724_S_NODE_1400_length_734_cov_4.080182_g1250_i0	PRJNA975724	1400	734	4.080182	29.94853588	Bacteria	2	Bacteria	Bacteria	82.4	7.44e-14	NR	OGQ23606.1	1797862	g1250	i0	52.1	1.44686648501362	71	32	28.2	1	734	528	1000	1070	OGQ23606.1 MAG: carbamoyl phosphate synthase large subunit [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_44_16]	diamond	1062	83.2	0.990384615384615	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_44_16

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