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

7 rows where bioproject = "PRJNA745553", 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
724342	724342	PRJNA745553_S_NODE_3961_length_543_cov_2.889362_g3773_i0	PRJNA745553	3961	543	2.889362	15.68923566	uncultured delta proteobacterium HF0070_10I02	710824	Bacteria	Bacteria	353	1.31e-92	NTclustered	gi\|297181000\|gb\|GU474857.1\|	710824	g3773	i0	79.238	66.3462246777164	525	96	95	13	4	520	6702	6183	Uncultured delta proteobacterium HF0070_10I02 genomic sequence	blastn	36026	353	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium HF0070_10I02
10928084	10928084	PRJNA745553_S_NODE_15989_length_308_cov_6.834043_g15794_i0	PRJNA745553	15989	308	6.834043	21.04885244	uncultured delta proteobacterium	34034	Bacteria	Bacteria	165	3.54e-36	NTclustered	gi\|60266479\|gb\|AY921933.1\|	34034	g15794	i0	76.49	14.9058441558442	302	71	98	0	7	308	999	698	Uncultured delta proteobacterium clone AKYG909 16S ribosomal RNA gene, partial sequence	blastn	4591	165	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
12203929	12203929	PRJNA745553_S_NODE_8210_length_418_cov_8.257971_g8015_i0	PRJNA745553	8210	418	8.257971	34.51831878	uncultured delta proteobacterium	34034	Bacteria	Bacteria	549	1.1699999999999996e-151	NTclustered	gi\|389546025\|gb\|JQ400953.1\|	34034	g8015	i0	95.627	78.6507177033493	343	13	82	1	78	418	1	343	Uncultured delta proteobacterium clone CNY_00893 16S ribosomal RNA gene, partial sequence	blastn	32876	549	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
17302204	17302204	PRJNA745553_S_NODE_16634_length_302_cov_4052.397380_g16439_i0	PRJNA745553	16634	302	4052.39738	12238.2400876	uncultured delta proteobacterium	34034	Bacteria	Bacteria	110	1.64e-19	NTclustered	gi\|1356668420\|gb\|MG520377.1\|	34034	g16439	i0	82.787	26.4172185430464	122	21	40	0	160	281	363	242	Uncultured delta proteobacterium clone CS110 16S ribosomal RNA gene, partial sequence	blastn	7978	110	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
18576047	18576047	PRJNA745553_S_NODE_3715_length_554_cov_5.804574_g3530_i0	PRJNA745553	3715	554	5.804574	32.15733996	uncultured delta proteobacterium	34034	Bacteria	Bacteria	584	4.349999999999999e-162	NTclustered	gi\|2874253888\|emb\|OY970063.1\|	34034	g3530	i0	87.259	214.56678700361	518	58	92	8	35	546	629593	629078	MAG: uncultured delta proteobacterium isolate MFD10007.bin.1.119 genome assembly, chromosome: 1	blastn	118870	584	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
24950527	24950527	PRJNA745553_S_NODE_11040_length_367_cov_7.986395_g10845_i0	PRJNA745553	11040	367	7.986395	29.31006965	uncultured delta proteobacterium	34034	Bacteria	Bacteria	185	3.289999999999999e-42	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g10845	i0	76.267	73.0653950953678	375	74	99	13	4	367	1500162	1500532	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	26815	185	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
30947582	30947582	PRJNA745553_S_NODE_15154_length_316_cov_7.296296_g14959_i0	PRJNA745553	15154	316	7.296296	23.05629536	Minicystis	1649470	Bacteria	Bacteria	64.3	1.57e-10	NR	OQB19054.1	1852869	g14959	i0	50	3.31329113924051	50	25	47.5	0	182	33	81	130	OQB19054.1 MAG: hypothetical protein BWY17_00214 [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	1047	64.7	0.993817619783617	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);;