metadata: contig_metadata: 27 rows where bioproject = "PRJNA1247234" and tax

27 rows where bioproject = "PRJNA1247234" and tax_phylum = "Cyanobacteriota"

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
351304	351304	PRJNA1247234_P_NODE_22721_length_249_cov_1.329545_g22565_i0	PRJNA1247234	22721	249	1.329545	3.31056705	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	289	1.58e-73	NTclustered	gi\|225696178\|gb\|FJ805845.1\|	259957	g22565	i0	93.035	111.128514056225	201	9	80	5	51	249	1556	1753	Uncultured Chroococcidiopsis sp. clone AU1_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27671	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1051729	1051729	PRJNA1247234_P_NODE_27661_length_242_cov_0.923077_g27505_i0	PRJNA1247234	27661	242	0.923077	2.23384634	Microcystis	1125	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g27505	i0	100	19.995867768595	242	0	100	0	1	242	1283224	1282983	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	4839	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
1626312	1626312	PRJNA1247234_P_NODE_542_length_1163_cov_5.643119_g469_i0	PRJNA1247234	542	1163	5.643119	65.62947397	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1528	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g469	i0	91.818	130.742046431642	1100	85	100	5	1	1096	2884	1786	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	152053	1528	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2327195	2327195	PRJNA1247234_P_NODE_9782_length_345_cov_1.125000_g9626_i0	PRJNA1247234	9782	345	1.125	3.88125	Microcystis	1125	Bacteria	Bacteria	621	1.98e-173	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g9626	i0	99.13	6	345	3	100	0	1	345	988147	987803	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	2070	621	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
4178802	4178802	PRJNA1247234_P_NODE_4004_length_497_cov_0.919811_g3853_i0	PRJNA1247234	4004	497	0.919811	4.57146067	Nodularia spumigena	70799	Bacteria	Bacteria	325	1.2699999999999997e-106	NR	WP_323245539.1	70799	g3853	i0	92.7	1.99195171026157	165	12	99.6	0	496	2	63	227	WP_323245539.1 methionine--tRNA ligase, partial [Nodularia spumigena]	diamond	990	325	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
4879695	4879695	PRJNA1247234_P_NODE_11524_length_324_cov_0.880478_g11368_i0	PRJNA1247234	11524	324	0.880478	2.85274872	Chroococcidiopsis	54298	Bacteria	Bacteria	479	1.1799999999999993e-130	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g11368	i0	95.652	13.3888888888889	299	12	99	1	1	298	883650	883352	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	4338	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
4879701	4879701	PRJNA1247234_P_NODE_12004_length_318_cov_1.910204_g11848_i0	PRJNA1247234	12004	318	1.910204	6.07444872	Microcystis	1125	Bacteria	Bacteria	586	6.609999999999998e-163	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g11848	i0	100	85.8710691823899	317	0	99	0	2	318	4150000	4149684	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	27307	586	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
6154348	6154348	PRJNA1247234_P_NODE_12065_length_318_cov_0.938776_g11909_i0	PRJNA1247234	12065	318	0.938776	2.98530768	Nodularia spumigena	70799	Bacteria	Bacteria	189	5.6499999999999985e-56	NR	WP_323245180.1	70799	g11909	i0	86.7	1.9811320754717	105	14	99.1	0	317	3	143	247	WP_323245180.1 30S ribosomal protein S1 [Nodularia spumigena]	diamond	630	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
6154369	6154369	PRJNA1247234_P_NODE_13805_length_300_cov_2.035242_g13649_i0	PRJNA1247234	13805	300	2.035242	6.105726	Microcystis	1125	Bacteria	Bacteria	555	1.7399999999999995e-153	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g13649	i0	100	41.9166666666667	300	0	100	0	1	300	3442390	3442091	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	12575	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
6729109	6729109	PRJNA1247234_P_NODE_14046_length_298_cov_1.386667_g13890_i0	PRJNA1247234	14046	298	1.386667	4.13226766	Stanieria cyanosphaera	102116	Bacteria	Bacteria	213	1.2e-50	NTclustered	gi\|428267688\|gb\|CP003653.1\|	111780	g13890	i0	82.773	1.56711409395973	238	41	80	0	60	297	1303275	1303038	Stanieria cyanosphaera PCC 7437, complete genome	blastn	467	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
7429586	7429586	PRJNA1247234_P_NODE_19366_length_257_cov_2.586957_g19210_i0	PRJNA1247234	19366	257	2.586957	6.64847949	Microcystis	1125	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g19210	i0	99.611	19.7859922178988	257	1	100	0	1	257	4149706	4149450	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	5085	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
8704606	8704606	PRJNA1247234_P_NODE_7347_length_386_cov_1.549521_g7191_i0	PRJNA1247234	7347	386	1.549521	5.98115106	Leptolyngbya	47251	Bacteria	Bacteria	658	0	NTclustered	gi\|46409895\|gb\|AY584520.1\|	212450	g7191	i0	97.409	174.295336787565	386	10	100	0	1	386	1052	1437	Leptolyngbya sp. PCC 7410 23S ribosomal RNA gene, partial sequence	blastn	67278	664	0.990963855421687	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 7410
9979752	9979752	PRJNA1247234_P_NODE_22188_length_250_cov_0.881356_g22032_i0	PRJNA1247234	22188	250	0.881356	2.20339	Microcystis	1125	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g22032	i0	100	22.704	250	0	100	0	1	250	4804890	4805139	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	5676	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
9979777	9979777	PRJNA1247234_P_NODE_24308_length_247_cov_0.896552_g24152_i0	PRJNA1247234	24308	247	0.896552	2.21448344	Chroococcidiopsis	54298	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g24152	i0	97.166	119.631578947368	247	7	100	0	1	247	4887959	4887713	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	29549	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
12530286	12530286	PRJNA1247234_P_NODE_16710_length_277_cov_1.372549_g16554_i0	PRJNA1247234	16710	277	1.372549	3.80196073	Microcystis	1125	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g16554	i0	100	65.2671480144404	277	0	100	0	1	277	4248333	4248057	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	18079	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
12530434	12530434	PRJNA1247234_P_NODE_8590_length_363_cov_1.906897_g8434_i0	PRJNA1247234	8590	363	1.906897	6.92203611	Microcystis	1125	Bacteria	Bacteria	671	0	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g8434	i0	100	86.9972451790634	363	0	100	0	1	363	2387207	2387569	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	31580	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
16928644	16928644	PRJNA1247234_P_NODE_20894_length_252_cov_0.871508_g20738_i0	PRJNA1247234	20894	252	0.871508	2.19620016	Moorena producens	1155739	Bacteria	Bacteria	91.6	4.84e-14	NTclustered	gi\|2412135964\|gb\|CP017708.2\|	1454205	g20738	i0	86.585	0.654761904761905	82	11	33	0	167	248	7483752	7483833	Moorena producens JHB chromosome, complete genome	blastn	165	91.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
20752748	20752748	PRJNA1247234_P_NODE_11297_length_326_cov_1.233202_g11141_i0	PRJNA1247234	11297	326	1.233202	4.02023852	Nodularia spumigena	70799	Bacteria	Bacteria	178	8.0299999999999995e-53	NR	WP_323245238.1	70799	g11141	i0	81.1	0.975460122699387	106	20	97.5	0	2	319	235	340	WP_323245238.1 zinc transporter ZntB [Nodularia spumigena]	diamond	318	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
21453514	21453514	PRJNA1247234_P_NODE_16977_length_275_cov_1.524752_g16821_i0	PRJNA1247234	16977	275	1.524752	4.193068	Microcystis	1125	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2041080097\|dbj\|AP024565.1\|	1126	g16821	i0	100	105.352727272727	275	0	100	0	1	275	3641438	3641712	Microcystis aeruginosa NIES-88 DNA, complete genome	blastn	28972	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
22028025	22028025	PRJNA1247234_P_NODE_13778_length_301_cov_0.899123_g13622_i0	PRJNA1247234	13778	301	0.899123	2.70636023	Nodularia spumigena	70799	Bacteria	Bacteria	134	3.68e-34	NR	WP_323245173.1	70799	g13622	i0	71.6	1.01661129568106	102	26	98.7	1	299	3	839	940	WP_323245173.1 FtsK/SpoIIIE family DNA translocase [Nodularia spumigena]	diamond	306	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
26915376	26915376	PRJNA1247234_P_NODE_23782_length_248_cov_0.891429_g23626_i0	PRJNA1247234	23782	248	0.891429	2.21074392	Nodularia spumigena	70799	Bacteria	Bacteria	153	1.46e-41	NR	WP_323245286.1	70799	g23626	i0	87.8	1.98387096774194	82	10	99.2	0	3	248	296	377	WP_323245286.1 cytochrome c biogenesis protein CcsA [Nodularia spumigena]	diamond	492	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
27136365	27136365	PRJNA1247234_P_NODE_24222_length_247_cov_0.896552_g24066_i0	PRJNA1247234	24222	247	0.896552	2.21448344	Nodularia spumigena	70799	Bacteria	Bacteria	77	2.35e-14	NR	WP_323245422.1	70799	g24066	i0	48.7	0.923076923076923	76	37	92.3	1	18	245	80	153	WP_323245422.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Nodularia spumigena]	diamond	228	77	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
27831644	27831644	PRJNA1247234_P_NODE_23164_length_249_cov_0.886364_g23008_i0	PRJNA1247234	23164	249	0.886364	2.20704636	Aliterella atlantica	1827278	Bacteria	Bacteria	151	1.23e-42	NR	WP_045055554.1	1827278	g23008	i0	100	0.963855421686747	80	0	96.4	0	241	2	1	80	WP_045055554.1 ABC transporter permease [Aliterella atlantica]	diamond	240	151	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28747353	28747353	PRJNA1247234_P_NODE_14207_length_297_cov_1.044643_g14051_i0	PRJNA1247234	14207	297	1.044643	3.10258971	Hyella patelloides	1982969	Bacteria	Bacteria	89	1.49e-19	NR	WP_144870175.1	1982969	g14051	i0	59.6	0.575757575757576	57	23	57.6	0	175	5	1	57	WP_144870175.1 class I SAM-dependent DNA methyltransferase [Hyella patelloides]	diamond	171	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Hyella	Hyella patelloides
30028638	30028638	PRJNA1247234_P_NODE_23591_length_248_cov_0.891429_g23435_i0	PRJNA1247234	23591	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	134	2.78e-34	NR	MFM6173072.1	289435	g23435	i0	77.8	14.6491935483871	81	18	98	0	247	5	330	410	MFM6173072.1 DNA-directed RNA polymerase subunit beta' [Sphaerospermopsis kisseleviana]	diamond	3633	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis kisseleviana
30041954	30041954	PRJNA1247234_P_NODE_23611_length_248_cov_0.891429_g23455_i0	PRJNA1247234	23611	248	0.891429	2.21074392	Nodularia spumigena	70799	Bacteria	Bacteria	150	6.049999999999999e-45	NR	WP_323245290.1	70799	g23455	i0	89	0.991935483870968	82	9	99.2	0	248	3	29	110	WP_323245290.1 Minf_1886 family protein [Nodularia spumigena]	diamond	246	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
31514049	31514049	PRJNA1247234_P_NODE_23056_length_249_cov_0.886364_g22900_i0	PRJNA1247234	23056	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	122	5.33e-30	NR	WP_323244861.1	70799	g22900	i0	68.7	3	83	26	100	0	1	249	208	290	WP_323244861.1 penicillin-binding transpeptidase domain-containing protein [Nodularia spumigena]	diamond	747	123	0.991869918699187	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena

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