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

5 rows where bioproject = "PRJNA293022", 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
4200486	4200486	PRJNA293022_P_NODE_54344_length_189_cov_1.342857_g53607_i0	PRJNA293022	54344	189	1.342857	2.53799973	uncultured delta proteobacterium	34034	Bacteria	Bacteria	279	6.83e-71	NTclustered	gi\|209407711\|emb\|FM242397.1\|	34034	g53607	i0	93.651	75.6137566137566	189	9	99	3	3	189	90	277	Uncultured delta proteobacterium partial 16S ribosomal RNA, clone 48 T12d-oil	blastn	14291	279	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
7437627	7437627	PRJNA293022_P_NODE_38146_length_226_cov_1.881356_g37409_i0	PRJNA293022	38146	226	1.881356	4.25186456	Bacteria	2	Bacteria	Bacteria	117	7.03e-22	NTclustered	gi\|297181813\|gb\|GU474879.1\|	710831	g37409	i0	82.353	2.46017699115044	136	23	60	1	58	193	14837	14703	Uncultured delta proteobacterium HF0200_19J16 genomic sequence	blastn	556	117	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0200_19J16
8026657	8026657	PRJNA293022_P_NODE_54747_length_188_cov_2.007194_g54010_i0	PRJNA293022	54747	188	2.007194	3.77352472	uncultured delta proteobacterium	34034	Bacteria	Bacteria	252	1.48e-62	NTclustered	gi\|283466870\|emb\|FN594673.1\|	34034	g54010	i0	91.444	94.4734042553192	187	10	98	6	3	187	185	3	Uncultured delta proteobacterium partial 16S rRNA gene, clone g1-3	blastn	17761	252	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
10577350	10577350	PRJNA293022_P_NODE_6929_length_541_cov_17.621951_g6219_i0	PRJNA293022	6929	541	17.621951	95.33475491	uncultured delta proteobacterium	34034	Bacteria	Bacteria	723	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g6219	i0	90.809	217.96303142329	544	44	100	6	1	541	14166	14706	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	117918	723	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
16950870	16950870	PRJNA293022_P_NODE_82914_length_153_cov_2.836538_g82177_i0	PRJNA293022	82914	153	2.836538	4.33990314	Persicimonas caeni	2292766	Bacteria	Bacteria	213	5.43e-51	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g82177	i0	92.053	198.673202614379	151	12	99	0	1	151	1204848	1204998	Persicimonas caeni strain YN101 chromosome	blastn	30397	213	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni

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