metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA734348" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA734348" 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_class	tax_order	tax_family	tax_genus	tax_species
10125389	10125389	PRJNA734348_P_NODE_108048_length_247_cov_0.885057_g107350_i0	PRJNA734348	108048	247	0.885057	2.18609079	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	105	1.07e-27	NR	MBI2996445.1	2052166	g107350	i0	65.7	1.65182186234818	67	23	81.4	0	209	9	5	71	MBI2996445.1 4Fe-4S dicluster domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	408	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26609040	26609040	PRJNA734348_P_NODE_50081_length_290_cov_1.221198_g49384_i0	PRJNA734348	50081	290	1.221198	3.5414742	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	202	9.61e-63	NR	MBK8219417.1	2711154	g49384	i0	99	0.993103448275862	96	1	99.3	0	289	2	224	319	MBK8219417.1 diguanylate cyclase [Candidatus Obscuribacter sp.]	diamond	288	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27052520	27052520	PRJNA734348_P_NODE_118722_length_244_cov_1.707602_g118024_i0	PRJNA734348	118722	244	1.707602	4.16654888	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	61.6	7.5e-10	NR	MBI3591729.1	2052166	g118024	i0	58.5	0.799180327868853	65	18	73.8	2	242	63	66	126	MBI3591729.1 ribonuclease P protein component [Candidatus Melainabacteria bacterium]	diamond	195	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27115436	27115436	PRJNA734348_P_NODE_142762_length_228_cov_3.012903_g142064_i0	PRJNA734348	142762	228	3.012903	6.86941884	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	144	3.1299999999999996e-42	NR	MBK8220190.1	2711154	g142064	i0	98.7	0.986842105263158	75	1	98.7	0	3	227	19	93	MBK8220190.1 50S ribosomal protein L9 [Candidatus Obscuribacter sp.]	diamond	225	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
28000254	28000254	PRJNA734348_P_NODE_85485_length_256_cov_1.355191_g84787_i0	PRJNA734348	85485	256	1.355191	3.46928896	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	92.8	9.36e-22	NR	HEY9858651.1	2364082	g84787	i0	89.1	0.64453125	55	6	64.5	0	165	1	1	55	HEY9858651.1 inositol monophosphatase family protein [Candidatus Obscuribacterales bacterium]	diamond	165	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28789178	28789178	PRJNA734348_P_NODE_109627_length_247_cov_0.885057_g108929_i0	PRJNA734348	109627	247	0.885057	2.18609079	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	77.8	6.42e-15	NR	MBX9666190.1	2364082	g108929	i0	49.4	0.983805668016194	81	36	93.5	2	5	235	187	266	MBX9666190.1 site-specific integrase [Candidatus Obscuribacterales bacterium]	diamond	243	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29967869	29967869	PRJNA734348_P_NODE_111931_length_246_cov_0.890173_g111233_i0	PRJNA734348	111931	246	0.890173	2.18982558	Bacillati	1783272	Bacteria	Bacteria	140	2.32e-37	NR	MCE3236415.1	2717857	g111233	i0	90.3	1.75609756097561	72	7	87.8	0	31	246	31	102	MCE3236415.1 conserved rane protein of unknown function [Vampirovibrio sp.]	diamond	432	141	0.99290780141844	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrio	Vampirovibrio sp.
30146915	30146915	PRJNA734348_P_NODE_112352_length_246_cov_0.890173_g111654_i0	PRJNA734348	112352	246	0.890173	2.18982558	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	62	8.13e-10	NR	MBX9668600.1	2364082	g111654	i0	43.9	1	82	45	100	1	246	1	19	99	MBX9668600.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	246	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30210192	30210192	PRJNA734348_P_NODE_82532_length_258_cov_2.335135_g81834_i0	PRJNA734348	82532	258	2.335135	6.0246483	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	87.8	1.16e-18	NR	MEB3285906.1	2692181	g81834	i0	69.8	2.05813953488372	63	17	70.9	1	256	74	218	280	MEB3285906.1 Cof-type HAD-IIB family hydrolase [Vampirovibrionales bacterium]	diamond	531	87.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
30557747	30557747	PRJNA734348_P_NODE_45293_length_299_cov_3.075221_g44596_i0	PRJNA734348	45293	299	3.075221	9.19491079	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	85.5	6.15e-17	NR	MBI2996071.1	2052166	g44596	i0	42.1	2.8695652173913	140	29	88.3	2	36	299	9	148	MBI2996071.1 UDP-N-acetylmuramate--L-alanine ligase [Candidatus Melainabacteria bacterium]	diamond	858	85.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
30789315	30789315	PRJNA734348_P_NODE_126354_length_242_cov_2.727811_g125656_i0	PRJNA734348	126354	242	2.727811	6.60130262	Bacteria	2	Bacteria	Bacteria	130	2.61e-33	NR	OGI19727.1	1801607	g125656	i0	78.8	1.98347107438017	80	17	99.2	0	241	2	17	96	OGI19727.1 MAG: electron transfer flavoprotein [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12]	diamond	480	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12
31126294	31126294	PRJNA734348_P_NODE_143375_length_227_cov_3.590909_g142677_i0	PRJNA734348	143375	227	3.590909	8.15136343	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	134	2e-36	NR	MCC6979353.1	2052166	g142677	i0	100	0.991189427312775	75	0	99.1	0	2	226	218	292	MCC6979353.1 DUF692 domain-containing protein [Candidatus Melainabacteria bacterium]	diamond	225	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria 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);;