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

12 rows where bioproject = "PRJNA849822", 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_species
2113965	2113965	PRJNA849822_P_NODE_17542_length_346_cov_1.648352_g17368_i0	PRJNA849822	17542	346	1.648352	5.70329792	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	470	7.63e-128	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17368	i0	91.329	135.725433526012	346	26	99	4	1	344	3681200	3681543	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	46961	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
8491522	8491522	PRJNA849822_P_NODE_34847_length_251_cov_2.623596_g34673_i0	PRJNA849822	34847	251	2.623596	6.58522596	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	226	1.2699999999999999e-54	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g34673	i0	83.071	63.7848605577689	254	38	99	5	1	250	3682129	3682381	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	16010	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
16536092	16536092	PRJNA849822_P_NODE_16593_length_356_cov_1.653710_g16419_i0	PRJNA849822	16593	356	1.65371	5.8872076	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	227	5.679999999999999e-74	NR	MBX9724270.1	2364082	g16419	i0	94.9	0.99438202247191	118	6	99.4	0	3	356	32	149	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	354	227	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
18689894	18689894	PRJNA849822_P_NODE_21395_length_313_cov_2.020833_g21221_i0	PRJNA849822	21395	313	2.020833	6.32520729	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	342	1.5499999999999996e-89	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g21221	i0	86.859	28.3961661341853	312	33	99	6	1	309	3680944	3681250	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	8888	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
27528894	27528894	PRJNA849822_P_NODE_43523_length_241_cov_2.386905_g43349_i0	PRJNA849822	43523	241	2.386905	5.75244105	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	47	9.41e-4	NR	HEY9784183.1	2364082	g43349	i0	39.5	2.80082987551867	76	44	93.4	2	240	16	51	125	HEY9784183.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	675	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
28349812	28349812	PRJNA849822_P_NODE_42466_length_243_cov_0.917647_g42292_i0	PRJNA849822	42466	243	0.917647	2.22988221	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	162	4.45e-44	NR	MBX9673982.1	2364082	g42292	i0	98.8	0.987654320987654	80	1	98.8	0	242	3	126	205	MBX9673982.1 DNA-directed RNA polymerase subunit beta [Candidatus Obscuribacterales bacterium]	diamond	240	162	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
28854810	28854810	PRJNA849822_P_NODE_11068_length_446_cov_1.667560_g10895_i0	PRJNA849822	11068	446	1.66756	7.4373176	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.1	1.58e-7	NR	HEY9814218.1	2364082	g10895	i0	32.1	0.901345291479821	134	87	87.4	2	9	398	90	223	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	402	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
29297083	29297083	PRJNA849822_P_NODE_41389_length_244_cov_0.912281_g41215_i0	PRJNA849822	41389	244	0.912281	2.22596564	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	85.1	4.22e-17	NR	MCA0314639.1	2052166	g41215	i0	100	0.504098360655738	41	0	50.4	0	123	1	1	41	MCA0314639.1 Fe-S cluster assembly protein SufB [Candidatus Melainabacteria bacterium]	diamond	123	85.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
29991790	29991790	PRJNA849822_P_NODE_18911_length_333_cov_1.065385_g18737_i0	PRJNA849822	18911	333	1.065385	3.54773205	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	62.4	7.53e-9	NR	HEY9814218.1	2364082	g18737	i0	35.7	0.756756756756757	84	51	73	2	249	7	14	97	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	252	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
30600215	30600215	PRJNA849822_P_NODE_27253_length_279_cov_1.543689_g27079_i0	PRJNA849822	27253	279	1.543689	4.30689231	Bacteria	2	Bacteria	Bacteria	107	2.28e-27	NR	PKL76191.1	2013813	g27079	i0	77.8	5.50537634408602	63	14	67.7	0	189	1	4	66	PKL76191.1 MAG: nucleoside-diphosphate kinase [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	1536	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
30908186	30908186	PRJNA849822_P_NODE_6094_length_630_cov_3.052065_g5925_i0	PRJNA849822	6094	630	3.052065	19.2280095	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	263	1.79e-84	NR	MFA6211476.1	2364082	g5925	i0	61.1	2.97619047619048	208	79	98.1	2	11	628	2	209	MFA6211476.1 alcohol dehydrogenase [Candidatus Obscuribacterales bacterium]	diamond	1875	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
31034724	31034724	PRJNA849822_P_NODE_40235_length_245_cov_0.906977_g40061_i0	PRJNA849822	40235	245	0.906977	2.22209365	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	171	4.9699999999999994e-48	NR	MBN9396776.1	2052166	g40061	i0	100	0.991836734693878	81	0	99.2	0	244	2	135	215	MBN9396776.1 DNA mismatch repair endonuclease MutL [Candidatus Melainabacteria bacterium]	diamond	243	171	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);;