metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where analysis = "blastn", bioproject = "PRJNA437204" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
1706662	1706662	PRJNA437204_P_NODE_115402_length_243_cov_1.811765_g115103_i0	PRJNA437204	115402	243	1.811765	4.40258895	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	278	3.3200000000000004e-70	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g115103	i0	87.552	51.3991769547325	241	29	99	1	3	243	3679728	3679967	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	12490	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
2983578	2983578	PRJNA437204_P_NODE_57563_length_285_cov_1.452830_g57264_i0	PRJNA437204	57563	285	1.45283	4.1405655	Umezakia ovalisporum	75695	Bacteria	Bacteria	350	8.34e-92	NTclustered	gi\|333109175\|gb\|JF768745.1\|	1029747	g57264	i0	88.85	112.663157894737	287	28	100	4	1	285	3606	3322	Aphanizomenon ovalisporum ILC-164 rDNA type 2 operon, complete sequence	blastn	32109	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
2983581	2983581	PRJNA437204_P_NODE_5763_length_668_cov_1.633613_g5473_i0	PRJNA437204	5763	668	1.633613	10.91253484	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	604	4.0699999999999984e-168	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g5473	i0	83.284	152.845808383234	676	94	100	18	1	668	3761	3097	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	102101	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
2983934	2983934	PRJNA437204_P_NODE_75163_length_257_cov_1.625000_g74864_i0	PRJNA437204	75163	257	1.625	4.17625	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	270	5.93e-68	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g74864	i0	85.769	349.859922178988	260	32	100	5	1	257	598546	598803	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	89914	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
9360026	9360026	PRJNA437204_P_NODE_125388_length_241_cov_0.916667_g125089_i0	PRJNA437204	125388	241	0.916667	2.20916747	Nostoc sp. CENA543	1869241	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1334417636\|gb\|CP023278.1\|	1869241	g125089	i0	100	0.116182572614108	28	0	12	0	184	211	1944295	1944322	Nostoc sp. CENA543 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CENA543
9360153	9360153	PRJNA437204_P_NODE_14348_length_467_cov_1.362944_g14049_i0	PRJNA437204	14348	467	1.362944	6.36494848	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	773	0	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g14049	i0	96.567	115.674518201285	466	16	99	0	2	467	2632	2167	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54020	773	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20834232	20834232	PRJNA437204_P_NODE_39977_length_324_cov_1.840637_g39678_i0	PRJNA437204	39977	324	1.840637	5.96366388	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	433	9.299999999999999e-117	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g39678	i0	92.182	27.4351851851852	307	22	94	2	12	317	511295	510990	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	8889	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
22108999	22108999	PRJNA437204_P_NODE_3138_length_844_cov_1.906615_g2886_i0	PRJNA437204	3138	844	1.906615	16.0918306	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	1009	0	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g2886	i0	88.457	198.537914691943	849	80	99	17	1	841	1222677	1223515	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	167566	1009	1	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);;