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

5 rows where bioproject = "PRJNA597223", 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_family	tax_genus	tax_species
6947669	6947669	PRJNA597223_P_NODE_71606_length_168_cov_2.090226_g69760_i0	PRJNA597223	71606	168	2.090226	3.51157968	uncultured delta proteobacterium	34034	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|927354417\|gb\|KT322951.1\|	34034	g69760	i0	93.491	100.220238095238	169	10	100	1	1	168	243	75	Uncultured delta proteobacterium clone TGR_WLFZ-771 16S ribosomal RNA gene, partial sequence	blastn	16837	250	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			uncultured delta proteobacterium
16443466	16443466	PRJNA597223_P_NODE_51673_length_194_cov_1.459119_g49827_i0	PRJNA597223	51673	194	1.459119	2.83069086	root	1	Root_unresolved	Root_unresolved	315	1.93e-81	NTclustered	gi\|26801211\|emb\|AJ532713.1\|	34034	g49827	i0	98.324	92.3814432989691	179	3	92	0	16	194	678	500	Uncultured delta proteobacterium partial 16S rRNA gene, clone JG34-KF-14	blastn	17922	315	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			uncultured delta proteobacterium
17718663	17718663	PRJNA597223_P_NODE_73694_length_165_cov_2.753846_g71848_i0	PRJNA597223	73694	165	2.753846	4.5438459	Sandaracinus	1055688	Bacteria	Bacteria	106	1.04e-18	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g71848	i0	88.506	113.739393939394	87	10	53	0	3	89	1544024	1543938	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	18767	106	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			uncultured delta proteobacterium
18992133	18992133	PRJNA597223_P_NODE_53335_length_190_cov_5.283871_g51489_i0	PRJNA597223	53335	190	5.283871	10.0393549	Nannocystis	53	Bacteria	Bacteria	143	9.42e-30	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g51489	i0	89.381	73.1842105263158	113	12	59	0	77	189	15202	15314	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	13905	143	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			uncultured delta proteobacterium
30092997	30092997	PRJNA597223_P_NODE_77812_length_160_cov_2.112000_g75966_i0	PRJNA597223	77812	160	2.112	3.3792	delta/epsilon subdivisions	68525	Bacteria	Bacteria	110	1.44e-29	NR	WP_220096280.1	1765737	g75966	i0	100	2.925	52	0	97.5	0	158	3	52	103	WP_220096280.1 zonular occludens toxin domain-containing protein, partial [Dissulfurirhabdus thermomarina]	diamond	468	110	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Dissulfurirhabdaceae	Dissulfurirhabdus	Dissulfurirhabdus thermomarina

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