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

9 rows where bioproject = "PRJNA1112809", 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
9951455	9951455	PRJNA1112809_P_NODE_157108_length_257_cov_1.255435_g153833_i0	PRJNA1112809	157108	257	1.255435	3.22646795	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	100	1.58e-22	NR	PKN58351.1	2013741	g153833	i0	59.3	1.98443579766537	86	34	99.2	1	1	255	365	450	PKN58351.1 MAG: hypothetical protein CVU56_06235 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	510	100	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
15522026	15522026	PRJNA1112809_P_NODE_143293_length_270_cov_1.563452_g140018_i0	PRJNA1112809	143293	270	1.563452	4.2213204	uncultured delta proteobacterium	34034	Bacteria	Bacteria	99	3.13e-16	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g140018	i0	85.87	14.3	92	13	34	0	8	99	1167888	1167979	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	3861	99	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	uncultured delta proteobacterium
27384074	27384074	PRJNA1112809_P_NODE_156563_length_257_cov_2.097826_g153288_i0	PRJNA1112809	156563	257	2.097826	5.39141282	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	120	7.039999999999999e-32	NR	PKN55915.1	2013741	g153288	i0	73.5	0.968871595330739	83	22	96.9	0	251	3	44	126	PKN55915.1 MAG: hypothetical protein CVU56_18760 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	249	120	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
28133025	28133025	PRJNA1112809_P_NODE_120485_length_296_cov_2.067265_g117210_i0	PRJNA1112809	120485	296	2.067265	6.1191044	Bacteria	2	Bacteria	Bacteria	96.3	1.9e-21	NR	PKN49686.1	2013748	g117210	i0	66.7	4.36824324324324	72	24	73	0	4	219	241	312	PKN49686.1 MAG: magnesium chelatase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	1293	96.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
29183852	29183852	PRJNA1112809_P_NODE_140349_length_273_cov_1.770000_g137074_i0	PRJNA1112809	140349	273	1.77	4.8321	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	48.5	2.98e-4	NR	PKN39646.1	2013748	g137074	i0	35.1	1.62637362637363	77	48	84.6	1	20	250	126	200	PKN39646.1 MAG: hypothetical protein CVU63_14935 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	444	48.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
29215476	29215476	PRJNA1112809_P_NODE_162449_length_252_cov_1.363128_g159174_i0	PRJNA1112809	162449	252	1.363128	3.43508256	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15	1797895	Bacteria	Bacteria	50.8	5.26e-5	NR	OGQ77307.1	1797895	g159174	i0	33.8	1.83333333333333	80	53	95.2	0	251	12	181	260	OGQ77307.1 MAG: hypothetical protein A2289_00095 [Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15]	diamond	462	50.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFOXYA12_FULL_58_15
29490450	29490450	PRJNA1112809_P_NODE_136730_length_277_cov_1.490196_g133455_i0	PRJNA1112809	136730	277	1.490196	4.12784292	delta/epsilon subdivisions	68525	Bacteria	Bacteria	45.8	0.00405	NR	OGQ83952.1	1797894	g133455	i0	48.2	3.89891696750903	56	27	58.5	1	28	189	205	260	OGQ83952.1 MAG: biotin--[acetyl-CoA-carboxylase] ligase [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19]	diamond	1080	46.2	0.991341991341991	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_60_19
32691512	32691512	PRJNA1112809_P_NODE_198800_length_229_cov_2.474359_g195525_i0	PRJNA1112809	198800	229	2.474359	5.66628211	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	85.9	1.81e-17	NR	PKN50070.1	2013748	g195525	i0	55.3	0.995633187772926	76	34	99.6	0	2	229	88	163	PKN50070.1 MAG: hypothetical protein CVU63_00360 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	228	85.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20
32754563	32754563	PRJNA1112809_P_NODE_156260_length_258_cov_0.718919_g152985_i0	PRJNA1112809	156260	258	0.718919	1.85481102	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-2	2013747	Bacteria	Bacteria	135	1.2599999999999999e-34	NR	PKN49034.1	2013748	g152985	i0	70.2	0.976744186046512	84	25	97.7	0	5	256	221	304	PKN49034.1 MAG: hypothetical protein CVU63_03280 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20]	diamond	252	135	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20

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