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

5 rows where bioproject = "PRJNA193544", 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
1640692	1640692	PRJNA193544_S_NODE_442_length_328_cov_4.354515_g427_i0	PRJNA193544	442	328	4.354515	14.2828092	uncultured delta proteobacterium	34034	Bacteria	Bacteria	289	2.16e-73	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g427	i0	82.727	108.496951219512	330	52	99	5	1	327	13483	13810	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	35587	289	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
4192985	4192985	PRJNA193544_S_NODE_2404_length_177_cov_23.371622_g2389_i0	PRJNA193544	2404	177	23.371622	41.36777094	uncultured delta proteobacterium	34034	Bacteria	Bacteria	145	2.4e-30	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g2389	i0	81.564	129.813559322034	179	29	100	4	1	177	14248	14424	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	22977	145	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
13808640	13808640	PRJNA193544_S_NODE_1611_length_207_cov_56.870787_g1596_i0	PRJNA193544	1611	207	56.870787	117.72252909	Bacteria	2	Bacteria	Bacteria	333	5.779999999999999e-87	NTclustered	gi\|588481665\|gb\|KF956460.1\|	34034	g1596	i0	95.652	99.1835748792271	207	9	100	0	1	207	523	317	Uncultured delta proteobacterium clone NS-OTU31 16S ribosomal RNA gene, partial sequence	blastn	20531	333	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
15082769	15082769	PRJNA193544_S_NODE_1612_length_207_cov_50.382022_g1597_i0	PRJNA193544	1612	207	50.382022	104.29078554	Byssovorax	224459	Bacteria	Bacteria	327	2.69e-85	NTclustered	gi\|219962346\|gb\|FJ569886.1\|	34034	g1597	i0	95.169	100.149758454106	207	10	100	0	1	207	87	293	Uncultured delta proteobacterium clone A5YC14RM small subunit ribosomal RNA gene, partial sequence	blastn	20731	327	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
18906690	18906690	PRJNA193544_S_NODE_2115_length_187_cov_32.886076_g2100_i0	PRJNA193544	2115	187	32.886076	61.49696212	Thermodesulfobacteriota	200940	Bacteria	Bacteria	281	1.8800000000000002e-71	NTclustered	gi\|339958901\|gb\|JN015508.1\|	34034	g2100	i0	97.576	87.5454545454545	165	2	87	2	25	187	670	506	Uncultured delta proteobacterium clone ZBP-1 16S ribosomal RNA gene, partial sequence	blastn	16371	281	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium

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