metadata: contig_metadata: 8 rows where bioproject = "PRJNA429937" and tax_phylum = "Candidatus Gottesmaniibacteriota"

8 rows where bioproject = "PRJNA429937" 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
26854484	26854484	PRJNA429937_P_NODE_39341_length_575_cov_4.045788_g24542_i1	PRJNA429937	39341	575	4.045788	23.263281	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_	2282145	Bacteria	Bacteria	251	1.76e-79	NR	OGG07764.1	1798377	g24542	i1	63.1	0.975652173913043	187	69	97.6	0	572	12	101	287	OGG07764.1 MAG: hypothetical protein A2872_02260 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12]	diamond	561	251	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12
27423643	27423643	PRJNA429937_P_NODE_93383_length_322_cov_3.368601_g70794_i0	PRJNA429937	93383	322	3.368601	10.84689522	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_	2282145	Bacteria	Bacteria	79.3	1.23e-14	NR	OGG21559.1	1798384	g70794	i0	71.2	0.484472049689441	52	15	48.4	0	176	21	1	52	OGG21559.1 MAG: hypothetical protein A3D03_02480 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_02_FULL_40_13]	diamond	156	79.3	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_02_FULL_40_13
28623321	28623321	PRJNA429937_P_NODE_25507_length_726_cov_4.685796_g15251_i0	PRJNA429937	25507	726	4.685796	34.01887896	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_	2282145	Bacteria	Bacteria	102	1.76e-21	NR	OGG07764.1	1798377	g15251	i0	50.6	0.359504132231405	87	43	36	0	310	50	2	88	OGG07764.1 MAG: hypothetical protein A2872_02260 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12]	diamond	261	102	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12
28844007	28844007	PRJNA429937_P_NODE_29368_length_673_cov_4.987578_g15251_i2	PRJNA429937	29368	673	4.987578	33.56639994	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_	2282145	Bacteria	Bacteria	99.8	1.08e-20	NR	OGG07764.1	1798377	g15251	i2	50.6	0.37890044576523	85	42	37.9	0	417	671	2	86	OGG07764.1 MAG: hypothetical protein A2872_02260 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12]	diamond	255	99.8	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12
29586574	29586574	PRJNA429937_P_NODE_75830_length_380_cov_4.749288_g53684_i0	PRJNA429937	75830	380	4.749288	18.0472944	Bacteria	2	Bacteria	Bacteria	147	3.8e-39	NR	KKS50878.1	1618435	g53684	i0	65	6.84473684210526	117	38	92.4	1	364	14	59	172	KKS50878.1 MAG: hypothetical protein UV17_C0067G0003 [Candidatus Gottesmanbacteria bacterium GW2011_GWA1_42_26]	diamond	2601	148	0.993243243243243	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium GW2011_GWA1_42_26
29886331	29886331	PRJNA429937_P_NODE_27171_length_702_cov_4.843982_g15251_i1	PRJNA429937	27171	702	4.843982	34.00475364	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_	2282145	Bacteria	Bacteria	110	1.04e-24	NR	OGG07764.1	1798377	g15251	i1	52.1	0.401709401709402	94	45	40.2	0	286	5	2	95	OGG07764.1 MAG: hypothetical protein A2872_02260 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12]	diamond	282	110	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12
31149545	31149545	PRJNA429937_P_NODE_38975_length_578_cov_4.089253_g24542_i0	PRJNA429937	38975	578	4.089253	23.63588234	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_	2282145	Bacteria	Bacteria	253	1.61e-80	NR	OGG07764.1	1798377	g24542	i0	64.4	0.975778546712803	188	66	97.6	1	575	12	101	287	OGG07764.1 MAG: hypothetical protein A2872_02260 [Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12]	diamond	564	253	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPHIGHO2_01_FULL_42_12
32003997	32003997	PRJNA429937_P_NODE_10138_length_1136_cov_5.595303_g5950_i0	PRJNA429937	10138	1136	5.595303	63.56264208	Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_	2282145	Bacteria	Bacteria	206	7.319999999999999e-55	NR	OGG23640.1	1798392	g5950	i0	55.9	0.448943661971831	170	73	44.9	1	737	228	1673	1840	OGG23640.1 MAG: hypothetical protein A3A79_00330 [Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_43_11b]	diamond	510	206	1	Bacteria	Bacteria candidate phyla	Candidatus Gottesmaniibacteriota	Candidatus Gottesmanbacteria bacterium RIFCSPLOWO2_01_FULL_43_11b

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