metadata: contig_metadata: 14 rows where bioproject = "PRJNA986547" and tax_clade = "Cyanobacteriota/Melainabacteria group"

14 rows where bioproject = "PRJNA986547" 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
2249495	2249495	PRJNA986547_P_NODE_6662_length_264_cov_1.287958_g6580_i0	PRJNA986547	6662	264	1.287958	3.40020912	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	472	1.5599999999999998e-128	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g6580	i0	98.864	274.19696969697	264	3	100	0	1	264	2847	2584	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	72388	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
3524801	3524801	PRJNA986547_P_NODE_7123_length_260_cov_3.491979_g7041_i0	PRJNA986547	7123	260	3.491979	9.0791454	Bacteria	2	Bacteria	Bacteria	121	6.84e-30	NR	WP_193869696.1	54306	g7041	i0	66.7	9.20769230769231	81	27	93.5	0	1	243	119	199	WP_193869696.1 putative bifunctional diguanylate cyclase/phosphodiesterase [Planktothrix mougeotii]	diamond	2394	122	0.991803278688525	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
6376401	6376401	PRJNA986547_P_NODE_9325_length_249_cov_0.875000_g9243_i0	PRJNA986547	9325	249	0.875	2.17875	Oscillatoriales	1150	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g9243	i0	99.598	157.859437751004	249	1	100	0	1	249	102580	102828	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	39307	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7650334	7650334	PRJNA986547_P_NODE_7026_length_261_cov_2.095745_g6944_i0	PRJNA986547	7026	261	2.095745	5.46989445	Microcoleus	44471	Bacteria	Bacteria	381	2.669999999999999e-101	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g6944	i0	93.077	4.8007662835249	260	18	99	0	1	260	3502830	3503089	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1253	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
9902271	9902271	PRJNA986547_P_NODE_12548_length_238_cov_3.878788_g12466_i0	PRJNA986547	12548	238	3.878788	9.23151544	Planktothrix sp. GU0601_MAG3	3078749	Bacteria	Bacteria	62.1	3.55e-5	NTclustered	gi\|2643647507\|gb\|CP136572.1\|	3078749	g12466	i0	94.872	6.76470588235294	39	2	33	0	171	209	1229429	1229391	MAG: Planktothrix sp. GU0601_MAG3 chromosome, complete genome	blastn	1610	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp. GU0601_MAG3
11177511	11177511	PRJNA986547_P_NODE_15549_length_213_cov_5.450000_g15467_i0	PRJNA986547	15549	213	5.45	11.6085	Synechococcus sp. MVIR-18-1	1386941	Bacteria	Bacteria	62.1	3.11e-5	NTclustered	gi\|1895773479\|gb\|CP047942.1\|	1386941	g15467	i0	97.297	0.380281690140845	37	0	17	1	177	212	638678	638714	Synechococcus sp. MVIR-18-1 chromosome, complete genome	blastn	81	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. MVIR-18-1
16276971	16276971	PRJNA986547_P_NODE_12673_length_237_cov_4.298780_g12591_i0	PRJNA986547	12673	237	4.29878	10.1881086	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	248	2.53e-61	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g12591	i0	85.654	47.7932489451477	237	33	100	1	1	237	3679731	3679966	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	11327	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16574818	16574818	PRJNA986547_P_NODE_2393_length_315_cov_6.024793_g2311_i0	PRJNA986547	2393	315	6.024793	18.97809795	Chroococcidiopsis	54298	Bacteria	Bacteria	518	2.42e-142	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g2311	i0	96.486	136.961904761905	313	11	99	0	1	313	795050	794738	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	43143	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
20100768	20100768	PRJNA986547_P_NODE_8396_length_251_cov_4.988764_g8314_i0	PRJNA986547	8396	251	4.988764	12.52179764	Nostoc sp. MS1	2764711	Bacteria	Bacteria	154	6.06e-33	NTclustered	gi\|2093825993\|dbj\|AP023441.1\|	2764711	g8314	i0	87.407	13.003984063745	135	16	54	1	117	251	3888437	3888570	Nostoc sp. MS1 DNA, complete genome	blastn	3264	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. MS1
27089772	27089772	PRJNA986547_P_NODE_9462_length_248_cov_2.142857_g9380_i0	PRJNA986547	9462	248	2.142857	5.31428536	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	143	4.36e-39	NR	MEE3350530.1	3022870	g9380	i0	74.4	7.93548387096774	82	21	99.2	0	3	248	52	133	MEE3350530.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium]	diamond	1968	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
28005827	28005827	PRJNA986547_P_NODE_16785_length_202_cov_4.682171_g16703_i0	PRJNA986547	16785	202	4.682171	9.45798542	Aliterella atlantica	1827278	Bacteria	Bacteria	83.6	2.9e-17	NR	WP_045054240.1	1827278	g16703	i0	72.1	1.00990099009901	68	16	99.5	2	201	1	206	271	WP_045054240.1 DNA repair protein RecO [Aliterella atlantica]	diamond	204	83.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
29836835	29836835	PRJNA986547_P_NODE_7731_length_256_cov_2.797814_g7649_i0	PRJNA986547	7731	256	2.797814	7.16240384	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	96.3	9.41e-23	NR	MBL8086383.1	2711154	g7649	i0	72.6	0.85546875	73	16	80.9	2	49	255	56	128	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	219	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32460985	32460985	PRJNA986547_P_NODE_2739_length_310_cov_4.645570_g2657_i0	PRJNA986547	2739	310	4.64557	14.401267	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	101	2.0399999999999994e-24	NR	HEY9780001.1	3088178	g2657	i0	100	0.483870967741935	50	0	48.4	0	1	150	102	151	HEY9780001.1 LptA/OstA family protein [Leptolyngbyaceae cyanobacterium]	diamond	150	101	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
32556089	32556089	PRJNA986547_P_NODE_13259_length_233_cov_4.425000_g13177_i0	PRJNA986547	13259	233	4.425	10.31025	Cyanobacteria bacterium UBA11367	2055774	Bacteria	Bacteria	80.5	5.07e-16	NR	HBE16399.1	2055774	g13177	i0	51.5	2.78111587982833	66	32	85	0	6	203	7	72	HBE16399.1 DNA methyltransferase [Cyanobacteria bacterium UBA11367]	diamond	648	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11367

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