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

5 rows where bioproject = "PRJNA682078" 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_genus	tax_species
7040488	7040488	PRJNA682078_P_NODE_273346_length_243_cov_1.811765_g271569_i0	PRJNA682078	273346	243	1.811765	4.40258895	Dissulfurimicrobium hydrothermale	1750598	Bacteria	Bacteria	115	2.7500000000000003e-21	NTclustered	gi\|2190143862\|gb\|CP085041.1\|	1750598	g271569	i0	84.956	45.8477366255144	113	17	47	0	131	243	693391	693503	Dissulfurimicrobium hydrothermale strain Sh68 chromosome, complete genome	blastn	11141	115	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Dissulfurimicrobium	Dissulfurimicrobium hydrothermale
14691883	14691883	PRJNA682078_P_NODE_49392_length_487_cov_2.181159_g47624_i0	PRJNA682078	49392	487	2.181159	10.62224433	uncultured delta proteobacterium	34034	Bacteria	Bacteria	562	1.77e-155	NTclustered	gi\|927354504\|gb\|KT323038.1\|	34034	g47624	i0	92.802	65.3716632443532	389	27	80	1	1	388	29	417	Uncultured delta proteobacterium clone TGR_WLFZ-858 16S ribosomal RNA gene, partial sequence	blastn	31836	562	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
19787176	19787176	PRJNA682078_P_NODE_207336_length_259_cov_1.048387_g205559_i0	PRJNA682078	207336	259	1.048387	2.71532233	Deltaproteobacteria bacterium Smac51	2946587	Bacteria	Bacteria	121	6.38e-23	NTclustered	gi\|2242725236\|gb\|CP026657.1\|	2946587	g205559	i0	84.874	16.5714285714286	119	18	46	0	21	139	888506	888624	Deltaproteobacteria bacterium Smac51 chromosome, complete genome	blastn	4292	121	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium Smac51
27725965	27725965	PRJNA682078_P_NODE_232884_length_250_cov_0.870056_g231107_i0	PRJNA682078	232884	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	68.2	4.68e-11	NR	OQB11111.1	1852869	g231107	i0	50.6	3.768	79	35	94.8	2	246	10	811	885	OQB11111.1 MAG: FG-GAP repeat protein [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	942	68.6	0.994169096209913	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium ADurb.Bin207
31282702	31282702	PRJNA682078_P_NODE_248475_length_247_cov_0.885057_g246698_i0	PRJNA682078	248475	247	0.885057	2.18609079	Deltaproteobacteria bacterium ADurb.Bin2	2026735	Bacteria	Bacteria	43.5	0.0194	NR	OQB14652.1	1852869	g246698	i0	39.1	0.777327935222672	64	36	75.3	2	240	55	67	129	OQB14652.1 MAG: hypothetical protein BWY17_02441 [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	192	43.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium ADurb.Bin207

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