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

18 rows where analysis = "blastn", bioproject = "PRJNA1158727" 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
1578891	1578891	PRJNA1158727_P_NODE_156082_length_243_cov_1.735294_g148620_i0	PRJNA1158727	156082	243	1.735294	4.21676442	Prochlorococcus marinus	1219	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|95115443\|gb\|DQ473696.1\|	167555	g148620	i0	100	29.3497942386831	243	0	100	0	1	243	349	591	Prochlorococcus marinus str. NATL1A photosystem D2 protein (psbD) gene, partial cds	blastn	7132	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
1579012	1579012	PRJNA1158727_P_NODE_162662_length_241_cov_0.916667_g155200_i0	PRJNA1158727	162662	241	0.916667	2.20916747	Nostoc commune	1178	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g155200	i0	90	154.572614107884	240	22	99	2	1	239	1738015	1737777	Nostoc cf. commune SO-36 DNA, complete genome	blastn	37252	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
2312748	2312748	PRJNA1158727_P_NODE_125922_length_260_cov_3.251337_g118461_i0	PRJNA1158727	125922	260	3.251337	8.4534762	Macrochaete	1844958	Bacteria	Bacteria	470	5.519999999999998e-128	NTclustered	gi\|336109608\|gb\|JN020217.1\|	1211	g118461	i0	99.231	99.6576923076923	260	2	100	0	1	260	555	814	Uncultured cyanobacterium clone cher4_2B_90 small subunit ribosomal RNA gene, partial sequence	blastn	25911	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2855033	2855033	PRJNA1158727_P_NODE_148223_length_246_cov_1.335260_g140761_i0	PRJNA1158727	148223	246	1.33526	3.2847396	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g140761	i0	98.374	157.256097560976	246	4	100	0	1	246	1244204	1243959	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	38685	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
3587949	3587949	PRJNA1158727_P_NODE_131923_length_254_cov_1.453039_g124462_i0	PRJNA1158727	131923	254	1.453039	3.69071906	Microcoleus	44471	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g124462	i0	100	190.476377952756	254	0	100	0	1	254	100959	100706	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	48381	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
4130576	4130576	PRJNA1158727_P_NODE_126424_length_260_cov_1.486631_g118963_i0	PRJNA1158727	126424	260	1.486631	3.8652406	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	422	1.57e-113	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g118963	i0	97.189	151	249	7	96	0	1	249	2055878	2055630	Leptolyngbya sp. 7M chromosome	blastn	39260	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
4130912	4130912	PRJNA1158727_P_NODE_143644_length_248_cov_0.880000_g136182_i0	PRJNA1158727	143644	248	0.88	2.1824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	326	1.2e-84	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g136182	i0	90.323	166.907258064516	248	24	100	0	1	248	3680371	3680618	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	41393	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6681858	6681858	PRJNA1158727_P_NODE_141766_length_249_cov_0.875000_g134304_i0	PRJNA1158727	141766	249	0.875	2.17875	Pseudanabaena sp. ABRG5-3	685565	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1320987122\|dbj\|AP017561.1\|	685565	g134304	i0	94.595	0.602409638554217	37	1	15	1	134	170	189576	189611	Pseudanabaena sp. ABRG5-3 plasmid ABRG53a DNA, complete sequence	blastn	150	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. ABRG5-3
7415352	7415352	PRJNA1158727_P_NODE_131586_length_254_cov_1.701657_g124125_i0	PRJNA1158727	131586	254	1.701657	4.32220878	Oscillatoriales	1150	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g124125	i0	100	116.669291338583	254	0	100	0	1	254	2435	2182	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29634	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9232474	9232474	PRJNA1158727_P_NODE_167548_length_226_cov_2.013072_g160086_i0	PRJNA1158727	167548	226	2.013072	4.54954272	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	207	4.06e-49	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g160086	i0	83.186	4.90265486725664	226	38	100	0	1	226	5028571	5028346	Calothrix sp. PCC 6303, complete genome	blastn	1108	207	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
10510651	10510651	PRJNA1158727_P_NODE_97209_length_298_cov_1.711111_g89748_i0	PRJNA1158727	97209	298	1.711111	5.09911078	Stanieria cyanosphaera	102116	Bacteria	Bacteria	278	4.2e-70	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g89748	i0	84.138	21.1510067114094	290	43	96	2	12	298	584	295	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	6303	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
11241033	11241033	PRJNA1158727_P_NODE_79289_length_341_cov_4.197761_g71828_i0	PRJNA1158727	79289	341	4.197761	14.31436501	root	1	Root_unresolved	Root_unresolved	623	5.4499999999999985e-174	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g71828	i0	99.707	99.0821114369501	341	0	100	1	1	341	429	90	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	33787	623	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13057271	13057271	PRJNA1158727_P_NODE_124551_length_262_cov_1.608466_g117090_i0	PRJNA1158727	124551	262	1.608466	4.21418092	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	422	1.58e-113	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g117090	i0	95.802	113.24427480916	262	10	100	1	1	262	3350	3090	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29670	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
16882519	16882519	PRJNA1158727_P_NODE_44154_length_562_cov_2.533742_g36725_i0	PRJNA1158727	44154	562	2.533742	14.23963004	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	861	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g36725	i0	95.082	109.046263345196	549	24	98	3	15	562	2772	2226	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	61284	861	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19429647	19429647	PRJNA1158727_P_NODE_123156_length_264_cov_1.089005_g115695_i0	PRJNA1158727	123156	264	1.089005	2.8749732	Egbenema sp. FJBBOT/2019	3398834	Bacteria	Bacteria	340	4.5999999999999996e-89	NTclustered	gi\|2917372002\|gb\|CP182236.1\|	3398834	g115695	i0	90.076	150.863636363636	262	26	99	0	3	264	261242	261503	Egbenema sp. FJBBOT/2019 chromosome, complete genome	blastn	39828	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Egbenema	Egbenema sp. FJBBOT/2019
19429805	19429805	PRJNA1158727_P_NODE_131056_length_255_cov_1.285714_g123595_i0	PRJNA1158727	131056	255	1.285714	3.2785707	Microcoleus vaginatus	119532	Bacteria	Bacteria	198	2.81e-46	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g123595	i0	82.883	48.6941176470588	222	36	99	2	1	220	1374470	1374691	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	12417	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
23255979	23255979	PRJNA1158727_P_NODE_130759_length_255_cov_1.692308_g123298_i0	PRJNA1158727	130759	255	1.692308	4.3153854	Nostoc sphaeroides	446679	Bacteria	Bacteria	326	1.2399999999999999e-84	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g123298	i0	89.764	11.7294117647059	254	26	99	0	1	254	1101198	1101451	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	2991	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
24531656	24531656	PRJNA1158727_P_NODE_50480_length_496_cov_1.657210_g43025_i0	PRJNA1158727	50480	496	1.65721	8.2197616	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	496	1.86e-135	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g43025	i0	85.507	80.5181451612903	483	61	96	9	19	496	3681097	3681575	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	39937	496	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);;