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

5 rows where bioproject = "PRJNA1122875", 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
7406585	7406585	PRJNA1122875_P_NODE_22426_length_350_cov_1.960289_g22202_i0	PRJNA1122875	22426	350	1.960289	6.8610115	Bacteria	2	Bacteria	Bacteria	276	1.7999999999999998e-69	NTclustered	gi\|429144172\|gb\|KC006355.1\|	34034	g22202	i0	100	71.4142857142857	149	0	85	0	5	153	224	372	Uncultured delta proteobacterium clone M7N28 16S ribosomal RNA gene, partial sequence	blastn	24995	276	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
27196377	27196377	PRJNA1122875_P_NODE_28262_length_309_cov_1.728814_g28038_i0	PRJNA1122875	28262	309	1.728814	5.34203526	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	58.9	2.05e-8	NR	MCH8882475.1	2024889	g28038	i0	47.7	0.631067961165049	65	34	63.1	0	208	14	21	85	MCH8882475.1 hypothetical protein [SAR324 cluster bacterium]	diamond	195	58.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster bacterium
30070068	30070068	PRJNA1122875_P_NODE_33632_length_284_cov_1.459716_g33408_i0	PRJNA1122875	33632	284	1.459716	4.14559344	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15	1797895	Bacteria	Bacteria	81.6	1.42e-16	NR	OGQ91000.1	1797895	g33408	i0	46.5	0.908450704225352	86	43	90.8	1	263	6	42	124	OGQ91000.1 MAG: hypothetical protein A2289_00830 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	258	81.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
30122435	30122435	PRJNA1122875_P_NODE_21812_length_355_cov_1.932624_g21588_i0	PRJNA1122875	21812	355	1.932624	6.8608152	Bacteria	2	Bacteria	Bacteria	159	4.4399999999999996e-43	NR	MBF0237851.1	2024889	g21588	i0	63.7	9.7943661971831	113	38	94.6	2	352	17	453	563	MBF0237851.1 phosphoenolpyruvate carboxykinase (GTP) [SAR324 cluster bacterium]	diamond	3477	159	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster bacterium
30164741	30164741	PRJNA1122875_P_NODE_6532_length_627_cov_1.527076_g6316_i0	PRJNA1122875	6532	627	1.527076	9.57476652	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	63.5	8.18e-8	NR	MDG2063940.1	2024889	g6316	i0	36	0.650717703349282	136	75	62.7	6	1	393	185	313	MDG2063940.1 LamG domain-containing protein [SAR324 cluster bacterium]	diamond	408	63.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	SAR324 cluster 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);;