metadata: contig_metadata: 24 rows where bioproject = "PRJNA1180292" and tax_clade = "Cyanobacteriota/Melainabacteria group"

24 rows where bioproject = "PRJNA1180292" 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
1041252	1041252	PRJNA1180292_P_NODE_4121_length_340_cov_1.715356_g3989_i0	PRJNA1180292	4121	340	1.715356	5.8322104	root	1	Root_unresolved	Root_unresolved	627	4.199999999999999e-175	NTclustered	gi\|2022617059\|gb\|MW876296.1\|	1211	g3989	i0	100	196.420588235294	339	0	99	0	1	339	507	845	Uncultured cyanobacterium clone Chav3-2-80 16S ribosomal RNA gene, partial sequence	blastn	66783	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1041259	1041259	PRJNA1180292_P_NODE_5361_length_301_cov_1.504386_g5229_i0	PRJNA1180292	5361	301	1.504386	4.52820186	Chroococcidiopsis	54298	Bacteria	Bacteria	388	1.88e-103	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g5229	i0	90.099	155.056478405316	303	25	99	3	1	300	795209	795509	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	46672	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
4144833	4144833	PRJNA1180292_P_NODE_8144_length_253_cov_0.866667_g8012_i0	PRJNA1180292	8144	253	0.866667	2.19266751	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	219	2.1399999999999993e-52	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g8012	i0	84.615	0.873517786561265	221	33	87	1	32	251	3943703	3943923	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	221	219	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
9245711	9245711	PRJNA1180292_P_NODE_11428_length_245_cov_0.906977_g11296_i0	PRJNA1180292	11428	245	0.906977	2.22209365	Sphaerospermopsis torques-reginae	984207	Bacteria	Bacteria	224	4.43e-54	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g11296	i0	94.483	5.57959183673469	145	8	59	0	99	243	5211378	5211234	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	1367	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
11796556	11796556	PRJNA1180292_P_NODE_9790_length_249_cov_0.886364_g9658_i0	PRJNA1180292	9790	249	0.886364	2.20704636	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g9658	i0	93.074	2.84738955823293	231	16	93	0	19	249	3771503	3771733	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	709	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
14346935	14346935	PRJNA1180292_P_NODE_6912_length_268_cov_1.994872_g6780_i0	PRJNA1180292	6912	268	1.994872	5.34625696	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g6780	i0	100	248.514925373134	268	0	100	0	1	268	5151	4884	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	66602	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
15620604	15620604	PRJNA1180292_P_NODE_11073_length_246_cov_0.901734_g10941_i0	PRJNA1180292	11073	246	0.901734	2.21826564	Anabaena cylindrica	1165	Bacteria	Bacteria	122	1.67e-23	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g10941	i0	91.954	3.47967479674797	87	7	35	0	2	88	5166600	5166686	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	856	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
16894924	16894924	PRJNA1180292_P_NODE_11494_length_245_cov_0.906977_g11362_i0	PRJNA1180292	11494	245	0.906977	2.22209365	Planktothricoides raciborskii	132608	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g11362	i0	94.595	1.06530612244898	37	0	27	2	168	202	2693355	2693391	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	261	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
16895009	16895009	PRJNA1180292_P_NODE_6354_length_279_cov_1.266990_g6222_i0	PRJNA1180292	6354	279	1.26699	3.5349021	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	364	2.909999999999999e-96	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g6222	i0	90.288	10.7025089605735	278	27	99	0	1	278	5952917	5953194	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	2986	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
19443918	19443918	PRJNA1180292_P_NODE_8376_length_252_cov_0.871508_g8244_i0	PRJNA1180292	8376	252	0.871508	2.19620016	Cyanobacteriota	1117	Bacteria	Bacteria	86.3	6.34e-18	NR	HEY9720629.1	2664179	g8244	i0	58.2	1.89285714285714	79	33	94	0	2	238	7	85	HEY9720629.1 LysR substrate-binding domain-containing protein [Oscillatoriaceae cyanobacterium]	diamond	477	86.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae		Oscillatoriaceae cyanobacterium
27040635	27040635	PRJNA1180292_P_NODE_9902_length_249_cov_0.886364_g9770_i0	PRJNA1180292	9902	249	0.886364	2.20704636	Leptolyngbya sp. 'hensonii'	1922337	Bacteria	Bacteria	107	9.99e-25	NR	WP_075596946.1	1922337	g9770	i0	63	1.95180722891566	81	29	96.4	1	1	240	38	118	WP_075596946.1 anti-phage-associated DUF1156 domain-containing protein [Leptolyngbya sp. 'hensonii']	diamond	486	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 'hensonii'
27261977	27261977	PRJNA1180292_P_NODE_3103_length_389_cov_0.987342_g2971_i0	PRJNA1180292	3103	389	0.987342	3.84076038	Anabaena	1163	Bacteria	Bacteria	49.3	8.68e-4	NR	WP_015217039.1	1163	g2971	i0	32	0.794344473007712	103	52	79.4	3	309	1	308	392	WP_015217039.1 MULTISPECIES: Tudor-knot domain-containing protein [Anabaena]	diamond	309	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena
27388445	27388445	PRJNA1180292_P_NODE_10263_length_248_cov_0.891429_g10131_i0	PRJNA1180292	10263	248	0.891429	2.21074392	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	134	1.05e-34	NR	MDY6802214.1	2847862	g10131	i0	89	1.98387096774194	82	9	99.2	0	248	3	10	91	MDY6802214.1 DNA mismatch repair endonuclease MutL [Cyanobacteriota bacterium]	diamond	492	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28038999	28038999	PRJNA1180292_P_NODE_8985_length_251_cov_0.876404_g8853_i0	PRJNA1180292	8985	251	0.876404	2.19977404	Cyanophyceae	3028117	Bacteria	Bacteria	160	1.26e-43	NR	WP_107666362.1	2082950	g8853	i0	78.3	8.92828685258964	83	18	99.2	0	249	1	36	118	WP_107666362.1 plasmid replication protein, CyRepA1 family [Cyanothece sp. BG0011]	diamond	2241	161	0.993788819875776	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. BG0011
28165240	28165240	PRJNA1180292_P_NODE_7665_length_255_cov_0.934066_g7533_i0	PRJNA1180292	7665	255	0.934066	2.3818683	Drouetiella	2303513	Bacteria	Bacteria	124	6.419999999999999e-31	NR	MBW4658798.1	904376	g7533	i0	64.7	5	85	30	100	0	255	1	402	486	MBW4658798.1 carboxylate-amine ligase [Drouetiella hepatica Uher 2000/2452]	diamond	1275	125	0.992	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella hepatica
28512481	28512481	PRJNA1180292_P_NODE_7387_length_260_cov_1.251337_g7255_i0	PRJNA1180292	7387	260	1.251337	3.2534762	Nostoc	1177	Bacteria	Bacteria	67.8	9.76e-13	NR	WP_340097065.1	272131	g7255	i0	45.2	1.43076923076923	62	34	71.5	0	190	5	3	64	WP_340097065.1 GIY-YIG nuclease family protein [Nostoc punctiforme]	diamond	372	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
28808798	28808798	PRJNA1180292_P_NODE_12808_length_242_cov_0.923077_g12676_i0	PRJNA1180292	12808	242	0.923077	2.23384634	Nostoc sp. TCL26-	1180	Bacteria	Bacteria	95.9	7.44e-21	NR	WP_179046383.1	2576904	g12676	i0	64.9	0.954545454545455	77	27	95.5	0	5	235	1683	1759	WP_179046383.1 FG-GAP-like repeat-containing protein [Nostoc sp. TCL26-01]	diamond	231	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
29250970	29250970	PRJNA1180292_P_NODE_11609_length_245_cov_0.906977_g11477_i0	PRJNA1180292	11609	245	0.906977	2.22209365	Annamia dubia NIES-4383	2759045	Bacteria	Bacteria	133	5.15e-35	NR	BDG65685.1	2759045	g11477	i0	80.2	0.991836734693878	81	16	99.2	0	3	245	161	241	BDG65685.1 integral membrane signal transducer protein [Annamia dubia NIES-4383]	diamond	243	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
29870214	29870214	PRJNA1180292_P_NODE_12891_length_242_cov_0.923077_g12759_i0	PRJNA1180292	12891	242	0.923077	2.23384634	Bacillati	1783272	Bacteria	Bacteria	46.2	0.00184	NR	MFN5564345.1	1153	g12759	i0	37.5	3.34710743801653	64	40	79.3	0	234	43	118	181	MFN5564345.1 hypothetical protein [Pseudanabaena sp.]	diamond	810	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
29965055	29965055	PRJNA1180292_P_NODE_3871_length_349_cov_1.130435_g3739_i0	PRJNA1180292	3871	349	1.130435	3.94521815	root	1	Root_unresolved	Root_unresolved	109	1.52e-25	NR	MBW4622826.1	1874554	g3739	i0	49.1	18.4985673352436	114	50	98	3	348	7	280	385	MBW4622826.1 4-hydroxyphenylpyruvate dioxygenase [Cyanosarcina radialis HA8281-LM2]	diamond	6456	109	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Cyanosarcina	Cyanosarcina radialis
31652277	31652277	PRJNA1180292_P_NODE_7917_length_253_cov_0.866667_g7785_i0	PRJNA1180292	7917	253	0.866667	2.19266751	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	110	2.55e-26	NR	MBK9143940.1	2052166	g7785	i0	52.4	0.972332015810277	82	39	97.2	0	3	248	125	206	MBK9143940.1 cytochrome-c peroxidase [Candidatus Melainabacteria bacterium]	diamond	246	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31778892	31778892	PRJNA1180292_P_NODE_8517_length_252_cov_0.871508_g8385_i0	PRJNA1180292	8517	252	0.871508	2.19620016	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	70.9	4.38e-14	NR	MFM2314679.1	2847862	g8385	i0	90.6	0.761904761904762	32	3	38.1	0	96	1	1	32	MFM2314679.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	192	70.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32475231	32475231	PRJNA1180292_P_NODE_12139_length_244_cov_0.912281_g12007_i0	PRJNA1180292	12139	244	0.912281	2.22596564	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	45.4	0.00407	NR	MBC7474511.1	2762020	g12007	i0	44.9	0.848360655737705	69	31	78.7	2	3	194	457	523	MBC7474511.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Sericytochromatia bacterium]	diamond	207	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32758875	32758875	PRJNA1180292_P_NODE_11620_length_245_cov_0.906977_g11488_i0	PRJNA1180292	11620	245	0.906977	2.22209365	Synechococcaceae cyanobacterium	2588875	Bacteria	Bacteria	144	8.43e-40	NR	MEB3323494.1	2588875	g11488	i0	85.2	1.98367346938776	81	12	99.2	0	243	1	194	274	MEB3323494.1 hypothetical protein [Synechococcaceae cyanobacterium]	diamond	486	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae cyanobacterium

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