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

23 rows where bioproject = "PRJNA917598", 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
895517	895517	PRJNA917598_P_NODE_24661_length_465_cov_3.000000_g23718_i0	PRJNA917598	24661	465	3	13.95	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	135	4.36e-27	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g23718	i0	79.512	1.35913978494624	205	31	44	9	67	269	2366807	2367002	Leptolyngbya sp. 7M chromosome	blastn	632	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
895982	895982	PRJNA917598_P_NODE_42001_length_354_cov_1.854093_g41057_i0	PRJNA917598	42001	354	1.854093	6.56348922	Limnospira platensis	118562	Bacteria	Bacteria	412	1.3299999999999995e-110	NTclustered	gi\|83777317\|gb\|DQ120927.1\|	357682	g41057	i0	88.922	0.943502824858757	334	37	94	0	21	354	507	174	Arthrospira platensis Ap-s chemotaxis signal transduction protein gene, partial cds	blastn	334	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
896199	896199	PRJNA917598_P_NODE_50481_length_322_cov_2.277108_g49537_i0	PRJNA917598	50481	322	2.277108	7.33228776	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	235	2.8e-57	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g49537	i0	80.363	1.62422360248447	331	48	100	13	1	322	125729	126051	Leptolyngbya sp. 7M chromosome	blastn	523	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
3446479	3446479	PRJNA917598_P_NODE_25723_length_456_cov_1.245431_g24779_i0	PRJNA917598	25723	456	1.245431	5.67916536	Oculatella lusitanica	2928764	Bacteria	Bacteria	804	0	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g24779	i0	98.465	126.767543859649	456	7	100	0	1	456	3298	2843	Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57806	804	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
5999794	5999794	PRJNA917598_P_NODE_65085_length_282_cov_0.784689_g64141_i0	PRJNA917598	65085	282	0.784689	2.21282298	Synechococcus sp. PCC 7502	1173263	Bacteria	Bacteria	244	4e-60	NTclustered	gi\|427993480\|gb\|CP003594.1\|	1173263	g64141	i0	82.686	174.152482269504	283	41	99	6	2	282	1848307	1848583	Synechococcus sp. PCC 7502, complete genome	blastn	49111	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PCC 7502
7273844	7273844	PRJNA917598_P_NODE_26806_length_446_cov_1.010724_g25862_i0	PRJNA917598	26806	446	1.010724	4.50782904	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	597	4.4199999999999985e-166	NTclustered	gi\|225696180\|gb\|FJ805847.1\|	259957	g25862	i0	92.019	99.8520179372197	426	32	96	1	1	426	2461	2884	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	44534	597	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11098715	11098715	PRJNA917598_P_NODE_10289_length_743_cov_5.497015_g9396_i0	PRJNA917598	10289	743	5.497015	40.84282145	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	499	2.21e-136	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g9396	i0	80.261	216.555854643338	689	114	92	20	1	680	3076	3751	Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence	blastn	160901	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
12374453	12374453	PRJNA917598_P_NODE_13930_length_632_cov_2.171735_g12998_i0	PRJNA917598	13930	632	2.171735	13.7253652	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	597	6.429999999999999e-166	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g12998	i0	84.345	140.346518987342	626	80	98	17	4	623	3159	3772	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	88699	597	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
14923809	14923809	PRJNA917598_P_NODE_36812_length_378_cov_1.996721_g35868_i0	PRJNA917598	36812	378	1.996721	7.54760538	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	514	3.82e-141	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g35868	i0	92.758	171.94708994709	359	20	95	6	21	378	2151838	2151485	Leptolyngbya sp. 7M chromosome	blastn	64996	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
17475100	17475100	PRJNA917598_P_NODE_7774_length_863_cov_1.200000_g6956_i0	PRJNA917598	7774	863	1.2	10.356	Oculatella lusitanica	2928764	Bacteria	Bacteria	1493	0	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g6956	i0	97.914	214.173812282735	863	16	99	1	1	861	2904	2042	Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	184832	1493	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
20022639	20022639	PRJNA917598_P_NODE_39636_length_365_cov_1.003425_g38692_i0	PRJNA917598	39636	365	1.003425	3.66250125	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	298	4.03e-76	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g38692	i0	82.065	438.098630136986	368	49	100	13	1	365	3650	3297	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	159906	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
23848284	23848284	PRJNA917598_P_NODE_41099_length_358_cov_1.603509_g40155_i0	PRJNA917598	41099	358	1.603509	5.74056222	uncultured Microcoleus sp.	259945	Bacteria	Bacteria	579	1.2599999999999999e-160	NTclustered	gi\|430000732\|gb\|JX877658.1\|	259945	g40155	i0	95.81	106.717877094972	358	15	100	0	1	358	40	397	Uncultured Microcoleus sp. clone HP02 16S ribosomal RNA gene, partial sequence	blastn	38205	579	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	uncultured Microcoleus sp.
27720124	27720124	PRJNA917598_P_NODE_82164_length_250_cov_0.870056_g81220_i0	PRJNA917598	82164	250	0.870056	2.17514	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	114	3.61e-27	NR	HEY9760341.1	3088181	g81220	i0	69.7	0.912	76	22	90	1	226	2	1	76	HEY9760341.1 response regulator [Oculatellaceae cyanobacterium]	diamond	228	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28066905	28066905	PRJNA917598_P_NODE_52665_length_315_cov_1.272727_g51721_i0	PRJNA917598	52665	315	1.272727	4.00909005	Arthrospira platensis Ap-s	118562	Bacteria	Bacteria	202	3.98e-63	NR	ABC46995.1	357682	g51721	i0	98.1	0.990476190476191	104	2	99	0	3	314	70	173	ABC46995.1 chemotaxis signal transduction protein, partial [Arthrospira platensis Ap-s]	diamond	312	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
29235230	29235230	PRJNA917598_P_NODE_14789_length_613_cov_1.527778_g13855_i0	PRJNA917598	14789	613	1.527778	9.36527914	Anabaena sp. WA113	1710889	Bacteria	Bacteria	104	3.11e-25	NR	OBQ15776.1	1710889	g13855	i0	57.1	0.411092985318108	84	36	41.1	0	353	102	10	93	OBQ15776.1 MAG: hypothetical protein AN488_20530 [Anabaena sp. WA113]	diamond	252	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. WA113
29961414	29961414	PRJNA917598_P_NODE_42691_length_351_cov_2.582734_g41747_i0	PRJNA917598	42691	351	2.582734	9.06539634	Trichormus sp. M33_DOE_039	2747804	Bacteria	Bacteria	118	2.1000000000000002e-30	NR	HIK06411.1	2747804	g41747	i0	63.3	3.97435897435897	90	31	75.2	1	3	266	144	233	HIK06411.1 CHRD domain-containing protein [Trichormus sp. M33_DOE_039]	diamond	1395	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus sp. M33_DOE_039
30214047	30214047	PRJNA917598_P_NODE_26312_length_450_cov_1.413793_g25368_i0	PRJNA917598	26312	450	1.413793	6.3620685	Limnothrix redekei	132606	Bacteria	Bacteria	186	1.7199999999999998e-54	NR	WP_393011443.1	132606	g25368	i0	83.7	2.76	104	17	69.3	0	449	138	280	383	WP_393011443.1 N-acetyl sugar amidotransferase [Limnothrix redekei]	diamond	1242	186	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix redekei
31098698	31098698	PRJNA917598_P_NODE_14675_length_615_cov_3.121771_g13741_i0	PRJNA917598	14675	615	3.121771	19.19889165	Synechococcus elongatus UTEX 2973	1350461	Bacteria	Bacteria	70.9	1.63e-12	NR	AJD58901.1	1350461	g13741	i0	52.4	0.307317073170732	63	30	30.7	0	343	155	1	63	AJD58901.1 hypothetical protein M744_10830 [Synechococcus elongatus UTEX 2973]	diamond	189	70.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
31383594	31383594	PRJNA917598_P_NODE_92736_length_243_cov_0.905882_g91792_i0	PRJNA917598	92736	243	0.905882	2.20129326	Microcoleus sp. SM1_3_4	2720457	Bacteria	Bacteria	54.7	4.63e-7	NR	NJL66832.1	2720457	g91792	i0	43.5	2.2962962962963	62	31	76.5	1	1	186	18	75	NJL66832.1 hypothetical protein [Microcoleus sp. SM1_3_4]	diamond	558	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. SM1_3_4
31667994	31667994	PRJNA917598_P_NODE_24677_length_465_cov_2.198980_g23734_i0	PRJNA917598	24677	465	2.19898	10.225257	Planktothrix mougeotii	54306	Bacteria	Bacteria	96.3	2.5300000000000003e-21	NR	WP_193869616.1	54306	g23734	i0	47.4	2.4258064516129	95	50	61.3	0	172	456	1	95	WP_193869616.1 macro domain-containing protein [Planktothrix mougeotii]	diamond	1128	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
31770257	31770257	PRJNA917598_P_NODE_88317_length_246_cov_0.890173_g87373_i0	PRJNA917598	88317	246	0.890173	2.18982558	Cyanophyceae	3028117	Bacteria	Bacteria	100	1.53e-22	NR	WP_017719947.1	1173028	g87373	i0	90.4	1.26829268292683	52	5	63.4	0	246	91	398	449	WP_017719947.1 TldD/PmbA family protein [Oscillatoria sp. PCC 10802]	diamond	312	101	0.99009900990099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
32711385	32711385	PRJNA917598_P_NODE_37680_length_374_cov_1.279070_g36736_i0	PRJNA917598	37680	374	1.27907	4.7837218	Rivularia sp. MS3	3012223	Bacteria	Bacteria	46.6	0.00683	NR	MBV6621788.1	3012223	g36736	i0	39.6	1.0668449197861	48	29	38.5	0	267	124	456	503	MBV6621788.1 cellulase family glycosylhydrolase [Rivularia sp. MS3]	diamond	399	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. MS3
32907601	32907601	PRJNA917598_P_NODE_76220_length_258_cov_1.670270_g75276_i0	PRJNA917598	76220	258	1.67027	4.3092966	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	145	5.9099999999999996e-40	NR	WP_115016674.1	368503	g75276	i0	78.6	8.81395348837209	84	18	97.7	0	5	256	7	90	WP_115016674.1 GDP-mannose 4,6-dehydratase [Synechococcus sp. UW140]	diamond	2274	146	0.993150684931507	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UW140

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