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

17 rows where analysis = "blastn", bioproject = "PRJNA627467" 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
8252290	8252290	PRJNA627467_P_NODE_14167_length_173_cov_4.185484_g14098_i0	PRJNA627467	14167	173	4.185484	7.24088732	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	285	1.32e-72	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g14098	i0	97.59	172.005780346821	166	4	96	0	4	169	3333	3498	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29757	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8252304	8252304	PRJNA627467_P_NODE_15287_length_170_cov_1.636364_g15218_i0	PRJNA627467	15287	170	1.636364	2.7818188	Phormidium yuhuli	2974039	Bacteria	Bacteria	113	6.430000000000001e-21	NTclustered	gi\|2260356645\|gb\|CP098611.1\|	2940671	g15218	i0	79.63	0.952941176470588	162	29	94	3	4	163	2030845	2031004	Phormidium yuhuli AB48 chromosome, complete genome	blastn	162	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium yuhuli
8252417	8252417	PRJNA627467_P_NODE_6067_length_314_cov_5.498113_g5999_i0	PRJNA627467	6067	314	5.498113	17.26407482	Nostoc sp. TCL26-01	2576904	Bacteria	Bacteria	239	2.1e-58	NTclustered	gi\|1866654106\|gb\|CP040297.1\|	2576904	g5999	i0	81.481	19.4426751592357	324	31	94	11	10	304	6551304	6550981	Nostoc sp. TCL26-01 chromosome, complete genome	blastn	6105	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
10803266	10803266	PRJNA627467_P_NODE_10129_length_187_cov_2.500000_g10060_i0	PRJNA627467	10129	187	2.5	4.675	Fischerella sp. JS2	2597771	Bacteria	Bacteria	159	9.169999999999999e-35	NTclustered	gi\|2589057682\|gb\|CP135918.1\|	2597771	g10060	i0	82.873	0.967914438502674	181	27	96	4	3	181	6905937	6905759	Fischerella sp. JS2 chromosome, complete genome	blastn	181	159	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. JS2
10803365	10803365	PRJNA627467_P_NODE_18289_length_163_cov_1.456140_g18220_i0	PRJNA627467	18289	163	1.45614	2.3735082	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	193	7.669999999999999e-45	NTclustered	gi\|2083855112\|dbj\|AP025021.1\|	2853227	g18220	i0	89.032	2.79754601226994	155	17	95	0	6	160	73881	74035	Calothrix sp. PCC 7716 plasmid Cal7716_p3 DNA, complete genome	blastn	456	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
13353399	13353399	PRJNA627467_P_NODE_18871_length_162_cov_0.902655_g18802_i0	PRJNA627467	18871	162	0.902655	1.4623011	Moorena producens	1155739	Bacteria	Bacteria	104	3.67e-18	NTclustered	gi\|2412135964\|gb\|CP017708.2\|	1454205	g18802	i0	90.123	6.96296296296296	81	6	51	1	62	140	4305178	4305258	Moorena producens JHB chromosome, complete genome	blastn	1128	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
14628052	14628052	PRJNA627467_P_NODE_13752_length_175_cov_1.587302_g13683_i0	PRJNA627467	13752	175	1.587302	2.7777785	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	171	3.9e-38	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g13683	i0	84.795	38.2285714285714	171	24	97	2	2	171	2611797	2611966	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	6690	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
14628082	14628082	PRJNA627467_P_NODE_15992_length_168_cov_0.857143_g15923_i0	PRJNA627467	15992	168	0.857143	1.44000024	Dulcicalothrix desertica	32056	Bacteria	Bacteria	246	6.03e-61	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g15923	i0	93.413	198.047619047619	167	9	99	2	1	167	267	103	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	33272	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
17177027	17177027	PRJNA627467_P_NODE_11114_length_184_cov_1.481481_g11045_i0	PRJNA627467	11114	184	1.481481	2.72592504	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	311	2.34e-80	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g11045	i0	97.79	141.396739130435	181	3	98	1	2	181	463	283	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	26017	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
17177058	17177058	PRJNA627467_P_NODE_13254_length_176_cov_5.992126_g13185_i0	PRJNA627467	13254	176	5.992126	10.54614176	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	219	1.3799999999999999e-52	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g13185	i0	92.715	160.363636363636	151	11	86	0	4	154	3644	3794	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	28224	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
17177114	17177114	PRJNA627467_P_NODE_18574_length_162_cov_2.840708_g18505_i0	PRJNA627467	18574	162	2.840708	4.60194696	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	189	9.85e-44	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g18505	i0	88.05	41.2962962962963	159	19	98	0	1	159	5646526	5646368	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	6690	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
17177187	17177187	PRJNA627467_P_NODE_5774_length_316_cov_1.445693_g5706_i0	PRJNA627467	5774	316	1.445693	4.56838988	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	132	3.69e-26	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g5706	i0	90.816	0.310126582278481	98	9	31	0	3	100	618635	618732	Synechococcus sp. CB0101 chromosome, complete genome	blastn	98	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
19725846	19725846	PRJNA627467_P_NODE_56_length_1179_cov_24.612389_g14_i1	PRJNA627467	56	1179	24.612389	290.18006631	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	1387	0	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g14	i1	88.166	145.318914334181	1183	116	99	19	1	1176	4223	3058	Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence	blastn	171331	1387	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
19725886	19725886	PRJNA627467_P_NODE_996_length_366_cov_3.116719_g929_i0	PRJNA627467	996	366	3.116719	11.40719154	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	248	4.13e-61	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g929	i0	99.27	76.448087431694	137	1	73	0	3	139	1934751	1934887	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	27980	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
22276412	22276412	PRJNA627467_P_NODE_8218_length_211_cov_6.530864_g8149_i0	PRJNA627467	8218	211	6.530864	13.78012304	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	313	7.7e-81	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g8149	i0	93.78	183.284360189573	209	12	99	1	1	208	2110	1902	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38673	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23551651	23551651	PRJNA627467_P_NODE_11279_length_183_cov_2.723881_g11210_i0	PRJNA627467	11279	183	2.723881	4.98470223	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	296	6.52e-76	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g11210	i0	97.159	231.377049180328	176	4	96	1	3	178	1857612	1857786	Calothrix sp. PCC 7716 DNA, complete genome	blastn	42342	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
25377204	25377204	PRJNA627467_P_NODE_20_length_1935_cov_33.503181_g14_i0	PRJNA627467	20	1935	33.503181	648.28655235	Kalymmatonema	3452864	Bacteria	Bacteria	1916	0	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g14	i0	87.748	185.875968992248	1665	173	86	27	281	1935	2580	4223	Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence	blastn	359670	1930	0.992746113989637	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum

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