metadata: contig_metadata: 5 rows where bioproject = "PRJNA758398" and tax

5 rows where bioproject = "PRJNA758398" and tax_clade = "delta/epsilon subdivisions"

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_species
27274365	27274365	PRJNA758398_S_NODE_42863_length_167_cov_0.864407_g42722_i0	PRJNA758398	42863	167	0.864407	1.44355969	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	51.6	9.8e-6	NR	RTZ76688.1	2024889	g42722	i0	46.8	3.97005988023952	47	25	84.4	0	152	12	62	108	RTZ76688.1 MAG: hypothetical protein DSY97_11510, partial [SAR324 cluster bacterium]	diamond	663	51.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			SAR324 cluster bacterium
28831187	28831187	PRJNA758398_S_NODE_54768_length_161_cov_0.857143_g54627_i0	PRJNA758398	54768	161	0.857143	1.38000023	Chloroflexota	200795	Bacteria	Bacteria	47.8	2.1e-4	NR	PKN56197.1	2013741	g54627	i0	74.2	1.60248447204969	31	7	55.9	1	97	8	1286	1316	PKN56197.1 MAG: hypothetical protein CVU56_17440 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	258	47.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
29074340	29074340	PRJNA758398_S_NODE_3268_length_522_cov_2.883721_g3129_i0	PRJNA758398	3268	522	2.883721	15.05302362	Bradymonadales bacterium	2099667	Bacteria	Bacteria	68.9	5.26e-10	NR	MBS7380160.1	2099667	g3129	i0	33.3	0.758620689655172	132	74	73.6	4	446	63	288	409	MBS7380160.1 DUF4215 domain-containing protein [Bradymonadales bacterium]	diamond	396	68.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales		Bradymonadales bacterium
29809941	29809941	PRJNA758398_S_NODE_27651_length_200_cov_2.013245_g27510_i0	PRJNA758398	27651	200	2.013245	4.02649	Bacteria	2	Bacteria	Bacteria	62.4	1.2e-9	NR	OGQ18271.1	1797858	g27510	i0	60.5	2.58	43	17	64.5	0	198	70	103	145	OGQ18271.1 MAG: 50S ribosomal protein L1 [Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11]	diamond	516	62.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Deltaproteobacteria bacterium RIFCSPHIGHO2_02_FULL_40_11
30779732	30779732	PRJNA758398_S_NODE_18354_length_235_cov_1.134409_g18213_i0	PRJNA758398	18354	235	1.134409	2.66586115	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	117	1.82e-28	NR	MBA2664773.1	2946527	g18213	i0	62.8	1.97872340425532	78	29	99.6	0	1	234	249	326	MBA2664773.1 S-layer homology domain-containing protein [Lujinxingiaceae bacterium]	diamond	465	117	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae	Lujinxingiaceae bacterium

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