metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax

9 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Candidatus Woeseibacteriota"

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_phylum	tax_species
32910368	32910368	PRJEB20058_P_NODE_106417_length_392_cov_103.347432_g103609_i0	PRJEB20058	106417	392	103.347432	405.12193344	Candidatus Woesebacteria bacterium GW2	2026804	Bacteria	Bacteria	133	9.63e-35	NR	KKR00120.1	1618574	g103609	i0	58.6	0.849489795918367	111	46	84.9	0	363	31	33	143	KKR00120.1 MAG: hypothetical protein UT24_C0016G0009 [Candidatus Woesebacteria bacterium GW2011_GWB1_39_12]	diamond	333	133	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWB1_39_12
32927606	32927606	PRJEB20058_P_NODE_120121_length_364_cov_6.188119_g117305_i0	PRJEB20058	120121	364	6.188119	22.52475316	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	45.4	0.0158	NR	MBP9702221.1	2026804	g117305	i0	52.5	0.634615384615385	40	19	33	0	94	213	1	40	MBP9702221.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	231	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
32928032	32928032	PRJEB20058_P_NODE_19281_length_945_cov_7.361991_g17236_i0	PRJEB20058	19281	945	7.361991	69.57081495	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	259	2.91e-79	NR	HNQ31229.1	2026804	g17236	i0	75.1	0.574603174603175	181	17	57.5	1	9	551	324	476	HNQ31229.1 class I tRNA ligase family protein [Candidatus Woesebacteria bacterium]	diamond	543	259	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
32945635	32945635	PRJEB20058_P_NODE_53290_length_576_cov_3.805825_g50551_i0	PRJEB20058	53290	576	3.805825	21.921552	Candidatus Woesebacteria bacterium RBG_13_36_22	1802478	Bacteria	Bacteria	102	1.41e-24	NR	OGM08873.1	1802478	g50551	i0	51.6	0.494791666666667	95	44	48.4	1	49	327	5	99	OGM08873.1 MAG: hypothetical protein A2Z67_02590 [Candidatus Woesebacteria bacterium RBG_13_36_22]	diamond	285	102	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium RBG_13_36_22
32945943	32945943	PRJEB20058_P_NODE_99274_length_409_cov_2.988506_g96467_i0	PRJEB20058	99274	409	2.988506	12.22298954	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	166	3.48e-50	NR	HNQ32026.1	2026804	g96467	i0	96.2	0.579462102689487	79	3	57.9	0	22	258	32	110	HNQ32026.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	237	166	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
32996095	32996095	PRJEB20058_P_NODE_144931_length_321_cov_4.023077_g142110_i0	PRJEB20058	144931	321	4.023077	12.91407717	Candidatus Woesebacteria bacterium GWB1_37_5	1802473	Bacteria	Bacteria	152	5.28e-41	NR	OGM05510.1	1802473	g142110	i0	71.3	2.11214953271028	108	28	98.1	1	320	6	100	207	OGM05510.1 MAG: hypothetical protein A2124_05535 [Candidatus Woesebacteria bacterium GWB1_37_5]	diamond	678	152	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GWB1_37_5
33008380	33008380	PRJEB20058_P_NODE_39763_length_667_cov_7.828383_g37126_i0	PRJEB20058	39763	667	7.828383	52.21531461	Bacteria	2	Bacteria	Bacteria	270	2.5e-86	NR	HNY04520.1	2026804	g37126	i0	85.2	4.02098950524738	149	22	67	0	531	85	22	170	HNY04520.1 tyrosine--tRNA ligase [Candidatus Woesebacteria bacterium]	diamond	2682	270	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
33030655	33030655	PRJEB20058_P_NODE_201804_length_255_cov_1.376289_g198980_i0	PRJEB20058	201804	255	1.376289	3.50953695	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	89.4	4.48e-20	NR	HCR36337.1	2026804	g198980	i0	57.9	0.894117647058824	76	32	89.4	0	14	241	1	76	HCR36337.1 hypothetical protein [Candidatus Woesebacteria bacterium]	diamond	228	89.4	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
33127806	33127806	PRJEB20058_P_NODE_229327_length_232_cov_44.959064_g226502_i0	PRJEB20058	229327	232	44.959064	104.30502848	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	2.35e-18	NR	KKT66813.1	1618564	g226502	i0	65.2	4.96551724137931	66	23	85.3	0	210	13	35	100	KKT66813.1 MAG: Ribonuclease HI [Candidatus Woesebacteria bacterium GW2011_GWA2_44_33]	diamond	1152	83.6	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium GW2011_GWA2_44_33

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