metadata: contig_metadata: 18 rows where bioproject = "PRJNA640143", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

18 rows where bioproject = "PRJNA640143", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
3160915	3160915	PRJNA640143_S_NODE_2583_length_486_cov_37.138085_g2402_i0	PRJNA640143	2583	486	37.138085	180.4910931	Aliterella chasmolithica	2739056	Bacteria	Bacteria	627	6.189999999999998e-175	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2402	i0	91.63	115.843621399177	454	36	93	2	34	486	1965	2417	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	56300	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
3707113	3707113	PRJNA640143_S_NODE_28923_length_162_cov_1.328000_g28713_i0	PRJNA640143	28923	162	1.328	2.15136	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	237	3.47e-58	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g28713	i0	93.168	134.722222222222	161	11	99	0	1	161	5577607	5577447	Anabaena sp. YBS01 chromosome, complete genome	blastn	21825	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
5713778	5713778	PRJNA640143_S_NODE_5605_length_350_cov_3.926518_g5395_i0	PRJNA640143	5605	350	3.926518	13.742813	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	503	7.59e-138	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g5395	i0	92.635	150.485714285714	353	20	99	3	1	349	2033	2383	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	52670	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9538351	9538351	PRJNA640143_S_NODE_18728_length_202_cov_11.563636_g18518_i0	PRJNA640143	18728	202	11.563636	23.35854472	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	292	9.52e-75	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g18518	i0	98.204	2.21287128712871	167	3	83	0	1	167	5032591	5032425	Calothrix sp. PCC 7716 DNA, complete genome	blastn	447	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
16458148	16458148	PRJNA640143_S_NODE_17973_length_206_cov_17.147929_g17763_i0	PRJNA640143	17973	206	17.147929	35.32473374	Bacteria	2	Bacteria	Bacteria	307	3.4800000000000004e-79	NTclustered	gi\|315190017\|gb\|HQ595208.1\|	1211	g17763	i0	100	117.776699029126	166	0	81	0	41	206	1	166	Uncultured cyanobacterium clone IC3040 16S ribosomal RNA gene, partial sequence	blastn	24262	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21012368	21012368	PRJNA640143_S_NODE_25397_length_175_cov_2.224638_g25187_i0	PRJNA640143	25397	175	2.224638	3.8931165	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	172	1.08e-38	NTclustered	gi\|2112847628\|emb\|OU815587.1\|	693223	g25187	i0	84.483	18.5142857142857	174	27	99	0	1	174	345	172	Gloeocapsopsis crepidinum cpcB gene for C-phycocyanin beta chain, strain CCAP 1425/1	blastn	3240	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
22832763	22832763	PRJNA640143_S_NODE_11658_length_253_cov_11.893519_g11448_i0	PRJNA640143	11658	253	11.893519	30.09060307	Drouetiella	2303513	Bacteria	Bacteria	351	2.02e-92	NTclustered	gi\|2312649307\|gb\|OP577847.1\|	2983374	g11448	i0	96.279	144.928853754941	215	6	84	2	6	218	2121	1907	Drouetiella lurida ACKU666 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36667	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella lurida
22832840	22832840	PRJNA640143_S_NODE_2198_length_519_cov_4.788382_g2042_i0	PRJNA640143	2198	519	4.788382	24.85170258	Microcystis	1125	Bacteria	Bacteria	553	1.1399999999999995e-152	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g2042	i0	86.747	148.400770712909	498	64	96	2	1	498	4186376	4186871	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	77020	553	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
23562787	23562787	PRJNA640143_S_NODE_4959_length_369_cov_3.701807_g4749_i0	PRJNA640143	4959	369	3.701807	13.65966783	Drouetiella epilithica	3059494	Bacteria	Bacteria	555	2.1899999999999999e-153	NTclustered	gi\|2312649311\|gb\|OP577851.1\|	2983373	g4749	i0	96.429	119.457994579946	336	12	91	0	1	336	2438	2103	Drouetiella epilithica ACKU670 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44080	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella epilithica
23562805	23562805	PRJNA640143_S_NODE_5559_length_351_cov_106.149682_g5349_i0	PRJNA640143	5559	351	106.149682	372.58538382	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	388	2.23e-103	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g5349	i0	92.91	171.680911680912	268	17	76	1	36	301	1234	1501	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	60260	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
25381760	25381760	PRJNA640143_S_NODE_19460_length_199_cov_1.444444_g19250_i0	PRJNA640143	19460	199	1.444444	2.87444356	Nostoc	1177	Bacteria	Bacteria	62.1	2.87e-5	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g19250	i0	88.679	0.683417085427136	53	3	25	2	1	50	1081594	1081646	Nostoc sp. NIES-3756 DNA, complete genome	blastn	136	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
27143807	27143807	PRJNA640143_S_NODE_19042_length_201_cov_2.018293_g18832_i0	PRJNA640143	19042	201	2.018293	4.05676893	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	49.7	7.56e-5	NR	WP_250124880.1	155894	g18832	i0	41.8	0.82089552238806	55	32	82.1	0	35	199	34	88	WP_250124880.1 restriction endonuclease subunit S [Chroococcidiopsis sp. CCMEE 29]	diamond	165	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
27933865	27933865	PRJNA640143_S_NODE_5165_length_362_cov_4.067692_g4955_i0	PRJNA640143	5165	362	4.067692	14.72504504	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	72	7.16e-13	NR	WP_009632138.1	927677	g4955	i0	94.7	0.314917127071823	38	2	31.5	0	116	3	1	38	WP_009632138.1 phycocyanin subunit beta [Synechocystis sp. PCC 7509]	diamond	114	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28344273	28344273	PRJNA640143_S_NODE_23246_length_183_cov_1.335616_g23036_i0	PRJNA640143	23246	183	1.335616	2.44417728	Xenococcaceae cyanobacterium MO_188.B32	3036640	Bacteria	Bacteria	43.5	0.00211	NR	MDJ0687266.1	3036640	g23036	i0	67.7	0.508196721311475	31	10	50.8	0	3	95	65	95	MDJ0687266.1 RNA-binding protein [Xenococcaceae cyanobacterium MO_188.B32]	diamond	93	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Xenococcaceae		Xenococcaceae cyanobacterium MO_188.B32
29575475	29575475	PRJNA640143_S_NODE_18250_length_205_cov_2.321429_g18040_i0	PRJNA640143	18250	205	2.321429	4.75892945	Nostocaceae	1162	Bacteria	Bacteria	67.8	3.33e-12	NR	WP_126987027.1	1162	g18040	i0	52.3	0.951219512195122	65	30	95.1	1	203	9	70	133	WP_126987027.1 MULTISPECIES: hypothetical protein [Nostocaceae]	diamond	195	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
29967149	29967149	PRJNA640143_S_NODE_14651_length_227_cov_13.878947_g14441_i0	PRJNA640143	14651	227	13.878947	31.50520969	Bacteria	2	Bacteria	Bacteria	43.5	0.0166	NR	KPQ31753.1	1666911	g14441	i0	42	2.04845814977974	50	26	66.1	2	198	49	537	583	KPQ31753.1 MAG: protein of unknown function (DUF3883) [Phormidesmis priestleyi Ana]	diamond	465	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Phormidesmis	Phormidesmis priestleyi
31123274	31123274	PRJNA640143_S_NODE_12275_length_247_cov_252.195238_g12065_i0	PRJNA640143	12275	247	252.195238	622.92223786	Pleurocapsa sp. CCALA 161	2107688	Bacteria	Bacteria	136	1.82e-37	NR	WP_106236211.1	2107688	g12065	i0	98.6	0.838056680161943	69	1	83.8	0	207	1	72	140	WP_106236211.1 SDR family oxidoreductase [Pleurocapsa sp. CCALA 161]	diamond	207	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. CCALA 161
32515784	32515784	PRJNA640143_S_NODE_9319_length_280_cov_6.316872_g9109_i0	PRJNA640143	9319	280	6.316872	17.6872416	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	147	1.15e-41	NR	WP_106369903.1	2107693	g9109	i0	98.6	0.792857142857143	74	1	79.3	0	34	255	46	119	WP_106369903.1 hypothetical protein [Chlorogloea sp. CCALA 695]	diamond	222	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695

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