metadata: contig_metadata: 7 rows where bioproject = "PRJEB58983" and tax

7 rows where bioproject = "PRJEB58983" 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_species
7777664	7777664	PRJEB58983_P_NODE_6567_length_481_cov_3.259804_g6153_i0	PRJEB58983	6567	481	3.259804	15.67965724	uncultured delta proteobacterium	34034	Bacteria	Bacteria	579	1.7399999999999993e-160	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g6153	i0	88.406	129.619542619543	483	53	100	3	1	481	81952	82433	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	62347	579	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
11603453	11603453	PRJEB58983_P_NODE_29690_length_248_cov_1.782857_g29275_i0	PRJEB58983	29690	248	1.782857	4.42148536	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	315	2.59e-81	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g29275	i0	90.123	167.854838709677	243	23	98	1	6	248	13304	13063	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	41628	315	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium HF0010_01J10
15427338	15427338	PRJEB58983_P_NODE_26273_length_259_cov_2.333333_g25858_i0	PRJEB58983	26273	259	2.333333	6.04333247	uncultured delta proteobacterium	34034	Bacteria	Bacteria	268	2.1499999999999998e-67	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g25858	i0	86.345	27.0849420849421	249	31	95	2	1	247	13666	13419	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	7015	268	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
16701796	16701796	PRJEB58983_P_NODE_34934_length_220_cov_4.054422_g34519_i0	PRJEB58983	34934	220	4.054422	8.9197284	uncultured delta proteobacterium	34034	Bacteria	Bacteria	350	6.17e-92	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g34519	i0	95.434	184.045454545455	219	10	99	0	1	219	81230	81012	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	40490	350	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
17976252	17976252	PRJEB58983_P_NODE_12375_length_358_cov_2.719298_g11960_i0	PRJEB58983	12375	358	2.719298	9.73508684	uncultured delta proteobacterium	34034	Bacteria	Bacteria	424	6.24e-114	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g11960	i0	93.403	374.586592178771	288	15	80	4	73	358	83949	83664	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	134102	424	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
17976409	17976409	PRJEB58983_P_NODE_19955_length_290_cov_1.990783_g19540_i0	PRJEB58983	19955	290	1.990783	5.7732707	uncultured delta proteobacterium	34034	Bacteria	Bacteria	220	6.96e-53	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g19540	i0	80.479	1.00689655172414	292	54	100	3	1	290	1331554	1331844	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	292	220	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
29907364	29907364	PRJEB58983_P_NODE_12551_length_356_cov_1.908127_g12136_i0	PRJEB58983	12551	356	1.908127	6.79293212	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	114	6.3099999999999996e-27	NR	MBF0276877.1	2024889	g12136	i0	48.7	0.985955056179775	117	58	97.8	2	2	349	145	260	MBF0276877.1 M20/M25/M40 family metallo-hydrolase [SAR324 cluster bacterium]	diamond	351	114	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);;