metadata: contig_metadata: 23 rows where bioproject = "PRJNA781196" and tax_clade = "Cyanobacteriota/Melainabacteria group"

23 rows where bioproject = "PRJNA781196" 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
759353	759353	PRJNA781196_P_NODE_44161_length_269_cov_2.040816_g43784_i0	PRJNA781196	44161	269	2.040816	5.48979504	Pleurocapsa minor	54308	Bacteria	Bacteria	477	3.4299999999999985e-130	NTclustered	gi\|2717502817\|gb\|PP667998.1\|	3139816	g43784	i0	98.876	126.35687732342	267	3	99	0	1	267	2252	2518	Pleurocapsa minor SAG 4.99 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33990	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
2035004	2035004	PRJNA781196_P_NODE_16882_length_405_cov_1.292169_g16505_i0	PRJNA781196	16882	405	1.292169	5.23328445	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	466	1.17e-126	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g16505	i0	87.438	197.130864197531	406	49	100	2	1	405	2034	1630	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	79838	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3310525	3310525	PRJNA781196_P_NODE_38063_length_289_cov_1.310185_g37686_i0	PRJNA781196	38063	289	1.310185	3.78643465	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	451	2.26e-122	NTclustered	gi\|225696180\|gb\|FJ805847.1\|	259957	g37686	i0	96.679	98.681660899654	271	9	94	0	1	271	2473	2743	Uncultured Chroococcidiopsis sp. clone AU1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28519	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5863067	5863067	PRJNA781196_P_NODE_60145_length_246_cov_1.352601_g59768_i0	PRJNA781196	60145	246	1.352601	3.32739846	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	231	2.6599999999999996e-56	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g59768	i0	96.429	85.4390243902439	140	5	72	0	38	177	1753	1614	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	21018	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6315387	6315387	PRJNA781196_P_NODE_57225_length_248_cov_0.914286_g56848_i0	PRJNA781196	57225	248	0.914286	2.26742928	Nostoc	1177	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|586962788\|gb\|KF921498.1\|	1464557	g56848	i0	99.597	112.987903225806	248	1	100	0	1	248	1225	978	Nostoc sp. PAN-549 16S ribosomal RNA gene, partial sequence	blastn	28021	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PAN-549
7138030	7138030	PRJNA781196_P_NODE_44006_length_270_cov_1.187817_g43629_i0	PRJNA781196	44006	270	1.187817	3.2071059	uncultured cyanobacterium	1211	Bacteria	Bacteria	383	7.73e-102	NTclustered	gi\|2874253781\|emb\|OY969765.1\|	1211	g43629	i0	92.222	135.151851851852	270	21	100	0	1	270	2239543	2239274	MAG: uncultured cyanobacterium isolate MFD03250.bin.1.145 genome assembly, chromosome: 1	blastn	36491	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7138057	7138057	PRJNA781196_P_NODE_45666_length_265_cov_1.312500_g45289_i0	PRJNA781196	45666	265	1.3125	3.478125	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	479	9.38e-131	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g45289	i0	99.245	166.932075471698	265	2	100	0	1	265	1244607	1244343	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	44237	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
7589367	7589367	PRJNA781196_P_NODE_56946_length_248_cov_2.045714_g56569_i0	PRJNA781196	56946	248	2.045714	5.07337072	Myxosarcina	52605	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|321271924\|gb\|HQ419021.1\|	1211	g56569	i0	99.597	100.673387096774	248	1	100	0	1	248	678	431	Uncultured cyanobacterium clone AL66_2CY_12 16S ribosomal RNA gene, partial sequence	blastn	24967	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
9687935	9687935	PRJNA781196_P_NODE_47828_length_258_cov_1.881081_g47451_i0	PRJNA781196	47828	258	1.881081	4.85318898	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	436	5.549999999999999e-118	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g47451	i0	97.287	217.496124031008	258	6	100	1	1	258	1857871	1857615	Calothrix sp. PCC 7716 DNA, complete genome	blastn	56114	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
11415054	11415054	PRJNA781196_P_NODE_14269_length_434_cov_7.875346_g13892_i0	PRJNA781196	14269	434	7.875346	34.17900164	Cyanophyceae	3028117	Bacteria	Bacteria	227	5.73e-74	NR	WP_190670235.1	2692825	g13892	i0	76.6	15.5668202764977	141	33	97.5	0	423	1	2	142	WP_190670235.1 nucleoside-diphosphate kinase [Microcoleus sp. FACHB-672]	diamond	6756	229	0.991266375545852	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. FACHB-672
11415168	11415168	PRJNA781196_P_NODE_39489_length_284_cov_3.109005_g39112_i0	PRJNA781196	39489	284	3.109005	8.8295742	Oscillatoriales	1150	Bacteria	Bacteria	505	1.67e-138	NTclustered	gi\|485099158\|ref\|NR_102552.1\|	179408	g39112	i0	98.601	152.18661971831	286	2	100	2	1	284	1467	1182	Oscillatoria nigro-viridis PCC 7112 strain PCC 7112 23S ribosomal RNA, complete sequence	blastn	43221	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
13512936	13512936	PRJNA781196_P_NODE_26751_length_335_cov_1.786260_g26374_i0	PRJNA781196	26751	335	1.78626	5.983971	root	1	Root_unresolved	Root_unresolved	183	3.5e-53	NR	OWY73533.1	1503470	g26374	i0	81.1	20.8746268656716	111	21	99.4	0	335	3	200	310	OWY73533.1 adenosylhomocysteinase [cyanobacterium TDX16]	diamond	6993	184	0.994565217391304	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
19062847	19062847	PRJNA781196_P_NODE_14375_length_433_cov_1.586111_g13998_i0	PRJNA781196	14375	433	1.586111	6.86786063	Cyanophyceae	3028117	Bacteria	Bacteria	717	0	NTclustered	gi\|385721928\|gb\|JQ253477.1\|	1211	g13998	i0	96.536	102.069284064665	433	15	100	0	1	433	318	750	Uncultured cyanobacterium clone QULP1F4 16S ribosomal RNA gene, partial sequence	blastn	44196	717	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20337704	20337704	PRJNA781196_P_NODE_49836_length_253_cov_1.250000_g49459_i0	PRJNA781196	49836	253	1.25	3.1625	Cyanophyceae	3028117	Bacteria	Bacteria	368	2.01e-97	NTclustered	gi\|146740647\|emb\|AM709634.1\|	372780	g49459	i0	92.941	158.418972332016	255	14	100	4	1	253	2629	2881	Fischerella muscicola SAG 2027 partial ribosomal RNA operon, strain SAG 2027	blastn	40080	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella muscicola
22436893	22436893	PRJNA781196_P_NODE_55878_length_249_cov_0.886364_g55501_i0	PRJNA781196	55878	249	0.886364	2.20704636	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'	1618022	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1349670869\|gb\|CP026692.1\|	1618022	g55501	i0	100	0.112449799196787	28	0	11	0	85	112	998391	998418	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont' strain 5183 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'
23711795	23711795	PRJNA781196_P_NODE_13359_length_447_cov_1.593583_g12982_i0	PRJNA781196	13359	447	1.593583	7.12331601	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	658	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g12982	i0	93.289	226.695749440716	447	29	100	1	1	447	3669738	3669293	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	101333	658	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
27338117	27338117	PRJNA781196_P_NODE_55743_length_249_cov_1.159091_g55366_i0	PRJNA781196	55743	249	1.159091	2.88613659	Synechococcus sp. NOUM97	1131	Bacteria	Bacteria	42.7	0.0389	NR	WP_186479849.1	1442555	g55366	i0	36.6	0.855421686746988	71	41	85.5	1	231	19	63	129	WP_186479849.1 GTPase ObgE [Synechococcus sp. NOUM97013]	diamond	213	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. NOUM97013
27464492	27464492	PRJNA781196_P_NODE_62383_length_245_cov_0.906977_g62006_i0	PRJNA781196	62383	245	0.906977	2.22209365	Nostoc sp. DedQUE01	3075387	Bacteria	Bacteria	63.9	1.82e-10	NR	MFN6501164.1	3075387	g62006	i0	34.7	0.918367346938776	75	49	91.8	0	225	1	6	80	MFN6501164.1 TerB family tellurite resistance protein [Nostoc sp. DedQUE01]	diamond	225	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. DedQUE01
27884135	27884135	PRJNA781196_P_NODE_61185_length_246_cov_0.901734_g60808_i0	PRJNA781196	61185	246	0.901734	2.21826564	Cyanophyceae	3028117	Bacteria	Bacteria	47.4	8.5e-4	NR	WP_066119880.1	1617448	g60808	i0	27.8	4.86585365853659	79	56	95.1	1	245	12	259	337	WP_066119880.1 mechanosensitive ion channel family protein [Geminocystis sp. NIES-3709]	diamond	1197	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
30748679	30748679	PRJNA781196_P_NODE_66974_length_242_cov_0.923077_g66597_i0	PRJNA781196	66974	242	0.923077	2.23384634	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	90.9	3.88e-19	NR	MBW4503829.1	1939789	g66597	i0	51.3	3	80	39	99.2	0	242	3	186	265	MBW4503829.1 NAD(P)-binding protein [Scytonema hyalinum WJT4-NPBG1]	diamond	726	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
31190608	31190608	PRJNA781196_P_NODE_59315_length_247_cov_0.896552_g58938_i0	PRJNA781196	59315	247	0.896552	2.21448344	Nostoc sp. CCY0012	1056123	Bacteria	Bacteria	58.2	3.92e-8	NR	WP_414543588.1	1056123	g58938	i0	48.2	0.680161943319838	56	28	68	1	73	240	48	102	WP_414543588.1 DUF4174 domain-containing protein [Nostoc sp. CCY0012]	diamond	168	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CCY0012
31254147	31254147	PRJNA781196_P_NODE_49735_length_253_cov_1.316667_g49358_i0	PRJNA781196	49735	253	1.316667	3.33116751	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	114	1.54e-29	NR	MBW4638347.1	2839657	g49358	i0	74.7	0.984189723320158	83	21	98.4	0	251	3	75	157	MBW4638347.1 DUF305 domain-containing protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	249	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
32424719	32424719	PRJNA781196_P_NODE_36119_length_296_cov_0.959641_g35742_i0	PRJNA781196	36119	296	0.959641	2.84053736	Calothrix sp. NIES-21	1187	Bacteria	Bacteria	50.1	1.65e-4	NR	WP_096603467.1	1954172	g35742	i0	42	1.53040540540541	50	29	50.7	0	10	159	8	57	WP_096603467.1 WD40 repeat domain-containing protein [Calothrix sp. NIES-2100]	diamond	453	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2100

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