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

29 rows where analysis = "blastn", bioproject = "PRJEB83101" 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
142864	142864	PRJEB83101_P_NODE_77661_length_246_cov_1.578035_g77356_i0	PRJEB83101	77661	246	1.578035	3.8819661	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	193	1.25e-44	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g77356	i0	81.356	0.959349593495935	236	44	96	0	11	246	6736574	6736339	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	236	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
997860	997860	PRJEB83101_P_NODE_44661_length_285_cov_3.179245_g44356_i0	PRJEB83101	44661	285	3.179245	9.06084825	root	1	Root_unresolved	Root_unresolved	521	1.6699999999999996e-143	NTclustered	gi\|344944308\|gb\|JN106378.1\|	1211	g44356	i0	100	102.908771929825	282	0	99	0	1	282	102	383	Uncultured cyanobacterium clone ASG3 16S ribosomal RNA gene, partial sequence	blastn	29329	521	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
2273075	2273075	PRJEB83101_P_NODE_47262_length_281_cov_1.192308_g46957_i0	PRJEB83101	47262	281	1.192308	3.35038548	Chroococcidiopsis	54298	Bacteria	Bacteria	270	6.569999999999999e-68	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g46957	i0	85.171	1.87188612099644	263	39	94	0	9	271	252772	253034	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	526	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
2691951	2691951	PRJEB83101_P_NODE_40143_length_295_cov_1.400901_g39838_i0	PRJEB83101	40143	295	1.400901	4.13265795	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g39838	i0	100	148.189830508475	295	0	100	0	1	295	1935085	1935379	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	43716	545	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
2692014	2692014	PRJEB83101_P_NODE_42383_length_290_cov_1.299539_g42078_i0	PRJEB83101	42383	290	1.299539	3.7686631	Microcoleus vaginatus	119532	Bacteria	Bacteria	292	1.45e-74	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g42078	i0	92.271	2.14137931034483	207	15	71	1	1	207	6125657	6125452	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	621	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
3968606	3968606	PRJEB83101_P_NODE_61224_length_258_cov_1.643243_g60919_i0	PRJEB83101	61224	258	1.643243	4.23956694	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g60919	i0	99.225	6.43798449612403	258	2	100	0	1	258	1987503	1987246	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	1661	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
3968630	3968630	PRJEB83101_P_NODE_62164_length_257_cov_1.195652_g61859_i0	PRJEB83101	62164	257	1.195652	3.07282564	Nostoc punctiforme	272131	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g61859	i0	96.774	0.120622568093385	31	1	12	0	58	88	3872230	3872260	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	31	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
5244628	5244628	PRJEB83101_P_NODE_44305_length_286_cov_1.464789_g44000_i0	PRJEB83101	44305	286	1.464789	4.18929654	Rippkaea orientalis	2546366	Bacteria	Bacteria	241	5.26e-59	NTclustered	gi\|218165370\|gb\|CP001287.1\|	41431	g44000	i0	82.27	2.94755244755245	282	46	98	4	7	286	4145655	4145376	Cyanothece sp. PCC 8801, complete genome	blastn	843	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Rippkaea	Rippkaea orientalis
6100687	6100687	PRJEB83101_P_NODE_16925_length_454_cov_3.296588_g16623_i0	PRJEB83101	16925	454	3.296588	14.96650952	Chroococcidiopsis	54298	Bacteria	Bacteria	833	0	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g16623	i0	99.78	164.299559471366	454	1	100	0	1	454	3237	2784	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	74592	839	0.99284862932062	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
9070202	9070202	PRJEB83101_P_NODE_77468_length_246_cov_1.803468_g77163_i0	PRJEB83101	77468	246	1.803468	4.43653128	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	305	1.54e-78	NTclustered	gi\|2245130261\|gb\|CP097481.1\|	2653189	g77163	i0	89.3	1.91463414634146	243	26	99	0	2	244	214967	215209	Chroococcidiopsis sp. CCNUC1 plasmid pA, complete sequence	blastn	471	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
9070329	9070329	PRJEB83101_P_NODE_82688_length_244_cov_0.912281_g82383_i0	PRJEB83101	82688	244	0.912281	2.22596564	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	235	2.0399999999999997e-57	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g82383	i0	84.016	3.97540983606557	244	39	100	0	1	244	7724104	7723861	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	970	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
9925813	9925813	PRJEB83101_P_NODE_35288_length_312_cov_2.263598_g34983_i0	PRJEB83101	35288	312	2.263598	7.06242576	Chroococcidiopsis	54298	Bacteria	Bacteria	279	1.23e-70	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g34983	i0	100	4.81089743589744	151	0	97	0	1	151	2671186	2671336	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	1501	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
10345707	10345707	PRJEB83101_P_NODE_71729_length_249_cov_1.772727_g71424_i0	PRJEB83101	71729	249	1.772727	4.41409023	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	93.5	1.33e-14	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g71424	i0	85.393	0.357429718875502	89	13	36	0	1	89	536658	536570	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	89	93.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
11201187	11201187	PRJEB83101_P_NODE_43949_length_287_cov_1.196262_g43644_i0	PRJEB83101	43949	287	1.196262	3.43327194	Chroococcidiopsis	54298	Bacteria	Bacteria	514	2.82e-141	NTclustered	gi\|485099067\|ref\|NR_102464.1\|	251229	g43644	i0	98.955	98.0243902439024	287	3	100	0	1	287	11	297	Chroococcidiopsis thermalis PCC 7203 16S ribosomal RNA, partial sequence	blastn	28133	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
11621539	11621539	PRJEB83101_P_NODE_84130_length_243_cov_0.917647_g83825_i0	PRJEB83101	84130	243	0.917647	2.22988221	uncultured cyanobacterium	1211	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|369724687\|gb\|JN792400.1\|	1211	g83825	i0	98.765	106.637860082305	243	3	100	0	1	243	863	621	Uncultured cyanobacterium clone PLYFP135 16S ribosomal RNA gene, partial sequence	blastn	25913	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13750969	13750969	PRJEB83101_P_NODE_16771_length_457_cov_1.773438_g16469_i0	PRJEB83101	16771	457	1.773438	8.10461166	Chroococcidiopsis	54298	Bacteria	Bacteria	845	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g16469	i0	100	118.643326039387	457	0	100	0	1	457	1289	1745	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	54220	845	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
13751701	13751701	PRJEB83101_P_NODE_82111_length_244_cov_0.912281_g81806_i0	PRJEB83101	82111	244	0.912281	2.22596564	Chroococcidiopsis	54298	Bacteria	Bacteria	307	4.25e-79	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g81806	i0	89.388	2.00819672131148	245	24	100	2	1	244	3796045	3795802	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	490	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
14170792	14170792	PRJEB83101_P_NODE_56812_length_265_cov_1.312500_g56507_i0	PRJEB83101	56812	265	1.3125	3.478125	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	254	6.19e-63	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g56507	i0	85.306	4.52452830188679	245	36	92	0	1	245	4721645	4721889	Nostoc sp. PCC 7524, complete genome	blastn	1199	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
14170961	14170961	PRJEB83101_P_NODE_63012_length_255_cov_2.434066_g62707_i0	PRJEB83101	63012	255	2.434066	6.2068683	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	104	6.31e-18	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g62707	i0	77.654	0.701960784313725	179	34	69	6	79	255	52612	52438	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	179	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
14171379	14171379	PRJEB83101_P_NODE_78892_length_246_cov_0.901734_g78587_i0	PRJEB83101	78892	246	0.901734	2.21826564	Fischerella sp. JS2	2597771	Bacteria	Bacteria	220	5.76e-53	NTclustered	gi\|2589057682\|gb\|CP135918.1\|	2597771	g78587	i0	83.333	17.650406504065	240	38	97	2	3	241	4427553	4427791	Fischerella sp. JS2 chromosome, complete genome	blastn	4342	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp. JS2
14171427	14171427	PRJEB83101_P_NODE_80812_length_245_cov_0.906977_g80507_i0	PRJEB83101	80812	245	0.906977	2.22209365	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	303	5.53e-78	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g80507	i0	90.129	9.29387755102041	233	23	95	0	9	241	6360849	6360617	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	2277	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
16300872	16300872	PRJEB83101_P_NODE_85113_length_242_cov_1.846154_g84808_i0	PRJEB83101	85113	242	1.846154	4.46769268	Chroococcidiopsis	54298	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g84808	i0	100	22.8347107438017	242	0	100	0	1	242	2725135	2725376	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	5526	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16300875	16300875	PRJEB83101_P_NODE_85933_length_242_cov_0.923077_g85628_i0	PRJEB83101	85933	242	0.923077	2.23384634	Chroococcidiopsis	54298	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g85628	i0	99.174	2	242	2	100	0	1	242	3552311	3552552	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	484	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16719672	16719672	PRJEB83101_P_NODE_80294_length_245_cov_0.906977_g79989_i0	PRJEB83101	80294	245	0.906977	2.22209365	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	217	7.41e-52	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g79989	i0	82.716	3.2734693877551	243	42	99	0	1	243	1505296	1505054	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	802	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
18849640	18849640	PRJEB83101_P_NODE_4855_length_931_cov_2.856643_g4623_i0	PRJEB83101	4855	931	2.856643	26.59534633	Chroococcidiopsis	54298	Bacteria	Bacteria	1659	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g4623	i0	99.029	158.518796992481	927	5	99	4	7	931	935	11	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	147581	1659	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
18849810	18849810	PRJEB83101_P_NODE_66375_length_252_cov_1.743017_g66070_i0	PRJEB83101	66375	252	1.743017	4.39240284	Chroococcidiopsis	54298	Bacteria	Bacteria	178	3.61e-40	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g66070	i0	94.783	1672.3253968254	115	5	58	1	1	114	3065106	3064992	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	421426	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
22675027	22675027	PRJEB83101_P_NODE_70318_length_250_cov_1.096045_g70013_i0	PRJEB83101	70318	250	1.096045	2.7401125	Nostoc	1177	Bacteria	Bacteria	60.2	1.35e-4	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g70013	i0	91.111	2.312	45	3	18	1	67	111	3707611	3707654	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	578	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
24367523	24367523	PRJEB83101_P_NODE_35140_length_312_cov_3.016736_g34835_i0	PRJEB83101	35140	312	3.016736	9.41221632	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	174	5.97e-39	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g34835	i0	87.417	0.961538461538462	151	19	48	0	162	312	5315078	5314928	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	300	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
24367900	24367900	PRJEB83101_P_NODE_49200_length_277_cov_2.186275_g48895_i0	PRJEB83101	49200	277	2.186275	6.05598175	Nostoc sp. C057	2576903	Bacteria	Bacteria	307	4.9300000000000005e-79	NTclustered	gi\|1866653154\|gb\|CP040288.1\|	2576903	g48895	i0	86.643	7	277	37	100	0	1	277	124226	123950	Nostoc sp. C057 plasmid p057_G	blastn	1939	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057

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