metadata: contig_metadata: 14 rows where bioproject = "PRJNA615351", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

14 rows where bioproject = "PRJNA615351", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_kingdom	tax_phylum	tax_order	tax_family	tax_genus	tax_species
17173272	17173272	PRJNA615351_P_NODE_100794_length_314_cov_3.935484_g86697_i0	PRJNA615351	100794	314	3.935484	12.35741976	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	239	2.1e-58	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g86697	i0	80.696	254.251592356688	316	53	99	6	1	313	1223058	1223368	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	79835	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
26668776	26668776	PRJNA615351_P_NODE_88201_length_375_cov_2.267647_g74124_i0	PRJNA615351	88201	375	2.267647	8.50367625	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	44.7	0.0323	NR	HNN62489.1	2711154	g74124	i0	46.2	0.624	39	21	31.2	0	264	148	72	110	HNN62489.1 VIT domain-containing protein [Candidatus Obscuribacter sp.]	diamond	234	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
26777019	26777019	PRJNA615351_P_NODE_22521_length_1366_cov_6.927874_g16375_i0	PRJNA615351	22521	1366	6.927874	94.63475884	Bacillati	1783272	Bacteria	Bacteria	193	8.03e-54	NR	MCC6976906.1	2052166	g16375	i0	36.5	2.22254758418741	342	201	74	7	77	1087	1	331	MCC6976906.1 zinc-binding dehydrogenase [Candidatus Melainabacteria bacterium]	diamond	3036	194	0.994845360824742	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
28324970	28324970	PRJNA615351_P_NODE_24806_length_1286_cov_7.101519_g16375_i1	PRJNA615351	24806	1286	7.101519	91.32553434	Bacillati	1783272	Bacteria	Bacteria	195	1.04e-54	NR	MCC6976906.1	2052166	g16375	i1	36.8	2.36080870917574	342	200	78.6	7	1210	200	1	331	MCC6976906.1 zinc-binding dehydrogenase [Candidatus Melainabacteria bacterium]	diamond	3036	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
28343774	28343774	PRJNA615351_P_NODE_67366_length_524_cov_2.744376_g53595_i0	PRJNA615351	67366	524	2.744376	14.38053024	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	72.4	9.79e-12	NR	HEY9814218.1	2364082	g53595	i0	35.7	0.738549618320611	129	72	71	4	513	142	89	211	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	387	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28564725	28564725	PRJNA615351_P_NODE_145247_length_197_cov_1.913580_g131147_i0	PRJNA615351	145247	197	1.91358	3.7697526	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	42.4	0.0282	NR	MBX9950540.1	2364082	g131147	i0	37.5	0.730964467005076	48	30	73.1	0	173	30	150	197	MBX9950540.1 protein kinase [Candidatus Obscuribacterales bacterium]	diamond	144	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29209256	29209256	PRJNA615351_P_NODE_122389_length_244_cov_1.564593_g108289_i0	PRJNA615351	122389	244	1.564593	3.81760692	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	63.2	2.37e-9	NR	OGI18165.1	1801611	g108289	i0	41.5	6.34426229508197	65	34	79.9	1	21	215	837	897	OGI18165.1 MAG: hypothetical protein A2255_10360 [Candidatus Melainabacteria bacterium RIFOXYA2_FULL_32_9]	diamond	1548	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium RIFOXYA2_FULL_32_9
29240722	29240722	PRJNA615351_P_NODE_120749_length_248_cov_2.126761_g106649_i0	PRJNA615351	120749	248	2.126761	5.27436728	Bacillati	1783272	Bacteria	Bacteria	43.5	0.0211	NR	HEY9888855.1	2364082	g106649	i0	42.4	2.66129032258065	59	26	66.5	3	4	168	474	528	HEY9888855.1 alpha-amylase family glycosyl hydrolase [Candidatus Obscuribacterales bacterium]	diamond	660	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30302079	30302079	PRJNA615351_P_NODE_36892_length_964_cov_3.644779_g27287_i0	PRJNA615351	36892	964	3.644779	35.13566956	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	90.9	3.29e-17	NR	HEY9814218.1	2364082	g27287	i0	35.4	0.563278008298755	181	99	54.1	8	953	432	89	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	543	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30314974	30314974	PRJNA615351_P_NODE_117172_length_258_cov_1.730942_g103073_i0	PRJNA615351	117172	258	1.730942	4.46583036	Bacillati	1783272	Bacteria	Bacteria	50.1	1.19e-4	NR	MFN5538738.1	2052166	g103073	i0	49.2	1.47674418604651	59	27	65.1	1	35	202	677	735	MFN5538738.1 Ig-like domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	381	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
30775587	30775587	PRJNA615351_P_NODE_125054_length_237_cov_2.138614_g110954_i0	PRJNA615351	125054	237	2.138614	5.06851518	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	45.1	0.00543	NR	MCB9470039.1	2364082	g110954	i0	39.1	0.810126582278481	64	36	77.2	1	237	55	469	532	MCB9470039.1 serine/threonine protein kinase [Candidatus Obscuribacterales bacterium]	diamond	192	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31881941	31881941	PRJNA615351_P_NODE_157397_length_180_cov_1.379310_g143297_i0	PRJNA615351	157397	180	1.37931	2.482758	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	44.7	0.0024	NR	PKL77184.1	2013813	g143297	i0	36.8	0.95	57	36	95	0	178	8	59	115	PKL77184.1 MAG: hypothetical protein CVV27_06455 [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	171	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
32325399	32325399	PRJNA615351_P_NODE_186399_length_151_cov_1.034483_g172299_i0	PRJNA615351	186399	151	1.034483	1.56206933	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	43.5	0.00579	NR	MDX2084911.1	2052166	g172299	i0	52.5	0.794701986754967	40	16	73.5	1	34	144	464	503	MDX2084911.1 adenylate/guanylate cyclase domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	120	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
32464668	32464668	PRJNA615351_P_NODE_105439_length_296_cov_2.421456_g91340_i0	PRJNA615351	105439	296	2.421456	7.16750976	Bacteria	2	Bacteria	Bacteria	64.3	1.77e-9	NR	MCD7879315.1	2137880	g91340	i0	46.2	2.58445945945946	65	34	64.9	1	105	296	432	496	MCD7879315.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	765	64.7	0.993817619783617	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales			Candidatus Gastranaerophilales 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);;