metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Candidatus Gottesmaniibacteriota"

9 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_phylum = "Candidatus Gottesmaniibacteriota"

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
27693471	27693471	PRJNA558770_P_NODE_189784_length_234_cov_4.195980_g187779_i0	PRJNA558770	189784	234	4.19598	9.8185932	Bacteria	2	Bacteria	Bacteria	48.9	2.13e-4	NR	OGG02732.1	1798371	g187779	i0	91.7	2.46153846153846	24	2	30.8	0	74	3	271	294	OGG02732.1 MAG: hypothetical protein A2W14_02280 [Candidatus Gottesmanbacteria bacterium RBG_16_37_8]	diamond	576	49.3	0.991886409736308	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RBG_16_37_8
27882594	27882594	PRJNA558770_P_NODE_209105_length_234_cov_3.447236_g207100_i0	PRJNA558770	209105	234	3.447236	8.06653224	Bacteria	2	Bacteria	Bacteria	43.5	0.0171	NR	OGG02442.1	1798374	g207100	i0	75	1.84615384615385	24	6	30.8	0	233	162	304	327	OGG02442.1 MAG: phosphopyruvate hydratase [Candidatus Gottesmanbacteria bacterium RBG_16_52_11]	diamond	432	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RBG_16_52_11
29541903	29541903	PRJNA558770_P_NODE_242530_length_234_cov_2.477387_g240525_i0	PRJNA558770	242530	234	2.477387	5.79708558	Candidatus Gottesmanbacteria bacterium	2282145	Bacteria	Bacteria	85.5	6.07e-18	NR	MBI3559265.1	2282145	g240525	i0	55.1	2	78	23	100	1	234	1	117	182	MBI3559265.1 hypothetical protein [Candidatus Gottesmanbacteria bacterium]	diamond	468	85.5	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium
29713556	29713556	PRJNA558770_P_NODE_347470_length_233_cov_1.843434_g345465_i0	PRJNA558770	347470	233	1.843434	4.29520122	Bacteria	2	Bacteria	Bacteria	42.7	0.0238	NR	OGG07673.1	1798377	g345465	i0	68	0.643776824034335	25	8	32.2	0	75	1	103	127	OGG07673.1 MAG: hypothetical protein A2872_01795 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12]	diamond	150	43.1	0.990719257540603	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12
30332184	30332184	PRJNA558770_P_NODE_290892_length_234_cov_1.547739_g288887_i0	PRJNA558770	290892	234	1.547739	3.62170926	Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_	2282145	Bacteria	Bacteria	45.8	0.00264	NR	OGG30499.1	1798394	g288887	i0	38.9	0.923076923076923	72	25	92.3	1	232	17	6	58	OGG30499.1 MAG: xylulokinase [Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_46_9]	diamond	216	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_46_9
30851208	30851208	PRJNA558770_P_NODE_235274_length_234_cov_2.658291_g233269_i0	PRJNA558770	235274	234	2.658291	6.22040094	Bacteria	2	Bacteria	Bacteria	46.6	0.00142	NR	KKP57531.1	1618434	g233269	i0	91.7	1.23076923076923	24	2	30.8	0	233	162	98	121	KKP57531.1 MAG: Type IV secretory pathway VirB4 component-like protein, partial [Candidatus Gottesmanbacteria bacterium GW2011_GWA1_34_13]	diamond	288	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium GW2011_GWA1_34_13
30932039	30932039	PRJNA558770_P_NODE_211834_length_234_cov_3.351759_g209829_i0	PRJNA558770	211834	234	3.351759	7.84311606	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_	2282145	Bacteria	Bacteria	54.3	2.69e-6	NR	OGG14760.1	1798375	g209829	i0	79.2	0.923076923076923	24	5	30.8	0	162	233	89	112	OGG14760.1 MAG: methionine--tRNA ligase [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_39_10]	diamond	216	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_39_10
31515333	31515333	PRJNA558770_P_NODE_251776_length_234_cov_2.271357_g249771_i0	PRJNA558770	251776	234	2.271357	5.31497538	Bacteria	2	Bacteria	Bacteria	50.4	6.45e-5	NR	KKS84220.1	1618436	g249771	i0	100	0.641025641025641	25	0	32.1	0	1	75	6	30	KKS84220.1 MAG: Pyruvate flavodoxin/ferredoxin oxidoreductase domain protein [Candidatus Gottesmanbacteria bacterium GW2011_GWA1_43_11]	diamond	150	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium GW2011_GWA1_43_11
32228783	32228783	PRJNA558770_P_NODE_147178_length_234_cov_6.623116_g145173_i0	PRJNA558770	147178	234	6.623116	15.49809144	Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_	2282145	Bacteria	Bacteria	42.4	0.0433	NR	OGG29321.1	1798394	g145173	i0	87	0.294871794871795	23	3	29.5	0	164	232	294	316	OGG29321.1 MAG: hypothetical protein A3A63_02145 [Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_46_9]	diamond	69	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_46_9

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