metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Candidatus Moraniibacteriota"

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
26889109	26889109	PRJNA556992_P_NODE_841201_length_244_cov_0.900585_g839011_i0	PRJNA556992	841201	244	0.900585	2.1974274	Candidatus Moranbacteria bacterium GW2	1618715	Bacteria	Bacteria	97.1	1.9799999999999998e-23	NR	KKP58937.1	1618715	g839011	i0	64.9	0.94672131147541	77	27	94.7	0	231	1	1	77	KKP58937.1 MAG: hypothetical protein UR51_C0002G0090 [Candidatus Moranbacteria bacterium GW2011_GWF1_34_10]	diamond	231	97.1	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moranbacteria bacterium GW2011_GWF1_34_10
27299641	27299641	PRJNA556992_P_NODE_1102383_length_212_cov_5.122302_g1100192_i0	PRJNA556992	1102383	212	5.122302	10.85928024	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	107	7.5e-26	NR	MDD3965333.1	2045217	g1100192	i0	98.1	0.735849056603774	52	1	73.6	0	157	2	1	52	MDD3965333.1 transposase [Candidatus Moraniibacteriota bacterium]	diamond	156	107	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
27710937	27710937	PRJNA556992_P_NODE_750384_length_248_cov_3.840000_g748195_i0	PRJNA556992	750384	248	3.84	9.5232	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	56.6	9.17e-8	NR	TXH06858.1	2045217	g748195	i0	96.2	9.12096774193548	26	1	31.5	0	78	1	5	30	TXH06858.1 MAG: VOC family protein [Candidatus Moraniibacteriota bacterium]	diamond	2262	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
28594519	28594519	PRJNA556992_P_NODE_406967_length_276_cov_1.399015_g404778_i0	PRJNA556992	406967	276	1.399015	3.8612814	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	122	8.22e-33	NR	MCX6762605.1	2045217	g404778	i0	58.7	1	92	38	100	0	276	1	40	131	MCX6762605.1 imidazole glycerol phosphate synthase subunit HisH [Candidatus Moraniibacteriota bacterium]	diamond	276	122	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
28689170	28689170	PRJNA556992_P_NODE_1140487_length_203_cov_8.323077_g1138296_i0	PRJNA556992	1140487	203	8.323077	16.89584631	Candidatus Moranbacteria bacterium RIFCSPHIGHO2_	1801637	Bacteria	Bacteria	76.6	1.68e-14	NR	OGI14258.1	1801637	g1138296	i0	67.2	0.990147783251232	67	22	99	0	201	1	124	190	OGI14258.1 MAG: redox-regulated ATPase YchF [Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31]	diamond	201	76.6	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moranbacteria bacterium RIFCSPHIGHO2_01_FULL_54_31
29288790	29288790	PRJNA556992_P_NODE_144289_length_362_cov_4.217993_g142101_i0	PRJNA556992	144289	362	4.217993	15.26913466	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	136	3.639999999999999e-35	NR	HDZ85889.1	2045217	g142101	i0	53.6	0.92817679558011	112	52	92.8	0	4	339	73	184	HDZ85889.1 DNA-binding protein [Candidatus Moraniibacteriota bacterium]	diamond	336	136	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
29541460	29541460	PRJNA556992_P_NODE_311270_length_287_cov_1.887850_g309081_i0	PRJNA556992	311270	287	1.88785	5.4181295	Candidatus Moranbacteria bacterium CG_4_8_14_3_um_filter_41_13	1974659	Bacteria	Bacteria	72.8	5.82e-13	NR	PIW94258.1	1974659	g309081	i0	53.7	2.21602787456446	54	25	56.4	0	2	163	199	252	PIW94258.1 MAG: DNA/RNA non-specific endonuclease [Candidatus Moranbacteria bacterium CG_4_8_14_3_um_filter_41_13]	diamond	636	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moranbacteria bacterium CG_4_8_14_3_um_filter_41_13
30110367	30110367	PRJNA556992_P_NODE_991192_length_231_cov_4.170886_g989002_i0	PRJNA556992	991192	231	4.170886	9.63474666	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	52	1.77e-5	NR	MEI6650363.1	2045217	g989002	i0	41.6	1	77	36	98.7	2	1	228	315	383	MEI6650363.1 ABC transporter ATP-binding protein [Candidatus Moraniibacteriota bacterium]	diamond	231	52	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
30774054	30774054	PRJNA556992_P_NODE_951254_length_235_cov_4.870370_g949064_i0	PRJNA556992	951254	235	4.87037	11.4453695	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	48.5	2.96e-4	NR	HPN55199.1	2045217	g949064	i0	41	1.05957446808511	83	39	95.7	3	9	233	325	405	HPN55199.1 beta-propeller fold lactonase family protein [Candidatus Moraniibacteriota bacterium]	diamond	249	48.5	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium
32196436	32196436	PRJNA556992_P_NODE_1035418_length_227_cov_2.324675_g1033228_i0	PRJNA556992	1035418	227	2.324675	5.27701225	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	42.4	0.0422	NR	MCK5080599.1	2045217	g1033228	i0	47.1	0.449339207048458	34	18	44.9	0	7	108	713	746	MCK5080599.1 excinuclease ABC subunit UvrA [Candidatus Moraniibacteriota bacterium]	diamond	102	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota	Candidatus Moraniibacteriota bacterium

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