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

30 rows where analysis = "blastn", bioproject = "PRJNA1249535" 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
1052459	1052459	PRJNA1249535_S_NODE_20241_length_656_cov_3.898799_g17175_i0	PRJNA1249535	20241	656	3.898799	25.57612144	Cyanophyceae	3028117	Bacteria	Bacteria	62.1	1.08e-4	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g17175	i0	95	11.3810975609756	40	1	9	1	559	598	6881017	6880979	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	7466	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
1632213	1632213	PRJNA1249535_S_NODE_285182_length_261_cov_1.659574_g281799_i0	PRJNA1249535	285182	261	1.659574	4.33148814	Nostoc commune	1178	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2237836886\|dbj\|AP025735.1\|	449208	g281799	i0	90.698	0.164750957854406	43	1	16	3	71	111	11845	11804	Nostoc cf. commune SO-36 plasmid pANSO36C DNA, complete sequence	blastn	43	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
1633933	1633933	PRJNA1249535_S_NODE_89542_length_387_cov_4.958599_g86160_i0	PRJNA1249535	89542	387	4.958599	19.18977813	Moorena producens	1155739	Bacteria	Bacteria	73.1	2.84e-8	NTclustered	gi\|1082408432\|gb\|CP017599.1\|	1458985	g86160	i0	93.878	0.250645994832041	49	2	13	1	326	374	5917854	5917807	Moorena producens PAL-8-15-08-1 chromosome, complete genome	blastn	97	73.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
2327796	2327796	PRJNA1249535_S_NODE_235582_length_287_cov_4.906542_g232199_i0	PRJNA1249535	235582	287	4.906542	14.08177554	Cyanophyceae	3028117	Bacteria	Bacteria	388	1.78e-103	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g232199	i0	91.756	255.526132404181	279	23	97	0	9	287	520	242	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	73336	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
4182178	4182178	PRJNA1249535_S_NODE_104944_length_370_cov_2.286195_g101561_i0	PRJNA1249535	104944	370	2.286195	8.4589215	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g101561	i0	100	0.0756756756756757	28	0	8	0	238	265	4769320	4769347	Nostoc sp. PCC 7524, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
5459285	5459285	PRJNA1249535_S_NODE_160945_length_328_cov_4.211765_g157562_i0	PRJNA1249535	160945	328	4.211765	13.8145892	Rippkaea orientalis	2546366	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|218165370\|gb\|CP001287.1\|	41431	g157562	i0	100	0.0853658536585366	28	0	9	0	156	183	4120308	4120335	Cyanothece sp. PCC 8801, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Rippkaea	Rippkaea orientalis
8008448	8008448	PRJNA1249535_S_NODE_104987_length_370_cov_2.006734_g101604_i0	PRJNA1249535	104987	370	2.006734	7.4249158	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g101604	i0	100	0.191891891891892	29	0	8	0	50	78	3686236	3686208	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	71	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
11837570	11837570	PRJNA1249535_S_NODE_77310_length_406_cov_2.198198_g73929_i0	PRJNA1249535	77310	406	2.198198	8.92468388	Crocosphaera subtropica	2546360	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|171696371\|gb\|CP000806.1\|	43989	g73929	i0	100	0.0714285714285714	29	0	7	0	374	402	2445620	2445648	Cyanothece sp. ATCC 51142 circular chromosome, complete sequence	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera subtropica
13111526	13111526	PRJNA1249535_S_NODE_303031_length_251_cov_2.191011_g299648_i0	PRJNA1249535	303031	251	2.191011	5.49943761	Synechococcus sp. PROS-9-1	1968775	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1895826200\|gb\|CP047961.1\|	1968775	g299648	i0	92.105	0.151394422310757	38	2	15	1	68	104	1349031	1348994	Synechococcus sp. PROS-9-1 chromosome, complete genome	blastn	38	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PROS-9-1
13805849	13805849	PRJNA1249535_S_NODE_139291_length_342_cov_3.832714_g135908_i0	PRJNA1249535	139291	342	3.832714	13.10788188	Nostoc	1177	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g135908	i0	100	0.16374269005848	28	0	8	0	314	341	3189584	3189557	Nostoc sp. NIES-3756 DNA, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
14384835	14384835	PRJNA1249535_S_NODE_153672_length_333_cov_2.130769_g150289_i0	PRJNA1249535	153672	333	2.130769	7.09546077	Cyanobacterium stanieri	102235	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|428686127\|gb\|CP003940.1\|	292563	g150289	i0	100	0.0840840840840841	28	0	8	0	113	140	1369336	1369309	Cyanobacterium stanieri PCC 7202, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium stanieri
14385748	14385748	PRJNA1249535_S_NODE_221472_length_295_cov_2.108108_g218089_i0	PRJNA1249535	221472	295	2.108108	6.2189186	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	396	1.0999999999999994e-105	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g218089	i0	90.909	191.959322033898	297	23	100	4	1	295	1764	1470	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	56628	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
14386444	14386444	PRJNA1249535_S_NODE_277112_length_265_cov_3.250000_g273729_i0	PRJNA1249535	277112	265	3.25	8.6125	Prochlorococcus sp. MIT 1223	3096217	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2625929803\|gb\|CP139303.1\|	3096217	g273729	i0	100	0.105660377358491	28	0	11	0	70	97	182985	183012	Prochlorococcus sp. MIT 1223 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1223
16354878	16354878	PRJNA1249535_S_NODE_313193_length_246_cov_1.364162_g309810_i0	PRJNA1249535	313193	246	1.364162	3.35583852	Nostocaceae	1162	Bacteria	Bacteria	388	1.49e-103	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g309810	i0	95.833	259.451219512195	240	10	98	0	1	240	1791348	1791109	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	63825	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
16934256	16934256	PRJNA1249535_S_NODE_252134_length_279_cov_1.495146_g248751_i0	PRJNA1249535	252134	279	1.495146	4.17145734	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	370	6.25e-98	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g248751	i0	91.45	239.652329749104	269	23	96	0	2	270	4790218	4789950	Gloeocapsa sp. PCC 7428, complete genome	blastn	66863	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
17630204	17630204	PRJNA1249535_S_NODE_41534_length_512_cov_5.011390_g38218_i0	PRJNA1249535	41534	512	5.01139	25.6583168	Chroococcaceae	1890464	Bacteria	Bacteria	896	0	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g38218	i0	98.246	105.712890625	513	8	100	1	1	512	852	1364	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	54125	896	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
18206752	18206752	PRJNA1249535_S_NODE_102555_length_372_cov_3.822742_g99172_i0	PRJNA1249535	102555	372	3.822742	14.22060024	Microcystis aeruginosa	1126	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|1787232413\|gb\|CP046973.1\|	2686288	g99172	i0	100	0.0752688172043011	28	0	8	0	52	79	190119	190092	Microcystis aeruginosa FD4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
18903985	18903985	PRJNA1249535_S_NODE_282135_length_262_cov_4.920635_g278752_i0	PRJNA1249535	282135	262	4.920635	12.8920637	Chlorogloeopsis	1123	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g278752	i0	100	0.213740458015267	28	0	11	0	134	161	1639929	1639902	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
19481438	19481438	PRJNA1249535_S_NODE_127096_length_351_cov_2.683453_g123713_i0	PRJNA1249535	127096	351	2.683453	9.41892003	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	313	1.38e-80	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g123713	i0	84.663	168.840455840456	326	37	91	12	4	323	597642	597324	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	59263	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
19482083	19482083	PRJNA1249535_S_NODE_173236_length_321_cov_2.842742_g169853_i0	PRJNA1249535	173236	321	2.842742	9.12520182	Gloeothece verrucosa	2546359	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g169853	i0	100	0.174454828660436	28	0	17	0	264	291	1255622	1255595	Cyanothece sp. PCC 7822, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
19483482	19483482	PRJNA1249535_S_NODE_283576_length_262_cov_1.238095_g280193_i0	PRJNA1249535	283576	262	1.238095	3.2438089	uncultured cyanobacterium	1211	Bacteria	Bacteria	455	1.56e-123	NTclustered	gi\|326580375\|gb\|JF268862.1\|	1211	g280193	i0	99.206	96.3587786259542	252	2	96	0	11	262	601	350	Uncultured cyanobacterium clone ABLBb26 16S ribosomal RNA gene, partial sequence	blastn	25246	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19483895	19483895	PRJNA1249535_S_NODE_320956_length_242_cov_1.384615_g317573_i0	PRJNA1249535	320956	242	1.384615	3.3507683	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	396	8.739999999999996e-106	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g317573	i0	96.296	120.429752066116	243	6	100	3	1	242	133281	133041	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	29144	396	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
19484760	19484760	PRJNA1249535_S_NODE_67376_length_426_cov_3.308782_g63997_i0	PRJNA1249535	67376	426	3.308782	14.09541132	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|1210228030\|dbj\|AP018283.1\|	2005460	g63997	i0	100	0.068075117370892	29	0	7	0	373	401	113559	113587	Chondrocystis sp. NIES-4102 plasmid plasmid2 DNA, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
20758513	20758513	PRJNA1249535_S_NODE_246377_length_282_cov_1.497608_g242994_i0	PRJNA1249535	246377	282	1.497608	4.22325456	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g242994	i0	100	0.102836879432624	29	0	10	0	248	276	1511281	1511309	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
22032205	22032205	PRJNA1249535_S_NODE_130678_length_348_cov_4.120000_g127295_i0	PRJNA1249535	130678	348	4.12	14.3376	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	449	9.999999999999998e-122	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g127295	i0	90	154.204022988506	350	31	100	4	1	348	1336	1683	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	53663	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
22032527	22032527	PRJNA1249535_S_NODE_153818_length_333_cov_1.396154_g150435_i0	PRJNA1249535	153818	333	1.396154	4.64919282	unicellular thermophilic cyanobacterium tBTRCCn 28	384612	Bacteria	Bacteria	531	3.31e-146	NTclustered	gi\|95071025\|gb\|DQ471448.1\|	384612	g150435	i0	98.986	90.5945945945946	296	3	89	0	38	333	650	355	Unicellular thermophilic cyanobacterium tBTRCCn 28 16S ribosomal RNA gene, partial sequence	blastn	30168	531	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					unicellular thermophilic cyanobacterium tBTRCCn 28
22034004	22034004	PRJNA1249535_S_NODE_274898_length_266_cov_4.388601_g271515_i0	PRJNA1249535	274898	266	4.388601	11.67367866	Nostoc piscinale	224012	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|930349143\|gb\|CP012036.1\|	224013	g271515	i0	96.774	0.116541353383459	31	1	12	0	153	183	498809	498779	Nostoc piscinale CENA21 chromosome	blastn	31	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc piscinale
23308972	23308972	PRJNA1249535_S_NODE_218639_length_296_cov_4.062780_g215256_i0	PRJNA1249535	218639	296	4.06278	12.0258288	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g215256	i0	100	0.0945945945945946	28	0	9	0	27	54	813643	813670	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
24583968	24583968	PRJNA1249535_S_NODE_303560_length_251_cov_1.314607_g300177_i0	PRJNA1249535	303560	251	1.314607	3.29966357	Dolichospermum heterosporum	747522	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2283110535\|gb\|CP099464.1\|	747523	g300177	i0	94.444	0.270916334661355	36	2	14	0	181	216	1186040	1186005	Dolichospermum heterosporum TAC447 strain NIES-1697 chromosome, complete genome	blastn	68	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum heterosporum
25278601	25278601	PRJNA1249535_S_NODE_44720_length_498_cov_6.837647_g41390_i0	PRJNA1249535	44720	498	6.837647	34.05148206	Nostoc	1177	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g41390	i0	100	0.309236947791165	30	0	6	0	407	436	318779	318808	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	154	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789

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