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

28 rows where analysis = "blastn", bioproject = "PRJNA600413" 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
3124336	3124336	PRJNA600413_P_NODE_141723_length_162_cov_0.902655_g141022_i0	PRJNA600413	141723	162	0.902655	1.4623011	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	217	4.5199999999999996e-52	NTclustered	gi\|2245130261\|gb\|CP097481.1\|	2653189	g141022	i0	98.374	0.759259259259259	123	2	76	0	40	162	90890	90768	Chroococcidiopsis sp. CCNUC1 plasmid pA, complete sequence	blastn	123	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
3124979	3124979	PRJNA600413_P_NODE_31523_length_253_cov_2.862745_g30822_i0	PRJNA600413	31523	253	2.862745	7.24274485	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	355	1.56e-93	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g30822	i0	92.126	163.00395256917	254	17	100	3	1	253	2998	2747	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41240	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4402041	4402041	PRJNA600413_P_NODE_45824_length_216_cov_1.269461_g45123_i0	PRJNA600413	45824	216	1.269461	2.74203576	Oscillatoria sp. CCAP 1459/13	272128	Bacteria	Bacteria	200	6.429999999999999e-47	NTclustered	gi\|46409890\|gb\|AY584515.1\|	272128	g45123	i0	86.022	392.462962962963	186	26	86	0	18	203	1387	1202	Oscillatoria sp. CCAP 1459/13 23S ribosomal RNA gene, partial sequence	blastn	84772	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. CCAP 1459/13
4970333	4970333	PRJNA600413_P_NODE_36364_length_237_cov_3.601064_g35663_i0	PRJNA600413	36364	237	3.601064	8.53452168	Bacteria	2	Bacteria	Bacteria	422	1.41e-113	NTclustered	gi\|1364871907\|gb\|MH074969.1\|	1211	g35663	i0	98.739	99.9324894514768	238	1	100	2	1	237	467	703	Uncultured cyanobacterium clone AG-313-N08 16S ribosomal RNA gene, partial sequence	blastn	23684	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6245887	6245887	PRJNA600413_P_NODE_33785_length_246_cov_0.903553_g33084_i0	PRJNA600413	33785	246	0.903553	2.22274038	Oscillatoriales	1150	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g33084	i0	99.593	111.735772357724	246	1	100	0	1	246	2428	2183	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	27487	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8794564	8794564	PRJNA600413_P_NODE_12847_length_407_cov_12.407821_g12148_i0	PRJNA600413	12847	407	12.407821	50.49983147	root	1	Root_unresolved	Root_unresolved	719	0	NTclustered	gi\|47594\|emb\|X53842.1\|	1148	g12148	i0	99.248	101.958230958231	399	2	98	1	1	399	340	737	Synechocystis sp. ndhE gene (partial), psaC gene for photosystem I iron-sulfur protein and ndhD-like ORF	blastn	41497	726	0.990358126721763	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
9501548	9501548	PRJNA600413_P_NODE_124208_length_164_cov_0.886957_g123507_i0	PRJNA600413	124208	164	0.886957	1.45460948	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	182	1.67e-41	NTclustered	gi\|427977893\|gb\|CP003590.1\|	118163	g123507	i0	87.821	1.95731707317073	156	18	95	1	1	156	3988734	3988888	Pleurocapsa sp. PCC 7327, complete genome	blastn	321	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
9501601	9501601	PRJNA600413_P_NODE_127148_length_164_cov_0.886957_g126447_i0	PRJNA600413	127148	164	0.886957	1.45460948	Gloeothece verrucosa	2546359	Bacteria	Bacteria	158	2.82e-34	NTclustered	gi\|306985596\|gb\|CP002199.1\|	497965	g126447	i0	84.568	0.98780487804878	162	22	98	3	3	163	156522	156681	Cyanothece sp. PCC 7822 plasmid Cy782201, complete sequence	blastn	162	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
9501868	9501868	PRJNA600413_P_NODE_148348_length_161_cov_0.910714_g147647_i0	PRJNA600413	148348	161	0.910714	1.46624954	Nostoc sp. HK-01	196308	Bacteria	Bacteria	137	3.59e-28	NTclustered	gi\|1373825370\|dbj\|AP018319.1\|	196308	g147647	i0	83.221	0.925465838509317	149	25	93	0	12	160	445216	445068	Nostoc sp. HK-01 plasmid plasmid1 DNA, complete genome	blastn	149	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
10779670	10779670	PRJNA600413_P_NODE_97149_length_169_cov_2.558333_g96448_i0	PRJNA600413	97149	169	2.558333	4.32358277	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	193	7.97e-45	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g96448	i0	88.344	4.0887573964497	163	16	96	1	7	169	181160	181001	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	691	193	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
11345104	11345104	PRJNA600413_P_NODE_126589_length_164_cov_0.886957_g125888_i0	PRJNA600413	126589	164	0.886957	1.45460948	Leptolyngbya	47251	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g125888	i0	100	6	164	0	100	0	1	164	5191654	5191817	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	984	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
12052594	12052594	PRJNA600413_P_NODE_147250_length_161_cov_0.910714_g146549_i0	PRJNA600413	147250	161	0.910714	1.46624954	Nodularia sphaerocarpa	137816	Bacteria	Bacteria	76.8	7.94e-10	NTclustered	gi\|2198613447\|gb\|CP060140.1\|	2761619	g146549	i0	83.333	0.521739130434783	84	12	52	2	1	83	1122221	1122303	Nodularia sphaerocarpa UHCC 0038 chromosome, complete genome	blastn	84	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia sphaerocarpa
14602261	14602261	PRJNA600413_P_NODE_142612_length_162_cov_0.902655_g141911_i0	PRJNA600413	142612	162	0.902655	1.4623011	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	182	1.6499999999999996e-41	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g141911	i0	98.095	11.8395061728395	105	0	100	2	59	162	4447051	4446948	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	1918	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
14602327	14602327	PRJNA600413_P_NODE_147232_length_161_cov_0.910714_g146531_i0	PRJNA600413	147232	161	0.910714	1.46624954	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	279	5.64e-71	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g146531	i0	98.125	6.99378881987578	160	3	100	0	2	161	173458	173299	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	1126	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
14602513	14602513	PRJNA600413_P_NODE_17472_length_343_cov_2.588435_g16771_i0	PRJNA600413	17472	343	2.588435	8.87833205	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	514	3.44e-141	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g16771	i0	93.623	105.046647230321	345	20	100	2	1	343	1773	2117	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36031	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14603949	14603949	PRJNA600413_P_NODE_78632_length_180_cov_4.671756_g77931_i0	PRJNA600413	78632	180	4.671756	8.4091608	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	327	2.2699999999999996e-85	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g77931	i0	99.444	147.522222222222	180	1	100	0	1	180	3077	2898	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	26554	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15170183	15170183	PRJNA600413_P_NODE_153372_length_157_cov_2.814815_g152671_i0	PRJNA600413	153372	157	2.814815	4.41925955	Chroococcidiopsis	54298	Bacteria	Bacteria	176	7.37e-40	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g152671	i0	93.966	3.77070063694268	116	7	96	0	1	116	1439722	1439837	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	592	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16444418	16444418	PRJNA600413_P_NODE_106353_length_167_cov_0.864407_g105652_i0	PRJNA600413	106353	167	0.864407	1.44355969	Microcystis	1125	Bacteria	Bacteria	217	4.69e-52	NTclustered	gi\|1861038497\|dbj\|LC557444.1\|	1126	g105652	i0	90.303	128	165	16	99	0	1	165	205	41	Microcystis aeruginosa NIES-1356 gene for 23S rRNA, partial sequence	blastn	21376	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
16444559	16444559	PRJNA600413_P_NODE_13153_length_402_cov_2.005666_g12454_i0	PRJNA600413	13153	402	2.005666	8.06277732	Oscillatoriales	1150	Bacteria	Bacteria	667	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g12454	i0	96.535	122.278606965174	404	12	100	2	1	402	2143	1740	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	49156	673	0.991084695393759	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16445084	16445084	PRJNA600413_P_NODE_51753_length_206_cov_1.452229_g51052_i0	PRJNA600413	51753	206	1.452229	2.99159174	Chroococcidiopsis	54298	Bacteria	Bacteria	148	2.2299999999999996e-31	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g51052	i0	95.652	1.39805825242718	92	4	93	0	1	92	1052136	1052227	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	288	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
18425054	18425054	PRJNA600413_P_NODE_126635_length_164_cov_0.886957_g125934_i0	PRJNA600413	126635	164	0.886957	1.45460948	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g125934	i0	100	15.3780487804878	164	0	100	0	1	164	715302	715465	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	2522	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
19701445	19701445	PRJNA600413_P_NODE_68496_length_187_cov_1.840580_g67795_i0	PRJNA600413	68496	187	1.84058	3.4418846	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	122	1.2e-23	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g67795	i0	85.965	4.10160427807487	114	16	61	0	1	114	407399	407286	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	767	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
20268735	20268735	PRJNA600413_P_NODE_42056_length_223_cov_4.873563_g41355_i0	PRJNA600413	42056	223	4.873563	10.86804549	Cyanophyceae	3028117	Bacteria	Bacteria	374	3.72e-99	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g41355	i0	96.861	110.609865470852	223	7	100	0	1	223	2612	2834	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24666	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20269211	20269211	PRJNA600413_P_NODE_96216_length_170_cov_1.685950_g95515_i0	PRJNA600413	96216	170	1.68595	2.866115	Chroococcidiopsis	54298	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g95515	i0	100	3.63529411764706	170	0	100	0	1	170	6125914	6125745	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	618	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
21544647	21544647	PRJNA600413_P_NODE_95557_length_170_cov_2.123967_g94856_i0	PRJNA600413	95557	170	2.123967	3.6107439	Nostoc	1177	Bacteria	Bacteria	152	1.36e-32	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g94856	i0	82.84	32	169	29	99	0	1	169	5431876	5432044	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	5440	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23525447	23525447	PRJNA600413_P_NODE_121959_length_165_cov_0.879310_g121258_i0	PRJNA600413	121959	165	0.87931	1.4508615	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	195	2.17e-45	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g121258	i0	87.879	1	165	20	100	0	1	165	943771	943607	Gloeocapsa sp. PCC 7428, complete genome	blastn	165	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
24798968	24798968	PRJNA600413_P_NODE_103800_length_167_cov_0.864407_g103099_i0	PRJNA600413	103800	167	0.864407	1.44355969	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	111	2.28e-20	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g103099	i0	91.358	0.48502994011976	81	7	49	0	87	167	3968594	3968514	Calothrix sp. PCC 7716 DNA, complete genome	blastn	81	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
25368001	25368001	PRJNA600413_P_NODE_106800_length_167_cov_0.864407_g106099_i0	PRJNA600413	106800	167	0.864407	1.44355969	Chroococcidiopsis	54298	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g106099	i0	100	2.9940119760479	167	0	100	0	1	167	1652119	1651953	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	500	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis

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